| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384 | 
							- using SqlSugar;
 
- using System;
 
- using System.Collections.Generic;
 
- using System.Text;
 
- namespace wms.sqlsugar.model.pt
 
- {
 
-     [Tenant("pt")]
 
-     [SugarTable("Base_MatInfo", "物料基础信息表")]
 
-     public class ptBaseMater : BaseModel
 
-     {
 
-         /// <summary> 
 
-         /// WarehouseId
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
 
-         public long WarehouseId { get; set; }
 
-         /// <summary> 
 
-         /// 物料编码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
 
-         public string Code { get; set; }
 
-         /// <summary> 
 
-         /// 物料名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = false)]
 
-         public string Name { get; set; }
 
-         /// <summary> 
 
-         /// 物料短描述
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string ShortDesc { get; set; }
 
-         /// <summary> 
 
-         /// 物料长描述
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 500, IsNullable = true)]
 
-         public string FullDesc { get; set; }
 
-         /// <summary> 
 
-         /// 物料补充描述
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 500, IsNullable = true)]
 
-         public string ExtDesc { get; set; }
 
-         /// <summary> 
 
-         /// 物料英文名
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string Enname { get; set; }
 
-         /// <summary> 
 
-         /// 物料组Id
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
 
-         public long MatGrpId { get; set; }
 
-         /// <summary> 
 
-         /// 叶类代码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string Leafcode { get; set; }
 
-         /// <summary> 
 
-         /// 叶类名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string LeafName { get; set; }
 
-         /// <summary> 
 
-         /// 中类代码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string MidCode { get; set; }
 
-         /// <summary> 
 
-         /// 中类名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string MidName { get; set; }
 
-         /// <summary> 
 
-         /// 大类代码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string HeadCode { get; set; }
 
-         /// <summary> 
 
-         /// 大类名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string HeadName { get; set; }
 
-         /// <summary> 
 
-         /// 规格型号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string Description { get; set; }
 
-         /// <summary> 
 
-         /// 材质
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string Texture { get; set; }
 
-         /// <summary> 
 
-         /// 图号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string FigureNo { get; set; }
 
-         /// <summary> 
 
-         /// 强度
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string Strength { get; set; }
 
-         /// <summary> 
 
-         /// 镀层
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string Plating { get; set; }
 
-         /// <summary> 
 
-         /// 镀层克重
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? PlatingWeight { get; set; }
 
-         /// <summary> 
 
-         /// 镀层主元素含量
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? PlatingContQty { get; set; }
 
-         /// <summary> 
 
-         /// 线密度
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? Linear { get; set; }
 
-         /// <summary> 
 
-         /// 产品号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string ProCode { get; set; }
 
-         /// <summary> 
 
-         /// 产品描述
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string ProName { get; set; }
 
-         /// <summary> 
 
-         /// 产品强度
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string ProStre { get; set; }
 
-         /// <summary> 
 
-         /// 线密度上限
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? LinearMax { get; set; }
 
-         /// <summary> 
 
-         /// 线密度下限
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? LinearMin { get; set; }
 
-         /// <summary> 
 
-         /// 线密度目标值
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? LinearTar { get; set; }
 
-         /// <summary> 
 
-         /// 单丝倍数
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? Mono { get; set; }
 
-         /// <summary> 
 
-         /// 工字轮型号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string SpoolType { get; set; }
 
-         /// <summary> 
 
-         /// 工字轮料号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string SpoolCode { get; set; }
 
-         /// <summary> 
 
-         /// 单卷长度
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? Length { get; set; }
 
-         /// <summary> 
 
-         /// 涂油量
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? OilQty { get; set; }
 
-         /// <summary> 
 
-         /// 润滑液种类
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string LubType { get; set; }
 
-         /// <summary> 
 
-         /// 排线间距
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? LineSpace { get; set; }
 
-         /// <summary> 
 
-         /// 捻距
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? LineLength { get; set; }
 
-         /// <summary> 
 
-         /// 捻向
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string LayDirect { get; set; }
 
-         /// <summary> 
 
-         /// 客户标准索引号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string CumIndex { get; set; }
 
-         /// <summary> 
 
-         /// 有无焊点
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string IsSolder { get; set; }
 
-         /// <summary> 
 
-         /// SKU号
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string SkuCode { get; set; }
 
-         /// <summary> 
 
-         /// SKU描述
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
 
-         public string SkuDesc { get; set; }
 
-         /// <summary> 
 
-         /// 控制扭转
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string Tors { get; set; }
 
-         /// <summary> 
 
-         /// 包装组ID
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string PackGrpId { get; set; }
 
-         /// <summary> 
 
-         /// 黑盘取样
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string BlackSamp { get; set; }
 
-         /// <summary> 
 
-         /// 黑盘检验
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string BlackChk { get; set; }
 
-         /// <summary> 
 
-         /// 客户编码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string CustCode { get; set; }
 
-         /// <summary> 
 
-         /// 客户描述
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string CustName { get; set; }
 
-         /// <summary> 
 
-         /// 收货地址编码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string AddressCode { get; set; }
 
-         /// <summary> 
 
-         /// 收货地址名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string AddressName { get; set; }
 
-         /// <summary> 
 
-         /// 生产批次数量(箱/批)
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? Qty { get; set; }
 
-         /// <summary> 
 
-         /// 每箱最大焊点盘数(个)
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? BoxMaxSolder { get; set; }
 
-         /// <summary> 
 
-         /// 工字轮最大焊点数(个)
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? SpoolMaxSolder { get; set; }
 
-         /// <summary> 
 
-         /// OVC比例
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal? Ovc { get; set; }
 
-         /// <summary> 
 
-         /// 起鼓等级
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string DrummLevel { get; set; }
 
-         /// <summary> 
 
-         /// 公司代码
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
 
-         public string ComCode { get; set; }
 
-         /// <summary> 
 
-         /// 公司名称
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
 
-         public string ComName { get; set; }
 
-         /// <summary> 
 
-         /// 计量单位
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 10, IsNullable = true)]
 
-         public string CalcUnit { get; set; }
 
-         /// <summary> 
 
-         /// 库存单位
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 10, IsNullable = true)]
 
-         public string StockUnit { get; set; }
 
-         /// <summary> 
 
-         /// 单重
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
 
-         public decimal Weight { get; set; }
 
-         /// <summary> 
 
-         /// 单重单位
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "nvarchar", Length = 10, IsNullable = true)]
 
-         public string WeightUnit { get; set; }
 
-         /// <summary> 
 
-         /// 是否启用时效
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
 
-         public bool IsHold { get; set; }
 
-         /// <summary> 
 
-         /// 时效时长
 
-         /// </summary> 
 
-         [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
 
-         public decimal HoldDuration { get; set; }
 
-     }
 
- }
 
 
  |