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