首页 > 代码库 > C# 事务处理

C# 事务处理

       /// <summary>        /// 发送消息;  先插入“发件箱”表;而后插入“收件箱”(批量发送选定用户)表;        /// </summary>        /// <param name="parms"></param>        /// <param name="isSend"></param>        /// <param name="messageId"></param>        /// <param name="allId"></param>        /// <returns></returns>        public static int InsertMessageToOutbox(SqlParameter[] parms, bool isSend, string messageId, string allId)        {            int result;            try            {                SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringDefault);                conn.Open();                SqlTransaction tran = conn.BeginTransaction();                try                {                    result = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "InsertMessageToOutbox", parms);                    if (isSend)                    {                        //DataTable dt=                        BatchAddInbox(conn, allId, messageId, tran);                    }                    else                    {                        if (result > 0)                        {                            result = 1000;                        }                    }                    tran.Commit();                }                catch                {                    tran.Rollback();                    throw new Exception();                }            }            catch            {                result = 0;            }            return result;        }