using iWareCommon.Common.Entity;
|
using iWareCommon.Utils;
|
using iWareExcel.ORM;
|
using System.Collections.Generic;
|
namespace iWareExcel.EXCEL.Entity
|
{
|
public class WorkBookEntity : ICommonEntity<EXCELWorkBook>
|
{
|
/// <summary>
|
/// 主键
|
/// </summary>
|
public int Id { get; set; }
|
|
/// <summary>
|
/// 工作簿名称
|
/// </summary>
|
public string Name { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string Remark { get; set; }
|
|
/// <summary>
|
/// 模板地址
|
/// </summary>
|
public string TemplatePath { get; set; }
|
|
/// <summary>
|
/// 是否需要模板
|
/// </summary>
|
public int NeedTemplate { get; set; }
|
|
/// <summary>
|
/// 服务器保存路径
|
/// </summary>
|
public string ServerPath { get; set; }
|
|
/// <summary>
|
/// 服务器保存文件名
|
/// </summary>
|
public string ServerFileName { get; set; }
|
|
/// <summary>
|
/// 表头写入开始行 从1开始
|
/// </summary>
|
public int HeadStartLine { get; set; }
|
|
/// <summary>
|
/// 数据写入开始行 从1开始
|
/// </summary>
|
public int DataStartLine { get; set; }
|
|
|
/// <summary>
|
/// 工作表列表
|
/// </summary>
|
public List<WorkSheetEntity> WorkSheets { get; set; }
|
|
|
/// <summary>
|
/// 无参构造
|
/// </summary>
|
public WorkBookEntity() { WorkSheets = new List<WorkSheetEntity>(); }
|
|
|
/// <summary>
|
/// 有参构造
|
/// </summary>
|
/// <param name="workBook">orm印射的类</param>
|
public WorkBookEntity(EXCELWorkBook workBook)
|
{
|
EntityPropHelper<WorkBookEntity, EXCELWorkBook>.CopyProp(workBook, this, GetColumnMap());
|
WorkSheets = new List<WorkSheetEntity>();
|
}
|
|
|
|
/// <summary>
|
/// 将对象转换成ORM中的类型
|
/// </summary>
|
/// <returns>Orm中的BASEShift类型</returns>
|
public EXCELWorkBook ToOrm()
|
{
|
EXCELWorkBook workBook = new EXCELWorkBook();
|
EntityPropHelper<WorkBookEntity, EXCELWorkBook>.CopyProp(this, workBook, GetColumnMap());
|
|
return workBook;
|
}
|
|
///<summary>
|
/// 获取自定义角色类中的字段名为键，orm中对象的字段名为值的字段
|
/// </summary>
|
/// <returns></returns>
|
public static Dictionary<string, string> GetColumnMap()
|
{
|
return new Dictionary<string, string>()
|
{
|
{"Id", "id"},
|
{"Name", "name"},
|
{"Remark", "remark"},
|
{"TemplatePath", "templatepath"},
|
{"NeedTemplate", "needtemplate"},
|
{"ServerPath", "serverpath"},
|
{"ServerFileName", "serverfilename"},
|
{"HeadStartLine","headstartline"},
|
{"DataStartLine","datastartline"}
|
};
|
}
|
|
/// <summary>
|
/// 根据ShiftEntity的字段转BASEShift的字段
|
/// </summary>
|
/// <param name="name">ShiftEntity的字段</param>
|
/// <returns>BASEShift</returns>
|
public static string GetColumnName(string name)
|
{
|
var columnMap = GetColumnMap();
|
return columnMap.ContainsKey(name) ? columnMap[name] : name;
|
}
|
|
|
/// <summary>
|
/// 获取ShiftEntity对应的表名
|
/// </summary>
|
/// <returns>表名</returns>
|
public static string GetTableName()
|
{
|
return "[dbo].[EXCELWorkBook]";
|
}
|
}
|
}
|
