예제 #1
0
        static void Main(string[] args)
        {
            EWRepository rep = EWRepository.Instance;

            rep.AddCategory2(1, "");

            Device d0 = null;

            using (var db = new EWContext(EWContext.connStr))
            {
                d0 = db.Devices.First(x => x.NO == "111");
                Console.WriteLine("所有设备:");
                foreach (var d in db.Devices.Include(nameof(Category2)))
                {
                    Console.WriteLine($"{d.NO}\t{d.Category2.Name}\t{d.Status}");
                }
            }


            bool success = false;

            if (d0.Status == DeviceStatus.Instore)
            {
                success = rep.BorrowDevice("111", "ly", "sub");
            }
            else if (d0.Status == DeviceStatus.Lent)
            {
                success = rep.ReturnDevice("111", "ly", "sub");
            }

            if (success)
            {
                using (var db = new EWContext(EWContext.connStr))
                {
                    Console.WriteLine("所有设备:");
                    foreach (var d in db.Devices.Include(nameof(Category2)))
                    {
                        Console.WriteLine($"{d.NO}\t{d.Category2.Name}\t{d.Status}");
                    }
                }
            }



            //Console.WriteLine("所有员工:");
            //foreach (var em in db.Employees)
            //{
            //    Console.WriteLine(em.Name);
            //}

            Console.WriteLine("Press any key to exit...");
            Console.ReadKey();
        }
예제 #2
0
        public OrderForm()
        {
            //Header =
            //    new OrderFormHeader(
            //        "株式会社ほげほげ",
            //        new DateTime(2017, 01, 15),
            //        Items.Sum(item => item.TotalPrice)
            //    );

            using (var db = new EWContext(EWContext.connStr))
            {
                this.Items = db.Devices.Include(nameof(Category2)).ToArray();
                //Console.WriteLine("所有设备:");

                //foreach (var d in db.Devices.Include(nameof(Category2)))
                //{
                //    Console.WriteLine($"{d.NO}\t{d.Category2.Name}\t{d.Status}");
                //}
            }
        }