public DataTable ExecSelSP <@type>(string SProc, ref @type paramObj)
        {
            SqlParameter[] Params = SearchRec.ToSqlParams(paramObj);
            DataSet        ds     = ExecSelSPDS(SProc, Params);

            foreach (var para in Params)
            {
                if (para.Direction == ParameterDirection.Output)
                {
                    paramObj.SetFieldValue(para.ParameterName.Replace("@", ""), para.Value);
                }
            }
            return((ds.Tables.Count > 0) ? ds.Tables[0] : null);
        }
 public DataTable ExecQuery(string Query, string tableName, SearchRec search)
 {
     return(ExecQuery(Query, tableName, search.ToSqlParams()));
 }
 public List <@type> GetEntities <@type>(string getSp, object parameters) where @type : class
 {
     return(ExecReaderSelSP(getSp, SearchRec.ToSqlParams(parameters)).ToList <@type>());
 }
 public DataSet ExecSelSPDS(string SProc, SearchRec search)
 {
     return(ExecSelSPDS(SProc, search.ToSqlParams()));
 }
 public object ExecEscalar(string Query, SearchRec search)
 {
     return(ExecEscalar(Query, search.ToSqlParams()));
 }
 public int ExecNonQuery(string Query, SearchRec search)
 {
     return(ExecNonQuery(Query, search.ToSqlParams()));
 }