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