public ActionResult QueryLogs(TerminalSettingLogSearchModel model, int searchPage)
{
SearchDataWithPagedDatas <TerminalSettingLogSearchModel, TerminalSettingLogListModel> result
= new SearchDataWithPagedDatas <TerminalSettingLogSearchModel, TerminalSettingLogListModel>();
// 根据查询条件查询数据 若没有符合条件的数据 则显示 “查无数据！”的提示
ViewBag.IsShow = 1;
result.SearchModel = model;
result.PagedDatas = TerminalSettingsBLL.GetPagedTerminalSettingLog(model, searchPage, this.PageSize);
return(PartialView("LogsPagedGrid", result));
}
public static AsiatekPagedList <TerminalSettingLogListModel> GetPagedTerminalSettingLog(TerminalSettingLogSearchModel model, int searchPage, int pageSize)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@tableName", "TerminalSetLogs AS a"),
new SqlParameter("@joinStr", @" INNER JOIN Users AS b ON a.SetUserID = b.ID
INNER JOIN dbo.Vehicles AS c ON c.PlateNum=a.PlateNum
INNER JOIN dbo.Structures AS d ON d.ID = c.StrucID"),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@currentPage", searchPage),
new SqlParameter("@orderBy", "a.SetDTime DESC"),
new SqlParameter("@showColumns", @"a.ID,a.[TerminalCode] ,a.[PlateNum],d.StrucName
,a.[SetType],a.[SetDTime] ,b.NickName AS SetUserName"),
};
string conditionStr = "1 = 1 ";
if (!string.IsNullOrWhiteSpace(model.StrucName))
{
conditionStr += " AND d.StrucName LIKE '%" + model.StrucName + "%'";
}
if (!string.IsNullOrWhiteSpace(model.PlateNum))
{
conditionStr += " AND a.PlateNum LIKE '%" + model.PlateNum + "%'";
}
if (!string.IsNullOrWhiteSpace(model.TerminalCode))
{
conditionStr += " AND a.TerminalCode LIKE '%" + model.TerminalCode + "%'";
}
if (model.SettingType.HasValue)
{
conditionStr += " AND a.SetType = " + (byte)(TerminalSettingTypeEnum)model.SettingType;
}
if (model.StartTime.HasValue && model.EndTime.HasValue)
{
model.EndTime = Convert.ToDateTime(model.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59");
conditionStr += " AND SetDTime BETWEEN '" + model.StartTime.Value + "' AND '" + model.EndTime.Value + "'";
}
else if (model.StartTime.HasValue && !model.EndTime.HasValue)
{
conditionStr += " AND SetDTime >= '" + model.StartTime.Value + "'";
}
else if (!model.StartTime.HasValue && model.EndTime.HasValue)
{
model.EndTime = Convert.ToDateTime(model.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59");
conditionStr += " AND SetDTime <= '" + model.EndTime.Value + "'";
}
paras.Add(new SqlParameter("@conditionStr", conditionStr));
paras.Add(new SqlParameter()
{
ParameterName = "@totalItemCount",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
paras.Add(new SqlParameter()
{
ParameterName = "@newCurrentPage",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
List <TerminalSettingLogListModel> list = ConvertToList <TerminalSettingLogListModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.StoredProcedure, "Proc_GetPagedDatas", paras.ToArray()));
int totalItemCount = Convert.ToInt32(paras[paras.Count - 2].Value);
int newCurrentPage = Convert.ToInt32(paras[paras.Count - 1].Value);
return(list.ToPagedList(newCurrentPage, pageSize, totalItemCount));
}
