Exemple #1
0
 /// <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);
 }
Exemple #2
0
        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);
        }