/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, JmelBase entity) { row.SetField("cono", entity.cono); row.SetField("jobid", entity.jobid); row.SetField("jobrevno", entity.jobrevno); row.SetField("lineno", entity.lineno); row.SetField("jmelRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromJmelBase(ref DataRow row, JmelBase entity) { row.SetField("cono", entity.cono); row.SetField("jobid", entity.jobid); row.SetField("jobrevno", entity.jobrevno); row.SetField("lineno", entity.lineno); row.SetField("whse", entity.whse); row.SetField("linetype", entity.linetype); row.SetField("prod", entity.prod); row.SetField("qtyord", entity.qtyord); row.SetField("reqprod", entity.reqprod); row.SetField("price", entity.price); row.SetField("xrefprodty", entity.xrefprodty); row.SetField("cost", entity.cost); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("marginpct", entity.marginpct); row.SetField("extprice", entity.extprice); row.SetField("vendno", entity.vendno); row.SetField("extcost", entity.extcost); row.SetField("prodline", entity.prodline); row.SetField("extmargin", entity.extmargin); row.SetField("taxablety", entity.taxablety); row.SetField("lastcost", entity.lastcost); row.SetField("lastprice", entity.lastprice); row.SetField("prodcat", entity.prodcat); row.SetField("lastmarginpct", entity.lastmarginpct); row.SetField("commtype", entity.commtype); row.SetField("lastextprc", entity.lastextprc); row.SetField("kitfl", entity.kitfl); row.SetField("lastextcst", entity.lastextcst); row.SetField("kitrollty", entity.kitrollty); row.SetField("lastextmrgn", entity.lastextmrgn); row.SetField("qtybreakty", entity.qtybreakty); row.SetField("descrip1", entity.descrip1); row.SetField("descrip2", entity.descrip2); row.SetField("promofl", entity.promofl); row.SetField("linestat", entity.linestat); row.SetField("printtype", entity.printtype); row.SetField("notimeschg", entity.notimeschg); row.SetField("awardty", entity.awardty); row.SetField("commentfl", entity.commentfl); row.SetField("relprocessfl", entity.relprocessfl); row.SetField("unit", entity.unit); row.SetField("relaccepttype", entity.relaccepttype); row.SetField("unitconv", entity.unitconv); row.SetField("pdrecno", entity.pdrecno); row.SetField("priceoverfl", entity.priceoverfl); row.SetField("pricetype", entity.pricetype); row.SetField("baseprice", entity.baseprice); row.SetField("listprice", entity.listprice); row.SetField("awardprice", entity.awardprice); row.SetField("pdcost", entity.pdcost); row.SetField("prodcost", entity.prodcost); row.SetField("costoverfl", entity.costoverfl); row.SetField("lockprfl", entity.lockprfl); row.SetField("lockcsfl", entity.lockcsfl); row.SetField("lockvnfl", entity.lockvnfl); row.SetField("lastcstovfl", entity.lastcstovfl); row.SetField("lastprcovfl", entity.lastprcovfl); row.SetField("lastvendno", entity.lastvendno); row.SetField("lastlockfl", entity.lastlockfl); row.SetField("ordertype", entity.ordertype); row.SetField("cataddfl", entity.cataddfl); row.SetField("reqshipdt", entity.reqshipdt); row.SetField("promisedt", entity.promisedt); row.SetField("duedt", entity.duedt); row.SetField("shipfmno", entity.shipfmno); row.SetField("arpwhse", entity.arpwhse); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("transproc", entity.transproc); row.SetField("operinit", entity.operinit); row.SetField("origlineno", entity.origlineno); 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("qtyrel", entity.qtyrel); row.SetField("specnstype", entity.specnstype); row.SetField("lostbusty", entity.lostbusty); row.SetField("netord", entity.netord); row.SetField("minmargin", entity.minmargin); row.SetField("orderaltno", entity.orderaltno); row.SetField("linealtno", entity.linealtno); row.SetField("disccd", entity.disccd); row.SetField("discamt", entity.discamt); row.SetField("discpct", entity.discpct); row.SetField("disctype", entity.disctype); row.SetField("pricecd", entity.pricecd); row.SetField("priceclty", entity.priceclty); row.SetField("groupnm", entity.groupnm); row.SetField("canceldt", entity.canceldt); row.SetField("custno", entity.custno); row.SetField("pricetypefl", entity.pricetypefl); row.SetField("pdsvcrecno", entity.pdsvcrecno); row.SetField("jmelRowID", entity.rowID.ToByteArray()); }