using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Text; using Core.Mes.Client.Comm.Attribute; namespace Core.StlMes.Client.PlnSaleOrd.物料Bom.entity { /// /// 数据库表SLM_ORDER_LINE所对应的实体类(生成工具:代码生成工具3.0) /// 作者:USER-20150714WV 时间:2016-06-22 /// public class SlmOrderLineEntity { /// /// 合同类型 /// private object specialtype; /// /// ORD_PK /// private object ordPk; /// /// 管理卡号(YY+MM+四位流水号) /// private object managNo; /// /// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号 /// private object orderNo; /// /// 内部管理号 /// private object orderSeqNo; /// /// 客户合同号 /// private object custmOrderNo; /// /// 评审单号(后台产生:XS/IE/GM+YYMM+四位流水号) /// private object revwRptNo; /// /// 合同类型 /// private object orderTyp; /// /// 合同类型描述 /// private object orderTypDesc; /// /// 协议号 /// private object protclNo; /// /// 客户编码 /// private object customerNo; /// /// 客户名称 /// private object customerNm; /// /// 市场系统(1006) /// //private object marketSys; /// /// 市场系统描述 /// //private object marketSysDesc; /// /// 简称 /// private object abrvition; /// /// 供货单位 /// private object supplyUnit; /// /// 计价方式(1203) /// private object priceFl; /// /// 币种 /// private object currency; /// /// 付款方式 /// private object mnyAskTyp; /// /// 结算单位编码 /// private object stlmtUnitNo; /// /// 结算单位名称 /// private object stlmtUnitNm; /// /// 首次受票人(国贸/钢贸/集团/客户) /// private object fstDraweeUnit; /// /// 法人 /// // private object legalPsn; /// /// 委托代理人 /// // private object agent; /// /// 地址 /// //private object address; /// /// 邮编 /// private object zipCode; /// /// 开户银行 /// //private object bank; /// /// 帐号 /// // private object account; /// /// 税号 /// //private object taxId; /// /// 电话 /// // private object phone; /// /// 传真 /// // private object fax; /// /// 合同量 /// // private object orderWgt; /// /// 合同总价(含税) /// //private object orderMnyTax; /// /// 合同总价(不含税) /// // private object orderMnyNtax; /// /// 付款要求描述 /// private object mnyAskDesc; /// /// 签订人 /// private object signPerson; /// /// 签订日期 /// private object signDate; /// /// 签订地点 /// private object signAddress; /// /// 合同年度 /// //private object orderYear; /// /// 合同开始时间 /// //private object orderBdate; /// /// 合同结束时间 /// //private object orderEdate; /// /// 合同扫描件编号 /// // private object orderScanNo; /// /// 是否客户范本(1:是;0:否) /// private object customerModelFl; /// /// 合同范本编号 /// //private object orderModelNo; /// /// 合同范本描述 /// //private object orderModelDesc; /// /// 销售组织(国贸/钢贸/销售公司) /// private object saleOrg; /// /// 销售组织描述 /// private object saleOrgDesc; /// /// 销售区域编码 /// private object saleAreaNo; /// /// 销售区域描述 /// private object saleAreaDesc; /// /// 合同状态 /// private object orderSts; /// /// 合同状态描述 /// private object orderStsDesc; /// /// 审批人 /// private object approvalMan; /// /// 审批时间 /// private object approvalTime; // // 生效人 // private object effectMan; // // 生效时间 // private object effectTime; /// /// 结案人 /// //private object closeMan; /// /// 结案时间 /// //private object closeTime; /// /// 创建人部门 /// private object createDept; private string regionNo = ""; /// /// 国家 /// [Description("地区/国家")] public string RegionNo { get { return regionNo; } set { regionNo = value; } } /// /// -------------------------------------合同行信息 /// /// private object ordLnPk; /// /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性) /// private object orderSeq; /// /// 客户Alpha编号 /// private object custAlphaNo; /// /// 产品规范码 /// private object psc; /// /// 产品规范描述 /// private object pscDesc; /// /// 冶金规范码 /// private object msc; /// /// 冶金规范描述 /// private object mscDesc; /// /// 冶金规范类型(A:钢管+管坯、B:钢管+接箍、C:短节+附件) /// private object mscStyle; /// /// 用途码 /// //private object useCode; /// /// 用途码描述 /// //private object useDesc; /// /// 品种分类(油井管;专业管;普管) /// private object prdCls; /// /// 品名代码 /// private object produccode; /// /// 品名描述 /// private object producname; /// /// 标准代码 /// private object stdCode; /// /// 标准名称 /// private object stdName; /// /// 钢级(牌号)代码 /// private object steelcode; /// /// 钢级(牌号)名称 /// private object steelname; /// /// 标准类别代码 /// private object stdStyle; /// /// 标准类别描述 /// private object stdStyleDesc; /// /// 订货规格代码(用于合同、质保书、标牌、标识) /// private object orderSpecCode; /// /// 订货规格描述(用于合同、质保书、标牌、标识) /// private object orderSpecDesc; /// /// 产品规格代码 /// private object specCode; /// /// 产品规格描述 /// private object specName; /// /// 外径(mm) /// private double? dimater; /// /// 壁厚(mm) /// private double? height; /// /// 扣型代码 /// private object modelCode; /// /// 扣型描述 /// private object modelDesc; /// /// 长度编码 /// private object lenNo; /// /// 长度描述 /// private object lenDesc; /// /// 长度单位 /// private object lenUnit; /// /// 下限 /// private double? lenMin; /// /// 上限 /// private double? lenMax; /// /// 短尺率(%) /// private object shrtLenRato; /// /// 短尺最短 /// private object shortest; /// /// 长尺率(%) /// private object longLenRato; /// /// 长尺最长 /// private object longest; /// /// 短尺随炉 /// private object shrtStove; /// /// 平均长度大于 /// private object avgLenMin; /// /// 最长最短差小于 /// private object difrncLenMax; /// /// 成品公差 /// private object endlenSpecstd; /// /// 单倍尺长 /// private double? siglLen; /// /// 订货计量单位(支、米、吨) /// private object orderUnit; /// /// 订货量 /// private double? orderQty; /// /// 订货保总长 /// private string ordEnsuTotlLen; /// /// 生产吨数(根据订货量计算) /// private double? prdctWgt; /// /// 交货量差方式(绝对值;百分比) /// private object delvryRangeTpe; /// /// 交货量差下限 /// // private object delvryRangeMin; /// /// 交货量差上限 /// //private object delvryRangeMax; /// /// 最终用户(来源客户表) /// private object finalUser; /// /// 最终用户描述 /// private object finalUserDesc; /// /// 外购坯(COM_BASE_INFO:1218) /// private object outsBilletFl; /// /// 外购管(COM_BASE_INFO:1219) /// private object outsStlPipeFl; /// /// ASSEL(1:允许;0:不允许) /// private Boolean asselFl; /// /// 监制要求(1:有;0:无) /// private Boolean producerFl; /// /// 监制编号(ORD_LN_PK+三位流水号) /// private object prdcrNo; /// /// 监制说明 /// private object prdcrDesc; /// /// MPS要求(1:有;0无) /// private Boolean mpsFl; /// /// MPS编号 /// private object mpsNo; /// /// MPS说明 /// private object mpsDesc; /// /// 交货开始日期 /// private object delvryBdate; /// /// 交货结束日期 /// private object delvryEdate; /// /// 交货信息描述 /// // private object delvryDesc; /// /// 运输信息描述 /// //private object transDesc; /// /// 附加要求编码 /// //private object addAskNo; /// /// 订货附加要求描述 /// private object orderAddDesc; /// /// 产品特殊要求标识 /// //private object orderSpecialFl; /// /// 特殊要求技术规范说明 /// //private object orderSpecialHead; /// /// 技术规范文件路径 /// // private object orderSpecialPath; /// /// 产品特殊要求描述 /// private object orderSpecialDesc; /// /// 质保书 /// private object zbs; /// /// 订货价 /// //private object orderPrice; /// /// 运费 /// //private object transPrice; /// /// 测价序号 /// //private object testId; /// /// 测算价 /// //private object testPrice; /// /// 出厂价 /// //private object outPrice; /// /// 结算价 /// // private object balncePrice; /// /// 合同行状态 /// private object orderLnStatus; /// /// 创建人 /// private object createName; /// /// 创建时间 /// private object createTime; /// /// 修改人 /// private object updateName; /// /// 修改时间 /// private object updateTime; /// /// 删除人 /// private object deleteName; /// /// 删除时间 /// private object deleteTime; private object containTax; /// /// containTax /// [Description("是否含税")] public object ContainTax { get { return containTax; } set { if (value == null) { containTax = DBNull.Value; } else { containTax = value; } } } //BALNCE_PRICE_STS private object aw; [Description("AW")] public object Aw { get { return aw; } set { if (value == null) { aw = DBNull.Value; } else { aw = value; } } } private object balncePriceSts; [Description("结算价状态")] public object BalncePriceSts { get { return balncePriceSts; } set { if (value == null) { balncePriceSts = DBNull.Value; } else { balncePriceSts = value; } } } private string pscNameDesc; /// /// 标的名称 /// [Description("标的名称")] public string PscNameDesc { get { return pscNameDesc; } set { pscNameDesc = value; } } //ABRVITION private string finalAbr; [Description("最终用户(简称)")] public string FinalAbr { get { return finalAbr; } set { finalAbr = value; } } private string projectNo; /// /// 订单工程编号 /// [Description("订单工程编号")] public string ProjectNo { get { return projectNo; } set { projectNo = value; } } public SlmOrderLineEntity() { projectNo = ""; finalAbr = ""; pscNameDesc = ""; containTax = ""; aw = ""; balncePriceSts = ""; specialtype = ""; orderSeqNo = ""; ordPk = ""; managNo = ""; orderNo = ""; custmOrderNo = ""; revwRptNo = ""; orderTyp = ""; orderTypDesc = ""; protclNo = ""; customerNo = ""; customerNm = ""; //marketSys = ""; //marketSysDesc = ""; abrvition = ""; supplyUnit = ""; priceFl = ""; currency = ""; mnyAskTyp = ""; stlmtUnitNo = ""; stlmtUnitNm = ""; fstDraweeUnit = ""; //legalPsn = ""; //agent = ""; //address = ""; zipCode = ""; //bank = ""; //account = ""; //taxId = ""; //phone = ""; //fax = ""; //orderWgt = ""; //orderMnyTax = ""; //orderMnyNtax = ""; mnyAskDesc = ""; signPerson = ""; signDate = ""; signAddress = ""; //orderYear = ""; //orderBdate = ""; //orderEdate = ""; //orderScanNo = ""; //customerModelFl = ""; //orderModelNo = ""; //orderModelDesc = ""; saleOrg = ""; saleOrgDesc = ""; saleAreaNo = ""; saleAreaDesc = ""; orderSts = ""; orderStsDesc = ""; approvalMan = ""; approvalTime = ""; effectMan = ""; effectTime = ""; //closeMan = ""; //closeTime = ""; createDept = ""; //------------------------------------ ordLnPk = ""; orderSeq = ""; custAlphaNo = ""; psc = ""; pscDesc = ""; msc = ""; mscDesc = ""; mscStyle = ""; //useCode = ""; //useDesc = ""; prdCls = ""; produccode = ""; producname = ""; stdCode = ""; stdName = ""; steelcode = ""; steelname = ""; stdStyle = ""; stdStyleDesc = ""; orderSpecCode = ""; orderSpecDesc = ""; specCode = ""; specName = ""; dimater = null; height = null; modelCode = ""; modelDesc = ""; lenNo = ""; lenDesc = ""; lenUnit = ""; lenMin = null; lenMax = null; shrtLenRato = ""; shortest = ""; longLenRato = ""; longest = ""; shrtStove = ""; avgLenMin = ""; difrncLenMax = ""; endlenSpecstd = ""; siglLen = null; orderUnit = ""; orderQty = null; ordEnsuTotlLen = ""; prdctWgt = null; delvryRangeTpe = ""; //delvryRangeMin = ""; //delvryRangeMax = ""; finalUser = ""; finalUserDesc = ""; outsBilletFl = ""; outsStlPipeFl = ""; asselFl = false; producerFl = false; prdcrNo = ""; prdcrDesc = ""; mpsFl = false; mpsNo = ""; mpsDesc = ""; delvryBdate = ""; delvryEdate = ""; //delvryDesc = ""; //transDesc = ""; //addAskNo = ""; orderAddDesc = ""; //orderSpecialFl = ""; //orderSpecialHead = ""; //orderSpecialPath = ""; orderSpecialDesc = ""; zbs = ""; //orderPrice = ""; //transPrice = ""; //testId = ""; //testPrice = ""; //outPrice = ""; //balncePrice = ""; orderLnStatus = ""; createName = ""; createTime = ""; updateName = ""; updateTime = ""; deleteName = ""; deleteTime = ""; } /// /// ORD_PK /// [Description("类型")] public object Specialtype { get { return specialtype; } set { if (value == null) { specialtype = DBNull.Value; } else { specialtype = value; } } } /// /// ORD_PK /// [Description("ORD_PK")] public object OrdPk { get { return ordPk; } set { if (value == null) { ordPk = DBNull.Value; } else { ordPk = value; } } } /// /// 内部管理号 /// [Description("内部管理号")] public object OrderSeqNo { get { return orderSeqNo; } set { if (value == null) { orderSeqNo = DBNull.Value; } else { orderSeqNo = value; } } } /// /// 管理卡号(YY+MM+四位流水号) /// [Description("管理卡号")] public object ManagNo { get { return managNo; } set { if (value == null) { managNo = DBNull.Value; } else { managNo = value; } } } /// /// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号 /// [Description("合同号")] public object OrderNo { get { return orderNo; } set { if (value == null) { orderNo = DBNull.Value; } else { orderNo = value; } } } /// /// 客户合同号 /// [Description("客户合同号")] public object CustmOrderNo { get { return custmOrderNo; } set { if (value == null) { custmOrderNo = DBNull.Value; } else { custmOrderNo = value; } } } /// /// 评审单号(后台产生:XS/IE/GM+YYMM+四位流水号) /// [Description("评审单号")] public object RevwRptNo { get { return revwRptNo; } set { if (value == null) { revwRptNo = DBNull.Value; } else { revwRptNo = value; } } } /// /// 合同类型 /// [Description("合同类型")] public object OrderTyp { get { return orderTyp; } set { if (value == null) { orderTyp = DBNull.Value; } else { orderTyp = value; } } } /// /// 合同类型描述 /// [Description("合同类型")] public object OrderTypDesc { get { return orderTypDesc; } set { if (value == null) { orderTypDesc = DBNull.Value; } else { orderTypDesc = value; } } } /// /// 协议号 /// [Description("协议号")] public object ProtclNo { get { return protclNo; } set { if (value == null) { protclNo = DBNull.Value; } else { protclNo = value; } } } /// /// 客户编码 /// [Description("客户编码")] public object CustomerNo { get { return customerNo; } set { if (value == null) { customerNo = DBNull.Value; } else { customerNo = value; } } } /// /// 客户名称 /// [Description("订货单位")] public object CustomerNm { get { return customerNm; } set { if (value == null) { customerNm = DBNull.Value; } else { customerNm = value; } } } ///// ///// 市场系统(1006) ///// //[Description("市场系统")] //public object MarketSys //{ // get { return marketSys; } // set // { // if (value == null) // { // marketSys = DBNull.Value; // } // else // { // marketSys = value; // } // } //} ///// ///// 市场系统描述 ///// //[Description("市场系统")] //public object MarketSysDesc //{ // get { return marketSysDesc; } // set // { // if (value == null) // { // marketSysDesc = DBNull.Value; // } // else // { // marketSysDesc = value; // } // } //} /// /// 简称 /// [Description("客户简称")] public object Abrvition { get { return abrvition; } set { if (value == null) { abrvition = DBNull.Value; } else { abrvition = value; } } } /// /// 供货单位 /// [Description("供货单位")] public object SupplyUnit { get { return supplyUnit; } set { if (value == null) { supplyUnit = DBNull.Value; } else { supplyUnit = value; } } } /// /// 计价方式(1203) /// [Description("计价方式")] public object PriceFl { get { return priceFl; } set { if (value == null) { priceFl = DBNull.Value; } else { priceFl = value; } } } /// /// 币种 /// [Description("币种")] public object Currency { get { return currency; } set { if (value == null) { currency = DBNull.Value; } else { currency = value; } } } /// /// 付款方式 /// [Description("付款方式")] public object MnyAskTyp { get { return mnyAskTyp; } set { if (value == null) { mnyAskTyp = DBNull.Value; } else { mnyAskTyp = value; } } } /// /// 结算单位编码 /// [Description("结算单位编码")] public object StlmtUnitNo { get { return stlmtUnitNo; } set { if (value == null) { stlmtUnitNo = DBNull.Value; } else { stlmtUnitNo = value; } } } /// /// 结算单位名称 /// [Description("结算单位")] public object StlmtUnitNm { get { return stlmtUnitNm; } set { if (value == null) { stlmtUnitNm = DBNull.Value; } else { stlmtUnitNm = value; } } } /// /// 首次受票人(国贸/钢贸/集团/客户) /// [Description("首次受票人")] public object FstDraweeUnit { get { return fstDraweeUnit; } set { if (value == null) { fstDraweeUnit = DBNull.Value; } else { fstDraweeUnit = value; } } } ///// ///// 法人 ///// //[Description("法人")] //public object LegalPsn //{ // get { return legalPsn; } // set // { // if (value == null) // { // legalPsn = DBNull.Value; // } // else // { // legalPsn = value; // } // } //} ///// ///// 委托代理人 ///// //[Description("委托代理人")] //public object Agent //{ // get { return agent; } // set // { // if (value == null) // { // agent = DBNull.Value; // } // else // { // agent = value; // } // } //} ///// ///// 地址 ///// //[Description("地址")] //public object Address //{ // get { return address; } // set // { // if (value == null) // { // address = DBNull.Value; // } // else // { // address = value; // } // } //} ///// ///// 邮编 ///// //[Description("邮编")] //public object ZipCode //{ // get { return zipCode; } // set // { // if (value == null) // { // zipCode = DBNull.Value; // } // else // { // zipCode = value; // } // } //} ///// ///// 开户银行 ///// //[Description("开户银行")] //public object Bank //{ // get { return bank; } // set // { // if (value == null) // { // bank = DBNull.Value; // } // else // { // bank = value; // } // } //} ///// ///// 帐号 ///// //[Description("帐号")] //public object Account //{ // get { return account; } // set // { // if (value == null) // { // account = DBNull.Value; // } // else // { // account = value; // } // } //} ///// ///// 税号 ///// //[Description("税号")] //public object TaxId //{ // get { return taxId; } // set // { // if (value == null) // { // taxId = DBNull.Value; // } // else // { // taxId = value; // } // } //} ///// ///// 电话 ///// //[Description("电话")] //public object Phone //{ // get { return phone; } // set // { // if (value == null) // { // phone = DBNull.Value; // } // else // { // phone = value; // } // } //} ///// ///// 传真 ///// //[Description("传真")] //public object Fax //{ // get { return fax; } // set // { // if (value == null) // { // fax = DBNull.Value; // } // else // { // fax = value; // } // } //} ///// ///// 合同量 ///// //[Description("合同量")] //public object OrderWgt //{ // get { return orderWgt; } // set // { // if (value == null) // { // orderWgt = DBNull.Value; // } // else // { // orderWgt = value; // } // } //} ///// ///// 合同总价(含税) ///// //[Description("合同总价(含税)")] //public object OrderMnyTax //{ // get { return orderMnyTax; } // set // { // if (value == null) // { // orderMnyTax = DBNull.Value; // } // else // { // orderMnyTax = value; // } // } //} ///// ///// 合同总价(不含税) ///// //[Description("合同总价(不含税)")] //public object OrderMnyNtax //{ // get { return orderMnyNtax; } // set // { // if (value == null) // { // orderMnyNtax = DBNull.Value; // } // else // { // orderMnyNtax = value; // } // } //} /// /// 付款要求描述 /// [Description("付款要求")] public object MnyAskDesc { get { return mnyAskDesc; } set { if (value == null) { mnyAskDesc = DBNull.Value; } else { mnyAskDesc = value; } } } /// /// 签订人 /// [Description("签订人")] public object SignPerson { get { return signPerson; } set { if (value == null) { signPerson = DBNull.Value; } else { signPerson = value; } } } /// /// 签订日期 /// [Description("签订日期")] public object SignDate { get { return signDate; } set { if (value == null) { signDate = DBNull.Value; } else { signDate = value; } } } /// /// 签订地点 /// [Description("签订地点")] public object SignAddress { get { return signAddress; } set { if (value == null) { signAddress = DBNull.Value; } else { signAddress = value; } } } ///// ///// 合同年度 ///// //[Description("合同年度")] //public object OrderYear //{ // get { return orderYear; } // set // { // if (value == null) // { // orderYear = DBNull.Value; // } // else // { // orderYear = value; // } // } //} ///// ///// 合同开始时间 ///// //[Description("合同开始时间")] //public object OrderBdate //{ // get { return orderBdate; } // set // { // if (value == null) // { // orderBdate = DBNull.Value; // } // else // { // orderBdate = value; // } // } //} ///// ///// 合同结束时间 ///// //[Description("合同结束时间")] //public object OrderEdate //{ // get { return orderEdate; } // set // { // if (value == null) // { // orderEdate = DBNull.Value; // } // else // { // orderEdate = value; // } // } //} ///// ///// 合同扫描件编号 ///// //[Description("合同扫描件编号")] //public object OrderScanNo //{ // get { return orderScanNo; } // set // { // if (value == null) // { // orderScanNo = DBNull.Value; // } // else // { // orderScanNo = value; // } // } //} /// /// 是否客户范本(1:是;0:否) /// [Description("是否客户范本")] public object CustomerModelFl { get { return customerModelFl; } set { if (value == null) { customerModelFl = DBNull.Value; } else { customerModelFl = value; } } } ///// ///// 合同范本编号 ///// //[Description("合同范本编号")] //public object OrderModelNo //{ // get { return orderModelNo; } // set // { // if (value == null) // { // orderModelNo = DBNull.Value; // } // else // { // orderModelNo = value; // } // } //} ///// ///// 合同范本描述 ///// //[Description("合同范本")] //public object OrderModelDesc //{ // get { return orderModelDesc; } // set // { // if (value == null) // { // orderModelDesc = DBNull.Value; // } // else // { // orderModelDesc = value; // } // } //} /// /// 销售组织(国贸/钢贸/销售公司) /// [Description("销售组织")] public object SaleOrg { get { return saleOrg; } set { if (value == null) { saleOrg = DBNull.Value; } else { saleOrg = value; } } } /// /// 销售组织描述 /// [Description("销售组织")] public object SaleOrgDesc { get { return saleOrgDesc; } set { if (value == null) { saleOrgDesc = DBNull.Value; } else { saleOrgDesc = value; } } } /// /// 销售区域编码 /// [Description("销售区域编码")] public object SaleAreaNo { get { return saleAreaNo; } set { if (value == null) { saleAreaNo = DBNull.Value; } else { saleAreaNo = value; } } } /// /// 销售区域描述 /// [Description("销售区域")] public object SaleAreaDesc { get { return saleAreaDesc; } set { if (value == null) { saleAreaDesc = DBNull.Value; } else { saleAreaDesc = value; } } } /// /// 合同状态 /// [Description("合同状态")] public object OrderSts { get { return orderSts; } set { if (value == null) { orderSts = DBNull.Value; } else { orderSts = value; } } } /// /// 合同状态描述 /// [Description("合同状态")] public object OrderStsDesc { get { return orderStsDesc; } set { if (value == null) { orderStsDesc = DBNull.Value; } else { orderStsDesc = value; } } } /// /// 审批人 /// [Description("审批人")] public object ApprovalMan { get { return approvalMan; } set { if (value == null) { approvalMan = DBNull.Value; } else { approvalMan = value; } } } /// /// 审批时间 /// [Description("审批时间")] public object ApprovalTime { get { return approvalTime; } set { if (value == null) { approvalTime = DBNull.Value; } else { approvalTime = value; } } } /// /// 生效人 /// [Description("生效人")] public object Effectman { get { return effectMan; } set { if (value == null) { effectMan = DBNull.Value; } else { effectMan = value; } } } /// /// 生效时间 /// [Description("生效时间")] public object Effecttime { get { return effectTime; } set { if (value == null) { effectTime = DBNull.Value; } else { effectTime = value; } } } ///// ///// 结案人 ///// //[Description("结案人")] //public object CloseMan //{ // get { return closeMan; } // set // { // if (value == null) // { // closeMan = DBNull.Value; // } // else // { // closeMan = value; // } // } //} ///// ///// 结案时间 ///// //[Description("结案时间")] //public object CloseTime //{ // get { return closeTime; } // set // { // if (value == null) // { // closeTime = DBNull.Value; // } // else // { // closeTime = value; // } // } //} /// /// 创建人部门 /// [Description("创建人部门")] public object CreateDept { get { return createDept; } set { if (value == null) { createDept = DBNull.Value; } else { createDept = value; } } } /// /// ORD_LN_PK(ORD_PK+三位流失号) /// [Description("ORD_LN_PK")] public object OrdLnPk { get { return ordLnPk; } set { if (value == null) { ordLnPk = DBNull.Value; } else { ordLnPk = value; } } } /// /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性) /// [Description("合同行号")] public object OrderSeq { get { return orderSeq; } set { if (value == null) { orderSeq = DBNull.Value; } else { orderSeq = value; } } } /// /// 客户Alpha编号 /// [Description("客户Alpha编号")] public object CustAlphaNo { get { return custAlphaNo; } set { if (value == null) { custAlphaNo = DBNull.Value; } else { custAlphaNo = value; } } } /// /// 产品规范码 /// [Description("产品规范码")] public object Psc { get { return psc; } set { if (value == null) { psc = DBNull.Value; } else { psc = value; } } } /// /// 产品规范描述 /// [Description("订货产品")] public object PscDesc { get { return pscDesc; } set { if (value == null) { pscDesc = DBNull.Value; } else { pscDesc = value; } } } /// /// 冶金规范码 /// [Description("冶金规范码")] public object Msc { get { return msc; } set { if (value == null) { msc = DBNull.Value; } else { msc = value; } } } /// /// 冶金规范描述 /// [Description("冶金规范码")] public object MscDesc { get { return mscDesc; } set { if (value == null) { mscDesc = DBNull.Value; } else { mscDesc = value; } } } /// /// 冶金规范类型(A:钢管+管坯、B:钢管+接箍、C:短节+附件) /// [Description("冶金规范类型")] public object MscStyle { get { return mscStyle; } set { if (value == null) { mscStyle = DBNull.Value; } else { mscStyle = value; } } } ///// ///// 用途码 ///// //[Description("用途码")] //public object UseCode //{ // get { return useCode; } // set // { // if (value == null) // { // useCode = DBNull.Value; // } // else // { // useCode = value; // } // } //} ///// ///// 用途码描述 ///// //[Description("用途码")] //public object UseDesc //{ // get { return useDesc; } // set // { // if (value == null) // { // useDesc = DBNull.Value; // } // else // { // useDesc = value; // } // } //} /// /// 品种分类(油井管;专业管;普管) /// [Description("品种分类")] public object PrdCls { get { return prdCls; } set { if (value == null) { prdCls = DBNull.Value; } else { prdCls = value; } } } /// /// 品名代码 /// [Description("品名代码")] public object Produccode { get { return produccode; } set { if (value == null) { produccode = DBNull.Value; } else { produccode = value; } } } /// /// 品名描述 /// [Description("品名")] public object Producname { get { return producname; } set { if (value == null) { producname = DBNull.Value; } else { producname = value; } } } /// /// 标准代码 /// [Description("标准代码")] public object StdCode { get { return stdCode; } set { if (value == null) { stdCode = DBNull.Value; } else { stdCode = value; } } } /// /// 标准名称 /// [Description("标准名称")] public object StdName { get { return stdName; } set { if (value == null) { stdName = DBNull.Value; } else { stdName = value; } } } /// /// 钢级(牌号)代码 /// [Description("钢级(牌号)代码")] public object Steelcode { get { return steelcode; } set { if (value == null) { steelcode = DBNull.Value; } else { steelcode = value; } } } /// /// 钢级(牌号)名称 /// [Description("钢级(牌号)")] public object Steelname { get { return steelname; } set { if (value == null) { steelname = DBNull.Value; } else { steelname = value; } } } /// /// 标准类别代码 /// [Description("标准类别代码")] public object StdStyle { get { return stdStyle; } set { if (value == null) { stdStyle = DBNull.Value; } else { stdStyle = value; } } } /// /// 标准类别描述 /// [Description("标准类别")] public object StdStyleDesc { get { return stdStyleDesc; } set { if (value == null) { stdStyleDesc = DBNull.Value; } else { stdStyleDesc = value; } } } /// /// 订货规格代码(用于合同、质保书、标牌、标识) /// [Description("订货规格代码")] public object OrderSpecCode { get { return orderSpecCode; } set { if (value == null) { orderSpecCode = DBNull.Value; } else { orderSpecCode = value; } } } /// /// 订货规格描述(用于合同、质保书、标牌、标识) /// [Description("订货规格")] public object OrderSpecDesc { get { return orderSpecDesc; } set { if (value == null) { orderSpecDesc = DBNull.Value; } else { orderSpecDesc = value; } } } /// /// 产品规格代码 /// [Description("产品规格代码")] public object SpecCode { get { return specCode; } set { if (value == null) { specCode = DBNull.Value; } else { specCode = value; } } } /// /// 产品规格描述 /// [Description("产品规格")] public object SpecName { get { return specName; } set { if (value == null) { specName = DBNull.Value; } else { specName = value; } } } /// /// 外径(mm) /// [Description("外径(mm)")] public double? Dimater { get { return dimater; } set { dimater = value; } } /// /// 壁厚(mm) /// [Description("壁厚(mm)")] public double? Height { get { return height; } set { height = value; } } /// /// 扣型代码 /// [Description("扣型代码")] public object ModelCode { get { return modelCode; } set { if (value == null) { modelCode = DBNull.Value; } else { modelCode = value; } } } /// /// 扣型描述 /// [Description("扣型")] public object ModelDesc { get { return modelDesc; } set { if (value == null) { modelDesc = DBNull.Value; } else { modelDesc = value; } } } /// /// 长度编码 /// [Description("长度编码")] public object LenNo { get { return lenNo; } set { if (value == null) { lenNo = DBNull.Value; } else { lenNo = value; } } } /// /// 长度描述 /// [Description("长度")] public object LenDesc { get { return lenDesc; } set { if (value == null) { lenDesc = DBNull.Value; } else { lenDesc = value; } } } /// /// 长度单位 /// [Description("长度单位")] public object LenUnit { get { return lenUnit; } set { if (value == null) { lenUnit = DBNull.Value; } else { lenUnit = value; } } } /// /// 下限 /// [Description("下限")] public double? LenMin { get { return lenMin; } set { lenMin = value; } } /// /// 上限 /// [Description("上限")] public double? LenMax { get { return lenMax; } set { lenMax = value; } } /// /// 短尺率(%) /// [Description("短尺率(%)")] public object ShrtLenRato { get { return shrtLenRato; } set { if (value == null) { shrtLenRato = DBNull.Value; } else { shrtLenRato = value; } } } /// /// 短尺最短 /// [Description("短尺最短")] public object Shortest { get { return shortest; } set { if (value == null) { shortest = DBNull.Value; } else { shortest = value; } } } /// /// 长尺率(%) /// [Description("长尺率(%)")] public object LongLenRato { get { return longLenRato; } set { if (value == null) { longLenRato = DBNull.Value; } else { longLenRato = value; } } } /// /// 长尺最长 /// [Description("长尺最长")] public object Longest { get { return longest; } set { if (value == null) { longest = DBNull.Value; } else { longest = value; } } } /// /// 短尺随炉 /// [Description("短尺随炉")] public object ShrtStove { get { return shrtStove; } set { if (value == null) { shrtStove = DBNull.Value; } else { shrtStove = value; } } } /// /// 平均长度大于 /// [Description("平均长度")] public object AvgLenMin { get { return avgLenMin; } set { if (value == null) { avgLenMin = DBNull.Value; } else { avgLenMin = value; } } } /// /// 最长最短差小于 /// [Description("最长最短差")] public object DifrncLenMax { get { return difrncLenMax; } set { if (value == null) { difrncLenMax = DBNull.Value; } else { difrncLenMax = value; } } } /// /// 成品公差 /// [Description("成品公差")] public object EndlenSpecstd { get { return endlenSpecstd; } set { if (value == null) { endlenSpecstd = DBNull.Value; } else { endlenSpecstd = value; } } } /// /// 单倍尺长 /// [Description("单倍尺长")] public double? SiglLen { get { return siglLen; } set { siglLen = value; } } /// /// 订货计量单位(支、米、吨) /// [Description("订货单位")] public object OrderUnit { get { return orderUnit; } set { if (value == null) { orderUnit = DBNull.Value; } else { orderUnit = value; } } } /// /// 订货量 /// [Description("订货量")] public double? OrderQty { get { return orderQty; } set { orderQty = value; } } /// /// 订货保总长 /// [Description("订货保总长")] public string OrdEnsuTotlLen { get { return ordEnsuTotlLen; } set { ordEnsuTotlLen = value; } } /// /// 生产吨数(根据订货量计算) /// [Description("生产量(支、吨)")] public double? PrdctWgt { get { return prdctWgt; } set { prdctWgt = value; } } /// /// 交货量差方式(绝对值;百分比) /// [Description("交货量差")] public object DelvryRangeTpe { get { return delvryRangeTpe; } set { if (value == null) { delvryRangeTpe = DBNull.Value; } else { delvryRangeTpe = value; } } } ///// ///// 交货量差下限 ///// //[Description("交货量差下限")] //public object DelvryRangeMin //{ // get { return delvryRangeMin; } // set // { // if (value == null) // { // delvryRangeMin = DBNull.Value; // } // else // { // delvryRangeMin = value; // } // } //} ///// ///// 交货量差上限 ///// //[Description("交货量差上限")] //public object DelvryRangeMax //{ // get { return delvryRangeMax; } // set // { // if (value == null) // { // delvryRangeMax = DBNull.Value; // } // else // { // delvryRangeMax = value; // } // } //} /// /// 最终用户(来源客户表) /// [Description("最终用户")] public object FinalUser { get { return finalUser; } set { if (value == null) { finalUser = DBNull.Value; } else { finalUser = value; } } } /// /// 最终用户描述 /// [Description("最终用户(全称)")] public object FinalUserDesc { get { return finalUserDesc; } set { if (value == null) { finalUserDesc = DBNull.Value; } else { finalUserDesc = value; } } } /// /// 外购坯(COM_BASE_INFO:1218) /// [Description("外购坯")] public object OutsBilletFl { get { return outsBilletFl; } set { if (value == null) { outsBilletFl = DBNull.Value; } else { outsBilletFl = value; } } } /// /// 外购管(COM_BASE_INFO:1219) /// [Description("外购管")] public object OutsStlPipeFl { get { return outsStlPipeFl; } set { if (value == null) { outsStlPipeFl = DBNull.Value; } else { outsStlPipeFl = value; } } } /// /// ASSEL(1:允许;0:不允许) /// [Description("ASSEL")] public Boolean AsselFl { get { return asselFl; } set { asselFl = value; } } /// /// 监制要求(1:有;0:无) /// [Description("监制要求")] public Boolean ProducerFl { get { return producerFl; } set { producerFl = value; } } /// /// 监制编号(ORD_LN_PK+三位流水号) /// [Description("监制编号")] public object PrdcrNo { get { return prdcrNo; } set { if (value == null) { prdcrNo = DBNull.Value; } else { prdcrNo = value; } } } /// /// 监制说明 /// [Description("监制说明")] public object PrdcrDesc { get { return prdcrDesc; } set { if (value == null) { prdcrDesc = DBNull.Value; } else { prdcrDesc = value; } } } /// /// MPS要求(1:有;0无) /// [Description("MPS要求")] public Boolean MpsFl { get { return mpsFl; } set { mpsFl = value; } } /// /// MPS编号 /// [Description("MPS编号")] public object MpsNo { get { return mpsNo; } set { if (value == null) { mpsNo = DBNull.Value; } else { mpsNo = value; } } } /// /// MPS说明 /// [Description("MPS说明")] public object MpsDesc { get { return mpsDesc; } set { if (value == null) { mpsDesc = DBNull.Value; } else { mpsDesc = value; } } } /// /// 交货开始日期 /// [Description("交货开始日期")] public object DelvryBdate { get { return delvryBdate; } set { if (value == null) { delvryBdate = DBNull.Value; } else { delvryBdate = value; } } } /// /// 交货结束日期 /// [Description("交货结束日期")] public object DelvryEdate { get { return delvryEdate; } set { if (value == null) { delvryEdate = DBNull.Value; } else { delvryEdate = value; } } } ///// ///// 交货信息描述 ///// //[Description("交货信息")] //public object DelvryDesc //{ // get { return delvryDesc; } // set // { // if (value == null) // { // delvryDesc = DBNull.Value; // } // else // { // delvryDesc = value; // } // } //} ///// ///// 运输信息描述 ///// //[Description("运输信息")] //public object TransDesc //{ // get { return transDesc; } // set // { // if (value == null) // { // transDesc = DBNull.Value; // } // else // { // transDesc = value; // } // } //} ///// ///// 附加要求编码 ///// //[Description("附加要求编码")] //public object AddAskNo //{ // get { return addAskNo; } // set // { // if (value == null) // { // addAskNo = DBNull.Value; // } // else // { // addAskNo = value; // } // } //} /// /// 订货附加要求描述 /// [Description("合同附加要求")] public object OrderAddDesc { get { return orderAddDesc; } set { if (value == null) { orderAddDesc = DBNull.Value; } else { orderAddDesc = value; } } } ///// ///// 产品特殊要求标识 ///// //[Description("产品特殊要求标识")] //public object OrderSpecialFl //{ // get { return orderSpecialFl; } // set // { // if (value == null) // { // orderSpecialFl = DBNull.Value; // } // else // { // orderSpecialFl = value; // } // } //} ///// ///// 特殊要求技术规范说明 ///// //[Description("特殊要求技术规范说明")] //public object OrderSpecialHead //{ // get { return orderSpecialHead; } // set // { // if (value == null) // { // orderSpecialHead = DBNull.Value; // } // else // { // orderSpecialHead = value; // } // } //} ///// ///// 技术规范文件路径 ///// //[Description("技术规范文件路径")] //public object OrderSpecialPath //{ // get { return orderSpecialPath; } // set // { // if (value == null) // { // orderSpecialPath = DBNull.Value; // } // else // { // orderSpecialPath = value; // } // } //} /// /// 产品特殊要求描述 /// [Description("产品特殊要求")] public object OrderSpecialDesc { get { return orderSpecialDesc; } set { if (value == null) { orderSpecialDesc = DBNull.Value; } else { orderSpecialDesc = value; } } } /// /// 质保书 /// [Description("质保书")] public object Zbs { get { return zbs; } set { if (value == null) { zbs = DBNull.Value; } else { zbs = value; } } } ///// ///// 订货价 ///// //[Description("订货价")] //public object OrderPrice //{ // get { return orderPrice; } // set // { // if (value == null) // { // orderPrice = DBNull.Value; // } // else // { // orderPrice = value; // } // } //} ///// ///// 运费 ///// //[Description("运费")] //public object TransPrice //{ // get { return transPrice; } // set // { // if (value == null) // { // transPrice = DBNull.Value; // } // else // { // transPrice = value; // } // } //} ///// ///// 测价序号 ///// //[Description("测价序号")] //public object TestId //{ // get { return testId; } // set // { // if (value == null) // { // testId = DBNull.Value; // } // else // { // testId = value; // } // } //} ///// ///// 测算价 ///// //[Description("测算价")] //public object TestPrice //{ // get { return testPrice; } // set // { // if (value == null) // { // testPrice = DBNull.Value; // } // else // { // testPrice = value; // } // } //} ///// ///// 出厂价 ///// //[Description("出厂价")] //public object OutPrice //{ // get { return outPrice; } // set // { // if (value == null) // { // outPrice = DBNull.Value; // } // else // { // outPrice = value; // } // } //} ///// ///// 结算价 ///// //[Description("结算价")] //public object BalncePrice //{ // get { return balncePrice; } // set // { // if (value == null) // { // balncePrice = DBNull.Value; // } // else // { // balncePrice = value; // } // } //} /// /// 合同行状态 /// [Description("合同行状态")] public object OrderLnStatus { get { return orderLnStatus; } set { if (value == null) { orderLnStatus = DBNull.Value; } else { orderLnStatus = value; } } } /// /// 创建人 /// [Description("创建人")] public object CreateName { get { return createName; } set { if (value == null) { createName = DBNull.Value; } else { createName = value; } } } /// /// 创建时间 /// [Description("创建时间")] public object CreateTime { get { return createTime; } set { if (value == null) { createTime = DBNull.Value; } else { createTime = value; } } } /// /// 修改人 /// [Description("修改人")] public object UpdateName { get { return updateName; } set { if (value == null) { updateName = DBNull.Value; } else { updateName = value; } } } /// /// 修改时间 /// [Description("修改时间")] public object UpdateTime { get { return updateTime; } set { if (value == null) { updateTime = DBNull.Value; } else { updateTime = value; } } } /// /// 删除人 /// [Description("删除人")] public object DeleteName { get { return deleteName; } set { if (value == null) { deleteName = DBNull.Value; } else { deleteName = value; } } } /// /// 删除时间 /// [Description("删除时间")] public object DeleteTime { get { return deleteTime; } set { if (value == null) { deleteTime = DBNull.Value; } else { deleteTime = value; } } } } }