public ActionResult GetTerminalTypeInfo(TerminalTypeSearchModel model, int searchPage)
{
SearchDataWithPagedDatas <TerminalTypeSearchModel, TerminalTypeListModel> result = new SearchDataWithPagedDatas <TerminalTypeSearchModel, TerminalTypeListModel>();
result.SearchModel = model;
result.PagedDatas = TerminalTypeBLL.GetPagedTerminalTypes(model, searchPage, this.PageSize);
return(PartialView("_TerminalTypePagedGrid", result));
}
public static AsiatekPagedList <TerminalTypeListModel> GetPagedTerminalTypes(TerminalTypeSearchModel model, int searchPage, int pageSize)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@tableName", "TerminalTypes tt"),
new SqlParameter("@joinStr", "INNER JOIN TerminalManufacturer tm ON tt.TerminalManufacturerID = tm.ID"),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@currentPage", searchPage),
new SqlParameter("@orderBy", "tt.ID"),
new SqlParameter("@showColumns", @"tt.ID ,tt.CommunicationMode,
tt.TerminalName ,
tt.ACCOFF_Frequency ,
tt.ACCON_Frequency ,
tt.Filter ,
tm.ManufacturerName"),
};
string conditionStr = string.Empty;
if (!string.IsNullOrWhiteSpace(model.TerminalName))
{
conditionStr += "tt.TerminalName LIKE '%" + model.TerminalName + "%'";
}
if (model.TerminalManufacturerID != -1)
{
if (string.IsNullOrWhiteSpace(conditionStr))
{
conditionStr += "tt.TerminalManufacturerID=" + model.TerminalManufacturerID + "";
}
else
{
conditionStr += " AND tt.TerminalManufacturerID=" + model.TerminalManufacturerID + "";
}
}
if (!string.IsNullOrWhiteSpace(conditionStr))
{
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 <TerminalTypeListModel> list = ConvertToList <TerminalTypeListModel> .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));
}
