public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //实例化一个对象 Model.HKSJ_USERS users = new Model.HKSJ_USERS(); //获取ID信息 //ID: RowUpdateUserID[0].ID, //UserName: $("#txtUpdateUserName").val(), //LoginName: $("#txtUpdateLoginName").val(), //Password: $("#txtUpdatePassword").val(), //Plane: $("#txtUpdatePlane").val(), //Phone: $("#txtUpdatePhone").val(), //Email: $("#txtUpdateEmail").val(), //CardNo: $("#txtUpdateCardNo").val() users.ID = context.Request["ID"] == null ? 0 : Convert.ToInt32(context.Request["ID"]); users.UserName = context.Request["UserName"]; users.LoginName = context.Request["LoginName"]; users.PassWord = context.Request["Password"]; users.Plane = context.Request["Plane"]; users.phone = context.Request["Phone"]; users.Mail = context.Request["Email"]; users.cardNo = context.Request["CardNo"]; //进行修改实现功能 if (userService.Update(users)) { context.Response.Write("OK"); } else { context.Response.Write("error"); } }
public void ProcessRequest(HttpContext context) { BLL.HKSJ_USERS userServices = new BLL.HKSJ_USERS(); context.Response.ContentType = "text/plain"; //获取参数实现用户的添加 Model.HKSJ_USERS users = new Model.HKSJ_USERS(); //UserName,LoginName,Password,Plane,Phone,Email,CardNo; users.UserName = context.Request["UserName"]; users.LoginName = context.Request["LoginName"]; users.PassWord = context.Request["Password"]; users.Plane = context.Request["Plane"]; users.phone = context.Request["Phone"]; users.Mail = context.Request["Email"]; users.cardNo = context.Request["CardNo"]; //实现给数据库中添加数据 if (userServices.Add(users) > 0) { context.Response.Write("OK"); } else { context.Response.Write("error"); } }
public Model.HKSJ_USERS GetLoginUser(string loginName, string userPwd) { //ID, UserName, LoginName, PassWord, Plane, phone, Mail, cardNo Model.HKSJ_USERS user = new Model.HKSJ_USERS(); string sql = "select ID, UserName, LoginName, PassWord, Plane, phone, Mail, cardNo from HKSJ_USERS where LoginName=@LoginName and PassWord=@PassWord"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@LoginName", loginName), new SqlParameter("@PassWord", userPwd) }; using (SqlDataReader reader = DbHelperSQL.ExecuteReader(sql, paras)) { if (reader.Read()) { user.ID = int.Parse(reader["ID"].ToString()); user.LoginName = reader["LoginName"] == DBNull.Value ? string.Empty : reader["LoginName"].ToString(); user.UserName = reader["UserName"] == DBNull.Value ? string.Empty : reader["UserName"].ToString(); user.cardNo = reader["cardNo"] == DBNull.Value ? string.Empty : reader["cardNo"].ToString(); user.Mail = reader["Mail"] == DBNull.Value ? string.Empty : reader["Mail"].ToString(); user.PassWord = reader["PassWord"] == DBNull.Value ? string.Empty : reader["PassWord"].ToString(); user.phone = reader["phone"] == DBNull.Value ? string.Empty : reader["phone"].ToString(); user.Plane = reader["Plane"] == DBNull.Value ? string.Empty : reader["Plane"].ToString(); } } return(user); }
public LoginResult GetUserLoginUserModel(string loginName, string userPwd) { //先对用户名或密码是否为空判断 if (string.IsNullOrEmpty(loginName)) { return(LoginResult.userIsNull); } if (string.IsNullOrEmpty(userPwd)) { return(LoginResult.pwdIsNull); } //用户名密码不为空就到数据库中查询 Model.HKSJ_USERS user = dal.GetLoginUser(loginName); //对返回的结果进行判断 if (user.LoginName == null) { return(LoginResult.userNotExist); } else if (userPwd != user.PassWord) { return(LoginResult.pwdError); } else { return(LoginResult.OK); } }
public List <Model.HKSJ_USERS> GetPageSizeNav(int pageIndex, int pageSize, out int totalCount) { //new一个SqlDataAdapter对象 using (SqlDataAdapter adapter = new SqlDataAdapter()) { //构造链接字符串 using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { //创建并执行数据源参数 adapter.SelectCommand = conn.CreateCommand(); //定义使用存储过程 adapter.SelectCommand.CommandText = "p_GetPageUSERS"; adapter.SelectCommand.CommandType = CommandType.StoredProcedure; //设置输入参数 adapter.SelectCommand.Parameters.Add(new SqlParameter("@pageIndex", pageIndex)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@pageSize", pageSize)); //设置输出参数 SqlParameter parameterout = new SqlParameter("@totalCount", SqlDbType.Int); parameterout.Direction = ParameterDirection.Output; adapter.SelectCommand.Parameters.Add(parameterout); //将数据源对象填充到表中 DataTable dt = new DataTable(); adapter.Fill(dt); //获取输出参数 totalCount = Convert.ToInt32(parameterout.Value); //循环遍历表中的数据源对象 List <Model.HKSJ_USERS> userproject = new List <Model.HKSJ_USERS>(); foreach (DataRow row in dt.Rows) { Model.HKSJ_USERS user = new Model.HKSJ_USERS(); //获取表中的所有对象显示输出 user.ID = Convert.ToInt32(row["ID"].ToString()); user.UserName = row["UserName"] == DBNull.Value ? "" : row["UserName"].ToString(); user.LoginName = row["LoginName"] == DBNull.Value ? "" : row["LoginName"].ToString(); user.PassWord = row["PassWord"] == DBNull.Value ? "" : row["PassWord"].ToString(); user.Plane = row["Plane"] == DBNull.Value ? "" : row["Plane"].ToString(); user.phone = row["phone"] == DBNull.Value ? "" : row["phone"].ToString(); user.Mail = row["Mail"] == DBNull.Value ? "" : row["Mail"].ToString(); user.cardNo = row["cardNo"] == DBNull.Value ? "" : row["cardNo"].ToString(); userproject.Add(user); } return(userproject); } } }
protected void btnLogin_Click(object sender, ImageClickEventArgs e) { #region 验证码判断 //先取得验证码,判断验证码是否正确,如果不正确就不用到数据库中查找内容了 string code = Session["ValidateCode"] == null ? string.Empty : Session["ValidateCode"].ToString(); string fromCode = Request["txtCode"]; if (code != fromCode) { //名字保留 userName = Request["txtClientID"]; //提醒用户 ErrorMsg = "验证码有误!"; return; } #endregion #region 获取提交过来的用户信息,到数据库查询 string strLoginName = Request["txtClientID"].Trim(); string strUserPwd = Request["txtPassword"]; BLL.HKSJ_USERS userInfoService = new BLL.HKSJ_USERS(); Model.HKSJ_USERS user = new Model.HKSJ_USERS(); LoginResult result = userInfoService.GetUserLoginUserModel(strLoginName, strUserPwd); //判断返回结果 if (result == LoginResult.userIsNull) { Js = "<script>alert('用户名不能为空!')</script>"; return; } else if (result == LoginResult.pwdIsNull) { Js = "<script>alert('密码不能为空!')</script>"; return; } else if (result == LoginResult.userNotExist) { Js = "<script>alert('用户名不存在!')</script>"; //名字保留 userName = Request["txtClientID"]; return; } else if (result == LoginResult.pwdError) { Js = "<script>alert('密码错误!')</script>"; //名字保留 userName = Request["txtClientID"]; return; } else if (result == LoginResult.OK) { //验证通过后把用户名保存到session里面 Session["user"] = user; //把登录成功的用户名保存到cookie中 if (!String.IsNullOrEmpty(strLoginName)) { Response.Cookies["userName"].Value = strLoginName; Response.Cookies["userName"].Expires = DateTime.Now.AddDays(5); } //验证都通过,转到后台页面 Response.Redirect("~/admin/users/adminUser.html"); } else { Js = "<script>alert('未知错误!')</script>"; return; } #endregion }