public string AddChefActivity(dynamic requestData)
{
try
{
string query = JsonConvert.SerializeObject(requestData);
ChefActivity model = JsonConvert.DeserializeObject <ChefActivity>(query);
#region 每次新增确保只有一个是进行状态
if (model.IsEnable == 1)
{
var qchefActivity = (from v in db.ChefActivity
where v.IsEnable == 1
select v).FirstOrDefault();
if (qchefActivity != null)
{
if (qchefActivity.IsEnable == 1)
{
qchefActivity.IsEnable = 0;
db.SaveChanges();
}
}
}
#endregion
model.CreateTime = DateTime.Now;
model.UpdateTime = DateTime.Now;
model.IsDel = 1;
db.ChefActivity.Add(model);
db.SaveChanges();
return("OK");
}
catch (Exception e)
{
return(e.Message);
}
}
public string UpdateIsEnable(dynamic requestDate)
{
try
{
var qchefActivity = (from v in db.ChefActivity
where v.IsEnable == 1
select v).FirstOrDefault();
if (qchefActivity != null)
{
if (qchefActivity.IsEnable == 1)
{
if (qchefActivity != null)
{
qchefActivity.IsEnable = 0;
db.Entry <ChefActivity>(qchefActivity).State = EntityState.Modified;
db.SaveChanges();
}
}
}
ChefActivity chefActivity = new ChefActivity();
chefActivity.ChefActivityId = requestDate.ChefActivityId;
chefActivity.ChefActivityName = requestDate.ChefActivityName;
chefActivity.IsEnable = requestDate.IsEnable;
chefActivity.UpdatePerson = requestDate.UpdatePerson;
chefActivity.UpdateTime = DateTime.Now;
//db.Entry<ChefActivity>(chefActivity).State = EntityState.Modified;
//db.Entry<ChefActivity>(chefActivity).Property("CreatePerson").IsModified = false;
//db.Entry<ChefActivity>(chefActivity).Property("CreateTime").IsModified = false;
//db.SaveChanges();
var sql = string.Format(@"update ChefActivity set ChefActivityName='{0}',IsEnable={1},UpdatePerson='{2}',UpdateTime='{3}' where ChefActivityId={4}", chefActivity.ChefActivityName, chefActivity.IsEnable, chefActivity.UpdatePerson, chefActivity.UpdateTime, chefActivity.ChefActivityId);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
return("OK");
}
catch (Exception e)
{
return("No");
}
}
