public string AddDishVisitLog(dynamic requestData)
{
try
{
DishVisitLog m = JsonConvert.DeserializeObject <DishVisitLog>(JsonConvert.SerializeObject(requestData));
var q = (from v in db.MySelfDishKu
where v.MySelfDishId == m.DishId
select v).FirstOrDefault();
m.DishType = q.DishType;
db.DishVisitLog.Add(m);
db.SaveChanges();
var sql = string.Format(@"update MySelfDishKu set VisitCount=VisitCount+1 where MySelfDishId={0}", m.DishId);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
var sqlCount = string.Format(@"SELECT [MySelfDishId],[VisitCount] FROM [MySelfDishKu] where [MySelfDishId]={0}", m.DishId);
var qVisitCount = dataContext.ExecuteDataTable(CommandType.Text, sqlCount);
return(JsonConvert.SerializeObject(qVisitCount));
}
catch (Exception)
{
return("No");
}
}
public string GetDishChefStar(dynamic requestData)
{
try
{
//首先增加看过统计
var q = JsonConvert.SerializeObject(requestData);
DishVisitLog m = JsonConvert.DeserializeObject <DishVisitLog>(q);
db.DishVisitLog.Add(m);
db.SaveChanges();
var sql = string.Format(@"update DishChefStar set VisitCount=VisitCount+1 where DishChefStarId={0}", m.DishId);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
//菜品基本信息
var dishType = (from v in db.DishChefStar
where v.DishChefStarId == m.DishId
select new
{
DishChefStarId = v.DishChefStarId,
DishTyPe = v.DishType,
ChefStarId = v.ChefStarId,
DishPicUrl = v.DishPicUrl,
DishName = v.DishName,
//点赞数
PrasieCount = v.PrasieCount,
VisitCount = v.VisitCount,
DishStory = v.DishStory
}).FirstOrDefault();
//菜品调料信息
var dishType1DishMateria = (from v in db.DishMaterial
where v.DishId == dishType.DishChefStarId
select new
{
DishId = v.DishId,
Material = v.Material,
Unit = v.Unit,
MaterialType = v.MaterialType
});
//菜品步骤信息
var dishType1DishStep = (from v in db.DishStep
where v.DishId == dishType.DishChefStarId
select new
{
DishId = v.DishId,
StepId = v.StepId,
StepName = v.StepName
});
//菜品推荐调料信息
var sqlSelect = string.Format(@"select FR.FlavourName,FR.FlavourPicUrl,FR.FlavourType,FR.FlavourRecId from FlavourRec as FR join FlavourRecRole FRR on FR.FlavourRecId=FRR.FlavourRecId where FRR.RoleId={0} and FRR.DishId={1}", dishType.ChefStarId, dishType.DishChefStarId);
var select = dataContext.ExecuteDataTable(CommandType.Text, sqlSelect);
//是否点赞过
var Parse = (from v in db.DishPrasieLog
where v.OpenId == m.OpenId && v.DishId == dishType.DishChefStarId
select v).FirstOrDefault();
var IsPrasie = "f";
if (Parse != null)
{
IsPrasie = "t";
}
////是否投票
//var Selected = (from v in db.DishSelectedLog
// where v.OpenId == m.OpenId && v.DishId == m.DishId
// select v).FirstOrDefault();
//var IsSelected = "f";
//if (Selected != null)
// IsSelected = "t";
//菜品是否收藏
var isDishChefColle = (from v in db.DishCollectLog
where v.DishId == m.DishId && v.OpenId == m.OpenId
select v).FirstOrDefault();
var isCollect = "f";
if (isDishChefColle != null)
{
isCollect = "t";
}
return("{\"dishInfo\":" + JsonConvert.SerializeObject(dishType) + ",\"dishType1DishMateria\":" + JsonConvert.SerializeObject(dishType1DishMateria) + ",\"dishType1DishStep\":" + JsonConvert.SerializeObject(dishType1DishStep) + ",\"select\":" + JsonConvert.SerializeObject(select) + ",\"IsPrasie\":\"" + IsPrasie + "\",\"IsCollect\":\"" + isCollect + "\"}");
}
catch (Exception)
{
return("No");
}
}
public string GetDishTutorDetail(dynamic requestData)
{
try
{
#region 增加导师看过数量
var q = JsonConvert.SerializeObject(requestData);
DishVisitLog m = JsonConvert.DeserializeObject <DishVisitLog>(q);
db.DishVisitLog.Add(m);
db.SaveChanges();
var sql = string.Format(@"update DishTutor set VisitCount=VisitCount+1 where TutorDishId={0}", m.DishId);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
#endregion
//导师基本信息
var qdishTutor = (from v in db.DishTutor
where v.TutorDishId == m.DishId
select new
{
TutorDishId = v.TutorDishId,
TutorId = v.TutorId,
DishStory = v.DishStory,
DishPic = v.DishPicUrl,
DishName = v.DishName,
VisitCount = v.VisitCount,
PrasieCount = v.PrasieCount
}).FirstOrDefault();
//菜品调料
var qdishMaterial = (from v in db.DishMaterial
where v.DishId == m.DishId
select new {
Material = v.Material,
Unit = v.Unit,
MaterialType = v.MaterialType
});
var qdishStep = (from v in db.DishStep
where v.DishId == m.DishId
select new
{
Step = v.StepId,
StepName = v.StepName
});
var sqlflavourRec = string.Format(@"select FlavourName,FlavourPicUrl from FlavourRec where FlavourRecId in(select FlavourRecId from FlavourRecRole where DishId={0})", m.DishId);
var qflavourRec = dataContext.ExecuteDataTable(CommandType.Text, sqlflavourRec);
var sqlDishPrasieLog = string.Format(@"select count(Id) as count from DishPrasieLog where DishId={0} and OpenId='{1}' and DishType={2}", m.DishId, m.OpenId, m.DishType);
var qDishPrasieLog = dataContext.ExecuteDataTable(CommandType.Text, sqlDishPrasieLog);
//var d = qDishPrasieLog.Rows[0]["count"];
//是否点赞
string flagPrasie = "f";
if (Convert.ToInt32(qDishPrasieLog.Rows[0]["count"]) > 0)
{
flagPrasie = "t";
}
//菜品是否收藏
var isDishChefColle = (from v in db.DishCollectLog
where v.DishId == m.DishId && v.OpenId == m.OpenId
select v).FirstOrDefault();
var isCollect = "f";
if (isDishChefColle != null)
{
isCollect = "t";
}
return("{\"dishTutor\":" + JsonConvert.SerializeObject(qdishTutor) + ",\"dishMaterial\":" + JsonConvert.SerializeObject(qdishMaterial) + ",\"dishStep\":" + JsonConvert.SerializeObject(qdishStep) + ",\"flavourRec\":" + JsonConvert.SerializeObject(qflavourRec) + ",\"flagPrasie\":\"" + flagPrasie + "\",\"IsCollect\":\"" + isCollect + "\"}");
}
catch (Exception)
{
return("No");
}
}
