郑德才博客

         /// <summary>
        /// 登录按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private void btnLogin_Click(object sender, EventArgs e)
        {
            if (Check())
            {
                LoginBLL login = new LoginBLL();
                Boolean Result = login.LoginCheck(txtUserAccount.Text.Trim(), txtUserPWD.Text.Trim(), cboUserType.Text.Trim());
                if (Result == true)
                {
                    ManageNumberForm ManageNumberForm = new ManageNumberForm();
                    this.Visible = false;
                    ManageNumberForm.ShowDialog();
                    this.Close();
                }
            }
        }

        /// <summary>
        /// 判断登录内容是否符合条件
        /// </summary>
        /// <returns></returns>

        private Boolean Check()
        {
            if (this.txtUserAccount.Text.Trim() == "")
            {
                MessageBox.Show("登录账号不能为空！");
                return false;
            }
            if (this.txtUserAccount.Text.Trim().Length > 20)
            {
                MessageBox.Show("登录账号长度不能超过20位！");
                return false;
            }
            if (this.txtUserPWD.Text.Trim().Length == 0)
            {
                MessageBox.Show("登录密码不能为空！");
                return false;
            }
            if (this.txtUserPWD.Text.Trim().Length > 20)
            {
                MessageBox.Show("登录密码长度不能超过20位！");
                return false;
            }
            if (this.cboUserType.Text.Trim() == "")
            {
                MessageBox.Show("你输入的登录账号不存在！");
                return false;
            }
            return true;
        }
 

        /// <summary>
        /// 登录判断
        /// </summary>
        /// <param name="UserAccount"></param>
        /// <param name="UserPWD"></param>
        /// <param name="UserType"></param>
        /// <returns></returns>
        public Boolean LoginCheck(string UserAccount, string UserPWD, string UserType)
        {
            try
            {
                string sql = string.Format("select UserPWD,UserName from AdminTable where UserAccount='{0}' and UserType='{1}'", UserAccount.ToString(), UserType.ToString());
                ArrayList arr = SQLDaoImpl.GetDBValue_1(ConnHelper.getConnectionString(), sql);
                if (arr != null && arr.Count > 0)
                {
                    PWD = (arr[0] == null) ? "" : arr[0].ToString();
                    UserName = (arr[1] == null) ? "" : arr[1].ToString();
                    if (UserPWD != null)
                    {
                        if (PWD.Equals(UserPWD.ToString()))
                        {
                            ConnHelper.UserAccount = UserAccount.ToString();
                            ConnHelper.UserType = UserType.ToString();
                            ConnHelper.UserName = UserName.ToString();
                            return true;
                        }
                    }
                }
            }
            catch (Exception ex)
            {

                throw ex;
            }
            finally
            {

            }
            return false;
        }