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