Exemple #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, WtelBase entity)
 {
     row.SetField("wtno", entity.wtno);
     row.SetField("wtsuf", entity.wtsuf);
     row.SetField("lineno", entity.lineno);
     row.SetField("wtelRowID", entity.rowID.ToByteArray());
     row.SetField("rowpointer", entity.rowpointer);
 }
Exemple #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromWtelBase(ref DataRow row, WtelBase entity)
 {
     row.SetField("wtno", entity.wtno);
     row.SetField("wtsuf", entity.wtsuf);
     row.SetField("shipfmwhse", entity.shipfmwhse);
     row.SetField("transtype", entity.transtype);
     row.SetField("lineno", entity.lineno);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("cono", entity.cono);
     row.SetField("unit", entity.unit);
     row.SetField("transdt", entity.transdt);
     row.SetField("enterdt", entity.enterdt);
     row.SetField("operinit", entity.operinit);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("transtm", entity.transtm);
     row.SetField("stkqtyship", entity.stkqtyship);
     row.SetField("prodcost", entity.prodcost);
     row.SetField("prodcati", entity.prodcati);
     row.SetField("usagefl", entity.usagefl);
     row.SetField("ordertype", entity.ordertype);
     row.SetField("weight", entity.weight);
     row.SetField("cubes", entity.cubes);
     row.SetField("qtyfmrcvs", entity.qtyfmrcvs);
     row.SetField("ostkqtyship", entity.ostkqtyship);
     row.SetField("qtyactship", entity.qtyactship);
     row.SetField("notimeschg", entity.notimeschg);
     row.SetField("statustype", entity.statustype);
     row.SetField("proddesc2", entity.proddesc2);
     row.SetField("leadoverty", entity.leadoverty);
     row.SetField("icspecrecno", entity.icspecrecno);
     row.SetField("printfl", entity.printfl);
     row.SetField("chrgqtyi", entity.chrgqtyi);
     row.SetField("bono", entity.bono);
     row.SetField("costoverfl", entity.costoverfl);
     row.SetField("user3", entity.user3);
     row.SetField("user4", entity.user4);
     row.SetField("user5", entity.user5);
     row.SetField("user6", entity.user6);
     row.SetField("nosnlotsi", entity.nosnlotsi);
     row.SetField("user7", entity.user7);
     row.SetField("user8", entity.user8);
     row.SetField("user9", entity.user9);
     row.SetField("prevqtyshp", entity.prevqtyshp);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("catwtfli", entity.catwtfli);
     row.SetField("bofl", entity.bofl);
     row.SetField("qtyship", entity.qtyship);
     row.SetField("duedt", entity.duedt);
     row.SetField("arpoverfl", entity.arpoverfl);
     row.SetField("cono2", entity.cono2);
     row.SetField("shiptowhse", entity.shiptowhse);
     row.SetField("netamt", entity.netamt);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("approvety", entity.approvety);
     row.SetField("approvedt", entity.approvedt);
     row.SetField("approveinit", entity.approveinit);
     row.SetField("chrgqtyo", entity.chrgqtyo);
     row.SetField("netrcv", entity.netrcv);
     row.SetField("prodcato", entity.prodcato);
     row.SetField("qtyrcv", entity.qtyrcv);
     row.SetField("stkqtyrcv", entity.stkqtyrcv);
     row.SetField("catwtflo", entity.catwtflo);
     row.SetField("linealtno", entity.linealtno);
     row.SetField("orderaltno", entity.orderaltno);
     row.SetField("nosnlotso", entity.nosnlotso);
     row.SetField("nonstockty", entity.nonstockty);
     row.SetField("binloc", entity.binloc);
     row.SetField("reqprod", entity.reqprod);
     row.SetField("xrefprodty", entity.xrefprodty);
     row.SetField("vendno", entity.vendno);
     row.SetField("prodline", entity.prodline);
     row.SetField("prodinrcvfl", entity.prodinrcvfl);
     row.SetField("netord", entity.netord);
     row.SetField("qtyunavail", entity.qtyunavail);
     row.SetField("reasunavty", entity.reasunavty);
     row.SetField("delayresrvfl", entity.delayresrvfl);
     row.SetField("glcostrcv", entity.glcostrcv);
     row.SetField("lastbofl", entity.lastbofl);
     row.SetField("glcostexc", entity.glcostexc);
     row.SetField("user1", entity.user1);
     row.SetField("user2", entity.user2);
     row.SetField("addonamt", entity.addonamt);
     row.SetField("wmqtyship", entity.wmqtyship);
     row.SetField("wmqtyrcv", entity.wmqtyrcv);
     row.SetField("unitconv", entity.unitconv);
     row.SetField("transproc", entity.transproc);
     row.SetField("user10", entity.user10);
     row.SetField("user11", entity.user11);
     row.SetField("user12", entity.user12);
     row.SetField("user13", entity.user13);
     row.SetField("user14", entity.user14);
     row.SetField("user15", entity.user15);
     row.SetField("user16", entity.user16);
     row.SetField("user17", entity.user17);
     row.SetField("user18", entity.user18);
     row.SetField("user19", entity.user19);
     row.SetField("user20", entity.user20);
     row.SetField("user21", entity.user21);
     row.SetField("user22", entity.user22);
     row.SetField("user23", entity.user23);
     row.SetField("user24", entity.user24);
     row.SetField("custstkqtyshp", entity.custstkqtyshp);
     row.SetField("custprodcost", entity.custprodcost);
     row.SetField("cutfl", entity.cutfl);
     row.SetField("cutlossamt", entity.cutlossamt);
     row.SetField("scraplossamt", entity.scraplossamt);
     row.SetField("rowpointer", entity.rowpointer);
     row.SetField("transdttmz", entity.transdttmz);
     row.SetField("wtelRowID", entity.rowID.ToByteArray());
 }