public string DelDishCollectLog(dynamic requestData) { try { var q = JsonConvert.SerializeObject(requestData); DishCollectLog m = JsonConvert.DeserializeObject <DishCollectLog>(q); var sql = string.Format("DELETE from DishCollectLog where OpenId='{0}' and DishId={1} and DishType={2}", m.OpenId, m.DishId, m.DishType); dataContext.ExecuteNonQuery(CommandType.Text, sql); return("OK"); } catch (Exception) { return("No"); } }
public string GetDishCollectState(dynamic requestData) { try { DishCollectLog m = JsonConvert.DeserializeObject <DishCollectLog>(JsonConvert.SerializeObject(requestData)); var q = (from v in db.DishCollectLog where v.OpenId == m.OpenId && v.DishId == m.DishId select v).FirstOrDefault(); var isCollect = "f"; if (q != null) { isCollect = "t"; } return("{\"IsCollect\":\"" + isCollect + "\"}"); } catch (Exception) { return("{\"IsCollect\":\"f\"}"); } }
public string AddDishCollectLog(dynamic requestData) { try { var q = JsonConvert.SerializeObject(requestData); DishCollectLog m = JsonConvert.DeserializeObject <DishCollectLog>(q); var d = (from v in db.DishCollectLog where v.OpenId == m.OpenId && v.DishId == m.DishId select v).FirstOrDefault(); if (d == null) { db.DishCollectLog.Add(m); db.SaveChanges(); } return("OK"); } catch (Exception) { return("No"); } }