public List <C_SKU_MPN> GetMpnBySkuAndPartno(OleExec sfcdb, string sku, string partno)
{
string sql = $@" select * from c_sku_mpn where skuno='{sku}' and partno='{partno}' ";
DataSet ds = sfcdb.ExecSelect(sql);
List <C_SKU_MPN> skuMpnList = new List <C_SKU_MPN>();
foreach (DataRow VARIABLE in ds.Tables[0].Rows)
{
Row_C_SKU_MPN rowCSkuMpn = (Row_C_SKU_MPN)this.NewRow();
rowCSkuMpn.loadData(VARIABLE);
skuMpnList.Add(rowCSkuMpn.GetDataObject());
}
return(skuMpnList);
}
public List <C_SKU_MPN> GetMpnBySku(OleExec DB, string Sku)
{
string sql = Sku.Equals("") ? $@"SELECT * FROM C_SKU_MPN ":$@"SELECT * FROM C_SKU_MPN where skuno='{Sku}'";
DataSet dsCSkuMpn = DB.ExecSelect(sql);
List <C_SKU_MPN> CSkuMpnList = new List <C_SKU_MPN>();
foreach (DataRow VARIABLE in dsCSkuMpn.Tables[0].Rows)
{
Row_C_SKU_MPN rowCSkuMpn = (Row_C_SKU_MPN)this.NewRow();
rowCSkuMpn.loadData(VARIABLE);
CSkuMpnList.Add(rowCSkuMpn.GetDataObject());
}
return(CSkuMpnList);
}
