コード例 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (TbUserName.Text.Trim() == "" || TbPWS.Text.Trim() == "")
            {
                MessageBox.Show("请正确输入账号和密码");
                return;
            }
            List <SqlParameter> sqlList = new List <SqlParameter>()
            {
                GuGuGuHelper.CreatePara("@EmployeeID", SqlDbType.Char, ParameterDirection.Input, TbUserName.Text.Trim(), 10),
                GuGuGuHelper.CreatePara("@password", SqlDbType.Char, ParameterDirection.Input, TbPWS.Text.Trim(), 16),
                GuGuGuHelper.CreatePara("@returnValue", SqlDbType.Int, ParameterDirection.ReturnValue),
            };

            GuGuGuHelper.ExecuteNonQuery("prcLogin", sqlList, CommandType.StoredProcedure);
            int returnValue = Convert.ToInt32(sqlList.ElementAt(2).Value);

            if (returnValue == 1)
            {
                MessageBox.Show("登陆成功!");
                GuGuGu fm = new GuGuGu(TbUserName.Text.Trim());
                Hide();
                fm.ShowDialog();
                Close();
            }
            else
            {
                MessageBox.Show("登陆失败!");
            }
        }