/// <summary>
/// 获取数据表格
/// </summary>
/// <param name="param"></param>
/// <param name="LoginName"></param>
/// <returns></returns>
public DataTableDto GetData(DataTableDto param, string loginName, string userName, string phone)
{
var query = Sqldb.Select <sys_user>()
//.LeftJoin((u, r) => u.role_id == r.id)
.WhereIf(!loginName.IsEmpty(), u => u.login_name == loginName)
.WhereIf(!userName.IsEmpty(), u => u.user_name.Contains(userName))
.WhereIf(!phone.IsEmpty(), u => u.mobile_phone.Contains(phone))
.OrderByDescending(u => u.is_super)
.OrderByDescending(u => u.create_time)
.Count(out long total)
.Page(param.pageNumber, param.pageSize)
.ToList();
if (query.Count > 0)
{
var roleIds = query.Where(s => s.role_id > 0).Select(s => s.role_id).ToList();
if (roleIds.Count > 0)
{
var roles = Sqldb.Select <sys_role>().Where(s => roleIds.Contains(s.id)).ToList();
query.ForEach(s =>
{
s.role_name = roles.Where(a => a.id == s.role_id).Select(a => a.role_name).FirstOrDefault();
});
}
}
param.rows = query;
param.total = total;
return(param);
}
public IActionResult GetData(DataTableDto dto)
{
var user = RequestHelper.AdminInfo();
var data = _noticeApp.GetList(dto, "", user);
return(Json(data));
}
public IActionResult GetReplyList(DataTableDto param)
{
var noticeId = RequestHelper.GetQueryInt("noticeId");
var data = _noticeApp.GetReplyList(param, noticeId);
return(Json(data));
}
public IActionResult LogData(DataTableDto dto)
{
string jobId = RequestHelper.GetPostString("jobId");
var data = _logApp.GetLogPageList(dto, jobId);
return(Json(data));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="param"></param>
/// <param name="channelId">栏目</param>
/// <param name="title">文章标题</param>
/// <param name="status">审核状态</param>
/// <param name="contentProperty">0-全部，1-置顶，2-推荐</param>
/// <returns></returns>
public DataTableDto GetData(DataTableDto param, int channelId, string title, int status, int contentProperty)
{
long total = 0;
var query = Sqldb.Select <cms_content>()
.WhereIf(channelId > 0, s => s.channel_id == channelId)
.WhereIf(status >= 0, s => s.content_status == status)
.WhereIf(!title.IsEmpty(), s => s.title.Contains(title));
if (contentProperty == 1)
{
query = query.Where(s => s.is_top == 1);
}
else if (contentProperty == 2)
{
query = query.Where(s => s.is_recommend == 1);
}
var data = query.OrderByDescending(s => s.is_top)
.OrderByDescending(s => s.id)
.Page(param.pageNumber, param.pageSize)
.Count(out total)
.ToList();
param.total = total;
param.rows = data;
return(param);
}
public IActionResult GetData(DataTableDto dto)
{
string tableName = RequestHelper.GetPostString("tableName");
var data = codeGenApp.GetList(dto, tableName);
return(Json(data));
}
public IActionResult GetData(DataTableDto param)
{
var name = RequestHelper.GetQueryString("name");
var data = _addressBookApp.GetList(param, name);
return(Json(data));
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public DataTableDto GetData(DataTableDto dto, int loginStatus, string loginName, string loginIP, string startDate, string endDate)
{
var stime = DateTime.Now.AddMonths(-1);
var etime = DateTime.Now;
if (!startDate.IsEmpty())
{
stime = startDate.ToDate();
}
if (!endDate.IsEmpty())
{
etime = endDate.ToDate().AddDays(1);
}
var query = Sqldb.Select <login_info>()
.Where(s => s.request_time > stime && s.request_time < etime)
.WhereIf(loginStatus >= 0, s => s.login_status == loginStatus)
.WhereIf(!loginName.IsEmpty(), s => s.login_name == loginName)
.WhereIf(!loginIP.IsEmpty(), s => s.request_ip == loginIP)
.OrderByDescending(s => s.id)
.Count(out long total)
.Page(dto.pageNumber, dto.pageSize)
.ToList();
dto.total = total;
dto.rows = query;
return(dto);
}
public ActionResult GetData(DataTableDto param)
{
string roleName = RequestHelper.GetPostString("roleName", "");
string roleCode = RequestHelper.GetPostString("roleCode", "");
var data = _roleApp.GetData(param, roleName, roleCode);
return(Json(data));
}
public ActionResult GetSonList(DataTableDto dto)
{
long pid = RequestHelper.GetPostInt64("pid", 0);
string name = RequestHelper.GetPostString("name");
var list = _dicApp.GetSonList(dto, pid, name);
return(Json(list));
}
public ActionResult GetData(DataTableDto dto)
{
string dicCode = RequestHelper.GetPostString("dicCode");
string dicName = RequestHelper.GetPostString("dicName");
var list = _dicApp.GetData(dto, dicCode, dicName);
return(Json(list));
}
public IActionResult GetData(DataTableDto dto)
{
int pid = RequestHelper.GetPostInt("pid");
string name = RequestHelper.GetPostString("templateName", "");
var data = _templateApp.GetData(dto, pid, name);
return(Json(data));
}
public ActionResult GetPageList(DataTableDto param)
{
string tableName = RequestHelper.GetPostString("tableName", "");
string logDate = RequestHelper.GetPostString("logDate", "");
var data = sysSqlLogApp.GetPageList(param, tableName, logDate.ToDate());
return(Json(data));
}
public static string ToJson(this DataTableDto grid, string datetimeformats)
{
var timeConverter = new IsoDateTimeConverter {
DateTimeFormat = datetimeformats
};
return(JsonConvert.SerializeObject(grid, Formatting.Indented, timeConverter));
}
public ActionResult GetData(DataTableDto dto)
{
var log_type = RequestHelper.GetQueryString("logType", "0").ToInt();
var log_summary = RequestHelper.GetQueryString("log_summary", "");
var logDate = RequestHelper.GetQueryString("logDate", TimeHelper.FormatDate(DateTime.Now, "0"));
var data = _logApp.GetList(dto, log_type, log_summary, logDate.ToDate());
return(Json(data));
}
public DataTableDto GetList(DataTableDto 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);
}
public IActionResult GetData(DataTableDto dto)
{
int channelId = RequestHelper.GetPostInt("channelId");
int status = RequestHelper.GetPostInt("status", -1);
int contentProperty = RequestHelper.GetPostInt("contentProperty", 0); //0-全部，1-置顶，2-推荐
string title = RequestHelper.GetPostString("title");
var data = _contentApp.GetData(dto, channelId, title, status, contentProperty);
return(Json(data));
}
public ActionResult GetData(DataTableDto param)
{
//var data = new DataGridEx();
string loginName = RequestHelper.GetPostString("loginName");
string userName = RequestHelper.GetPostString("userName");
string phone = RequestHelper.GetPostString("phone");
var data = _userApp.GetData(param, loginName, userName, phone);
return(Json(data));
}
/// <summary>
/// 任务执行日志
/// </summary>
/// <param name="dto"></param>
/// <param name="jobId"></param>
/// <returns></returns>
public DataTableDto GetLogPageList(DataTableDto dto, string jobId)
{
var query = Sqldb.Select<crontab_history>()
.Where(s => s.job_id == jobId)
.OrderByDescending(s => s.id)
.Count(out long total)
.Page(dto.pageNumber, dto.pageSize).ToList();
dto.total = total;
dto.rows = query;
return dto;
}
public DataTableDto <Contracts> GetPages(int page, int size, string sort, string search)
{
var dataTable = new DataTableDto <Contracts>();
var contractList = UnitOfWork.GetRepository <Contracts>().GetAll()
.Where(x => (x.Id.ToString().Contains(search) || x.Name.Contains(search)) && x.IsDelete == false).ToList();
var total = contractList.Count();
dataTable.TotalElements = total;
dataTable.Data = contractList.Skip(page).Take(size).ToList();
return(dataTable);
}
public DataTableDto GetList(DataTableDto 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 IActionResult GetData(DataTableDto dto)
{
int loginStatus = RequestHelper.GetPostInt("loginStatus", -1);
string loginName = RequestHelper.GetPostString("loginName");
string loginIP = RequestHelper.GetPostString("loginIP");
string loginDate = RequestHelper.GetPostString("loginDate");
var data = loginInfoApp.GetData(dto, loginStatus, loginName, loginIP, loginDate);
return(Json(data));
}
public DataTableDto GetList(DataTableDto param, int logType, string log_summary, DateTime logDate)
{
var query = Sqldb.Select <easy_log>()
.Where(s => s.log_time >= logDate)
.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.pageNumber, param.pageSize).ToList();
param.total = total;
param.rows = query;
return(param);
}
/// <summary>
/// 数据列表
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public DataTableDto GetData(DataTableDto dto)
{
var query = Sqldb.Select <cms_ad>()
.OrderByDescending(s => s.id)
.Count(out long total)
.Page(dto.pageNumber, dto.pageSize)
.ToList();
dto.rows = query;
dto.total = total;
return(dto);
}
/// <summary>
/// 获取表格
/// </summary>
/// <param name="param"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public DataTableDto GetList(DataTableDto param, string tableName)
{
var query = Sqldb.Select <code_table>()
.WhereIf(!string.IsNullOrEmpty(tableName), s => s.table_name == tableName)
.OrderByDescending(s => s.update_time)
.Count(out long total)
.Page(param.page, param.limit).ToList();
param.total = total;
param.rows = query;
return(param);
}
/// <summary>
/// 字典数据
/// </summary>
/// <param name="dto"></param>
/// <param name="pid"></param>
/// <param name="name"></param>
/// <returns></returns>
public DataTableDto GetSonList(DataTableDto dto, long pid, string name)
{
var query = Sqldb.Queryable <sys_dictionary>()
.Where(s => s.parent_id == pid)
.WhereIf(!name.IsEmpty(), s => s.dic_name == name)
.OrderBy(s => s.sort_num)
.Count(out long total)
.Page(dto.page, dto.limit).ToList();
dto.rows = query;
dto.total = total;
return(dto);
}
/// <summary>
///获取数据列表
/// </summary>
/// <param name="param"></param>
public DataTableDto GetData(DataTableDto param)
{
long total = 0;
var query = Sqldb.Select <sys_position>()
.OrderBy(s => s.id)
.Page(param.pageNumber, param.pageSize)
.Count(out total)
.ToList();
param.total = total;
param.rows = query;
return(param);
}
public DataTableDto GetReplyList(DataTableDto 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 DataTableDto GetList(DataTableDto 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>
/// <returns></returns>
public DataTableDto GetData(DataTableDto param, string roleName, string roleCode)
{
var query = Sqldb.Queryable <sys_role>()
.WhereIf(!roleName.IsEmpty(), s => s.role_name.Contains(roleName))
.WhereIf(!roleCode.IsEmpty(), s => s.role_code.Contains(roleCode))
.OrderBy(s => s.role_sort)
.Count(out long total)
.Page(param.page, param.limit).ToList();
param.total = total;
param.rows = query;
return(param);
}