public string UpdateMySelfDish(dynamic requestData)
{
try
{
#region 修改基本菜品信息
MySelfDishKu mySelfDishKu = JsonConvert.DeserializeObject <MySelfDishKu>(JsonConvert.SerializeObject(requestData.MySelfDishKu));
var sqlMySelfDishKu = string.Format(@"Update [dbo].[MySelfDishKu] set [DishStory]='{0}', [DishPicUrl]='{1}' , [DishName]='{2}', [UpateTime]='{3}', [IsApply]=0 where MySelfDishId={4}", mySelfDishKu.DishStory, mySelfDishKu.DishPicUrl, mySelfDishKu.DishName, DateTime.Now, mySelfDishKu.MySelfDishId);
dataContext.ExecuteNonQuery(CommandType.Text, sqlMySelfDishKu);
#endregion
#region 修改菜品调料
var middleDishMaterial = requestData.DishMaterial;
List <DishMaterial> addDishMaterial = new List <DishMaterial>();
for (int i = 0; i < middleDishMaterial.Count; i++)
{
addDishMaterial.Add(JsonConvert.DeserializeObject <DishMaterial>(JsonConvert.SerializeObject(middleDishMaterial[i])));
}
//删除原来调料
string deleteDishMaterial = string.Format(@"DELETE FROM [dbo].[DishMaterial] where DishId={0}", mySelfDishKu.MySelfDishId);
dataContext.ExecuteNonQuery(CommandType.Text, deleteDishMaterial);
for (int i = 0; i < addDishMaterial.Count; i++)
{
string insert = string.Format(@"INSERT INTO [dbo].[DishMaterial] ([DishId]
,[Material] ,[Unit],[MaterialType] ,[CreateTime]) VALUES ({0} ,'{1}' ,'{2}' ,{3} ,'{4}' ) ", mySelfDishKu.MySelfDishId, addDishMaterial[i].Material, addDishMaterial[i].Unit, addDishMaterial[i].MaterialType, addDishMaterial[i].CreateTime);
dataContext.ExecuteNonQuery(CommandType.Text, insert);
}
#endregion
#region 修改推荐调料
var middleMySelfFRRole = requestData.MySelfFRRole;
List <MySelfFRRole> addMySelfFRRole = new List <MySelfFRRole>();
for (int i = 0; i < middleMySelfFRRole.Count; i++)
{
addMySelfFRRole.Add(JsonConvert.DeserializeObject <MySelfFRRole>(JsonConvert.SerializeObject(middleMySelfFRRole[i])));
}
//删除原来调料
string deleteMySelfFRRole = string.Format(@"DELETE FROM [dbo].[MySelfFRRole] where MySelfDishKuId={0}", mySelfDishKu.MySelfDishId);
dataContext.ExecuteNonQuery(CommandType.Text, deleteMySelfFRRole);
for (int i = 0; i < addMySelfFRRole.Count; i++)
{
string insert = string.Format(@"INSERT INTO [dbo].[MySelfFRRole] ([MemberId]
,[MySelfDishKuId] ,[MySelfFRId],[Unit],[CreateTime]) VALUES ({0} ,'{1}' ,'{2}' ,{3} ,'{4}' ) ", addMySelfFRRole[i].MemberId, mySelfDishKu.MySelfDishId, addMySelfFRRole[i].MySelfFRId, addMySelfFRRole[i].Unit, addMySelfFRRole[i].CreateTime);
dataContext.ExecuteNonQuery(CommandType.Text, insert);
}
#endregion
#region 修改菜品步骤
var middleDishStep = requestData.DishStep;
List <DishStep> addDishStep = new List <DishStep>();
for (int i = 0; i < middleDishStep.Count; i++)
{
addDishStep.Add(JsonConvert.DeserializeObject <DishStep>(JsonConvert.SerializeObject(middleDishStep[i])));
}
//删除
string deleteDishStep = string.Format(@"DELETE FROM [dbo].[DishStep] where DishId={0}", mySelfDishKu.MySelfDishId);
dataContext.ExecuteNonQuery(CommandType.Text, deleteDishStep);
for (int i = 0; i < addDishStep.Count; i++)
{
string insert = string.Format("INSERT INTO DishStep (DishId,StepId,StepName,CreateTime) VALUES ({0} ,{1} ,'{2}' ,'{3}' ) ", mySelfDishKu.MySelfDishId, i + 1, addDishStep[i].StepName, addDishStep[i].CreateTime);
dataContext.ExecuteNonQuery(CommandType.Text, insert);
}
#endregion
return("OK");
}
catch (Exception)
{
return("No");
}
}
public string AddDish(dynamic requestData)
{
lock (olock)
{
try
{
MySelfDishKu mySelfDishKu = JsonConvert.DeserializeObject <MySelfDishKu>(JsonConvert.SerializeObject(requestData.MySelfDishKu));
var middleRole = requestData.MySelfFRRole;
List <MySelfFRRole> addRole = new List <MySelfFRRole>();
for (int i = 0; i < middleRole.Count; i++)
{
addRole.Add(JsonConvert.DeserializeObject <MySelfFRRole>(JsonConvert.SerializeObject(middleRole[i])));
}
#region 判断个人菜品库能添加多少道菜品,确定菜品DishType编号
int mysele = addRole[0].MySelfFRId;
int memberId = addRole[0].MemberId;
var qRole = (from v in db.MySelfFR
where v.MySelfFRId == mysele
select v).FirstOrDefault();
var qMySelfDishKu = (from v in db.MySelfDishKu
where v.CreateTime <qRole.EndTime && v.CreateTime> qRole.BeginTime && v.MemberId == memberId
orderby v.DishType descending
select v).FirstOrDefault();
if (qMySelfDishKu == null)
{
mySelfDishKu.DishType = 1;
}
else
{
int FRCount = qRole.FRCount;
int type = qMySelfDishKu.DishType;
if (type < FRCount)
{
type = type + 1;
mySelfDishKu.DishType = type;
}
else
{
return("本次活动上传菜品机会用完");
}
}
#endregion
#region 增加个人菜品库菜品
mySelfDishKu.CreateTime = DateTime.Now;
mySelfDishKu.UpateTime = DateTime.Now;
mySelfDishKu.ApplyTime = Convert.ToDateTime("1990-01-01");
db.MySelfDishKu.Add(mySelfDishKu);
db.SaveChanges();
#endregion
#region 增加调味信息
var middleDishMaterial = requestData.DishMaterial;
List <DishMaterial> addDishMaterial = JsonConvert.DeserializeObject <List <DishMaterial> >(JsonConvert.SerializeObject(middleDishMaterial));
//for (int i = 0; i < middleDishMaterial.Count; i++)
//{
// addDishMaterial.Add(JsonConvert.DeserializeObject<DishMaterial>(JsonConvert.SerializeObject(middleDishMaterial[i])));
//}
for (int i = 0; i < addDishMaterial.Count; i++)
{
string insert = string.Format(@"INSERT INTO [dbo].[DishMaterial] ([DishId]
,[Material] ,[Unit],[MaterialType] ,[CreateTime]) VALUES ({0} ,'{1}' ,'{2}' ,{3} ,'{4}' ) ", mySelfDishKu.MySelfDishId, addDishMaterial[i].Material, addDishMaterial[i].Unit, addDishMaterial[i].MaterialType, addDishMaterial[i].CreateTime);
dataContext.ExecuteNonQuery(CommandType.Text, insert);
}
#endregion
#region 增加推荐调料
var middleMySelfFRRole = requestData.MySelfFRRole;
List <MySelfFRRole> addMySelfFRRole = JsonConvert.DeserializeObject <List <MySelfFRRole> >(JsonConvert.SerializeObject(middleMySelfFRRole));
//for (int i = 0; i < middleMySelfFRRole.Count; i++)
//{
// addMySelfFRRole.Add(JsonConvert.DeserializeObject<MySelfFRRole>(JsonConvert.SerializeObject(middleMySelfFRRole[i])));
//}
for (int i = 0; i < addMySelfFRRole.Count; i++)
{
string insert = string.Format(@"INSERT INTO [dbo].[MySelfFRRole] ([MemberId]
,[MySelfDishKuId] ,[MySelfFRId],[Unit],[CreateTime]) VALUES ({0} ,'{1}' ,'{2}' ,{3} ,'{4}' ) ", addMySelfFRRole[i].MemberId, mySelfDishKu.MySelfDishId, addMySelfFRRole[i].MySelfFRId, addMySelfFRRole[i].Unit, addMySelfFRRole[i].CreateTime);
dataContext.ExecuteNonQuery(CommandType.Text, insert);
}
#endregion
#region 增加做菜步骤
var middleDishStep = requestData.DishStep;
List <DishStep> addDishStep = JsonConvert.DeserializeObject <List <DishStep> >(JsonConvert.SerializeObject(middleDishStep));
//for (int i = 0; i < middleDishStep.Count; i++)
//{
// addDishStep.Add(JsonConvert.DeserializeObject<DishStep>(JsonConvert.SerializeObject(middleDishStep[i])));
//}
for (int i = 0; i < addDishStep.Count; i++)
{
string insert = string.Format("INSERT INTO DishStep (DishId,StepId,StepName,CreateTime) VALUES ({0} ,{1} ,'{2}' ,'{3}' ) ", mySelfDishKu.MySelfDishId, i + 1, addDishStep[i].StepName, addDishStep[i].CreateTime);
dataContext.ExecuteNonQuery(CommandType.Text, insert);
}
#endregion
return("OK");
}
catch (Exception)
{
return("No");
}
}
}
