movercptid CHAR VARYING 0 0 False False 移库单号 rawid CHAR VARYING 0 0 True False 原料主键…
- User
move_rcpt_id CHAR VARYING 0 0 False False 移库单号 raw_id CHAR VARYING 0 0 True False 原料主键 material_type CHAR VARYING 255 0 True False 材质 standard_id CHAR VARYING 0 0 True False 标准id from_location_id CHAR VARYING 255 0 True False 原库位 from_warehouse_id CHAR VARYING 255 0 True False 原仓库 move_count INTEGER 0 0 True False 移库数量 per_len DECIMAL 255 0 True False 单长度 per_wtg DECIMAL 255 0 True False 单重 用[Column(Description = “注释内容”)]的方式对每个字段进行注释 首字母大写 下划线要留着 c#实体类
- Assistant
[Table("表名")] public class MoveReceiverEntity { [Column(Description = "移库单号")] public string MoveRcptId { get; set; }
[Column(Description = "原料主键")] public string RawId { get; set; } [Column(Description = "材质")] public string MaterialType { get; set; } [Column(Description = "标准id")] public string StandardId { get; set; } [Column(Description = "原库位")] public string FromLocationId { get; set; } [Column(Description = "原仓库")] public string FromWarehouseId { get; set; } [Column(Description = "移库数量")] public int MoveCount { get; set; } [Column(Description = "单长度")] public decimal PerLen { get; set; } [Column(Description = "单重")] public decimal PerWtg { get; set; }}
- User
picking_rcpt_id CHAR VARYING 0 0 False False 移库单号 raw_id CHAR VARYING 0 0 True False 原料主键 material_type CHAR VARYING 255 0 True False 材质 standard_id CHAR VARYING 0 0 True False 标准id move_count INTEGER 0 0 True False 移库数量 per_len DECIMAL 255 0 True False 单长度 per_wtg DECIMAL 255 0 True False 单重 picking_count INTEGER 0 0 False False 领用数量 delivery_count INTEGER 0 0 True False 已经发放的数量
- Assistant
[Table("表名")] public class PickingReceiverEntity { [Column(Description = "移库单号")] public string PickingRcptId { get; set; }
[Column(Description = "原料主键")] public string RawId { get; set; } [Column(Description = "材质")] public string MaterialType { get; set; } [Column(Description = "标准id")] public string StandardId { get; set; } [Column(Description = "移库数量")] public int MoveCount { get; set; } [Column(Description = "单长度")] public decimal PerLen { get; set; } [Column(Description = "单重")] public decimal PerWtg { get; set; } [Column(Description = "领用数量")] public int PickingCount { get; set; } [Column(Description = "已经发放的数量")] public int DeliveryCount { get; set; }}
- User
wh_rcpt_id CHAR VARYING 0 0 False False 入库单主键 raw_id CHAR VARYING 255 0 False False 原料主键 material_type CHAR VARYING 255 0 False False 材质 standard_id CHAR VARYING 0 0 False False 标准Id per_len DECIMAL 255 0 False False 单长度 per_wtg DECIMAL 255 0 False False 单重 count INT 0 0 False False 数量 real_wtg DECIMAL 255 0 True False 过磅重 furnace_batch_no DECIMAL 0 0 True False 炉批号 brand CHAR VARYING 255 0 True False 品牌 remarks CHAR VARYING 255 0 True False 备注 warehouse_id CHARACTER VARYING 0 0 True False 仓库 location_id CHARACTER VARYING 0 0 True False 库位
- Assistant
[Table("表名")] public class WarehouseReceiverEntity { [Column(Description = "入库单主键")] public string WhRcptId { get; set; }
[Column(Description = "原料主键")] public string RawId { get; set; } [Column(Description = "材质")] public string MaterialType { get; set; } [Column(Description = "标准Id")] public string StandardId { get; set; } [Column(Description = "单长度")] public decimal PerLen { get; set; } [Column(Description = "单重")] public decimal PerWtg { get; set; } [Column(Description = "数量")] public int Count { get; set; } [Column(Description = "过磅重")] public decimal RealWtg { get; set; } [Column(Description = "炉批号")] public decimal FurnaceBatchNo { get; set; } [Column(Description = "品牌")] public string Brand { get; set; } [Column(Description = "备注")] public string Remarks { get; set; } [Column(Description = "仓库")] public string WarehouseId { get; set; } [Column(Description = "库位")] public string LocationId { get; set; }}