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