public List <C_SKU_AQL> GetSkuAqlBySkuId(OleExec DB, string SkuId)
{
List <C_SKU_AQL> res = new List <C_SKU_AQL>();
string strSql = $@" select A.* from C_SKU_AQL A,C_SKU B where B.SKUNO=A.SKUNO AND B.ID='{SkuId}' ";
DataSet ds = DB.ExecSelect(strSql);
foreach (DataRow item in ds.Tables[0].Rows)
{
Row_C_SKU_AQL r = (Row_C_SKU_AQL)this.NewRow();
r.loadData(item);
res.Add(r.GetDataObject());
}
return(res);
}
public C_SKU_AQL GetSkuAql(OleExec DB, string Skuno)
{
C_SKU_AQL res = new C_SKU_AQL();
string strSql = $@" select * from C_SKU_AQL where skuno='{Skuno}' ";
DataSet ds = DB.ExecSelect(strSql);
foreach (DataRow item in ds.Tables[0].Rows)
{
Row_C_SKU_AQL r = (Row_C_SKU_AQL)this.NewRow();
r.loadData(item);
res = r.GetDataObject();
}
return(res);
}
