Esempio n. 1
0
 /// <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);
 }
Esempio n. 2
0
 /// <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());
 }