62,046
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE [dbo].[usp_TransactSql]
(
@SqlStatement varchar(4000)
)
AS
BEGIN TRANSACTION
EXECUTE (@SqlStatement)
IF (@@ERROR = 0)
COMMIT TRANSACTION
ELSE
ROLLBACK TRANSACTION
public void Transact(string strSql)
{
Parameter[] parameter = { new Parameter("@SqlStatement", SqlDbType.VarChar, 4000, strSql) };
objBusinessBase.ExecuteProcedure("usp_TransactSql", parameter);
}
string strSql = this.txtSql.Text.Trim();
try
{
objDataBase.Transact(strSql);
this.txtSql.Text = string.Empty;
objInsusJsUtility.JsAlert("Transact-SQL成功处理!");
}
catch (Exception ex)
{
objInsusJsUtility.JsAlert(ex.Message);
}