/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromValinelistresults(ref DataRow row, Valinelistresults entity) { row.SetField("vano", entity.vano); row.SetField("vasuf", entity.vasuf); row.SetField("cvanotes", entity.cvanotes); row.SetField("seqno", entity.seqno); row.SetField("csctnnotes", entity.csctnnotes); row.SetField("lineno", entity.lineno); row.SetField("whse", entity.whse); row.SetField("nonstockty", entity.nonstockty); row.SetField("shipprod", entity.shipprod); row.SetField("notesfl", entity.notesfl); row.SetField("proddesc", entity.proddesc); row.SetField("proddesc2", entity.proddesc2); row.SetField("qtybasetotfl", entity.qtybasetotfl); row.SetField("oqtybasetotfl", entity.oqtybasetotfl); row.SetField("wipsetfl", entity.wipsetfl); row.SetField("qtyneeded", entity.qtyneeded); row.SetField("stkqtyneed", entity.stkqtyneed); row.SetField("unit", entity.unit); row.SetField("qtyord", entity.qtyord); row.SetField("stkqtyord", entity.stkqtyord); row.SetField("prodcost", entity.prodcost); row.SetField("prodcostdspl", entity.prodcostdspl); row.SetField("statustype", entity.statustype); row.SetField("commentfl", entity.commentfl); row.SetField("rushfl", entity.rushfl); row.SetField("labordata", entity.labordata); row.SetField("netamt", entity.netamt); row.SetField("netamtdspl", entity.netamtdspl); row.SetField("netglamtinfo", entity.netglamtinfo); row.SetField("sctntype", entity.sctntype); row.SetField("serlottype", entity.serlottype); row.SetField("netavail", entity.netavail); row.SetField("qtyship", entity.qtyship); row.SetField("stkqtyship", entity.stkqtyship); row.SetField("qtyonorder", entity.qtyonorder); row.SetField("usagefl", entity.usagefl); row.SetField("completefl", entity.completefl); row.SetField("boseqno", entity.boseqno); row.SetField("laborflatrtfl", entity.laborflatrtfl); row.SetField("labortype", entity.labortype); row.SetField("laborunits", entity.laborunits); row.SetField("unitconv", entity.unitconv); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("timeslsrep", entity.timeslsrep); row.SetField("timeworkdt", entity.timeworkdt); row.SetField("hours", entity.hours); row.SetField("minutes", entity.minutes); row.SetField("timeactty", entity.timeactty); row.SetField("timecomment", entity.timecomment); row.SetField("arpvendno", entity.arpvendno); row.SetField("arpprodline", entity.arpprodline); row.SetField("cubes", entity.cubes); row.SetField("arpwhse", entity.arpwhse); row.SetField("prodcat", entity.prodcat); row.SetField("weight", entity.weight); row.SetField("icspstatus", entity.icspstatus); row.SetField("qtyunavail", entity.qtyunavail); row.SetField("reasunavty", entity.reasunavty); row.SetField("orderaltno", entity.orderaltno); row.SetField("orderalttype", entity.orderalttype); row.SetField("linealtno", entity.linealtno); row.SetField("directfl", entity.directfl); row.SetField("serlotoverfl", entity.serlotoverfl); row.SetField("rowid", entity.rowid.ToByteArray()); row.SetField("ttblrowid", entity.ttblrowid.ToByteArray()); row.SetField("vvendno", entity.vvendno); row.SetField("vshipfmno", entity.vshipfmno); row.SetField("vduedt", entity.vduedt); row.SetField("vorderdt", entity.vorderdt); row.SetField("vshipviaty", entity.vshipviaty); row.SetField("vfobfl", entity.vfobfl); row.SetField("vconfirmfl", entity.vconfirmfl); row.SetField("wwhse", entity.wwhse); row.SetField("wduedt", entity.wduedt); row.SetField("wshipviaty", entity.wshipviaty); row.SetField("dispqtyordfl", entity.dispqtyordfl); row.SetField("vaprod", entity.vaprod); row.SetField("vawhse", entity.vawhse); row.SetField("dispqtyneedfl", entity.dispqtyneedfl); row.SetField("dispavailfl", entity.dispavailfl); row.SetField("availqtydspl", entity.availqtydspl); row.SetField("ordertype", entity.ordertype); row.SetField("ordertypedspl", entity.ordertypedspl); row.SetField("orderduedt", entity.orderduedt); row.SetField("builderinit", entity.builderinit); row.SetField("builderdspl", entity.builderdspl); row.SetField("timeelapsed", entity.timeelapsed); row.SetField("timeelapseddspl", entity.timeelapseddspl); row.SetField("cancelty", entity.cancelty); row.SetField("allowdelete", entity.allowdelete); row.SetField("allowcancel", entity.allowcancel); row.SetField("maxlaborcalcqty", entity.maxlaborcalcqty); row.SetField("transtype", entity.transtype); row.SetField("vadescrip", entity.vadescrip); row.SetField("vaverno", entity.vaverno); row.SetField("powtorderaltno", entity.powtorderaltno); row.SetField("powtorderalttype", entity.powtorderalttype); row.SetField("powtlinealtno", entity.powtlinealtno); row.SetField("powtvvendno", entity.powtvvendno); row.SetField("powtvshipfmno", entity.powtvshipfmno); row.SetField("powtvduedt", entity.powtvduedt); row.SetField("powtvorderdt", entity.powtvorderdt); row.SetField("powtvshipviaty", entity.powtvshipviaty); row.SetField("powtvfobfl", entity.powtvfobfl); row.SetField("powtvconfirmfl", entity.powtvconfirmfl); row.SetField("powtwwhse", entity.powtwwhse); row.SetField("powtwduedt", entity.powtwduedt); row.SetField("powtwshipviaty", entity.powtwshipviaty); row.SetField("powtupdtfl", entity.powtupdtfl); row.SetField("powtordertypedspl", entity.powtordertypedspl); row.SetField("lgthcompfl", entity.lgthcompfl); row.SetField("scrapfctr", entity.scrapfctr); row.SetField("cutoffty", entity.cutoffty); row.SetField("extcubes", entity.extcubes); row.SetField("extweight", entity.extweight); row.SetField("shpqtyoverfl", entity.shpqtyoverfl); row.SetField("costoverfl", entity.costoverfl); row.SetField("intermprodfl", entity.intermprodfl); row.SetField("wmfl", entity.wmfl); row.SetField("wmqtyship", entity.wmqtyship); row.SetField("userfield", entity.userfield); row.SetField("cutofflength", entity.cutofflength); row.SetField("allowmarkfl", entity.allowmarkfl); row.SetField("nonstockfl", entity.nonstockfl); row.SetField("seecostfl", entity.seecostfl); row.SetField("icsnpofl", entity.icsnpofl); row.SetField("iclotrcpttype", entity.iclotrcpttype); row.SetField("btnaddline-sensitive", entity.btnaddlineSensitive); row.SetField("btnaddline-hidden", entity.btnaddlineHidden); row.SetField("btnaddline-label", entity.btnaddlineLabel); row.SetField("btnrefresh-sensitive", entity.btnrefreshSensitive); row.SetField("btnrefresh-hidden", entity.btnrefreshHidden); row.SetField("m_sourcing-label", entity.mSourcingLabel); row.SetField("nonstockty-sensitive", entity.nonstocktySensitive); row.SetField("shipprod-sensitive", entity.shipprodSensitive); row.SetField("qtybasetotfl-sensitive", entity.qtybasetotflSensitive); row.SetField("qtyneeded-sensitive", entity.qtyneededSensitive); row.SetField("unit-sensitive", entity.unitSensitive); row.SetField("qtyship-sensitive", entity.qtyshipSensitive); row.SetField("rushfl-sensitive", entity.rushflSensitive); row.SetField("prodcost-sensitive", entity.prodcostSensitive); row.SetField("chgglcostfl", entity.chgglcostfl); row.SetField("cancelsimple-sensitive", entity.cancelsimpleSensitive); row.SetField("cancelsimple-hidden", entity.cancelsimpleHidden); row.SetField("cancelchoices-sensitive", entity.cancelchoicesSensitive); row.SetField("cancelchoices-hidden", entity.cancelchoicesHidden); row.SetField("askcountfl", entity.askcountfl); row.SetField("setcountfl", entity.setcountfl); row.SetField("leadtm", entity.leadtm); row.SetField("qtyavail", entity.qtyavail); row.SetField("qtyshort", entity.qtyshort); row.SetField("brandcode", entity.brandcode); row.SetField("mfgprod", entity.mfgprod); row.SetField("vendprod", entity.vendprod); row.SetField("restrictovrfl", entity.restrictovrfl); row.SetField("restricterrmess", entity.restricterrmess); row.SetField("msdsfl", entity.msdsfl); }
public static Valinelistresults BuildValinelistresultsFromRow(DataRow row) { Valinelistresults entity = new Valinelistresults(); entity.vano = row.IsNull("vano") ? 0 : row.Field <int>("vano"); entity.vasuf = row.IsNull("vasuf") ? 0 : row.Field <int>("vasuf"); entity.cvanotes = row.IsNull("cvanotes") ? string.Empty : row.Field <string>("cvanotes"); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); entity.csctnnotes = row.IsNull("csctnnotes") ? string.Empty : row.Field <string>("csctnnotes"); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.nonstockty = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty"); entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod"); entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc"); entity.proddesc2 = row.IsNull("proddesc2") ? string.Empty : row.Field <string>("proddesc2"); entity.qtybasetotfl = row.Field <bool>("qtybasetotfl"); entity.oqtybasetotfl = row.Field <bool>("oqtybasetotfl"); entity.wipsetfl = row.Field <bool>("wipsetfl"); entity.qtyneeded = row.IsNull("qtyneeded") ? decimal.Zero : row.Field <decimal>("qtyneeded"); entity.stkqtyneed = row.IsNull("stkqtyneed") ? decimal.Zero : row.Field <decimal>("stkqtyneed"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord"); entity.stkqtyord = row.IsNull("stkqtyord") ? decimal.Zero : row.Field <decimal>("stkqtyord"); entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost"); entity.prodcostdspl = row.IsNull("prodcostdspl") ? string.Empty : row.Field <string>("prodcostdspl"); entity.statustype = row.Field <bool>("statustype"); entity.commentfl = row.Field <bool>("commentfl"); entity.rushfl = row.Field <bool>("rushfl"); entity.labordata = row.IsNull("labordata") ? string.Empty : row.Field <string>("labordata"); entity.netamt = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt"); entity.netamtdspl = row.IsNull("netamtdspl") ? string.Empty : row.Field <string>("netamtdspl"); entity.netglamtinfo = row.IsNull("netglamtinfo") ? decimal.Zero : row.Field <decimal>("netglamtinfo"); entity.sctntype = row.IsNull("sctntype") ? string.Empty : row.Field <string>("sctntype"); entity.serlottype = row.IsNull("serlottype") ? string.Empty : row.Field <string>("serlottype"); entity.netavail = row.IsNull("netavail") ? decimal.Zero : row.Field <decimal>("netavail"); entity.qtyship = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship"); entity.stkqtyship = row.IsNull("stkqtyship") ? decimal.Zero : row.Field <decimal>("stkqtyship"); entity.qtyonorder = row.IsNull("qtyonorder") ? decimal.Zero : row.Field <decimal>("qtyonorder"); entity.usagefl = row.Field <bool>("usagefl"); entity.completefl = row.Field <bool>("completefl"); entity.boseqno = row.IsNull("boseqno") ? 0 : row.Field <int>("boseqno"); entity.laborflatrtfl = row.Field <bool>("laborflatrtfl"); entity.labortype = row.IsNull("labortype") ? string.Empty : row.Field <string>("labortype"); entity.laborunits = row.IsNull("laborunits") ? decimal.Zero : row.Field <decimal>("laborunits"); entity.unitconv = row.IsNull("unitconv") ? decimal.Zero : row.Field <decimal>("unitconv"); entity.icspecrecno = row.IsNull("icspecrecno") ? 0 : row.Field <int>("icspecrecno"); entity.timeslsrep = row.IsNull("timeslsrep") ? string.Empty : row.Field <string>("timeslsrep"); entity.timeworkdt = row.Field <DateTime?>("timeworkdt"); entity.hours = row.IsNull("hours") ? 0 : row.Field <int>("hours"); entity.minutes = row.IsNull("minutes") ? 0 : row.Field <int>("minutes"); entity.timeactty = row.IsNull("timeactty") ? string.Empty : row.Field <string>("timeactty"); entity.timecomment = row.IsNull("timecomment") ? string.Empty : row.Field <string>("timecomment"); entity.arpvendno = row.IsNull("arpvendno") ? decimal.Zero : row.Field <decimal>("arpvendno"); entity.arpprodline = row.IsNull("arpprodline") ? string.Empty : row.Field <string>("arpprodline"); entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes"); entity.arpwhse = row.IsNull("arpwhse") ? string.Empty : row.Field <string>("arpwhse"); entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat"); entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field <decimal>("weight"); entity.icspstatus = row.IsNull("icspstatus") ? string.Empty : row.Field <string>("icspstatus"); entity.qtyunavail = row.IsNull("qtyunavail") ? decimal.Zero : row.Field <decimal>("qtyunavail"); entity.reasunavty = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty"); entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno"); entity.orderalttype = row.IsNull("orderalttype") ? string.Empty : row.Field <string>("orderalttype"); entity.linealtno = row.IsNull("linealtno") ? 0 : row.Field <int>("linealtno"); entity.directfl = row.Field <bool>("directfl"); entity.serlotoverfl = row.Field <bool>("serlotoverfl"); entity.rowid = row.Field <byte[]>("rowid").ToStringEncoded(); entity.ttblrowid = row.Field <byte[]>("ttblrowid").ToStringEncoded(); entity.vvendno = row.IsNull("vvendno") ? decimal.Zero : row.Field <decimal>("vvendno"); entity.vshipfmno = row.IsNull("vshipfmno") ? 0 : row.Field <int>("vshipfmno"); entity.vduedt = row.Field <DateTime?>("vduedt"); entity.vorderdt = row.Field <DateTime?>("vorderdt"); entity.vshipviaty = row.IsNull("vshipviaty") ? string.Empty : row.Field <string>("vshipviaty"); entity.vfobfl = row.Field <bool>("vfobfl"); entity.vconfirmfl = row.Field <bool>("vconfirmfl"); entity.wwhse = row.IsNull("wwhse") ? string.Empty : row.Field <string>("wwhse"); entity.wduedt = row.Field <DateTime?>("wduedt"); entity.wshipviaty = row.IsNull("wshipviaty") ? string.Empty : row.Field <string>("wshipviaty"); entity.dispqtyordfl = row.Field <bool>("dispqtyordfl"); entity.vaprod = row.IsNull("vaprod") ? string.Empty : row.Field <string>("vaprod"); entity.vawhse = row.IsNull("vawhse") ? string.Empty : row.Field <string>("vawhse"); entity.dispqtyneedfl = row.Field <bool>("dispqtyneedfl"); entity.dispavailfl = row.Field <bool>("dispavailfl"); entity.availqtydspl = row.IsNull("availqtydspl") ? string.Empty : row.Field <string>("availqtydspl"); entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype"); entity.ordertypedspl = row.IsNull("ordertypedspl") ? string.Empty : row.Field <string>("ordertypedspl"); entity.orderduedt = row.Field <DateTime?>("orderduedt"); entity.builderinit = row.IsNull("builderinit") ? string.Empty : row.Field <string>("builderinit"); entity.builderdspl = row.IsNull("builderdspl") ? string.Empty : row.Field <string>("builderdspl"); entity.timeelapsed = row.IsNull("timeelapsed") ? 0 : row.Field <int>("timeelapsed"); entity.timeelapseddspl = row.IsNull("timeelapseddspl") ? string.Empty : row.Field <string>("timeelapseddspl"); entity.cancelty = row.IsNull("cancelty") ? string.Empty : row.Field <string>("cancelty"); entity.allowdelete = row.Field <bool>("allowdelete"); entity.allowcancel = row.Field <bool>("allowcancel"); entity.maxlaborcalcqty = row.IsNull("maxlaborcalcqty") ? 0 : row.Field <int>("maxlaborcalcqty"); entity.transtype = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype"); entity.vadescrip = row.IsNull("vadescrip") ? string.Empty : row.Field <string>("vadescrip"); entity.vaverno = row.IsNull("vaverno") ? 0 : row.Field <int>("vaverno"); entity.powtorderaltno = row.IsNull("powtorderaltno") ? 0 : row.Field <int>("powtorderaltno"); entity.powtorderalttype = row.IsNull("powtorderalttype") ? string.Empty : row.Field <string>("powtorderalttype"); entity.powtlinealtno = row.IsNull("powtlinealtno") ? 0 : row.Field <int>("powtlinealtno"); entity.powtvvendno = row.IsNull("powtvvendno") ? decimal.Zero : row.Field <decimal>("powtvvendno"); entity.powtvshipfmno = row.IsNull("powtvshipfmno") ? 0 : row.Field <int>("powtvshipfmno"); entity.powtvduedt = row.Field <DateTime?>("powtvduedt"); entity.powtvorderdt = row.Field <DateTime?>("powtvorderdt"); entity.powtvshipviaty = row.IsNull("powtvshipviaty") ? string.Empty : row.Field <string>("powtvshipviaty"); entity.powtvfobfl = row.Field <bool>("powtvfobfl"); entity.powtvconfirmfl = row.Field <bool>("powtvconfirmfl"); entity.powtwwhse = row.IsNull("powtwwhse") ? string.Empty : row.Field <string>("powtwwhse"); entity.powtwduedt = row.Field <DateTime?>("powtwduedt"); entity.powtwshipviaty = row.IsNull("powtwshipviaty") ? string.Empty : row.Field <string>("powtwshipviaty"); entity.powtupdtfl = row.Field <bool>("powtupdtfl"); entity.powtordertypedspl = row.IsNull("powtordertypedspl") ? string.Empty : row.Field <string>("powtordertypedspl"); entity.lgthcompfl = row.Field <bool>("lgthcompfl"); entity.scrapfctr = row.IsNull("scrapfctr") ? decimal.Zero : row.Field <decimal>("scrapfctr"); entity.cutoffty = row.IsNull("cutoffty") ? string.Empty : row.Field <string>("cutoffty"); entity.extcubes = row.IsNull("extcubes") ? decimal.Zero : row.Field <decimal>("extcubes"); entity.extweight = row.IsNull("extweight") ? decimal.Zero : row.Field <decimal>("extweight"); entity.shpqtyoverfl = row.IsNull("shpqtyoverfl") ? decimal.Zero : row.Field <decimal>("shpqtyoverfl"); entity.costoverfl = row.IsNull("costoverfl") ? decimal.Zero : row.Field <decimal>("costoverfl"); entity.intermprodfl = row.IsNull("intermprodfl") ? decimal.Zero : row.Field <decimal>("intermprodfl"); entity.wmfl = row.Field <bool>("wmfl"); entity.wmqtyship = row.IsNull("wmqtyship") ? decimal.Zero : row.Field <decimal>("wmqtyship"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); entity.cutofflength = row.IsNull("cutofflength") ? decimal.Zero : row.Field <decimal>("cutofflength"); entity.allowmarkfl = row.Field <bool>("allowmarkfl"); entity.nonstockfl = row.Field <bool>("nonstockfl"); entity.seecostfl = row.Field <bool>("seecostfl"); entity.icsnpofl = row.Field <bool>("icsnpofl"); entity.iclotrcpttype = row.IsNull("iclotrcpttype") ? string.Empty : row.Field <string>("iclotrcpttype"); entity.btnaddlineSensitive = row.Field <bool>("btnaddline-sensitive"); entity.btnaddlineHidden = row.Field <bool>("btnaddline-hidden"); entity.btnaddlineLabel = row.IsNull("btnaddline-label") ? string.Empty : row.Field <string>("btnaddline-label"); entity.btnrefreshSensitive = row.Field <bool>("btnrefresh-sensitive"); entity.btnrefreshHidden = row.Field <bool>("btnrefresh-hidden"); entity.mSourcingLabel = row.IsNull("m_sourcing-label") ? string.Empty : row.Field <string>("m_sourcing-label"); entity.nonstocktySensitive = row.Field <bool>("nonstockty-sensitive"); entity.shipprodSensitive = row.Field <bool>("shipprod-sensitive"); entity.qtybasetotflSensitive = row.Field <bool>("qtybasetotfl-sensitive"); entity.qtyneededSensitive = row.Field <bool>("qtyneeded-sensitive"); entity.unitSensitive = row.Field <bool>("unit-sensitive"); entity.qtyshipSensitive = row.Field <bool>("qtyship-sensitive"); entity.rushflSensitive = row.Field <bool>("rushfl-sensitive"); entity.prodcostSensitive = row.Field <bool>("prodcost-sensitive"); entity.chgglcostfl = row.Field <bool>("chgglcostfl"); entity.cancelsimpleSensitive = row.Field <bool>("cancelsimple-sensitive"); entity.cancelsimpleHidden = row.Field <bool>("cancelsimple-hidden"); entity.cancelchoicesSensitive = row.Field <bool>("cancelchoices-sensitive"); entity.cancelchoicesHidden = row.Field <bool>("cancelchoices-hidden"); entity.askcountfl = row.Field <bool>("askcountfl"); entity.setcountfl = row.Field <bool>("setcountfl"); entity.leadtm = row.IsNull("leadtm") ? 0 : row.Field <int>("leadtm"); entity.qtyavail = row.IsNull("qtyavail") ? decimal.Zero : row.Field <decimal>("qtyavail"); entity.qtyshort = row.IsNull("qtyshort") ? decimal.Zero : row.Field <decimal>("qtyshort"); entity.brandcode = row.IsNull("brandcode") ? string.Empty : row.Field <string>("brandcode"); entity.mfgprod = row.IsNull("mfgprod") ? string.Empty : row.Field <string>("mfgprod"); entity.vendprod = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod"); entity.restrictovrfl = row.Field <bool>("restrictovrfl"); entity.restricterrmess = row.IsNull("restricterrmess") ? string.Empty : row.Field <string>("restricterrmess"); entity.msdsfl = row.Field <bool>("msdsfl"); return(entity); }