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