public int ValideExists(string key)
{
string sql = CategoryItems.BuilderValideSql();
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "@code", Value = key
}
};
return(CommonRepository.ExecuteCount(sql, param, SqlConnString));
}
public int Count(RequestParam param)
{
string sql = SqlCmdHelper.GenerateCountSql <Organze>();
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (!string.IsNullOrEmpty(param.QueryKey))
{
sql += "and Code like @key+'%' or Name like @key+'%'";
sqlParam.Add(new SqlParameter()
{
ParameterName = "@key", Value = param.QueryKey
});
}
SqlCmdHelper help = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(CommonRepository.ExecuteCount(sql, sqlParam.ToArray(), SqlConnString));
}
