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