예제 #1
0
 public List<MessageEntity> getMessageByRestaurantId(int restaurantId)
 {
     //string mysql = "SELECT * FROM yumiyumi.yumi_account where user_name ='"+email+"'";
     string mysql = "SELECT `message_text`,`from_id`,`to_id`,`status`,`message_id`,`ctime` FROM `yumiyumi`.`yumi_message` where restaurant_id=?restaurantId ORDER BY `message_id` DESC  LIMIT 0,50;";
     MySqlParameter[] parameters = {
             new MySqlParameter("?restaurantId", MySqlDbType.Int32),
             };
     parameters[0].Value = restaurantId;
     MySqlDataReader myreader = MySqlHelper.ExecuteReader(mysql, parameters);
     List<MessageEntity> list = new List<MessageEntity>();
     while (myreader.Read())
     {
         MessageEntity message = new MessageEntity();
         message.message_text = myreader.GetString(0);
         message.from_id = myreader.GetInt32(1);
         message.to_id = myreader.GetInt32(2);
         message.status = myreader.GetInt32(3);
         message.message_id = myreader.GetInt32(4);
         message.ctime = myreader.GetString(5);
         message.restaurant_id = restaurantId;
         list.Add(message);
     }
     myreader.Close();
     return list;
 }
예제 #2
0
 public void ProcessRequest(HttpContext context)
 {
     context.Response.ContentType = "text/plain";
     String content = context.Request.QueryString["content"];
     MessageDAO messageDAO = new MessageDAO();
     MessageEntity message = new MessageEntity();
     message.ctime = System.DateTime.Now.ToString();
     message.from_id = -1;
     message.to_id = 1;
     message.status = 0;
     message.message_text = content;
     message.restaurant_id = 1;
     messageDAO.addOneMessage(message);
     context.Response.Write(content);
 }
예제 #3
0
        public bool addOneMessage(MessageEntity message)
        {
            string mysql = "insert into `yumi_message`(`message_text`,`from_id`,`to_id`,`status`,`ctime`,`restaurant_id`) values(?text,?fromId,?toId,?stauts,?ctime,?restaurantId);";
            MySqlParameter[] parameters = {
                    new MySqlParameter("?text", MySqlDbType.Text),
                    new MySqlParameter("?fromId", MySqlDbType.Int32),
                    new MySqlParameter("?toId", MySqlDbType.Int32),
                    new MySqlParameter("?stauts", MySqlDbType.Int32),
                    new MySqlParameter("?ctime", MySqlDbType.VarChar,32),
                    new MySqlParameter("?restaurantId", MySqlDbType.Int32)
                    };
            parameters[0].Value = message.message_text;
            parameters[1].Value = message.from_id;
            parameters[2].Value = message.to_id;
            parameters[3].Value = message.status;
            parameters[4].Value = System.DateTime.Now.Ticks;
            parameters[5].Value = message.restaurant_id;

            //通过MySqlCommand的ExecuteReader()方法构造DataReader对象
            int count = MySqlHelper.ExecuteNonQuery(mysql, parameters);
            if (count > 0) { return true; }
            else { return false; }
        }