/// <summary> /// 增加一条数据 /// </summary> public bool Add(ManagementCenter.Model.XH_SpotTradeRules model, DbTransaction tran, Database db) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into XH_SpotTradeRules("); strSql.Append( "MinChangePrice,FundDeliveryInstitution,StockDeliveryInstitution,BreedClassID,IsSlew,MaxLeaveQuantity,ValueTypeMinChangePrice,MarketUnitID,PriceUnit,MaxLeaveQuantityUnit,MinVolumeMultiples,BreedClassValidID,BreedClassHighLowID)"); strSql.Append(" values ("); strSql.Append( "@MinChangePrice,@FundDeliveryInstitution,@StockDeliveryInstitution,@BreedClassID,@IsSlew,@MaxLeaveQuantity,@ValueTypeMinChangePrice,@MarketUnitID,@PriceUnit,@MaxLeaveQuantityUnit,@MinVolumeMultiples,@BreedClassValidID,@BreedClassHighLowID)"); if (db == null) { db = DatabaseFactory.CreateDatabase(); } DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MinChangePrice", DbType.Currency, model.MinChangePrice); db.AddInParameter(dbCommand, "FundDeliveryInstitution", DbType.Int32, model.FundDeliveryInstitution); db.AddInParameter(dbCommand, "StockDeliveryInstitution", DbType.Int32, model.StockDeliveryInstitution); db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID); db.AddInParameter(dbCommand, "IsSlew", DbType.Int32, model.IsSlew); db.AddInParameter(dbCommand, "MaxLeaveQuantity", DbType.Int32, model.MaxLeaveQuantity); db.AddInParameter(dbCommand, "ValueTypeMinChangePrice", DbType.Int32, model.ValueTypeMinChangePrice); // db.AddInParameter(dbCommand, "ValueTypeMaxLeaveQuantity", DbType.Int32, model.ValueTypeMaxLeaveQuantity); db.AddInParameter(dbCommand, "MarketUnitID", DbType.Int32, model.MarketUnitID); db.AddInParameter(dbCommand, "PriceUnit", DbType.Int32, model.PriceUnit); db.AddInParameter(dbCommand, "MaxLeaveQuantityUnit", DbType.Int32, model.MaxLeaveQuantityUnit); db.AddInParameter(dbCommand, "MinVolumeMultiples", DbType.Int32, model.MinVolumeMultiples); db.AddInParameter(dbCommand, "BreedClassValidID", DbType.Int32, model.BreedClassValidID); db.AddInParameter(dbCommand, "BreedClassHighLowID", DbType.Int32, model.BreedClassHighLowID); // db.ExecuteNonQuery(dbCommand); object obj; if (tran == null) { obj = db.ExecuteNonQuery(dbCommand); } else { obj = db.ExecuteNonQuery(dbCommand, tran); } return(true); }
/// <summary> /// 得到一个对象实体 /// </summary> public ManagementCenter.Model.XH_SpotTradeRules GetModel(int BreedClassID) { StringBuilder strSql = new StringBuilder(); strSql.Append( "select MinChangePrice,FundDeliveryInstitution,StockDeliveryInstitution,BreedClassID,IsSlew,MaxLeaveQuantity,ValueTypeMinChangePrice,MarketUnitID,PriceUnit,MaxLeaveQuantityUnit,MinVolumeMultiples,BreedClassValidID,BreedClassHighLowID from XH_SpotTradeRules "); strSql.Append(" where BreedClassID=@BreedClassID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, BreedClassID); ManagementCenter.Model.XH_SpotTradeRules model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateSpotTradeRules(ManagementCenter.Model.XH_SpotTradeRules model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XH_SpotTradeRules set "); strSql.Append("MinChangePrice=@MinChangePrice,"); strSql.Append("FundDeliveryInstitution=@FundDeliveryInstitution,"); strSql.Append("StockDeliveryInstitution=@StockDeliveryInstitution,"); strSql.Append("IsSlew=@IsSlew,"); strSql.Append("MaxLeaveQuantity=@MaxLeaveQuantity,"); strSql.Append("ValueTypeMinChangePrice=@ValueTypeMinChangePrice,"); // strSql.Append("ValueTypeMaxLeaveQuantity=@ValueTypeMaxLeaveQuantity,"); strSql.Append("MarketUnitID=@MarketUnitID,"); strSql.Append("PriceUnit=@PriceUnit,"); strSql.Append("MaxLeaveQuantityUnit=@MaxLeaveQuantityUnit,"); strSql.Append("MinVolumeMultiples=@MinVolumeMultiples,"); strSql.Append("BreedClassValidID=@BreedClassValidID,"); strSql.Append("BreedClassHighLowID=@BreedClassHighLowID"); strSql.Append(" where BreedClassID=@BreedClassID"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MinChangePrice", DbType.Currency, model.MinChangePrice); db.AddInParameter(dbCommand, "FundDeliveryInstitution", DbType.Int32, model.FundDeliveryInstitution); db.AddInParameter(dbCommand, "StockDeliveryInstitution", DbType.Int32, model.StockDeliveryInstitution); db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID); db.AddInParameter(dbCommand, "IsSlew", DbType.Int32, model.IsSlew); db.AddInParameter(dbCommand, "MaxLeaveQuantity", DbType.Int32, model.MaxLeaveQuantity); db.AddInParameter(dbCommand, "ValueTypeMinChangePrice", DbType.Int32, model.ValueTypeMinChangePrice); // db.AddInParameter(dbCommand, "ValueTypeMaxLeaveQuantity", DbType.Int32, model.ValueTypeMaxLeaveQuantity); db.AddInParameter(dbCommand, "MarketUnitID", DbType.Int32, model.MarketUnitID); db.AddInParameter(dbCommand, "PriceUnit", DbType.Int32, model.PriceUnit); db.AddInParameter(dbCommand, "MaxLeaveQuantityUnit", DbType.Int32, model.MaxLeaveQuantityUnit); db.AddInParameter(dbCommand, "MinVolumeMultiples", DbType.Int32, model.MinVolumeMultiples); db.AddInParameter(dbCommand, "BreedClassValidID", DbType.Int32, model.BreedClassValidID); db.AddInParameter(dbCommand, "BreedClassHighLowID", DbType.Int32, model.BreedClassHighLowID); db.ExecuteNonQuery(dbCommand); return(true); }
/// <summary> /// 对象实体绑定数据 /// </summary> public ManagementCenter.Model.XH_SpotTradeRules ReaderBind(IDataReader dataReader) { ManagementCenter.Model.XH_SpotTradeRules model = new ManagementCenter.Model.XH_SpotTradeRules(); object ojb; ojb = dataReader["MinChangePrice"]; if (ojb != null && ojb != DBNull.Value) { model.MinChangePrice = (decimal)ojb; } ojb = dataReader["FundDeliveryInstitution"]; if (ojb != null && ojb != DBNull.Value) { model.FundDeliveryInstitution = (int)ojb; } ojb = dataReader["StockDeliveryInstitution"]; if (ojb != null && ojb != DBNull.Value) { model.StockDeliveryInstitution = (int)ojb; } ojb = dataReader["BreedClassID"]; if (ojb != null && ojb != DBNull.Value) { model.BreedClassID = (int)ojb; } ojb = dataReader["IsSlew"]; if (ojb != null && ojb != DBNull.Value) { model.IsSlew = (int)ojb; } ojb = dataReader["MaxLeaveQuantity"]; if (ojb != null && ojb != DBNull.Value) { model.MaxLeaveQuantity = (int)ojb; } ojb = dataReader["ValueTypeMinChangePrice"]; if (ojb != null && ojb != DBNull.Value) { model.ValueTypeMinChangePrice = (int)ojb; } ojb = dataReader["MarketUnitID"]; if (ojb != null && ojb != DBNull.Value) { model.MarketUnitID = (int)ojb; } ojb = dataReader["PriceUnit"]; if (ojb != null && ojb != DBNull.Value) { model.PriceUnit = (int)ojb; } ojb = dataReader["MaxLeaveQuantityUnit"]; if (ojb != null && ojb != DBNull.Value) { model.MaxLeaveQuantityUnit = (int)ojb; } ojb = dataReader["MinVolumeMultiples"]; if (ojb != null && ojb != DBNull.Value) { model.MinVolumeMultiples = (int)ojb; } ojb = dataReader["BreedClassValidID"]; if (ojb != null && ojb != DBNull.Value) { model.BreedClassValidID = (int)ojb; } ojb = dataReader["BreedClassHighLowID"]; if (ojb != null && ojb != DBNull.Value) { model.BreedClassHighLowID = (int)ojb; } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ManagementCenter.Model.XH_SpotTradeRules model) { return(Add(model, null, null)); }