formcompetenceinfo.cs

数据库开发与实例（1+1混合数据库开发实例丛书）人事管理系统的源代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace HRMan.SysOper
{
    public partial class FormCompetenceInfo : Form
    {
        public FormCompetenceInfo()
        {
            InitializeComponent();
           
        }

        private void FormCompetenceInfo_Load(object sender, EventArgs e)
        {
            DBDataGrid();
            
        }
    
        public void DBDataGrid()
        {
            string SqlText = "select uId as 用户ID ,uName as 用户名称,uPower as 用户权限 from UserInfo";
            DataAccess DA = new DataAccess();
            this.dt = DA.ExeSQLdt(SqlText);
            this.dataGrid1.Columns.Clear();
            
            //combobox数据源。。。 
            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("权限", typeof(string)));

            DataRow row = dt.NewRow();
            row[0] = "系统管理员";
            dt.Rows.Add(row);

            DataRow row2 = dt.NewRow();
            row2[0] = "普通用户";
            dt.Rows.Add(row2);

            dt.AcceptChanges();

            //DataGridView列 
            DataGridViewComboBoxColumn cbc = new DataGridViewComboBoxColumn();
            cbc.DataSource = dt;
            cbc.DisplayMember = "权限";
            cbc.ValueMember = "权限";
            cbc.DataPropertyName = "权限";
            cbc.HeaderText = "权限";

            DataGridViewTextBoxColumn cid = new DataGridViewTextBoxColumn();
            cid.HeaderText = "用户ID";
            cid.DataPropertyName = "用户ID";

            DataGridViewTextBoxColumn cname = new DataGridViewTextBoxColumn();
            cname.HeaderText = "用户名称";
            cname.DataPropertyName = "用户名称";

            this.dataGrid1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { cid, cname, cbc });

            //DataGridView数据源 
            DataTable dtSource = new DataTable();
            dtSource.Columns.Add("用户ID", typeof(Int32));
            dtSource.Columns.Add("用户名称", typeof(string));
            dtSource.Columns.Add("权限", typeof(string));

            foreach (DataRow forrow in this.dt.Rows)
            {
                DataRow r1 = dtSource.NewRow();
                r1[0] = forrow[0];
                r1[1] = forrow[1];
                r1[2] = forrow[2];
                dtSource.Rows.Add(r1);
                dtSource.AcceptChanges();
            }
            
            this.dataGrid1.DataSource = dtSource;
            this.dataGrid1.Columns[0].ReadOnly = true;
            this.dataGrid1.Columns[1].ReadOnly = true;
            if (this.dataGrid1.Rows.Count != 0)
            {
                for (int i = 0; i < this.dataGrid1.Rows.Count; )
                {
                    this.dataGrid1.Rows[i].DefaultCellStyle.BackColor = System.Drawing.Color.Pink;
                    i += 2;
                }
            }
        }

        

        private void dataGrid1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            MessageBox.Show(dataGrid1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
            string SqlText = "update UserInfo set uPower = '" + dataGrid1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()+"' where uId =" + this.dataGrid1.Rows[e.RowIndex].Cells[0].Value ;
            DataAccess DA = new DataAccess();
            DA.ExeSQL(SqlText);
            DBDataGrid();

        }
       
    }
}