Exemplo n.º 1
0
        public override bool Update(TransactionManager transactionManager, Payout entity)
        {
            SqlDatabase database = new SqlDatabase(this._connectionString);
            DbCommand   command  = StoredProcedureProvider.GetCommandWrapper(database, "dbo.Payout_Update", this._useStoredProcedure);

            database.AddInParameter(command, "@PayoutCode", DbType.AnsiString, entity.PayoutCode);
            database.AddInParameter(command, "@OriginalPayoutCode", DbType.AnsiString, entity.OriginalPayoutCode);
            database.AddInParameter(command, "@PayoutID", DbType.AnsiString, entity.PayoutID);
            database.AddInParameter(command, "@ProjectCode", DbType.AnsiString, entity.ProjectCode);
            database.AddInParameter(command, "@PaymentCodes", DbType.AnsiString, entity.PaymentCodes);
            database.AddInParameter(command, "@PayoutDate", DbType.DateTime, entity.PayoutDate.HasValue ? ((object)entity.PayoutDate) : ((object)DBNull.Value));
            database.AddInParameter(command, "@PaymentType", DbType.AnsiString, entity.PaymentType);
            database.AddInParameter(command, "@Payer", DbType.AnsiString, entity.Payer);
            database.AddInParameter(command, "@SupplyCode", DbType.AnsiString, entity.SupplyCode);
            database.AddInParameter(command, "@BillNo", DbType.AnsiString, entity.BillNo);
            database.AddInParameter(command, "@InvoNo", DbType.AnsiString, entity.InvoNo);
            database.AddInParameter(command, "@BankName", DbType.AnsiString, entity.BankName);
            database.AddInParameter(command, "@BankAccount", DbType.AnsiString, entity.BankAccount);
            database.AddInParameter(command, "@SubjectCode", DbType.AnsiString, entity.SubjectCode);
            database.AddInParameter(command, "@Money", DbType.Decimal, entity.Money.HasValue ? ((object)entity.Money) : ((object)DBNull.Value));
            database.AddInParameter(command, "@Status", DbType.Int32, entity.Status.HasValue ? ((object)entity.Status) : ((object)DBNull.Value));
            database.AddInParameter(command, "@InputPerson", DbType.AnsiString, entity.InputPerson);
            database.AddInParameter(command, "@InputDate", DbType.DateTime, entity.InputDate.HasValue ? ((object)entity.InputDate) : ((object)DBNull.Value));
            database.AddInParameter(command, "@CheckPerson", DbType.AnsiString, entity.CheckPerson);
            database.AddInParameter(command, "@CheckDate", DbType.DateTime, entity.CheckDate.HasValue ? ((object)entity.CheckDate) : ((object)DBNull.Value));
            database.AddInParameter(command, "@CheckOpinion", DbType.AnsiString, entity.CheckOpinion);
            database.AddInParameter(command, "@SupplyName", DbType.AnsiString, entity.SupplyName);
            database.AddInParameter(command, "@Remark", DbType.AnsiString, entity.Remark);
            database.AddInParameter(command, "@ReceiptCount", DbType.Int32, entity.ReceiptCount.HasValue ? ((object)entity.ReceiptCount) : ((object)DBNull.Value));
            database.AddInParameter(command, "@GroupCode", DbType.AnsiString, entity.GroupCode);
            database.AddInParameter(command, "@IsApportioned", DbType.Int32, entity.IsApportioned.HasValue ? ((object)entity.IsApportioned) : ((object)DBNull.Value));
            database.AddInParameter(command, "@Cash", DbType.Decimal, entity.Cash.HasValue ? ((object)entity.Cash) : ((object)DBNull.Value));
            database.AddInParameter(command, "@MoneyType", DbType.AnsiString, entity.MoneyType);
            database.AddInParameter(command, "@ExchangeRate", DbType.Decimal, entity.ExchangeRate.HasValue ? ((object)entity.ExchangeRate) : ((object)DBNull.Value));
            database.AddInParameter(command, "@VoucherNo", DbType.AnsiString, entity.VoucherNo);
            database.AddInParameter(command, "@SubjectSetCode", DbType.AnsiString, entity.SubjectSetCode);
            int num = 0;

            if (transactionManager != null)
            {
                num = Utility.ExecuteNonQuery(transactionManager, command);
            }
            else
            {
                num = Utility.ExecuteNonQuery(database, command);
            }
            if (DataRepository.Provider.EnableEntityTracking)
            {
                EntityManager.StopTracking(entity.EntityTrackingKey);
            }
            entity.OriginalPayoutCode = entity.PayoutCode;
            entity.AcceptChanges();
            return(Convert.ToBoolean(num));
        }