/// <summary>
/// 创建报表文件格式
/// </summary>
/// <param name="entity"></param>
/// <param name="list"></param>
/// <returns></returns>
public int Create(ReportsEntity entity,List<ReportParamsEntity> list)
{
if (!entity.ReportNum.IsEmpty())
{
return Update(entity,list);
}
int line = 0;
using (TransactionScope ts = new TransactionScope())
{
entity.ReportNum = entity.ReportNum.IsEmpty() ? SequenceProvider.GetSequence(typeof(ReportsEntity)) : entity.ReportNum;
entity.IncludeAll();
line += this.Reports.Add(entity);
if (!list.IsNullOrEmpty())
{
foreach (ReportParamsEntity item in list)
{
item.ParamNum = item.ParamNum.IsEmpty() ? SequenceProvider.GetSequence(typeof(ReportParamsEntity)) : item.ParamNum;
item.ReportNum = entity.ReportNum;
item.IncludeAll();
}
this.ReportParams.Add(list);
}
ts.Complete();
}
return line;
}
/// <summary>
/// 根据报表格式编号删除报表
/// </summary>
/// <param name="reportNum"></param>
/// <returns></returns>
public int Delete(string reportNum)
{
ReportsEntity entity = new ReportsEntity();
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
entity.Where(a => a.ReportNum == reportNum);
int line = this.Reports.Update(entity);
return line;
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int Delete(List<string> list)
{
if (!list.IsNullOrEmpty())
{
ReportsEntity entity = new ReportsEntity();
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
entity.Where("ReportNum", ECondition.In, list.ToArray());
int line = this.Reports.Update(entity);
return line;
}
return 0;
}
/// <summary>
/// 修改报表格式
/// </summary>
/// <param name="entity"></param>
/// <param name="list"></param>
/// <returns></returns>
public int Update(ReportsEntity entity, List<ReportParamsEntity> list)
{
int line = 0;
using (TransactionScope ts = new TransactionScope())
{
ReportParamsEntity param = new ReportParamsEntity();
param.Where(a => a.ReportNum == entity.ReportNum);
line += this.ReportParams.Delete(param);
entity.Include(a => new { a.ReportName, a.ReportType, a.Remark, a.DataSource, a.DsType, a.FileName });
entity.Where(a => a.ReportNum == entity.ReportNum);
line += this.Reports.Update(entity);
if (!list.IsNullOrEmpty())
{
foreach (ReportParamsEntity item in list)
{
item.ParamNum = item.ParamNum.IsEmpty() ? SequenceProvider.GetSequence(typeof(ReportParamsEntity)) : item.ParamNum;
item.ReportNum = entity.ReportNum;
item.IncludeAll();
}
this.ReportParams.Add(list);
}
ts.Complete();
}
return line;
}
/// <summary>
/// 查询报表
/// </summary>
/// <param name="argReportNum"></param>
/// <returns></returns>
public ReportsEntity GetReport(string argReportNum)
{
ReportsEntity entity = new ReportsEntity();
entity.IncludeAll();
entity.Where(a => a.ReportNum == argReportNum)
.And(a=>a.IsDelete==(int)EIsDelete.NotDelete)
;
entity = this.Reports.GetSingle(entity);
return entity;
}
/// <summary>
/// 报表查询分页
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<ReportsEntity> GetList(ReportsEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
entity.OrderBy(a => a.ID,EOrderBy.ASC);
int rowCount = 0;
List<ReportsEntity> listResult = this.Reports.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
return listResult;
}
/// <summary>
/// 查询数据集
/// </summary>
/// <param name="entity"></param>
/// <param name="list"></param>
/// <returns></returns>
public DataSet GetDataSource(ReportsEntity entity, List<ReportParamsEntity> list,int orderType,string orderNum)
{
DataSet ds = null;
if (entity.ReportType == (int)EReportType.Report)
{
ds = this.Reports.GetDataSource(entity, list);
}
else
{
if (orderType == (int)EOrder.InOrder)
{
Bill<InStorageEntity, InStorDetailEntity> bill = new InStorageOrder();
ds = bill.GetPrint(orderNum);
}
else if (orderType == (int)EOrder.OutOrder)
{
Bill<OutStorageEntity, OutStoDetailEntity> bill = new OutStorageOrder();
ds = bill.GetPrint(orderNum);
}
}
return ds;
}
public ActionResult GetList()
{
int status = WebUtil.GetFormValue<int>("Status", 0);
int ReportType = WebUtil.GetFormValue<int>("ReportType", -1);
string ReportName = WebUtil.GetFormValue<string>("ReportName", string.Empty);
int pageSize = WebUtil.GetFormValue<int>("PageSize", 10);
int pageIndex = WebUtil.GetFormValue<int>("PageIndex", 1);
PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize };
ReportsEntity entity = new ReportsEntity();
ReportProvider provider = new ReportProvider();
if (status > -1)
{
entity.Where(a => a.Status == status);
}
if (!ReportName.IsEmpty())
{
entity.Where("ReportName", ECondition.Like, "%" + ReportName + "%");
}
if (ReportType > 0)
{
entity.Where(a => a.ReportType == ReportType);
}
List<ReportsEntity> listResult = provider.GetList(entity, ref pageInfo);
listResult = listResult == null ? new List<ReportsEntity>() : listResult;
string json = JsonConvert.SerializeObject(listResult);
this.ReturnJson.AddProperty("Data", json);
this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount);
return Content(this.ReturnJson.ToString());
}