コード例 #1
0
        /// <summary>
        /// 执行存储过程(适应:参数无返回值的存储过程)
        /// </summary>
        /// <param name="sql">sql参考:exec pro_Test 1,1(pro_Test 1,1)</param>
        /// <returns>存储过程返回的对象</returns>
        public DataTable Exec(string sql)
        {
            DataTable result = _dal.Exec(sql);

            if (result == null)
            {
                return(new DataTable());
            }
            return(result);
        }
コード例 #2
0
        /// <summary>
        /// 执行存储过程(参数无返回值)
        /// </summary>
        /// <param name="sql">sql参考:exec pro_Test 1,1(pro_Test 1,1)</param>
        /// <param name="c">数据库连接对象</param>
        /// <returns></returns>
        public static DataTable ExecObj(string sql, DataConnection c)
        {
            ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);

            return(dal.Exec(sql));
        }