640 lines
18 KiB
C#
640 lines
18 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using WMS.Attirubte;
|
|
using System.ComponentModel;
|
|
|
|
namespace WMS.Model.Stock
|
|
{
|
|
#region 库存Model
|
|
|
|
/// <summary>
|
|
/// 库存Model
|
|
/// </summary>
|
|
[Serializable]
|
|
[TableClmAttribute(TableName = "T_MI_STOCK")]
|
|
public class MIStockModel
|
|
{
|
|
private string _locstatus = string.Empty;
|
|
private string _locsts = string.Empty;
|
|
|
|
private string _stock_id = string.Empty;
|
|
private string _putin_id = string.Empty;
|
|
private string _storage_id = string.Empty;
|
|
private string _storage_name = string.Empty;
|
|
private string _area_id = string.Empty;
|
|
private string _area_name = string.Empty;
|
|
private string _location_id = string.Empty;
|
|
private string _location_star = string.Empty;
|
|
private string _location_end = string.Empty;
|
|
private string _goods_typeid = string.Empty;
|
|
private string _goods_id = string.Empty;
|
|
private string _goods_name = string.Empty;
|
|
private decimal _shelves_num = 0;
|
|
private string _remark = string.Empty;
|
|
private string _version = string.Empty;
|
|
private string _storage_mode = string.Empty;
|
|
private string _provider_id = string.Empty;
|
|
private string _provider_name = string.Empty;
|
|
private DateTime _production_date = DateTime.Parse("1900-01-01");
|
|
private DateTime _ware_date = DateTime.Parse("1900-01-01");
|
|
private string _docctnumber = string.Empty;
|
|
|
|
|
|
private Boolean _ischeck;
|
|
private decimal _occupy_num = 0;
|
|
private decimal _able_num = 0;
|
|
|
|
private string _notice_id = string.Empty;
|
|
private string _ori_bill = string.Empty;
|
|
|
|
private decimal _period = 0;
|
|
|
|
private DateTime _due_date = DateTime.Parse("1900-01-01");
|
|
private string _goods_typename = string.Empty;
|
|
private string _barcode = string.Empty;
|
|
private DateTime _timeStart = DateTime.Parse("1900-01-01");
|
|
private DateTime _timeEnd = DateTime.Parse("1900-01-01");
|
|
private DateTime _timeStartOn = DateTime.Parse("1900-01-01");
|
|
private DateTime _timeEndOn = DateTime.Parse("1900-01-01");
|
|
public string _unit_name = string.Empty;
|
|
private string _unit = string.Empty;
|
|
private decimal _cost_price = 0;
|
|
private decimal _sum_cost_price = 0;
|
|
|
|
private string _CUSTOMER_ID = string.Empty;
|
|
private string _STS = string.Empty;
|
|
|
|
private string _STSEBS = string.Empty;
|
|
|
|
/// <summary>
|
|
/// 库存状态
|
|
/// </summary>
|
|
[DisplayName("库存状态")]
|
|
public string STS
|
|
{
|
|
set { _STS = value; }
|
|
get { return _STS; }
|
|
}
|
|
|
|
|
|
|
|
|
|
//
|
|
|
|
private string _GOODS_SKU = string.Empty;
|
|
|
|
/// <summary>
|
|
/// 周期
|
|
/// </summary>
|
|
[DisplayName("周期")]
|
|
public string GOODS_SKU
|
|
{
|
|
set { _GOODS_SKU = value; }
|
|
get { return _GOODS_SKU; }
|
|
}
|
|
|
|
|
|
|
|
private string _pickingid = string.Empty;
|
|
|
|
[DisplayName("入库单号")]
|
|
public string PICKINGID
|
|
{
|
|
set { _pickingid = value; }
|
|
get { return _pickingid; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// 库位性质
|
|
/// </summary>
|
|
[DisplayName("库位性质")]
|
|
public string LOCSTATUS
|
|
{
|
|
set { _locstatus = value; }
|
|
get { return _locstatus; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// 货位状态
|
|
/// </summary>
|
|
[DisplayName("货位状态")]
|
|
public string LOCSTS
|
|
{
|
|
set { _locsts = value; }
|
|
get { return _locsts; }
|
|
}
|
|
|
|
[DisplayName("MES上报状态")]
|
|
public string STSEBS
|
|
{
|
|
set { _STSEBS = value; }
|
|
get { return _STSEBS; }
|
|
}
|
|
|
|
private string _ctl = string.Empty;
|
|
[DisplayName("料箱号")]
|
|
public string CTL
|
|
{
|
|
get { return _ctl; }
|
|
set { _ctl = value; }
|
|
}
|
|
/// <summary>
|
|
/// 选择
|
|
/// </summary>
|
|
[DisplayName("选择")]
|
|
[TableClm(NoSelect=false)]
|
|
public Boolean IsCheckRec
|
|
{
|
|
get { return _ischeck; }
|
|
set { _ischeck = value; }
|
|
}
|
|
private string _Whseloc = "";
|
|
/// <summary>
|
|
/// Whseloc
|
|
/// </summary>
|
|
[DisplayName("仓储编号")]
|
|
public string Whseloc
|
|
{
|
|
get { return _Whseloc; }
|
|
set { _Whseloc = value; }
|
|
}
|
|
private string _High = string.Empty;
|
|
/// <summary>
|
|
/// HIGH
|
|
/// </summary>
|
|
[DisplayName("面积")]
|
|
public string High
|
|
{
|
|
get { return _High; }
|
|
set { _High = value; }
|
|
}
|
|
|
|
private string _SIZE = string.Empty;
|
|
/// <summary>
|
|
/// HIGH
|
|
/// </summary>
|
|
[DisplayName("托盘大小")]
|
|
public string SIZE
|
|
{
|
|
get { return _SIZE; }
|
|
set { _SIZE = value; }
|
|
}
|
|
private string _wgh = "0";
|
|
/// <summary>
|
|
/// 重量
|
|
/// </summary>
|
|
[DisplayName("重量")]
|
|
[TableClm(NoSelect = false)]
|
|
public string WGH
|
|
{
|
|
get { return _wgh; }
|
|
set { _wgh = value; }
|
|
}
|
|
private string _lotId = string.Empty;
|
|
|
|
/// <summary>
|
|
/// 单双面
|
|
/// </summary>
|
|
[DisplayName("单双面")]
|
|
public string ProDucLotId
|
|
{
|
|
get { return _lotId; }
|
|
set { _lotId = value; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// 库存编号
|
|
/// </summary>
|
|
[DisplayName("仓储编号")]
|
|
[TableClm(NoSelect = false)]
|
|
public string STOCK_ID
|
|
{
|
|
set { _stock_id = value; }
|
|
get { return _stock_id; }
|
|
}
|
|
//private string _customer_id = string.Empty;
|
|
[DisplayName("客户代码")]
|
|
public string Customer_Id
|
|
{
|
|
get { return _CUSTOMER_ID; }
|
|
set { _CUSTOMER_ID = value; }
|
|
}
|
|
/// <summary>
|
|
/// 上架批次号
|
|
/// </summary>
|
|
[DisplayName("上架单号")]
|
|
public string PUTIN_ID
|
|
{
|
|
set { _putin_id = value; }
|
|
get { return _putin_id; }
|
|
}
|
|
/// <summary>
|
|
/// 子库编号
|
|
/// </summary>
|
|
[DisplayName("子库编号")]
|
|
[TableClmAttribute(ClmJoinTable = "T_BASE_STORAGEINFO", JoinTableClm = "STORAGE_ID", JoinTableClmName = "STORAGE_NAME")]
|
|
public string STORAGE_ID
|
|
{
|
|
set { _storage_id = value; }
|
|
get { return _storage_id; }
|
|
}
|
|
/// <summary>
|
|
/// 仓库
|
|
/// </summary>
|
|
[DisplayName("仓库")]
|
|
[TableClm(NoSelect = false)]
|
|
public string STORAGE_NAME
|
|
{
|
|
set { _storage_name = value; }
|
|
get { return _storage_name; }
|
|
}
|
|
/// <summary>
|
|
/// 库区编号
|
|
/// </summary>
|
|
[DisplayName("库区")]
|
|
[TableClmAttribute(JoinTableClmName = "STORAGE_AREA_NAME", JoinTableClm = "STORAGE_AREA_ID", ClmJoinTable = "T_BASE_STORAGE_AREA")]
|
|
public string AREA_ID
|
|
{
|
|
set { _area_id = value; }
|
|
get { return _area_id; }
|
|
}
|
|
/// <summary>
|
|
/// 库区编号
|
|
/// </summary>
|
|
[DisplayName("库区")]
|
|
[TableClm(NoSelect = false)]
|
|
public string AREA_NAME
|
|
{
|
|
set { _area_name = value; }
|
|
get { return _area_name; }
|
|
}
|
|
/// <summary>
|
|
/// 库位编号
|
|
/// </summary>
|
|
[DisplayName("库位")]
|
|
[TableClm(NoSelect = false)]
|
|
//[TableClmAttribute(JoinTableClmName = "LOCATION_NAME", JoinTableClm = "LOC_ID", ClmJoinTable = "T_BASE_STORAGE_AREA_LOCATION", ClassName = "LOCATION_NAME")]
|
|
public string LOCATION_ID
|
|
{
|
|
set { _location_id = value; }
|
|
get { return _location_id; }
|
|
}
|
|
/// <summary>
|
|
/// 库位编号
|
|
/// </summary>
|
|
[DisplayName("开始库位")]
|
|
[TableClm(NoSelect = false)]
|
|
public string LOCATION_STAR
|
|
{
|
|
set { _location_star = value; }
|
|
get { return _location_star; }
|
|
}
|
|
/// <summary>
|
|
/// 库位编号
|
|
/// </summary>
|
|
[DisplayName("结束库位")]
|
|
[TableClm(NoSelect = false)]
|
|
public string LOCATION_END
|
|
{
|
|
set { _location_end = value; }
|
|
get { return _location_end; }
|
|
}
|
|
/// <summary>
|
|
/// 包装层级
|
|
/// </summary>
|
|
[DisplayName("包装层级")]
|
|
[TableClmAttribute(JoinTableClmName = "GOODS_TYPE_NAME", JoinTableClm = "GOODS_TYPE_ID", ClmJoinTable = "T_BASE_GOODS_TYPE", ClassName = "GOODS_TYPE_NAME")]
|
|
public string GOODS_TYPEID
|
|
{
|
|
set { _goods_typeid = value; }
|
|
get { return _goods_typeid; }
|
|
}
|
|
/// <summary>
|
|
/// 工序名称
|
|
/// </summary>
|
|
[DisplayName("工序名称")]
|
|
[TableClm(NoSelect = false)]
|
|
public string GOODS_TYPENAME
|
|
{
|
|
set { _goods_typename = value; }
|
|
get { return _goods_typename; }
|
|
}
|
|
/// <summary>
|
|
/// GoodsNumber
|
|
/// </summary>
|
|
[DisplayName("物料编号")]
|
|
[TableClmAttribute(ClmJoinTable = "T_BASE_GOODS", JoinTableClm = "GOODS_ID", JoinTableClmName = "GOODS_NAME")]
|
|
public string GOODS_ID
|
|
{
|
|
set { _goods_id = value; }
|
|
get { return _goods_id; }
|
|
}
|
|
/// <summary>
|
|
/// 物料
|
|
/// </summary>
|
|
[DisplayName("物料规格")]
|
|
[TableClm(NoSelect = false)]
|
|
public string GOODS_NAME
|
|
{
|
|
set { _goods_name = value; }
|
|
get { return _goods_name; }
|
|
}
|
|
/// <summary>
|
|
/// 数量
|
|
/// </summary>
|
|
[DisplayName("库存数量")]
|
|
public decimal SHELVES_NUM
|
|
{
|
|
set { _shelves_num = value; }
|
|
get { return _shelves_num; }
|
|
}
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
[DisplayName("备注")]
|
|
[TableClm(NoSelect = false)]
|
|
public string REMARK
|
|
{
|
|
set { _remark = value; }
|
|
get { return _remark; }
|
|
}
|
|
/// <summary>
|
|
/// 版本号
|
|
/// </summary>
|
|
[DisplayName("出库时间")]
|
|
[TableClm(NoSelect = false)]
|
|
public string VERSION
|
|
{
|
|
set { _version = value; }
|
|
get { return _version; }
|
|
}
|
|
/// <summary>
|
|
/// 入库类型（采购入库、退货入库、调货入库、盲收、其它）
|
|
/// </summary>
|
|
[DisplayName("入库类型")]
|
|
public string STORAGE_MODE
|
|
{
|
|
set { _storage_mode = value; }
|
|
get { return _storage_mode; }
|
|
}
|
|
/// <summary>
|
|
/// 工单号
|
|
/// </summary>
|
|
[DisplayName("供应商ID")]
|
|
[TableClmAttribute(ClmJoinTable = "T_BASE_PROVIDER_DICTIONARY", JoinTableClm = "PROVIDER_ID", JoinTableClmName = "PROVIDER_NAME")]
|
|
public string PROVIDER_ID
|
|
{
|
|
set { _provider_id = value; }
|
|
get { return _provider_id; }
|
|
}
|
|
/// <summary>
|
|
/// 供应商
|
|
/// </summary>
|
|
[DisplayName("供应商名称")]
|
|
[TableClm(NoSelect = false)]
|
|
public string PROVIDER_NAME
|
|
{
|
|
set { _provider_name = value; }
|
|
get { return _provider_name; }
|
|
}
|
|
/// <summary>
|
|
/// 码盘时间
|
|
/// </summary>
|
|
[DisplayName("码盘时间")]
|
|
[TableClm(NoSelect = false)]
|
|
public DateTime PRODUCTION_DATE
|
|
{
|
|
set { _production_date = value; }
|
|
get { return _production_date; }
|
|
}
|
|
/// <summary>
|
|
/// 入库时间
|
|
/// </summary>
|
|
[DisplayName("入库时间")]
|
|
[TableClm(NoSelect = false)]
|
|
public DateTime WARE_DATE
|
|
{
|
|
set { _ware_date = value; }
|
|
get { return _ware_date; }
|
|
}
|
|
/// <summary>
|
|
/// 单据编号（调整填写调整单号，入库填写入库单号
|
|
/// </summary>
|
|
[DisplayName("销售订单")]
|
|
[TableClm(NoSelect = false)]
|
|
public string DOCCTNUMBER
|
|
{
|
|
set { _docctnumber = value; }
|
|
get { return _docctnumber; }
|
|
}
|
|
/// <summary>
|
|
/// 占用数量
|
|
/// </summary>
|
|
[DisplayName("占用库存")]
|
|
[TableClm(NoSelect = false)]
|
|
public decimal OCCUPY_NUM
|
|
{
|
|
set { _occupy_num = value; }
|
|
get { return _occupy_num; }
|
|
}
|
|
/// <summary>
|
|
/// 未锁数量
|
|
/// </summary>
|
|
[DisplayName("未锁库存")]
|
|
[TableClm(NoSelect = false)]
|
|
public decimal ABLE_NUM
|
|
{
|
|
set { _able_num = value; }
|
|
get { return _able_num; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// 通知单号
|
|
/// </summary>
|
|
[DisplayName("入库单号")]
|
|
[TableClm(NoSelect = false)]
|
|
public string NOTICE_ID
|
|
{
|
|
set { _notice_id = value; }
|
|
get { return _notice_id; }
|
|
}
|
|
/// <summary>
|
|
/// 来源单据
|
|
/// </summary>
|
|
[DisplayName("来源单据")]
|
|
[TableClm(NoSelect = false)]
|
|
public string ORI_BILL
|
|
{
|
|
set { _ori_bill = value; }
|
|
get { return _ori_bill; }
|
|
}
|
|
string _GOODS_MEASURE_ID = "";
|
|
/// <summary>
|
|
///箱规
|
|
/// <summary>
|
|
[DisplayName("(垫板/铝片)")]
|
|
public string GOODS_MEASURE_ID
|
|
{
|
|
get { return _GOODS_MEASURE_ID; }
|
|
|
|
set { _GOODS_MEASURE_ID = value; }
|
|
}
|
|
string _GOODS_MEASURE_NAME = "";
|
|
/// <summary>
|
|
///箱规名称
|
|
/// <summary>
|
|
[DisplayName("箱规名称")]
|
|
public string GOODS_MEASURE_NAME
|
|
{
|
|
get { return _GOODS_MEASURE_NAME; }
|
|
|
|
set { _GOODS_MEASURE_NAME = value; }
|
|
}
|
|
/// <summary>
|
|
/// 保质期
|
|
/// </summary>
|
|
[DisplayName("保质期")]
|
|
[TableClm(NoSelect = false)]
|
|
public decimal PERIOD
|
|
{
|
|
get { return _period; }
|
|
set { _period = value; }
|
|
}
|
|
|
|
private decimal _GOODSVOLUME = 0;
|
|
|
|
/// <summary>
|
|
/// 包数量
|
|
/// </summary>
|
|
[DisplayName("包数量")]
|
|
public decimal GOODSVOLUME
|
|
{
|
|
get { return _GOODSVOLUME; }
|
|
set { _GOODSVOLUME = value; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// 到期日期
|
|
/// </summary>
|
|
///
|
|
|
|
[DisplayName("到期日期")]
|
|
[TableClm(NoSelect = false)]
|
|
public DateTime DUE_DATE
|
|
{
|
|
get { return _due_date; }
|
|
set { _due_date = value; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// BarCode
|
|
/// </summary>
|
|
[DisplayName("箱码")]
|
|
[TableClm(NoSelect = false)]
|
|
public string BARCODE
|
|
{
|
|
get { return _barcode; }
|
|
set { _barcode = value; }
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 生产起始日期
|
|
/// </summary>
|
|
[DisplayName("生产起始日期")]
|
|
[TableClm(NoSelect = false)]
|
|
public DateTime TIMESTART
|
|
{
|
|
get { return _timeStart; }
|
|
set { _timeStart = value; }
|
|
}
|
|
/// <summary>
|
|
/// 生产结束日期
|
|
/// </summary>
|
|
[DisplayName("生产结束日期")]
|
|
[TableClm(NoSelect = false)]
|
|
public DateTime TIMEEND
|
|
{
|
|
get { return _timeEnd; }
|
|
set { _timeEnd = value; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// 上架起始日期
|
|
/// </summary>
|
|
[DisplayName("上架起始日期")]
|
|
[TableClm(NoSelect = false)]
|
|
public DateTime TIMESTARTON
|
|
{
|
|
get { return _timeStartOn; }
|
|
set { _timeStartOn = value; }
|
|
}
|
|
/// <summary>
|
|
/// 上架结束日期
|
|
/// </summary>
|
|
[DisplayName("上架结束日期")]
|
|
[TableClm(NoSelect = false)]
|
|
public DateTime TIMEENDON
|
|
{
|
|
get { return _timeEndOn; }
|
|
set { _timeEndOn = value; }
|
|
}
|
|
/// <summary>
|
|
///物料UNIT （字典表获取下拉）
|
|
/// <summary>
|
|
[DisplayName("单位")]
|
|
[TableClm(NoSelect = false)]
|
|
//[TableClmAttribute(JoinTableClmName = "VC_DICTIONARY_NAME", JoinTableClm = "VC_CHAR_VALUE", ClmJoinTable = "t_sys_dictionary_tab", JoinTableWhere = " VC_DICTIONARY_TYPE = 'vc_uom' ", ClassName = "VC_DICTIONARY_NAME")]
|
|
//[TableClm(NoSelect = false)]
|
|
public string UNIT { get { return _unit; } set { _unit = value; } }
|
|
|
|
|
|
/// <summary>
|
|
/// 物料UNIT
|
|
/// </summary>
|
|
[DisplayName("单位名称")]
|
|
[TableClm(NoSelect = false)]
|
|
public string UNIT_NAME { get { return _unit_name; } set { _unit_name = value; } }
|
|
|
|
|
|
/// <summary>
|
|
/// 成本价
|
|
/// </summary>
|
|
[DisplayName("成本价")]
|
|
[TableClm(NoSelect = false)]
|
|
public decimal COST_PRICE
|
|
{
|
|
get { return _cost_price; }
|
|
set
|
|
{
|
|
_cost_price = value;
|
|
}
|
|
}
|
|
|
|
[DisplayName("总成本价")]
|
|
[TableClm(NoSelect = false)]
|
|
public decimal SUM_COST_PRICE
|
|
{
|
|
get { return _sum_cost_price; }
|
|
set { _sum_cost_price = value; }
|
|
|
|
}
|
|
/// <summary>
|
|
/// 每包数量
|
|
/// </summary>
|
|
decimal _PACKING_NUM = 0;
|
|
[DisplayName("每包数量")]
|
|
[TableClm(NoSelect = false)]
|
|
public decimal PACKING_NUM
|
|
{
|
|
get { return _PACKING_NUM; }
|
|
set { _PACKING_NUM = value; }
|
|
|
|
}
|
|
|
|
}
|
|
#endregion
|
|
}
|