Пример #1
0
        /// <summary>
        ///  更新一条数据
        /// </summary>
        public bool Update(objMsg model)
        {
            string str =
                "UPDATE p_objmsg SET SpecificTypeID=@SpecificTypeID,Title=@Title,Msg=@Msg,CreatDateTime=@CreatDateTime,Remake=@Remake where ID=@ID;";

            MySqlParameter[] parameters =
            {
                new MySqlParameter("@ID",             MySqlDbType.Int32,      11),
                new MySqlParameter("@SpecificTypeID", MySqlDbType.Int32),
                new MySqlParameter("@Title",          MySqlDbType.VarChar,   255),
                new MySqlParameter("@Msg",            MySqlDbType.VarChar,   255),
                new MySqlParameter("@CreatDateTime",  MySqlDbType.DateTime),
                new MySqlParameter("@Remake",         MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = model.ID;
            parameters[1].Value = model.SpecificTypeID;
            parameters[2].Value = model.Title;
            parameters[3].Value = model.Msg;
            parameters[4].Value = model.CreatDateTime;
            parameters[5].Value = model.Remake;

            if (DBHelper.ExecuteSql(str, parameters) >= 0)
            {
                return(true);
            }
            return(false);
        }
Пример #2
0
        /// <summary>
        ///// 是否存在该记录
        ///// </summary>
        //public bool Exists(int ID)
        //{
        //    int rowsAffected;
        //    MySqlParameter[] parameters = {
        //            new MySqlParameter("@ID", MySqlDbType.Int32)
        //    };
        //    parameters[0].Value = ID;

        //    int result = DbHelper.RunProcedure("p_objmsg_Exists", parameters, out rowsAffected);
        //    if (result == 1)
        //    {
        //        return true;
        //    }
        //    else
        //    {
        //        return false;
        //    }
        //}

        /// <summary>
        ///  增加一条数据
        /// </summary>
        public bool Add(objMsg model)
        {
            string str =
                "INSERT INTO p_objmsg(SpecificTypeID, Title, Msg, CreatDateTime, Remake) VALUE(@SpecificTypeID,@Title, @Msg, @CreatDateTime, @Remake);";

            MySqlParameter[] parameters =
            {
                //  new MySqlParameter("@ID", MySqlDbType.Int32,11),
                new MySqlParameter("@SpecificTypeID", MySqlDbType.Int32),
                new MySqlParameter("@Title",          MySqlDbType.VarChar,   255),
                new MySqlParameter("@Msg",            MySqlDbType.VarChar,   255),
                new MySqlParameter("@CreatDateTime",  MySqlDbType.DateTime),
                new MySqlParameter("@Remake",         MySqlDbType.VarChar, 255)
            };
            //  parameters[0].Value = model.ID;
            parameters[0].Value = model.SpecificTypeID;
            parameters[1].Value = model.Title;
            parameters[2].Value = model.Msg;
            parameters[3].Value = model.CreatDateTime;
            parameters[4].Value = model.Remake;

            if (DBHelper.ExecuteSql(str, parameters) >= 0)
            {
                return(true);
            }
            return(false);
        }
Пример #3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public objMsg DataRowToModel(DataRow row)
        {
            objMsg model = new objMsg();

            if (row != null)
            {
                if (row["ID"] != null && row["ID"].ToString() != "")
                {
                    model.ID = int.Parse(row["ID"].ToString());
                }
                if (row["SpecificTypeID"] != null)
                {
                    model.SpecificTypeID = int.Parse(row["SpecificTypeID"].ToString());
                }
                if (row["Title"] != null)
                {
                    model.Title = row["Title"].ToString();
                }
                if (row["Msg"] != null)
                {
                    model.Msg = row["Msg"].ToString();
                }
                if (row["CreatDateTime"] != null && row["CreatDateTime"].ToString() != "")
                {
                    model.CreatDateTime = DateTime.Parse(row["CreatDateTime"].ToString());
                }
                if (row["Remake"] != null)
                {
                    model.Remake = row["Remake"].ToString();
                }
            }
            return(model);
        }
Пример #4
0
        /// <summary>
        /// 内容页
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public ActionResult Content(string ID)
        {
            List <objSpecificType> ListBook = bllSpecificType.GetModelList(" TypeID=1 ");

            ViewData["book"] = ListBook;

            objMsg msg = bll.GetModel(int.Parse(ID));

            if (msg != null)
            {
                msg.Title = FromUnicodeString(msg.Title);
                msg.Msg   = FromUnicodeString(msg.Msg);
            }
            ViewData["msg"] = msg;
            return(View());
        }
Пример #5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public objMsg GetModel(int ID)
        {
            string str = "SELECT * FROM p_objmsg WHERE ID=@ID; ";

            MySqlParameter[] parameters =
            {
                new MySqlParameter("@ID", MySqlDbType.Int32)
            };
            parameters[0].Value = ID;

            objMsg  model = new objMsg();
            DataSet ds    = DBHelper.Query(str, parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Пример #6
0
        public ActionResult SaveContent(string username, string password, string tbTilie, string tbMsg, string tbType)
        {
            if (username == "tanzhenyu" && password == "liuyang")
            {
                objMsg obj = new objMsg();

                obj.CreatDateTime = DateTime.Now;

                obj.Msg            = ToUnicodeString(tbMsg);   //Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(tbMsg));
                obj.SpecificTypeID = int.Parse(tbType);
                obj.Title          = ToUnicodeString(tbTilie); //Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(tbTilie)); ;
                bll.Add(obj);
            }
            List <objMsg>          listMsgs         = bll.GetModelList(" 1=1 order by CreatDateTime LIMIT 10 ");
            List <objSpecificType> listSpecificType = bllSpecificType.GetModelList(" TypeID=1 ");

            List <objMsg> list = listMsgs;

            List <objSpecificType> ListBook = listSpecificType;

            ViewData["NewMsg"] = objMsgBase64ToString(list);
            ViewData["book"]   = ListBook;
            return(View("Index"));
        }
Пример #7
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(objMsg model)
 {
     return(dal.Update(model));
 }
Пример #8
0
        ///// <summary>
        ///// 是否存在该记录
        ///// </summary>
        ////public bool Exists(int ID)
        ////{
        ////    return dal.Exists(ID);
        ////}

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(objMsg model)
        {
            return(dal.Add(model));
        }