Exemple #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, JmehBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("jobid", entity.jobid);
     row.SetField("jobrevno", entity.jobrevno);
     row.SetField("jmehRowID", entity.rowID.ToByteArray());
 }
Exemple #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromJmehBase(ref DataRow row, JmehBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("jobid", entity.jobid);
     row.SetField("jobrevno", entity.jobrevno);
     row.SetField("quoteno", entity.quoteno);
     row.SetField("custno", entity.custno);
     row.SetField("shipto", entity.shipto);
     row.SetField("whse", entity.whse);
     row.SetField("stagecd", entity.stagecd);
     row.SetField("enterdt", entity.enterdt);
     row.SetField("entertm", entity.entertm);
     row.SetField("duedt", entity.duedt);
     row.SetField("begindt", entity.begindt);
     row.SetField("expiredt", entity.expiredt);
     row.SetField("awarddt", entity.awarddt);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("promisedt", entity.promisedt);
     row.SetField("descrip1", entity.descrip1);
     row.SetField("descrip2", entity.descrip2);
     row.SetField("takenby", entity.takenby);
     row.SetField("awardnm", entity.awardnm);
     row.SetField("awarddesc", entity.awarddesc);
     row.SetField("custpo", entity.custpo);
     row.SetField("contact", entity.contact);
     row.SetField("contactphno", entity.contactphno);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("lostbusty", entity.lostbusty);
     row.SetField("openinit", entity.openinit);
     row.SetField("commtype", entity.commtype);
     row.SetField("termstype", entity.termstype);
     row.SetField("slsrepin", entity.slsrepin);
     row.SetField("slsrepout", entity.slsrepout);
     row.SetField("pricetype", entity.pricetype);
     row.SetField("pricecd", entity.pricecd);
     row.SetField("disccd", entity.disccd);
     row.SetField("relprocessfl", entity.relprocessfl);
     row.SetField("relcompfl", entity.relcompfl);
     row.SetField("relinit", entity.relinit);
     row.SetField("refer", entity.refer);
     row.SetField("transtype", entity.transtype);
     row.SetField("restrictty", entity.restrictty);
     row.SetField("orderdisp", entity.orderdisp);
     row.SetField("opentorelfl", entity.opentorelfl);
     row.SetField("shipviaty", entity.shipviaty);
     row.SetField("lumpbillamt", entity.lumpbillamt);
     row.SetField("lumpbillfl", entity.lumpbillfl);
     row.SetField("lumppricefl", entity.lumppricefl);
     row.SetField("arpwhse", entity.arpwhse);
     row.SetField("approvty", entity.approvty);
     row.SetField("transdt", entity.transdt);
     row.SetField("transtm", entity.transtm);
     row.SetField("transproc", entity.transproc);
     row.SetField("operinit", entity.operinit);
     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("vendno", entity.vendno);
     row.SetField("totprice", entity.totprice);
     row.SetField("totcost", entity.totcost);
     row.SetField("totmargin", entity.totmargin);
     row.SetField("prodline", entity.prodline);
     row.SetField("printtype", entity.printtype);
     row.SetField("minmargin", entity.minmargin);
     row.SetField("totextprice", entity.totextprice);
     row.SetField("totextcost", entity.totextcost);
     row.SetField("shiptoaddr1", entity.shiptoaddr1);
     row.SetField("shiptoaddr2", entity.shiptoaddr2);
     row.SetField("shiptoaddr3", entity.shiptoaddr3);
     row.SetField("shiptocity", entity.shiptocity);
     row.SetField("shiptonm", entity.shiptonm);
     row.SetField("shiptost", entity.shiptost);
     row.SetField("shiptozip", entity.shiptozip);
     row.SetField("shiptofaxphoneno", entity.shiptofaxphoneno);
     row.SetField("shiptophoneno", entity.shiptophoneno);
     row.SetField("canceldt", entity.canceldt);
     row.SetField("costapprovfl", entity.costapprovfl);
     row.SetField("prcapprovfl", entity.prcapprovfl);
     row.SetField("relpricefl", entity.relpricefl);
     row.SetField("jmehRowID", entity.rowID.ToByteArray());
 }