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