Exemplo n.º 1
0
        private void Employeelogin_Click(object sender, EventArgs e)
        {
            string user = username.Text;
            string pwd  = password.Text;

            if ("".Equals(user) || user == null)
            {
                MessageBox.Show("用户名不得为空!");
            }
            else
            {
                if ("".Equals(pwd) || pwd == null)
                {
                    MessageBox.Show("密码不得为空!");
                }
                else
                {
                    string sql = "select * from employee where username="******"ds");
                        connection.Close();
                        DataTable         dataTable = ds.Tables["ds"];
                        DataRowCollection coldrow   = dataTable.Rows;
                        DataRow           dataRow;
                        for (int i = 0; i < coldrow.Count; i++)
                        {
                            dataRow = coldrow[i];

                            if (pwd.Equals(dataRow[3]))
                            {
                                if (Convert.ToInt32(dataRow[4]) == 1)
                                {
                                    MessageBox.Show("您好," + dataRow[1] + ",恭喜你登陆成功!");
                                    index inde = new index(1, user);
                                    this.Hide();
                                    inde.Show();
                                }
                                else
                                {
                                    MessageBox.Show("您已被限制登录!状态:" + Convert.ToInt32(dataRow[4]));
                                }
                            }
                            else
                            {
                                MessageBox.Show("密码错误,请重新输入!");
                            }
                        }
                        if (coldrow.Count == 0)
                        {
                            MessageBox.Show("未查询到该员工信息,请重新输入!");
                        }
                    }
                }
            }
        }