Пример #1
0
        /// <summary>
        /// 对象实体绑定数据
        /// </summary>
        public Mxm.Model.feed_back ReaderBind(IDataReader dataReader)
        {
            Mxm.Model.feed_back model = new Mxm.Model.feed_back();
            object ojb;

            ojb = dataReader["feed_id"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.feed_id = (int)ojb;
            }
            model.title        = dataReader["title"].ToString();
            model.linkman      = dataReader["linkman"].ToString();
            model.corperation  = dataReader["corperation"].ToString();
            model.link_address = dataReader["link_address"].ToString();
            ojb = dataReader["postcode"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.postcode = (decimal)ojb;
            }
            model.link_tel = dataReader["link_tel"].ToString();
            model.fax      = dataReader["fax"].ToString();
            ojb            = dataReader["mobile"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.mobile = (decimal)ojb;
            }
            model.email       = dataReader["email"].ToString();
            model.msg_content = dataReader["msg_content"].ToString();
            return(model);
        }
Пример #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Mxm.Model.feed_back GetModel(int feed_id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select feed_id,title,linkman,corperation,link_address,postcode,link_tel,fax,mobile,email,msg_content from feed_back ");
            strSql.Append(" where feed_id=@feed_id ");
            Database  db        = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());

            db.AddInParameter(dbCommand, "feed_id", DbType.Int32, feed_id);
            Mxm.Model.feed_back model = null;
            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                if (dataReader.Read())
                {
                    model = ReaderBind(dataReader);
                }
            }
            return(model);
        }
Пример #3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(Mxm.Model.feed_back model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into feed_back(");
            strSql.Append("title,linkman,corperation,link_address,postcode,link_tel,fax,mobile,email,msg_content)");

            strSql.Append(" values (");
            strSql.Append("@title,@linkman,@corperation,@link_address,@postcode,@link_tel,@fax,@mobile,@email,@msg_content)");
            Database  db        = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());

            db.AddInParameter(dbCommand, "title", DbType.String, model.title);
            db.AddInParameter(dbCommand, "linkman", DbType.String, model.linkman);
            db.AddInParameter(dbCommand, "corperation", DbType.String, model.corperation);
            db.AddInParameter(dbCommand, "link_address", DbType.String, model.link_address);
            db.AddInParameter(dbCommand, "postcode", DbType.Decimal, model.postcode);
            db.AddInParameter(dbCommand, "link_tel", DbType.String, model.link_tel);
            db.AddInParameter(dbCommand, "fax", DbType.String, model.fax);
            db.AddInParameter(dbCommand, "mobile", DbType.Decimal, model.mobile);
            db.AddInParameter(dbCommand, "email", DbType.String, model.email);
            db.AddInParameter(dbCommand, "msg_content", DbType.String, model.msg_content);
            db.ExecuteNonQuery(dbCommand);
        }
Пример #4
0
 /// <summary>
 /// 对象实体绑定数据
 /// </summary>
 public Mxm.Model.feed_back ReaderBind(IDataReader dataReader)
 {
     Mxm.Model.feed_back model = new Mxm.Model.feed_back();
     object ojb;
     ojb = dataReader["feed_id"];
     if (ojb != null && ojb != DBNull.Value)
     {
         model.feed_id = (int)ojb;
     }
     model.title = dataReader["title"].ToString();
     model.linkman = dataReader["linkman"].ToString();
     model.corperation = dataReader["corperation"].ToString();
     model.link_address = dataReader["link_address"].ToString();
     ojb = dataReader["postcode"];
     if (ojb != null && ojb != DBNull.Value)
     {
         model.postcode = (decimal)ojb;
     }
     model.link_tel = dataReader["link_tel"].ToString();
     model.fax = dataReader["fax"].ToString();
     ojb = dataReader["mobile"];
     if (ojb != null && ojb != DBNull.Value)
     {
         model.mobile = (decimal)ojb;
     }
     model.email = dataReader["email"].ToString();
     model.msg_content = dataReader["msg_content"].ToString();
     return model;
 }