Exemple #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromOeblanketreleasesingle(ref DataRow row, Oeblanketreleasesingle entity)
 {
     row.SetField("orderno", entity.orderno);
     row.SetField("ordersuf", entity.ordersuf);
     row.SetField("custno", entity.custno);
     row.SetField("releasetxt", entity.releasetxt);
     row.SetField("shipto", entity.shipto);
     row.SetField("shiptonm", entity.shiptonm);
     row.SetField("shiptoaddr1", entity.shiptoaddr1);
     row.SetField("shiptoaddr2", entity.shiptoaddr2);
     row.SetField("shiptoaddr3", entity.shiptoaddr3);
     row.SetField("shiptocity", entity.shiptocity);
     row.SetField("shiptost", entity.shiptost);
     row.SetField("shiptozip", entity.shiptozip);
     row.SetField("shiptocountry", entity.shiptocountry);
     row.SetField("shiptonotesfl", entity.shiptonotesfl);
     row.SetField("geocd", entity.geocd);
     row.SetField("outofcityfl", entity.outofcityfl);
     row.SetField("promisedt", entity.promisedt);
     row.SetField("promisedt-o", entity.promisedtO);
     row.SetField("origpromisedt", entity.origpromisedt);
     row.SetField("origpromisedt-o", entity.origpromisedtO);
     row.SetField("shipinstr", entity.shipinstr);
     row.SetField("extshipinstr", entity.extshipinstr);
     row.SetField("billdt", entity.billdt);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("reqshipdt-o", entity.reqshipdtO);
     row.SetField("lumpbillamt", entity.lumpbillamt);
     row.SetField("totamt", entity.totamt);
     row.SetField("remain", entity.remain);
     row.SetField("termstype", entity.termstype);
     row.SetField("shipviaty", entity.shipviaty);
     row.SetField("shipviadesc", entity.shipviadesc);
     row.SetField("termslinefl", entity.termslinefl);
     row.SetField("name", entity.name);
     row.SetField("shipreqfl", entity.shipreqfl);
     row.SetField("addr1", entity.addr1);
     row.SetField("addr2", entity.addr2);
     row.SetField("addr3", entity.addr3);
     row.SetField("city", entity.city);
     row.SetField("state", entity.state);
     row.SetField("zipcd", entity.zipcd);
     row.SetField("ordernox", entity.ordernox);
     row.SetField("stagecd", entity.stagecd);
     row.SetField("stagecdx", entity.stagecdx);
     row.SetField("transtype", entity.transtype);
     row.SetField("takenby", entity.takenby);
     row.SetField("freeformaddr", entity.freeformaddr);
     row.SetField("ordernotesfl", entity.ordernotesfl);
     row.SetField("custnotesfl", entity.custnotesfl);
     row.SetField("whse", entity.whse);
     row.SetField("saleswhse", entity.saleswhse);
     row.SetField("oeehrowid", entity.oeehrowid.ToByteArray());
     row.SetField("arscrowid", entity.arscrowid.ToByteArray());
     row.SetField("arssrowid", entity.arssrowid.ToByteArray());
     row.SetField("orderdisp", entity.orderdisp);
     row.SetField("promisedtchangedfl", entity.promisedtchangedfl);
     row.SetField("origpromisedtchangedfl", entity.origpromisedtchangedfl);
     row.SetField("reqshipdtchangedfl", entity.reqshipdtchangedfl);
     row.SetField("lndtentfl", entity.lndtentfl);
     row.SetField("dtupdtype", entity.dtupdtype);
     row.SetField("promptflushdateupdtype", entity.promptflushdateupdtype);
     row.SetField("fiShipToNm-sensitive", entity.fiShipToNmSensitive);
     row.SetField("fiShipToAddr1-sensitive", entity.fiShipToAddr1Sensitive);
     row.SetField("fiShipToAddr2-sensitive", entity.fiShipToAddr2Sensitive);
     row.SetField("fiShipToAddr3-sensitive", entity.fiShipToAddr3Sensitive);
     row.SetField("fiShipToCity-sensitive", entity.fiShipToCitySensitive);
     row.SetField("fiShipToSt-sensitive", entity.fiShipToStSensitive);
     row.SetField("fiShipToSt-hidden", entity.fiShipToStHidden);
     row.SetField("fiShipToZip-sensitive", entity.fiShipToZipSensitive);
     row.SetField("fiGeoCode-sensitive", entity.fiGeoCodeSensitive);
     row.SetField("tgOutOfCityFl-sensitive", entity.tgOutOfCityFlSensitive);
     row.SetField("btnLookupGeoCd-sensitive", entity.btnLookupGeoCdSensitive);
     row.SetField("cbCountryCd-sensitive", entity.cbCountryCdSensitive);
     row.SetField("fiShipTo-sensitive", entity.fiShipToSensitive);
     row.SetField("fiPromiseDt-sensitive", entity.fiPromiseDtSensitive);
     row.SetField("fiOrigPromiseDt-sensitive", entity.fiOrigPromiseDtSensitive);
     row.SetField("fiReqShipDt-sensitive", entity.fiReqShipDtSensitive);
     row.SetField("fiShipInstr-sensitive", entity.fiShipInstrSensitive);
     row.SetField("fiBillDt-sensitive", entity.fiBillDtSensitive);
     row.SetField("fiShipVia-sensitive", entity.fiShipViaSensitive);
     row.SetField("btnShipVia-sensitive", entity.btnShipViaSensitive);
     row.SetField("btnLookupShipTo-sensitive", entity.btnLookupShipToSensitive);
     row.SetField("fiLumpBillAmt-sensitive", entity.fiLumpBillAmtSensitive);
     row.SetField("Btn_OK-sensitive", entity.btnOKSensitive);
     row.SetField("fiState-hidden", entity.fiStateHidden);
     row.SetField("billtocountrycd", entity.billtocountrycd);
 }
Exemple #2
0
        public static Oeblanketreleasesingle BuildOeblanketreleasesingleFromRow(DataRow row)
        {
            Oeblanketreleasesingle entity = new Oeblanketreleasesingle();

            entity.orderno                  = row.IsNull("orderno") ? 0 : row.Field <int>("orderno");
            entity.ordersuf                 = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf");
            entity.custno                   = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
            entity.releasetxt               = row.IsNull("releasetxt") ? string.Empty : row.Field <string>("releasetxt");
            entity.shipto                   = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
            entity.shiptonm                 = row.IsNull("shiptonm") ? string.Empty : row.Field <string>("shiptonm");
            entity.shiptoaddr1              = row.IsNull("shiptoaddr1") ? string.Empty : row.Field <string>("shiptoaddr1");
            entity.shiptoaddr2              = row.IsNull("shiptoaddr2") ? string.Empty : row.Field <string>("shiptoaddr2");
            entity.shiptoaddr3              = row.IsNull("shiptoaddr3") ? string.Empty : row.Field <string>("shiptoaddr3");
            entity.shiptocity               = row.IsNull("shiptocity") ? string.Empty : row.Field <string>("shiptocity");
            entity.shiptost                 = row.IsNull("shiptost") ? string.Empty : row.Field <string>("shiptost");
            entity.shiptozip                = row.IsNull("shiptozip") ? string.Empty : row.Field <string>("shiptozip");
            entity.shiptocountry            = row.IsNull("shiptocountry") ? string.Empty : row.Field <string>("shiptocountry");
            entity.shiptonotesfl            = row.IsNull("shiptonotesfl") ? string.Empty : row.Field <string>("shiptonotesfl");
            entity.geocd                    = row.IsNull("geocd") ? 0 : row.Field <int>("geocd");
            entity.outofcityfl              = row.Field <bool>("outofcityfl");
            entity.promisedt                = row.Field <DateTime?>("promisedt");
            entity.promisedtO               = row.Field <DateTime?>("promisedt-o");
            entity.origpromisedt            = row.Field <DateTime?>("origpromisedt");
            entity.origpromisedtO           = row.Field <DateTime?>("origpromisedt-o");
            entity.shipinstr                = row.IsNull("shipinstr") ? string.Empty : row.Field <string>("shipinstr");
            entity.extshipinstr             = row.IsNull("extshipinstr") ? string.Empty : row.Field <string>("extshipinstr");
            entity.billdt                   = row.Field <DateTime?>("billdt");
            entity.reqshipdt                = row.Field <DateTime?>("reqshipdt");
            entity.reqshipdtO               = row.Field <DateTime?>("reqshipdt-o");
            entity.lumpbillamt              = row.IsNull("lumpbillamt") ? decimal.Zero : row.Field <decimal>("lumpbillamt");
            entity.totamt                   = row.IsNull("totamt") ? decimal.Zero : row.Field <decimal>("totamt");
            entity.remain                   = row.IsNull("remain") ? decimal.Zero : row.Field <decimal>("remain");
            entity.termstype                = row.IsNull("termstype") ? string.Empty : row.Field <string>("termstype");
            entity.shipviaty                = row.IsNull("shipviaty") ? string.Empty : row.Field <string>("shipviaty");
            entity.shipviadesc              = row.IsNull("shipviadesc") ? string.Empty : row.Field <string>("shipviadesc");
            entity.termslinefl              = row.Field <bool>("termslinefl");
            entity.name                     = row.IsNull("name") ? string.Empty : row.Field <string>("name");
            entity.shipreqfl                = row.Field <bool>("shipreqfl");
            entity.addr1                    = row.IsNull("addr1") ? string.Empty : row.Field <string>("addr1");
            entity.addr2                    = row.IsNull("addr2") ? string.Empty : row.Field <string>("addr2");
            entity.addr3                    = row.IsNull("addr3") ? string.Empty : row.Field <string>("addr3");
            entity.city                     = row.IsNull("city") ? string.Empty : row.Field <string>("city");
            entity.state                    = row.IsNull("state") ? string.Empty : row.Field <string>("state");
            entity.zipcd                    = row.IsNull("zipcd") ? string.Empty : row.Field <string>("zipcd");
            entity.ordernox                 = row.IsNull("ordernox") ? string.Empty : row.Field <string>("ordernox");
            entity.stagecd                  = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd");
            entity.stagecdx                 = row.IsNull("stagecdx") ? string.Empty : row.Field <string>("stagecdx");
            entity.transtype                = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype");
            entity.takenby                  = row.IsNull("takenby") ? string.Empty : row.Field <string>("takenby");
            entity.freeformaddr             = row.Field <bool>("freeformaddr");
            entity.ordernotesfl             = row.IsNull("ordernotesfl") ? string.Empty : row.Field <string>("ordernotesfl");
            entity.custnotesfl              = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
            entity.whse                     = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.saleswhse                = row.IsNull("saleswhse") ? string.Empty : row.Field <string>("saleswhse");
            entity.oeehrowid                = row.Field <byte[]>("oeehrowid").ToStringEncoded();
            entity.arscrowid                = row.Field <byte[]>("arscrowid").ToStringEncoded();
            entity.arssrowid                = row.Field <byte[]>("arssrowid").ToStringEncoded();
            entity.orderdisp                = row.IsNull("orderdisp") ? string.Empty : row.Field <string>("orderdisp");
            entity.promisedtchangedfl       = row.Field <bool>("promisedtchangedfl");
            entity.origpromisedtchangedfl   = row.Field <bool>("origpromisedtchangedfl");
            entity.reqshipdtchangedfl       = row.Field <bool>("reqshipdtchangedfl");
            entity.lndtentfl                = row.Field <bool>("lndtentfl");
            entity.dtupdtype                = row.IsNull("dtupdtype") ? string.Empty : row.Field <string>("dtupdtype");
            entity.promptflushdateupdtype   = row.Field <bool>("promptflushdateupdtype");
            entity.fiShipToNmSensitive      = row.Field <bool>("fiShipToNm-sensitive");
            entity.fiShipToAddr1Sensitive   = row.Field <bool>("fiShipToAddr1-sensitive");
            entity.fiShipToAddr2Sensitive   = row.Field <bool>("fiShipToAddr2-sensitive");
            entity.fiShipToAddr3Sensitive   = row.Field <bool>("fiShipToAddr3-sensitive");
            entity.fiShipToCitySensitive    = row.Field <bool>("fiShipToCity-sensitive");
            entity.fiShipToStSensitive      = row.Field <bool>("fiShipToSt-sensitive");
            entity.fiShipToStHidden         = row.Field <bool>("fiShipToSt-hidden");
            entity.fiShipToZipSensitive     = row.Field <bool>("fiShipToZip-sensitive");
            entity.fiGeoCodeSensitive       = row.Field <bool>("fiGeoCode-sensitive");
            entity.tgOutOfCityFlSensitive   = row.Field <bool>("tgOutOfCityFl-sensitive");
            entity.btnLookupGeoCdSensitive  = row.Field <bool>("btnLookupGeoCd-sensitive");
            entity.cbCountryCdSensitive     = row.Field <bool>("cbCountryCd-sensitive");
            entity.fiShipToSensitive        = row.Field <bool>("fiShipTo-sensitive");
            entity.fiPromiseDtSensitive     = row.Field <bool>("fiPromiseDt-sensitive");
            entity.fiOrigPromiseDtSensitive = row.Field <bool>("fiOrigPromiseDt-sensitive");
            entity.fiReqShipDtSensitive     = row.Field <bool>("fiReqShipDt-sensitive");
            entity.fiShipInstrSensitive     = row.Field <bool>("fiShipInstr-sensitive");
            entity.fiBillDtSensitive        = row.Field <bool>("fiBillDt-sensitive");
            entity.fiShipViaSensitive       = row.Field <bool>("fiShipVia-sensitive");
            entity.btnShipViaSensitive      = row.Field <bool>("btnShipVia-sensitive");
            entity.btnLookupShipToSensitive = row.Field <bool>("btnLookupShipTo-sensitive");
            entity.fiLumpBillAmtSensitive   = row.Field <bool>("fiLumpBillAmt-sensitive");
            entity.btnOKSensitive           = row.Field <bool>("Btn_OK-sensitive");
            entity.fiStateHidden            = row.Field <bool>("fiState-hidden");
            entity.billtocountrycd          = row.IsNull("billtocountrycd") ? string.Empty : row.Field <string>("billtocountrycd");
            return(entity);
        }