예제 #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, PvJmlnBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("jobrevno", entity.jobrevno);
     row.SetField("lineno", entity.lineno);
     row.SetField("jobid", entity.jobid);
     row.SetField("pv_jmlnRowID", entity.rowID.ToByteArray());
 }
예제 #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPvJmlnBase(ref DataRow row, PvJmlnBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("jobrevno", entity.jobrevno);
     row.SetField("lineno", entity.lineno);
     row.SetField("prod", entity.prod);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("prodline", entity.prodline);
     row.SetField("prline", entity.prline);
     row.SetField("linetype", entity.linetype);
     row.SetField("unit", entity.unit);
     row.SetField("frzrebty", entity.frzrebty);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("scrndiscamt", entity.scrndiscamt);
     row.SetField("price", entity.price);
     row.SetField("scrnprodcost", entity.scrnprodcost);
     row.SetField("scrnpdcost", entity.scrnpdcost);
     row.SetField("vendno", entity.vendno);
     row.SetField("prvendno", entity.prvendno);
     row.SetField("kitfl", entity.kitfl);
     row.SetField("disctype", entity.disctype);
     row.SetField("maint-l", entity.maintL);
     row.SetField("prodtype", entity.prodtype);
     row.SetField("reqprod", entity.reqprod);
     row.SetField("xrefprodty", entity.xrefprodty);
     row.SetField("crprod", entity.crprod);
     row.SetField("linefl", entity.linefl);
     row.SetField("cataddfl", entity.cataddfl);
     row.SetField("pricereset", entity.pricereset);
     row.SetField("costoverfl", entity.costoverfl);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("unitconv", entity.unitconv);
     row.SetField("priceover", entity.priceover);
     row.SetField("calcdiscamt", entity.calcdiscamt);
     row.SetField("rebamt", entity.rebamt);
     row.SetField("calcprodcost", entity.calcprodcost);
     row.SetField("calcpdcost", entity.calcpdcost);
     row.SetField("idicsp", entity.idicsp);
     row.SetField("idicsw1", entity.idicsw1);
     row.SetField("idicsw2", entity.idicsw2);
     row.SetField("idjmel", entity.idjmel);
     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("ordertype", entity.ordertype);
     row.SetField("arpwhse", entity.arpwhse);
     row.SetField("qtytype", entity.qtytype);
     row.SetField("manprice", entity.manprice);
     row.SetField("priceroll", entity.priceroll);
     row.SetField("promofl", entity.promofl);
     row.SetField("pdrecno", entity.pdrecno);
     row.SetField("idpdsc", entity.idpdsc);
     row.SetField("lostbustyl", entity.lostbustyl);
     row.SetField("slsrepin", entity.slsrepin);
     row.SetField("slsrepout", entity.slsrepout);
     row.SetField("commtype", entity.commtype);
     row.SetField("priceclty", entity.priceclty);
     row.SetField("printpricefl", entity.printpricefl);
     row.SetField("subtotalfl", entity.subtotalfl);
     row.SetField("disccd", entity.disccd);
     row.SetField("prodpricecd", entity.prodpricecd);
     row.SetField("pricelevel", entity.pricelevel);
     row.SetField("scrncost", entity.scrncost);
     row.SetField("stkunit", entity.stkunit);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("totlinefl", entity.totlinefl);
     row.SetField("nosnlots", entity.nosnlots);
     row.SetField("nosnlotsk", entity.nosnlotsk);
     row.SetField("baseprice", entity.baseprice);
     row.SetField("listprice", entity.listprice);
     row.SetField("orgdiscamt", entity.orgdiscamt);
     row.SetField("orgnetord", entity.orgnetord);
     row.SetField("orgnosnlots", entity.orgnosnlots);
     row.SetField("orgnosnlotsk", entity.orgnosnlotsk);
     row.SetField("orgpdrecno", entity.orgpdrecno);
     row.SetField("orgprice", entity.orgprice);
     row.SetField("orgprod", entity.orgprod);
     row.SetField("orgprodcat", entity.orgprodcat);
     row.SetField("orgprodcost", entity.orgprodcost);
     row.SetField("orglinetype", entity.orglinetype);
     row.SetField("orgstkqtyord", entity.orgstkqtyord);
     row.SetField("orgqtyord", entity.orgqtyord);
     row.SetField("orgtotprice", entity.orgtotprice);
     row.SetField("orgtotqtyord", entity.orgtotqtyord);
     row.SetField("orgunit", entity.orgunit);
     row.SetField("orgunitchg", entity.orgunitchg);
     row.SetField("orgidicsp", entity.orgidicsp);
     row.SetField("orgidicsw1", entity.orgidicsw1);
     row.SetField("orgidicsw2", entity.orgidicsw2);
     row.SetField("orgweight", entity.orgweight);
     row.SetField("orgrebamt", entity.orgrebamt);
     row.SetField("firstmarginwarnfl", entity.firstmarginwarnfl);
     row.SetField("firstsuperwarnfl", entity.firstsuperwarnfl);
     row.SetField("filler-1", entity.filler1);
     row.SetField("filler-2", entity.filler2);
     row.SetField("filler-3", entity.filler3);
     row.SetField("filler-4", entity.filler4);
     row.SetField("filler-5", entity.filler5);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("promisedt", entity.promisedt);
     row.SetField("filler-7", entity.filler7);
     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("jmelrecid", entity.jmelrecid);
     row.SetField("jmelrowid", entity.jmelrowid);
     row.SetField("priceonty", entity.priceonty);
     row.SetField("qtybreakty", entity.qtybreakty);
     row.SetField("serlottype", entity.serlottype);
     row.SetField("proddesc2", entity.proddesc2);
     row.SetField("vcspeccostty", entity.vcspeccostty);
     row.SetField("vccsunperstk", entity.vccsunperstk);
     row.SetField("vcspecconv", entity.vcspecconv);
     row.SetField("vcprccostper", entity.vcprccostper);
     row.SetField("vcspecrecno", entity.vcspecrecno);
     row.SetField("spcconvertfl", entity.spcconvertfl);
     row.SetField("jobid", entity.jobid);
     row.SetField("specnstype", entity.specnstype);
     row.SetField("orgspecnstype", entity.orgspecnstype);
     row.SetField("priceoverfl", entity.priceoverfl);
     row.SetField("netord", entity.netord);
     row.SetField("pricetype", entity.pricetype);
     row.SetField("duedt", entity.duedt);
     row.SetField("linestat", entity.linestat);
     row.SetField("printtype", entity.printtype);
     row.SetField("taxablety", entity.taxablety);
     row.SetField("marginpct", entity.marginpct);
     row.SetField("minmargin", entity.minmargin);
     row.SetField("groupnm", entity.groupnm);
     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("pricetypefl", entity.pricetypefl);
     row.SetField("custno", entity.custno);
     row.SetField("pv_jmlnRowID", entity.rowID.ToByteArray());
 }