/// <summary> /// 修改系统外用户 /// </summary> /// <param name="u"></param> public void _UpdUser(DT_UserLoginRecord u) { Tools t = new Tools(); //根据id修改 DT_UserLoginRecord ul = umbll.QueryById(u.Id); ul.RealName = u.RealName; ul.Telphone = u.Telphone; ul.Password = t.GetMd5(u.Password); //ul.IsInner = false; //是否内部成员 是 //ul.RoleId =0; //用户权限 ul.UpdateTime = DateTime.Now; int count = umbll.UpdUser(ul); if (count > 0) { Response.Write("1"); } else { Response.Write("0"); } Response.End(); }
/// <summary> /// 添加系统外用户 /// </summary> /// <param name="u"></param> public void _AddUser(DT_UserLoginRecord u) { Tools t = new Tools(); DT_UserLoginRecord ul = new DT_UserLoginRecord(); ul.RealName = u.RealName; ul.Telphone = u.Telphone; ul.Password = t.GetMd5(u.Password); ul.IsInner = false; //是否内部成员 是 ul.RoleId = 0; //用户角色为0,表示系统外 ul.AddTime = DateTime.Now; ul.Status = true; //添加用户时,账号状态默认为true // ul.ShareStatus = "是"; int count = umbll.AddUser(ul); if (count > 0) { Response.Write("1"); } else { Response.Write("0"); } Response.End(); }
//public ActionResult UserManage(int? id=1) //{ // //全部内部用户 // List<DT_UserLoginRecord> allusers = umbll.SelectUsers(); // ViewBag.allusers = allusers; // //全部单位 // List<DT_WorkUnit> units = wbll.SelUnitByParent(); // ViewBag.units = units; // //全部科室 // List<DT_WorkUnit> depts = wbll.SelDeptByParent(); // ViewBag.depts = depts; // //全部角色 // List<DT_Role> rlist = rbll.SelectRoles(); // ViewBag.rlist = rlist; // return View(); //} /// <summary> /// 添加用户 /// </summary> /// <param name="u"></param> public void _AddUser(DT_UserLoginRecord u) { Tools t = new Tools(); DT_UserLoginRecord ul = new DT_UserLoginRecord(); ul.RealName = u.RealName; ul.WorkUnitId = u.WorkUnitId; ul.DeptId = u.DeptId; ul.IsCadre = u.IsCadre; //是否科级干部 ul.IsInner = true; //是否内部成员 是 ul.Telphone = u.Telphone; ul.Password = t.GetMd5(u.Password); ul.RoleId = u.RoleId; //用户权限 ul.AddTime = DateTime.Now; ul.Status = true; //添加用户时,账号状态默认为true int count = umbll.AddUser(ul); if (count > 0) { Response.Write("1"); } else { Response.Write("0"); } Response.End(); }
/// <summary> /// 修改外部共享人的roleid:0 /// </summary> /// <param name="id"></param> public void _UpdShareRoleId(int id) { DT_UserLoginRecord updrole = sbll.QueryUserByid(id); // updrole.RoleId = 0; updrole.ShareStatus = "是"; sbll.UpdShareRoleId(updrole); }
/// <summary> /// 添加登录记录 /// </summary> /// <param name="id"></param> /// <param name="ip"></param> /// <param name="remark"></param> /// <returns></returns> //public int UpdUserLoginRecord(int id, string ip, string remark) //{ // try // { // return udal.UpdUserLoginRecord(id,ip,remark); // } // catch // { // return 0; // } //} public int UpdUserLoginRecord(DT_UserLoginRecord u) { try { return(udal.UpdUserLoginRecord(u)); } catch { return(0); } }
/// <summary> /// 删除系统外用户 /// </summary> /// <param name="u"></param> public void _DelUser(int id) { DT_UserLoginRecord u = umbll.QueryById(id); //quabll.QueryPayByRole(id); int count = umbll.DelUser(u); if (count > 0) { Response.Write("<script type='text/javascript'>alert('删除成功!');</script>"); Response.Write("<script type='text/javascript'>window.location.href='/ShareFile/SetShare';</script>"); } }
/// <summary> /// 登录记录 /// </summary> /// <param name="id"></param> /// <param name="num"></param> /// <returns></returns> public int GetLoginRecord(int id, int num) { UserBLL ubll = new UserBLL(); //登录IP string ip = Request.UserHostAddress; string remark = "正常登录"; DT_UserLoginRecord ulr = ubll.QueryOneUser(id); ulr.LoginTime = DateTime.Now; ulr.LoginIp = ip; ulr.LoginNum = num + 1; ulr.Remark = remark; return(ubll.UpdUserLoginRecord(ulr)); }
/// <summary> /// 启用用户状态 /// </summary> /// <param name="u"></param> public void _OpenStatus(int id) { //根据id修改 DT_UserLoginRecord ul = umbll.QueryById(id); ul.Status = true; int count = umbll.UpdUser(ul); if (count > 0) { Response.Write("<script type='text/javascript'>alert('该用户已被启用,可再次登录系统!');</script>"); Response.Write("<script type='text/javascript'>window.location.href='/SystemManage/UserManage';</script>"); } else { Response.Write("<script type='text/javascript'>alert('启用失败,请重试!');</script>"); Response.Write("<script type='text/javascript'>window.location.href='/SystemManage/UserManage';</script>"); } //Response.End(); }
/// <summary> /// 添加单位 /// </summary> /// <param name="u"></param> public void _AddUnit(DT_WorkUnit w) { DT_UserLoginRecord u = (DT_UserLoginRecord)Session["user"]; DT_WorkUnit wu = new DT_WorkUnit(); wu.UnitName = w.UnitName; wu.AddUnitTime = DateTime.Now; wu.CreateUnit = u.Telphone; int count = wbll.AddUnit(wu); if (count > 0) { Response.Write("1"); } else { Response.Write("0"); } Response.End(); }
// // GET: /Base/ protected override void OnActionExecuting(ActionExecutingContext filterContext) { UserBLL ubll = new UserBLL(); WorkUnitBLL wbll = new WorkUnitBLL(); UserManageBLL umbll = new UserManageBLL(); ShareBLL sbll = new ShareBLL(); BuildTimeBLL bbll = new BuildTimeBLL(); TotalBLL tbll = new TotalBLL(); DT_UserLoginRecord u = filterContext.HttpContext.Session["user"] as DT_UserLoginRecord; //没有登录则不能访问 if (u == null) { filterContext.Result = new RedirectResult("/Home/Login"); } else { ViewBag.username = u.Telphone; //ViewBag.photo=u //是否科级干部 ViewBag.iscadre = ubll.IsCadre(u.Id); //登录id ViewBag.id = u.Id; //用户角色 ViewBag.role = Session["roleid"]; //用户是否有共享 ViewBag.sharestatus = Session["sharestatus"]; //全部单位 List <DT_WorkUnit> allunits = wbll.SelUnitByParent(); ViewBag.allunits = allunits; //全部科室 List <DT_WorkUnit> alldepts = wbll.SelDeptByParent(); ViewBag.alldepts = alldepts; //照片 string img = ubll.GetImg(Convert.ToInt32(Session["id"])); ViewBag.img = img; //全部内部用户 List <DT_UserLoginRecord> allusers = umbll.SelectUsers(); ViewBag.allusers = allusers; //根据本人登录id查询其单位id ViewBag.SelUnitidByUid = ubll.SelUnitidByUid(Convert.ToInt32(Session["id"])); //单位id ViewBag.unitid = Session["unitid"]; //年份 List <DT_Total> years = sbll.Total().GroupBy(a => a.YearTable).Select(b => new DT_Total { YearTable = b.Key }).ToList(); ViewBag.years = years; //根据添加时间获取最新的建档时间 ViewBag.buildtime = bbll.GetLastTime(); //查询全部基本信息表 List <DT_UserInfo> userinfolist1 = ubll.SelectUserInfo(); ViewBag.userinfolist1 = userinfolist1; //根据登录id和年份查询出年份 ViewBag.yeartable = tbll.SelectYear(Convert.ToInt32(Session["id"])); //根据登录id查询总表status的状态 这里主要是根据status为“被退回”来判断 //修改二次修改,点击“保存”时,同时修改status为“未提交”,可再次提交 (注意年份) ViewBag.status = ubll.SelStatus(Convert.ToInt32(Session["id"])); } }
public void ExcLogin() { UserBLL ubll = new UserBLL(); string tel = Request["telphone"]; string pwd = Request["password"]; Tools t = new Tools(); pwd = t.GetMd5(pwd); DT_UserLoginRecord u = ubll.Login(tel, pwd); if (u != null) { Session["user"] = u; Session["id"] = u.Id; Session["realname"] = u.RealName; Session["roleid"] = u.RoleId; Session["unitid"] = u.WorkUnitId; Session["tel"] = u.Telphone; Session["sharestatus"] = u.ShareStatus; Session["count"] = u.LoginNum; //登录IP string ip = Request.UserHostAddress.ToString(); string remark = "正常登录"; DT_UserLoginRecord ulr = ubll.QueryOneUser(u.Id); ulr.LoginTime = DateTime.Now; //登录时间 ulr.LoginIp = ip; //登录IP ulr.LoginNum = (u.LoginNum == null?0:u.LoginNum) + 1; //登录次数 ulr.Remark = remark; ubll.UpdUserLoginRecord(ulr); // GetLoginRecord(u.Id,u.LoginNum); if (u.Status != null) { if (u.Status == true) { if (u.RoleId != null) { if (u.IsCadre != null) { if (u.IsCadre == true) { if (u.RoleId == 1 || u.RoleId == 2) { BuildTimeBLL bbll = new BuildTimeBLL(); //填档开始时间 DateTime?starttime = bbll.GetLastTime().BuildStartTime; //填档结束时间 DateTime?endtime = bbll.GetLastTime().BuildEndTime; //这里目前设置的是本地时间 DateTime time = DateTime.Now; //是科级干部的普通用户或审核用户在填档有效期内时间判断 if (time < starttime) { Response.Write("<script type='text/javascript'>alert('很抱歉,填档时间未开始!');location.href='/Home/NoStart';</script>"); } else if (time > endtime) { Response.Write("<script type='text/javascript'>alert('很抱歉,填档时间已结束!');location.href='/Home/HasStop';</script>"); } else { if (u.RoleId == 1) { Response.Write("<script type='text/javascript'>alert('登录成功');location.href='/EnterFile/Index';</script>"); } else if (u.RoleId == 2) { Response.Write("<script type='text/javascript'>alert('登录成功');location.href='/Main/Index';</script>"); } } } else if (u.RoleId == 3 || u.RoleId == 4) { Response.Write("<script type='text/javascript'>alert('登录成功');location.href='/Main/Index';</script>"); } else if ((u.RoleId == 1 || u.RoleId == 2 || u.RoleId == 3 || u.RoleId == 4) && u.ShareStatus == "是") { ShareBLL sbll = new ShareBLL(); //共享开始时间 DateTime?sharebegintime = sbll.GetLastRecord().ShareBeginTime; //共享结束时间 DateTime?shareendtime = sbll.GetLastRecord().ShareEndTime; DateTime?time = DateTime.Now; if (time < sharebegintime) { Response.Write("<script type='text/javascript'>alert('很抱歉,共享时间未开始!');location.href='/Home/NoStart';</script>"); } else if (time > shareendtime) { Response.Write("<script type='text/javascript'>alert('很抱歉,共享时间已结束!');location.href='/Home/HasStop';</script>"); } else if (time <= shareendtime && time >= sharebegintime) { Response.Write("<script type='text/javascript'>alert('登录成功');location.href='/ForeignShare/Index';</script>"); } } else { Response.Write("<script type='text/javascript'>alert('你无权登录该系统!');location.href='/Home/Login';</script>"); } } } else { //科级干部为空或者不是科级干部的用户 if (u.RoleId == 1) { Response.Write("<script type='text/javascript'>alert('你无权登录该系统!');location.href='/Home/Login';</script>"); } else if (u.RoleId == 2 || u.RoleId == 3 || u.RoleId == 4) { Response.Write("<script type='text/javascript'>alert('登录成功');location.href='/Main/Index';</script>"); } else if (u.RoleId == 0 && u.IsInner == false && u.ShareStatus == "是") { ShareBLL sbll = new ShareBLL(); //共享开始时间 DateTime?sharebegintime = sbll.GetLastRecord().ShareBeginTime; //共享结束时间 DateTime?shareendtime = sbll.GetLastRecord().ShareEndTime; DateTime?time = DateTime.Now; if (time < sharebegintime) { Response.Write("<script type='text/javascript'>alert('很抱歉,共享时间未开始!');location.href='/Home/NoStart';</script>"); } else if (time > shareendtime) { Response.Write("<script type='text/javascript'>alert('很抱歉,共享时间已结束!');location.href='/Home/HasStop';</script>"); } else if (time <= shareendtime && time >= sharebegintime) { Response.Write("<script type='text/javascript'>alert('登录成功');location.href='/ForeignShare/Index';</script>"); } } else { Response.Write("<script type='text/javascript'>alert('你无权登录该系统!');location.href='/Home/Login';</script>"); } } } else { Response.Write("<script type='text/javascript'>alert('你无权登录该系统!');location.href='/Home/Login';</script>"); } } else { //ubll.UpdUserLoginRecord(u.Id, ip, remark2); Response.Write("<script type='text/javascript'>alert('该用户账号已被禁用,请联系高级用户!');;location.href='/Home/Login';</script>");//账号被禁用 } } else { Response.Write("<script type='text/javascript'>alert('你无权登录该系统!');location.href='/Home/Login';</script>"); } } else { Response.Write("<script>alert('登录失败!');location.href='/Home/Login';</script>");//登录失败 } Response.End(); }
/// <summary> /// 修改外部共享人的roleid /// </summary> /// <param name="u"></param> /// <returns></returns> public int UpdShareRoleId(DT_UserLoginRecord u) { return(sdal.UpdShareRoleId(u)); }
/// <summary> /// 删除用户 /// </summary> /// <param name="u"></param> /// <returns></returns> public int DelUser(DT_UserLoginRecord u) { return(umdal.DelUser(u)); }
/// <summary> /// 修改用户 /// </summary> /// <param name="u"></param> /// <returns></returns> public int UpdUser(DT_UserLoginRecord u) { return(umdal.UpdUser(u)); }