示例#1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPvPolnBase(ref DataRow row, PvPolnBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("pono", entity.pono);
     row.SetField("posuf", entity.posuf);
     row.SetField("lineno", entity.lineno);
     row.SetField("filler-1", entity.filler1);
     row.SetField("orgcatwtfl", entity.orgcatwtfl);
     row.SetField("orgcubes", entity.orgcubes);
     row.SetField("orgnetamt", entity.orgnetamt);
     row.SetField("orgnonstockty", entity.orgnonstockty);
     row.SetField("orgnosnlots", entity.orgnosnlots);
     row.SetField("orgprod", entity.orgprod);
     row.SetField("orgprice", entity.orgprice);
     row.SetField("orgsqtyord", entity.orgsqtyord);
     row.SetField("orgstkqtyord", entity.orgstkqtyord);
     row.SetField("orgqtyord", entity.orgqtyord);
     row.SetField("orgqtyrcv", entity.orgqtyrcv);
     row.SetField("orgunit", entity.orgunit);
     row.SetField("orgidicsp", entity.orgidicsp);
     row.SetField("orgidicsw", entity.orgidicsw);
     row.SetField("orgweight", entity.orgweight);
     row.SetField("filler-2", entity.filler2);
     row.SetField("cubes", entity.cubes);
     row.SetField("duedt", entity.duedt);
     row.SetField("nonstockty", entity.nonstockty);
     row.SetField("prod", entity.prod);
     row.SetField("scrnprice", entity.scrnprice);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("unit", entity.unit);
     row.SetField("weight", entity.weight);
     row.SetField("reasunavty", entity.reasunavty);
     row.SetField("filler-3", entity.filler3);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("unitconv", entity.unitconv);
     row.SetField("idpoel", entity.idpoel);
     row.SetField("idicsp", entity.idicsp);
     row.SetField("idicsw", entity.idicsw);
     row.SetField("linefl", entity.linefl);
     row.SetField("maint-l", entity.maintL);
     row.SetField("nosnlots", entity.nosnlots);
     row.SetField("priceover", entity.priceover);
     row.SetField("filler-4", entity.filler4);
     row.SetField("speccostty", entity.speccostty);
     row.SetField("csunperstk", entity.csunperstk);
     row.SetField("specconv", entity.specconv);
     row.SetField("prccostper", entity.prccostper);
     row.SetField("icspecrecno", entity.icspecrecno);
     row.SetField("serlottype", entity.serlottype);
     row.SetField("netavail", entity.netavail);
     row.SetField("proddesc1", entity.proddesc1);
     row.SetField("netamt", entity.netamt);
     row.SetField("proddesc2", entity.proddesc2);
     row.SetField("calcprice", entity.calcprice);
     row.SetField("poelrecid", entity.poelrecid);
     row.SetField("manprice", entity.manprice);
     row.SetField("poelrowid", entity.poelrowid);
     row.SetField("stkunit", entity.stkunit);
     row.SetField("tallyfl", entity.tallyfl);
     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("orgreasunavty", entity.orgreasunavty);
     row.SetField("expshipdt", entity.expshipdt);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("launchtallyfl", entity.launchtallyfl);
     row.SetField("backorder", entity.backorder);
     row.SetField("onorder", entity.onorder);
     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("userchr1", entity.userchr1);
     row.SetField("userchr2", entity.userchr2);
     row.SetField("userchr3", entity.userchr3);
     row.SetField("userchr4", entity.userchr4);
     row.SetField("userdec1", entity.userdec1);
     row.SetField("userdec2", entity.userdec2);
     row.SetField("userdt1", entity.userdt1);
     row.SetField("userdt2", entity.userdt2);
     row.SetField("contractno", entity.contractno);
     row.SetField("pdsvcrecno", entity.pdsvcrecno);
     row.SetField("orgpdsvcrecno", entity.orgpdsvcrecno);
     row.SetField("ackdt", entity.ackdt);
     row.SetField("ackrsn", entity.ackrsn);
     row.SetField("ncnr", entity.ncnr);
     row.SetField("countryoforigin", entity.countryoforigin);
     row.SetField("tariffcd", entity.tariffcd);
     row.SetField("upcid", entity.upcid);
     row.SetField("pv_polnRowID", entity.rowID.ToByteArray());
 }
示例#2
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, PvPolnBase entity)
 {
     row.SetField("pv_polnRowID", entity.rowID.ToByteArray());
 }