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