/// <summary>
/// 查询加班列表
/// </summary>
/// <param name="request">条件</param>
/// <returns>加班列表</returns>
public Response <List <JBRecord> > GetJBRecordList(Request <JBQuery> request)
{
Response <List <JBRecord> > response = new Response <List <JBRecord> >();
try
{
if (request != null && request.Data != null)
{
JBQuery model = request.Data;
RoleType role = utility.GetRoleType(cookieKey);
model.UserID = role == RoleType.Admin ? model.UserID : utility.GetUserID(cookieKey);
IQueryable <JBRecord> query = dbContext.JBRecords.AsQueryable();
if (model.UserID.HasValue && model.UserID != 0)//role != RoleType.Admin
{
query = query.Where(o => o.UserID == model.UserID.Value);
}
//if (model.Year.HasValue)
//{
// query = query.Where(o => o.Year == model.Year.Value);
//}
//if (model.Month.HasValue)
//{
// query = query.Where(o => o.Month == model.Month.Value);
//}
if (model.STime.HasValue)
{
query = query.Where(o => o.STime >= model.STime.Value);
}
if (model.ETime.HasValue)
{
query = query.Where(o => o.ETime <= model.ETime.Value);
}
if (!string.IsNullOrEmpty(model.RemarkKey))
{
query = query.Where(o => o.Remark.Contains(model.RemarkKey));
}
//response.Result = query.OrderByDescending(o => o.ModifiedTime).ToList();
response.TotalCount = query.Count();
int pageIndex = model.PageIndex <= 0 ? 1 : model.PageIndex;
int pageSize = model.PageSize <= 0 ? 10 : model.PageSize;
response.Result = query.OrderByDescending(o => o.ModifiedTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
if (response.Result != null && response.Result.Count > 0)
{
response.IsSuccess = true;
}
else
{
response.ErrorMsg = "没有数据！";
}
log.AddLog(LogType.Info, "GetJBRecordList,查询结果：" + JsonConvert.SerializeObject(response), request.RequestKey);
}
}
catch (Exception ex)
{
log.AddLog(LogType.Error, "GetJBRecordList,查询加班异常：" + ex.Message, request.RequestKey);
}
return(response);
}
/// <summary>
/// 查询加班记录
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public ActionResult JBList(JBQuery data)
{
if (Request.HttpMethod == "POST")
{
Response <List <JBRecord> > response = new Response <List <JBRecord> >();
List <object> list = new List <object>();
if (data != null)
{
Request <JBQuery> request = new Request <JBQuery>();
request.Data = data;
request.RequestKey = Guid.NewGuid().ToString();
request.RequsetTime = DateTime.Now;
response = logic.GetJBRecordList(request);
//行号
#region
if (response.Result != null && response.Result.Count > 0)
{
int index = 1;
foreach (JBRecord item in response.Result)
{
list.Add(new
{
RowNum = index,
JID = item.JID,
UserID = item.UserID,
STime = item.STime,
ETime = item.ETime,
Hours = item.Hours,
Remark = item.Remark,
AddTime = item.AddTime,
ModifiedTime = item.ModifiedTime
});
index++;
}
}
#endregion
}
//return Json(new { data = response.Result });
//return Json(new { rows = response.Result, total = response.TotalCount });
return(Json(new { rows = list, total = response.TotalCount }));
}
else
{
//int userid = Convert.ToInt32(Request.QueryString["userid"]);
//int year = Convert.ToInt32(Request.Params["year"]);
//int month = Convert.ToInt32(Request["month"]);
ViewData["UserID"] = string.IsNullOrEmpty(Request["userid"])?"0":Request["userid"];
ViewData["Year"] = string.IsNullOrEmpty(Request["year"]) ? "0" : Request["year"];
ViewData["Month"] = string.IsNullOrEmpty(Request["month"]) ? "0" : Request["month"];
return(View());
}
}
