/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSledgetproddetailresults(ref DataRow row, Sledgetproddetailresults entity) { row.SetField("sledrowid", entity.sledrowid.ToByteArray()); row.SetField("prod", entity.prod); row.SetField("whse", entity.whse); row.SetField("statuscd", entity.statuscd); row.SetField("action", entity.action); row.SetField("statustype", entity.statustype); row.SetField("descrip1", entity.descrip1); row.SetField("descrip2", entity.descrip2); row.SetField("descrip3", entity.descrip3); row.SetField("vendno", entity.vendno); row.SetField("vendname", entity.vendname); row.SetField("slpbseqno", entity.slpbseqno); row.SetField("notesfl", entity.notesfl); row.SetField("lookupnm", entity.lookupnm); row.SetField("seqno", entity.seqno); row.SetField("baseprice", entity.baseprice); row.SetField("icscfl", entity.icscfl); row.SetField("listprice", entity.listprice); row.SetField("icspfl", entity.icspfl); row.SetField("stndcost", entity.stndcost); row.SetField("icswfl", entity.icswfl); row.SetField("replcost", entity.replcost); row.SetField("lastcostfor", entity.lastcostfor); row.SetField("prodline", entity.prodline); row.SetField("prodlinedesc", entity.prodlinedesc); row.SetField("unitstock", entity.unitstock); row.SetField("unitstnd", entity.unitstnd); row.SetField("prodcat", entity.prodcat); row.SetField("prodcatdesc", entity.prodcatdesc); row.SetField("termspct", entity.termspct); row.SetField("pricetype", entity.pricetype); row.SetField("pricetypedesc", entity.pricetypedesc); row.SetField("priceonty", entity.priceonty); row.SetField("slgroup", entity.slgroup); row.SetField("cubes", entity.cubes); row.SetField("weight", entity.weight); row.SetField("effectdt", entity.effectdt); row.SetField("costtext", entity.costtext); row.SetField("slspeccostty", entity.slspeccostty); row.SetField("slprccostper", entity.slprccostper); row.SetField("originty", entity.originty); row.SetField("slproduct", entity.slproduct); row.SetField("sldescrip1", entity.sldescrip1); row.SetField("sldescrip2", entity.sldescrip2); row.SetField("sldescrip3", entity.sldescrip3); row.SetField("slunit", entity.slunit); row.SetField("imptype", entity.imptype); row.SetField("slcat", entity.slcat); row.SetField("sloriginty", entity.sloriginty); row.SetField("sllinecd", entity.sllinecd); row.SetField("slvendcd", entity.slvendcd); row.SetField("sllist", entity.sllist); row.SetField("slcost", entity.slcost); row.SetField("slmsdsfl", entity.slmsdsfl); row.SetField("slmsdssheetno", entity.slmsdssheetno); row.SetField("slcsunperstk", entity.slcsunperstk); row.SetField("slexchgrate1", entity.slexchgrate1); row.SetField("slexchgrate2", entity.slexchgrate2); row.SetField("slcurrencyty", entity.slcurrencyty); row.SetField("sleditfl", entity.sleditfl); row.SetField("upcno", entity.upcno); row.SetField("slupdttype", entity.slupdttype); row.SetField("tsupdtdsc", entity.tsupdtdsc); row.SetField("slaltprod", entity.slaltprod); row.SetField("idwdatapos", entity.idwdatapos); row.SetField("userfield", entity.userfield); row.SetField("slprceffdt", entity.slprceffdt); row.SetField("slprcexpdt", entity.slprcexpdt); row.SetField("slunspsc", entity.slunspsc); row.SetField("pdscfl", entity.pdscfl); row.SetField("pdsvfl", entity.pdsvfl); row.SetField("slpricebrk1", entity.slpricebrk1); row.SetField("slpricebrk2", entity.slpricebrk2); row.SetField("slpricebrk3", entity.slpricebrk3); row.SetField("slpricebrk4", entity.slpricebrk4); row.SetField("slpricebrk5", entity.slpricebrk5); row.SetField("slpricebrk6", entity.slpricebrk6); row.SetField("slpricebrk7", entity.slpricebrk7); row.SetField("slpricebrk8", entity.slpricebrk8); row.SetField("slpricebrk9", entity.slpricebrk9); row.SetField("slcostbrk1", entity.slcostbrk1); row.SetField("slcostbrk2", entity.slcostbrk2); row.SetField("slcostbrk3", entity.slcostbrk3); row.SetField("slcostbrk4", entity.slcostbrk4); row.SetField("slcostbrk5", entity.slcostbrk5); row.SetField("slcostbrk6", entity.slcostbrk6); row.SetField("slcostbrk7", entity.slcostbrk7); row.SetField("slcostbrk8", entity.slcostbrk8); row.SetField("slcostbrk9", entity.slcostbrk9); row.SetField("slqtybrk1", entity.slqtybrk1); row.SetField("slqtybrk2", entity.slqtybrk2); row.SetField("slqtybrk3", entity.slqtybrk3); row.SetField("slqtybrk4", entity.slqtybrk4); row.SetField("slqtybrk5", entity.slqtybrk5); row.SetField("slqtybrk6", entity.slqtybrk6); row.SetField("slqtybrk7", entity.slqtybrk7); row.SetField("slqtybrk8", entity.slqtybrk8); row.SetField("slsupersede", entity.slsupersede); row.SetField("slxref1", entity.slxref1); row.SetField("slxref2", entity.slxref2); row.SetField("slxref3", entity.slxref3); row.SetField("slxref4", entity.slxref4); 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("rebatety", entity.rebatety); row.SetField("rebatetydesc", entity.rebatetydesc); row.SetField("rebsubty", entity.rebsubty); row.SetField("rebsubtydesc", entity.rebsubtydesc); }
public static Sledgetproddetailresults BuildSledgetproddetailresultsFromRow(DataRow row) { Sledgetproddetailresults entity = new Sledgetproddetailresults(); entity.sledrowid = row.Field <byte[]>("sledrowid").ToStringEncoded(); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.statuscd = row.IsNull("statuscd") ? string.Empty : row.Field <string>("statuscd"); entity.action = row.IsNull("action") ? string.Empty : row.Field <string>("action"); entity.statustype = row.Field <bool>("statustype"); entity.descrip1 = row.IsNull("descrip1") ? string.Empty : row.Field <string>("descrip1"); entity.descrip2 = row.IsNull("descrip2") ? string.Empty : row.Field <string>("descrip2"); entity.descrip3 = row.IsNull("descrip3") ? string.Empty : row.Field <string>("descrip3"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.vendname = row.IsNull("vendname") ? string.Empty : row.Field <string>("vendname"); entity.slpbseqno = row.IsNull("slpbseqno") ? 0 : row.Field <int>("slpbseqno"); entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl"); entity.lookupnm = row.IsNull("lookupnm") ? string.Empty : row.Field <string>("lookupnm"); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); entity.baseprice = row.IsNull("baseprice") ? decimal.Zero : row.Field <decimal>("baseprice"); entity.icscfl = row.Field <bool>("icscfl"); entity.listprice = row.IsNull("listprice") ? decimal.Zero : row.Field <decimal>("listprice"); entity.icspfl = row.Field <bool>("icspfl"); entity.stndcost = row.IsNull("stndcost") ? decimal.Zero : row.Field <decimal>("stndcost"); entity.icswfl = row.Field <bool>("icswfl"); entity.replcost = row.IsNull("replcost") ? decimal.Zero : row.Field <decimal>("replcost"); entity.lastcostfor = row.IsNull("lastcostfor") ? decimal.Zero : row.Field <decimal>("lastcostfor"); entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline"); entity.prodlinedesc = row.IsNull("prodlinedesc") ? string.Empty : row.Field <string>("prodlinedesc"); entity.unitstock = row.IsNull("unitstock") ? string.Empty : row.Field <string>("unitstock"); entity.unitstnd = row.IsNull("unitstnd") ? string.Empty : row.Field <string>("unitstnd"); entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat"); entity.prodcatdesc = row.IsNull("prodcatdesc") ? string.Empty : row.Field <string>("prodcatdesc"); entity.termspct = row.IsNull("termspct") ? decimal.Zero : row.Field <decimal>("termspct"); entity.pricetype = row.IsNull("pricetype") ? string.Empty : row.Field <string>("pricetype"); entity.pricetypedesc = row.IsNull("pricetypedesc") ? string.Empty : row.Field <string>("pricetypedesc"); entity.priceonty = row.IsNull("priceonty") ? string.Empty : row.Field <string>("priceonty"); entity.slgroup = row.IsNull("slgroup") ? string.Empty : row.Field <string>("slgroup"); entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes"); entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field <decimal>("weight"); entity.effectdt = row.Field <DateTime?>("effectdt"); entity.costtext = row.IsNull("costtext") ? string.Empty : row.Field <string>("costtext"); entity.slspeccostty = row.IsNull("slspeccostty") ? string.Empty : row.Field <string>("slspeccostty"); entity.slprccostper = row.IsNull("slprccostper") ? string.Empty : row.Field <string>("slprccostper"); entity.originty = row.IsNull("originty") ? string.Empty : row.Field <string>("originty"); entity.slproduct = row.IsNull("slproduct") ? string.Empty : row.Field <string>("slproduct"); entity.sldescrip1 = row.IsNull("sldescrip1") ? string.Empty : row.Field <string>("sldescrip1"); entity.sldescrip2 = row.IsNull("sldescrip2") ? string.Empty : row.Field <string>("sldescrip2"); entity.sldescrip3 = row.IsNull("sldescrip3") ? string.Empty : row.Field <string>("sldescrip3"); entity.slunit = row.IsNull("slunit") ? string.Empty : row.Field <string>("slunit"); entity.imptype = row.IsNull("imptype") ? string.Empty : row.Field <string>("imptype"); entity.slcat = row.IsNull("slcat") ? string.Empty : row.Field <string>("slcat"); entity.sloriginty = row.IsNull("sloriginty") ? string.Empty : row.Field <string>("sloriginty"); entity.sllinecd = row.IsNull("sllinecd") ? string.Empty : row.Field <string>("sllinecd"); entity.slvendcd = row.IsNull("slvendcd") ? string.Empty : row.Field <string>("slvendcd"); entity.sllist = row.IsNull("sllist") ? decimal.Zero : row.Field <decimal>("sllist"); entity.slcost = row.IsNull("slcost") ? decimal.Zero : row.Field <decimal>("slcost"); entity.slmsdsfl = row.Field <bool>("slmsdsfl"); entity.slmsdssheetno = row.IsNull("slmsdssheetno") ? string.Empty : row.Field <string>("slmsdssheetno"); entity.slcsunperstk = row.IsNull("slcsunperstk") ? decimal.Zero : row.Field <decimal>("slcsunperstk"); entity.slexchgrate1 = row.IsNull("slexchgrate1") ? decimal.Zero : row.Field <decimal>("slexchgrate1"); entity.slexchgrate2 = row.IsNull("slexchgrate2") ? decimal.Zero : row.Field <decimal>("slexchgrate2"); entity.slcurrencyty = row.IsNull("slcurrencyty") ? string.Empty : row.Field <string>("slcurrencyty"); entity.sleditfl = row.Field <bool>("sleditfl"); entity.upcno = row.IsNull("upcno") ? string.Empty : row.Field <string>("upcno"); entity.slupdttype = row.IsNull("slupdttype") ? string.Empty : row.Field <string>("slupdttype"); entity.tsupdtdsc = row.IsNull("tsupdtdsc") ? string.Empty : row.Field <string>("tsupdtdsc"); entity.slaltprod = row.IsNull("slaltprod") ? string.Empty : row.Field <string>("slaltprod"); entity.idwdatapos = row.IsNull("idwdatapos") ? string.Empty : row.Field <string>("idwdatapos"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); entity.slprceffdt = row.Field <DateTime?>("slprceffdt"); entity.slprcexpdt = row.Field <DateTime?>("slprcexpdt"); entity.slunspsc = row.IsNull("slunspsc") ? string.Empty : row.Field <string>("slunspsc"); entity.pdscfl = row.Field <bool>("pdscfl"); entity.pdsvfl = row.Field <bool>("pdsvfl"); entity.slpricebrk1 = row.IsNull("slpricebrk1") ? decimal.Zero : row.Field <decimal>("slpricebrk1"); entity.slpricebrk2 = row.IsNull("slpricebrk2") ? decimal.Zero : row.Field <decimal>("slpricebrk2"); entity.slpricebrk3 = row.IsNull("slpricebrk3") ? decimal.Zero : row.Field <decimal>("slpricebrk3"); entity.slpricebrk4 = row.IsNull("slpricebrk4") ? decimal.Zero : row.Field <decimal>("slpricebrk4"); entity.slpricebrk5 = row.IsNull("slpricebrk5") ? decimal.Zero : row.Field <decimal>("slpricebrk5"); entity.slpricebrk6 = row.IsNull("slpricebrk6") ? decimal.Zero : row.Field <decimal>("slpricebrk6"); entity.slpricebrk7 = row.IsNull("slpricebrk7") ? decimal.Zero : row.Field <decimal>("slpricebrk7"); entity.slpricebrk8 = row.IsNull("slpricebrk8") ? decimal.Zero : row.Field <decimal>("slpricebrk8"); entity.slpricebrk9 = row.IsNull("slpricebrk9") ? decimal.Zero : row.Field <decimal>("slpricebrk9"); entity.slcostbrk1 = row.IsNull("slcostbrk1") ? decimal.Zero : row.Field <decimal>("slcostbrk1"); entity.slcostbrk2 = row.IsNull("slcostbrk2") ? decimal.Zero : row.Field <decimal>("slcostbrk2"); entity.slcostbrk3 = row.IsNull("slcostbrk3") ? decimal.Zero : row.Field <decimal>("slcostbrk3"); entity.slcostbrk4 = row.IsNull("slcostbrk4") ? decimal.Zero : row.Field <decimal>("slcostbrk4"); entity.slcostbrk5 = row.IsNull("slcostbrk5") ? decimal.Zero : row.Field <decimal>("slcostbrk5"); entity.slcostbrk6 = row.IsNull("slcostbrk6") ? decimal.Zero : row.Field <decimal>("slcostbrk6"); entity.slcostbrk7 = row.IsNull("slcostbrk7") ? decimal.Zero : row.Field <decimal>("slcostbrk7"); entity.slcostbrk8 = row.IsNull("slcostbrk8") ? decimal.Zero : row.Field <decimal>("slcostbrk8"); entity.slcostbrk9 = row.IsNull("slcostbrk9") ? decimal.Zero : row.Field <decimal>("slcostbrk9"); entity.slqtybrk1 = row.IsNull("slqtybrk1") ? decimal.Zero : row.Field <decimal>("slqtybrk1"); entity.slqtybrk2 = row.IsNull("slqtybrk2") ? decimal.Zero : row.Field <decimal>("slqtybrk2"); entity.slqtybrk3 = row.IsNull("slqtybrk3") ? decimal.Zero : row.Field <decimal>("slqtybrk3"); entity.slqtybrk4 = row.IsNull("slqtybrk4") ? decimal.Zero : row.Field <decimal>("slqtybrk4"); entity.slqtybrk5 = row.IsNull("slqtybrk5") ? decimal.Zero : row.Field <decimal>("slqtybrk5"); entity.slqtybrk6 = row.IsNull("slqtybrk6") ? decimal.Zero : row.Field <decimal>("slqtybrk6"); entity.slqtybrk7 = row.IsNull("slqtybrk7") ? decimal.Zero : row.Field <decimal>("slqtybrk7"); entity.slqtybrk8 = row.IsNull("slqtybrk8") ? decimal.Zero : row.Field <decimal>("slqtybrk8"); entity.slsupersede = row.IsNull("slsupersede") ? string.Empty : row.Field <string>("slsupersede"); entity.slxref1 = row.IsNull("slxref1") ? string.Empty : row.Field <string>("slxref1"); entity.slxref2 = row.IsNull("slxref2") ? string.Empty : row.Field <string>("slxref2"); entity.slxref3 = row.IsNull("slxref3") ? string.Empty : row.Field <string>("slxref3"); entity.slxref4 = row.IsNull("slxref4") ? string.Empty : row.Field <string>("slxref4"); 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.rebatety = row.IsNull("rebatety") ? string.Empty : row.Field <string>("rebatety"); entity.rebatetydesc = row.IsNull("rebatetydesc") ? string.Empty : row.Field <string>("rebatetydesc"); entity.rebsubty = row.IsNull("rebsubty") ? string.Empty : row.Field <string>("rebsubty"); entity.rebsubtydesc = row.IsNull("rebsubtydesc") ? string.Empty : row.Field <string>("rebsubtydesc"); return(entity); }