public override bool Update(TransactionManager transactionManager, MaterialPurchasDtl entity)
        {
            SqlDatabase database = new SqlDatabase(this._connectionString);
            DbCommand   command  = StoredProcedureProvider.GetCommandWrapper(database, "dbo.MaterialPurchasDtl_Update", this._useStoredProcedure);

            database.AddInParameter(command, "@MaterialPurchasDtlID", DbType.Int32, entity.MaterialPurchasDtlID);
            database.AddInParameter(command, "@MaterialPurchasID", DbType.Int32, entity.MaterialPurchasID.HasValue ? ((object)entity.MaterialPurchasID) : ((object)DBNull.Value));
            database.AddInParameter(command, "@TypeStandard", DbType.AnsiString, entity.TypeStandard);
            database.AddInParameter(command, "@Unit", DbType.AnsiString, entity.Unit);
            database.AddInParameter(command, "@Number", DbType.Decimal, entity.Number.HasValue ? ((object)entity.Number) : ((object)DBNull.Value));
            database.AddInParameter(command, "@NeedDate", DbType.DateTime, entity.NeedDate.HasValue ? ((object)entity.NeedDate) : ((object)DBNull.Value));
            database.AddInParameter(command, "@SignDate", DbType.DateTime, entity.SignDate.HasValue ? ((object)entity.SignDate) : ((object)DBNull.Value));
            database.AddInParameter(command, "@SearchPriceDtl", DbType.AnsiString, entity.SearchPriceDtl);
            database.AddInParameter(command, "@FinalPrice", DbType.Decimal, entity.FinalPrice.HasValue ? ((object)entity.FinalPrice) : ((object)DBNull.Value));
            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.AcceptChanges();
            return(Convert.ToBoolean(num));
        }
Esempio n. 2
0
        public static MaterialPurchasDtl CreateMaterialPurchasDtl(int?materialPurchasDtlMaterialPurchasID, string materialPurchasDtlTypeStandard, string materialPurchasDtlUnit, decimal?materialPurchasDtlNumber, DateTime?materialPurchasDtlNeedDate, DateTime?materialPurchasDtlSignDate, string materialPurchasDtlSearchPriceDtl, decimal?materialPurchasDtlFinalPrice)
        {
            MaterialPurchasDtl dtl = new MaterialPurchasDtl();

            dtl.MaterialPurchasID = materialPurchasDtlMaterialPurchasID;
            dtl.TypeStandard      = materialPurchasDtlTypeStandard;
            dtl.Unit           = materialPurchasDtlUnit;
            dtl.Number         = materialPurchasDtlNumber;
            dtl.NeedDate       = materialPurchasDtlNeedDate;
            dtl.SignDate       = materialPurchasDtlSignDate;
            dtl.SearchPriceDtl = materialPurchasDtlSearchPriceDtl;
            dtl.FinalPrice     = materialPurchasDtlFinalPrice;
            return(dtl);
        }
Esempio n. 3
0
        public virtual MaterialPurchasDtl Copy()
        {
            MaterialPurchasDtl dtl = new MaterialPurchasDtl();

            dtl.MaterialPurchasDtlID = this.MaterialPurchasDtlID;
            dtl.MaterialPurchasID    = this.MaterialPurchasID;
            dtl.TypeStandard         = this.TypeStandard;
            dtl.Unit           = this.Unit;
            dtl.Number         = this.Number;
            dtl.NeedDate       = this.NeedDate;
            dtl.SignDate       = this.SignDate;
            dtl.SearchPriceDtl = this.SearchPriceDtl;
            dtl.FinalPrice     = this.FinalPrice;
            dtl.AcceptChanges();
            return(dtl);
        }