/// <summary>
/// 执行sql语句
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>返回影响的行数</returns>
public int ExecuteSql(string sql)
{
bllPaging objbllPaging = new bllPaging();
StringBuilder Builder = new StringBuilder();
Builder.AppendLine(sql);//开始事务
try
{
int intResult = objbllPaging.ExecuteNonQueryBySQL2(Builder.ToString());
return(intResult);
}
catch (Exception ex)
{ }
finally
{
objbllPaging = null;
}
return(0);
}
/// <summary>
/// 用事务执行SQL命令,并返回受影响的行数
/// </summary>
/// <param name="sql">sql语句（不包含事务语句）</param>
/// <returns>返回影响的行数</returns>
public int ExecuteDataSetByTran2(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
{
int intResult = objbllPaging.ExecuteNonQueryBySQL2(Builder.ToString());
return(intResult);
}
catch (Exception ex)
{ }
finally
{
objbllPaging = null;
}
return(0);
}
