public static AsiatekPagedList <VehicleTemperatureAlarmRulesListModel> GetPagedVehicleTemperatureAlarmRules
(VehicleTemperatureAlarmRulesSearchModel model, int userAffiliatedStrucID, int searchPage, int pageSize)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@tableName", "dbo.Vehicles v"),
new SqlParameter("@joinStr", @"INNER JOIN Func_GetAllTheSubsetOfVehiclesByStrucID(" + userAffiliatedStrucID + @") vt ON vt.VID=v.ID
INNER JOIN dbo.Structures struc ON vt.StrucID=struc.ID
LEFT JOIN dbo.VehicleTemperatureAlarmRules vtar ON vt.VID=vtar.VehicleID
LEFT JOIN dbo.TemperatureAlarmRules tar ON tar.ID=vtar.TemperatureAlarmRuleID"),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@currentPage", searchPage),
new SqlParameter("@orderBy", "v.ID DESC"),
new SqlParameter("@showColumns", @"v.ID AS VID,v.VehicleName,v.PlateNum,v.VIN,tar.Name AS RuleName,struc.StrucName "),
};
string conditionStr = "1=1";
if (model.TemperatureAlarmRuleID != -1)
{
conditionStr += " AND vtar.TemperatureAlarmRuleID = " + model.TemperatureAlarmRuleID + "";
}
if (model.StrucID != -1)
{
conditionStr += " AND v.StrucID = " + model.StrucID + "";
}
if (!string.IsNullOrWhiteSpace(model.PlateNum))
{
conditionStr += " AND v.PlateNum LIKE '%" + model.PlateNum + "%'";
}
if (!string.IsNullOrWhiteSpace(model.VehicleName))
{
conditionStr += " AND v.VehicleName LIKE '%" + model.VehicleName + "%'";
}
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 <VehicleTemperatureAlarmRulesListModel> list = ConvertToList <VehicleTemperatureAlarmRulesListModel> .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));
}
public ActionResult GetTemperatureAlarmRuleDistribution(VehicleTemperatureAlarmRulesSearchModel model, int searchPage)
{
var result = new SearchDataWithPagedDatas <VehicleTemperatureAlarmRulesSearchModel, VehicleTemperatureAlarmRulesListModel>();
result.SearchModel = model;
//代码预留在这里，先强制是默认模式
if (base.VehicleViewMode)//默认模式
{
result.PagedDatas = TemperatureAlarmRuleBLL.GetPagedVehicleTemperatureAlarmRules(model, base.CurrentStrucID, searchPage, this.PageSize);
}
else//自由模式
{
result.PagedDatas = TemperatureAlarmRuleBLL.GetPagedVehicleTemperatureAlarmRules(model, base.CurrentStrucID, searchPage, this.PageSize);
}
return(PartialView("_VehicleTemperatureAlarmRulesPagedGrid", result));
}
