467 lines
14 KiB
C#
467 lines
14 KiB
C#
|
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
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
/// 物料规格
|
|||
|
|
/// </summary>
|
|||
|
|
[Serializable]
|
|||
|
|
[TableClmAttribute(TableName = "T_BASE_SKU")]
|
|||
|
|
public class SKUModel
|
|||
|
|
{
|
|||
|
|
#region Model
|
|||
|
|
private string _sku_id;
|
|||
|
|
private string _sku_name;
|
|||
|
|
private decimal _sku_num;
|
|||
|
|
private string _goods_id;
|
|||
|
|
private string _brand;
|
|||
|
|
private string _gmodel;
|
|||
|
|
private string _gsize;
|
|||
|
|
private string _configure;
|
|||
|
|
private string _gclass;
|
|||
|
|
private string _color;
|
|||
|
|
private string _design_color;
|
|||
|
|
private string _capacity_packing;
|
|||
|
|
private string _unit;
|
|||
|
|
private string _guse;
|
|||
|
|
private decimal _price;
|
|||
|
|
private string _origin;
|
|||
|
|
private decimal _glength;
|
|||
|
|
private decimal _gwidth;
|
|||
|
|
private decimal _gheight;
|
|||
|
|
private decimal _gvolume;
|
|||
|
|
private string _gvolume_unit;
|
|||
|
|
private decimal _gross_weight;
|
|||
|
|
private decimal _net_weight;
|
|||
|
|
private string _scale_unit;
|
|||
|
|
private string _provider_id;
|
|||
|
|
private string _hsnumber;
|
|||
|
|
private string _abc;
|
|||
|
|
private string _hazardous;
|
|||
|
|
private string _gstored;
|
|||
|
|
private decimal _period;
|
|||
|
|
private string _periodunit;
|
|||
|
|
private decimal _addtax;
|
|||
|
|
private string _season;
|
|||
|
|
private decimal _tariffrate;
|
|||
|
|
private string _gift_flag;
|
|||
|
|
private string _sc_flag;
|
|||
|
|
private string _status;
|
|||
|
|
private byte[] _img;
|
|||
|
|
private string _remark;
|
|||
|
|
private string _create_man;
|
|||
|
|
private DateTime _create_date;
|
|||
|
|
private string _update_man;
|
|||
|
|
private DateTime _update_date;
|
|||
|
|
/// <summary>
|
|||
|
|
/// 规格编号
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("规格")]
|
|||
|
|
public string SKU_ID
|
|||
|
|
{
|
|||
|
|
set { _sku_id = value; }
|
|||
|
|
get { return _sku_id; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 规格名称
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("规格名称")]
|
|||
|
|
public string SKU_NAME
|
|||
|
|
{
|
|||
|
|
set { _sku_name = value; }
|
|||
|
|
get { return _sku_name; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 规格数量
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("规格数量")]
|
|||
|
|
[TableClm(NoSelect = false)]
|
|||
|
|
public decimal Sku_num
|
|||
|
|
{
|
|||
|
|
get { return _sku_num; }
|
|||
|
|
set { _sku_num = value; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 物料编号
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("物料")]
|
|||
|
|
public string GOODS_ID
|
|||
|
|
{
|
|||
|
|
set { _goods_id = value; }
|
|||
|
|
get { return _goods_id; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 品牌
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("品牌")]
|
|||
|
|
public string BRAND
|
|||
|
|
{
|
|||
|
|
set { _brand = value; }
|
|||
|
|
get { return _brand; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 型号
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("型号")]
|
|||
|
|
public string GMODEL
|
|||
|
|
{
|
|||
|
|
set { _gmodel = value; }
|
|||
|
|
get { return _gmodel; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 尺码
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("尺码")]
|
|||
|
|
public string GSIZE
|
|||
|
|
{
|
|||
|
|
set { _gsize = value; }
|
|||
|
|
get { return _gsize; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 配置
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("配置")]
|
|||
|
|
public string CONFIGURE
|
|||
|
|
{
|
|||
|
|
set { _configure = value; }
|
|||
|
|
get { return _configure; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 等级
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("等级")]
|
|||
|
|
public string GCLASS
|
|||
|
|
{
|
|||
|
|
set { _gclass = value; }
|
|||
|
|
get { return _gclass; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 颜色
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("颜色")]
|
|||
|
|
public string COLOR
|
|||
|
|
{
|
|||
|
|
set { _color = value; }
|
|||
|
|
get { return _color; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 花色
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("花色")]
|
|||
|
|
public string DESIGN_COLOR
|
|||
|
|
{
|
|||
|
|
set { _design_color = value; }
|
|||
|
|
get { return _design_color; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 包装容量
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("包装容量")]
|
|||
|
|
public string CAPACITY_PACKING
|
|||
|
|
{
|
|||
|
|
set { _capacity_packing = value; }
|
|||
|
|
get { return _capacity_packing; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 单位 （字典表获取下拉）
|
|||
|
|
/// </summary>
|
|||
|
|
[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
|
|||
|
|
{
|
|||
|
|
set { _unit = value; }
|
|||
|
|
get { return _unit; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 用途
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("用途")]
|
|||
|
|
public string GUSE
|
|||
|
|
{
|
|||
|
|
set { _guse = value; }
|
|||
|
|
get { return _guse; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 价格
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("价格")]
|
|||
|
|
public decimal PRICE
|
|||
|
|
{
|
|||
|
|
set { _price = value; }
|
|||
|
|
get { return _price; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 产地
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("产地")]
|
|||
|
|
public string ORIGIN
|
|||
|
|
{
|
|||
|
|
set { _origin = value; }
|
|||
|
|
get { return _origin; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 长
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("长")]
|
|||
|
|
public decimal GLENGTH
|
|||
|
|
{
|
|||
|
|
set { _glength = value; }
|
|||
|
|
get { return _glength; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 宽
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("宽")]
|
|||
|
|
public decimal GWIDTH
|
|||
|
|
{
|
|||
|
|
set { _gwidth = value; }
|
|||
|
|
get { return _gwidth; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 高
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("高")]
|
|||
|
|
public decimal GHEIGHT
|
|||
|
|
{
|
|||
|
|
set { _gheight = value; }
|
|||
|
|
get { return _gheight; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 体积
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("体积")]
|
|||
|
|
public decimal GVOLUME
|
|||
|
|
{
|
|||
|
|
set { _gvolume = value; }
|
|||
|
|
get { return _gvolume; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 体积单位
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("体积单位")]
|
|||
|
|
public string GVOLUME_UNIT
|
|||
|
|
{
|
|||
|
|
set { _gvolume_unit = value; }
|
|||
|
|
get { return _gvolume_unit; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 毛重
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("毛重")]
|
|||
|
|
public decimal GROSS_WEIGHT
|
|||
|
|
{
|
|||
|
|
set { _gross_weight = value; }
|
|||
|
|
get { return _gross_weight; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 净重
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("净重")]
|
|||
|
|
public decimal NET_WEIGHT
|
|||
|
|
{
|
|||
|
|
set { _net_weight = value; }
|
|||
|
|
get { return _net_weight; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 重量单位 （字典表获取下拉）
|
|||
|
|
/// </summary>
|
|||
|
|
[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
|
|||
|
|
{
|
|||
|
|
set { _scale_unit = value; }
|
|||
|
|
get { return _scale_unit; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 供应商编号
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("供应商")]
|
|||
|
|
[TableClmAttribute(JoinTableClmName = "PROVIDER_NAME", JoinTableClm = "PROVIDER_ID", ClmJoinTable = "T_BASE_PROVIDER_DICTIONARY", ClassName = "PROVIDER_NAME")]
|
|||
|
|
public string PROVIDER_ID
|
|||
|
|
{
|
|||
|
|
set { _provider_id = value; }
|
|||
|
|
get { return _provider_id; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 海关编码 （HS编码）
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("海关编码")]
|
|||
|
|
public string HSNUMBER
|
|||
|
|
{
|
|||
|
|
set { _hsnumber = value; }
|
|||
|
|
get { return _hsnumber; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// ABC分类
|
|||
|
|
/// </summary>
|
|||
|
|
[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
|
|||
|
|
{
|
|||
|
|
set { _abc = value; }
|
|||
|
|
get { return _abc; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 危险品 0否 1是
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("危险品")]
|
|||
|
|
[TableClm(ColumnData = "否%0|是%1")]
|
|||
|
|
public string HAZARDOUS
|
|||
|
|
{
|
|||
|
|
set { _hazardous = value; }
|
|||
|
|
get { return _hazardous; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 存储条件
|
|||
|
|
/// </summary>
|
|||
|
|
[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 GSTORED
|
|||
|
|
{
|
|||
|
|
set { _gstored = value; }
|
|||
|
|
get { return _gstored; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 保质期
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("保质期")]
|
|||
|
|
public decimal PERIOD
|
|||
|
|
{
|
|||
|
|
set { _period = value; }
|
|||
|
|
get { return _period; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 保质期单位
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("保质期单位")]
|
|||
|
|
[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
|
|||
|
|
{
|
|||
|
|
set { _periodunit = value; }
|
|||
|
|
get { return _periodunit; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 增值税
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("增值税")]
|
|||
|
|
public decimal ADDTAX
|
|||
|
|
{
|
|||
|
|
set { _addtax = value; }
|
|||
|
|
get { return _addtax; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 季节
|
|||
|
|
/// </summary>
|
|||
|
|
[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
|
|||
|
|
{
|
|||
|
|
set { _season = value; }
|
|||
|
|
get { return _season; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 关税税率
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("关税税率")]
|
|||
|
|
public decimal TARIFFRATE
|
|||
|
|
{
|
|||
|
|
set { _tariffrate = value; }
|
|||
|
|
get { return _tariffrate; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 是否是赠品 0否 1是
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("赠品")]
|
|||
|
|
[TableClm(ColumnData = "是%1|否%0")]
|
|||
|
|
public string GIFT_FLAG
|
|||
|
|
{
|
|||
|
|
set { _gift_flag = value; }
|
|||
|
|
get { return _gift_flag; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 是否是组合物料 0否 1是
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("组合物料")]
|
|||
|
|
[TableClm(ColumnData = "是%1|否%0")]
|
|||
|
|
public string SC_FLAG
|
|||
|
|
{
|
|||
|
|
set { _sc_flag = value; }
|
|||
|
|
get { return _sc_flag; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 状态
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("状态")]
|
|||
|
|
[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
|
|||
|
|
{
|
|||
|
|
set { _status = value; }
|
|||
|
|
get { return _status; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 图片
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("图片")]
|
|||
|
|
[TableClm(NoSelect = false)]
|
|||
|
|
public byte[] IMG
|
|||
|
|
{
|
|||
|
|
set { _img = value; }
|
|||
|
|
get { return _img; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 备注
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("备注")]
|
|||
|
|
public string REMARK
|
|||
|
|
{
|
|||
|
|
set { _remark = value; }
|
|||
|
|
get { return _remark; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 创建人
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("创建人")]
|
|||
|
|
public string CREATE_MAN
|
|||
|
|
{
|
|||
|
|
set { _create_man = value; }
|
|||
|
|
get { return _create_man; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 创建时间
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("创建时间")]
|
|||
|
|
public DateTime CREATE_DATE
|
|||
|
|
{
|
|||
|
|
set { _create_date = value; }
|
|||
|
|
get { return _create_date; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 修改人
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("修改人")]
|
|||
|
|
public string UPDATE_MAN
|
|||
|
|
{
|
|||
|
|
set { _update_man = value; }
|
|||
|
|
get { return _update_man; }
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 修改时间
|
|||
|
|
/// </summary>
|
|||
|
|
[DisplayName("修改时间")]
|
|||
|
|
public DateTime UPDATE_DATE
|
|||
|
|
{
|
|||
|
|
set { _update_date = value; }
|
|||
|
|
get { return _update_date; }
|
|||
|
|
}
|
|||
|
|
#endregion Model
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|