예제 #1
0
        public DataTable ExecSelSP <@type>(string SProc, ref @type paramObj)
        {
            OracleParameter[] 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);
        }
예제 #2
0
 public DataTable ExecQuery(string Query, string tableName, SearchRec search)
 {
     return(ExecQuery(Query, tableName, search.ToSqlParams()));
 }
예제 #3
0
 public object ExecEscalar(string Query, SearchRec search)
 {
     return(ExecEscalar(Query, search.ToSqlParams()));
 }
예제 #4
0
 public DataSet ExecSelSPDS(string SProc, SearchRec search)
 {
     return(ExecSelSPDS(SProc, search.ToSqlParams()));
 }
예제 #5
0
 public int ExecNonQuery(string Query, SearchRec search)
 {
     return(ExecNonQuery(Query, search.ToSqlParams()));
 }