private void AddUserInfo(HttpContext context) { BLL.UserInfo bll = new BLL.UserInfo(); string UserName = context.Request["U_username"]; int ExistRes = bll.Exist(string.Format("U_username='******'", UserName)); if (ExistRes > 0) { context.Response.Write("exist"); return; } Model.UserInfo model = new Model.UserInfo(); model.U_username = UserName; model.U_password = model.U_username; model.U_power = context.Request["U_power"]; model.U_nickname = context.Request["U_nickname"]; model.U_mailbox = context.Request["U_mailbox"]; model.U_Role = context.Request["U_Role"]; model.U_Comments = context.Request["U_Comments"]; model.U_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.U_IsDelete = 0; if (bll.Add(model) > 0) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
public static Com.DataPack.DataRsp <string> page(string PageIndex, string PageSize, string uname, string ustat) { Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>(); try { BLL.UserInfo user_bll = new BLL.UserInfo(); Com.DataPack.PageModelResp pages = new Com.DataPack.PageModelResp(); pages.PageIndex = int.Parse(PageIndex); pages.PageSize = int.Parse(PageSize); int rowc = 0; int pc = 0; // ,DepartId,Address,HeadImg,inssj,udsj string cols = "UserId,UserName,Name,Status,Email,inssj"; DataTable userdt = user_bll.GetListCols(cols, "1=1", "UserId", "", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; pages.PageCount = pc; pages.RowCount = rowc; if (userdt.Rows.Count > 0) { pages.list = userdt; } rsp.data = Newtonsoft.Json.JsonConvert.SerializeObject(pages).Replace("\n\r", ""); } catch (Exception ex) { throw; } return(rsp); }
private void UpdateUserInfo(HttpContext context) { BLL.UserInfo bll = new BLL.UserInfo(); string UserName = context.Request["U_username"]; string ID = context.Request["U_ID"]; int ExistRes = bll.Exist(string.Format("U_username='******' and U_ID not in ({1})", UserName, ID)); if (ExistRes > 0) { context.Response.Write("exist"); return; } Model.UserInfo model = new Model.UserInfo(); model.U_ID = Convert.ToInt32(ID); model.U_username = UserName; model.U_power = context.Request["U_power"]; model.U_nickname = context.Request["U_nickname"]; model.U_mailbox = context.Request["U_mailbox"]; model.U_Role = context.Request["U_Role"]; model.U_Comments = context.Request["U_Comments"]; if (bll.Update(model)) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
protected void btn_Login_Click(object sender, EventArgs e) { string strUserName = this.txt_username.Value.Trim(); string strPassword = this.txt_password.Value.Trim(); if (string.IsNullOrEmpty(strUserName) || string.IsNullOrEmpty(strPassword)) { Response.Write("<script>alert('Please Input Username or Password !');location.href='Login.aspx'</script>"); } else { BLL.UserInfo bll = new BLL.UserInfo(); DataSet ds = bll.Login(strUserName, strPassword); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; Session["User_ID"] = dr["U_ID"]; Session["User_UserName"] = dr["U_nickname"]; Session["User_Power"] = dr["U_power"]; Response.Redirect("DashBoard.aspx"); } else { Response.Write("<script>alert('Username or Password Incorrect !');location.href='Login.aspx'</script>"); } } }
//[ValidateAntiForgeryToken] public async Task<ActionResult> Login(LoginViewModel model, string returnUrl) { if (Request.Params["username"] != null && Request.Params["username"].Trim() != "") { int Id = Convert.ToInt32(Request.Params["username"]); string pwd = Request.Params["password"]; BLL.UserInfo bll = new BLL.UserInfo(); if (bll.GetRecordCount("Uid=" + Id.ToString() + " and Pwd='" + pwd + "'") == 1) { return Redirect("/MyCenter/Index"); } } if (!ModelState.IsValid) { return View(model); } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false); switch (result) { case SignInStatus.Success: return RedirectToLocal(returnUrl); case SignInStatus.LockedOut: return View("Lockout"); case SignInStatus.RequiresVerification: return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return View(model); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string userName = context.Request["userName"]; string pwd = context.Request["password"]; //从数据库读取用户密码验证 BLL.UserInfo UserInfoObject = new BLL.UserInfo(); if (UserInfoObject.Exists(userName, pwd) == true) { //将账号密码写入coockie context.Response.Cookies["UserName"].Value = userName; context.Response.Cookies["pwd"].Value = pwd; context.Response.Cookies["IsLogin"].Value = "OK"; context.Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(1); context.Response.Cookies["pwd"].Expires = DateTime.Now.AddDays(1); context.Response.Cookies["IsLogin"].Expires = DateTime.Now.AddDays(1); context.Response.Write("ok"); context.Response.End(); } else { context.Response.Write("登陆失败,请检查用户名或密码"); context.Response.End(); } }
private void button1_Click(object sender, EventArgs e) { string userName = textBox1.Text.Trim(); string password = textBox2.Text.Trim(); if (userName == "" || password == "") { MessageBox.Show("用户名或密码不能为空!"); textBox1.Focus(); return; } else { BLL.UserInfo user = new BLL.UserInfo(); if (user.Login(userName, password)) { UserHelper.userName = textBox1.Text.Trim(); UserHelper.password = textBox2.Text.Trim(); this.Hide(); scheduleUI f; f = new scheduleUI(); f.Show(); } else { MessageBox.Show("用户名或密码错误,请重新输入!", "错误"); textBox1.Text = ""; textBox2.Text = ""; textBox1.Focus(); } } }
public ActionResult Info() { int Tid = Convert.ToInt32(HttpContext.Session["userid"]); Danyl.SnnuURP.Model.Teacher teacher = new BLL.Teacher().GetModel(Tid); try { Danyl.SnnuURP.Model.Depart depart = new BLL.Depart().GetModel(teacher.DeptId); Danyl.SnnuURP.Model.TeacherType TType = new BLL.TeacherType().GetModel(teacher.TeacherTypeId); Danyl.SnnuURP.Model.UserInfo userInfo = new BLL.UserInfo().GetModel(Tid); ViewBag.Tid = teacher.Tid; ViewBag.Tname = teacher.Tname; ViewBag.Sex = teacher.Sex ? '男' : '女'; ViewBag.IdNumber = teacher.IdNumber; ViewBag.Depart = depart.DeptName; ViewBag.Degree = teacher.Degree; ViewBag.TeacherType = TType.TeacherTypes; ViewBag.Phone = userInfo.UserPhone; ViewBag.Email = userInfo.UserEmail; return View(ViewBag); } catch (Exception ex) { return Redirect("~/Teacher/Account/Login"); } }
private void UpdateDynamicJSUserInfo(HttpContext context) { BLL.UserInfo bll = new BLL.UserInfo(); DataSet ds = bll.GetList(""); List <Model.UserForJson> list = new List <Model.UserForJson>(); foreach (DataRow dr in ds.Tables[0].Rows) { list.Add(new Model.UserForJson() { U_ID = Convert.ToInt32(dr["U_ID"]), U_nickname = dr["U_nickname"].ToString() }); } JavaScriptSerializer jss = new JavaScriptSerializer(); //string strJson = string.Format("{{\"rows\":{0}}}", jss.Serialize(list)); string strJson = jss.Serialize(list); try { //File.WriteAllText(WMSys.Common.PathHelper.ServerPath+"\\jsonData\\UserInfo.json", strJson); string DynamicJSPath = WMSys.Common.PathHelper.ServerPath + "\\DynamicJS\\TagsInputUserData.js"; string[] DynamicJSContent = File.ReadAllLines(DynamicJSPath); DynamicJSContent[0] = string.Format("var JsonData = '{0}'", strJson); File.WriteAllLines(DynamicJSPath, DynamicJSContent); context.Response.Write(strJson); } catch (Exception) { context.Response.Write("fail"); } }
void DataBind()//定义一个函数用于绑定数据到DataGridView { BLL.UserInfo bll = new BLL.UserInfo(); DataSet ds = new DataSet(); ds = bll.GetList(); dataGridView2.DataSource = ds.Tables[0]; }
private void ChangePassword(HttpContext context) { int U_ID = Convert.ToInt32(context.Request["U_ID"]); string oldPassword = context.Request["oldPassword"]; string NewPassword = context.Request["NewPassword"]; BLL.UserInfo bll = new BLL.UserInfo(); context.Response.Write(bll.ChangePassword(U_ID, oldPassword, NewPassword)); }
public string GetNameByUserInfoID(int UserInfoID) { string Name = ""; BLL.UserInfo BUserInfo = new BLL.UserInfo(); Model.UserInfo MUserInfo = new Model.UserInfo(); MUserInfo = BUserInfo.GetModel(UserInfoID); if (MUserInfo != null) { Name = MUserInfo.TrueName; } return(Name); }
/// <summary> /// 执行策略 /// </summary> public override void DoWork <T>(T context) { var userInfoContext = context as XCLCMS.Data.BLL.Strategy.UserInfo.UserInfoContext; if (null == userInfoContext.UserInfo) { return; } bool flag = false; XCLCMS.Data.BLL.UserInfo bll = new BLL.UserInfo(); try { switch (userInfoContext.HandleType) { case StrategyLib.HandleType.ADD: userInfoContext.UserInfo.CreaterID = userInfoContext.ContextInfo.UserInfoID; userInfoContext.UserInfo.CreaterName = userInfoContext.ContextInfo.UserName; userInfoContext.UserInfo.CreateTime = DateTime.Now; userInfoContext.UserInfo.UpdaterID = userInfoContext.UserInfo.CreaterID; userInfoContext.UserInfo.UpdaterName = userInfoContext.UserInfo.CreaterName; userInfoContext.UserInfo.UpdateTime = userInfoContext.UserInfo.CreateTime; flag = bll.Add(userInfoContext.UserInfo); break; case StrategyLib.HandleType.UPDATE: userInfoContext.UserInfo.UpdaterID = userInfoContext.ContextInfo.UserInfoID; userInfoContext.UserInfo.UpdaterName = userInfoContext.ContextInfo.UserName; userInfoContext.UserInfo.UpdateTime = DateTime.Now; flag = bll.Update(userInfoContext.UserInfo); break; } } catch (Exception ex) { flag = false; this.ResultMessage += string.Format("异常信息:{0}", ex.Message); } if (flag) { this.Result = StrategyLib.ResultEnum.SUCCESS; } else { this.Result = StrategyLib.ResultEnum.FAIL; this.ResultMessage = string.Format("保存用户基础信息失败!{0}", this.ResultMessage); } }
private void DeleteUserInfo(HttpContext context) { BLL.UserInfo bll = new BLL.UserInfo(); int U_ID = Convert.ToInt32(context.Request["U_ID"]); if (bll.Delete(U_ID)) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
private void toolSave_Click(object sender, EventArgs e) { if (txtUserName.Text == "" || txtUserPassword.Text == "" || cboUserType.Text == "") { MessageBox.Show("请将信息添加完整!"); return; } Model.UserInfo model = new Model.UserInfo();//实例化model层 model.UserName = txtUserName.Text.Trim(); model.UserPassword = txtUserPassword.Text.Trim(); model.UserType = cboUserType.Text.Trim(); BLL.UserInfo bll = new BLL.UserInfo();//实例化BLL层 model = bll.ToMD5(model); switch (flag) { case 0: { } break; case 1: { if (bll.Add(model)) //将员工信息添加到数据库中,根据返回值判断是否添加成功 { DataBind(); //窗体登录时绑定数据到DataGridView ControlStatus(); } } break; case 2: { if (bll.Update(model)) //根据返回布尔值判断是否修改数据成功 { DataBind(); //窗体登录时绑定数据到DataGridView txtUserName.ReadOnly = false; ControlStatus(); } } break; case 3: { if (bll.Delete(model)) //根据返回布尔值判断是否删除数据成功 { DataBind(); //窗体登录时绑定数据到DataGridView ControlStatus(); } } break; } }
public void ProcessRequest(HttpContext context) { BLL.UserInfo UserInfoService = new BLL.UserInfo(); context.Response.ContentType = "text/plain"; string userName = context.Request["userName"]; string pwd = context.Request["password"]; string confirmPwd = context.Request["password_confirmation"]; string Guid_Code = context.Request["Guid_Code"]; if (UserInfoService.Exists(Guid_Code) == false) { context.Response.Write("邀请码不正确,请QQ联系 1443742816 , 2101300125 获取邀请码!"); context.Response.End(); } else if (pwd != confirmPwd) { context.Response.Write("输入的两次密码不一致!"); context.Response.End(); } else if (pwd == "" || userName == "") { context.Response.Write("账号或密码不能为空!"); context.Response.End(); } else { Model.UserInfo UserinfoModal = new Model.UserInfo(); UserinfoModal.UserId = userName; UserinfoModal.UserPassword = pwd; if (UserInfoService.Add(UserinfoModal) == 0 || UserInfoService.Delete(Guid_Code)) { context.Response.Write("ok"); } else { context.Response.Write("注册失败!"); } context.Response.End(); } }
public ActionResult Login(Osiris.CloudWeb.Models.UserInfo user) { string uName = user.UserName.Trim(); string uPassword = Commons.Get_MD5(user.Password.Trim()); Osiris.BLL.UserInfo bll = new BLL.UserInfo(); string r = bll.CheckUserInfo(uName, uPassword); if (r.Equals("success")) { Session["UserName"] = uName; Session["Eare"] = "上海市"; return(Redirect("/home/index")); } else { // var scripts = string.Format("alert('{0}');", r); // return Content(string.Format("<script>alert('{0}');</script>", r)); Response.Write(string.Format("<script>alert('{0}');</script>", r)); return(View("login")); } }
//private void LoginReturnUserInfo(HttpContext context) //{ //} private void GetUserInfoSingle(HttpContext context) { BLL.UserInfo bll = new BLL.UserInfo(); DataSet ds = bll.GetList(" U_ID=" + context.Request["U_ID"]); DataRow dr = ds.Tables[0].Rows[0]; List <Model.UserInfo> list = new List <Model.UserInfo>(); list.Add(new Model.UserInfo() { U_username = dr["U_username"].ToString(), U_PowerDisplay = ChangePowerToDisplay(dr["U_power"].ToString()), U_power = dr["U_power"].ToString(), U_nickname = dr["U_nickname"].ToString(), U_mailbox = dr["U_mailbox"].ToString(), U_Role = dr["U_Role"].ToString(), U_Comments = dr["U_Comments"].ToString() }); JavaScriptSerializer jss = new JavaScriptSerializer(); string strJson = jss.Serialize(list).TrimStart('[').TrimEnd(']'); context.Response.Write(strJson); }
private void btnLogin_Click_1(object sender, EventArgs e) { Model.UserInfo model = new Model.UserInfo();//实例化Model层 model.UserName = txtUserName.Text.Trim(); model.UserPassword = txtPassword.Text.Trim(); BLL.UserInfo bll = new BLL.UserInfo(); //实例化BLL层 model = bll.ToMD5(model); DataSet ds = new DataSet(); //定义DataSet对象 ds = bll.GetList(model); //调用BLL层中的GetList方法,返还DataSet对象 if (ds.Tables[0].Rows.Count > 0) { Main main = new Main(); main.Type = ds.Tables[0].Rows[0]["用户类别"].ToString(); main.Show(); this.Hide(); } else { MessageBox.Show("用户名或者密码输入错误!"); } }
private void txtOK_Click(object sender, EventArgs e) { string strSelect = this.cbxCondition.Text.Trim(); if (strSelect == "") { MessageBox.Show("请选择查询条件!"); return; } if (this.txtKeyWord.Text == "") { MessageBox.Show("输入查询条件!"); return; } string strWhere = "1=1"; string userName = txtKeyWord.Text; string userType = txtKeyWord.Text; switch (strSelect) { case "用户账号": { strWhere = strWhere + " and UserName like '%" + userName + "%' "; } break; case "用户类型": { strWhere = strWhere + " and UserType = '" + userType + "'"; } break; } BLL.UserInfo bll = new BLL.UserInfo(); //实例化BLL层 DataSet ds = new DataSet(); ds = bll.GetList(strWhere); //执行带参数SQL语句,将结果存在ds中 dataGridView2.DataSource = ds.Tables[0]; //将ds中的表作为DataGridView的数据源 }
//[ValidateAntiForgeryToken] public async Task<ActionResult> Login(LoginViewModel model, string returnUrl) { if (Request.Params["username"] != null && Request.Params["username"].Trim() != "") { string Uid = Request.Params["username"]; string pwd = Request.Params["password"]; List<Danyl.SnnuURP.Model.UserInfo> userInfolist = new BLL.UserInfo().GetModelList("Uid=" + Uid + " and Pwd='" + pwd + "'"); if (userInfolist.Count==1) { Danyl.SnnuURP.Model.UserInfo userInfo = userInfolist.FirstOrDefault<Danyl.SnnuURP.Model.UserInfo>(); this.HttpContext.Session["userid"] = userInfo.Uid; this.HttpContext.Session["username"] = userInfo.Uname; return Redirect("../MyInfo/Index"); } } if (!ModelState.IsValid) { return View(model); } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false); switch (result) { case SignInStatus.Success: return RedirectToLocal(returnUrl); case SignInStatus.LockedOut: return View("Lockout"); case SignInStatus.RequiresVerification: return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return View(model); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Trim() == "") { MessageBox.Show("用户名不能为空!", "Error"); return; } if (textBox2.Text.Trim() == "") { MessageBox.Show("密码不能为空!", "Error"); return; } string user = textBox1.Text.Trim(); string pass = textBox2.Text.Trim(); Model.UserInfo adduser = new Model.UserInfo(); adduser.UserName = user; adduser.Password = pass; BLL.UserInfo insectuser = new BLL.UserInfo(); if (insectuser.AddUserInfoList(adduser)) { MessageBox.Show("注册成功!"); this.Hide(); LoginUI f; f = new LoginUI(); f.Show(); } else { MessageBox.Show("很抱歉,注册失败!","Error"); textBox1.Text = ""; textBox2.Text = ""; textBox1.Focus(); } }
private void QueryUserList(HttpContext context) { string strKeyWord = context.Request["KeyWord"]; BLL.UserInfo bll = new BLL.UserInfo(); List <Model.UserInfo> list = new List <Model.UserInfo>(); DataSet ds = new DataSet(); if (!string.IsNullOrEmpty(strKeyWord)) { ds = bll.GetList(string.Format("U_nickname like '%{0}%'", strKeyWord)); } else { ds = bll.GetList(""); } foreach (DataRow dr in ds.Tables[0].Rows) { list.Add(new Model.UserInfo() { U_ID = Convert.ToInt32(dr["U_ID"]), U_username = dr["U_username"].ToString(), //U_power = dr["U_power"].ToString(), U_PowerDisplay = ChangePowerToDisplay(dr["U_power"].ToString()), //U_power = dr["U_Power"].ToString(), U_nickname = dr["U_nickname"].ToString(), U_mailbox = dr["U_mailbox"].ToString(), U_Role = dr["U_Role"].ToString(), }); } JavaScriptSerializer jss = new JavaScriptSerializer(); //string strJson = string.Format("{{\"rows\":{0}}}", jss.Serialize(list)); string strJson = jss.Serialize(list); context.Response.Write(strJson); }