public ActionResult GetDutyLogPageData(DutyLogQuery query)
{
if (query == null)
{
query = new DutyLogQuery();
}
if (!query.PageIndex.HasValue)
{
query.PageIndex = 1;
}
if (!query.PageSize.HasValue)
{
query.PageSize = 10;
}
PageVM <DutyLogVM> list = new DutyLogService().GetDutyLogPageData(query);
if (list == null || list.Data == null || list.Data.Count == 0)
{
return(Json(new
{
Code = -200,
Msg = "暂无数据"
}));
}
return(Json(new
{
Code = 200,
Msg = "获取成功",
Data = list
}));
}
public ActionResult GetDutyLogPageData(DutyLogQuery query)
{
if (query == null)
{
query = new DutyLogQuery();
}
if (!query.PageIndex.HasValue)
{
query.PageIndex = 1;
}
if (!query.PageSize.HasValue)
{
query.PageSize = 10;
}
try
{
PageVM <DutyLogVM> list = new DutyLogService().GetDutyLogPageData(query);
if (list == null || list.Data == null || list.Data.Count == 0)
{
return(Json(new
{
Code = -200,
Msg = "暂无数据"
}));
}
return(Json(new
{
Code = 200,
Msg = "获取成功",
Data = list
}));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.Message);
throw ex;
}
}
public PageVM <DutyLogVM> GetDutyLogPageData(DutyLogQuery query)
{
if (!query.PageIndex.HasValue)
{
query.PageIndex = 1;
}
if (!query.PageSize.HasValue)
{
query.PageSize = 10;
}
string sql = "select * from dutylog du where 1=1 ";
if (!string.IsNullOrEmpty(query.KeyWord))
{
sql += string.Format(" and du.UserName like '%{0}%' ", query.KeyWord);
}
if (query.StartTime.HasValue)
{
sql += string.Format(" and date(du.StartTime) >= '{0}' ", query.StartTime);
}
if (query.EndTime.HasValue)
{
sql += string.Format(" and date(du.EndTime) <= '{0}' ", query.EndTime);
}
sql += " order by du.ID DESC ";
string pageSql = string.Format(" Limit {0},{1}", (query.PageIndex - 1) * query.PageSize, query.PageSize);
using (var dbContext = new DbContext().ConnectionStringName(ConnectionUtil.connWXB, DbProviderTypes.MySql))
{
//获取指定页数据
List <DutyLogVM> list = dbContext.Sql(sql + pageSql).Query <DutyLogVM, List <DutyLogVM> >(reader =>
{
var duVM = new DutyLogVM()
{
ID = reader.AsInt("ID"),
UserName = reader.AsString("UserName"),
UserID = reader.AsInt("UserID")
};
if (!string.IsNullOrEmpty(reader["StartTime"].ToString()))
{
duVM.StartTime = Convert.ToDateTime(reader["StartTime"]);
duVM.StartTimeStr = duVM.StartTime.Value.ToString("yyyy-MM-dd hh:MM:ss");
}
else
{
duVM.StartTimeStr = string.Empty;
}
if (!string.IsNullOrEmpty(reader["EndTime"].ToString()))
{
duVM.EndTime = Convert.ToDateTime(reader["EndTime"]);
duVM.EndTimeStr = duVM.EndTime.Value.ToString("yyyy-MM-dd hh:MM:ss");
}
else
{
duVM.EndTimeStr = string.Empty;
}
return(duVM);
});
//获取数据总数
int totalCount = dbContext.Sql(sql).Query().Count;
//总页数
double totalPages = ((double)totalCount / query.PageSize.Value);
PageVM <DutyLogVM> pageVM = new PageVM <DutyLogVM>();
pageVM.Data = list;
pageVM.TotalCount = totalCount;
pageVM.TotalPages = (int)Math.Ceiling(totalPages);
pageVM.PageIndex = query.PageIndex;
return(pageVM);
}
}
