public static Pdemloadpdsrresults BuildPdemloadpdsrresultsFromRow(DataRow row)
{
Pdemloadpdsrresults entity = new Pdemloadpdsrresults();
entity.updttype = row.Field <bool>("updttype");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.prodnotesfl = row.IsNull("prodnotesfl") ? string.Empty : row.Field <string>("prodnotesfl");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.proddesc2 = row.IsNull("proddesc2") ? string.Empty : row.Field <string>("proddesc2");
entity.xrefprod = row.IsNull("xrefprod") ? string.Empty : row.Field <string>("xrefprod");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.rebatety = row.IsNull("rebatety") ? string.Empty : row.Field <string>("rebatety");
entity.rebsubty = row.IsNull("rebsubty") ? string.Empty : row.Field <string>("rebsubty");
entity.prodprcty = row.IsNull("prodprcty") ? string.Empty : row.Field <string>("prodprcty");
entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline");
entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.vendnotesfl = row.IsNull("vendnotesfl") ? string.Empty : row.Field <string>("vendnotesfl");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
entity.custtype = row.IsNull("custtype") ? string.Empty : row.Field <string>("custtype");
entity.shiptonotesfl = row.IsNull("shiptonotesfl") ? string.Empty : row.Field <string>("shiptonotesfl");
entity.custrebty = row.IsNull("custrebty") ? string.Empty : row.Field <string>("custrebty");
entity.contractNo = row.IsNull("ContractNo") ? string.Empty : row.Field <string>("ContractNo");
entity.startdt = row.Field <DateTime?>("startdt");
entity.enddt = row.Field <DateTime?>("enddt");
entity.dropshipty = row.IsNull("dropshipty") ? string.Empty : row.Field <string>("dropshipty");
entity.rebatecd = row.IsNull("rebatecd") ? string.Empty : row.Field <string>("rebatecd");
entity.rebcalcty = row.IsNull("rebcalcty") ? string.Empty : row.Field <string>("rebcalcty");
entity.margincostty = row.IsNull("margincostty") ? string.Empty : row.Field <string>("margincostty");
entity.rebatecostty = row.IsNull("rebatecostty") ? string.Empty : row.Field <string>("rebatecostty");
entity.rebdowntoty = row.IsNull("rebdowntoty") ? string.Empty : row.Field <string>("rebdowntoty");
entity.rebateamt = row.IsNull("rebateamt") ? decimal.Zero : row.Field <decimal>("rebateamt");
entity.rebatepct = row.IsNull("rebatepct") ? decimal.Zero : row.Field <decimal>("rebatepct");
entity.priceSheet = row.IsNull("PriceSheet") ? string.Empty : row.Field <string>("PriceSheet");
entity.priceEffectiveDate = row.Field <DateTime?>("PriceEffectiveDate");
entity.priceSheetTo = row.IsNull("PriceSheetTo") ? string.Empty : row.Field <string>("PriceSheetTo");
entity.priceEffectiveDateTo = row.Field <DateTime?>("PriceEffectiveDateTo");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.sharefl = row.Field <bool>("sharefl");
entity.sharepct = row.IsNull("sharepct") ? decimal.Zero : row.Field <decimal>("sharepct");
entity.capsellamount = row.IsNull("capsellamount") ? decimal.Zero : row.Field <decimal>("capsellamount");
entity.capselltypefl = row.Field <bool>("capselltypefl");
entity.manualfl = row.Field <bool>("manualfl");
entity.contractlineno = row.IsNull("contractlineno") ? 0 : row.Field <int>("contractlineno");
entity.region = row.IsNull("region") ? string.Empty : row.Field <string>("region");
entity.contractcostfl = row.Field <bool>("contractcostfl");
entity.usecontractlineno = row.Field <bool>("usecontractlineno");
entity.price = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price");
entity.prccurrencyty = row.IsNull("prccurrencyty") ? string.Empty : row.Field <string>("prccurrencyty");
entity.usepricerebfl = row.Field <bool>("usepricerebfl");
entity.rebrecno = row.IsNull("rebrecno") ? decimal.Zero : row.Field <decimal>("rebrecno");
entity.cUpdErrMsg = row.IsNull("cUpdErrMsg") ? string.Empty : row.Field <string>("cUpdErrMsg");
entity.pvPdmlineRowid = row.Field <byte[]>("pv_pdmline_rowid").ToStringEncoded();
entity.excelrowid = row.IsNull("excelrowid") ? string.Empty : row.Field <string>("excelrowid");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromPdemloadpdsrresults(ref DataRow row, Pdemloadpdsrresults entity)
{
row.SetField("updttype", entity.updttype);
row.SetField("prod", entity.prod);
row.SetField("prodnotesfl", entity.prodnotesfl);
row.SetField("proddesc", entity.proddesc);
row.SetField("proddesc2", entity.proddesc2);
row.SetField("xrefprod", entity.xrefprod);
row.SetField("whse", entity.whse);
row.SetField("rebatety", entity.rebatety);
row.SetField("rebsubty", entity.rebsubty);
row.SetField("prodprcty", entity.prodprcty);
row.SetField("prodline", entity.prodline);
row.SetField("prodcat", entity.prodcat);
row.SetField("vendno", entity.vendno);
row.SetField("vendnotesfl", entity.vendnotesfl);
row.SetField("custno", entity.custno);
row.SetField("custnotesfl", entity.custnotesfl);
row.SetField("custtype", entity.custtype);
row.SetField("shiptonotesfl", entity.shiptonotesfl);
row.SetField("custrebty", entity.custrebty);
row.SetField("ContractNo", entity.contractNo);
row.SetField("startdt", entity.startdt);
row.SetField("enddt", entity.enddt);
row.SetField("dropshipty", entity.dropshipty);
row.SetField("rebatecd", entity.rebatecd);
row.SetField("rebcalcty", entity.rebcalcty);
row.SetField("margincostty", entity.margincostty);
row.SetField("rebatecostty", entity.rebatecostty);
row.SetField("rebdowntoty", entity.rebdowntoty);
row.SetField("rebateamt", entity.rebateamt);
row.SetField("rebatepct", entity.rebatepct);
row.SetField("PriceSheet", entity.priceSheet);
row.SetField("PriceEffectiveDate", entity.priceEffectiveDate);
row.SetField("PriceSheetTo", entity.priceSheetTo);
row.SetField("PriceEffectiveDateTo", entity.priceEffectiveDateTo);
row.SetField("refer", entity.refer);
row.SetField("sharefl", entity.sharefl);
row.SetField("sharepct", entity.sharepct);
row.SetField("capsellamount", entity.capsellamount);
row.SetField("capselltypefl", entity.capselltypefl);
row.SetField("manualfl", entity.manualfl);
row.SetField("contractlineno", entity.contractlineno);
row.SetField("region", entity.region);
row.SetField("contractcostfl", entity.contractcostfl);
row.SetField("usecontractlineno", entity.usecontractlineno);
row.SetField("price", entity.price);
row.SetField("prccurrencyty", entity.prccurrencyty);
row.SetField("usepricerebfl", entity.usepricerebfl);
row.SetField("rebrecno", entity.rebrecno);
row.SetField("cUpdErrMsg", entity.cUpdErrMsg);
row.SetField("pv_pdmline_rowid", entity.pvPdmlineRowid.ToByteArray());
row.SetField("excelrowid", entity.excelrowid);
row.SetField("userfield", entity.userfield);
}
