/// <summary>
/// Возвращает постраничный список шаблонов для контроллеров
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public Paged<TemplateModel> GetTemplates(TemplateFilter filter)
{
using (var db = new CMSdb(_context))
{
var query = db.core_views
.Where(t => t.id != Guid.Empty);
if (filter.Controller.HasValue)
query = query.Where(t => t.f_controller == filter.Controller.Value);
if (!string.IsNullOrEmpty(filter.SearchText))
query = query.Where(t => t.c_name.ToLower().Contains(filter.SearchText.ToLower()));
query = query.OrderBy(t => t.n_sort);
int itemsCount = query.Count();
var list = query
.Skip(filter.Size * (filter.Page - 1))
.Take(filter.Size).Select(s => new TemplateModel()
{
Id = s.id,
Title = s.c_name,
Desc = s.c_desc,
Controller = new ModuleModel()
{
Id = s.f_controller,
Name = db.core_controllers
.Where(c => c.id == s.f_controller).Any()
? db.core_controllers.Where(c => c.id == s.f_controller).First().c_name
: "!!! Возможно контроллер удален",
},
ViewPath = s.c_path,
Image = s.c_img,
});
return new Paged<TemplateModel>()
{
Items = list.ToArray(),
Pager = new PagerModel()
{
PageNum = filter.Page,
PageSize = filter.Size,
TotalCount = itemsCount
}
};
}
}
public static TemplateScopeContext CreateScope(Dictionary <string, object> args = null, TemplateFilter functions = null)
{
var context = new TemplateContext();
if (functions != null)
{
context.TemplateFilters.Insert(0, functions);
}
context.Init();
return(new TemplateScopeContext(new PageResult(context.OneTimePage("")), null, args));
}
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
}));
}
private async Task ClearAsync()
{
Filter = new TemplateFilter();
await FilterChanged.Invoke(Filter);
}
public RuntimeProperties(ServiceConfigParameters ConfigParameters)
{
_ServiceConfigParameters = ConfigParameters;
//personal
_Staff_ID = new StaffID();
_Full_Name = new FullName();
_Country = new Country();
_ContractType = new ContractType();
_ContractTypeForReports = new ContractTypeForReports();
_Position = new Position();
_DateOfTREnd = new DateOfTREnd();
_DateOfTRStart = new DateOfTRStart();
_DateOfEntrance = new DateOfEntrance();
_CalendarName = new CalendarName();
_TemplateFilter = new TemplateFilter();
_ArePropReadyPersonal = new ArePropReady();
_BusinessUnitInfo = new BusinessUnitInfo();
_PMSA = new PMSA();
_PMSAItem = new PMSAItem();
_Gender = new Gender();
_ActivityCodeInfo = new ActivityCodeInfo();
_OfficialLS = new OfficialLS();
_PhoneDirOnly = new PhoneDirOnly();
//update
_SelectedDate = new SelectedDate();
_SelectedDateStatus = new SelectedDateStatus();
_SelectedDateTransactionStatus = new SelectedDateTransactionStatus();
_SelectedDateType = new SelectedDateType();
_SelectedDateisOptional = new SelectedDateisOptional();
_PercentPerDay = new PercentPerDay();
_SelectedJob = new SelectedJob();
_MaxHoursDaily = new MaxHoursDaily();
_ArePropReadyTRUpdate = new ArePropReady();
_TRInputListClient = new TRInputListClient();
_LastOpenDay = new LastOpenDay();
//submit
_SumOfHours = new SumOfHours();
_TRInputList = new TRInputList();
_WorkingHoursWeekly = new WorkingHoursWeekly();
_MinHoursDaily = new MinHoursDaily();
_FirstSubmitableDay = new FirstSubmitableDay();
_SelectedActivityCode = new SelectedActivityCode();
_Description = new Description();
_Location = new Location();
_BusinessUnit = new BusinessUnit();
_ReasonCode = new ReasonCode();
_ArePropReadyTRSubmit = new ArePropReady();
_PeriodEnd = new PeriodEnd();
//reports
_PeriodStarting = new PeriodStarting();
_ArePropReadyReports = new ArePropReady();
_ReportIntervalFrom = new ReportIntervalFrom();
_ReportIntervalTo = new ReportIntervalTo();
_UserIDList = new UserIDList();
_SelectedReportTemplate = new SelectedReportTemplate();
_SelectedReportType = new SelectedReportType();
//külön queryk-ben/Getparameters-ben kap értéket
_LastSubmittedDay = new LastSubmittedDay();
_JobCh = new JobCH();
_InsertedHour = new InstertedHour();
_ValidationConstraint = new ValidationConstraint();
_JobFilter = new JobFilter();
_ActivityCodeFilter = new ActivityCodeFilter();
_UserGroup = new UserGroup();
_ReasonCodeFilter = new ReasonCodeFilter();
}
