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); }