/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromValinelinetie(ref DataRow row, Valinelinetie entity) { row.SetField("maint-l", entity.maintL); row.SetField("ordertype", entity.ordertype); row.SetField("ordertypeenabled", entity.ordertypeenabled); row.SetField("ordertypelist", entity.ordertypelist); row.SetField("vendno", entity.vendno); row.SetField("vendnoenabled", entity.vendnoenabled); row.SetField("shipfmno", entity.shipfmno); row.SetField("shipfmnoenabled", entity.shipfmnoenabled); row.SetField("poduedate", entity.poduedate); row.SetField("poduedateenabled", entity.poduedateenabled); row.SetField("poshipvia", entity.poshipvia); row.SetField("poshipviaenabled", entity.poshipviaenabled); row.SetField("fob", entity.fob); row.SetField("fobenabled", entity.fobenabled); row.SetField("phoneno", entity.phoneno); row.SetField("faxphoneno", entity.faxphoneno); row.SetField("expediter", entity.expediter); row.SetField("confirm", entity.confirm); row.SetField("confirmenabled", entity.confirmenabled); row.SetField("orderdate", entity.orderdate); row.SetField("orderdatehidden", entity.orderdatehidden); row.SetField("wtwhse", entity.wtwhse); row.SetField("wtwhseenabled", entity.wtwhseenabled); row.SetField("wtduedate", entity.wtduedate); row.SetField("wtduedateenabled", entity.wtduedateenabled); row.SetField("wtshipvia", entity.wtshipvia); row.SetField("wtshipviaenabled", entity.wtshipviaenabled); row.SetField("wtcono", entity.wtcono); row.SetField("orderaltno", entity.orderaltno); row.SetField("orderaltnoenabled", entity.orderaltnoenabled); row.SetField("orderaltnohidden", entity.orderaltnohidden); row.SetField("vaverno", entity.vaverno); row.SetField("vavernoenabled", entity.vavernoenabled); row.SetField("vavernohidden", entity.vavernohidden); row.SetField("backordertype", entity.backordertype); row.SetField("backordertypeenabled", entity.backordertypeenabled); row.SetField("powtnew", entity.powtnew); row.SetField("powtintfl", entity.powtintfl); row.SetField("miscvendor", entity.miscvendor); row.SetField("manualname", entity.manualname); row.SetField("manualaddr1", entity.manualaddr1); row.SetField("manualaddr2", entity.manualaddr2); row.SetField("manualaddr3", entity.manualaddr3); row.SetField("manualcity", entity.manualcity); row.SetField("manualstate", entity.manualstate); row.SetField("manualzipcd", entity.manualzipcd); row.SetField("backtietype", entity.backtietype); row.SetField("backtietypeenabled", entity.backtietypeenabled); row.SetField("backtietypehidden", entity.backtietypehidden); row.SetField("powtaltno", entity.powtaltno); row.SetField("powtaltnoenabled", entity.powtaltnoenabled); row.SetField("powtaltnohidden", entity.powtaltnohidden); row.SetField("backtiesrcenabled", entity.backtiesrcenabled); row.SetField("backtiesrchidden", entity.backtiesrchidden); row.SetField("userfield", entity.userfield); row.SetField("mutli-src-rowid", entity.mutliSrcRowid.ToByteArray()); row.SetField("powtorderaltno", entity.powtorderaltno); row.SetField("powtorderaltnoenabled", entity.powtorderaltnoenabled); row.SetField("powtorderaltnohidden", entity.powtorderaltnohidden); row.SetField("powtorderalttype", entity.powtorderalttype); row.SetField("powtordertypeenabled", entity.powtordertypeenabled); row.SetField("powtlinealtno", entity.powtlinealtno); row.SetField("powtvvendno", entity.powtvvendno); row.SetField("powtvvendnoenabled", entity.powtvvendnoenabled); row.SetField("powtvshipfmno", entity.powtvshipfmno); row.SetField("powtvshipfmnoenabled", entity.powtvshipfmnoenabled); row.SetField("powtvduedt", entity.powtvduedt); row.SetField("powtvduedtenabled", entity.powtvduedtenabled); row.SetField("powtvorderdt", entity.powtvorderdt); row.SetField("powtvorderdthidden", entity.powtvorderdthidden); row.SetField("powtvshipviaty", entity.powtvshipviaty); row.SetField("powtvshipviatyenabled", entity.powtvshipviatyenabled); row.SetField("powtvfobfl", entity.powtvfobfl); row.SetField("powtvfobflenabled", entity.powtvfobflenabled); row.SetField("powtvconfirmfl", entity.powtvconfirmfl); row.SetField("powtvconfirmflenabled", entity.powtvconfirmflenabled); row.SetField("powtwwhse", entity.powtwwhse); row.SetField("powtwwhseenabled", entity.powtwwhseenabled); row.SetField("powtwduedt", entity.powtwduedt); row.SetField("powtwduedtenabled", entity.powtwduedtenabled); row.SetField("powtwshipviaty", entity.powtwshipviaty); row.SetField("powtwshipviatyenabled", entity.powtwshipviatyenabled); row.SetField("powtupdtfl", entity.powtupdtfl); row.SetField("powtbackordertype", entity.powtbackordertype); row.SetField("powtbackordertypeenabled", entity.powtbackordertypeenabled); row.SetField("powtexpediter", entity.powtexpediter); row.SetField("powtphoneno", entity.powtphoneno); row.SetField("powtfaxphoneno", entity.powtfaxphoneno); row.SetField("powtwtcono", entity.powtwtcono); row.SetField("powtordertypelist", entity.powtordertypelist); row.SetField("defvendno", entity.defvendno); row.SetField("defpoduedate", entity.defpoduedate); row.SetField("defwtduedate", entity.defwtduedate); }
public static Valinelinetie BuildValinelinetieFromRow(DataRow row) { Valinelinetie entity = new Valinelinetie(); entity.maintL = row.IsNull("maint-l") ? string.Empty : row.Field <string>("maint-l"); entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype"); entity.ordertypeenabled = row.Field <bool>("ordertypeenabled"); entity.ordertypelist = row.IsNull("ordertypelist") ? string.Empty : row.Field <string>("ordertypelist"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.vendnoenabled = row.Field <bool>("vendnoenabled"); entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno"); entity.shipfmnoenabled = row.Field <bool>("shipfmnoenabled"); entity.poduedate = row.Field <DateTime?>("poduedate"); entity.poduedateenabled = row.Field <bool>("poduedateenabled"); entity.poshipvia = row.IsNull("poshipvia") ? string.Empty : row.Field <string>("poshipvia"); entity.poshipviaenabled = row.Field <bool>("poshipviaenabled"); entity.fob = row.Field <bool>("fob"); entity.fobenabled = row.Field <bool>("fobenabled"); entity.phoneno = row.IsNull("phoneno") ? string.Empty : row.Field <string>("phoneno"); entity.faxphoneno = row.IsNull("faxphoneno") ? string.Empty : row.Field <string>("faxphoneno"); entity.expediter = row.IsNull("expediter") ? string.Empty : row.Field <string>("expediter"); entity.confirm = row.Field <bool>("confirm"); entity.confirmenabled = row.Field <bool>("confirmenabled"); entity.orderdate = row.Field <DateTime?>("orderdate"); entity.orderdatehidden = row.Field <bool>("orderdatehidden"); entity.wtwhse = row.IsNull("wtwhse") ? string.Empty : row.Field <string>("wtwhse"); entity.wtwhseenabled = row.Field <bool>("wtwhseenabled"); entity.wtduedate = row.Field <DateTime?>("wtduedate"); entity.wtduedateenabled = row.Field <bool>("wtduedateenabled"); entity.wtshipvia = row.IsNull("wtshipvia") ? string.Empty : row.Field <string>("wtshipvia"); entity.wtshipviaenabled = row.Field <bool>("wtshipviaenabled"); entity.wtcono = row.IsNull("wtcono") ? 0 : row.Field <int>("wtcono"); entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno"); entity.orderaltnoenabled = row.Field <bool>("orderaltnoenabled"); entity.orderaltnohidden = row.Field <bool>("orderaltnohidden"); entity.vaverno = row.IsNull("vaverno") ? 0 : row.Field <int>("vaverno"); entity.vavernoenabled = row.Field <bool>("vavernoenabled"); entity.vavernohidden = row.Field <bool>("vavernohidden"); entity.backordertype = row.IsNull("backordertype") ? string.Empty : row.Field <string>("backordertype"); entity.backordertypeenabled = row.Field <bool>("backordertypeenabled"); entity.powtnew = row.Field <bool>("powtnew"); entity.powtintfl = row.Field <bool>("powtintfl"); entity.miscvendor = row.Field <bool>("miscvendor"); entity.manualname = row.IsNull("manualname") ? string.Empty : row.Field <string>("manualname"); entity.manualaddr1 = row.IsNull("manualaddr1") ? string.Empty : row.Field <string>("manualaddr1"); entity.manualaddr2 = row.IsNull("manualaddr2") ? string.Empty : row.Field <string>("manualaddr2"); entity.manualaddr3 = row.IsNull("manualaddr3") ? string.Empty : row.Field <string>("manualaddr3"); entity.manualcity = row.IsNull("manualcity") ? string.Empty : row.Field <string>("manualcity"); entity.manualstate = row.IsNull("manualstate") ? string.Empty : row.Field <string>("manualstate"); entity.manualzipcd = row.IsNull("manualzipcd") ? string.Empty : row.Field <string>("manualzipcd"); entity.backtietype = row.IsNull("backtietype") ? string.Empty : row.Field <string>("backtietype"); entity.backtietypeenabled = row.Field <bool>("backtietypeenabled"); entity.backtietypehidden = row.Field <bool>("backtietypehidden"); entity.powtaltno = row.IsNull("powtaltno") ? 0 : row.Field <int>("powtaltno"); entity.powtaltnoenabled = row.Field <bool>("powtaltnoenabled"); entity.powtaltnohidden = row.Field <bool>("powtaltnohidden"); entity.backtiesrcenabled = row.Field <bool>("backtiesrcenabled"); entity.backtiesrchidden = row.Field <bool>("backtiesrchidden"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); entity.mutliSrcRowid = row.Field <byte[]>("mutli-src-rowid").ToStringEncoded(); entity.powtorderaltno = row.IsNull("powtorderaltno") ? 0 : row.Field <int>("powtorderaltno"); entity.powtorderaltnoenabled = row.Field <bool>("powtorderaltnoenabled"); entity.powtorderaltnohidden = row.Field <bool>("powtorderaltnohidden"); entity.powtorderalttype = row.IsNull("powtorderalttype") ? string.Empty : row.Field <string>("powtorderalttype"); entity.powtordertypeenabled = row.Field <bool>("powtordertypeenabled"); entity.powtlinealtno = row.IsNull("powtlinealtno") ? 0 : row.Field <int>("powtlinealtno"); entity.powtvvendno = row.IsNull("powtvvendno") ? decimal.Zero : row.Field <decimal>("powtvvendno"); entity.powtvvendnoenabled = row.Field <bool>("powtvvendnoenabled"); entity.powtvshipfmno = row.IsNull("powtvshipfmno") ? 0 : row.Field <int>("powtvshipfmno"); entity.powtvshipfmnoenabled = row.Field <bool>("powtvshipfmnoenabled"); entity.powtvduedt = row.Field <DateTime?>("powtvduedt"); entity.powtvduedtenabled = row.Field <bool>("powtvduedtenabled"); entity.powtvorderdt = row.Field <DateTime?>("powtvorderdt"); entity.powtvorderdthidden = row.Field <bool>("powtvorderdthidden"); entity.powtvshipviaty = row.IsNull("powtvshipviaty") ? string.Empty : row.Field <string>("powtvshipviaty"); entity.powtvshipviatyenabled = row.Field <bool>("powtvshipviatyenabled"); entity.powtvfobfl = row.Field <bool>("powtvfobfl"); entity.powtvfobflenabled = row.Field <bool>("powtvfobflenabled"); entity.powtvconfirmfl = row.Field <bool>("powtvconfirmfl"); entity.powtvconfirmflenabled = row.Field <bool>("powtvconfirmflenabled"); entity.powtwwhse = row.IsNull("powtwwhse") ? string.Empty : row.Field <string>("powtwwhse"); entity.powtwwhseenabled = row.Field <bool>("powtwwhseenabled"); entity.powtwduedt = row.Field <DateTime?>("powtwduedt"); entity.powtwduedtenabled = row.Field <bool>("powtwduedtenabled"); entity.powtwshipviaty = row.IsNull("powtwshipviaty") ? string.Empty : row.Field <string>("powtwshipviaty"); entity.powtwshipviatyenabled = row.Field <bool>("powtwshipviatyenabled"); entity.powtupdtfl = row.Field <bool>("powtupdtfl"); entity.powtbackordertype = row.IsNull("powtbackordertype") ? string.Empty : row.Field <string>("powtbackordertype"); entity.powtbackordertypeenabled = row.Field <bool>("powtbackordertypeenabled"); entity.powtexpediter = row.IsNull("powtexpediter") ? string.Empty : row.Field <string>("powtexpediter"); entity.powtphoneno = row.IsNull("powtphoneno") ? string.Empty : row.Field <string>("powtphoneno"); entity.powtfaxphoneno = row.IsNull("powtfaxphoneno") ? string.Empty : row.Field <string>("powtfaxphoneno"); entity.powtwtcono = row.IsNull("powtwtcono") ? 0 : row.Field <int>("powtwtcono"); entity.powtordertypelist = row.IsNull("powtordertypelist") ? string.Empty : row.Field <string>("powtordertypelist"); entity.defvendno = row.IsNull("defvendno") ? decimal.Zero : row.Field <decimal>("defvendno"); entity.defpoduedate = row.Field <DateTime?>("defpoduedate"); entity.defwtduedate = row.Field <DateTime?>("defwtduedate"); return(entity); }