/// <summary> /// 对象实体绑定数据 /// </summary> public ManagementCenter.Model.StockInfo ReaderBind(IDataReader dataReader) { ManagementCenter.Model.StockInfo model = new ManagementCenter.Model.StockInfo(); object ojb; model.StockCode = dataReader["StockCode"].ToString(); model.StockName = dataReader["StockName"].ToString(); model.Paydt = dataReader["Paydt"].ToString(); model.LabelCommodityCode = dataReader["LabelCommodityCode"].ToString(); model.Nindcd = dataReader["Nindcd"].ToString(); model.StockPinYin = dataReader["StockPinYin"].ToString(); ojb = dataReader["turnovervolume"]; if (ojb != null && ojb != DBNull.Value) { model.turnovervolume = (double)ojb; } //2009-12-01新增实体字段 ojb = dataReader["GoerScale"]; if (ojb != null && ojb != DBNull.Value) { model.GoerScale = (decimal)ojb; } ojb = dataReader["BreedClassID"]; if (ojb != null && ojb != DBNull.Value) { model.BreedClassID = (int)ojb; } //ojb = dataReader["CodeFormSource"]; //if (ojb != null && ojb != DBNull.Value) //{ // model.CodeFromSource = (int)ojb; //} return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ManagementCenter.Model.StockInfo GetModel(string StockCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select StockCode,StockName,Paydt,LabelCommodityCode,Nindcd,StockPinYin,turnovervolume from StockInfo "); strSql.Append(" where StockCode=@StockCode "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "StockCode", DbType.String, StockCode); ManagementCenter.Model.StockInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ManagementCenter.Model.StockInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StockInfo("); strSql.Append("StockCode,StockName,Paydt,LabelCommodityCode,Nindcd,StockPinYin,turnovervolume)"); strSql.Append(" values ("); strSql.Append("@StockCode,@StockName,@Paydt,@LabelCommodityCode,@Nindcd,@StockPinYin,@turnovervolume)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "StockCode", DbType.String, model.StockCode); db.AddInParameter(dbCommand, "StockName", DbType.String, model.StockName); db.AddInParameter(dbCommand, "Paydt", DbType.String, model.Paydt); db.AddInParameter(dbCommand, "LabelCommodityCode", DbType.String, model.LabelCommodityCode); db.AddInParameter(dbCommand, "Nindcd", DbType.String, model.Nindcd); db.AddInParameter(dbCommand, "StockPinYin", DbType.String, model.StockPinYin); db.AddInParameter(dbCommand, "Nindcd", DbType.Double, model.turnovervolume); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ManagementCenter.Model.StockInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update StockInfo set "); strSql.Append("StockName=@StockName,"); strSql.Append("Paydt=@Paydt,"); strSql.Append("LabelCommodityCode=@LabelCommodityCode,"); strSql.Append("StockPinYin=@StockPinYin,"); strSql.Append("turnovervolume=@turnovervolume,"); strSql.Append("Nindcd=@Nindcd"); 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, "StockName", DbType.String, model.StockName); db.AddInParameter(dbCommand, "Paydt", DbType.String, model.Paydt); db.AddInParameter(dbCommand, "LabelCommodityCode", DbType.String, model.LabelCommodityCode); db.AddInParameter(dbCommand, "Nindcd", DbType.String, model.Nindcd); db.ExecuteNonQuery(dbCommand); }