Пример #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, WtehBase entity)
 {
     row.SetField("wtno", entity.wtno);
     row.SetField("wtsuf", entity.wtsuf);
     row.SetField("wtehRowID", entity.rowID.ToByteArray());
     row.SetField("rowpointer", entity.rowpointer);
 }
Пример #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromWtehBase(ref DataRow row, WtehBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("wtno", entity.wtno);
     row.SetField("wtsuf", entity.wtsuf);
     row.SetField("stagecd", entity.stagecd);
     row.SetField("shiptonm", entity.shiptonm);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("orderaltno", entity.orderaltno);
     row.SetField("transtype", entity.transtype);
     row.SetField("shiptost", entity.shiptost);
     row.SetField("shiptozip", entity.shiptozip);
     row.SetField("shipfmwhse", entity.shipfmwhse);
     row.SetField("shipinstr", entity.shipinstr);
     row.SetField("refer", entity.refer);
     row.SetField("shipviaty", entity.shipviaty);
     row.SetField("shipdt", entity.shipdt);
     row.SetField("immedwtfl", entity.immedwtfl);
     row.SetField("fminvexrate", entity.fminvexrate);
     row.SetField("operinit", entity.operinit);
     row.SetField("transdt", entity.transdt);
     row.SetField("orderdt", entity.orderdt);
     row.SetField("printeddt", entity.printeddt);
     row.SetField("enterdt", entity.enterdt);
     row.SetField("receiptdt", entity.receiptdt);
     row.SetField("transtm", entity.transtm);
     row.SetField("ototqtyshp", entity.ototqtyshp);
     row.SetField("shiptoaddr1", entity.shiptoaddr1);
     row.SetField("shiptoaddr2", entity.shiptoaddr2);
     row.SetField("totqtyact", entity.totqtyact);
     row.SetField("shiptocity", entity.shiptocity);
     row.SetField("nolineitem", entity.nolineitem);
     row.SetField("drdeltm", entity.drdeltm);
     row.SetField("createdby", entity.createdby);
     row.SetField("totlineamt", entity.totlineamt);
     row.SetField("wletsetno", entity.wletsetno);
     row.SetField("totweight", entity.totweight);
     row.SetField("bostage", entity.bostage);
     row.SetField("totcubes", entity.totcubes);
     row.SetField("totqtyshp", entity.totqtyshp);
     row.SetField("drdeldt", entity.drdeldt);
     row.SetField("borelfl", entity.borelfl);
     row.SetField("boexistsfl", entity.boexistsfl);
     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("stagearea", entity.stagearea);
     row.SetField("user8", entity.user8);
     row.SetField("user9", entity.user9);
     row.SetField("jrnlno", entity.jrnlno);
     row.SetField("nosnlotsi", entity.nosnlotsi);
     row.SetField("notimeschg", entity.notimeschg);
     row.SetField("nextlineno", entity.nextlineno);
     row.SetField("linefl", entity.linefl);
     row.SetField("printfl", entity.printfl);
     row.SetField("ignoreltfl", entity.ignoreltfl);
     row.SetField("cono2", entity.cono2);
     row.SetField("totqtyord", entity.totqtyord);
     row.SetField("totqtyrcv", entity.totqtyrcv);
     row.SetField("shiptowhse", entity.shiptowhse);
     row.SetField("totshipamt", entity.totshipamt);
     row.SetField("totordamt", entity.totordamt);
     row.SetField("totrcvamt", entity.totrcvamt);
     row.SetField("duedt", entity.duedt);
     row.SetField("nosnlotso", entity.nosnlotso);
     row.SetField("dueoverfl", entity.dueoverfl);
     row.SetField("openinit", entity.openinit);
     row.SetField("jrnlno2", entity.jrnlno2);
     row.SetField("nounappr", entity.nounappr);
     row.SetField("pickedby", entity.pickedby);
     row.SetField("pkgid", entity.pkgid);
     row.SetField("wtauth", entity.wtauth);
     row.SetField("addonamt1", entity.addonamt1);
     row.SetField("addonamt2", entity.addonamt2);
     row.SetField("addontype1", entity.addontype1);
     row.SetField("addontype2", entity.addontype2);
     row.SetField("rcvoperinit", entity.rcvoperinit);
     row.SetField("jrnlno3", entity.jrnlno3);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("orderaltsuf", entity.orderaltsuf);
     row.SetField("nocatwghti", entity.nocatwghti);
     row.SetField("nocatwghto", entity.nocatwghto);
     row.SetField("laststagecd", entity.laststagecd);
     row.SetField("noerrs", entity.noerrs);
     row.SetField("pickcnt", entity.pickcnt);
     row.SetField("addonnet1", entity.addonnet1);
     row.SetField("addonnet2", entity.addonnet2);
     row.SetField("langcd", entity.langcd);
     row.SetField("user1", entity.user1);
     row.SetField("user2", entity.user2);
     row.SetField("nopackages", entity.nopackages);
     row.SetField("addondist1", entity.addondist1);
     row.SetField("addondist2", entity.addondist2);
     row.SetField("actfreight", entity.actfreight);
     row.SetField("shippingpt", entity.shippingpt);
     row.SetField("zone", entity.zone);
     row.SetField("divno", entity.divno);
     row.SetField("rushfl", entity.rushfl);
     row.SetField("transproc", entity.transproc);
     row.SetField("drexpfl", entity.drexpfl);
     row.SetField("fmcurrencyty", entity.fmcurrencyty);
     row.SetField("tocurrencyty", entity.tocurrencyty);
     row.SetField("toinvexrate", entity.toinvexrate);
     row.SetField("fmexpexrate", entity.fmexpexrate);
     row.SetField("toexpexrate", entity.toexpexrate);
     row.SetField("fmcapexrate", entity.fmcapexrate);
     row.SetField("tocapexrate", entity.tocapexrate);
     row.SetField("shiptoaddr3", entity.shiptoaddr3);
     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("esbshipmentfl", entity.esbshipmentfl);
     row.SetField("esbasnfl", entity.esbasnfl);
     row.SetField("autoaltwhsecd", entity.autoaltwhsecd);
     row.SetField("autoaltordno", entity.autoaltordno);
     row.SetField("autoaltordsuf", entity.autoaltordsuf);
     row.SetField("rowpointer", entity.rowpointer);
     row.SetField("countrycd", entity.countrycd);
     row.SetField("extshipinstr", entity.extshipinstr);
     row.SetField("transdttmz", entity.transdttmz);
     row.SetField("markupaddonfl", entity.markupaddonfl);
     row.SetField("reasoncode", entity.reasoncode);
     row.SetField("lspinvregstatus", entity.lspinvregstatus);
     row.SetField("lspuuid", entity.lspuuid);
     row.SetField("lspinvregstatdttmz", entity.lspinvregstatdttmz);
     row.SetField("lspidentifier1", entity.lspidentifier1);
     row.SetField("lspidentifier2", entity.lspidentifier2);
     row.SetField("wtehRowID", entity.rowID.ToByteArray());
 }