コード例 #1
0
        private void frmPurchaseOrder_Load(object sender, EventArgs e)
        {
            db        = new Session4Entities();
            dataTable = new List <Dictionary <string, string> >();
            data      = this.Tag as Dictionary <string, string>;

            cbSuppliers.ValueMember   = "ID";
            cbSuppliers.DisplayMember = "Name";
            cbSuppliers.DataSource    = (from x in db.Suppliers select x).ToList <Supplier>();
            if (data["Type"] == "Edit")
            {
                cbSuppliers.SelectedValue = int.Parse(data["SupplierID"]);
            }
            //if (data["Type"] != "Edit") cbSuppliers.SelectedValue = int.Parse(data["SupplierID"]);

            cbWarehouse.ValueMember   = "ID";
            cbWarehouse.DisplayMember = "Name";
            cbWarehouse.DataSource    = (from x in db.Warehouses select x).ToList <Warehouse>();
            //if (data["Type"] != "Edit") cbWarehouse.SelectedValue = int.Parse(data["WarehouseID"]);
            if (data["Type"] == "Edit")
            {
                cbSuppliers.SelectedValue = int.Parse(data["WarehouseID"]);
            }

            if (data["Type"] == "Edit")
            {
                dpkDate.Value = DateTime.Parse(data["Date"]);
            }

            cbPartname.ValueMember   = "ID";
            cbPartname.DisplayMember = "Name";
            cbPartname.DataSource    = (from x in db.Parts select x).ToList <Part>();


            LoadDataTable();

            Part part = cbPartname.SelectedItem as Part;

            if (part.BatchNumberHasRequired == false)
            {
                txtBatchNumber.Enabled = false;
                txtBatchNumber.Text    = "";
            }
            else
            {
                txtBatchNumber.Enabled = true;
            }
        }
コード例 #2
0
        private void frmInventoryManagement_Load(object sender, EventArgs e)
        {
            //init db
            db = new Session4Entities();

            //var order = new Order
            //{
            //    ID = 20,
            //    Date = DateTime.Now,
            //    SupplierID = 1,
            //    TransactionTypeID = 1,
            //    SourceWarehouseID = 1
            //};

            //var orderItem1 = new OrderItem
            //{
            //    ID = 43,
            //    //OrderID = 20,
            //    Amount = 100,
            //    BatchNumber = "123",
            //    PartID = 3
            //};
            //var orderItem2 = new OrderItem
            //{
            //    ID = 453,
            //    //OrderID = 20,
            //    Amount = 100,
            //    BatchNumber = "123",
            //    PartID = 3
            //};

            //order.OrderItems.Add(orderItem1);
            //order.OrderItems.Add(orderItem2);


            //db.Orders.Add(order);
            //db.SaveChanges();

            //var o = db.Orders.FirstOrDefault();

            //init dgvCurrentInventory
            dataTable = new List <Dictionary <string, string> >();
            LoadDataTable();
        }
コード例 #3
0
 public AirlineManager()
 {
     _airlineRepository = new AirlineRepository();
     _session4DbContext = new Session4Entities();
 }
コード例 #4
0
 public AirlineRepository()
 {
     session4 = new Session4Entities();
 }