예제 #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, PoelBase entity)
 {
     row.SetField("pono", entity.pono);
     row.SetField("posuf", entity.posuf);
     row.SetField("lineno", entity.lineno);
     row.SetField("cono", entity.cono);
     row.SetField("poelRowID", entity.rowID.ToByteArray());
     row.SetField("rowpointer", entity.rowpointer);
 }
예제 #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPoelBase(ref DataRow row, PoelBase entity)
 {
     row.SetField("pono", entity.pono);
     row.SetField("posuf", entity.posuf);
     row.SetField("whse", entity.whse);
     row.SetField("transtype", entity.transtype);
     row.SetField("lineno", entity.lineno);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("cono", entity.cono);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("unit", entity.unit);
     row.SetField("buyer", entity.buyer);
     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("stkqtyrcv", entity.stkqtyrcv);
     row.SetField("price", entity.price);
     row.SetField("prodline", entity.prodline);
     row.SetField("vendno", entity.vendno);
     row.SetField("botype", entity.botype);
     row.SetField("netamt", entity.netamt);
     row.SetField("reqprod", entity.reqprod);
     row.SetField("weight", entity.weight);
     row.SetField("cubes", entity.cubes);
     row.SetField("origcubes", entity.origcubes);
     row.SetField("origweight", entity.origweight);
     row.SetField("notimeschg", entity.notimeschg);
     row.SetField("statustype", entity.statustype);
     row.SetField("leadoverty", entity.leadoverty);
     row.SetField("icspecrecno", entity.icspecrecno);
     row.SetField("printfl", entity.printfl);
     row.SetField("sxextractdt", entity.sxextractdt);
     row.SetField("chrgqty", entity.chrgqty);
     row.SetField("origduedt", entity.origduedt);
     row.SetField("expshipdt", entity.expshipdt);
     row.SetField("bono", entity.bono);
     row.SetField("vafakeprodfl", entity.vafakeprodfl);
     row.SetField("user3", entity.user3);
     row.SetField("user4", entity.user4);
     row.SetField("user5", entity.user5);
     row.SetField("user6", entity.user6);
     row.SetField("nosnlots", entity.nosnlots);
     row.SetField("user7", entity.user7);
     row.SetField("user8", entity.user8);
     row.SetField("user9", entity.user9);
     row.SetField("prevqtyord", entity.prevqtyord);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("duedt", entity.duedt);
     row.SetField("invcost", entity.invcost);
     row.SetField("unitoverfl", entity.unitoverfl);
     row.SetField("priceoverfl", entity.priceoverfl);
     row.SetField("stkqtyoverfl", entity.stkqtyoverfl);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("qtyrcv", entity.qtyrcv);
     row.SetField("shipfmno", entity.shipfmno);
     row.SetField("qtyrel", entity.qtyrel);
     row.SetField("costoverfl", entity.costoverfl);
     row.SetField("nonstockty", entity.nonstockty);
     row.SetField("rcvcost", entity.rcvcost);
     row.SetField("qtyunavail", entity.qtyunavail);
     row.SetField("reasunavty", entity.reasunavty);
     row.SetField("eachfl", entity.eachfl);
     row.SetField("proddesc2", entity.proddesc2);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("tallyfl", entity.tallyfl);
     row.SetField("glcostrcv", entity.glcostrcv);
     row.SetField("glcostinv", entity.glcostinv);
     row.SetField("wodiscamt", entity.wodiscamt);
     row.SetField("catwtfl", entity.catwtfl);
     row.SetField("netrcv", entity.netrcv);
     row.SetField("exlatefl", entity.exlatefl);
     row.SetField("tariffamt", entity.tariffamt);
     row.SetField("domrcvcost", entity.domrcvcost);
     row.SetField("dominvcost", entity.dominvcost);
     row.SetField("landedcost", entity.landedcost);
     row.SetField("addonamt1", entity.addonamt1);
     row.SetField("addonamt2", entity.addonamt2);
     row.SetField("addonamt3", entity.addonamt3);
     row.SetField("addonamt4", entity.addonamt4);
     row.SetField("user1", entity.user1);
     row.SetField("user2", entity.user2);
     row.SetField("costeachfl", entity.costeachfl);
     row.SetField("wmqtyrcv", entity.wmqtyrcv);
     row.SetField("taxabletyau", entity.taxabletyau);
     row.SetField("taxoverideau", entity.taxoverideau);
     row.SetField("taxgroup", entity.taxgroup);
     row.SetField("taxrateau", entity.taxrateau);
     row.SetField("taxamt", entity.taxamt);
     row.SetField("unitchgfl", entity.unitchgfl);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("qtycosted", entity.qtycosted);
     row.SetField("stkqtybilled", entity.stkqtybilled);
     row.SetField("origtrf", entity.origtrf);
     row.SetField("unitconv", entity.unitconv);
     row.SetField("transproc", entity.transproc);
     row.SetField("ignoreltfl", entity.ignoreltfl);
     row.SetField("rcvsafety", entity.rcvsafety);
     row.SetField("rcvnetavl", entity.rcvnetavl);
     row.SetField("leadtime", entity.leadtime);
     row.SetField("recvaddfl", entity.recvaddfl);
     row.SetField("contno", entity.contno);
     row.SetField("usetrackfl", entity.usetrackfl);
     row.SetField("trackno", entity.trackno);
     row.SetField("tracklineno", entity.tracklineno);
     row.SetField("orgpono", entity.orgpono);
     row.SetField("orgposuf", entity.orgposuf);
     row.SetField("warrantyfl", entity.warrantyfl);
     row.SetField("correctionty", entity.correctionty);
     row.SetField("countrycd", entity.countrycd);
     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("contractno", entity.contractno);
     row.SetField("pdsvcrecno", entity.pdsvcrecno);
     row.SetField("ackdt", entity.ackdt);
     row.SetField("ackrsn", entity.ackrsn);
     row.SetField("rowpointer", entity.rowpointer);
     row.SetField("ncnr", entity.ncnr);
     row.SetField("countryoforigin", entity.countryoforigin);
     row.SetField("tariffcd", entity.tariffcd);
     row.SetField("vendretauth", entity.vendretauth);
     row.SetField("transdttmz", entity.transdttmz);
     row.SetField("upcid", entity.upcid);
     row.SetField("poelRowID", entity.rowID.ToByteArray());
 }