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