public PartlyCollection <VTemplate> GetList(VTemplateFilter filter)
{
var where = filter.ConvertToWhereBuilder();
where.AppendItem("Status", 0);
//string sql = ORMapping.GetSelectSql<VTemplate>(TSqlBuilder.Instance);
//sql += " WHERE 1=1";
//if (!where.IsEmpty)
//{
// sql += " AND " + where.ToSqlString(TSqlBuilder.Instance);
//}
//var qc = new QueryCondition(
// filter.RowIndex,
// filter.PageSize,
// "*",
// sql,
// " CreatorTime desc",
// where.ToSqlString(TSqlBuilder.Instance));
var tuple = GetPageSplitedCollection(filter.RowIndex, filter.PageSize, where.ToSqlString(TSqlBuilder.Instance));
return(tuple);
}
public PartlyCollection <VTemplate> GetViewList(VTemplateFilter filter)
{
return(_vTemplateAdapter.GetList(filter));
}
public IHttpActionResult LoadTemplateData([FromBody] TemplateFilter filter)
{
var queryFilter = new VTemplateFilter();
if (!UserInfoOperator.Instance.IsAdmin() || filter.IsOnlySelf)
{
queryFilter.CreatorLoginName = WebHelper.GetCurrentUser().LoginName;
}
//如果查看的为非自己的数据 则需要数据权限
//if (!filter.IsOnlySelf)
//{
// var startOrg = AuthHelper.GetPrivilegeStartOrg();
// queryFilter.UnitFullPath = startOrg;
//}
queryFilter.CreatorLoginOrName = filter.TemplateCreateLoginOrName;
#region 获取时间范围
DateTime date = DateTime.MinValue.ValidateSqlMinDate();
if (filter.TimeRange.HasValue)
{
switch (filter.TimeRange)
{
case 1:
date = DateTime.Today;
break;
case 2:
date = DateTime.Now.AddDays(-1);
break;
case 3:
date = DateTime.Now.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek))) - 7);
break;
case 4:
date = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-1);
break;
case 5:
date = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-3);
break;
case 6:
date = DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(-1);
break;
}
}
#endregion
queryFilter.TemplateName = filter.TemplateName;
queryFilter.CreatorTimeStart = date;
queryFilter.PageIndex = filter.PageIndex;
queryFilter.PageSize = filter.PageSize;
//如果不是加载本地导入模板 则只查询非本地导入模板
if (!filter.WithImport)
{
queryFilter.IsImport = 0;
}
var data = TemplateOperator.Instance.GetViewList(queryFilter);
var templates = data.Select(x =>
{
Template template = new Template();
template.ConvertEntity(x);
return(template);
}).ToList();
return(BizResult(new ViewData <Template>()
{
Data = templates, TotalCount = data.TotalCount
}));
}