public override DataTable OfSelect(DbTransaction ptran, string ps_where, params object[] p_params)
{
string ls_sql = "";
if (SelectSQLString.ToLower().Contains("where") || ps_where.Trim().ToLower().StartsWith("where"))
{
ls_sql = this.SelectSQLString + ps_where;
}
else
{
ls_sql = this.SelectSQLString + " WHERE 1=1 " + ps_where;
}
return(OfExecuteDatatable(ptran, ls_sql, p_params));
}
/// <summary>
///
/// </summary>
/// <param name="ps_where"></param>
/// <returns></returns>
public int of_select_count(DbTransaction ptran, string ps_where)
{
string ls_sql = "";
if (SelectSQLString.ToLower().Contains("where") || ps_where.Trim().ToLower().StartsWith("where"))
{
ls_sql = this.SelectCountSQLString + ps_where;
}
else
{
ls_sql = this.SelectCountSQLString + " WHERE " + ps_where;
}
int li_return = int.Parse(of_execute_scalar(ptran, ls_sql, null).ToString());
return(li_return);
}