public override int ExecuteUpdate(ND_USER user, SM_SHOPSUPPLY obj)
{
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.SUPPLYID = BaseExtends.GetNewAutoNo("SP");
obj.OPERATOR = user.USERDM;
}
int lnno = 1;
//foreach (SM_SHOPSUPPLYDTL d in obj.SHOPSUPPLYDTL)
//{
// if (d.ITEMCODE.IsNullOrEmpty()) { obj.SHOPSUPPLYDTL.Remove(d); continue; }
// d.SUPPLYID = obj.SUPPLYID;
// d.SUPLNNO = lnno;
// lnno++;
//}
for (int i = 0; i < obj.SHOPSUPPLYDTL.Count; i++)
{
SM_SHOPSUPPLYDTL d = obj.SHOPSUPPLYDTL[i];
if (d.ITEMCODE.IsNullOrEmpty())
{
obj.SHOPSUPPLYDTL.Remove(d); i--; continue;
}
d.SUPPLYID = obj.SUPPLYID;
d.SUPLNNO = lnno;
lnno++;
}
base.ExecuteUpdate(obj);
return(obj.Id);
}
public void SetItemCode(SM_SHOPSUPPLYDTL dtl)
{
this.txt_ITEMCODE.SetValue(dtl.ITEMCODE);
this.txt_ITEMDESC.SetValue(dtl.ITEMNAME);
this.txt_ATTRIBUTEA.SetValue(dtl.ATTRIBUTEA);
this.drop_attributeb.SetValue(dtl.ATTRIBUTEB);
SearchData(dtl.ITEMCODE, dtl.ITEMNAME, "", "", dtl.ATTRIBUTEA, dtl.ATTRIBUTEB, "", true);
}
private void KuCun()
{
SM_SHOPSUPPLYDTL shopsupplydtl = gGrid1.GetCurSelect <SM_SHOPSUPPLYDTL>();
ItemLocStorage itemlocstorageform = new ItemLocStorage();
itemlocstorageform.EventRowSelected += ItemLoc_RowSelected;
itemlocstorageform.SetItemCode(shopsupplydtl);
itemlocstorageform.ShowDialog();
this.gGrid1.Refresh();
}
void ItemLoc_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
SM_SHOPSUPPLYDTL cur = gGrid1.GetCurSelect <SM_SHOPSUPPLYDTL>();
cur.ITEMCODE = e.DataRow["ITEMCODE"].ToString();
cur.ITEMNAME = e.DataRow["ITEMNAME"].ToString();
cur.WRHSCODE = e.DataRow["WRHSCODE"].ToString();
cur.WRHSNAME = e.DataRow["WRHSNAME"].ToString();
cur.LOCCODE = e.DataRow["LOCCODE"].ToString();
cur.LOCNAME = e.DataRow["LOCNAME"].ToString();
cur.ATTRIBUTEA = e.DataRow["ATTRIBUTEA"].ToString();
cur.ATTRIBUTEB = e.DataRow["ATTRIBUTEB"].ToString();
cur.ATTRIBUTEBNAME = e.DataRow["ATTRIBUTEBNAME"].ToString();
cur.ATTRIBUTEC = G.Core.GConvert.ToDecimal(e.DataRow["ATTRIBUTEC"]);
}
}
public override void AddRow()
{
SM_SHOPSUPPLYDTL shopsupplydtl = gGrid1.AddRow <SM_SHOPSUPPLYDTL>();
}
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);
}
}