/// <summary>
/// 对象实体绑定数据
/// </summary>
public ManagementCenter.Model.XH_RightHightLowPrices ReaderBind(IDataReader dataReader)
{
ManagementCenter.Model.XH_RightHightLowPrices model = new ManagementCenter.Model.XH_RightHightLowPrices();
object ojb;
ojb = dataReader["RightHightLowPriceID"];
if (ojb != null && ojb != DBNull.Value)
{
model.RightHightLowPriceID = (int)ojb;
}
ojb = dataReader["RightFrontDayClosePrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.RightFrontDayClosePrice = (decimal)ojb;
}
ojb = dataReader["StockFrontDayClosePrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.StockFrontDayClosePrice = (decimal)ojb;
}
ojb = dataReader["SetScale"];
if (ojb != null && ojb != DBNull.Value)
{
model.SetScale = (decimal)ojb;
}
ojb = dataReader["HightLowID"];
if (ojb != null && ojb != DBNull.Value)
{
model.HightLowID = (int)ojb;
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ManagementCenter.Model.XH_RightHightLowPrices model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XH_RightHightLowPrices(");
strSql.Append("RightHightLowPriceID,RightFrontDayClosePrice,StockFrontDayClosePrice,SetScale,HightLowID)");
strSql.Append(" values (");
strSql.Append("@RightHightLowPriceID,@RightFrontDayClosePrice,@StockFrontDayClosePrice,@SetScale,@HightLowID)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RightHightLowPriceID", DbType.Int32, model.RightHightLowPriceID);
db.AddInParameter(dbCommand, "RightFrontDayClosePrice", DbType.Double, model.RightFrontDayClosePrice);
db.AddInParameter(dbCommand, "StockFrontDayClosePrice", DbType.Double, model.StockFrontDayClosePrice);
db.AddInParameter(dbCommand, "SetScale", DbType.Double, model.SetScale);
db.AddInParameter(dbCommand, "HightLowID", DbType.Int32, model.HightLowID);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ManagementCenter.Model.XH_RightHightLowPrices model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XH_RightHightLowPrices set ");
strSql.Append("RightFrontDayClosePrice=@RightFrontDayClosePrice,");
strSql.Append("StockFrontDayClosePrice=@StockFrontDayClosePrice,");
strSql.Append("SetScale=@SetScale,");
strSql.Append("HightLowID=@HightLowID");
strSql.Append(" where RightHightLowPriceID=@RightHightLowPriceID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RightHightLowPriceID", DbType.Int32, model.RightHightLowPriceID);
db.AddInParameter(dbCommand, "RightFrontDayClosePrice", DbType.Double, model.RightFrontDayClosePrice);
db.AddInParameter(dbCommand, "StockFrontDayClosePrice", DbType.Double, model.StockFrontDayClosePrice);
db.AddInParameter(dbCommand, "SetScale", DbType.Double, model.SetScale);
db.AddInParameter(dbCommand, "HightLowID", DbType.Int32, model.HightLowID);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ManagementCenter.Model.XH_RightHightLowPrices GetModel(int RightHightLowPriceID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RightHightLowPriceID,RightFrontDayClosePrice,StockFrontDayClosePrice,SetScale,HightLowID from XH_RightHightLowPrices ");
strSql.Append(" where RightHightLowPriceID=@RightHightLowPriceID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RightHightLowPriceID", DbType.Int32, RightHightLowPriceID);
ManagementCenter.Model.XH_RightHightLowPrices model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
