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