public ActionResult GetTemperatureAlarmRules(TemperatureAlarmRuleSearchModel model, int searchPage)
{
var result = new SearchDataWithPagedDatas <TemperatureAlarmRuleSearchModel, TemperatureAlarmRuleListModel>();
result.SearchModel = model;
result.PagedDatas = TemperatureAlarmRuleBLL.GetPagedTemperatureAlarmRules(model, base.CurrentStrucID, searchPage, this.PageSize);
return(PartialView("_TemperatureAlarmRulePagedGrid", result));
}
public static AsiatekPagedList <TemperatureAlarmRuleListModel> GetPagedTemperatureAlarmRules(TemperatureAlarmRuleSearchModel model, int userAffiliatedStrucID, int searchPage, int pageSize)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@tableName", "TemperatureAlarmRules tar"),
new SqlParameter("@joinStr", @"INNER JOIN Func_GetStrucAndSubStrucByUserAffiliatedStrucID(" + userAffiliatedStrucID + ") struc ON tar.AffiliatedStrucID=struc.ID"),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@currentPage", searchPage),
new SqlParameter("@orderBy", "tar.ID DESC"),
new SqlParameter("@showColumns", @"tar.ID,tar.Name,struc.StrucName AS AffiliatedStrucName"),
};
string conditionStr = "tar.Name LIKE '%" + model.Name + "%'";
if (model.AffiliatedStrucID != -1)
{
conditionStr += " AND struc.ID = " + model.AffiliatedStrucID + "";
}
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 <TemperatureAlarmRuleListModel> list = ConvertToList <TemperatureAlarmRuleListModel> .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));
}
