/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromLoadoeelallttresults(ref DataRow row, Loadoeelallttresults entity)
{
row.SetField("orderno", entity.orderno);
row.SetField("ordersuf", entity.ordersuf);
row.SetField("lineno", entity.lineno);
row.SetField("seqno", entity.seqno);
row.SetField("rectype", entity.rectype);
row.SetField("oenotesfl", entity.oenotesfl);
row.SetField("commentfl", entity.commentfl);
row.SetField("shipprod", entity.shipprod);
row.SetField("prodnotesfl", entity.prodnotesfl);
row.SetField("proddesc", entity.proddesc);
row.SetField("custno", entity.custno);
row.SetField("custnotesfl", entity.custnotesfl);
row.SetField("shipto", entity.shipto);
row.SetField("whse", entity.whse);
row.SetField("transtype", entity.transtype);
row.SetField("stagecd", entity.stagecd);
row.SetField("custpo", entity.custpo);
row.SetField("jobno", entity.jobno);
row.SetField("takenby", entity.takenby);
row.SetField("enterdt", entity.enterdt);
row.SetField("promisedt", entity.promisedt);
row.SetField("invoicedt", entity.invoicedt);
row.SetField("shipdt", entity.shipdt);
row.SetField("compprod", entity.compprod);
row.SetField("compprodnotesfl", entity.compprodnotesfl);
row.SetField("compproddesc", entity.compproddesc);
row.SetField("qtyneeded", entity.qtyneeded);
row.SetField("qtyord", entity.qtyord);
row.SetField("qtyreservd", entity.qtyreservd);
row.SetField("qtyship", entity.qtyship);
row.SetField("reqfl", entity.reqfl);
row.SetField("unit", entity.unit);
row.SetField("compseqno", entity.compseqno);
row.SetField("user1", entity.user1);
row.SetField("user2", entity.user2);
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("user8", entity.user8);
row.SetField("user9", entity.user9);
row.SetField("orderDisp", entity.orderDisp);
row.SetField("autoaltwhsefl", entity.autoaltwhsefl);
row.SetField("suspend", entity.suspend);
row.SetField("approvty", entity.approvty);
row.SetField("countryoforigin", entity.countryoforigin);
row.SetField("tariffcd", entity.tariffcd);
row.SetField("restrictcd", entity.restrictcd);
row.SetField("restrictovrfl", entity.restrictovrfl);
row.SetField("certcode", entity.certcode);
row.SetField("custreserveovrfl", entity.custreserveovrfl);
row.SetField("custreservecontractno", entity.custreservecontractno);
row.SetField("saleswhse", entity.saleswhse);
row.SetField("fulfillmentordfl", entity.fulfillmentordfl);
row.SetField("fulfillmenttiedfl", entity.fulfillmenttiedfl);
row.SetField("refer", entity.refer);
}
public static Loadoeelallttresults BuildLoadoeelallttresultsFromRow(DataRow row)
{
Loadoeelallttresults entity = new Loadoeelallttresults();
entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno");
entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf");
entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
entity.rectype = row.IsNull("rectype") ? string.Empty : row.Field <string>("rectype");
entity.oenotesfl = row.IsNull("oenotesfl") ? string.Empty : row.Field <string>("oenotesfl");
entity.commentfl = row.Field <bool>("commentfl");
entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
entity.prodnotesfl = row.IsNull("prodnotesfl") ? string.Empty : row.Field <string>("prodnotesfl");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.transtype = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype");
entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd");
entity.custpo = row.IsNull("custpo") ? string.Empty : row.Field <string>("custpo");
entity.jobno = row.IsNull("jobno") ? string.Empty : row.Field <string>("jobno");
entity.takenby = row.IsNull("takenby") ? string.Empty : row.Field <string>("takenby");
entity.enterdt = row.Field <DateTime?>("enterdt");
entity.promisedt = row.Field <DateTime?>("promisedt");
entity.invoicedt = row.Field <DateTime?>("invoicedt");
entity.shipdt = row.Field <DateTime?>("shipdt");
entity.compprod = row.IsNull("compprod") ? string.Empty : row.Field <string>("compprod");
entity.compprodnotesfl = row.IsNull("compprodnotesfl") ? string.Empty : row.Field <string>("compprodnotesfl");
entity.compproddesc = row.IsNull("compproddesc") ? string.Empty : row.Field <string>("compproddesc");
entity.qtyneeded = row.IsNull("qtyneeded") ? decimal.Zero : row.Field <decimal>("qtyneeded");
entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
entity.qtyreservd = row.IsNull("qtyreservd") ? decimal.Zero : row.Field <decimal>("qtyreservd");
entity.qtyship = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship");
entity.reqfl = row.Field <bool>("reqfl");
entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
entity.compseqno = row.IsNull("compseqno") ? 0 : row.Field <int>("compseqno");
entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1");
entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2");
entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3");
entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4");
entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5");
entity.user6 = row.Field <decimal?>("user6");
entity.user7 = row.Field <decimal?>("user7");
entity.user8 = row.Field <DateTime?>("user8");
entity.user9 = row.Field <DateTime?>("user9");
entity.orderDisp = row.IsNull("orderDisp") ? string.Empty : row.Field <string>("orderDisp");
entity.autoaltwhsefl = row.Field <bool>("autoaltwhsefl");
entity.suspend = row.IsNull("suspend") ? string.Empty : row.Field <string>("suspend");
entity.approvty = row.IsNull("approvty") ? string.Empty : row.Field <string>("approvty");
entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin");
entity.tariffcd = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd");
entity.restrictcd = row.IsNull("restrictcd") ? string.Empty : row.Field <string>("restrictcd");
entity.restrictovrfl = row.Field <bool>("restrictovrfl");
entity.certcode = row.IsNull("certcode") ? string.Empty : row.Field <string>("certcode");
entity.custreserveovrfl = row.Field <bool>("custreserveovrfl");
entity.custreservecontractno = row.IsNull("custreservecontractno") ? string.Empty : row.Field <string>("custreservecontractno");
entity.saleswhse = row.IsNull("saleswhse") ? string.Empty : row.Field <string>("saleswhse");
entity.fulfillmentordfl = row.Field <bool>("fulfillmentordfl");
entity.fulfillmenttiedfl = row.Field <bool>("fulfillmenttiedfl");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
return(entity);
}