Example #1
0
 /// <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());
 }
Example #2
0
 /// <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());
 }