System.Data.Common.DbTransaction.Rollback C# (CSharp) Method

Rollback() public abstract method

public abstract Rollback ( ) : void
return void
        public abstract void Rollback();
    }

Usage Example

示例#1
0
        /// <summary>
        /// ���� ɾ��
        /// </summary>
        /// <param name="orgid">Orgid ���</param>
        /// <returns>ִ�н��</returns>
        public int OrganizationDelete(out string resultMsg, Int32 orgid, DbTransaction tran = null)
        {
            resultMsg = string.Empty;
            int res = 0;
            try
            {
                //�洢��������
                string sql = "usp_organization_delete";

                //�������
                IList<DBParameter> parm = new List<DBParameter>();
                parm.Add(new DBParameter() { ParameterName = "Id", ParameterValue = orgid, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
                parm.Add(new DBParameter() { ParameterName = "resultMsg", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String });
                //����ִ��
                res = DBHelper.ExecuteNonQuery(sql, true, parm, tran);
                foreach (var item in parm)
                {
                    //��ȡ�������ֵ
                    if (item.ParameterName == "resultMsg")
                    {
                        resultMsg = item.ParameterValue.ToString();
                        break;
                    }
                }
            }
            catch (Exception ex)
            {
                if(tran != null)
                    tran.Rollback();
                resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
            }
            return res;
        }
All Usage Examples Of System.Data.Common.DbTransaction::Rollback