void dropdown_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
gGrid1.GetCurSelect <DM_PRICEBILLDTL>().ITEMNAME = G.Core.GConvert.ToString(e.DataRow["ItemName"]);
}
}
private void DROP_CUSTID_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
this.DROP_SALEREP.SetValue(G.Core.GConvert.ToString(e.DataRow["SALESMAN"]));
}
}
private void DROP_ORDERID_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
string orderid = G.Core.GConvert.ToString(e.DataRow["ORDERID"]);
string sql = string.Format("select a.*,a.BOMQTY-ISNULL(b.pocketqty,0) as UNFINISHQTY,C.INVUNIT from SM_BOMTEMP_V1 a left join (select ORDERID,ORDLNNO,ITEMCODE,SUM(POCKETQTY) as pocketqty from SM_POCKETDTL group by ORDERID,ORDLNNO,ITEMCODE) b on a.ORDERID=b.ORDERID and a.ORDLNNO=b.ORDLNNO AND A.ITEMCODE=B.ITEMCODE LEFT JOIN DM_ITEM C ON A.ITEMCODE=C.ITEMCODE where A.TYPEID=1 AND a.ORDERID='{0}' ", orderid);
DataSet ds = G.Data.DbEntry.Provider.ExecuteDataset(sql);
if (ds.Tables[0].Rows.Count > 0)
{
BindingList <SM_POCKETDTL> L_pocketd = this.gGrid1.DataSource as BindingList <SM_POCKETDTL>;
L_pocketd.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SM_POCKETDTL pocketdtl = new SM_POCKETDTL();
pocketdtl.BOMTEMPID = G.Core.GConvert.ToInt(dr["ID"]);
pocketdtl.ORDERID = G.Core.GConvert.ToString(dr["ORDERID"]);
pocketdtl.ORDLNNO = G.Core.GConvert.ToInt(dr["ORDLNNO"]);
pocketdtl.ITEMCODE = G.Core.GConvert.ToString(dr["ITEMCODE"]);
pocketdtl.ITEMNAME = G.Core.GConvert.ToString(dr["ITEMNAME"]);
pocketdtl.UNIT = G.Core.GConvert.ToString(dr["INVUNIT"]);
pocketdtl.ORDQTY = G.Core.GConvert.ToInt(dr["BOMQTY"]);
pocketdtl.ATTRIBUTEA = G.Core.GConvert.ToString(dr["ATTRIBUTEA"]);
pocketdtl.ATTRIBUTEB = G.Core.GConvert.ToString(dr["ATTRIBUTEB"]);
pocketdtl.ATTRIBUTEBNAME = G.Core.GConvert.ToString(dr["ATTRIBUTEBNAME"]);
pocketdtl.ATTRIBUTEC = G.Core.GConvert.ToDecimal(dr["ATTRIBUTEC"]);
pocketdtl.STYLENO = G.Core.GConvert.ToString(dr["ATTRIBUTED"]);
pocketdtl.UNFINISHQTY = G.Core.GConvert.ToDecimal(dr["UNFINISHQTY"]);;
L_pocketd.Add(pocketdtl);
}
}
}
gGrid1.Refresh();
}
void DROP_GX_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
gxname = DROP_GX.Text;
LoadGridCP(orderid, gxname);
LoadGridShop(orderid, gxname);
this.LoadGridZJ(orderid, gxname);
}
void dropdown_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
SM_BOM cur = gGrid1.GetCurSelect <SM_BOM>();
cur.CITEMNAME = e.DataRow["ItemName"].ToString();
}
}
void dropdown_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
gGrid1.GetCurSelect <SM_XSKPDTL>().ITEMNAME = G.Core.GConvert.ToString(e.DataRow["ItemName"]);
gGrid1.GetCurSelect <SM_XSKPDTL>().JLDW = G.Core.GConvert.ToString(e.DataRow["INVUNIT"]);
}
gGrid1.Refresh();
}
private void DROP_ITEMCODE_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
DataRow dr = e.DataRow;
if (dr != null)
{
this.TXT_INVUNIT.SetValue(dr["INVUNIT"]);
}
}
void DROP_FITEM_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
DataRow dr = e.DataRow;
if (dr != null)
{
fitem = e.DataRow["ItemCode"].ToString();
this.LoadData();
}
}
void dropdown_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
SM_SALEORDERDTL cur = gGrid1.GetCurSelect <SM_SALEORDERDTL>();
cur.ITEMNAME = e.DataRow["ItemName"].ToString();
cur.ITEMCODE = e.DataRow["ItemCode"].ToString();
//CacuCurPrice(cur);
}
}
private void DROP_ACUSTCODE_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
DataRow dr = e.DataRow;
if (dr != null)
{
this.TXT_SALESMANNAME.SetValue(dr["SALESMANNAME"]);
this.TXT_SALESREPNAME.SetValue(dr["SALESREPNAME"]);
}
}
void dropdown_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
gGrid1.GetCurSelect <SM_PORDERDTL>().ITEMNAME = G.Core.GConvert.ToString(e.DataRow["ItemName"]);
gGrid1.GetCurSelect <SM_PORDERDTL>().INVUNIT = G.Core.GConvert.ToString(e.DataRow["INVUNIT"]);
gGrid1.GetCurSelect <SM_PORDERDTL>().ISATTRIBUTEA = G.Core.GConvert.ToBool(e.DataRow["ISATTRIBUTEA"]);
gGrid1.GetCurSelect <SM_PORDERDTL>().ISATTRIBUTEB = G.Core.GConvert.ToBool(e.DataRow["ISATTRIBUTEB"]);
gGrid1.GetCurSelect <SM_PORDERDTL>().ISATTRIBUTEC = G.Core.GConvert.ToBool(e.DataRow["ISATTRIBUTEC"]);
}
}
void dropdown_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
gGrid1.GetCurSelect <SM_SHIPVOUCHERDTL>().ITEMNAME = G.Core.GConvert.ToString(e.DataRow["ItemName"]);
gGrid1.GetCurSelect <SM_SHIPVOUCHERDTL>().INVUNIT = G.Core.GConvert.ToString(e.DataRow["INVUNIT"]);
gGrid1.GetCurSelect <SM_SHIPVOUCHERDTL>().WRHSCODE = G.Core.GConvert.ToString(e.DataRow["WRHSCODE"]);
gGrid1.GetCurSelect <SM_SHIPVOUCHERDTL>().WRHSNAME = G.Core.GConvert.ToString(e.DataRow["WRHSNAME"]);
gGrid1.GetCurSelect <SM_SHIPVOUCHERDTL>().LOCCODE = G.Core.GConvert.ToString(e.DataRow["LOCCODE"]);
gGrid1.GetCurSelect <SM_SHIPVOUCHERDTL>().LOCNAME = G.Core.GConvert.ToString(e.DataRow["LOCNAME"]);
}
gGrid1.Refresh();
}
void DROP_CUSTID_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
DataRow dr = e.DataRow;
if (dr != null)
{
this.DROP_INVCUSTID.SetValue(dr["ID"]);
this.DROP_SALESMAN.SetValue(dr["SALESMAN"]);
this.DROP_SALESREP.SetValue(dr["SALESREP"]);
this.DROP_INOFC.SetValue(dr["INOFC"]);
this.TXT_CUSTLEV.SetValue(dr["CUSTLEV"]);
}
}
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();
}
void dropdown_RowSelected(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().ITEMNAME = G.Core.GConvert.ToString(e.DataRow["ItemName"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().UNIT = G.Core.GConvert.ToString(e.DataRow["INVUNIT"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().WRHSCODE = G.Core.GConvert.ToString(e.DataRow["WRHSCODE"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().WRHSNAME = G.Core.GConvert.ToString(e.DataRow["WRHSNAME"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().LOCCODE = G.Core.GConvert.ToString(e.DataRow["LOCCODE"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().LOCNAME = G.Core.GConvert.ToString(e.DataRow["LOCNAME"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().ISATTRIBUTEA = G.Core.GConvert.ToBool(e.DataRow["ISATTRIBUTEA"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().ISATTRIBUTEB = G.Core.GConvert.ToBool(e.DataRow["ISATTRIBUTEB"]);
gGrid1.GetCurSelect <SM_ASSISTMENTRYDTL>().ISATTRIBUTEC = G.Core.GConvert.ToBool(e.DataRow["ISATTRIBUTEC"]);
}
gGrid1.Refresh();
}
private void DROP_ITEMCODE_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
DataRow dr = e.DataRow;
if (dr != null)
{
this.TXT_INVUNIT.SetValue(dr["INVUNIT"]);
this.DROP_SUPCODE.Value = G.Core.GConvert.ToString(dr["SUPCODE"]);
this.DROP_SUPCODE.Text = G.Core.GConvert.ToString(dr["SUPPNAME"]);
if (G.Core.GConvert.ToString(dr["SUPCODE"]) == "" || G.Core.GConvert.ToString(dr["SUPCODE"]) == "0")
{
this.DROP_SUPCODE.ReadOnly = false;
this.NUM_SUPPRICE.ReadOnly = false;
}
this.NUM_SUPPRICE.SetValue(dr["SUPPRICE"]);
}
}
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"]);
}
}
private void DROP_ASSISTMSCODE_RowSelect(object sender, Interface.Event.DataRowEvent e)
{
if (e.DataRow != null)
{
this.TXT_SUPPNAME.Text = G.Core.GConvert.ToString(e.DataRow["SUPPNAME"]);
string code = G.Core.GConvert.ToString(e.DataRow["ASSISTMSCODE"]);
G.BLL.ERP.Assist.SM_ASSISTMSUPPLYLogic assistlogic = new BLL.ERP.Assist.SM_ASSISTMSUPPLYLogic();
SM_ASSISTMSUPPLY assistmsobj = assistlogic.ExecuteSelect(CK.K["ASSISTMSCODE"].Eq(code), OrderBy.Parse("ASSISTMSCODE"), 0, 0)[0];
if (assistmsobj != null)
{
BindingList <SM_ASSISTMENTRYDTL> assistmedtl = this.gGrid1.DataSource as BindingList <SM_ASSISTMENTRYDTL>;
assistmedtl.Clear();
foreach (SM_ASSISTMSUPPLYDTL r in assistmsobj.ASSISTMSUPPLYDTL)
{
SM_ASSISTMENTRYDTL assistme = new SM_ASSISTMENTRYDTL();
assistme.ASSISTMSLNNO = r.LNNO;
assistme.ITEMCODE = r.ITEMCODE;
assistme.ITEMNAME = r.ITEMNAME;
assistme.UNIT = r.UNIT;
assistme.FACTQTY = r.LEFTQTY;
assistme.KGQTY = r.KGQTY;
assistme.RATE = r.RATE;
assistme.ATTRIBUTEA = r.ATTRIBUTEA;
assistme.ATTRIBUTEB = r.ATTRIBUTEB;
assistme.ATTRIBUTEBNAME = r.ATTRIBUTEBNAME;
assistme.ATTRIBUTEC = r.ATTRIBUTEC;
assistme.WRHSCODE = r.WRHSCODE;
assistme.WRHSNAME = r.WRHSNAME;
assistme.LOCCODE = r.LOCCODE;
assistme.LOCNAME = r.LOCNAME;
assistme.ISATTRIBUTEA = r.ISATTRIBUTEA;
assistme.ISATTRIBUTEB = r.ISATTRIBUTEB;
assistme.ISATTRIBUTEC = r.ISATTRIBUTEC;
assistmedtl.Add(assistme);
}
}
}
}
