/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOeiohdrlistresults(ref DataRow row, Oeiohdrlistresults entity)
{
row.SetField("orderno", entity.orderno);
row.SetField("ordersuf", entity.ordersuf);
row.SetField("oenotesfl", entity.oenotesfl);
row.SetField("custno", entity.custno);
row.SetField("custnotesfl", entity.custnotesfl);
row.SetField("arscname", entity.arscname);
row.SetField("shipto", entity.shipto);
row.SetField("shiptonm", entity.shiptonm);
row.SetField("arssname", entity.arssname);
row.SetField("divno", entity.divno);
row.SetField("whse", entity.whse);
row.SetField("icsdname", entity.icsdname);
row.SetField("transtype", entity.transtype);
row.SetField("stagecd", entity.stagecd);
row.SetField("suspend", entity.suspend);
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("origpromisedt", entity.origpromisedt);
row.SetField("reqshipdt", entity.reqshipdt);
row.SetField("invoicedt", entity.invoicedt);
row.SetField("shipdt", entity.shipdt);
row.SetField("slsrepin", entity.slsrepin);
row.SetField("slsrepout", entity.slsrepout);
row.SetField("totqtyord", entity.totqtyord);
row.SetField("totqtyshp", entity.totqtyshp);
row.SetField("totinvamt", entity.totinvamt);
row.SetField("totlineord", entity.totlineord);
row.SetField("totlineamt", entity.totlineamt);
row.SetField("pkgno", entity.pkgno);
row.SetField("trackerno", entity.trackerno);
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("stagedesc", entity.stagedesc);
row.SetField("origincd", entity.origincd);
row.SetField("origincopyty", entity.origincopyty);
row.SetField("originorderno", entity.originorderno);
row.SetField("originordersuf", entity.originordersuf);
row.SetField("ccsubmitdt", entity.ccsubmitdt);
row.SetField("vendretauth", entity.vendretauth);
row.SetField("saleswhse", entity.saleswhse);
row.SetField("fulfillmentordfl", entity.fulfillmentordfl);
row.SetField("fulfillmenttiedfl", entity.fulfillmenttiedfl);
row.SetField("approvty", entity.approvty);
row.SetField("refer", entity.refer);
row.SetField("lspinvregstatus", entity.lspinvregstatus);
row.SetField("lspinvregstatdttmz", entity.lspinvregstatdttmz);
row.SetField("userfield", entity.userfield);
}
public static Oeiohdrlistresults BuildOeiohdrlistresultsFromRow(DataRow row)
{
Oeiohdrlistresults entity = new Oeiohdrlistresults();
entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno");
entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf");
entity.oenotesfl = row.IsNull("oenotesfl") ? string.Empty : row.Field <string>("oenotesfl");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
entity.arscname = row.IsNull("arscname") ? string.Empty : row.Field <string>("arscname");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.shiptonm = row.IsNull("shiptonm") ? string.Empty : row.Field <string>("shiptonm");
entity.arssname = row.IsNull("arssname") ? string.Empty : row.Field <string>("arssname");
entity.divno = row.IsNull("divno") ? 0 : row.Field <int>("divno");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.icsdname = row.IsNull("icsdname") ? string.Empty : row.Field <string>("icsdname");
entity.transtype = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype");
entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd");
entity.suspend = row.IsNull("suspend") ? string.Empty : row.Field <string>("suspend");
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.origpromisedt = row.Field <DateTime?>("origpromisedt");
entity.reqshipdt = row.Field <DateTime?>("reqshipdt");
entity.invoicedt = row.Field <DateTime?>("invoicedt");
entity.shipdt = row.Field <DateTime?>("shipdt");
entity.slsrepin = row.IsNull("slsrepin") ? string.Empty : row.Field <string>("slsrepin");
entity.slsrepout = row.IsNull("slsrepout") ? string.Empty : row.Field <string>("slsrepout");
entity.totqtyord = row.IsNull("totqtyord") ? decimal.Zero : row.Field <decimal>("totqtyord");
entity.totqtyshp = row.IsNull("totqtyshp") ? decimal.Zero : row.Field <decimal>("totqtyshp");
entity.totinvamt = row.IsNull("totinvamt") ? decimal.Zero : row.Field <decimal>("totinvamt");
entity.totlineord = row.IsNull("totlineord") ? decimal.Zero : row.Field <decimal>("totlineord");
entity.totlineamt = row.IsNull("totlineamt") ? decimal.Zero : row.Field <decimal>("totlineamt");
entity.pkgno = row.IsNull("pkgno") ? 0 : row.Field <int>("pkgno");
entity.trackerno = row.IsNull("trackerno") ? string.Empty : row.Field <string>("trackerno");
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.stagedesc = row.IsNull("stagedesc") ? string.Empty : row.Field <string>("stagedesc");
entity.origincd = row.IsNull("origincd") ? string.Empty : row.Field <string>("origincd");
entity.origincopyty = row.IsNull("origincopyty") ? string.Empty : row.Field <string>("origincopyty");
entity.originorderno = row.IsNull("originorderno") ? 0 : row.Field <int>("originorderno");
entity.originordersuf = row.IsNull("originordersuf") ? 0 : row.Field <int>("originordersuf");
entity.ccsubmitdt = row.Field <DateTime?>("ccsubmitdt");
entity.vendretauth = row.IsNull("vendretauth") ? string.Empty : row.Field <string>("vendretauth");
entity.saleswhse = row.IsNull("saleswhse") ? string.Empty : row.Field <string>("saleswhse");
entity.fulfillmentordfl = row.Field <bool>("fulfillmentordfl");
entity.fulfillmenttiedfl = row.Field <bool>("fulfillmenttiedfl");
entity.approvty = row.IsNull("approvty") ? string.Empty : row.Field <string>("approvty");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.lspinvregstatus = row.IsNull("lspinvregstatus") ? string.Empty : row.Field <string>("lspinvregstatus");
entity.lspinvregstatdttmz = row.Field <DateTime?>("lspinvregstatdttmz");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
