private void ShowInfo(int u_ID) { WalleProject.BLL.t_user bll = new WalleProject.BLL.t_user(); WalleProject.Model.t_user model = bll.GetModel(u_ID); this.txtu_address.Text = model.u_address; this.txtu_creaditsLogID.Text = model.u_creaditsLogID.ToString(); this.lblu_ID.Text = model.u_ID.ToString(); this.txtu_nickName.Text = model.u_nickName; this.txtu_birthDate.Text = model.u_birthDate.ToString(); this.txtu_name.Text = model.u_name; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WalleProject.Model.t_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_user("); strSql.Append("u_address,u_lastLoginDate,u_creaditsLogID,u_registrationDate,u_nickName,u_category,u_birthDate,u_state,u_passWord,u_integral,u_creditGrade,u_name,u_pic_ID,u_phone)"); strSql.Append(" values ("); strSql.Append("@u_address,@u_lastLoginDate,@u_creaditsLogID,@u_registrationDate,@u_nickName,@u_category,@u_birthDate,@u_state,@u_passWord,@u_integral,@u_creditGrade,@u_name,@u_pic_ID,@u_phone)"); MySqlParameter[] parameters = { new MySqlParameter("@u_address", MySqlDbType.VarChar, 50), new MySqlParameter("@u_lastLoginDate", MySqlDbType.DateTime), new MySqlParameter("@u_creaditsLogID", MySqlDbType.Int32, 10), new MySqlParameter("@u_registrationDate", MySqlDbType.Date), new MySqlParameter("@u_nickName", MySqlDbType.VarChar, 10), new MySqlParameter("@u_category", MySqlDbType.VarChar, 10), new MySqlParameter("@u_birthDate", MySqlDbType.Date), new MySqlParameter("@u_state", MySqlDbType.VarChar, 10), new MySqlParameter("@u_passWord", MySqlDbType.VarChar, 10), new MySqlParameter("@u_integral", MySqlDbType.Int32, 10), new MySqlParameter("@u_creditGrade", MySqlDbType.VarChar, 10), new MySqlParameter("@u_name", MySqlDbType.VarChar, 10), new MySqlParameter("@u_pic_ID", MySqlDbType.Int32, 10), new MySqlParameter("@u_phone", MySqlDbType.VarChar, 20) }; parameters[0].Value = model.u_address; parameters[1].Value = model.u_lastLoginDate; parameters[2].Value = model.u_creaditsLogID; parameters[3].Value = model.u_registrationDate; parameters[4].Value = model.u_nickName; parameters[5].Value = model.u_category; parameters[6].Value = model.u_birthDate; parameters[7].Value = model.u_state; parameters[8].Value = model.u_passWord; parameters[9].Value = model.u_integral; parameters[10].Value = model.u_creditGrade; parameters[11].Value = model.u_name; parameters[12].Value = model.u_pic_ID; parameters[13].Value = model.u_phone; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int u_ID) { WalleProject.BLL.t_user bll = new WalleProject.BLL.t_user(); WalleProject.Model.t_user model = bll.GetModel(u_ID); this.lblu_address.Text = model.u_address; this.lblu_lastLoginDate.Text = string.Format("{0:yyyy-MM-dd}", model.u_lastLoginDate); this.lblu_creaditsLogID.Text = model.u_creaditsLogID.ToString(); this.lblu_registrationDate.Text = model.u_registrationDate.ToString(); this.lblu_ID.Text = model.u_ID.ToString(); this.lblu_nickName.Text = model.u_nickName; this.lblu_category.Text = model.u_category; this.lblu_birthDate.Text = string.Format("{0:yyyy-MM-dd}", model.u_birthDate); this.lblu_state.Text = model.u_state; this.lblu_integral.Text = model.u_integral.ToString(); this.lblu_creditGrade.Text = model.u_creditGrade; this.lblu_name.Text = model.u_name; }
/// <summary> /// 通过电话号码得到一个对象实体 /// </summary> public WalleProject.Model.t_user GetModel(String phone) { StringBuilder strSql = new StringBuilder(); strSql.Append("select u_phone,u_address,u_lastLoginDate,u_creaditsLogID,u_registrationDate,u_ID,u_nickName,u_category,u_birthDate,u_state,u_passWord,u_integral,u_creditGrade,u_name,u_pic_ID from t_user "); strSql.Append(" where u_phone=@u_phone"); MySqlParameter[] parameters = { new MySqlParameter("@u_phone", MySqlDbType.String) }; parameters[0].Value = phone; WalleProject.Model.t_user model = new WalleProject.Model.t_user(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtu_address.Text.Trim().Length == 0) { strErr += "u_address不能为空!\\n"; } if (!PageValidate.IsDateTime(txtu_lastLoginDate.Text)) { strErr += "u_lastLoginDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtu_creaditsLogID.Text)) { strErr += "u_creaditsLogID格式错误!\\n"; } if (!PageValidate.IsDateTime(txtu_registrationDate.Text)) { strErr += "u_registrationDate格式错误!\\n"; } if (this.txtu_nickName.Text.Trim().Length == 0) { strErr += "u_nickName不能为空!\\n"; } if (this.txtu_category.Text.Trim().Length == 0) { strErr += "u_category不能为空!\\n"; } if (!PageValidate.IsDateTime(txtu_birthDate.Text)) { strErr += "u_birthDate格式错误!\\n"; } if (this.txtu_state.Text.Trim().Length == 0) { strErr += "u_state不能为空!\\n"; } if (this.txtu_passWord.Text.Trim().Length == 0) { strErr += "u_passWord不能为空!\\n"; } if (!PageValidate.IsNumber(txtu_integral.Text)) { strErr += "u_integral格式错误!\\n"; } if (this.txtu_creditGrade.Text.Trim().Length == 0) { strErr += "u_creditGrade不能为空!\\n"; } if (this.txtu_name.Text.Trim().Length == 0) { strErr += "u_name不能为空!\\n"; } if (!PageValidate.IsNumber(txtu_pic_ID.Text)) { strErr += "u_pic_ID格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string u_address = this.txtu_address.Text; DateTime u_lastLoginDate = DateTime.Parse(this.txtu_lastLoginDate.Text); int u_creaditsLogID = int.Parse(this.txtu_creaditsLogID.Text); DateTime u_registrationDate = DateTime.Parse(this.txtu_registrationDate.Text); string u_nickName = this.txtu_nickName.Text; string u_category = this.txtu_category.Text; DateTime u_birthDate = DateTime.Parse(this.txtu_birthDate.Text); string u_state = this.txtu_state.Text; string u_passWord = this.txtu_passWord.Text; int u_integral = int.Parse(this.txtu_integral.Text); string u_creditGrade = this.txtu_creditGrade.Text; string u_name = this.txtu_name.Text; int u_pic_ID = int.Parse(this.txtu_pic_ID.Text); WalleProject.Model.t_user model = new WalleProject.Model.t_user(); model.u_address = u_address; model.u_lastLoginDate = u_lastLoginDate; model.u_creaditsLogID = u_creaditsLogID; model.u_registrationDate = u_registrationDate; model.u_nickName = u_nickName; model.u_category = u_category; model.u_birthDate = u_birthDate; model.u_state = u_state; model.u_passWord = u_passWord; model.u_integral = u_integral; model.u_creditGrade = u_creditGrade; model.u_name = u_name; model.u_pic_ID = u_pic_ID; WalleProject.BLL.t_user bll = new WalleProject.BLL.t_user(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_user DataRowToModel(DataRow row) { WalleProject.Model.t_user model = new WalleProject.Model.t_user(); if (row != null) { if (row["u_address"] != null) { model.u_address = row["u_address"].ToString(); } if (row["u_phone"] != null) { model.u_phone = row["u_phone"].ToString(); } if (row["u_lastLoginDate"] != null && row["u_lastLoginDate"].ToString() != "") { model.u_lastLoginDate = DateTime.Parse(row["u_lastLoginDate"].ToString()); } if (row["u_creaditsLogID"] != null && row["u_creaditsLogID"].ToString() != "") { model.u_creaditsLogID = int.Parse(row["u_creaditsLogID"].ToString()); } if (row["u_registrationDate"] != null && row["u_registrationDate"].ToString() != "") { model.u_registrationDate = DateTime.Parse(row["u_registrationDate"].ToString()); } if (row["u_ID"] != null && row["u_ID"].ToString() != "") { model.u_ID = int.Parse(row["u_ID"].ToString()); } if (row["u_nickName"] != null) { model.u_nickName = row["u_nickName"].ToString(); } if (row["u_category"] != null) { model.u_category = row["u_category"].ToString(); } if (row["u_birthDate"] != null && row["u_birthDate"].ToString() != "") { model.u_birthDate = DateTime.Parse(row["u_birthDate"].ToString()); } if (row["u_state"] != null) { model.u_state = row["u_state"].ToString(); } if (row["u_passWord"] != null) { model.u_passWord = row["u_passWord"].ToString(); } if (row["u_integral"] != null && row["u_integral"].ToString() != "") { model.u_integral = int.Parse(row["u_integral"].ToString()); } if (row["u_creditGrade"] != null) { model.u_creditGrade = row["u_creditGrade"].ToString(); } if (row["u_name"] != null) { model.u_name = row["u_name"].ToString(); } if (row["u_pic_ID"] != null && row["u_pic_ID"].ToString() != "") { model.u_pic_ID = int.Parse(row["u_pic_ID"].ToString()); } } return(model); }
protected void btn_Login_Click1(object sender, EventArgs e) { if ((Session["PassErrorCountAdmin"] != null) && (Session["PassErrorCountAdmin"].ToString() != "")) { int PassErroeCount = Convert.ToInt32(Session["PassErrorCountAdmin"]); if (PassErroeCount > 3) { input_userName.Enabled = true; input_passWord.Enabled = true; btn_Login.Enabled = false; this.lblMsg.Text = "对不起,你错误登录了三次,系统登录锁定!"; return; } } Console.WriteLine(Session["CheckCode"]); #region 检查验证码 if ((Session["CheckCode"] != null) && (Session["CheckCode"].ToString() != "")) { if (Session["CheckCode"].ToString().ToLower() != this.CheckCode.Value.ToLower()) { this.lblMsg.Text = "输入的验证码有误!"; Session["CheckCode"] = null; return; } else { this.lblMsg.Text = ""; Session["CheckCode"] = null; string userName = Maticsoft.Common.PageValidate.InputText(input_userName.Text.Trim(), 30); string Password = MD5Enctypt.MD5.Md5Encrypt(Maticsoft.Common.PageValidate.InputText(input_passWord.Text.Trim(), 30)); bool isNumber = Maticsoft.Common.PageValidate.IsNumber(userName); //验证登录信息,如果验证通过则返回当前用户对象的安全上下文信息 // AccountsPrincipal newUser = AccountsPrincipal.ValidateLogin(userName, Password); BLL.t_user user = new BLL.t_user(); if (isNumber) { if (user.Exists(int.Parse(userName))) { if (user.IsLogin(int.Parse(userName), Password)) { WalleProject.Model.t_user _user = new WalleProject.Model.t_user(); _user = user.GetModel(int.Parse(userName)); _user.u_lastLoginDate = DateTime.Now; if (new BLL.t_user().Update(_user)) { Session["UserInfo"] = _user; if (this.chk_remenberMe.Checked) { HttpCookie cookie = new HttpCookie("USER_NAME"); cookie.Value = input_userName.Text; Response.Cookies.Add(cookie); } Response.Redirect("../User/Default.aspx?id=1"); } } else { this.lblMsg.Text = "您输入的密码不正确!"; Response.Write("<script>alert('您输入的密码不正确!')</script>"); } } else { this.lblMsg.Text = "您输入的用户名不存在!"; Response.Write("<script> alert('您输入的用户名不存在!')</script>"); } } } } else { Response.Redirect("../User/UserLogin.aspx"); } #endregion #region /* if (newUser == null)//登录信息不对 { this.lblMsg.Text = "登陆失败: " + userName; if ((Session["PassErrorCountAdmin"] != null) && (Session["PassErrorCountAdmin"].ToString() != "")) { int PassErroeCount = Convert.ToInt32(Session["PassErrorCountAdmin"]); Session["PassErrorCountAdmin"] = PassErroeCount + 1; } else { Session["PassErrorCountAdmin"] = 1; } } else { //根据用户对象的上下文得到用户对象信息,用于得到其他信息 User currentUser = new LTP.Accounts.Bus.User(newUser); //if (currentUser.UserType != "AA") //{ // this.lblMsg.Text = "你非管理员用户,你没有权限登录后台系统!"; // return; //} //把当前用户对象实例赋给Context.User,这样做将会把完整的用户信息加载到ASP.NET提供的验证体系中 Context.User = newUser; //验证当前用户密码 if (((SiteIdentity)User.Identity).TestPassword(Password) == 0) { this.lblMsg.Text = "你的密码无效!"; if ((Session["PassErrorCountAdmin"] != null) && (Session["PassErrorCountAdmin"].ToString() != "")) { int PassErroeCount = Convert.ToInt32(Session["PassErrorCountAdmin"]); Session["PassErrorCountAdmin"] = PassErroeCount + 1; } else { Session["PassErrorCountAdmin"] = 1; } } else { //保存当前用户对象信息 FormsAuthentication.SetAuthCookie(userName, false); Session["UserInfo"] = currentUser; Session["Style"] = currentUser.Style; if (Session["returnPage"] != null) { string returnpage = Session["returnPage"].ToString(); Session["returnPage"] = null; Response.Redirect(returnpage); } else { Response.Redirect("main.htm"); } } }*/ #endregion }