/// <summary>
/// 删除用户
/// </summary>
/// <param name="usernameId"></param>
/// <returns></returns>
public ActionResult DeleteUsername(int usernameId)
{
//定义返回
string strMsg = "fail";
try
{
B_UsernameList dbPurchase = (from tbGoods in MyModels.B_UsernameList
where tbGoods.usernameID == usernameId
select tbGoods).Single();
MyModels.B_UsernameList.Remove(dbPurchase);
if (MyModels.SaveChanges() > 0)
{
strMsg = "success";
S_JournalList pwJournalList = new S_JournalList();
pwJournalList.usernameID = Convert.ToInt32(Session["usernameID"]);
pwJournalList.Operate = "删除用户";
pwJournalList.OperateDate = DateTime.Now;
MyModels.S_JournalList.Add(pwJournalList);
MyModels.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增用户
/// </summary>
/// <returns></returns>
public ActionResult AddUserMessage(B_UsernameList tbold)
{
string strMsg = "fali";
int userID = tbold.usernameID;
var dbUser = MyModels.B_UsernameList.Where(p => p.usernameID == userID).ToList();
try
{
int oldstring = (from tb in MyModels.B_UsernameList
where tb.username == tbold.username
select tb).Count();
if (oldstring == 0)
{
B_UsernameList KK = new B_UsernameList();
KK.username = Request.Form["username"];
KK.name = Request.Form["name"];
KK.password = Common.AESEncryptHelper.Encrypt(Request.Form["UniformAuthenticationCode"]);
KK.UniformAuthenticationCode = Request.Form["UniformAuthenticationCode"];
//KK.IDnumber = Common.AESEncryptHelper.Encrypt(Request.Form["IDnumber"]);
KK.IDnumber = Request.Form["IDnumber"];
KK.location = Request.Form["location"];
KK.phonenumber = Request.Form["phonenumber"];
KK.postbox = Request.Form["postbox"];
KK.UserroleID = Convert.ToInt32(Request.Form["UserroleID"]);
KK.DepartmenttypeID = Convert.ToInt32(Request.Form["DepartmenttypeID"]);
KK.BaseDetailID = Convert.ToInt32(Request.Form["BaseDetailID"]);
KK.remarks = Request.Form["remarks"];
KK.USERReviewNo = Convert.ToBoolean(Request.Form["USERReviewNo"]);
if (KK.username != null && KK.name != null && KK.UniformAuthenticationCode != null && KK.IDnumber != null && KK.location != null &&
KK.phonenumber != null && KK.postbox != null && KK.UserroleID != null && KK.DepartmenttypeID != null && KK.BaseDetailID != null)
{
MyModels.B_UsernameList.Add(KK);
//MyModels.SaveChanges();
S_JournalList pwJournalList = new S_JournalList();
pwJournalList.usernameID = Convert.ToInt32(Session["usernameID"]);
pwJournalList.Operate = "新增用户";
pwJournalList.OperateDate = DateTime.Now;
MyModels.S_JournalList.Add(pwJournalList);
MyModels.SaveChanges();
}
strMsg = "success";
}
}
catch (Exception e)
{
Console.WriteLine(e);
strMsg = "exsit";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改保存
/// </summary>
/// <param name="tbold"></param>
/// <returns></returns>
public ActionResult UpdatePreserve(B_UsernameList tbold)
{
string strMsg = "fali";
int userID = tbold.usernameID;
var dbUser = MyModels.B_UsernameList.Where(p => p.usernameID == userID).ToList();
try
{
if (tbold.usernameID > 0)
{
B_UsernameList KK = MyModels.B_UsernameList.Where(p => p.usernameID == userID).Single();
KK.usernameID = userID;
KK.username = Request.Form["username"];
KK.name = Request.Form["name"];
//KK.password = Common.AESEncryptHelper.Encrypt(Request.Form["password"]);
KK.UniformAuthenticationCode = Request.Form["UniformAuthenticationCode"];
//KK.IDnumber = Common.AESEncryptHelper.Encrypt(Request.Form["IDnumber"]);
KK.IDnumber = Request.Form["IDnumber"];
KK.location = Request.Form["location"];
KK.phonenumber = Request.Form["phonenumber"];
KK.postbox = Request.Form["postbox"];
KK.UserroleID = Convert.ToInt32(Request.Form["UserroleID"]);
KK.DepartmenttypeID = Convert.ToInt32(Request.Form["DepartmenttypeID"]);
KK.BaseDetailID = Convert.ToInt32(Request.Form["BaseDetailID"]);
KK.remarks = Request.Form["remarks"];
KK.USERReviewNo = tbold.USERReviewNo;
MyModels.Entry(KK).State = System.Data.Entity.EntityState.Modified;
MyModels.SaveChanges();
S_JournalList pwJournalList = new S_JournalList();
pwJournalList.usernameID = Convert.ToInt32(Session["usernameID"]);
pwJournalList.Operate = "修改用户";
pwJournalList.OperateDate = DateTime.Now;
MyModels.S_JournalList.Add(pwJournalList);
MyModels.SaveChanges();
}
strMsg = "success";
}
catch (Exception e)
{
Console.WriteLine(e);
strMsg = "exsit";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
