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