/// <summary>
/// 绑定用户数据
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult GetBindDetails(int ID)
{
using (EasyUIDemoDBEntities db = new EasyUIDemoDBEntities())
{
var BindIDForUpdateTextBox = db.UserInfo.Where(u => u.ID == ID).FirstOrDefault();
return(Json(BindIDForUpdateTextBox, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="userinfo"></param>
/// <returns></returns>
public ActionResult AddUser(UserInfo userinfo)
{
userinfo.CreateTime = DateTime.Now;
using (EasyUIDemoDBEntities db = new EasyUIDemoDBEntities())
{
db.UserInfo.Add(userinfo);
db.SaveChanges();
}
return(Content("OK"));
}
/// <summary>
/// 获取用户的所有信息
/// </summary>
/// <returns></returns>
public ActionResult GetAllUserInfo()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int total = 0;
using (EasyUIDemoDBEntities db = new EasyUIDemoDBEntities())
{
var temp = from u in db.UserInfo select u;
total = temp.Count();
var users = temp.OrderByDescending(s => s.ID)
.Skip <UserInfo>((pageIndex - 1) * pageSize).Take <UserInfo>(pageSize);
var data = new
{
total = total,
rows = users.ToList <UserInfo>()
};
return(Json(data));
}
}
/// <summary>
/// 处理登录的信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public JsonResult CheckUserLogin(UserInfo userInfo)
{
using (EasyUIDemoDBEntities db = new EasyUIDemoDBEntities())
{
//linq查询
var users = from p in db.UserInfo
where p.Name == userInfo.Name && p.Password == userInfo.Password && p.Enable == true
select p;
if (users.Count() > 0)
{
userInfo = users.FirstOrDefault();
Response.Cookies["UserName"].Value = userInfo.Name;
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(7);
return(Json(new { result = "success", content = "" }));
}
else
{
return(Json(new { result = "error", content = "用户名密码错误，请您检查" }));
}
}
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="deleteUserInfoID"></param>
/// <returns></returns>
public ActionResult DeleteUser(string deleteUserInfoID, string Name)
{
var UIdsName = Name.Split(',');
List <string> deleteUName = new List <string>();
foreach (var item in UIdsName)
{
deleteUName.Add(item);
}
if (deleteUName.Contains(Session["UserName"].ToString()))
{
return(Content("含有正在使用的用户，禁止删除"));
}
if (string.IsNullOrEmpty(deleteUserInfoID))
{
return(Content("请选择您要删除的数据"));
}
var idsStr = deleteUserInfoID.Split(',');
List <int> deleteIDList = new List <int>();
foreach (var ID in idsStr)
{
deleteIDList.Add(Convert.ToInt32(ID));
}
using (EasyUIDemoDBEntities db = new EasyUIDemoDBEntities())
{
foreach (var ID in deleteIDList)
{
var users = db.UserInfo.Where(p => p.ID == ID).FirstOrDefault();
db.UserInfo.Remove(users);
}
db.SaveChanges();
}
return(Content("OK"));
}
