Пример #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, OeelbBase entity)
 {
     row.SetField("lineno", entity.lineno);
     row.SetField("cono", entity.cono);
     row.SetField("batchnm", entity.batchnm);
     row.SetField("seqno", entity.seqno);
     row.SetField("oeelbRowID", entity.rowID.ToByteArray());
 }
Пример #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromOeelbBase(ref DataRow row, OeelbBase entity)
 {
     row.SetField("lineno", entity.lineno);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("cono", entity.cono);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("unit", entity.unit);
     row.SetField("price", entity.price);
     row.SetField("transdt", entity.transdt);
     row.SetField("enterdt", entity.enterdt);
     row.SetField("operinit", entity.operinit);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("discamt", entity.discamt);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("transtm", entity.transtm);
     row.SetField("prodcost", entity.prodcost);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("prodline", entity.prodline);
     row.SetField("vendno", entity.vendno);
     row.SetField("usagefl", entity.usagefl);
     row.SetField("ordertype", entity.ordertype);
     row.SetField("botype", entity.botype);
     row.SetField("netamt", entity.netamt);
     row.SetField("corechgty", entity.corechgty);
     row.SetField("specnstype", entity.specnstype);
     row.SetField("user1", entity.user1);
     row.SetField("user2", entity.user2);
     row.SetField("leadtm", entity.leadtm);
     row.SetField("proddesc2", entity.proddesc2);
     row.SetField("pricetype", entity.pricetype);
     row.SetField("priceoverfl", entity.priceoverfl);
     row.SetField("xrefprodty", entity.xrefprodty);
     row.SetField("reqprod", entity.reqprod);
     row.SetField("bplineno", entity.bplineno);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("rushfl", entity.rushfl);
     row.SetField("user3", entity.user3);
     row.SetField("user4", entity.user4);
     row.SetField("user5", entity.user5);
     row.SetField("chrgqty", entity.chrgqty);
     row.SetField("user6", entity.user6);
     row.SetField("user7", entity.user7);
     row.SetField("user8", entity.user8);
     row.SetField("user9", entity.user9);
     row.SetField("returnfl", entity.returnfl);
     row.SetField("taxablefl", entity.taxablefl);
     row.SetField("disctype", entity.disctype);
     row.SetField("corecharge", entity.corecharge);
     row.SetField("reasunavty", entity.reasunavty);
     row.SetField("datccost", entity.datccost);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("slsrepin", entity.slsrepin);
     row.SetField("slsrepout", entity.slsrepout);
     row.SetField("jobno", entity.jobno);
     row.SetField("commtype", entity.commtype);
     row.SetField("printpricefl", entity.printpricefl);
     row.SetField("subtotalfl", entity.subtotalfl);
     row.SetField("costoverfl", entity.costoverfl);
     row.SetField("crreasonty", entity.crreasonty);
     row.SetField("taxgroup", entity.taxgroup);
     row.SetField("nontaxtype", entity.nontaxtype);
     row.SetField("termspct", entity.termspct);
     row.SetField("gststatus", entity.gststatus);
     row.SetField("qtyunavail", entity.qtyunavail);
     row.SetField("batchnm", entity.batchnm);
     row.SetField("seqno", entity.seqno);
     row.SetField("restockamt", entity.restockamt);
     row.SetField("promisedt", entity.promisedt);
     row.SetField("jitpickfl", entity.jitpickfl);
     row.SetField("cataddfl", entity.cataddfl);
     row.SetField("shipfmno", entity.shipfmno);
     row.SetField("arpprodline", entity.arpprodline);
     row.SetField("arpvendno", entity.arpvendno);
     row.SetField("icspecrecno", entity.icspecrecno);
     row.SetField("transproc", entity.transproc);
     row.SetField("restktaxgrp", entity.restktaxgrp);
     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("quoteshipviaty", entity.quoteshipviaty);
     row.SetField("oeelbRowID", entity.rowID.ToByteArray());
 }