Exemple #1
0
        private void Update()
        {
            SqlConnection cnn = new SqlConnection(DbConnString);

            cnn.Open();
            SqlTransaction sqlTransaction = cnn.BeginTransaction();

            try
            {
                SqlHelper.ExecuteNonQuery(sqlTransaction, this.GetCmdUpdate());
                ReportAuth ra = new ReportAuth();
                ra.UpdateViewNameToBusobject(this.DbConnString, this.DataCnn, sqlTransaction, this._ID);
                sqlTransaction.Commit();
            }
            catch (Exception e)
            {
                sqlTransaction.Rollback();
                throw e;
            }
            finally
            {
                if (cnn.State == ConnectionState.Open)
                {
                    cnn.Close();
                }
            }
            //SqlHelper.ExecuteNonQuery(DbConnString, this.GetCmdUpdate());
        }