图书管理系统-用户增删改查
这篇是基于上篇图书管理的系统用户查询的后续
这篇主要是管理了用户信息的变更
后端代码如下
public JsonResult UserEditOrSubmit(MyCustomer MyCustomers, int Type)
{
Result result = new Result();
try
{
string My_KeyId = MyCustomers.My_KeyId.ToString();
if (!string.IsNullOrEmpty(My_KeyId))
{
MyCustomer ML = db.MyCustomers.Where(a =>a.My_KeyId == MyCustomers.My_KeyId).ToList().SingleOrDefault();
if (Type == 1)
{
if (ML != null && Type == 1)
{
result.Message = "数据已存在请勿重复保存!";
result.Error = 1;
}
else
{
var date = DateTime.Now.ToString("yyyyMMddHHmmss");
MyCustomers.My_Cus_KeyId = Guid.NewGuid();
MyCustomers.My_CusCode = date;
MyCustomers.My_UserPassWard = "123";
MyCustomers.My_UserPowerCode = 1000;
MyCustomers.My_CusSex = 1;
MyCustomers.My_Status = 1;
db.MyCustomers.Add(MyCustomers);
db.SaveChanges();
result.Message = "保存成功!";
result.Error = 0;
}
}
else if (Type == 2 && ML != null)
{
ML.My_CusChiName = MyCustomers.My_CusChiName;
ML.My_UserPhone = MyCustomers.My_UserPhone;
db.Entry<MyCustomer>(ML).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
result.Message = "编辑成功!";
result.Error = 0;
}
else if (Type == 3 && ML != null)
{
ML.My_Status = 2;
db.Entry<MyCustomer>(ML).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
result.Message = "删除成功!";
result.Error = 0;
}
else
{
result.Message = "保存失败!";
result.Error = 1;
}
ML = null;
}
else
{
result.Message = "Id为空,保存失败!";
result.Error = 1;
}
}
catch (Exception e)
{
result.Message = e.Message + e.InnerException;
result.Error = 1;
result = null;
}
return Json(new { DATA1 = result }, JsonRequestBehavior.AllowGet);
}