using iWareCommon.Common.Entity;
|
using iWareCommon.Common.Service;
|
using iWareCommon.Utils;
|
using iWareExcel.EXCEL.Dao;
|
using iWareExcel.EXCEL.Entity;
|
using iWareExcel.ORM;
|
using iWareExcel.Properties;
|
using System;
|
using System.Collections.Generic;
|
using System.Data.Entity.Validation;
|
using System.Linq;
|
|
namespace iWareExcel.EXCEL.Service
|
{
|
public class WorkBookService : CommonService<WorkBookEntity, EXCELWorkBook, DbModelExcel>
|
{
|
private static object Lock = new object();
|
|
private WorkBookService() : base(WorkBookDao.GetInstance()) { }
|
|
private static WorkBookService Instance = null;
|
|
/// <summary>
|
/// 获取单例的方法
|
/// </summary>
|
/// <returns>角色服务的单例实体</returns>
|
public static WorkBookService GetInstance()
|
{
|
if (Instance == null)
|
{
|
lock (Lock)
|
{
|
if (Instance == null)
|
{
|
Instance = new WorkBookService();
|
}
|
}
|
}
|
return Instance;
|
}
|
|
|
/// <summary>
|
/// 根据条件查询
|
/// </summary>
|
/// <param name="param">查询条件</param>
|
/// <param name="msg">异常错误信息</param>
|
/// <returns>工作簿列表</returns>
|
public override List<WorkBookEntity> QueryByParam(QueryParam param, out string msg)
|
{
|
msg = "";
|
using(var dbModel = new DbModelExcel())
|
{
|
try
|
{
|
var workBooks = WorkBookDao.GetInstance().QueryByParam(param, dbModel);
|
var workBookIds = new List<int>();
|
var workBookDict = new Dictionary<int, WorkBookEntity>();
|
|
workBooks.ForEach(x => { workBookIds.Add(x.Id); workBookDict.Add(x.Id, x); });
|
|
var workSheets = dbModel.EXCELWorkSheets.Where(x => workBookIds.Contains(x.workbookid)).OrderBy(x => x.sheetindex).ToList();
|
|
var workSheetIds = new List<int>();
|
var workSheetDict = new Dictionary<int, WorkSheetEntity>();
|
|
workSheets.ForEach(x => {
|
workSheetIds.Add(x.id);
|
var workSheet = new WorkSheetEntity(x);
|
workSheetDict.Add(x.id, workSheet);
|
workBookDict[x.workbookid].WorkSheets.Add(workSheet);
|
});
|
|
var workCells = dbModel.EXCELWorkCells.Where(x => workSheetIds.Contains(x.worksheetid)).OrderBy(x => x.cellindex).ToList();
|
|
workCells.ForEach(x => workSheetDict[x.worksheetid].WorkCells.Add(new WorkCellEntity(x)));
|
|
return workBooks;
|
}
|
catch (DbEntityValidationException ex)
|
{
|
var errs = ex.EntityValidationErrors.SelectMany(validationResult => validationResult.ValidationErrors).Select(m => m.ErrorMessage);
|
msg = string.Join(", ", errs);
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "QueryByParam", msg);
|
return new List<WorkBookEntity>();
|
}
|
catch (Exception ex)
|
{
|
msg = ex.Message;
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "QueryByParam", ex.Message);
|
return new List<WorkBookEntity>();
|
}
|
}
|
|
}
|
|
|
|
|
}
|
|
|
}
|
