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