/// <summary> /// 获取数据集 /// </summary> /// <param name="sql"></param> /// <returns></returns> public DataSet getDataSetBySql(string sql) { bllPaging objbllPaging = new bllPaging(); DataSet ds = null; try { ds = objbllPaging.GetDataSetInfoBySQL(sql); } catch (Exception ex) { } finally { objbllPaging = null; } return(ds); }
/// <summary> /// 用事务执行SQL命令,并返回数据集 /// </summary> /// <param name="sql">sql语句(不包含事务语句)</param> /// <returns></returns> public DataSet ExecuteDataSetByTran(string sql) { bllPaging objbllPaging = new bllPaging(); StringBuilder Builder = new StringBuilder(); Builder.AppendLine(" BEGIN TRAN tan1"); //开始事务 Builder.AppendLine(sql); //开始事务 Builder.AppendLine(" if(@@error=0) begin commit tran tan1; end else begin rollback tran tran1 end"); //结束事务 DataSet ds = null; try { ds = objbllPaging.GetDataSetInfoBySQL(Builder.ToString()); } catch (Exception ex) { } finally { objbllPaging = null; } return(ds); }