/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, PoerahBase entity) { row.SetField("cono", entity.cono); row.SetField("reportno", entity.reportno); row.SetField("poerahRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPoerahBase(ref DataRow row, PoerahBase entity) { row.SetField("cono", entity.cono); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("operinit", entity.operinit); row.SetField("reportno", entity.reportno); row.SetField("vendno", entity.vendno); row.SetField("prodline", entity.prodline); row.SetField("shipfmno", entity.shipfmno); row.SetField("billtowhse", entity.billtowhse); row.SetField("whse", entity.whse); row.SetField("buyer", entity.buyer); row.SetField("shiptonm", entity.shiptonm); row.SetField("shiptoaddr1", entity.shiptoaddr1); row.SetField("shiptoaddr2", entity.shiptoaddr2); row.SetField("shiptocity", entity.shiptocity); row.SetField("shiptost", entity.shiptost); row.SetField("shiptozip", entity.shiptozip); row.SetField("shipinstr", entity.shipinstr); row.SetField("refer", entity.refer); row.SetField("duedt", entity.duedt); row.SetField("shipviaty", entity.shipviaty); row.SetField("termstype", entity.termstype); row.SetField("ignoreltfl", entity.ignoreltfl); row.SetField("subfl", entity.subfl); row.SetField("bofl", entity.bofl); row.SetField("resalefl", entity.resalefl); row.SetField("resaleno", entity.resaleno); row.SetField("orderdisp", entity.orderdisp); row.SetField("totlineamt", entity.totlineamt); row.SetField("totweight", entity.totweight); row.SetField("totcubes", entity.totcubes); row.SetField("totqtyord", entity.totqtyord); row.SetField("transtype", entity.transtype); row.SetField("oper2", entity.oper2); row.SetField("reportnm", entity.reportnm); row.SetField("nextlineno", entity.nextlineno); row.SetField("fobfl", entity.fobfl); row.SetField("linerevfl", entity.linerevfl); row.SetField("currencyty", entity.currencyty); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("addlcarrycost", entity.addlcarrycost); row.SetField("tarbuyamt", entity.tarbuyamt); row.SetField("notesfl", entity.notesfl); row.SetField("rpterr", entity.rpterr); row.SetField("tarbuytype", entity.tarbuytype); row.SetField("sourcety", entity.sourcety); row.SetField("frtconsldtcd", entity.frtconsldtcd); row.SetField("openinit", entity.openinit); row.SetField("reqshipdt", entity.reqshipdt); row.SetField("createdt", entity.createdt); row.SetField("dueoverfl", entity.dueoverfl); row.SetField("rushfl", entity.rushfl); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("conslinefl", entity.conslinefl); row.SetField("user6", entity.user6); row.SetField("conswhsefl", entity.conswhsefl); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("wodiscoverfl", entity.wodiscoverfl); row.SetField("wodiscamt", entity.wodiscamt); row.SetField("wodisctype", entity.wodisctype); row.SetField("automrgfl", entity.automrgfl); row.SetField("reqoverfl", entity.reqoverfl); row.SetField("mergefl", entity.mergefl); row.SetField("orderptfl", entity.orderptfl); row.SetField("transproc", entity.transproc); row.SetField("reportpri", entity.reportpri); row.SetField("totcritical", entity.totcritical); row.SetField("totbelowop", entity.totbelowop); row.SetField("totrush", entity.totrush); row.SetField("totnpna", entity.totnpna); row.SetField("pridesc", entity.pridesc); row.SetField("reviewcycle", entity.reviewcycle); row.SetField("totdoc", entity.totdoc); row.SetField("rpterrfl", entity.rpterrfl); row.SetField("blno", entity.blno); row.SetField("blsuf", entity.blsuf); row.SetField("esrqstid", entity.esrqstid); row.SetField("shiptoaddr3", entity.shiptoaddr3); row.SetField("addonamt1", entity.addonamt1); row.SetField("addonamt2", entity.addonamt2); row.SetField("addonamt3", entity.addonamt3); row.SetField("addonamt4", entity.addonamt4); row.SetField("addoncapfl1", entity.addoncapfl1); row.SetField("addoncapfl2", entity.addoncapfl2); row.SetField("addoncapfl3", entity.addoncapfl3); row.SetField("addoncapfl4", entity.addoncapfl4); row.SetField("addondistr", entity.addondistr); row.SetField("addonnet1", entity.addonnet1); row.SetField("addonnet2", entity.addonnet2); row.SetField("addonnet3", entity.addonnet3); row.SetField("addonnet4", entity.addonnet4); row.SetField("addonno1", entity.addonno1); row.SetField("addonno2", entity.addonno2); row.SetField("addonno3", entity.addonno3); row.SetField("addonno4", entity.addonno4); row.SetField("addontype1", entity.addontype1); row.SetField("addontype2", entity.addontype2); row.SetField("addontype3", entity.addontype3); row.SetField("addontype4", entity.addontype4); row.SetField("user10", entity.user10); row.SetField("user11", entity.user11); row.SetField("user12", entity.user12); row.SetField("user13", entity.user13); row.SetField("user14", entity.user14); row.SetField("user15", entity.user15); row.SetField("user16", entity.user16); row.SetField("user17", entity.user17); row.SetField("user18", entity.user18); row.SetField("user19", entity.user19); row.SetField("user20", entity.user20); row.SetField("user21", entity.user21); row.SetField("user22", entity.user22); row.SetField("user23", entity.user23); row.SetField("user24", entity.user24); row.SetField("contractno", entity.contractno); row.SetField("freightexpectedty", entity.freightexpectedty); row.SetField("totsuper", entity.totsuper); row.SetField("countrycd", entity.countrycd); row.SetField("geocd", entity.geocd); row.SetField("outofcityfl", entity.outofcityfl); row.SetField("rowpointer", entity.rowpointer); row.SetField("frttermscd", entity.frttermscd); row.SetField("frtbillacct", entity.frtbillacct); row.SetField("transferloc", entity.transferloc); row.SetField("poerahRowID", entity.rowID.ToByteArray()); }