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)); }