/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromPdgetpdsrrecordsresults(ref DataRow row, Pdgetpdsrrecordsresults entity)
{
row.SetField("actqty", entity.actqty);
row.SetField("addoncost", entity.addoncost);
row.SetField("arppushfl", entity.arppushfl);
row.SetField("arptype", entity.arptype);
row.SetField("arpwhse", entity.arpwhse);
row.SetField("avgcost", entity.avgcost);
row.SetField("baseprice", entity.baseprice);
row.SetField("BatchNm", entity.batchNm);
row.SetField("buytype", entity.buytype);
row.SetField("caprebfl", entity.caprebfl);
row.SetField("cdlink", entity.cdlink);
row.SetField("chainedfl", entity.chainedfl);
row.SetField("class", entity.@class);
row.SetField("commtype", entity.commtype);
row.SetField("cono", entity.cono);
row.SetField("ContractNo", entity.contractNo);
row.SetField("custno", entity.custno);
row.SetField("custnotesfl", entity.custnotesfl);
row.SetField("custrebty", entity.custrebty);
row.SetField("custtype", entity.custtype);
row.SetField("disctype", entity.disctype);
row.SetField("dropshipty", entity.dropshipty);
row.SetField("enddt", entity.enddt);
row.SetField("famgrptype", entity.famgrptype);
row.SetField("filter1", entity.filter1);
row.SetField("filter2", entity.filter2);
row.SetField("filter3", entity.filter3);
row.SetField("filter4", entity.filter4);
row.SetField("filter5", entity.filter5);
row.SetField("filter6", entity.filter6);
row.SetField("filter7", entity.filter7);
row.SetField("hardmaxqtyfl", entity.hardmaxqtyfl);
row.SetField("hardpricefl", entity.hardpricefl);
row.SetField("jobno", entity.jobno);
row.SetField("lastcost", entity.lastcost);
row.SetField("levelcd", entity.levelcd);
row.SetField("levelkey", entity.levelkey);
row.SetField("line_rowid", entity.lineRowid);
row.SetField("listprice", entity.listprice);
row.SetField("margincostty", entity.margincostty);
row.SetField("maxqty", entity.maxqty);
row.SetField("maxqtytype", entity.maxqtytype);
row.SetField("minqty", entity.minqty);
row.SetField("modified", entity.modified);
row.SetField("modifiernm", entity.modifiernm);
row.SetField("modifierrebfl", entity.modifierrebfl);
row.SetField("operinit", entity.operinit);
row.SetField("OrigCust", entity.origCust);
row.SetField("OrigStartDt", entity.origStartDt);
row.SetField("Origwhse", entity.origwhse);
row.SetField("pdrecno", entity.pdrecno);
row.SetField("pd_rowid", entity.pdRowid);
row.SetField("pexactrnd", entity.pexactrnd);
row.SetField("prcdisc1", entity.prcdisc1);
row.SetField("prcdisc2", entity.prcdisc2);
row.SetField("prcdisc3", entity.prcdisc3);
row.SetField("prcdisc4", entity.prcdisc4);
row.SetField("prcdisc5", entity.prcdisc5);
row.SetField("prcdisc6", entity.prcdisc6);
row.SetField("prcdisc7", entity.prcdisc7);
row.SetField("prcdisc8", entity.prcdisc8);
row.SetField("prcdisc9", entity.prcdisc9);
row.SetField("prcdisc21", entity.prcdisc21);
row.SetField("prcdisc22", entity.prcdisc22);
row.SetField("prcdisc23", entity.prcdisc23);
row.SetField("prcdisc24", entity.prcdisc24);
row.SetField("prcdisc25", entity.prcdisc25);
row.SetField("prcdisc26", entity.prcdisc26);
row.SetField("prcdisc27", entity.prcdisc27);
row.SetField("prcdisc28", entity.prcdisc28);
row.SetField("prcdisc29", entity.prcdisc29);
row.SetField("prcdisc31", entity.prcdisc31);
row.SetField("prcdisc32", entity.prcdisc32);
row.SetField("prcdisc33", entity.prcdisc33);
row.SetField("prcdisc34", entity.prcdisc34);
row.SetField("prcdisc35", entity.prcdisc35);
row.SetField("prcdisc36", entity.prcdisc36);
row.SetField("prcdisc37", entity.prcdisc37);
row.SetField("prcdisc38", entity.prcdisc38);
row.SetField("prcdisc39", entity.prcdisc39);
row.SetField("prcdisc41", entity.prcdisc41);
row.SetField("prcdisc42", entity.prcdisc42);
row.SetField("prcdisc43", entity.prcdisc43);
row.SetField("prcdisc44", entity.prcdisc44);
row.SetField("prcdisc45", entity.prcdisc45);
row.SetField("prcdisc46", entity.prcdisc46);
row.SetField("prcdisc47", entity.prcdisc47);
row.SetField("prcdisc48", entity.prcdisc48);
row.SetField("prcdisc49", entity.prcdisc49);
row.SetField("prcdisc51", entity.prcdisc51);
row.SetField("prcdisc52", entity.prcdisc52);
row.SetField("prcdisc53", entity.prcdisc53);
row.SetField("prcdisc54", entity.prcdisc54);
row.SetField("prcdisc55", entity.prcdisc55);
row.SetField("prcdisc56", entity.prcdisc56);
row.SetField("prcdisc57", entity.prcdisc57);
row.SetField("prcdisc58", entity.prcdisc58);
row.SetField("prcdisc59", entity.prcdisc59);
row.SetField("prcdisc61", entity.prcdisc61);
row.SetField("prcdisc62", entity.prcdisc62);
row.SetField("prcdisc63", entity.prcdisc63);
row.SetField("prcdisc64", entity.prcdisc64);
row.SetField("prcdisc65", entity.prcdisc65);
row.SetField("prcdisc66", entity.prcdisc66);
row.SetField("prcdisc67", entity.prcdisc67);
row.SetField("prcdisc68", entity.prcdisc68);
row.SetField("prcdisc69", entity.prcdisc69);
row.SetField("prcmult1", entity.prcmult1);
row.SetField("prcmult2", entity.prcmult2);
row.SetField("prcmult3", entity.prcmult3);
row.SetField("prcmult4", entity.prcmult4);
row.SetField("prcmult5", entity.prcmult5);
row.SetField("prcmult6", entity.prcmult6);
row.SetField("prcmult7", entity.prcmult7);
row.SetField("prcmult8", entity.prcmult8);
row.SetField("prcmult9", entity.prcmult9);
row.SetField("prctype", entity.prctype);
row.SetField("PriceEffectiveDate", entity.priceEffectiveDate);
row.SetField("PriceEffectiveDateTo", entity.priceEffectiveDateTo);
row.SetField("priceonty", entity.priceonty);
row.SetField("PriceSheet", entity.priceSheet);
row.SetField("PriceSheetTo", entity.priceSheetTo);
row.SetField("pricety", entity.pricety);
row.SetField("primarykey", entity.primarykey);
row.SetField("prod", entity.prod);
row.SetField("prodcat", entity.prodcat);
row.SetField("prodcost", entity.prodcost);
row.SetField("proddesc", entity.proddesc);
row.SetField("proddesc2", entity.proddesc2);
row.SetField("prodline", entity.prodline);
row.SetField("prodnotesfl", entity.prodnotesfl);
row.SetField("prodprcty", entity.prodprcty);
row.SetField("promofl", entity.promofl);
row.SetField("pround", entity.pround);
row.SetField("ptarget", entity.ptarget);
row.SetField("qtybreakty", entity.qtybreakty);
row.SetField("qtybrk1", entity.qtybrk1);
row.SetField("qtybrk2", entity.qtybrk2);
row.SetField("qtybrk3", entity.qtybrk3);
row.SetField("qtybrk4", entity.qtybrk4);
row.SetField("qtybrk5", entity.qtybrk5);
row.SetField("qtybrk6", entity.qtybrk6);
row.SetField("qtybrk7", entity.qtybrk7);
row.SetField("qtybrk8", entity.qtybrk8);
row.SetField("qtytype", entity.qtytype);
row.SetField("qtyyymm", entity.qtyyymm);
row.SetField("quotefl", entity.quotefl);
row.SetField("quoteno", entity.quoteno);
row.SetField("rebateamt", entity.rebateamt);
row.SetField("rebatecd", entity.rebatecd);
row.SetField("rebatecost", entity.rebatecost);
row.SetField("rebatecostty", entity.rebatecostty);
row.SetField("rebatepct", entity.rebatepct);
row.SetField("rebatety", entity.rebatety);
row.SetField("rebcalcty", entity.rebcalcty);
row.SetField("rebdowntoty", entity.rebdowntoty);
row.SetField("rebrecno", entity.rebrecno);
row.SetField("rebsubty", entity.rebsubty);
row.SetField("refer", entity.refer);
row.SetField("replcost", entity.replcost);
row.SetField("SeqNo", entity.seqNo);
row.SetField("SetID", entity.setID);
row.SetField("shipfmno", entity.shipfmno);
row.SetField("shiptonotesfl", entity.shiptonotesfl);
row.SetField("sortkey", entity.sortkey);
row.SetField("source", entity.source);
row.SetField("startdt", entity.startdt);
row.SetField("statustype", entity.statustype);
row.SetField("stndcost", entity.stndcost);
row.SetField("taxprice", entity.taxprice);
row.SetField("termsdiscfl", entity.termsdiscfl);
row.SetField("termspct", entity.termspct);
row.SetField("touchedfl", entity.touchedfl);
row.SetField("transdt", entity.transdt);
row.SetField("transproc", entity.transproc);
row.SetField("transtm", entity.transtm);
row.SetField("Typecode", entity.typecode);
row.SetField("units", entity.units);
row.SetField("updttype", entity.updttype);
row.SetField("user1", entity.user1);
row.SetField("user2", entity.user2);
row.SetField("user3", entity.user3);
row.SetField("user4", entity.user4);
row.SetField("user5", entity.user5);
row.SetField("user6", entity.user6);
row.SetField("user7", entity.user7);
row.SetField("user8", entity.user8);
row.SetField("user9", entity.user9);
row.SetField("vendno", entity.vendno);
row.SetField("vendnotesfl", entity.vendnotesfl);
row.SetField("vendorprice", entity.vendorprice);
row.SetField("vendprod", entity.vendprod);
row.SetField("vendquote", entity.vendquote);
row.SetField("whse", entity.whse);
row.SetField("xrefprod", entity.xrefprod);
row.SetField("rebatedesc", entity.rebatedesc);
row.SetField("dropshiptydesc", entity.dropshiptydesc);
row.SetField("contractlineno", entity.contractlineno);
row.SetField("sharefl", entity.sharefl);
row.SetField("manualfl", entity.manualfl);
}
public static Pdgetpdsrrecordsresults BuildPdgetpdsrrecordsresultsFromRow(DataRow row)
{
Pdgetpdsrrecordsresults entity = new Pdgetpdsrrecordsresults();
entity.actqty = row.IsNull("actqty") ? decimal.Zero : row.Field <decimal>("actqty");
entity.addoncost = row.IsNull("addoncost") ? decimal.Zero : row.Field <decimal>("addoncost");
entity.arppushfl = row.Field <bool>("arppushfl");
entity.arptype = row.IsNull("arptype") ? string.Empty : row.Field <string>("arptype");
entity.arpwhse = row.IsNull("arpwhse") ? string.Empty : row.Field <string>("arpwhse");
entity.avgcost = row.IsNull("avgcost") ? decimal.Zero : row.Field <decimal>("avgcost");
entity.baseprice = row.IsNull("baseprice") ? decimal.Zero : row.Field <decimal>("baseprice");
entity.batchNm = row.IsNull("BatchNm") ? string.Empty : row.Field <string>("BatchNm");
entity.buytype = row.IsNull("buytype") ? string.Empty : row.Field <string>("buytype");
entity.caprebfl = row.Field <bool>("caprebfl");
entity.cdlink = row.IsNull("cdlink") ? string.Empty : row.Field <string>("cdlink");
entity.chainedfl = row.Field <bool>("chainedfl");
entity.@class = row.IsNull("class") ? 0 : row.Field <int>("class");
entity.commtype = row.IsNull("commtype") ? string.Empty : row.Field <string>("commtype");
entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono");
entity.contractNo = row.IsNull("ContractNo") ? string.Empty : row.Field <string>("ContractNo");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
entity.custrebty = row.IsNull("custrebty") ? string.Empty : row.Field <string>("custrebty");
entity.custtype = row.IsNull("custtype") ? string.Empty : row.Field <string>("custtype");
entity.disctype = row.IsNull("disctype") ? string.Empty : row.Field <string>("disctype");
entity.dropshipty = row.IsNull("dropshipty") ? string.Empty : row.Field <string>("dropshipty");
entity.enddt = row.Field <DateTime?>("enddt");
entity.famgrptype = row.IsNull("famgrptype") ? string.Empty : row.Field <string>("famgrptype");
entity.filter1 = row.IsNull("filter1") ? string.Empty : row.Field <string>("filter1");
entity.filter2 = row.IsNull("filter2") ? string.Empty : row.Field <string>("filter2");
entity.filter3 = row.IsNull("filter3") ? string.Empty : row.Field <string>("filter3");
entity.filter4 = row.IsNull("filter4") ? string.Empty : row.Field <string>("filter4");
entity.filter5 = row.IsNull("filter5") ? string.Empty : row.Field <string>("filter5");
entity.filter6 = row.IsNull("filter6") ? string.Empty : row.Field <string>("filter6");
entity.filter7 = row.IsNull("filter7") ? string.Empty : row.Field <string>("filter7");
entity.hardmaxqtyfl = row.Field <bool>("hardmaxqtyfl");
entity.hardpricefl = row.Field <bool>("hardpricefl");
entity.jobno = row.IsNull("jobno") ? string.Empty : row.Field <string>("jobno");
entity.lastcost = row.IsNull("lastcost") ? decimal.Zero : row.Field <decimal>("lastcost");
entity.levelcd = row.IsNull("levelcd") ? string.Empty : row.Field <string>("levelcd");
entity.levelkey = row.IsNull("levelkey") ? string.Empty : row.Field <string>("levelkey");
entity.lineRowid = row.IsNull("line_rowid") ? string.Empty : row.Field <string>("line_rowid");
entity.listprice = row.IsNull("listprice") ? decimal.Zero : row.Field <decimal>("listprice");
entity.margincostty = row.IsNull("margincostty") ? string.Empty : row.Field <string>("margincostty");
entity.maxqty = row.IsNull("maxqty") ? decimal.Zero : row.Field <decimal>("maxqty");
entity.maxqtytype = row.IsNull("maxqtytype") ? string.Empty : row.Field <string>("maxqtytype");
entity.minqty = row.IsNull("minqty") ? decimal.Zero : row.Field <decimal>("minqty");
entity.modified = row.Field <bool>("modified");
entity.modifiernm = row.IsNull("modifiernm") ? string.Empty : row.Field <string>("modifiernm");
entity.modifierrebfl = row.Field <bool>("modifierrebfl");
entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
entity.origCust = row.IsNull("OrigCust") ? decimal.Zero : row.Field <decimal>("OrigCust");
entity.origStartDt = row.Field <DateTime?>("OrigStartDt");
entity.origwhse = row.IsNull("Origwhse") ? string.Empty : row.Field <string>("Origwhse");
entity.pdrecno = row.IsNull("pdrecno") ? 0 : row.Field <int>("pdrecno");
entity.pdRowid = row.IsNull("pd_rowid") ? string.Empty : row.Field <string>("pd_rowid");
entity.pexactrnd = row.IsNull("pexactrnd") ? decimal.Zero : row.Field <decimal>("pexactrnd");
entity.prcdisc1 = row.IsNull("prcdisc1") ? decimal.Zero : row.Field <decimal>("prcdisc1");
entity.prcdisc2 = row.IsNull("prcdisc2") ? decimal.Zero : row.Field <decimal>("prcdisc2");
entity.prcdisc3 = row.IsNull("prcdisc3") ? decimal.Zero : row.Field <decimal>("prcdisc3");
entity.prcdisc4 = row.IsNull("prcdisc4") ? decimal.Zero : row.Field <decimal>("prcdisc4");
entity.prcdisc5 = row.IsNull("prcdisc5") ? decimal.Zero : row.Field <decimal>("prcdisc5");
entity.prcdisc6 = row.IsNull("prcdisc6") ? decimal.Zero : row.Field <decimal>("prcdisc6");
entity.prcdisc7 = row.IsNull("prcdisc7") ? decimal.Zero : row.Field <decimal>("prcdisc7");
entity.prcdisc8 = row.IsNull("prcdisc8") ? decimal.Zero : row.Field <decimal>("prcdisc8");
entity.prcdisc9 = row.IsNull("prcdisc9") ? decimal.Zero : row.Field <decimal>("prcdisc9");
entity.prcdisc21 = row.IsNull("prcdisc21") ? decimal.Zero : row.Field <decimal>("prcdisc21");
entity.prcdisc22 = row.IsNull("prcdisc22") ? decimal.Zero : row.Field <decimal>("prcdisc22");
entity.prcdisc23 = row.IsNull("prcdisc23") ? decimal.Zero : row.Field <decimal>("prcdisc23");
entity.prcdisc24 = row.IsNull("prcdisc24") ? decimal.Zero : row.Field <decimal>("prcdisc24");
entity.prcdisc25 = row.IsNull("prcdisc25") ? decimal.Zero : row.Field <decimal>("prcdisc25");
entity.prcdisc26 = row.IsNull("prcdisc26") ? decimal.Zero : row.Field <decimal>("prcdisc26");
entity.prcdisc27 = row.IsNull("prcdisc27") ? decimal.Zero : row.Field <decimal>("prcdisc27");
entity.prcdisc28 = row.IsNull("prcdisc28") ? decimal.Zero : row.Field <decimal>("prcdisc28");
entity.prcdisc29 = row.IsNull("prcdisc29") ? decimal.Zero : row.Field <decimal>("prcdisc29");
entity.prcdisc31 = row.IsNull("prcdisc31") ? decimal.Zero : row.Field <decimal>("prcdisc31");
entity.prcdisc32 = row.IsNull("prcdisc32") ? decimal.Zero : row.Field <decimal>("prcdisc32");
entity.prcdisc33 = row.IsNull("prcdisc33") ? decimal.Zero : row.Field <decimal>("prcdisc33");
entity.prcdisc34 = row.IsNull("prcdisc34") ? decimal.Zero : row.Field <decimal>("prcdisc34");
entity.prcdisc35 = row.IsNull("prcdisc35") ? decimal.Zero : row.Field <decimal>("prcdisc35");
entity.prcdisc36 = row.IsNull("prcdisc36") ? decimal.Zero : row.Field <decimal>("prcdisc36");
entity.prcdisc37 = row.IsNull("prcdisc37") ? decimal.Zero : row.Field <decimal>("prcdisc37");
entity.prcdisc38 = row.IsNull("prcdisc38") ? decimal.Zero : row.Field <decimal>("prcdisc38");
entity.prcdisc39 = row.IsNull("prcdisc39") ? decimal.Zero : row.Field <decimal>("prcdisc39");
entity.prcdisc41 = row.IsNull("prcdisc41") ? decimal.Zero : row.Field <decimal>("prcdisc41");
entity.prcdisc42 = row.IsNull("prcdisc42") ? decimal.Zero : row.Field <decimal>("prcdisc42");
entity.prcdisc43 = row.IsNull("prcdisc43") ? decimal.Zero : row.Field <decimal>("prcdisc43");
entity.prcdisc44 = row.IsNull("prcdisc44") ? decimal.Zero : row.Field <decimal>("prcdisc44");
entity.prcdisc45 = row.IsNull("prcdisc45") ? decimal.Zero : row.Field <decimal>("prcdisc45");
entity.prcdisc46 = row.IsNull("prcdisc46") ? decimal.Zero : row.Field <decimal>("prcdisc46");
entity.prcdisc47 = row.IsNull("prcdisc47") ? decimal.Zero : row.Field <decimal>("prcdisc47");
entity.prcdisc48 = row.IsNull("prcdisc48") ? decimal.Zero : row.Field <decimal>("prcdisc48");
entity.prcdisc49 = row.IsNull("prcdisc49") ? decimal.Zero : row.Field <decimal>("prcdisc49");
entity.prcdisc51 = row.IsNull("prcdisc51") ? decimal.Zero : row.Field <decimal>("prcdisc51");
entity.prcdisc52 = row.IsNull("prcdisc52") ? decimal.Zero : row.Field <decimal>("prcdisc52");
entity.prcdisc53 = row.IsNull("prcdisc53") ? decimal.Zero : row.Field <decimal>("prcdisc53");
entity.prcdisc54 = row.IsNull("prcdisc54") ? decimal.Zero : row.Field <decimal>("prcdisc54");
entity.prcdisc55 = row.IsNull("prcdisc55") ? decimal.Zero : row.Field <decimal>("prcdisc55");
entity.prcdisc56 = row.IsNull("prcdisc56") ? decimal.Zero : row.Field <decimal>("prcdisc56");
entity.prcdisc57 = row.IsNull("prcdisc57") ? decimal.Zero : row.Field <decimal>("prcdisc57");
entity.prcdisc58 = row.IsNull("prcdisc58") ? decimal.Zero : row.Field <decimal>("prcdisc58");
entity.prcdisc59 = row.IsNull("prcdisc59") ? decimal.Zero : row.Field <decimal>("prcdisc59");
entity.prcdisc61 = row.IsNull("prcdisc61") ? decimal.Zero : row.Field <decimal>("prcdisc61");
entity.prcdisc62 = row.IsNull("prcdisc62") ? decimal.Zero : row.Field <decimal>("prcdisc62");
entity.prcdisc63 = row.IsNull("prcdisc63") ? decimal.Zero : row.Field <decimal>("prcdisc63");
entity.prcdisc64 = row.IsNull("prcdisc64") ? decimal.Zero : row.Field <decimal>("prcdisc64");
entity.prcdisc65 = row.IsNull("prcdisc65") ? decimal.Zero : row.Field <decimal>("prcdisc65");
entity.prcdisc66 = row.IsNull("prcdisc66") ? decimal.Zero : row.Field <decimal>("prcdisc66");
entity.prcdisc67 = row.IsNull("prcdisc67") ? decimal.Zero : row.Field <decimal>("prcdisc67");
entity.prcdisc68 = row.IsNull("prcdisc68") ? decimal.Zero : row.Field <decimal>("prcdisc68");
entity.prcdisc69 = row.IsNull("prcdisc69") ? decimal.Zero : row.Field <decimal>("prcdisc69");
entity.prcmult1 = row.IsNull("prcmult1") ? decimal.Zero : row.Field <decimal>("prcmult1");
entity.prcmult2 = row.IsNull("prcmult2") ? decimal.Zero : row.Field <decimal>("prcmult2");
entity.prcmult3 = row.IsNull("prcmult3") ? decimal.Zero : row.Field <decimal>("prcmult3");
entity.prcmult4 = row.IsNull("prcmult4") ? decimal.Zero : row.Field <decimal>("prcmult4");
entity.prcmult5 = row.IsNull("prcmult5") ? decimal.Zero : row.Field <decimal>("prcmult5");
entity.prcmult6 = row.IsNull("prcmult6") ? decimal.Zero : row.Field <decimal>("prcmult6");
entity.prcmult7 = row.IsNull("prcmult7") ? decimal.Zero : row.Field <decimal>("prcmult7");
entity.prcmult8 = row.IsNull("prcmult8") ? decimal.Zero : row.Field <decimal>("prcmult8");
entity.prcmult9 = row.IsNull("prcmult9") ? decimal.Zero : row.Field <decimal>("prcmult9");
entity.prctype = row.Field <bool>("prctype");
entity.priceEffectiveDate = row.Field <DateTime?>("PriceEffectiveDate");
entity.priceEffectiveDateTo = row.Field <DateTime?>("PriceEffectiveDateTo");
entity.priceonty = row.IsNull("priceonty") ? string.Empty : row.Field <string>("priceonty");
entity.priceSheet = row.IsNull("PriceSheet") ? string.Empty : row.Field <string>("PriceSheet");
entity.priceSheetTo = row.IsNull("PriceSheetTo") ? string.Empty : row.Field <string>("PriceSheetTo");
entity.pricety = row.IsNull("pricety") ? string.Empty : row.Field <string>("pricety");
entity.primarykey = row.IsNull("primarykey") ? string.Empty : row.Field <string>("primarykey");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.proddesc2 = row.IsNull("proddesc2") ? string.Empty : row.Field <string>("proddesc2");
entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline");
entity.prodnotesfl = row.IsNull("prodnotesfl") ? string.Empty : row.Field <string>("prodnotesfl");
entity.prodprcty = row.IsNull("prodprcty") ? string.Empty : row.Field <string>("prodprcty");
entity.promofl = row.Field <bool>("promofl");
entity.pround = row.IsNull("pround") ? string.Empty : row.Field <string>("pround");
entity.ptarget = row.IsNull("ptarget") ? 0 : row.Field <int>("ptarget");
entity.qtybreakty = row.IsNull("qtybreakty") ? string.Empty : row.Field <string>("qtybreakty");
entity.qtybrk1 = row.IsNull("qtybrk1") ? 0 : row.Field <int>("qtybrk1");
entity.qtybrk2 = row.IsNull("qtybrk2") ? 0 : row.Field <int>("qtybrk2");
entity.qtybrk3 = row.IsNull("qtybrk3") ? 0 : row.Field <int>("qtybrk3");
entity.qtybrk4 = row.IsNull("qtybrk4") ? 0 : row.Field <int>("qtybrk4");
entity.qtybrk5 = row.IsNull("qtybrk5") ? 0 : row.Field <int>("qtybrk5");
entity.qtybrk6 = row.IsNull("qtybrk6") ? 0 : row.Field <int>("qtybrk6");
entity.qtybrk7 = row.IsNull("qtybrk7") ? 0 : row.Field <int>("qtybrk7");
entity.qtybrk8 = row.IsNull("qtybrk8") ? 0 : row.Field <int>("qtybrk8");
entity.qtytype = row.IsNull("qtytype") ? string.Empty : row.Field <string>("qtytype");
entity.qtyyymm = row.IsNull("qtyyymm") ? string.Empty : row.Field <string>("qtyyymm");
entity.quotefl = row.Field <bool>("quotefl");
entity.quoteno = row.IsNull("quoteno") ? string.Empty : row.Field <string>("quoteno");
entity.rebateamt = row.IsNull("rebateamt") ? decimal.Zero : row.Field <decimal>("rebateamt");
entity.rebatecd = row.IsNull("rebatecd") ? string.Empty : row.Field <string>("rebatecd");
entity.rebatecost = row.IsNull("rebatecost") ? decimal.Zero : row.Field <decimal>("rebatecost");
entity.rebatecostty = row.IsNull("rebatecostty") ? string.Empty : row.Field <string>("rebatecostty");
entity.rebatepct = row.IsNull("rebatepct") ? decimal.Zero : row.Field <decimal>("rebatepct");
entity.rebatety = row.IsNull("rebatety") ? string.Empty : row.Field <string>("rebatety");
entity.rebcalcty = row.IsNull("rebcalcty") ? string.Empty : row.Field <string>("rebcalcty");
entity.rebdowntoty = row.IsNull("rebdowntoty") ? string.Empty : row.Field <string>("rebdowntoty");
entity.rebrecno = row.IsNull("rebrecno") ? decimal.Zero : row.Field <decimal>("rebrecno");
entity.rebsubty = row.IsNull("rebsubty") ? string.Empty : row.Field <string>("rebsubty");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.replcost = row.IsNull("replcost") ? decimal.Zero : row.Field <decimal>("replcost");
entity.seqNo = row.IsNull("SeqNo") ? decimal.Zero : row.Field <decimal>("SeqNo");
entity.setID = row.IsNull("SetID") ? string.Empty : row.Field <string>("SetID");
entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno");
entity.shiptonotesfl = row.IsNull("shiptonotesfl") ? string.Empty : row.Field <string>("shiptonotesfl");
entity.sortkey = row.IsNull("sortkey") ? string.Empty : row.Field <string>("sortkey");
entity.source = row.IsNull("source") ? string.Empty : row.Field <string>("source");
entity.startdt = row.Field <DateTime?>("startdt");
entity.statustype = row.IsNull("statustype") ? string.Empty : row.Field <string>("statustype");
entity.stndcost = row.IsNull("stndcost") ? decimal.Zero : row.Field <decimal>("stndcost");
entity.taxprice = row.IsNull("taxprice") ? decimal.Zero : row.Field <decimal>("taxprice");
entity.termsdiscfl = row.Field <bool>("termsdiscfl");
entity.termspct = row.IsNull("termspct") ? decimal.Zero : row.Field <decimal>("termspct");
entity.touchedfl = row.Field <bool>("touchedfl");
entity.transdt = row.Field <DateTime?>("transdt");
entity.transproc = row.IsNull("transproc") ? string.Empty : row.Field <string>("transproc");
entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
entity.typecode = row.IsNull("Typecode") ? string.Empty : row.Field <string>("Typecode");
entity.units = row.IsNull("units") ? string.Empty : row.Field <string>("units");
entity.updttype = row.Field <bool>("updttype");
entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1");
entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2");
entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3");
entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4");
entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5");
entity.user6 = row.Field <decimal?>("user6");
entity.user7 = row.Field <decimal?>("user7");
entity.user8 = row.Field <DateTime?>("user8");
entity.user9 = row.Field <DateTime?>("user9");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.vendnotesfl = row.IsNull("vendnotesfl") ? string.Empty : row.Field <string>("vendnotesfl");
entity.vendorprice = row.IsNull("vendorprice") ? decimal.Zero : row.Field <decimal>("vendorprice");
entity.vendprod = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
entity.vendquote = row.IsNull("vendquote") ? string.Empty : row.Field <string>("vendquote");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.xrefprod = row.IsNull("xrefprod") ? string.Empty : row.Field <string>("xrefprod");
entity.rebatedesc = row.IsNull("rebatedesc") ? string.Empty : row.Field <string>("rebatedesc");
entity.dropshiptydesc = row.IsNull("dropshiptydesc") ? string.Empty : row.Field <string>("dropshiptydesc");
entity.contractlineno = row.IsNull("contractlineno") ? 0 : row.Field <int>("contractlineno");
entity.sharefl = row.Field <bool>("sharefl");
entity.manualfl = row.Field <bool>("manualfl");
return(entity);
}