/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromUpdtoelinedsplttresults(ref DataRow row, Updtoelinedsplttresults entity)
{
row.SetField("lineitemtype", entity.lineitemtype);
row.SetField("sortlineno", entity.sortlineno);
row.SetField("dspllineno", entity.dspllineno);
row.SetField("actllineno", entity.actllineno);
row.SetField("shipprod", entity.shipprod);
row.SetField("proddesc", entity.proddesc);
row.SetField("commentfl", entity.commentfl);
row.SetField("specnstype", entity.specnstype);
row.SetField("specnstypedspl", entity.specnstypedspl);
row.SetField("notesfl", entity.notesfl);
row.SetField("unit", entity.unit);
row.SetField("unitconv", entity.unitconv);
row.SetField("prodcost", entity.prodcost);
row.SetField("disctype", entity.disctype);
row.SetField("discamt", entity.discamt);
row.SetField("discamtdspl", entity.discamtdspl);
row.SetField("discpct", entity.discpct);
row.SetField("bono", entity.bono);
row.SetField("bonodspl", entity.bonodspl);
row.SetField("botype", entity.botype);
row.SetField("linedodspl", entity.linedodspl);
row.SetField("rushfl", entity.rushfl);
row.SetField("rushdspl", entity.rushdspl);
row.SetField("qtyord", entity.qtyord);
row.SetField("qtyship", entity.qtyship);
row.SetField("qtyorddspl", entity.qtyorddspl);
row.SetField("qtyshipdspl", entity.qtyshipdspl);
row.SetField("returnfl", entity.returnfl);
row.SetField("reqprod", entity.reqprod);
row.SetField("price", entity.price);
row.SetField("pricedspl", entity.pricedspl);
row.SetField("qtybreakty", entity.qtybreakty);
row.SetField("pdrecno", entity.pdrecno);
row.SetField("hardpricefl", entity.hardpricefl);
row.SetField("netord", entity.netord);
row.SetField("netamt", entity.netamt);
row.SetField("netamtdspl", entity.netamtdspl);
row.SetField("netpricedspl", entity.netpricedspl);
row.SetField("enterdt", entity.enterdt);
row.SetField("jitpickfl", entity.jitpickfl);
row.SetField("jitpickdspl", entity.jitpickdspl);
row.SetField("reqshipdt", entity.reqshipdt);
row.SetField("promisedt", entity.promisedt);
row.SetField("kitfl", entity.kitfl);
row.SetField("tallyfl", entity.tallyfl);
row.SetField("corertnty", entity.corertnty);
row.SetField("origcore", entity.origcore);
row.SetField("extrasortasc", entity.extrasortasc);
row.SetField("extrasortdsc", entity.extrasortdsc);
row.SetField("ordertype", entity.ordertype);
row.SetField("ordertypedspl", entity.ordertypedspl);
row.SetField("qtyreturn", entity.qtyreturn);
row.SetField("qtyreturndspl", entity.qtyreturndspl);
row.SetField("orderaltno", entity.orderaltno);
row.SetField("netavail", entity.netavail);
row.SetField("priceoverfl", entity.priceoverfl);
row.SetField("priceclty", entity.priceclty);
row.SetField("pricecd", entity.pricecd);
row.SetField("ptlkitbofl", entity.ptlkitbofl);
row.SetField("kitsplitamt", entity.kitsplitamt);
row.SetField("bonoptl", entity.bonoptl);
row.SetField("priceorigcd", entity.priceorigcd);
row.SetField("margin", entity.margin);
row.SetField("margindspl", entity.margindspl);
row.SetField("margpct", entity.margpct);
row.SetField("margpctdspl", entity.margpctdspl);
row.SetField("cube", entity.cube);
row.SetField("weight", entity.weight);
row.SetField("csunperstk", entity.csunperstk);
row.SetField("specconv", entity.specconv);
row.SetField("prccostper", entity.prccostper);
row.SetField("speccostty", entity.speccostty);
row.SetField("icspecrecno", entity.icspecrecno);
row.SetField("speccostdspl", entity.speccostdspl);
row.SetField("edierr", entity.edierr);
row.SetField("ediexc", entity.ediexc);
row.SetField("edilineno", entity.edilineno);
row.SetField("custprod", entity.custprod);
row.SetField("origlineno", entity.origlineno);
row.SetField("chgtolineno", entity.chgtolineno);
row.SetField("lostbusty", entity.lostbusty);
row.SetField("chgqtyfl", entity.chgqtyfl);
row.SetField("extcomfl", entity.extcomfl);
row.SetField("inventoryty", entity.inventoryty);
row.SetField("invtydspl", entity.invtydspl);
row.SetField("ncnr", entity.ncnr);
row.SetField("eccnclasscd", entity.eccnclasscd);
row.SetField("countryoforigin", entity.countryoforigin);
row.SetField("tariffcd", entity.tariffcd);
row.SetField("upcid", entity.upcid);
}
public static Updtoelinedsplttresults BuildUpdtoelinedsplttresultsFromRow(DataRow row)
{
Updtoelinedsplttresults entity = new Updtoelinedsplttresults();
entity.lineitemtype = row.IsNull("lineitemtype") ? string.Empty : row.Field <string>("lineitemtype");
entity.sortlineno = row.IsNull("sortlineno") ? 0 : row.Field <int>("sortlineno");
entity.dspllineno = row.IsNull("dspllineno") ? string.Empty : row.Field <string>("dspllineno");
entity.actllineno = row.IsNull("actllineno") ? 0 : row.Field <int>("actllineno");
entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.commentfl = row.Field <bool>("commentfl");
entity.specnstype = row.IsNull("specnstype") ? string.Empty : row.Field <string>("specnstype");
entity.specnstypedspl = row.IsNull("specnstypedspl") ? string.Empty : row.Field <string>("specnstypedspl");
entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
entity.unitconv = row.IsNull("unitconv") ? decimal.Zero : row.Field <decimal>("unitconv");
entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
entity.disctype = row.Field <bool>("disctype");
entity.discamt = row.IsNull("discamt") ? decimal.Zero : row.Field <decimal>("discamt");
entity.discamtdspl = row.IsNull("discamtdspl") ? string.Empty : row.Field <string>("discamtdspl");
entity.discpct = row.IsNull("discpct") ? decimal.Zero : row.Field <decimal>("discpct");
entity.bono = row.IsNull("bono") ? 0 : row.Field <int>("bono");
entity.bonodspl = row.IsNull("bonodspl") ? string.Empty : row.Field <string>("bonodspl");
entity.botype = row.IsNull("botype") ? string.Empty : row.Field <string>("botype");
entity.linedodspl = row.IsNull("linedodspl") ? string.Empty : row.Field <string>("linedodspl");
entity.rushfl = row.Field <bool>("rushfl");
entity.rushdspl = row.IsNull("rushdspl") ? string.Empty : row.Field <string>("rushdspl");
entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
entity.qtyship = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship");
entity.qtyorddspl = row.IsNull("qtyorddspl") ? decimal.Zero : row.Field <decimal>("qtyorddspl");
entity.qtyshipdspl = row.IsNull("qtyshipdspl") ? decimal.Zero : row.Field <decimal>("qtyshipdspl");
entity.returnfl = row.Field <bool>("returnfl");
entity.reqprod = row.IsNull("reqprod") ? string.Empty : row.Field <string>("reqprod");
entity.price = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price");
entity.pricedspl = row.IsNull("pricedspl") ? string.Empty : row.Field <string>("pricedspl");
entity.qtybreakty = row.IsNull("qtybreakty") ? string.Empty : row.Field <string>("qtybreakty");
entity.pdrecno = row.IsNull("pdrecno") ? 0 : row.Field <int>("pdrecno");
entity.hardpricefl = row.Field <bool>("hardpricefl");
entity.netord = row.IsNull("netord") ? decimal.Zero : row.Field <decimal>("netord");
entity.netamt = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt");
entity.netamtdspl = row.IsNull("netamtdspl") ? string.Empty : row.Field <string>("netamtdspl");
entity.netpricedspl = row.IsNull("netpricedspl") ? string.Empty : row.Field <string>("netpricedspl");
entity.enterdt = row.Field <DateTime?>("enterdt");
entity.jitpickfl = row.Field <bool>("jitpickfl");
entity.jitpickdspl = row.IsNull("jitpickdspl") ? string.Empty : row.Field <string>("jitpickdspl");
entity.reqshipdt = row.Field <DateTime?>("reqshipdt");
entity.promisedt = row.Field <DateTime?>("promisedt");
entity.kitfl = row.Field <bool>("kitfl");
entity.tallyfl = row.Field <bool>("tallyfl");
entity.corertnty = row.IsNull("corertnty") ? string.Empty : row.Field <string>("corertnty");
entity.origcore = row.IsNull("origcore") ? string.Empty : row.Field <string>("origcore");
entity.extrasortasc = row.IsNull("extrasortasc") ? string.Empty : row.Field <string>("extrasortasc");
entity.extrasortdsc = row.IsNull("extrasortdsc") ? string.Empty : row.Field <string>("extrasortdsc");
entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype");
entity.ordertypedspl = row.IsNull("ordertypedspl") ? string.Empty : row.Field <string>("ordertypedspl");
entity.qtyreturn = row.IsNull("qtyreturn") ? decimal.Zero : row.Field <decimal>("qtyreturn");
entity.qtyreturndspl = row.IsNull("qtyreturndspl") ? string.Empty : row.Field <string>("qtyreturndspl");
entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno");
entity.netavail = row.IsNull("netavail") ? decimal.Zero : row.Field <decimal>("netavail");
entity.priceoverfl = row.Field <bool>("priceoverfl");
entity.priceclty = row.IsNull("priceclty") ? string.Empty : row.Field <string>("priceclty");
entity.pricecd = row.IsNull("pricecd") ? decimal.Zero : row.Field <decimal>("pricecd");
entity.ptlkitbofl = row.Field <bool>("ptlkitbofl");
entity.kitsplitamt = row.IsNull("kitsplitamt") ? decimal.Zero : row.Field <decimal>("kitsplitamt");
entity.bonoptl = row.IsNull("bonoptl") ? 0 : row.Field <int>("bonoptl");
entity.priceorigcd = row.IsNull("priceorigcd") ? string.Empty : row.Field <string>("priceorigcd");
entity.margin = row.IsNull("margin") ? decimal.Zero : row.Field <decimal>("margin");
entity.margindspl = row.IsNull("margindspl") ? string.Empty : row.Field <string>("margindspl");
entity.margpct = row.IsNull("margpct") ? decimal.Zero : row.Field <decimal>("margpct");
entity.margpctdspl = row.IsNull("margpctdspl") ? string.Empty : row.Field <string>("margpctdspl");
entity.cube = row.IsNull("cube") ? decimal.Zero : row.Field <decimal>("cube");
entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field <decimal>("weight");
entity.csunperstk = row.IsNull("csunperstk") ? decimal.Zero : row.Field <decimal>("csunperstk");
entity.specconv = row.IsNull("specconv") ? 0 : row.Field <int>("specconv");
entity.prccostper = row.IsNull("prccostper") ? string.Empty : row.Field <string>("prccostper");
entity.speccostty = row.IsNull("speccostty") ? string.Empty : row.Field <string>("speccostty");
entity.icspecrecno = row.IsNull("icspecrecno") ? 0 : row.Field <int>("icspecrecno");
entity.speccostdspl = row.IsNull("speccostdspl") ? string.Empty : row.Field <string>("speccostdspl");
entity.edierr = row.IsNull("edierr") ? 0 : row.Field <int>("edierr");
entity.ediexc = row.IsNull("ediexc") ? 0 : row.Field <int>("ediexc");
entity.edilineno = row.IsNull("edilineno") ? string.Empty : row.Field <string>("edilineno");
entity.custprod = row.IsNull("custprod") ? string.Empty : row.Field <string>("custprod");
entity.origlineno = row.IsNull("origlineno") ? 0 : row.Field <int>("origlineno");
entity.chgtolineno = row.IsNull("chgtolineno") ? 0 : row.Field <int>("chgtolineno");
entity.lostbusty = row.IsNull("lostbusty") ? string.Empty : row.Field <string>("lostbusty");
entity.chgqtyfl = row.Field <bool>("chgqtyfl");
entity.extcomfl = row.Field <bool>("extcomfl");
entity.inventoryty = row.IsNull("inventoryty") ? string.Empty : row.Field <string>("inventoryty");
entity.invtydspl = row.IsNull("invtydspl") ? string.Empty : row.Field <string>("invtydspl");
entity.ncnr = row.IsNull("ncnr") ? string.Empty : row.Field <string>("ncnr");
entity.eccnclasscd = row.IsNull("eccnclasscd") ? string.Empty : row.Field <string>("eccnclasscd");
entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin");
entity.tariffcd = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd");
entity.upcid = row.IsNull("upcid") ? string.Empty : row.Field <string>("upcid");
return(entity);
}
