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;
}