using iWareCommon.Common.Entity;
|
using iWareCommon.Utils;
|
using iWareExcel.ORM;
|
using System;
|
using System.Collections.Generic;
|
namespace iWareExcel.EXCEL.Entity
|
{
|
public class WorkCellEntity : ICommonEntity<EXCELWorkCell>
|
{
|
/// <summary>
|
/// 主键
|
/// </summary>
|
public int Id { get; set; }
|
|
/// <summary>
|
/// Excel展示名
|
/// </summary>
|
public string DisplayName { get; set; }
|
|
/// <summary>
|
/// 属性名
|
/// </summary>
|
public string PropName { get; set; }
|
|
/// <summary>
|
/// 工作页Id
|
/// </summary>
|
public int WorkSheetId { get; set; }
|
|
/// <summary>
|
/// 工作页名称
|
/// </summary>
|
public string WorkSheetName { get; set; }
|
|
/// <summary>
|
/// 工作簿Id
|
/// </summary>
|
public int WorkBookId { get; set; }
|
|
/// <summary>
|
/// 工作簿名称
|
/// </summary>
|
public string WorkBookName { get; set; }
|
|
/// <summary>
|
/// 数据类型
|
/// </summary>
|
public int DataType { get; set; }
|
|
/// <summary>
|
/// 是否枚举
|
/// </summary>
|
public int IsEnum { get; set; }
|
|
/// <summary>
|
/// 枚举类名
|
/// </summary>
|
public string EnumClass { get; set; }
|
|
/// <summary>
|
/// 排序
|
/// </summary>
|
public int CellIndex { get; set; }
|
|
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
public WorkCellEntity(){}
|
|
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
/// <param name="workCell">工作单元</param>
|
public WorkCellEntity(EXCELWorkCell workCell)
|
{
|
EntityPropHelper<WorkCellEntity, EXCELWorkCell>.CopyProp(workCell, this, GetColumnMap());
|
}
|
|
/// <summary>
|
/// 将实体类转成ORM类
|
/// </summary>
|
/// <returns></returns>
|
public EXCELWorkCell ToOrm()
|
{
|
var workCell = new EXCELWorkCell();
|
EntityPropHelper<WorkCellEntity, EXCELWorkCell>.CopyProp(this, workCell, GetColumnMap());
|
return workCell;
|
}
|
|
/// <summary>
|
/// 获取自定义工位类中的字段名为键，orm中对象的字段名为值的字段
|
/// </summary>
|
/// <returns></returns>
|
public static Dictionary<String, String> GetColumnMap()
|
{
|
return new Dictionary<string, string>()
|
{
|
{"Id", "id"},
|
{"DisplayName", "displayname"},
|
{"PropName","propname"},
|
{"WorkSheetId","worksheetid"},
|
{"WorkSheetName","worksheetname"},
|
{"WorkBookId","workbookid"},
|
{"WorkBookName","workbookname"},
|
{"DataType","datatype"},
|
{"IsEnum","isenum"},
|
{"EnumClass","enumclass"},
|
{"CellIndex", "cellindex"}
|
};
|
}
|
|
|
/// <summary>
|
/// 根据Entity的字段转ORM的字段
|
/// </summary>
|
/// <param name="name"></param>
|
/// <returns></returns>
|
public static String GetColumnName(String name)
|
{
|
var columnMap = GetColumnMap();
|
return columnMap.ContainsKey(name) ? columnMap[name] : name;
|
}
|
|
|
public static string GetTableName()
|
{
|
return "[dbo].[EXCELWorkCell]";
|
}
|
|
|
|
|
}
|
}
|
