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();
}
public override void AddRow()
{
SM_POCKETDTL pocketdtl = gGrid1.AddRow <SM_POCKETDTL>();
}
