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)); }
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); }
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); }