/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, SledBase entity) { row.SetField("sledRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSledBase(ref DataRow row, SledBase entity) { row.SetField("baseprice", entity.baseprice); row.SetField("cono", entity.cono); row.SetField("cubes", entity.cubes); row.SetField("descrip1", entity.descrip1); row.SetField("descrip2", entity.descrip2); row.SetField("icscfl", entity.icscfl); row.SetField("icspfl", entity.icspfl); row.SetField("icswfl", entity.icswfl); row.SetField("imptype", entity.imptype); row.SetField("listprice", entity.listprice); row.SetField("lookupnm", entity.lookupnm); row.SetField("notesfl", entity.notesfl); row.SetField("operinit", entity.operinit); row.SetField("priceonty", entity.priceonty); row.SetField("pricetype", entity.pricetype); row.SetField("prod", entity.prod); row.SetField("prodcat", entity.prodcat); row.SetField("prodline", entity.prodline); row.SetField("replcost", entity.replcost); row.SetField("seqno", entity.seqno); row.SetField("slaltprod", entity.slaltprod); row.SetField("slcat", entity.slcat); row.SetField("slcost", entity.slcost); row.SetField("slcsunperstk", entity.slcsunperstk); row.SetField("slcurrencyty", entity.slcurrencyty); row.SetField("sldescrip1", entity.sldescrip1); row.SetField("sldescrip2", entity.sldescrip2); row.SetField("sleditfl", entity.sleditfl); row.SetField("slexchgrate1", entity.slexchgrate1); row.SetField("slexchgrate2", entity.slexchgrate2); row.SetField("slgroup", entity.slgroup); row.SetField("sllinecd", entity.sllinecd); row.SetField("sllist", entity.sllist); row.SetField("slmsdsfl", entity.slmsdsfl); row.SetField("slmsdssheetno", entity.slmsdssheetno); row.SetField("sloriginty", entity.sloriginty); row.SetField("slpbseqno", entity.slpbseqno); row.SetField("slprccostper", entity.slprccostper); row.SetField("slproduct", entity.slproduct); row.SetField("slspeccostty", entity.slspeccostty); row.SetField("slunit", entity.slunit); row.SetField("slupdtno", entity.slupdtno); row.SetField("slupdttype", entity.slupdttype); row.SetField("slvendcd", entity.slvendcd); row.SetField("slxref1", entity.slxref1); row.SetField("slxref2", entity.slxref2); row.SetField("statuscd", entity.statuscd); row.SetField("statustype", entity.statustype); row.SetField("stndcost", entity.stndcost); row.SetField("termspct", entity.termspct); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("unitstock", entity.unitstock); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("whse", entity.whse); row.SetField("weight", entity.weight); row.SetField("slsupersede", entity.slsupersede); row.SetField("effectdt", entity.effectdt); 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("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("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("slxref3", entity.slxref3); row.SetField("slxref4", entity.slxref4); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("vendno", entity.vendno); row.SetField("idwdatapos", entity.idwdatapos); row.SetField("slunspsc", entity.slunspsc); row.SetField("rebsubty", entity.rebsubty); row.SetField("rebatety", entity.rebatety); row.SetField("errorcd", entity.errorcd); row.SetField("holdcd", entity.holdcd); row.SetField("slprceffdt", entity.slprceffdt); row.SetField("slprcexpdt", entity.slprcexpdt); row.SetField("lastcostfor", entity.lastcostfor); row.SetField("rebatecost", entity.rebatecost); row.SetField("pdscfl", entity.pdscfl); row.SetField("pdsvfl", entity.pdsvfl); row.SetField("transproc", entity.transproc); row.SetField("unitstnd", entity.unitstnd); row.SetField("unitconv", entity.unitconv); row.SetField("rowpointer", entity.rowpointer); row.SetField("descrip3", entity.descrip3); row.SetField("sldescrip3", entity.sldescrip3); row.SetField("sledRowID", entity.rowID.ToByteArray()); }