/// <summary>
/// 验证输入的用户信息是否正常
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
private string ValidInput(sysuser user)
{
string msg = string.Empty;
if (string.IsNullOrEmpty(user.userno))
{
msg += "请输入用户编号<br />";
}
if (string.IsNullOrEmpty(user.username))
{
msg += "请输入用户姓名<br />";
}
if (string.IsNullOrEmpty(user.xingbie))
{
msg += "请选择用户性别<br />";
}
if (string.IsNullOrEmpty(user.shenfhm))
{
msg += "请输入身份号码<br />";
}
if (string.IsNullOrEmpty(user.isvalid))
{
msg += "请选择是否有效<br />";
}
return(msg);
}
public ActionResult Login(string username, string password)
{
if (string.IsNullOrEmpty(username))
{
ModelState.AddModelError("username", "请输入用户名");
return(View());
}
if (string.IsNullOrEmpty(password))
{
ModelState.AddModelError("password", "请输入密码");
return(View());
}
AuthBll bll = new AuthBll();
sysuser usr = bll.Login(username, password);
if (usr == null)
{
ModelState.Clear();
ModelState.AddModelError("error", "用户名密码不正确");
return(View());
}
else
{
base.UserInfo = usr;
return(RedirectToAction("Index", "Login", new { Area = "Auth" }));
}
}
public JsonResult Password(string userno, string repeatpassword, string newpassword)
{
OperateResultModel orm = new OperateResultModel();
try
{
if (string.IsNullOrEmpty(repeatpassword) || string.IsNullOrEmpty(newpassword))
{
throw new Exception("密码不能为空");
}
if (repeatpassword != newpassword)
{
throw new Exception("两次密码输入不一致");
}
Permission permission = new Permission();
sysuser user = new sysuser()
{
userno = userno,
password = newpassword,
editer = SessionUser.UserNo,
editdate = DateTime.Now
};
orm = permission.UpdateUser(user);
}
catch (Exception ex)
{
orm.message = ex.Message;
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
protected virtual void DeletePerson(string id)
{
lock (lockObj) {
var persons = this.CurrentData;
sysuser person = null;
foreach (sysuser p in persons)
{
if (p.id == id)
{
person = p;
break;
}
}
if (person == null)
{
throw new Exception("sysuser not found");
}
persons.Remove(person);
Global.SqlMapper.DeleteByKey <sysuser>(person.id);
this.Session["sysusers"] = persons;
}
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
var noAuthorizeAttributes = filterContext.ActionDescriptor.GetCustomAttributes(typeof(AllowAnonymousAttribute), false);
if (noAuthorizeAttributes.Length > 0)
{
base.OnActionExecuting(filterContext);
return;
}
//没有登录
sysuser usr = UserInfo;
if (usr == null)
{
filterContext.Result = RedirectToAction("Login", "Login", new { Area = "Auth" });
return;
}
////页面权限
////MenuHepler.List.MenuGroups.AsParallel().ForAll((p) =>
//foreach (var p in MenuHepler.List.MenuGroups)
//{
// var file = ((filterContext.RequestContext.HttpContext).Request).FilePath;
// if (p.MenuArray.Any(a => a.Url.Contains(file) && !a.Permission.Contains("," + usr.Positionid + ",")))
// {
// filterContext.Result = RedirectToAction("ErrorA", "Account", new { Area = "Auth" });
// return;
// }
//}
////);
base.OnActionExecuting(filterContext);
}
public JsonResult Add(sysuser user)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(user);
if (string.IsNullOrEmpty(orm.message))
{
UserModel um = SessionUser;
user.password = "******";
DateTime dtnow = DateTime.Now;
user.createdate = dtnow;
user.creater = um.UserNo;
user.editdate = dtnow;
user.editer = um.UserNo;
Permission permission = new Permission();
orm = permission.InsertUser(user);
orm.rows = user;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public int DeleteUser(List <string> ids)
{
using (var db = new BFdbContext())
{
int res = 0;
using (var tx = db.BeginTransaction())
{
try
{
foreach (string id in ids)
{
sysuser ent = db.sysuser.FirstOrDefault(p => p.Userid == id);
ent.Delflag = true;
db.TUpdate <sysuser>(ent);
}
db.SaveChanges();
tx.Commit();
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
return(res);
}
}
public PartialViewResult Password(string userno)
{
Permission permission = new Permission();
sysuser user = permission.QueryUser(userno);
return(PartialView(user));
}
private void btn_AddUser_Click(object sender, EventArgs e)
{
for (int n = 0; n <= 10; n++)
{
sysuser user = new sysuser();
user.name = "aa" + AdobeUtil.RandomNumber();
Mydb.Insert(user);
}
}
public PartialViewResult Edit(string userno)
{
sysuser user = null;
if (!string.IsNullOrEmpty(userno))
{
Permission permission = new Permission();
user = permission.QueryUser(userno);
}
return(PartialView(user));
}
protected virtual string AddPerson(sysuser person)
{
lock (lockObj) {
var persons = this.CurrentData;
person.id = person.CreateID();
persons.Add(person);
this.Session["sysusers"] = persons;
Global.SqlMapper.Create <sysuser>(person);
return(person.id);
}
}
//
// GET: /main/User/Create
public ActionResult Create()
{
var model = new sysuser();
model.Password = "******";
var bll = new UserBll();
Init(bll);
return(View(model));
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public int AddUser(sysuser ent)
{
using (var db = new BFdbContext())
{
if (db.sysuser.Any(u => u.Username == ent.Username))
{
throw new ValidException("Username", "已存在此名称的用户！");
}
ent.Delflag = false;
ent.Createddate = DateTime.Now;
ent.Modifydate = DateTime.Now;
return(db.Insert <sysuser>(ent));
}
}
/// <summary>
/// 方法名称: Insert
/// 内容摘要: 插入一条新纪录
/// </summary>
/// <returns>int</returns>
public virtual object Insert(sysuser obj)
{
object result = null;
try
{
result = _sysuserDao.Create <sysuser>(obj);
}
catch (Exception e)
{
throw e;
}
return(result);
}
/// <summary>
/// 方法名称: Update
/// 内容摘要: 更新一条新纪录
/// </summary>
/// <returns>int</returns>
public virtual int Update(sysuser obj)
{
int result = 0;
try
{
result = _sysuserDao.Update <sysuser>(obj);
}
catch (Exception e)
{
throw e;
}
return(result);
}
/// <summary>
/// 更新用户新
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public int EditUser(sysuser ent)
{
using (var db = new BFdbContext())
{
if (db.sysuser.Any(u => u.Username == ent.Username && u.Userid != ent.Userid))
{
throw new ValidException("Username", "已存在此名称的用户！");
}
sysuser usr = db.sysuser.FirstOrDefault(p => p.Userid == ent.Userid);
usr.Email = ent.Email;
usr.Password = ent.Password;
usr.Delflag = ent.Delflag;
usr.Username = ent.Username;
usr.Modifydate = DateTime.Now;
return(db.Update <sysuser>(usr));
}
}
public JsonResult Update(sysuser user)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(user);
if (string.IsNullOrEmpty(orm.message))
{
user.editdate = DateTime.Now;
user.editer = SessionUser.UserNo;
Permission permission = new Permission();
orm = permission.UpdateUser(user);
orm.rows = user;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public ActionResult Create(FormCollection collection)
{
var model = new sysuser();
this.TryUpdateModel <sysuser>(model);
var bll = new UserBll();
try
{
bll.AddUser(model);
}
catch (ValidException ex)
{
this.ModelState.AddModelError(ex.Name, ex.Message);
return(View(model));
}
return(this.RefreshParent());
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public sysuser Login(string name, string pwd)
{
using (BFdbContext db = new BFdbContext())
{
IEnumerable <sysuser> users = db.FindAll <sysuser>(p => p.Logincode == name && p.Password == pwd && p.Delflag == false);
if (users.Count() < 1)
{
return(null);
}
else
{
sysuser usr = users.First();
usr.Lastlogindate = DateTime.Now;
usr.Logincount = usr.Logincount.GetValueOrDefault(0) + 1;
db.Update <sysuser>(usr);
return(usr);
}
}
}
public ActionResult ModifyPwd(sysuser model)
{
if (model.NewPassword == model.Password)
{
ModelState.AddModelError("NewPassword", "新密码与旧密码一致，修改失败");
return(View(model));
}
if (model.NewPassword != model.ConfirmPassword)
{
ModelState.AddModelError("ConfirmPassword", "密码输入不一致");
return(View(model));
}
string oldpwd = model.Password;
string newpwd = model.NewPassword;
var bll = new UserBll();
model = bll.GetUser(base.UserInfo.Userid);
if (model.Password != oldpwd)
{
ModelState.AddModelError("Password", "旧密码输入错误");
return(View(model));
}
model.Password = newpwd;
try
{
bll.Update <sysuser>(model);
}
catch (ValidException ex)
{
this.ModelState.AddModelError(ex.Name, ex.Message);
return(View(model));
}
return(this.RefreshParent());
}
public JsonResult Index(string userno, string password)
{
userno = userno.ToUpper();
Permission permission = new Permission();
OperateResultModel orm = permission.ValidUser(userno, password);
sysuser user = orm.rows as sysuser;
if (user == null)
{
}
else
{
UserModel um = new UserModel()
{
UserNo = user.userno,
UserName = user.username
};
BaseController bc = new BaseController();
bc.SessionUser = um;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
protected virtual void UpdatePerson(sysuser person)
{
lock (lockObj) {
var persons = this.CurrentData;
sysuser updatingPerson = null;
foreach (sysuser p in persons)
{
if (p.id == person.id)
{
updatingPerson = p;
break;
}
}
if (updatingPerson == null)
{
throw new Exception("sysuser not found");
}
ConvertHelper.CopyTo(person, updatingPerson);
Global.SqlMapper.Update <sysuser>(updatingPerson);
this.Session["sysusers"] = persons;
}
}
public ActionResult ModifyPwd()
{
sysuser usr = new sysuser();
return(View(usr));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="user">用户实体</param>
/// <returns></returns>
public OperateResultModel UpdateUser(sysuser user)
{
SysUserDal dal = new SysUserDal();
return(dal.Update(user));
}
/// <summary>
/// 插入用户信息
/// </summary>
/// <param name="user">用户实体</param>
/// <returns></returns>
public OperateResultModel InsertUser(sysuser user)
{
SysUserDal dal = new SysUserDal();
return(dal.Insert(user));
}
/// <summary>
/// 保存登录信息
/// </summary>
/// <param name="usr"></param>
public static void Add(sysuser usr)
{
HttpContext.Current.Session.Add("pk_sid_user", usr);
}
