赵正易
20c7855995
添加成品库出入库报表功能，包括入库报表和出库报表的查询接口 在WmGoodsRecord模型中新增ChangePackage字段记录变动箱数 修复Job_Blank.cs中多余的return null语句
96 lines
2.5 KiB
C#
96 lines
2.5 KiB
C#
namespace ZR.Model.MES.wms
|
||
{
|
||
/// <summary>
|
||
/// 成品库数据变动表
|
||
/// </summary>
|
||
[SugarTable("wm_goods_record")]
|
||
public class WmGoodsRecord
|
||
{
|
||
/// <summary>
|
||
/// 主键
|
||
/// </summary>
|
||
[SugarColumn(IsPrimaryKey = true, IsIdentity = false)]
|
||
public string Id { get; set; }
|
||
|
||
/// <summary>
|
||
/// 库存主键
|
||
/// </summary>
|
||
[SugarColumn(IsPrimaryKey = true, IsIdentity = false, ColumnName = "fk_inventory_id")]
|
||
public string FkInventoryId { get; set; }
|
||
|
||
/// <summary>
|
||
/// 关联记录字段，识别记录字段如PDA
|
||
/// </summary>
|
||
public string Code { get; set; }
|
||
|
||
/// <summary>
|
||
/// 零件号
|
||
/// </summary>
|
||
public string Partnumber { get; set; }
|
||
|
||
/// <summary>
|
||
/// 毛坯号
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "blank_num")]
|
||
public string BlankNum { get; set; }
|
||
|
||
/// <summary>
|
||
/// 变动类别 1-入库 2-出库 3-盘点
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "change_type")]
|
||
public int? ChangeType { get; set; }
|
||
|
||
/// <summary>
|
||
/// 变动箱数
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "change_package")]
|
||
public int? ChangePackage { get; set; }
|
||
|
||
/// <summary>
|
||
/// 变动数量
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "change_quantity")]
|
||
public int? ChangeQuantity { get; set; }
|
||
|
||
/// <summary>
|
||
/// 时间（操作时间）
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "action_time")]
|
||
public DateTime? ActionTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 状态（暂定）
|
||
/// </summary>
|
||
public int? Status { get; set; }
|
||
|
||
/// <summary>
|
||
/// 备注
|
||
/// </summary>
|
||
public string Remark { get; set; }
|
||
|
||
/// <summary>
|
||
/// 创建人
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "cREATED_BY")]
|
||
public string CreatedBy { get; set; }
|
||
|
||
/// <summary>
|
||
/// 创建时间
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "cREATED_TIME")]
|
||
public DateTime? CreatedTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 更新人
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "uPDATED_BY")]
|
||
public string UpdatedBy { get; set; }
|
||
|
||
/// <summary>
|
||
/// 更新时间
|
||
/// </summary>
|
||
[SugarColumn(ColumnName = "uPDATED_TIME")]
|
||
public DateTime? UpdatedTime { get; set; }
|
||
}
|
||
}
|