/// <summary>
/// 分页获取扫描历史列表信息
/// </summary>
/// <param name="searchParam">搜索条件</param>
/// <param name="para">分页信息</param>
/// <returns></returns>
public JsonResult GetScanHistoryListBySearch(ScanHistorySearch searchParam, GridParams para)
{
if (para.sortdatafield == null)
{
para.sortdatafield = "CreatedDate";
para.sortorder = "desc";
}
para.pagenum = para.pagenum + 1;
var model = _scanHistoryLogic.GetScanHistoryListBySearch(searchParam, para);
return(Json(model, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 分页获取扫描历史列表信息
/// </summary>
/// <param name="searchParam">搜索条件</param>
/// <param name="para">分页信息</param>
/// <returns></returns>
public JsonResultModel <Business_ScanHistory_Information> GetScanHistoryListBySearch(ScanHistorySearch searchParam, GridParams para)
{
using (var db = SugarDao_MsSql.GetInstance())
{
JsonResultModel <Business_ScanHistory_Information> jsonResult = new JsonResultModel <Business_ScanHistory_Information>();
var query = db.Queryable <Business_ScanHistory_Information>();
if (!string.IsNullOrEmpty(searchParam.MachineCode))
{
query.Where(it => it.MachineCode.Contains(searchParam.MachineCode));
}
if (!string.IsNullOrEmpty(searchParam.CreatedDateFrom) && !string.IsNullOrEmpty(searchParam.CreatedDateTo))
{
DateTime createdTimeStart = DateTime.Parse(searchParam.CreatedDateFrom);
DateTime createdTimeEnd = DateTime.Parse(searchParam.CreatedDateTo);
query.Where(i => i.CreatedDate > createdTimeStart && i.CreatedDate < createdTimeEnd);
}
else
{
if (!string.IsNullOrEmpty(searchParam.CreatedDateFrom))
{
DateTime createdTimeStart = DateTime.Parse(searchParam.CreatedDateFrom);
query.Where(i => i.CreatedDate > createdTimeStart);
}
if (!string.IsNullOrEmpty(searchParam.CreatedDateTo))
{
DateTime createdTimeEnd = DateTime.Parse(searchParam.CreatedDateTo);
query.Where(i => i.CreatedDate < createdTimeEnd);
}
}
query.OrderBy(para.sortdatafield + " " + para.sortorder);
jsonResult.TotalRows = query.Count();
jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize);
//存入操作日志表
string logData = JsonHelper.ModelToJson(jsonResult);
_logLogic.SaveLog(3, 44, CurrentUser.GetCurrentUser().LoginName, "扫码历史列表", logData);
return(jsonResult);
}
}
/// <summary>
/// 分页获取扫描历史列表信息
/// </summary>
/// <param name="searchParam">搜索条件</param>
/// <param name="para">分页信息</param>
/// <returns></returns>
public JsonResultModel <Business_ScanHistory_Information> GetScanHistoryListBySearch(ScanHistorySearch searchParam, GridParams para)
{
return(_scanHistoryServer.GetScanHistoryListBySearch(searchParam, para));
}
