using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.Serialization; using System.ComponentModel; using WMS.Attirubte; namespace WMS.Model.Base { /// /// 物料资料 /// [Serializable] [TableClmAttribute(TableName = "T_BASE_GOODS")] public class GoodsInfoModel { #region 已注销 // public GoodsInfoModel() // { // GOODS_ID = string.Empty; // GOODS_NAME = string.Empty; // GOODS_SHORT_NAME = string.Empty; // PY_NAME = string.Empty; // GOODS_TYPE_ID = string.Empty; // SPECIFICATION = string.Empty; // MODEL = string.Empty; // PRICE = 0; // BARCODE = string.Empty; // GLENGTH = 0; // GWIDTH = 0; // GHEIGHT = 0; // GVOLUME = 0; // SCALE_UNIT = string.Empty; // UNIT = string.Empty; // WARN_UP = 0; // WARN_DOWN = 0; // PRODUCE_AREA = string.Empty; // GROSS_WEIGHT = 0; // NET_WEIGHT = 0; // PROVIDER_ID = string.Empty; // HSNUMBER = string.Empty; // ABC = string.Empty; // STORED = string.Empty; // PERIOD = 0; // PERIODUNIT = string.Empty; // ADDTAX = 0; // SEASON = string.Empty; // TARIFFRATE = 0; // REMARK = string.Empty; // STATUS = string.Empty; // VERSION = string.Empty; // GOODS_TYPE_NAME = string.Empty; // SCALE_UNIT_NAME = string.Empty; // UNIT_NAME = string.Empty; // PROVIDER_NAME = string.Empty; // ABC_NAME = string.Empty; // STORED_NAME = string.Empty; // PERIODUNIT_NAME = string.Empty; // SEASON_NAME = string.Empty; // STATUS_NAME = string.Empty; // HAZARDOUS_NAME = string.Empty; // } ///// /////GoodsNumber ///// // [DisplayName("GoodsNumber")] // public virtual string GOODS_ID { get; set; } ///// /////Goods NAME ///// //[DisplayName("物料")] //public virtual string GOODS_NAME { get; set; } ///// /////物料简称 ///// //[DisplayName("物料简称")] //public virtual string GOODS_SHORT_NAME { get; set; } ///// /////助记码 ///// //[DisplayName("助记码")] //public virtual string PY_NAME { get; set; } ///// /////物料分类编号 ///// //[DisplayName("物料分类编号")] //[TableClmAttribute(JoinTableClmName = "GOODS_TYPE_NAME", JoinTableClm = "GOODS_TYPE_ID", ClmJoinTable = "T_BASE_GOODS_TYPE", ClassName = "GOODS_TYPE_NAME")] //public virtual string GOODS_TYPE_ID { get; set; } ///// ///// 物料分类名称 ///// //[DisplayName("物料分类")] //public virtual string GOODS_TYPE_NAME { get; set; } ///// /////规格 ///// //[DisplayName("规格")] //public virtual string SPECIFICATION { get; set; } ///// /////型号 ///// //[DisplayName("型号")] //public virtual string MODEL { get; set; } ///// /////单价 ///// //[DisplayName("单价")] //public virtual decimal PRICE { get; set; } ///// /////BarCode ///// //[DisplayName("BarCode")] //public virtual string BARCODE { get; set; } ///// /////长 ///// //[DisplayName("长")] //public virtual decimal GLENGTH { get; set; } ///// /////宽 ///// //[DisplayName("宽")] //public virtual decimal GWIDTH { get; set; } ///// /////高 ///// //[DisplayName("高")] //public virtual decimal GHEIGHT { get; set; } ///// /////体积 ///// //[DisplayName("体积")] //public virtual decimal GVOLUME { get; set; } ///// /////物料重量UNIT (字典表获取下拉) ///// //[DisplayName("重量UNIT")] //[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'kg_unit' ", ClassName = "VC_DICTIONARY_NAME")] //public virtual string SCALE_UNIT { get; set; } ///// ///// 重量UNIT ///// //[DisplayName("重量UNIT")] //public virtual string SCALE_UNIT_NAME { get; set; } ///// /////物料UNIT (字典表获取下拉) ///// //[DisplayName("物料UNIT")] //[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'vc_uom' ", ClassName = "VC_DICTIONARY_NAME")] //public virtual string UNIT { get; set; } ///// ///// 物料UNIT ///// //[DisplayName("物料UNIT")] //public virtual string UNIT_NAME { get; set; } ///// /////库存上限 ///// //[DisplayName("库存上限")] //public virtual decimal WARN_UP { get; set; } ///// /////库存下限 ///// //[DisplayName("库存下限")] //public virtual decimal WARN_DOWN { get; set; } ///// /////产地 ///// //[DisplayName("产地")] //public virtual string PRODUCE_AREA { get; set; } ///// /////毛重 ///// //[DisplayName("毛重")] //public virtual decimal GROSS_WEIGHT { get; set; } ///// /////净重 ///// //[DisplayName("净重")] //public virtual decimal NET_WEIGHT { get; set; } ///// /////供应商编号 ///// //[DisplayName("供应商编号")] //[TableClmAttribute(JoinTableClmName = "PROVIDER_NAME", JoinTableClm = "PROVIDER_ID", ClmJoinTable = "T_BASE_PROVIDER_DICTIONARY", ClassName = "PROVIDER_NAME")] //public virtual string PROVIDER_ID { get; set; } ///// ///// 供应商 ///// //[DisplayName("供应商")] //public virtual string PROVIDER_NAME { get; set; } ///// /////海关编码 (HS编码) ///// //[DisplayName("海关编码 (HS编码)")] //public virtual string HSNUMBER { get; set; } ///// /////ABC分类 ///// //[DisplayName("ABC分类")] //[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'loc_adc_class' ", ClassName = "VC_DICTIONARY_NAME")] //public virtual string ABC { get; set; } ///// ///// ABC ///// //[DisplayName("ABC等级")] //public virtual string ABC_NAME { get; set; } ///// /////危险品 0否 1是 ///// //[DisplayName("危险品")] //[TableClm(ColumnData = "否%0|是%1")] //public virtual string HAZARDOUS { get; set; } ///// ///// 危险品 ///// //[DisplayName("危险品")] //public virtual string HAZARDOUS_NAME { get; set; } ///// /////存储条件 ///// //[DisplayName("存储条件")] //[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'loc_storage' ", ClassName = "VC_DICTIONARY_NAME")] //public virtual string STORED { get; set; } ///// ///// 存储条件 ///// //[DisplayName("存储条件")] //public virtual string STORED_NAME { get; set; } ///// /////保质期 ///// //[DisplayName("保质期")] //public virtual Int64 PERIOD { get; set; } ///// /////保质期UNIT ///// //[DisplayName("保质期UNIT")] //[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'qg_unit' ", ClassName = "VC_DICTIONARY_NAME")] // public virtual string PERIODUNIT { get; set; } ///// ///// 保质期UNIT ///// //[DisplayName("保质期UNIT")] //public virtual string PERIODUNIT_NAME { get; set; } ///// /////增值税 ///// //[DisplayName("增值税")] //public virtual decimal ADDTAX { get; set; } ///// /////季节 ///// //[DisplayName("季节")] //[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'loc_season' ", ClassName = "VC_DICTIONARY_NAME")] //public virtual string SEASON { get; set; } ///// ///// 季节 ///// //[DisplayName("季节")] //public virtual string SEASON_NAME { get; set; } ///// /////关税税率 ///// //[DisplayName("关税税率")] //public virtual decimal TARIFFRATE { get; set; } ///// /////备注 ///// //[DisplayName("备注")] //public virtual string REMARK { get; set; } ///// /////Status ///// //[DisplayName("Status")] //[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'good_status' ", ClassName = "VC_DICTIONARY_NAME")] //public virtual string STATUS { get; set; } ///// ///// Status ///// //[DisplayName("Status")] //public virtual string STATUS_NAME { get; set; } ///// /////版本 ///// //[DisplayName("版本")] //public virtual string VERSION { get; set; } //private Boolean _ischeck;//第一列复选框 //[DisplayName("是否选中")] //[TableClm(NoSelect = false)] //public Boolean IsCheck //{ // get { return _ischeck; } // set { _ischeck = value; } //} #endregion private string _goods_id =string.Empty; private string _goods_name = string.Empty; private string _goods_short_name = string.Empty; private string _py_name = string.Empty; private string _goods_type_id = string.Empty; private string _specification = string.Empty; private string _model = string.Empty; private decimal _price= 0; private string _barcode = string.Empty; private decimal _glength = 0; private decimal _gwidth = 0; private decimal _gheight = 0; private decimal _gvolume= 0; private string _scale_unit= string.Empty; private string _unit= string.Empty; private decimal _warn_up= 0; private decimal _warn_down = 0; private string _produce_area= string.Empty; private decimal _gross_weight = 0; private decimal _net_weight = 0; private string _provider_id = string.Empty; private string _hsnumber = string.Empty; private string _abc = string.Empty; private string _hazardous = string.Empty; private string _stored = string.Empty; private decimal _period= 0; private string _periodunit = string.Empty; private decimal _addtax= 0; private string _season = string.Empty; private decimal _tariffrate= 0; private string _remark = string.Empty; private string _status = string.Empty; private string _version = string.Empty; private string _storage_area_id = string.Empty; private string _storage_id = string.Empty; private string _storage_name = string.Empty; private string _storage_area_name = string.Empty; private string _storage_area_short_name = string.Empty; /// /// 所属仓库 /// [DisplayName("仓库名称")] [TableClmAttribute(JoinTableClmName = "STORAGE_NAME", JoinTableClm = "STORAGE_ID", ClmJoinTable = "T_BASE_STORAGEINFO")] public string STORAGE_ID { set { _storage_id = value; } get { return _storage_id; } } string _semists = "0"; [DisplayName("是否半成品")] [TableClm(NoSelect = false)] public string SEMISTS { set { _semists = value; } get { return _semists; } } /// /// 所属仓库 /// [DisplayName("仓库名称")] [TableClm(NoSelect = false)] public string STORAGE_NAME { set { _storage_name = value; } get { return _storage_name; } } /// /// 库区编号 /// [DisplayName("库区编号")] public string STORAGE_AREA_ID { set { _storage_area_id = value; } get { return _storage_area_id; } } // private string _storage_area_name; /// /// 库区名称 /// [DisplayName("仓库库区")] public string STORAGE_AREA_NAME { set { _storage_area_name = value; } get { return _storage_area_name; } } /// ///GoodsNumber /// [DisplayName("物料编号")] public string GOODS_ID { get { return _goods_id; } set { _goods_id = value; } } /// ///Goods NAME /// [DisplayName("物料名称")] public string GOODS_NAME { get { return _goods_name; } set { _goods_name = value; } } /// ///物料简称 /// [DisplayName("物料简称")] public string GOODS_SHORT_NAME { get { return _goods_short_name; } set { _goods_short_name = value; } } /// ///助记码 /// [DisplayName("助记码")] public string PY_NAME { get { return _py_name; } set { _py_name = value; } } /// ///物料分类编号 /// [DisplayName("分类编号")] [TableClmAttribute(JoinTableClmName = "GOODS_TYPE_NAME", JoinTableClm = "GOODS_TYPE_ID", ClmJoinTable = "T_BASE_GOODS_TYPE", ClassName = "GOODS_TYPE_NAME")] public string GOODS_TYPE_ID { get { return _goods_type_id; } set { _goods_type_id = value; } } public string _goods_type_name; /// /// 物料分类名称 /// [DisplayName("分类名称")] [TableClm(NoSelect = false)] public string GOODS_TYPE_NAME { get { return _goods_type_name; } set { _goods_type_name = value; } } /// ///规格 /// [DisplayName("规格")] public string SPECIFICATION { get { return _specification; } set { _specification = value; } } /// ///型号 /// [DisplayName("型号")] public string MODEL { get { return _model; } set { _model = value; } } /// ///单价 /// [DisplayName("单价")] public decimal PRICE { get { return _price; } set { _price = value; } } /// ///BarCode /// [DisplayName("条形码")] public string BARCODE { get { return _barcode; } set { _barcode = value; } } /// ///长 /// [DisplayName("长")] public decimal GLENGTH { get { return _glength; } set { _glength = value; } } /// ///宽 /// [DisplayName("宽")] public decimal GWIDTH { get { return _gwidth; } set { _gwidth = value; } } /// ///高 /// [DisplayName("高")] public decimal GHEIGHT { get { return _gheight; } set { _gheight = value; } } /// ///体积 /// [DisplayName("体积")] public decimal GVOLUME { get { return _gvolume; } set { _gvolume = value; } } /// ///物料重量UNIT (字典表获取下拉) /// [DisplayName("重量单位")] [TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'kg_unit' ", ClassName = "VC_DICTIONARY_NAME")] public string SCALE_UNIT { get { return _scale_unit; } set { _scale_unit = value; } } public string _scale_unit_name; /// /// 重量UNIT /// [DisplayName("重量单位")] [TableClm(NoSelect = false)] public string SCALE_UNIT_NAME { get { return _scale_unit_name; } set { _scale_unit_name = value; } } /// ///物料UNIT (字典表获取下拉) /// [DisplayName("单位")] [TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'vc_uom' ", ClassName = "VC_DICTIONARY_NAME")] public string UNIT { get { return _unit; } set { _unit = value; } } public string _unit_name; /// /// 物料UNIT /// [DisplayName("单位")] [TableClm(NoSelect = false)] public string UNIT_NAME { get { return _unit_name; } set { _unit_name = value; } } /// ///库存上限 /// [DisplayName("库存上限")] public decimal WARN_UP { get { return _warn_up; } set { _warn_up = value; } } /// ///库存下限 /// [DisplayName("库存下限")] public decimal WARN_DOWN { get { return _warn_down; } set { _warn_down = value; } } /// ///产地 /// [DisplayName("产地")] public string PRODUCE_AREA { get { return _produce_area; } set { _produce_area = value; } } /// ///毛重 /// [DisplayName("毛重")] public decimal GROSS_WEIGHT { get { return _gross_weight; } set { _gross_weight = value; } } /// ///净重 /// [DisplayName("净重")] public decimal NET_WEIGHT { get { return _net_weight; } set { _net_weight = value; } } /// ///供应商编号 /// [DisplayName("供应商")] [TableClmAttribute(JoinTableClmName = "PROVIDER_NAME", JoinTableClm = "PROVIDER_ID", ClmJoinTable = "T_BASE_PROVIDER_DICTIONARY", ClassName = "PROVIDER_NAME")] public string PROVIDER_ID { get { return _provider_id; } set { _provider_id = value; } } public string _provider_name; /// /// 供应商 /// [DisplayName("供应商")] [TableClm(NoSelect = false)] public string PROVIDER_NAME { get { return _provider_name; } set { _provider_name = value; } } /// ///海关编码 (HS编码) /// [DisplayName("海关编码 (HS编码)")] public string HSNUMBER { get { return _hsnumber; } set { _hsnumber = value; } } /// ///ABC分类 /// [DisplayName("ABC等级")] [TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'loc_adc_class' ", ClassName = "VC_DICTIONARY_NAME")] public string ABC { get { return _abc; } set { _abc = value; } } public string _abc_name; /// /// ABC /// [DisplayName("ABC等级")] [TableClm(NoSelect = false)] public string ABC_NAME { get { return _abc_name; } set { _abc_name = value; } } /// ///危险品 0否 1是 /// [DisplayName("危险品")] [TableClm(ColumnData = "否%0|是%1")] public string HAZARDOUS { get { return _hazardous; } set { _hazardous = value; } } public string _hazardous_name; /// /// 危险品 /// [DisplayName("危险品")] [TableClm(NoSelect = false)] public string HAZARDOUS_NAME { get { return _hazardous_name; } set { _hazardous_name = value; } } /// ///存储条件 /// [DisplayName("存储条件")] [TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'loc_storage' ", ClassName = "VC_DICTIONARY_NAME")] public string STORED { get { return _stored; } set { _stored = value; } } public string _stored_name; /// /// 存储条件 /// [DisplayName("存储条件")] [TableClm(NoSelect = false)] public string STORED_NAME { get { return _stored_name; } set { _stored_name = value; } } /// ///保质期 /// [DisplayName("保质期")] public decimal PERIOD { get { return _period; } set { _period = value; } } /// ///保质期UNIT /// [DisplayName("保质期UNIT")] [TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'qg_unit' ", ClassName = "VC_DICTIONARY_NAME")] public string PERIODUNIT { get { return _periodunit; } set { _periodunit = value; } } public string _periodunit_name; /// /// 保质期UNIT /// [DisplayName("保质期UNIT")] [TableClm(NoSelect = false)] public string PERIODUNIT_NAME { get { return _periodunit_name; } set { _periodunit_name = value; } } /// ///增值税 /// [DisplayName("增值税")] public decimal ADDTAX { get { return _addtax; } set { _addtax = value; } } /// ///季节 /// [DisplayName("季节")] [TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'loc_season' ", ClassName = "VC_DICTIONARY_NAME")] public string SEASON { get { return _season; } set { _season = value; } } public string _season_name; /// /// 季节 /// [DisplayName("季节")] [TableClm(NoSelect = false)] public string SEASON_NAME { get { return _season_name; } set { _season_name = value; } } /// ///关税税率 /// [DisplayName("关税税率")] public decimal TARIFFRATE { get { return _tariffrate; } set { _tariffrate = value; } } /// ///备注 /// [DisplayName("备注")] public string REMARK { get { return _remark; } set { _remark = value; } } /// ///Status /// [DisplayName("Status")] [TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'good_status' ", ClassName = "VC_DICTIONARY_NAME")] public string STATUS { get { return _status; } set { _status = value; } } public string _status_name; /// /// Status /// [DisplayName("状态")] [TableClm(NoSelect = false)] public string STATUS_NAME { get { return _status_name; } set { _status_name = value; } } /// ///版本 /// [DisplayName("版本")] public string VERSION { get { return _version; } set { _version = value; } } /// ///图片 /// [DisplayName("图片")] [TableClm(NoSelect = false)] public byte[] IMG { get { return _img; } set { _img = value; } } private Boolean _ischeck ;//第一列复选框 private byte[] _img; private string _create_man =string.Empty; private string _update_man = string.Empty; private DateTime _create_date; private DateTime _update_date; private string _sc_flag = string.Empty; private string _create_man_name = string.Empty; private string _update_man_name = string.Empty; private string _sc_flag_name = string.Empty; private decimal _cost_price=0; [DisplayName("是否选中")] [TableClm(NoSelect = false)] public Boolean IsCheck { get { return _ischeck; } set { _ischeck = value; } } /// ///创建人 /// [DisplayName("创建人")] [TableClmAttribute(JoinTableClmName = "NAME", JoinTableClm = "USER_ID", ClmJoinTable = "T_BASE_USERINFO")] public string CREATE_MAN { get { return _create_man; } set { _create_man = value; } } /// ///创建人 /// [DisplayName("创建人")] [TableClm(NoSelect = false)] public string CREATE_MAN_NAME { get { return _create_man_name; } set { _create_man_name = value; } } /// ///修改人 /// [DisplayName("修改人")] [TableClm(NoSelect = false)] public string UPDATE_MAN_NAME { get { return _update_man_name; } set { _update_man_name = value; } } /// ///创建时间 /// [DisplayName("创建时间")] public DateTime CREATE_DATE { get { return _create_date; } set { _create_date = value; } } /// ///修改人 /// [DisplayName("修改人")] [TableClmAttribute(JoinTableClmName = "NAME", JoinTableClm = "USER_ID", ClmJoinTable = "T_BASE_USERINFO")] public string UPDATE_MAN { get { return _update_man; } set { _update_man = value; } } /// ///修改时间 /// [DisplayName("修改时间")] public DateTime UPDATE_DATE { get { return _update_date; } set { _update_date = value; } } /// /// 组合物料 /// [DisplayName("组合物料")] [TableClm(ColumnData = "是%1|否%0")] public string SC_FLAG { set { _sc_flag = value; } get { return _sc_flag; } } /// /// 组合物料 /// [DisplayName("组合物料")] [TableClm(NoSelect = false)] public string SC_FLAG_NAME { get { return _sc_flag_name; } set { _sc_flag_name = value; } } /// /// 成本价 /// [DisplayName("成本价")] public decimal COST_PRICE { get { return _cost_price; } set { _cost_price = value; } } } }