Ejemplo n.º 1
0
 /// <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);
 }
Ejemplo n.º 2
0
 /// <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());
 }