public ActionResult GetData(BootstrapGridDto dto)
{
var log_type = RequestHelper.GetQueryString("log_type", "0").ToInt();
var log_summary = RequestHelper.GetQueryString("log_summary", "");
var data = _logApp.GetList(dto, log_type, log_summary);
return(Data(data));
}
public ActionResult GetData(BootstrapGridDto param)
{
string accountName = RequestHelper.RequestGet("accountName", "");
var data = _userService.GetData(param, accountName);
_logService.WriteLog(LogType.VIEW, $"查询用户", LogState.NORMAL);//写入日志
return(Content(data.ToJson()));
}
public ActionResult GetData()
{
var data = new BootstrapGridDto();
var list = _dicService.GetData();
_logService.WriteLog(LogType.VIEW, $"查询字典", LogState.NORMAL);//写入日志
return(Content(data.ToJson()));
}
public ActionResult GetData(BootstrapGridDto param)
{
var data = new BootstrapGridDto();
data = _roleService.GetData(param);
_logService.WriteLog(LogType.VIEW, $"查询角色", LogState.NORMAL);//写入日志
return(Content(data.ToJson()));
}
public BootstrapGridDto GetData(BootstrapGridDto param)
{
int total = 0;
var data = _sysfuncRepository.Queryable <sys_operate>().OrderBy(s => s.create_time, OrderByType.Desc).Select(u => new { Id = u.id, FuncName = u.func_name, FuncCName = u.func_cname, FuncIcon = u.func_icon, FuncSort = u.func_sort, FuncClass = u.func_class, CreateTime = u.create_time, CreatePerson = u.create_person }).ToPageList(param.page, param.limit, ref total);
param.rows = data;
param.total = total;
return(param);
}
public BootstrapGridDto GetData(BootstrapGridDto param)
{
int total = 0;
var query = _sysroleRepository.Queryable <sys_role>().OrderBy(s => s.sort).ToPageList(param.page, param.limit, ref total);
param.total = total;
param.rows = query;
return(param);
}
public BootstrapGridDto GetList(BootstrapGridDto param, string ntitle, LoginUserDto user)
{
long total = 0;
var query = new List <work_notice>();
var deptId = 0;
if (user.IsSuper)
{
query = Sqldb.Select <work_notice>()
.WhereIf(!string.IsNullOrEmpty(ntitle), s => s.n_title.Contains(ntitle))
.OrderByDescending(s => s.id).Count(out total).Page(param.page, param.limit)
.ToList();
}
else
{
query = Sqldb.Select <work_notice, work_notice_reply>()
.InnerJoin((n, r) => n.id == r.notice_id)
.Where((n, r) => r.dept_id == deptId)
.WhereIf(!string.IsNullOrEmpty(ntitle), (n, r) => n.n_title.Contains(ntitle))
.OrderByDescending((n, r) => n.id).Count(out total).Page(param.page, param.limit)
.ToList();
}
if (query.Count > 0)
{
var ids = query.Select(s => s.id).ToList();
var repList = Sqldb.Queryable <work_notice_reply>()
.Where(s => ids.Contains(s.notice_id)).ToList();
query.ForEach(s =>
{
var noticeRefReplys = repList.Where(a => a.notice_id == s.id).ToList();
s.received_count = noticeRefReplys.Where(a => a.reply_status == 1).Count();
s.unreceived_count = noticeRefReplys.Where(a => a.reply_status == 0).Count();
if (user.IsSuper)
{
s.is_check = 1;
}
else
{
if (deptId > 0)
{
s.is_check = noticeRefReplys.Where(a => a.dept_id == deptId).OrderBy(a => a.id)
.Select(a => a.reply_status).FirstOrDefault();
}
}
});
}
param.total = total;
param.rows = query;
return(param);
}
/// <summary>
/// 数据表格
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ActionResult GetData(BootstrapGridDto param)
{
//var data = new DataGridEx();
string accountName = RequestHelper.RequestGet("accountName", "");
var data = _userApp.GetData(param, accountName);
return(Content(data.ToJson()));
}
public BootstrapGridDto GetData(BootstrapGridDto param)
{
var query = _demoRepository.Queryable <demo>();
int total = 0;
var data = query.OrderBy(u => u.create_time, OrderByType.Desc).Select(u => new { Id = u.id, Name = u.name, Sex = u.sex, Age = u.age, Remark = u.remark, CreateTime = u.create_time, CreatePerson = u.create_person }).ToPageList(param.page, param.limit, ref total);
param.rows = data;
param.total = total;
return(param);
}
public BootstrapGridDto GetData(BootstrapGridDto param)
{
var query = _syslogRepository.Queryable <sys_log>();
int total = 0;
var data = query.OrderBy(u => u.logtime, OrderByType.Desc).Select(u => new { Id = u.id, Operation = u.operation, LogTime = u.logtime, LogtType = u.logtype, LogMsg = u.logmsg, LogLevel = u.loglevel, LogIP = u.logip }).ToPageList(param.page, param.limit, ref total);
param.rows = data;
param.total = total;
return(param);
}
/// <summary>
/// 数据表格
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ActionResult GetData(BootstrapGridDto param)
{
//var data = new DataGridEx();
string accountName = RequestHelper.GetQueryString("userName");
string nickName = RequestHelper.GetQueryString("nickName");
var data = _userApp.GetData(param, accountName, nickName);
return(Content(data.ToJson()));
}
/// <summary>
/// 数据表格
/// </summary>
/// <returns></returns>
public ActionResult GetData()
{
var data = new BootstrapGridDto();
var list = _dicApp.GetData();
//data.list = list;
//data.pageSize = list.Count;
return(Content(data.ToJson()));
}
public BootstrapGridDto GetData(BootstrapGridDto param, string accountName)
{
var query = Sqldb.Queryable <sys_user, sys_role>((u, r) => new object[] { JoinType.Left, u.sys_role_id == r.id }).Where((u, r) => !u.is_super);
int total = 0;
var data = query.OrderBy((u, r) => u.create_time, OrderByType.Desc).Select((u, r) => new { Id = u.id, AccountName = u.account_name, RealName = u.real_name, MobilePhone = u.mobile_phone, Email = u.email, CreateTime = u.create_time, RoleName = r.role_name }).ToPageList(param.page, param.limit, ref total);
param.rows = data;
param.total = total;
return(param);
}
public BootstrapGridDto GetData(BootstrapGridDto param)
{
int total = 0;
var query = Sqldb.Queryable <hangfire_jobs>().OrderBy(s => s.id)
.ToPageList(param.page, param.limit, ref total);
param.rows = query;
param.total = total;
return(param);
}
public BootstrapGridDto GetList(BootstrapGridDto param, int logType, string log_summary)
{
var query = Sqldb.Select <easy_log>()
.WhereIf(logType > 0, s => s.log_type == logType)
.WhereIf(!string.IsNullOrEmpty(log_summary), s => s.log_summary == log_summary)
.OrderByDescending(s => s.id).Count(out long total).Page(param.page, param.limit).ToList();
param.total = total;
param.rows = query;
return(param);
}
public BootstrapGridDto GetList(BootstrapGridDto param)
{
var query = Sqldb.Select <hangfire_task>()
.OrderByDescending(s => s.excute_status)
.OrderByDescending(s => s.excute_time).Count(out long total)
.Page(param.page, param.limit).ToList();
param.total = total;
param.rows = query;
return(param);
}
public BootstrapGridDto GetData(BootstrapGridDto param)
{
int total = 0;
var data = Sqldb.Queryable <sys_operate>()
.OrderBy(s => s.func_sort)
.ToPageList(param.page, param.limit, ref total);
param.rows = data;
param.total = total;
return(param);
}
public BootstrapGridDto GetData(BootstrapGridDto dto)
{
var query = Sqldb.Select <cms_ad>()
.OrderByDescending(s => s.id)
.Count(out long total)
.Page(dto.page, dto.limit)
.ToList();
dto.rows = query;
dto.total = total;
return(dto);
}
/// <summary>
/// 角色表格
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public BootstrapGridDto GetData(BootstrapGridDto param)
{
var query = Sqldb.Queryable <sys_role>()
.OrderBy(s => s.sort)
.Count(out long total)
.Page(param.page, param.limit).ToList();
param.total = total;
param.rows = query;
return(param);
}
/// <summary>
///获取数据列表
/// </summary>
/// <param name="param"></param>
public BootstrapGridDto GetData(BootstrapGridDto param)
{
long total = 0;
var query = Sqldb.Select <cms_content>()
.OrderBy(s => s.id)
.Page(param.page, param.limit)
.Count(out total)
.ToList();
param.total = total;
param.rows = query;
return(param);
}
public BootstrapGridDto GetData(BootstrapGridDto param)
{
var data = Sqldb.Queryable <sys_operate>()
.OrderBy(s => s.func_sort)
.Count(out long total)
.Page(param.page, param.limit)
.ToList();
param.rows = data;
param.total = total;
return(param);
}
public BootstrapGridDto GetReplyList(BootstrapGridDto param, int noticeId)
{
long total = 0;
var replys = Sqldb.Select <work_notice_reply>().Where(s => s.notice_id == noticeId)
.OrderByDescending(s => s.reply_time)
.Count(out total)
.Page(param.page, param.limit)
.ToList();
param.total = total;
param.rows = replys;
return(param);
}
public BootstrapGridDto GetList(BootstrapGridDto param, string name)
{
long total = 0;
var query = Sqldb.Select <work_address_book>()
.WhereIf(!string.IsNullOrEmpty(name), s => s.real_name == name)
.OrderByDescending(s => s.id).Count(out total)
.Page(param.page, param.limit)
.ToList();
param.total = total;
param.rows = query;
return(param);
}
/// <summary>
///获取数据列表
/// </summary>
/// <param name="param"></param>
public BootstrapGridDto GetData(BootstrapGridDto param, int channelId)
{
long total = 0;
var query = Sqldb.Select <cms_content>()
.WhereIf(channelId > 0, s => s.channel_id == channelId)
.OrderByDescending(s => s.is_top)
.OrderByDescending(s => s.id)
.Page(param.page, param.limit)
.Count(out total)
.ToList();
param.total = total;
param.rows = query;
return(param);
}
public BootstrapGridDto GetData(BootstrapGridDto dto, int pid)
{
var query = Sqldb.Select <cms_template>()
.WhereIf(pid > 0, s => s.pid == pid)
.OrderByDescending(s => s.id)
.Count(out long total)
.Page(dto.page, dto.limit)
.ToList(s => new cms_template
{
id = s.id,
template_name = s.template_name,
template_file = s.template_file,
is_default = s.is_default
});
dto.total = total;
dto.rows = query;
return(dto);
}
/// <summary>
/// 获取数据表格
/// </summary>
/// <param name="param"></param>
/// <param name="accountName"></param>
/// <returns></returns>
public BootstrapGridDto GetData(BootstrapGridDto param, string accountName, string nickName)
{
var query = Sqldb.Select <sys_user, sys_role, sys_department>()
.LeftJoin((u, r, d) => u.sys_role_id == r.id)
.LeftJoin((u, r, d) => u.dept_id == d.id)
.WhereIf(!accountName.IsEmpty(), (u, r, d) => u.account_name == accountName)
.WhereIf(!nickName.IsEmpty(), (u, r, d) => u.real_name.Contains(nickName))
.OrderByDescending((u, r, d) => u.is_super)
.OrderByDescending((u, r, d) => u.create_time)
.Count(out long total)
.Page(param.page, param.limit)
.ToList((u, r, d) => new { Id = u.id, IsSuper = u.is_super, AccountName = u.account_name,
RealName = u.real_name, MobilePhone = u.mobile_phone, Email = u.email,
CreateTime = u.create_time, RoleName = r.role_name, DeptName = d.department_name });
param.rows = query;
param.total = total;
return(param);
}
protected virtual ContentResult Data(BootstrapGridDto dto, string dateFormatter = "yyyy-MM-dd HH:mm:ss")
{
return(Content(dto.ToJson(dateFormatter)));
}
public IActionResult GetData(BootstrapGridDto dto)
{
var data = _adApp.GetData(dto);
return(Data(data));
}
public List <sys_menu> GetMenuList(BootstrapGridDto param)
{
var query = _sysmenuRepository.Queryable <sys_menu>().OrderBy(s => s.menu_sort).ToList();
return(query);
}
public ActionResult GetData(BootstrapGridDto dto)
{
var data = _logApp.GetList(dto);
return(Data(data));
}
