public void Save(DM_ITEMSPLIT itemsplit, DM_ITEM itemA, DM_ITEM itemB, DM_ITEM itemC, DM_ITEM itemD) { try { DbEntry.UsingTransaction(delegate { if (itemsplit.ItemCodeA == "" && itemsplit.Id > 0) { this.ExecuteDelete(itemsplit); } else { this.ExecuteUpdate(itemsplit); if (itemA != null) { DbEntry.Save(itemA); //itemA.Save(); } if (itemB != null) { DbEntry.Save(itemB); } if (itemC != null) { DbEntry.Save(itemC); } if (itemD != null) { DbEntry.Save(itemD); } } }); } catch (Exception e) { throw e; } }
public void InStorage() { DataRow drow = this.GetCurSelect(); if (drow == null) { return; } SM_SHOPINEDIT oFrm = new SM_SHOPINEDIT(); G.BLL.ERP.BaseData.DM_ITEMLogic itemlogic = new G.BLL.ERP.BaseData.DM_ITEMLogic(); DM_ITEM itemobj = itemlogic.ExecuteSelect(CK.K["ITEMCODE"].Eq(drow["ITEMCODE"]), OrderBy.Parse("ITEMCODE"), 0, 0)[0]; SM_SHOPIN shopin = new SM_SHOPIN(); shopin.ITEMCODE = G.Core.GConvert.ToString(drow["ITEMCODE"]); shopin.ITEMNAME = G.Core.GConvert.ToString(drow["ITEMNAME"]); shopin.INVUNIT = itemobj.InvUnit; shopin.ATTRIBUTEA = G.Core.GConvert.ToString(drow["ATTRIBUTEA"]); shopin.ATTRIBUTEB = G.Core.GConvert.ToString(drow["ATTRIBUTEB"]); shopin.ATTRIBUTEC = G.Core.GConvert.ToInt(drow["ATTRIBUTEC"]); shopin.INQTY = G.Core.GConvert.ToInt(drow["UNFINQTY"]); shopin.SHOPORDERID = G.Core.GConvert.ToString(drow["SHOPORDID"]); shopin.STATUS = "N"; shopin.STATUSNAME = "新增"; oFrm.SetData(shopin); oFrm.ShowDialog(); this.RefreshData(); }
public override bool SaveBefore(ref SM_SHOPIN obj) { DM_ITEMLogic itemlogic = new DM_ITEMLogic(); DM_ITEM item = itemlogic.GetItemByCode(obj.ITEMCODE); if (item != null) { obj.ISATTRIBUTEA = G.Core.GConvert.ToBool(item.IsAttributeA); obj.ISATTRIBUTEB = G.Core.GConvert.ToBool(item.IsAttributeB); obj.ISATTRIBUTEC = G.Core.GConvert.ToBool(item.IsAttributeC); } if (obj.ISATTRIBUTEA == false) { obj.ATTRIBUTEA = ""; } if (obj.ISATTRIBUTEB == false) { obj.ATTRIBUTEB = ""; obj.ATTRIBUTEBNAME = ""; } if (obj.ISATTRIBUTEC == false) { obj.ATTRIBUTEC = 0; } return(true); }
private void ValidShopInData(SM_SHOPIN obj) { DM_ITEMLogic itemlogic = new DM_ITEMLogic(); DM_ITEM item = itemlogic.GetItemByCode(obj.ITEMCODE); if (G.Core.GConvert.ToString(obj.ITEMCODE) == "") { throw new Exception("没有物品,不能保存!"); } if (G.Core.GConvert.ToBool(item.IsAttributeA) == true && G.Core.GConvert.ToString(obj.ATTRIBUTEA) == "") { throw new Exception("没有色号,不能保存!"); } if (G.Core.GConvert.ToString(obj.WRHSCODE) == "") { throw new Exception("没有仓库,不能保存!"); } if (G.Core.GConvert.ToString(obj.LOCCODE) == "") { throw new Exception("没有库位,不能保存!"); } if (G.Core.GConvert.ToDecimal(obj.INQTY) == 0) { throw new Exception("数量为0,不能保存!"); } }
private void PrepurOrder() { try { SM_BOMTEMP temp = new SM_BOMTEMP(); G.BLL.ERP.BaseData.DM_ITEMLogic itemlogic = new G.BLL.ERP.BaseData.DM_ITEMLogic(); SM_PREPURORDER prepur = new SM_PREPURORDER(); if (tabControl1.SelectedIndex == 0) { this.Grid_CP.FinishEditing(); temp = this.Grid_CP.GetCurSelect <SM_BOMTEMP>(); } else { this.Grid_ZJ.FinishEditing(); temp = this.Grid_ZJ.GetCurSelect <SM_BOMTEMP>(); } prepur.PREPURQTY = G.Core.GConvert.ToDecimal(temp.LEFTQTY); prepur.ORDERID = temp.ORDERID; prepur.ORDLNNO = temp.ORDLNNO; prepur.APPLYUSER = G.AppInfo.GGlobal.User.USERDM; prepur.APPLYUSERNAME = G.AppInfo.GGlobal.User.USERNAME; prepur.ITEMCODE = temp.ITEMCODE; prepur.ITEMNAME = temp.ITEMNAME; prepur.PURTYPE = "1"; prepur.INVUNIT = temp.INVUNIT; prepur.BOMTEMPID = temp.Id; prepur.ATTRIBUTEA = temp.ATTRIBUTEA; prepur.ATTRIBUTEB = temp.ATTRIBUTEB; prepur.ATTRIBUTEBNAME = temp.ATTRIBUTEBNAME; prepur.ATTRIBUTEC = temp.ATTRIBUTEC; prepur.ATTRIBUTED = temp.ATTRIBUTED; prepur.REMARK = temp.MEMO; DM_ITEM itemobj = itemlogic.ExecuteSelect(CK.K["ITEMCODE"].Eq(temp.ITEMCODE), OrderBy.Parse("ITEMCODE"), 0, 0)[0]; prepur.SUPCODE = itemobj.SUPCODE; prepur.SUPPRICE = itemobj.SUPPRICE; prepur.ISATTRIBUTEA = G.Core.GConvert.ToBool(itemobj.IsAttributeA); prepur.ISATTRIBUTEB = G.Core.GConvert.ToBool(itemobj.IsAttributeB); prepur.ISATTRIBUTEC = G.Core.GConvert.ToBool(itemobj.IsAttributeC); //弹出采购申请单,数据来自选择行 Purchase.SM_PREPURORDEREDIT prepurEdit = new Purchase.SM_PREPURORDEREDIT(); prepurEdit.SetData(prepur); DialogResult drst = prepurEdit.ShowDialog(); if (drst == DialogResult.OK) { //采购数量填入BOMTEMP temp.PURQTY += temp.LEFTQTY; ((SM_BOMTEMPLogic)this.Logic).ExecuteUpdate(G.AppInfo.GGlobal.User, temp); } this.LoadGridCP(orderid, gxname); this.LoadGridShop(orderid, gxname); this.LoadGridZJ(orderid, gxname); } catch (Exception e) { MessageBox.Show(e.Message); } }
private void txt_ItemCodeB_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { var list = itemlogic.ExecuteSelect(CK.K["ITEMCODE"].Eq(txt_ItemCodeB.Text), OrderBy.Parse("ITEMCODE"), 20, 0); if (list.Count > 0) { txt_ItemDescB.Text = list[0].ItemName; itemb = list[0]; } } }
private void check_IsD_CheckedChanged(object sender, EventArgs e) { if (check_IsD.Checked) { txt_ItemCodeD.Text = GenerateCode("D", fatheritem.ItemCode); txt_ItemDescD.Text = GenerateDesc("D", fatheritem.ItemCode, fatheritem.ItemName); itemd = getitems(fatheritem, txt_ItemCodeD.Text, txt_ItemDescD.Text); } else { txt_ItemCodeD.Text = ""; txt_ItemDescD.Text = ""; itemd = null; } }
private void DROP_POID_RowSelect(object sender, Interface.Event.DataRowEvent e) { if (e.DataRow != null) { try { this.DROP_SUPCODE.Text = G.Core.GConvert.ToString(e.DataRow["SUPPNAME"]); this.DROP_SUPCODE.Value = G.Core.GConvert.ToString(e.DataRow["SUPCODE"]); string poid = G.Core.GConvert.ToString(e.DataRow["POID"]); G.BLL.ERP.Purchase.SM_PORDERLogic porderlogic = new G.BLL.ERP.Purchase.SM_PORDERLogic(); SM_PORDER pobj = porderlogic.ExecuteSelect(CK.K["POID"].Eq(poid), OrderBy.Parse("POID"), 0, 0)[0]; if (pobj != null) { //SM_SHIPVOUCHER shipv = this.editData as SM_SHIPVOUCHER; //shipv.SHIPVOUCHERDTL.Clear(); BindingList <SM_SHIPVOUCHERDTL> shipvd = this.gGrid1.DataSource as BindingList <SM_SHIPVOUCHERDTL>; shipvd.Clear(); foreach (SM_PORDERDTL r in pobj.PORDERDTL) { if (r.PREPURQTY > r.SHIFTQTY) { G.BLL.ERP.BaseData.DM_ITEMLogic itemlogic = new G.BLL.ERP.BaseData.DM_ITEMLogic(); DM_ITEM itemobj = itemlogic.ExecuteSelect(CK.K["ITEMCODE"].Eq(r.ITEMCODE), OrderBy.Parse("ITEMCODE"), 0, 0)[0]; SM_SHIPVOUCHERDTL shipd = new SM_SHIPVOUCHERDTL(); shipd.POLNNO = r.POLNNO; shipd.ITEMCODE = r.ITEMCODE; shipd.ITEMNAME = r.ITEMNAME; shipd.INVUNIT = r.INVUNIT; shipd.PREPURQTY = r.PREPURQTY; shipd.PRICE = r.PURPRICE; shipd.ATTRIBUTEA = r.ATTRIBUTEA; shipd.ATTRIBUTEB = r.ATTRIBUTEB; shipd.ATTRIBUTEBNAME = r.ATTRIBUTEBNAME; shipd.ATTRIBUTEC = r.ATTRIBUTEC; shipd.WRHSCODE = itemobj.WrhsCode; shipd.WRHSNAME = itemobj.WRHSNAME; shipd.LOCCODE = itemobj.LocCode; shipd.LOCNAME = itemobj.LOCNAME; shipd.UNFINISHQTY = r.PREPURQTY - r.SHIFTQTY; shipd.ISATTRIBUTEA = (bool)itemobj.IsAttributeA; shipd.ISATTRIBUTEB = (bool)itemobj.IsAttributeB; shipd.ISATTRIBUTEC = (bool)itemobj.IsAttributeC; shipvd.Add(shipd); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } gGrid1.Refresh(); }
private void check_IsB_CheckedChanged(object sender, EventArgs e) { if (check_IsB.Checked) { txt_ItemCodeB.Text = GenerateCode("B", fatheritem.ItemCode); txt_ItemDescB.Text = GenerateDesc("B", fatheritem.ItemCode, fatheritem.ItemName); itemb = getitems(fatheritem, txt_ItemCodeB.Text, txt_ItemDescB.Text); check_Bmould.Checked = (bool)itemb.IsAttributeB; } else { txt_ItemCodeB.Text = ""; txt_ItemDescB.Text = ""; itemb = null; } }
private void Save() { try { DateTime dt1 = DateTime.Now; editData = eadapter.GetData(); DateTime dt2 = DateTime.Now; G.BLL.ERP.BaseData.DM_ITEMLogic logic = new BLL.ERP.BaseData.DM_ITEMLogic(); logic.ExecuteUpdate(editData); DateTime dt3 = DateTime.Now; string info = string.Format("总时间{0},获取时间{1},保存时间{2}", (dt3 - dt1).TotalSeconds, (dt2 - dt1).TotalSeconds, (dt3 - dt2).TotalSeconds); G.AppInfo.GGlobal.SetInfo(info); MessageBox.Show("保存成功!"); } catch (Exception e) { MessageBox.Show(e.Message); } }
private DM_ITEM getitems(DM_ITEM item, string itemcode, string itemname) { DM_ITEM itemn = null; if (!itemcode.IsNullOrEmpty()) { itemn = itemlogic.FindObject(CK.K["ItemCode"].Eq(itemcode)); if (itemn == null) { itemn = new DM_ITEM(); } itemn.ItemCode = itemcode; itemn.ItemDesc = itemname; itemn.ItemName = itemname; itemn.ItemType = item.ItemType; itemn.ItemTypeID = item.ItemTypeID; itemn.WrhsCode = item.WrhsCode; itemn.LocCode = item.LocCode; itemn.InvUnit = "个"; itemn.Operator = G.AppInfo.GGlobal.User.USERDM; itemn.Py = G.Core.PinYin.GetCodeString(itemname); } return(itemn); }
private void AssistMsupply() { try { SM_BOMTEMP temp = new SM_BOMTEMP(); G.BLL.ERP.BaseData.DM_ITEMLogic itemlogic = new G.BLL.ERP.BaseData.DM_ITEMLogic(); SM_SHOPSUPPLY shopsupply = new SM_SHOPSUPPLY(); shopsupply.APPLYER = G.AppInfo.GGlobal.User.USERDM; shopsupply.APPLYERNAME = G.AppInfo.GGlobal.User.USERNAME; shopsupply.APPLYDATE = DateTime.Parse(BaseExtends.GetServerDate().ToShortDateString()); G.BLL.Sys.ND_ORGINAZITIONLogic userlogic = new BLL.Sys.ND_ORGINAZITIONLogic(); ND_ORGINAZITION userobj = userlogic.ExecuteSelect(CK.K["ID"].Eq(G.AppInfo.GGlobal.User.ORGID), OrderBy.Parse("ORGNAME"), 0, 0)[0]; shopsupply.WORKSHOP = userobj.ORGDM; shopsupply.ORGNAME = userobj.ORGNAME; SM_SHOPSUPPLYDTL dtl = new SM_SHOPSUPPLYDTL(); if (tabControl1.SelectedIndex == 0) { this.Grid_CP.FinishEditing(); temp = this.Grid_CP.GetCurSelect <SM_BOMTEMP>(); dtl.ACTQTY = G.Core.GConvert.ToDecimal(temp.LEFTQTY); } else { this.Grid_ZJ.FinishEditing(); temp = this.Grid_ZJ.GetCurSelect <SM_BOMTEMP>(); DM_ITEM itemobj1 = itemlogic.ExecuteSelect(CK.K["ITEMCODE"].Eq(temp.FATHERITEM), OrderBy.Parse("ITEMCODE"), 0, 0)[0]; if (temp.FATHERITEM.Substring(0, 4) == "S1LS") { dtl.ACTQTY = G.Core.GConvert.ToDecimal(temp.LEFTQTY * itemobj1.ISIZE / 100); } else { dtl.ACTQTY = G.Core.GConvert.ToDecimal(temp.LEFTQTY); } } dtl.ITEMCODE = temp.ITEMCODE; dtl.ITEMNAME = temp.ITEMNAME; dtl.UNIT = temp.INVUNIT; dtl.ATTRIBUTEA = temp.ATTRIBUTEA; dtl.ATTRIBUTEB = temp.ATTRIBUTEB; dtl.ATTRIBUTEBNAME = temp.ATTRIBUTEBNAME; dtl.ATTRIBUTEC = temp.ATTRIBUTEC; dtl.ATTRIBUTED = temp.ATTRIBUTED; dtl.MEMO = temp.MEMO; dtl.BOMTEMPID = temp.Id; DM_ITEM itemobj = itemlogic.ExecuteSelect(CK.K["ITEMCODE"].Eq(temp.ITEMCODE), OrderBy.Parse("ITEMCODE"), 0, 0)[0]; dtl.ISATTRIBUTEA = G.Core.GConvert.ToBool(itemobj.IsAttributeA); dtl.ISATTRIBUTEB = G.Core.GConvert.ToBool(itemobj.IsAttributeB); dtl.ISATTRIBUTEC = G.Core.GConvert.ToBool(itemobj.IsAttributeC); shopsupply.SHOPSUPPLYDTL.Add(dtl); //弹出外协领料单,数据来自选择行 Storage.SM_SHOPSUPPLYEDIT edit = new Storage.SM_SHOPSUPPLYEDIT(); edit.CurEditStatus = EditorStatus.Modify; edit.SetData(shopsupply); edit.ShowDialog(); this.LoadGridCP(orderid, gxname); this.LoadGridShop(orderid, gxname); this.LoadGridZJ(orderid, gxname); } catch (Exception e) { MessageBox.Show(e.Message); } }
private void ShopSupply() { try { this.gGrid1.FinishEditing(); List <SM_BOMTEMP> tempdata = (this.gGrid1.DataSource as BindingList <SM_BOMTEMP>).ToList <SM_BOMTEMP>(); var updata = from temp in tempdata where temp.ISSELECT == true select temp; SM_SHOPSUPPLY shopsupply = new SM_SHOPSUPPLY(); G.BLL.Sys.ND_ORGINAZITIONLogic orglogic = new G.BLL.Sys.ND_ORGINAZITIONLogic(); ND_ORGINAZITION orgobj = orglogic.ExecuteSelect(CK.K["ID"].Eq(G.AppInfo.GGlobal.User.ORGID), OrderBy.Parse("ID"), 0, 0)[0]; shopsupply.APPLYER = G.AppInfo.GGlobal.User.USERDM; shopsupply.APPLYERNAME = G.AppInfo.GGlobal.User.USERNAME; shopsupply.APPLYDATE = G.Core.GConvert.ToDateTime(System.Time.Now); shopsupply.WORKSHOP = orgobj.ORGDM; shopsupply.ORGNAME = orgobj.ORGNAME; bool nopass = true; foreach (SM_BOMTEMP t in updata) { if (t.ONHANDQTY == 0 || t.UNASSISTQTY <= 0) { nopass = false; break; } SM_SHOPSUPPLYDTL shopsupplydtl = new SM_SHOPSUPPLYDTL(); G.BLL.ERP.BaseData.DM_ITEMLogic itemlogic = new G.BLL.ERP.BaseData.DM_ITEMLogic(); DM_ITEM itemobj = itemlogic.ExecuteSelect(CK.K["ITEMCODE"].Eq(t.ITEMCODE), OrderBy.Parse("ITEMCODE"), 0, 0)[0]; shopsupplydtl.BOMTEMPID = t.Id; shopsupplydtl.ITEMCODE = t.ITEMCODE; shopsupplydtl.ITEMNAME = t.ITEMNAME; shopsupplydtl.UNIT = t.INVUNIT; shopsupplydtl.ATTRIBUTEA = t.ATTRIBUTEA; shopsupplydtl.ATTRIBUTEB = t.ATTRIBUTEB; shopsupplydtl.ATTRIBUTEBNAME = t.ATTRIBUTEBNAME; shopsupplydtl.ATTRIBUTEC = t.ATTRIBUTEC; shopsupplydtl.MEMO = t.MEMO; shopsupplydtl.ATTRIBUTED = t.ATTRIBUTED; shopsupplydtl.WRHSCODE = t.WRHSCODE; shopsupplydtl.WRHSNAME = t.WRHSNAME; shopsupplydtl.LOCCODE = t.LOCCODE; shopsupplydtl.LOCNAME = t.LOCNAME; shopsupplydtl.ISATTRIBUTEA = G.Core.GConvert.ToBool(itemobj.IsAttributeA); shopsupplydtl.ISATTRIBUTEB = G.Core.GConvert.ToBool(itemobj.IsAttributeB); shopsupplydtl.ISATTRIBUTEC = G.Core.GConvert.ToBool(itemobj.IsAttributeC); if (t.UNASSISTQTY <= t.ONHANDQTY) { shopsupplydtl.ACTQTY = t.UNASSISTQTY; } else { shopsupplydtl.ACTQTY = t.ONHANDQTY; } shopsupply.SHOPSUPPLYDTL.Add(shopsupplydtl); } //弹出成品领料单,数据来自选择行 G.Erp.Storage.SM_SHOPSUPPLYEDIT shopsupplyEdit = new G.Erp.Storage.SM_SHOPSUPPLYEDIT(); shopsupplyEdit.CurEditStatus = EditorStatus.Modify; shopsupplyEdit.SetData(shopsupply); shopsupplyEdit.ShowDialog(); //成品领料数量填入BOMTEMP foreach (SM_BOMTEMP t in updata) { if (t.UNASSISTQTY <= t.ONHANDQTY) { t.STOCKQTY = G.Core.GConvert.ToDecimal(t.STOCKQTY) + t.UNASSISTQTY; } else { t.STOCKQTY = G.Core.GConvert.ToDecimal(t.STOCKQTY) + t.ONHANDQTY; } ((SM_BOMTEMPLogic)this.Logic).ExecuteUpdate(G.AppInfo.GGlobal.User, tempdata); } this.Refresh(); } catch (Exception e) { MessageBox.Show(e.Message); } }
private void New() { editData = new DM_ITEM(); this.LoadData(); }
public void SetData(DM_ITEM data) { editData = data; LoadData(); }