private void DepartForm_Load(object sender, EventArgs e) { using (KanbanModal db = new KanbanModal()) { // MessageBox.Show(db.Database.Connection.ConnectionString); comboBox1.DataSource = db.LKM_Depart.ToList <LKM_Depart>(); comboBox1.DisplayMember = "DepartName"; comboBox1.ValueMember = "DepartName"; comboBox1.SelectedText = loginForm.label4.Text; comboBox1.SelectedValue = loginForm.label4.Text; } }
private void GetStockData(bool isFront) { try { using (KanbanModal db = new KanbanModal()) { db.Database.Log = RecordDBLog; IQueryable <KbanBanInv> result; if (!isFront) { result = from lkexek in db.lkm_exec_kanban_entry join lkanban in db.lkm_kanban on lkexek.fbasic_billno equals lkanban.fbillno join master in db.lkm_Materials on lkanban.fitemid equals(int) master.fInterID join lke in db.LKM_MCCItemEntry on master.fItemID equals lke.fItemID join lmentry in db.LKM_MCCPTEntry on lke.fConfigID equals lmentry.fConfigID join lc in db.lkm_CommonBill on lmentry.fProTecID equals lc.fInterID join inv in db.lkm_blank_inventory on new { ID1 = lkanban.fitemid, ID2 = (int?)lmentry.fProTecID } equals new { ID1 = inv.fitemid, ID2 = inv.fproid } into invleft from leftinv in invleft.DefaultIfEmpty() where lkexek.fbillno == kanbanNo.Text && lmentry.fProTecID != 56 && lmentry.fProTecID == 101 select new KbanBanInv { ID = master.fItemCode + lmentry.fConfigID + lmentry.fProTecID, Fbillno = lkexek.fbillno, FItemCode = master.fItemCode, FItemName = master.fItemName, FitemInterID = lkanban.fitemid, FModel = master.fModel, FProTecID = lmentry.fInterID, Bustype = 0, FName = lc.fName, FConfigID = lke.fConfigID, Fcount = leftinv == null ? null : leftinv.fcount, FDCount = leftinv == null ? null : leftinv.fcount }; } else { result = from lkexek in db.lkm_exec_kanban_entry join lkanban in db.lkm_kanban on lkexek.fbasic_billno equals lkanban.fbillno join master in db.lkm_Materials on lkanban.fitemid equals(int) master.fInterID join lke in db.LKM_MCCItemEntry on master.fItemID equals lke.fItemID join lmentry in db.LKM_MCCPTEntry on lke.fConfigID equals lmentry.fConfigID join lc in db.lkm_CommonBill on lmentry.fProTecID equals lc.fInterID join inv in db.lkm_blank_inventory on new { ID1 = lkanban.fitemid, ID2 = (int?)lmentry.fProTecID } equals new { ID1 = inv.fitemid, ID2 = inv.fproid } into invleft from leftinv in invleft.DefaultIfEmpty() where lkexek.fbillno == kanbanNo.Text && lmentry.fProTecID != 56 && lmentry.fProTecID != 101 select new KbanBanInv { ID = master.fItemCode + lmentry.fConfigID + lmentry.fProTecID, Fbillno = lkexek.fbillno, FItemCode = master.fItemCode, FItemName = master.fItemName, FitemInterID = lkanban.fitemid, FModel = master.fModel, FProTecID = lmentry.fInterID, Bustype = 0, FName = lc.fName, FConfigID = lke.fConfigID, Fcount = leftinv == null ? null : leftinv.fcount, FDCount = leftinv == null ? null : leftinv.fcount }; } var pdSource = result.ToList(); dataGridView1.DataSource = pdSource; using (MemoryStream ms = new MemoryStream()) { BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(ms, pdSource); ms.Seek(0, SeekOrigin.Begin); kanbanInvsOrigin = formatter.Deserialize(ms) as List <KbanBanInv>; } errMessage.Text = "查找成功"; } } catch (Exception ex) { // MessageBox.Show(ex.Message); errMessage.Text = "发生错误:" + ex.Message; throw; } }