private void txtReg_userName_Leave(object sender, EventArgs e) { //当控件不再是活动空间时,检查用户名是否重复 labRgs_username.Text = ""; // string strName = txtReg_userName.Text.Trim(); if (string.IsNullOrEmpty(strName)) { TextBoxInputError("请输入用户名", labRgs_username, pic_username); return; } // int result = CarHomeMethod.CheckUserName(strName); if (result == 0) { TextBoxInputOk(pic_username); } else { TextBoxInputError("当前用户名已被注册", labRgs_username, pic_username); } }
private void btnLogin_Click(object sender, EventArgs e) { string uname = txtUserName.Text.Trim(); //Trim 只能移除首尾两端的空格 //string uname = txtReg_userName.Text.Replace(" ", ""); //Replace 替换所有空格 string upass = txtPassworld.Text.Trim(); if (string.IsNullOrEmpty(uname) || string.IsNullOrEmpty(upass)) { MessageBox.Show("请输入用户名和密码"); return; } // #region 旧代码 //string sql = "SELECT T_UserName,T_QQNum FROM Users WHERE T_UserName=@UserName and T_Password = @Password;"; //SQLiteParameter[] parms = new SQLiteParameter[] { // new SQLiteParameter("@UserName",uname), // new SQLiteParameter("@Password",upass) //}; //SQLiteDataReader dr = StaticInfo.SqliteHelper.ExecuteReader(sql, parms); //if(dr.HasRows) //{ // while (dr.Read()) // { // StaticInfo.CarUserName = dr["T_UserName"].ToString(); // StaticInfo.CarUserQQ = dr["T_QQNum"].ToString(); // } // this.Close(); //} //else //{ // MessageBox.Show("没有数据,请注册"); // btnRegister_Click(sender, e);//打开注册窗口 //} #endregion CarHomeMethod.Login(uname, upass); if (StaticInfo.CheckUserNameIsNull()) { MessageBox.Show("没有数据,请注册"); btnRegister_Click(sender, e);//打开注册窗口 } else { this.Close(); } }
private void btnReg_Register_Click(object sender, EventArgs e) { //输入非空判断 string uname = txtReg_userName.Text.Trim(); //Trim 只能移除首尾两端的空格 //string uname = txtReg_userName.Text.Replace(" ", ""); //Replace 替换所有空格 string upass = txtReg_passwolrd.Text.Trim(); string upass2 = txtReg_passwolrd2.Text.Trim(); string uQQ = txtReg_QQ.Text.Trim(); if (string.IsNullOrEmpty(uname) || string.IsNullOrEmpty(upass) || string.IsNullOrEmpty(upass2)) { MessageBox.Show("带*号为必填项"); return; } //两次输入密码是否一致 if (!upass.Equals(upass2)) { MessageBox.Show("两次输入的密码不一致"); return; } #region 安全的写法,容易找出sql注入 //字符串拼接的方式 向数据库插入数据 //string sql = string.Format("INSERT INTO CH_Users (CH_UserName, CH_Passworld, CH_QQ) VALUES({0}, {1}, {2});", uname, upass, uQQ); //int res= sqlHelper.ExecuteNonQuery(sql, null); //if (res > 0) // MessageBox.Show("恭喜【" + uname + "】注册成功"); //else // MessageBox.Show("很遗憾【" + uname + "】注册失败"); #endregion #region 旧代码 Ctrl K + S //安全写法 //string sql = "INSERT INTO Users (T_UserName, T_Password, T_QQNum) VALUES(@T_UserName, @T_Password, @T_QQNum);"; //// //SQLiteParameter[] parms = new SQLiteParameter[] { // new SQLiteParameter( "@T_UserName", uname), // new SQLiteParameter( "@T_Password", upass), // new SQLiteParameter( "@T_QQNum", uQQ), //}; //int res = sqlHelper.ExecuteNonQuery(sql, parms); //if (res > 0) //{ // MessageBox.Show("恭喜【" + uname + "】注册成功"); // carUserName = uname; // carUserQQ = uQQ; // this.Close();//关闭窗口 //} //else // MessageBox.Show("很遗憾【" + uname + "】注册失败"); #endregion int res = CarHomeMethod.Register(uname, upass, uQQ); if (res > 0) { MessageBox.Show("恭喜【" + uname + "】注册成功"); StaticInfo.CarUserName = uname; StaticInfo.CarUserQQ = uQQ; this.Close();//关闭窗口 } else { MessageBox.Show("很遗憾【" + uname + "】注册失败"); } }