public static Sledgetprodlistresults BuildSledgetprodlistresultsFromRow(DataRow row) { Sledgetprodlistresults entity = new Sledgetprodlistresults(); 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.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.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.termspct = row.IsNull("termspct") ? decimal.Zero : row.Field <decimal>("termspct"); entity.pricetype = row.IsNull("pricetype") ? string.Empty : row.Field <string>("pricetype"); 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.morerecords = row.Field <bool>("morerecords"); 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 UpdateRowFromSledgetprodlistresults(ref DataRow row, Sledgetprodlistresults 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("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("unitstock", entity.unitstock); row.SetField("unitstnd", entity.unitstnd); row.SetField("prodcat", entity.prodcat); row.SetField("termspct", entity.termspct); row.SetField("pricetype", entity.pricetype); 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("morerecords", entity.morerecords); row.SetField("userfield", entity.userfield); }