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); }