michgan software studio

13명이 돈을 모았더니 63만원이 되었다.

        public static void Main()
        {
            int total = 63;
            int people = 13;

            for(int a=0; a <= (total/3); ++a)
            {
                for(int b=0; b <= (total/5); ++b)
                {
                    for(int c=0; c <= (total/10); ++c)
                    {
                        int s = a*3 + b*5 + c*10;
                        if (s == total && (a+b+c) == people)
                        {
                            Console.WriteLine("3={0}, 5={1}, 10={2}", a, b, c);
                        }
                    }
                }
            }
        }

        public static void Main()
        {
            Recurse(new int[coins.Length], 0, 63);
        }

        static int[] coins = new int[] { 3, 5, 7, 10 };
        static int people = 13;
        static void Recurse(int[] key, int depth, int remain)
        {
            int coin = coins[depth];
            int maxLoop = remain / coin;
            int[] newKey = (int[])key.Clone();
            for (int i = 0; i <= maxLoop; ++i)
            {
                int newRemain = remain - i * coin;
                newKey[depth] = i;

                if (depth + 1 == coins.Length)
                {
                    var n = newKey.Aggregate(0, delegate(int c, int r)
                    {
                        return c + r;
                    });
                    if (n == people && newRemain == 0)
                    {
                        StringBuilder sb = new StringBuilder();
                        for (int j = 0; j < coins.Length; ++j)
                        {
                            sb.AppendFormat("{0}={1} ", coins[j], newKey[j]);
                        }
                        Console.WriteLine(sb.ToString());
                    }
                }
                else
                {
                    Recurse(newKey, depth + 1, newRemain);
                }
            }
        }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SQLite;
using System.IO;

namespace sqlitecs
{
    class Program
    {
        static void Main(string[] args)
        {
            //  Creating a database.
            SQLiteConnection.CreateFile("test.db");

            //  Open the database.
            using (var connection = new SQLiteConnection("Data Source=test.db"))
            {
                connection.Open();                 try
                {
                    //  Create table.
                    using (SQLiteCommand command = connection.CreateCommand())
                    {
                        command.CommandText = "CREATE TABLE File (Name text, Size bigint, Modified datetime);";
                        command.ExecuteNonQuery();
                    }

                    //  Insert datas.
                    using (SQLiteCommand command = connection.CreateCommand())
                    {
                        command.CommandText = "INSERT INTO File VALUES (?,?,?);";
                        SQLiteParameter p1 = new SQLiteParameter();
                        SQLiteParameter p2 = new SQLiteParameter();
                        SQLiteParameter p3 = new SQLiteParameter();
                        command.Parameters.Add(p1);
                        command.Parameters.Add(p2);
                        command.Parameters.Add(p3);

                        foreach (var fi in (new DirectoryInfo("c:\\Windows")).GetFiles())
                        {
                            p1.Value = fi.Name;
                            p2.Value = fi.Length;
                            p3.Value = fi.LastWriteTimeUtc;
                            command.ExecuteNonQuery();
                        }
                    }

                    //  Select files by its size between 1k and 1M
                    using (SQLiteCommand command = connection.CreateCommand())
                    {
                        command.CommandText = "SELECT * from File where Size >= 1024 and Size <= 1048576 order by Size;";
                        using (SQLiteDataReader reader = command.ExecuteReader())
                        {
                            while(reader.HasRows && reader.Read())
                            {
                                Console.WriteLine("{0}, {1}, {2}", reader.GetString(0), reader.GetInt64(1), reader.GetDateTime(2));
                            }
                        }
                    }
                }
                finally
                {
                    connection.Close();
                }
            }
        }
    }
}