jl_person_message.cs

此系统开发了一个公交车管理系统。系统根据权限的不同

            SqlConnection con = new SqlConnection(dl);
            //打开连接
            con.Open();
            if (CheckNumber == "" && CheckUserName != "")
            {
                //创建sql语句将信息从库中调出
                string sql = "select user_account as 员工帐号,user_name as 员工姓名,user_power as 权限,user_money as 基本工资,user_remark as 备注 from db_User where user_name = '" + CheckUserName + "' ";
                //创建执行对象cmd
                SqlCommand cmd = new SqlCommand(sql, con);
                //创建读取器对象sdr
                SqlDataAdapter sdr = new SqlDataAdapter();
                //sdr的查询方法为cmd
                sdr.SelectCommand = cmd;
                //创建一个dataset容器
                DataSet ds = new DataSet();
                //填充数据ds
                sdr.Fill(ds);
                //绑定datagriview数据源为ds
                this.GridViewPersonResult.DataSource = ds.Tables[0].DefaultView;
                //关闭连接
                con.Close();
                GridViewPersonResult.Columns[0].Width = 80;
                GridViewPersonResult.Columns[1].Width = 80;
                GridViewPersonResult.Columns[2].Width = 80;
                GridViewPersonResult.Columns[3].Width = 80;
                GridViewPersonResult.Columns[4].Width = 120;

            }
            if (CheckUserName == "" && CheckNumber != "")
            { //创建sql语句将信息从库中调出
                string sql = "select user_account as 员工帐号,user_name as 员工姓名,user_power as 权限,user_money as 基本工资,user_remark as 备注 from db_User where user_account = '" + CheckNumber + "' ";
                //创建执行对象cmd
                SqlCommand cmd = new SqlCommand(sql, con);
                //创建读取器对象sdr
                SqlDataAdapter sdr = new SqlDataAdapter();
                //sdr的查询方法为cmd
                sdr.SelectCommand = cmd;
                //创建一个dataset容器
                DataSet ds = new DataSet();
                //填充数据ds
                sdr.Fill(ds);
                //绑定datagriview数据源为ds
                this.GridViewPersonResult.DataSource = ds.Tables[0].DefaultView;
                //关闭连接
                con.Close();
                GridViewPersonResult.Columns[0].Width = 80;
                GridViewPersonResult.Columns[1].Width = 80;
                GridViewPersonResult.Columns[2].Width = 80;
                GridViewPersonResult.Columns[3].Width = 80;
                GridViewPersonResult.Columns[4].Width = 120;
            }
            if (CheckUserName == "" && CheckNumber == "")
            {
                //调用gridviewcarresult方法
                this.gridviewcarresult();
            }
            if (CheckUserName !="" && CheckNumber != "")
            {
                //创建sql语句将信息从库中调出
                string sql = "select user_account as 员工帐号,user_name as 员工姓名,user_power as 权限,user_money as 基本工资,user_remark as 备注 from db_User where user_account = '" + CheckNumber + "'and user_name = '" + CheckUserName + "' ";
                //创建执行对象cmd
                SqlCommand cmd = new SqlCommand(sql, con);
                //创建读取器对象sdr
                SqlDataAdapter sdr = new SqlDataAdapter();
                //sdr的查询方法为cmd
                sdr.SelectCommand = cmd;
                //创建一个dataset容器
                DataSet ds = new DataSet();
                //填充数据ds
                sdr.Fill(ds);
                //绑定datagriview数据源为ds
                this.GridViewPersonResult.DataSource = ds.Tables[0].DefaultView;
                //关闭连接
                con.Close();
                GridViewPersonResult.Columns[0].Width = 80;
                GridViewPersonResult.Columns[1].Width = 80;
                GridViewPersonResult.Columns[2].Width = 80;
                GridViewPersonResult.Columns[3].Width = 80;
                GridViewPersonResult.Columns[4].Width = 120;
            }


        }
        #endregion
        #region 删除按钮
        private void btnUserDelete_Click(object sender, EventArgs e)
        {
            //获取选中的行的信息
            string row = this.GridViewPerson.CurrentRow.Cells[0].Value.ToString().Trim();
            DialogResult drm = MessageBox.Show("确定要删除此人信息吗？", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
            if (drm == DialogResult.OK)
            {
                //创建sql语句将信息从库中调出
                string sql = "delete db_User where user_account  = '" + row + "'";
                Car.ADU(sql);
                this.textNumber.Clear();
                this.textUserName.Clear();
                this.textPassWord.Clear();
                this.textUserMoney.Clear();
                this.textUserRemark.Clear();
                this.gridviewcar();
                MessageBox.Show("删除成功");
            }
            else
            {
                MessageBox.Show("请选择要删除的车辆");
            }
        }
        #endregion
        #region 修改按钮
        private void btnUserUpdate_Click(object sender, EventArgs e)
        {
            string Number = this.textNumber.Text.ToString().Trim();
            string UserName = this.textUserName.Text.ToString().Trim();
            string PassWord = this.textPassWord.Text.ToString().Trim();
            object Power = (object)this.textPower.SelectedItem;
            string UserMoney = this.textUserMoney.Text.ToString().Trim();
            string UserRemark = this.textUserRemark.Text.ToString().Trim();
            if (Number != "")
            {
                if (UserRemark != "")
                {
                    if (UserName != "")
                    {
                        if (PassWord != "")
                        {
                            if (UserMoney != "")
                            {
                                string sql = "update db_User set user_name ='" + UserName + "', user_pwd ='" + PassWord + "' , user_power='" + Power + "',user_money = '" + UserMoney + "',user_remark = '" + UserRemark + "' where user_account = '" + Number + "'";
                                Car.ADU(sql);
                                this.gridviewcar();
                                MessageBox.Show("修改成功");
                                this.textNumber.Clear();
                                this.textUserName.Clear();
                                this.textPassWord.Clear();
                                this.textUserMoney.Clear();
                                this.textUserRemark.Clear();
                            }
                            else
                            {

                                MessageBox.Show("请选择要修改的员工 ");

                            }

                        }
                        else
                        {
                            MessageBox.Show("请选择要修改的员工 ");
                        }
                    }
                    else
                    {
                        MessageBox.Show("请选择要修改的员工");
                    }

                }
                else
                {
                    MessageBox.Show("请选择要修改的员工");
                }

            }
            else
            {
                MessageBox.Show("请选择要修改的员工");
            }
           
        }
        #endregion
        #region 点击gridview后显示要修改的内容
       
          private void GridViewPerson_CellClick(object sender, DataGridViewCellEventArgs e)
         {
            //获取选中的行的信息
            this.textNumber.Text = GridViewPerson.CurrentRow.Cells[0].Value.ToString();
            this.textUserName.Text = GridViewPerson.CurrentRow.Cells[1].Value.ToString();
            this.textPassWord.Text = GridViewPerson.CurrentRow.Cells[2].Value.ToString();
            this.textPower.SelectedItem = GridViewPerson.CurrentRow.Cells[3].Value.ToString();
            this.textUserMoney.Text = GridViewPerson.CurrentRow.Cells[4].Value.ToString();
            this.textUserRemark.Text = GridViewPerson.CurrentRow.Cells[5].Value.ToString();
        }
           #endregion




    }
}