public ActionResult DataLogGridData(int id)
{
GridRequest request = new GridRequest(Request);
if (id > 0)
{
request.FilterGroup.Rules.Add(new FilterRule("OperateLog.Id", id));
}
int total;
var datas = GetQueryData<DataLog, int>(LoggingContract.DataLogs, out total, request).Select(m => new
{
m.Id,
m.EntityKey,
m.Name,
m.EntityName,
m.OperateType,
LogItems = m.LogItems.Select(n => new
{
n.Field,
n.FieldName,
n.OriginalValue,
n.NewValue,
n.DataType
})
}).ToList();
return Json(new GridData<object>(datas, total), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData(string entityName)
{
GridRequest request = new GridRequest(Request);
var query = (from a in FlowContract.FlowArchives where a.CreatorUserId==Operator.UserId
join i in FlowContract.FlowItems on a.FlowItemId equals i.Id
join r in FlowContract.FlowRelateForms on i.FlowDesignId equals r.FlowDesignId
join f in FlowContract.FlowForms on r.FlowFormId equals f.Id
join d in CommonContract.Dictionarys on f.TypeVal equals d.Value
select new FlowFormDto
{
Id = a.Id,
FormName = i.EntityName,
TypeVal = f.TypeVal,
TypeName = d.Name,
CreatorUserName = a.CreatorUserName,
CreatTime = a.CreatedTime
})
.WhereIf(c => c.FormName.Contains(entityName), !entityName.IsNullOrEmpty());
var total = query.Count();
if (request.PageCondition.SortConditions.Length > 0)
{
foreach (var item in request.PageCondition.SortConditions)
{
query = query.OrderBy(item.SortField, item.ListSortDirection);
}
}
else
query = query.OrderBy("CreatTime", ListSortDirection.Descending);
var list = query.Skip((request.PageCondition.PageIndex - 1) * request.PageCondition.PageSize).Take(request.PageCondition.PageSize).ToList();
var data = new GridData<FlowFormDto>(list, total);
return Json(data, JsonRequestBehavior.AllowGet);
}
public ActionResult GridData(int? id)
{
GridRequest request = new GridRequest(Request);
var page = GetPageResult(IdentityContract.Roles, m => new
{
m.Id,
m.Name,
m.Remark,
m.IsAdmin,
m.IsSystem,
m.IsLocked,
m.CreatedTime
}, request);
return Json(page.ToGridData(), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData(string formName)
{
GridRequest request = new GridRequest(Request);
var page = GetPageResult(FlowContract.FlowDesigns,
m => new
{
m.Id,
m.FlowType,
m.FlowName,
m.CreatorUserName,
m.CreatedTime,
m.Status
},
request);
return Json(page.ToGridData(), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData()
{
GridRequest request = new GridRequest(Request);
request.AddDefaultSortCondition(new SortCondition("CreatedTime", ListSortDirection.Descending));
var page = GetPageResult(FlowContract.FlowItems,
m => new
{
m.Id,
m.EntityName,
m.CreatorUserName,
m.CreatedTime,
m.DelayDay,
m.StepDay,
m.HandleDay
},
request);
return Json(page.ToGridData(), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData()
{
GridRequest request = new GridRequest(Request);
var predicate = ExpressionExtensions.True<WorkFlowTask>();
predicate = predicate.And(c => c.Status >= 10 && c.ReceiverId == Operator.UserId);
var page = FlowContract.FlowTasks.ToPage(predicate, request.PageCondition, m => new
{
m.Id,
m.FlowItemId,
m.FlowItem.FlowDesignId,
m.FlowItem.EntityId,
m.FlowItem.EntityName,
m.StepName,
m.SenderName,
m.CreatedTime,
m.Status,
m.StepDay,
m.DelayDay,
m.DelayReason
});
return Json(page.ToGridData(), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData()
{
GridRequest request = new GridRequest(Request);
if (request.PageCondition.SortConditions.Length == 0)
{
request.PageCondition.SortConditions = new[]
{
new SortCondition("ClassName")
};
}
Expression<Func<EntityInfo, bool>> predicate = FilterHelper.GetExpression<EntityInfo>(request.FilterGroup);
var page = SecurityContract.EntityInfos.ToPageCache(predicate,
request.PageCondition,
m => new
{
m.Id,
m.Name,
m.ClassName,
m.DataLogEnabled
});
return Json(page.ToGridData(), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData()
{
GridRequest request = new GridRequest(Request);
request.AddDefaultSortCondition(new SortCondition("CreatedTime", ListSortDirection.Descending));
var page = GetPageResult(IdentityContract.Users,
m => new
{
m.Id,
m.OrganizationId,
m.UserName,
m.NickName,
m.Email,
m.EmailConfirmed,
m.PhoneNumber,
m.PhoneNumberConfirmed,
m.LockoutEndDateUtc,
m.AccessFailedCount,
m.IsLocked,
m.CreatedTime
},
request);
return Json(page.ToGridData(), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData()
{
GridRequest request = new GridRequest(Request);
request.AddDefaultSortCondition(new SortCondition("CreatedTime", ListSortDirection.Descending));
request.FilterGroup.Rules.Add(new FilterRule("CreatorUserId", Operator.UserId));
request.FilterGroup.Operate = FilterOperate.And;
var page = GetPageResult(FlowContract.FlowDelegations,
m => new
{
m.Id,
m.FlowDesignId,
m.TrusteeId,
FlowName=m.FlowDesign.FlowName,
m.CreatorUserName,
m.CreatedTime,
m.TrusteeName,
m.StartTime,
m.EndTime,
m.Status
},
request);
return Json(page.ToGridData(), JsonRequestBehavior.AllowGet);
}
public ActionResult OperateLogGridData()
{
int total;
GridRequest request = new GridRequest(Request);
if (request.PageCondition.SortConditions.Length == 0)
{
request.PageCondition.SortConditions = new[] { new SortCondition("CreatedTime", ListSortDirection.Descending) };
}
var datas = GetQueryData<OperateLog, int>(LoggingContract.OperateLogs, out total, request).Select(m => new
{
m.Id,
m.FunctionName,
m.Operator.UserId,
m.Operator.NickName,
m.Operator.Ip,
m.CreatedTime,
DataLogs = new { m.Id, m.DataLogs.Count }
}).ToList();
return Json(new GridData<object>(datas, total), JsonRequestBehavior.AllowGet);
}
public ActionResult GridData()
{
GridRequest request = new GridRequest(Request);
if (request.PageCondition.SortConditions.Length == 0)
{
request.PageCondition.SortConditions = new[]
{
new SortCondition("Area"),
new SortCondition("Controller"),
new SortCondition("Name")
};
}
Expression<Func<Function, bool>> predicate = FilterHelper.GetExpression<Function>(request.FilterGroup);
var page = SecurityContract.Functions.ToPage(predicate,
request.PageCondition,
m => new
{
m.Id,
m.Name,
m.Url,
m.FunctionType,
m.OperateLogEnabled,
m.DataLogEnabled,
m.CacheExpirationSeconds,
m.IsCacheSliding,
m.Area,
m.Controller,
m.Action,
m.IsController,
m.IsAjax,
m.IsChild,
m.IsLocked,
m.IsTypeChanged,
m.IsCustom,
m.MenuName,
m.Type,
m.IconCls
});
GridData<object> gridData = new GridData<object>() { Total = page.Total };
gridData.Rows = page.Data.Select(m => new
{
m.Id,
m.Name,
m.Url,
m.FunctionType,
m.OperateLogEnabled,
m.DataLogEnabled,
m.CacheExpirationSeconds,
m.IsCacheSliding,
m.Area,
m.Controller,
m.Action,
ModuleName = m.Area + "-" + m.Controller,
m.IsController,
m.IsAjax,
m.IsChild,
m.IsLocked,
m.IsTypeChanged,
m.IsCustom,
m.MenuName,
m.Type,
m.IconCls
}).ToArray();
return Json(gridData, JsonRequestBehavior.AllowGet);
}
public ActionResult GridData(string formName)
{
GridRequest request = new GridRequest(Request);
var query = (from form in FlowContract.FlowForms
join r in FlowContract.FlowRelateForms on form.Id equals r.FlowFormId into fr
from r in fr.DefaultIfEmpty()
join d in CommonContract.Dictionarys on form.TypeVal equals d.Value into dic
from d in dic.DefaultIfEmpty()
select new FlowFormDto
{
Id=form.Id,
FormName=form.FormName,
TypeVal = form.TypeVal,
TypeName=d.Name,
CreatorUserName=form.CreatorUserName,
CreatTime=form.CreatedTime,
FilePath=form.FilePath,
ActionPath=form.ActionPath,
EnabledFlow=form.EnabledFlow,
Status=form.Status,
FlowDesignId=r.FlowDesignId
})
.WhereIf(c=>c.FormName.Contains(formName),!formName.IsNullOrEmpty());
var total = query.Count();
if (request.PageCondition.SortConditions.Length > 0 )
{
foreach (var item in request.PageCondition.SortConditions)
{
query = query.OrderBy(item.SortField, item.ListSortDirection);
}
}
else
query=query.OrderBy("CreatTime", ListSortDirection.Descending);
var list = query.Skip((request.PageCondition.PageIndex - 1) * request.PageCondition.PageSize).Take(request.PageCondition.PageSize).ToList();
var data = new GridData<FlowFormDto>(list, total);
return Json(data, JsonRequestBehavior.AllowGet);
}