/// <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()); }
/// <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()); }