using iWareCommon.Common.Entity; using iWareCommon.Utils; using iWareDataCore.ORM; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace iWareDataCore.Check.Entity { public class PlanViewEntity : ICommonEntity { /// /// 1计划表主键id /// public int Id { get; set; } /// /// 2原始库位id /// public int PlaceId { get; set; } /// /// 3原始物料id /// public int MaterialId { get; set; } /// /// 4计划表外键id /// public int PlanId { get; set; } /// /// 5数量 /// public int Quantity { get; set; } /// /// 6计划编号 /// public string PlanNo { get; set; } /// /// 7开始时间 /// public DateTime BeginTime { get; set; } /// /// 8结束时间 /// public DateTime EndTime { get; set; } /// /// 9修改时间 /// public DateTime UpdateTime { get; set; } /// /// 10计划状态 /// public int PlanStatus { get; set; } /// /// 11备注 /// public string Remark { get; set; } /// /// 12库位状态 /// public int PlaceStatus { get; set; } /// /// 13核查后库位id /// public int CheckPlaceId { get; set; } /// /// 14核查后物料id /// public int CheckMaterialId { get; set; } /// /// 15出入库类型 /// public string TypeName { get; set; } /// /// 16物料号 /// public string MaterialCode { get; set; } /// /// 17库位号 /// public string PlaceCode { get; set; } /// /// 18物料号 /// public string CheckMaterialCode { get; set; } /// /// 19库位号 /// public string CheckPlaceCode { get; set; } /// /// 20船级社 /// public string ClassificationSociety { get; set; } /// /// 21分段号 /// public string SerialNo { get; set; } /// /// 22厚 /// public string Thick { get; set; } /// /// 23宽 /// public string Wide { get; set; } /// /// 24长 /// public string Length { get; set; } /// /// 无参构造 /// public PlanViewEntity() { } /// /// 有参构造 /// /// orm映射的类 public PlanViewEntity(CheckPlanView plan) { EntityPropHelper.CopyProp(plan, this, GetColumnMap()); } /// /// 将对象转换成ORM中的类型 /// /// Orm中的CheckPlanView类型 public CheckPlanView ToOrm() { var place = new CheckPlanView(); EntityPropHelper.CopyProp(this, place, GetColumnMap()); return place; } /// /// 获取自定义角色类中的字段名为键,orm中对象的字段名为值的字段 /// /// public static Dictionary GetColumnMap() { return new Dictionary() { {"Id", "id"}, {"PlaceId", "placeid"}, {"MaterialId", "materialid"}, {"PlanId", "planid"}, {"Quantity", "quantity"}, {"PlanNo", "planno"}, {"BeginTime", "begintime"}, {"EndTime", "endtime"}, {"UpdateTime", "updatetime"}, {"PlanStatus", "planstatus"}, {"Remark", "remark"}, {"PlaceStatus", "placestatus"}, {"CheckPlaceId", "checkplaceid"}, {"CheckMaterialId", "checkmaterialid"}, {"TypeName", "typename"}, {"PlaceCode", "placecode"}, {"MaterialCode", "materialcode"}, {"CheckMaterialCode", "checkmaterialcode"}, {"CheckPlaceCode", "checkplacecode"}, { "ClassificationSociety", "classificationsociety"}, { "SerialNo", "serialno"}, { "Thick", "thick"}, { "Wide", "wide"}, { "Length", "length"} }; } /// /// 根据 的字段转CheckPlanView的字段 /// /// 的字段 /// CheckPlanView public static string GetColumnName(string name) { var columnMap = GetColumnMap(); return columnMap.ContainsKey(name) ? columnMap[name] : name; } /// /// 获取WareHouseAreaTypeEntity对应的表名 /// /// 表名 public static string GetTableName() { return "[dbo].[CheckPlanView]"; } } }