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