public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; // int user_id = Convert.ToInt32(context.Request.QueryString["user_id"]); int restaurant_id = Convert.ToInt32(context.Request.QueryString["restaurant_id"]); int service_type = Convert.ToInt32(context.Request.QueryString["service_type"]); ServiceDAO serviceDAO = new ServiceDAO(); ServiceEntity service = new ServiceEntity(); // service.user_id = user_id; service.restaurant_id = restaurant_id; service.service_type = service_type; service.ctime = System.DateTime.Now.ToString(); service.status = 0; bool success = serviceDAO.addOneService(service); context.Response.Write(success + "\n"); context.Response.Write("help"); }
public bool addOneService(ServiceEntity service) { string mysql = "insert `yumi_service`(`user_id`,`restaurant_id`,`service_type`,`ctime`,`status`) values(?user_id,?restaurant_id,?service_type,?time,?status);"; MySqlParameter[] parameters = { new MySqlParameter("?user_id", MySqlDbType.Int32), new MySqlParameter("?restaurant_id", MySqlDbType.Int32), new MySqlParameter("?service_type", MySqlDbType.Int32), new MySqlParameter("?time", MySqlDbType.VarChar,32), new MySqlParameter("?status", MySqlDbType.Int32) }; parameters[0].Value = service.user_id; parameters[1].Value = service.restaurant_id; parameters[2].Value = service.service_type; parameters[3].Value = service.ctime; parameters[4].Value = service.status; //通过MySqlCommand的ExecuteReader()方法构造DataReader对象 int count = MySqlHelper.ExecuteNonQuery(mysql, parameters); if (count > 0) { return true; } else { return false; } }
public List<ServiceEntity> getAllServiceByRestaurantId(int restaurantId) { string mysql = "SELECT `id`,`user_id`,`restaurant_id`,`service_type`,`ctime` FROM `yumi_service` WHERE `restaurant_id` =?restaurantId"; MySqlParameter[] parameters = { new MySqlParameter("?restaurantId", MySqlDbType.Int32) }; parameters[0].Value = restaurantId; MySqlDataReader myreader = MySqlHelper.ExecuteReader(mysql, parameters); List<ServiceEntity> list = new List<ServiceEntity>(); while (myreader.Read()) { ServiceEntity service = new ServiceEntity(); service.id = myreader.GetInt32(0); service.user_id = myreader.GetInt32(1); service.restaurant_id = myreader.GetInt32(2); service.service_type = myreader.GetInt32(3); service.ctime = myreader.GetString(4); list.Add(service); } myreader.Close(); for (int i = 0; i < list.Count;i++ ) { string mysql2 = "SELECT `service_name` FROM `yumi_service_type` WHERE `service_id` =?serviceId"; MySqlParameter[] parameters2 = { new MySqlParameter("?serviceId", MySqlDbType.Int32) }; parameters2[0].Value = list[i].service_type; MySqlDataReader myreader2 = MySqlHelper.ExecuteReader(mysql2, parameters2); while (myreader2.Read()) { list[i].service_name = myreader2.GetString(0); } myreader2.Close(); } myreader.Close(); return list; }