Beispiel #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, PvShoplistBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("oper2", entity.oper2);
     row.SetField("prod", entity.prod);
     row.SetField("pv_shoplistRowID", entity.rowID.ToByteArray());
 }
Beispiel #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPvShoplistBase(ref DataRow row, PvShoplistBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("oper2", entity.oper2);
     row.SetField("prod", entity.prod);
     row.SetField("dsplprod", entity.dsplprod);
     row.SetField("addswoptprodfl", entity.addswoptprodfl);
     row.SetField("chrg", entity.chrg);
     row.SetField("cubes", entity.cubes);
     row.SetField("descrip", entity.descrip);
     row.SetField("descrip2", entity.descrip2);
     row.SetField("icspecrecno", entity.icspecrecno);
     row.SetField("speccostty", entity.speccostty);
     row.SetField("csunperstk", entity.csunperstk);
     row.SetField("prccostper", entity.prccostper);
     row.SetField("discamt", entity.discamt);
     row.SetField("discoverfl", entity.discoverfl);
     row.SetField("disctype", entity.disctype);
     row.SetField("extra-1", entity.extra1);
     row.SetField("extra-2", entity.extra2);
     row.SetField("lastpurdt", entity.lastpurdt);
     row.SetField("lastprice", entity.lastprice);
     row.SetField("lookupnm", entity.lookupnm);
     row.SetField("marginamt", entity.marginamt);
     row.SetField("marginpct", entity.marginpct);
     row.SetField("netord", entity.netord);
     row.SetField("netrecommend", entity.netrecommend);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("pdrecno", entity.pdrecno);
     row.SetField("pdsvfl", entity.pdsvfl);
     row.SetField("arpprodline", entity.arpprodline);
     row.SetField("price", entity.price);
     row.SetField("priceoverfl", entity.priceoverfl);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("prodcost", entity.prodcost);
     row.SetField("qtyavail", entity.qtyavail);
     row.SetField("qtybreakty", entity.qtybreakty);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("qtyrecommend", entity.qtyrecommend);
     row.SetField("seasontype", entity.seasontype);
     row.SetField("specnstype", entity.specnstype);
     row.SetField("specconv", entity.specconv);
     row.SetField("statmessage", entity.statmessage);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("stkqtyrecommend", entity.stkqtyrecommend);
     row.SetField("totalstkqty", entity.totalstkqty);
     row.SetField("unit", entity.unit);
     row.SetField("unitconv", entity.unitconv);
     row.SetField("weight", entity.weight);
     row.SetField("whse", entity.whse);
     row.SetField("seqno", entity.seqno);
     row.SetField("optionalwords", entity.optionalwords);
     row.SetField("arpvendno", entity.arpvendno);
     row.SetField("transdt", entity.transdt);
     row.SetField("transtm", entity.transtm);
     row.SetField("transproc", entity.transproc);
     row.SetField("operinit", entity.operinit);
     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("contractno", entity.contractno);
     row.SetField("pdsvcrecno", entity.pdsvcrecno);
     row.SetField("dsplqtyavail", entity.dsplqtyavail);
     row.SetField("custreservefoundfl", entity.custreservefoundfl);
     row.SetField("pv_shoplistRowID", entity.rowID.ToByteArray());
 }