public string Register(string name, string password, string tel, string select)
{
string msg = string.Empty;
bool result = false;
try
{
using (db_EnglishClassEntities db = new db_EnglishClassEntities())
{
tb_User user = new tb_User();
user.User_Name = name;
user.User_PWD = password;
user.Tel = tel;
user.State = select;
db.tb_User.Add(user);
db.SaveChanges();
if (user.State == "0")
{
tb_Plant plant = new tb_Plant();
plant.UID = user.UID;
plant.State = "0";
db.tb_Plant.Add(plant);
db.SaveChanges();
}
result = true;
}
}
catch (Exception e)
{
result = false;
msg = e.Message;
}
return("{\"result\":\"" + result + "\",\"Msg\":\"" + msg + "\"}");
}
public void Delete(int pid)
{
tb_Plant user = db.tb_Plant.Find(pid);
db.tb_Plant.Remove(user);
//user.State = "1";
//db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
public string AddorUpdatePlant(int nums, int days)
{
int UID = int.Parse(Request.Cookies["UID"].Value);
string msg = string.Empty;
int result = 0;
var user = (tb_Plant)db.tb_Plant.Where(x => x.UID == UID && x.State == "0").FirstOrDefault();
if (user == null)
{
tb_Plant plant = new tb_Plant();
plant.State = "0";
plant.UID = UID;
plant.Days = days;
plant.Nums = nums;
plant.CreateTime = DateTime.Now;
db.tb_Plant.Add(plant);
db.SaveChanges();
}
else
{
user.Days = days;
user.Nums = nums;
db.Entry(user).State = EntityState.Modified;
}
// user.CreateTime = DateTime.Now;
try
{
db.SaveChanges();
result = 1;
}
catch (Exception ex)
{
msg = ex.Message;
}
return("{\"result\":\"" + result + "\",\"Msg\":\"" + msg + "\"}");
}
