| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449 | 
							- using SqlSugar;
 
- using System;
 
- using System.Collections.Generic;
 
- using System.Text;
 
- namespace wms.sqlsugar.model.pt
 
- {
 
-     [Tenant("pt")]
 
-     [SugarTable("Bill_InvNow", "库存表")]
 
-     public class ptBillInvnow : BaseModel
 
-     {
 
-         /// <summary> 
 
-         /// WarehouseId
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
 
-         public long WarehouseId { get; set; }
 
-         /// <summary> 
 
-         /// 容器ID
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
 
-         public long ContGrpId { get; set; }
 
-         /// <summary> 
 
-         /// 容器条码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ContGrpBarCode { get; set; }
 
-         /// <summary> 
 
-         /// 组盘类型(1物料盘 2空盘)
 
-         /// </summary> 
 
-         //[SugarColumn(ColumnDataType = "int", IsNullable = false)]
 
-         //public int ContGrpType { get; set; }
 
-         /// <summary> 
 
-         /// 成品箱条码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string BoxBarCode { get; set; }
 
-         /// <summary> 
 
-         /// Bom工单号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string BomDocsNo { get; set; }
 
-         /// <summary> 
 
-         /// BomMatId
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
 
-         public long BomMatId { get; set; }
 
-         /// <summary> 
 
-         /// BomMatCode
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string BomMatCode { get; set; }
 
-         /// <summary> 
 
-         /// BomMatName
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string BomMatName { get; set; }
 
-         /// <summary> 
 
-         /// BomSetId
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
 
-         public long BomSetId { get; set; }
 
-         /// <summary> 
 
-         /// ExecStateCode
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ExecStateCode { get; set; }
 
-         /// <summary> 
 
-         /// 执行单据号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ExecDocsNo { get; set; }
 
-         /// <summary> 
 
-         /// 执行单据行号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ExecDocsRowNo { get; set; }
 
-         /// <summary> 
 
-         /// 执行单据类型代码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ExecDocsTypeCode { get; set; }
 
-         /// <summary> 
 
-         /// InvInOut
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "int", IsNullable = false)]
 
-         public int InvInOut { get; set; }
 
-         /// <summary> 
 
-         /// ExecWho
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ExecWho { get; set; }
 
-         /// <summary> 
 
-         /// ExecTime
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
 
-         public DateTime ExecTime { get; set; }
 
-         /// <summary> 
 
-         /// 摆放行
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "int", IsNullable = false)]
 
-         public int PutRow { get; set; }
 
-         /// <summary> 
 
-         /// 摆放列
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "int", IsNullable = false)]
 
-         public int PutCol { get; set; }
 
-         /// <summary> 
 
-         /// 摆放层
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "int", IsNullable = false)]
 
-         public int PutLayer { get; set; }
 
-         /// <summary> 
 
-         /// 材料号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string InvBarCode { get; set; }
 
-         /// <summary> 
 
-         /// 组盘状态
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string InvStateCode { get; set; }
 
-         /// <summary> 
 
-         /// 入库单据号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string InDocsNo { get; set; }
 
-         /// <summary> 
 
-         /// 入库单据行号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string InDocsRowNo { get; set; }
 
-         /// <summary> 
 
-         /// 供应商编码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string SuppCode { get; set; }
 
-         /// <summary> 
 
-         /// 供应商名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string SuppName { get; set; }
 
-         /// <summary> 
 
-         /// 客户编码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string CustCode { get; set; }
 
-         /// <summary> 
 
-         /// 客户名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string CustName { get; set; }
 
-         /// <summary> 
 
-         /// 物料ID
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
 
-         public long MatId { get; set; }
 
-         /// <summary> 
 
-         /// 物料编码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string MatCode { get; set; }
 
-         /// <summary> 
 
-         /// 物料名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string MatName { get; set; }
 
-         /// <summary> 
 
-         /// 包重
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal TolWQty { get; set; }
 
-         /// <summary> 
 
-         /// 净重
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal NetWQty { get; set; }
 
-         /// <summary> 
 
-         /// 皮重
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal TareWQty { get; set; }
 
-         /// <summary> 
 
-         /// 长度
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal LengthQty { get; set; }
 
-         /// <summary> 
 
-         /// 碳当量
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal CaQty { get; set; }
 
-         /// <summary> 
 
-         /// 焊点数量
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal SolderQty { get; set; }
 
-         /// <summary> 
 
-         /// ContUsageQty
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "int", IsNullable = false)]
 
-         public int ContUsageQty { get; set; }
 
-         /// <summary> 
 
-         /// 生产批号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string BatchNo { get; set; }
 
-         /// <summary> 
 
-         /// 生产时间
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
 
-         public DateTime ProductTime { get; set; }
 
-         /// <summary> 
 
-         /// 第一次入库时间
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
 
-         public DateTime OneInTime { get; set; }
 
-         /// <summary> 
 
-         /// 盘条条码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string RodBarCode { get; set; }
 
-         /// <summary> 
 
-         /// 工字轮条码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string HWBarCode { get; set; }
 
-         /// <summary> 
 
-         /// RFID条码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string RFIDBarCode { get; set; }
 
-         /// <summary> 
 
-         /// 材料号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string CLBarCode { get; set; }
 
-         /// <summary> 
 
-         /// 工字轮规格
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string HWTypeCode { get; set; }
 
-         /// <summary> 
 
-         /// 炉号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string BoilerNo { get; set; }
 
-         /// <summary> 
 
-         /// 包号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string PackNo { get; set; }
 
-         /// <summary> 
 
-         /// 牌号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string BrandNo { get; set; }
 
-         /// <summary> 
 
-         /// 执行标准
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ExecStd { get; set; }
 
-         /// <summary> 
 
-         /// 许可证号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string LicenceCode { get; set; }
 
-         /// <summary> 
 
-         /// 改手盘标记(余料)
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsSurplus { get; set; }
 
-         /// <summary> 
 
-         /// 返工标记
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsRework { get; set; }
 
-         /// <summary> 
 
-         /// 是否黑盘
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsBlack { get; set; }
 
-         /// <summary> 
 
-         /// 是否芯股
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsCore { get; set; }
 
-         /// <summary> 
 
-         /// 快投标记
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsFast { get; set; }
 
-         /// <summary> 
 
-         /// 是否异常
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsFail { get; set; }
 
-         /// <summary> 
 
-         /// 异常原因
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
 
-         public string FailReason { get; set; }
 
-         /// <summary> 
 
-         /// 单/双丝
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string SilkTypeCode { get; set; }
 
-         /// <summary> 
 
-         /// 等级
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string Grade { get; set; }
 
-         /// <summary> 
 
-         /// 是否退料
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsBack { get; set; }
 
-         /// <summary> 
 
-         /// 退料原因
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
 
-         public string BackReason { get; set; }
 
-         /// <summary> 
 
-         /// 是否 扭转检测
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsTorsChk { get; set; }
 
-         /// <summary> 
 
-         /// 扭转次数
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "int", IsNullable = false)]
 
-         public int TorsChkQty { get; set; }
 
-         /// <summary> 
 
-         /// 扭转检测时间
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
 
-         public DateTime TorsChkTime { get; set; }
 
-         /// <summary> 
 
-         /// 扭转检测结果值
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? TorsChkValue { get; set; }
 
-         /// <summary> 
 
-         /// 扭转检测设备号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string TorsChkMachCode { get; set; }
 
-         /// <summary> 
 
-         /// 工序订单号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ProcessDocsCode { get; set; }
 
-         /// <summary> 
 
-         /// 生产机台号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ProductMachCode { get; set; }
 
-         /// <summary> 
 
-         /// 生产产线号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ProductLineNo { get; set; }
 
-         /// <summary> 
 
-         /// 货物大小
 
-         /// </summary> 
 
-         [SugarColumn(IsNullable = false)]
 
-         public int Size { get; set; }
 
-         /// <summary> 
 
-         /// 规格
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string Describe { get; set; }
 
-         /// <summary>
 
-         /// 时效期
 
-         /// </summary>
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal HoldDuration { get; set; }
 
-     }
 
- }
 
 
  |