public ActionResult GetNeedDealAlarmList(NeedDealExceptionSearchModel model, int searchPage)
{
var result = new SearchDataWithPagedDatas <NeedDealExceptionSearchModel, NeedDealExceptionListModel>();
var now = DateTime.Now;
model.BeginDateTime = DateTime.Parse(now.AddMonths(-1).ToString("yyyy-MM-dd 00:00:00"));
model.EndDateTime = DateTime.Parse(now.AddDays(1).ToString("yyyy-MM-dd 00:00:00"));
result.SearchModel = model;
if (base.VehicleViewMode)
{
result.PagedDatas = ExceptionBLL.GetDefaultNeedDealExceptionList(model, searchPage, this.PageSize, base.CurrentStrucID);
}
else
{
result.PagedDatas = ExceptionBLL.GetNeedDealExceptionList(model, searchPage, this.PageSize, base.CurrentUserID);
}
return(PartialView("_NeedDealAlarmPagedGrid", result));
}
public static AsiatekPagedList <NeedDealExceptionListModel> GetNeedDealExceptionList(NeedDealExceptionSearchModel model, int searchPage, int pageSize, int userID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@tableName", "VW_SZYDExceptions e"),
new SqlParameter("@joinStr", @" INNER JOIN Func_GetVehiclesListByUserID_New(" + userID + @") v ON e.VIN=v.VIN
INNER JOIN dbo.ExceptionType et ON et.ID=e.ExceptionTypeID
INNER JOIN dbo.Terminals t ON t.LinkedVehicleID=v.VID
INNER JOIN dbo.ServerInfo si ON t.ServerInfoID=si.ID AND si.ServerCode=e.ServerCode"),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@currentPage", searchPage),
new SqlParameter("@orderBy", "e.SignalStartTime DESC"),
new SqlParameter("@showColumns", @"e.ID AS ExID,et.ExName,v.VehicleName,e.SignalStartTime,e.StartAddress,e.SignalEndTime,e.EndAddress,si.LinkedServerName,e.TerminalCode"),
};
#region 筛选条件
string conditionStr = "e.ExceptionTypeID IN(2,5,103) AND e.Status<>1 AND e.SignalStartTime BETWEEN '" + model.BeginDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "' AND '" + model.EndDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "'";
if (model.EndState == 1)//结束
{
conditionStr += " AND e.SignalEndTime IS NOT NULL";
}
else if (model.EndState == 0)//未结束
{
conditionStr += " AND e.SignalEndTime IS NULL";
}
paras.Add(new SqlParameter("@conditionStr", conditionStr));
#endregion
paras.Add(new SqlParameter()
{
ParameterName = "@totalItemCount",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
paras.Add(new SqlParameter()
{
ParameterName = "@newCurrentPage",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
var list = ConvertToList <NeedDealExceptionListModel> .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));
}
