public PagedList <TestModel> GetListModel(TestSearchModel searchModel)
{
string sqlCount = @"
SELECT count(1)
FROM dbo.WmsRole (NOLOCK)
WHERE 1 = 1 {0}
";
string sqlPage = @"
SELECT RoleNo ,
RoleName ,
RoleDescription ,
Status
FROM dbo.WmsRole (NOLOCK)
WHERE 1 = 1 {0}
";
List <SqlParameter> parameterList = new List <SqlParameter>();
StringBuilder sbWhere = new StringBuilder();
SqlStringHelper.CreateSqlWhereAndPara(searchModel.RoleNo, SqlDbType.VarChar, "RoleNo", "RoleNo", ref sbWhere, ref parameterList);
SqlStringHelper.CreateSqlWhereAndPara(searchModel.RoleName, SqlDbType.VarChar, "RoleName", "RoleName", ref sbWhere, ref parameterList);
sqlPage = string.Format(sqlPage, sbWhere);
sqlCount = string.Format(sqlCount, sbWhere);
return(ExecPageSplit <TestModel>(sqlCount, sqlPage, "RoleName", searchModel, false, parameterList));
}