Example #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPdgetpdscrecordsresults(ref DataRow row, Pdgetpdscrecordsresults 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("lastuseddt", entity.lastuseddt);
     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);
 }
Example #2
0
        public static Pdgetpdscrecordsresults BuildPdgetpdscrecordsresultsFromRow(DataRow row)
        {
            Pdgetpdscrecordsresults entity = new Pdgetpdscrecordsresults();

            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.lastuseddt           = row.Field <DateTime?>("lastuseddt");
            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");
            return(entity);
        }