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;
}
}
