usermanagement.cs

C#2.0宝典源码,C#经典书籍,很多例子

using System;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using StudentsMIS.DataAccess;

namespace StudentsMIS.WinForm
{
	/// <summary>
	/// UserManagement 的摘要说明。
	/// </summary>
	public class UserManagement : System.Windows.Forms.Form
	{
    private System.Windows.Forms.Panel panel1;
    private System.Windows.Forms.Button btnApply;
    private System.Windows.Forms.Button btnDelete;
    private System.Windows.Forms.Button btnOK;
    private System.Windows.Forms.Button btnCancel;
    private System.Data.DataSet dataSetAdmin;
    private System.Data.DataTable dataTableAdmin;
    private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
    private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;
    private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn2;
    private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn3;
    private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn4;
    private System.Windows.Forms.DataGrid dataGridAdmin;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;
    private OleDbCommand objCommand;
    private OleDbDataAdapter objAdapter;
    private OleDbCommandBuilder objCommandBuilder;

		public UserManagement()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();
      objCommand = CommandBuilder.BuildOleDbCommand("Select * From admin");
      objAdapter = new OleDbDataAdapter(objCommand);
      objCommandBuilder = new OleDbCommandBuilder(objAdapter);
      objAdapter.InsertCommand = objCommandBuilder.GetInsertCommand();
      objAdapter.DeleteCommand = objCommandBuilder.GetDeleteCommand();
      objAdapter.UpdateCommand = objCommandBuilder.GetUpdateCommand();
      objAdapter.Fill(dataSetAdmin.Tables["Admins"]);
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
      this.dataGridAdmin = new System.Windows.Forms.DataGrid();
      this.dataSetAdmin = new System.Data.DataSet();
      this.dataTableAdmin = new System.Data.DataTable();
      this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
      this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
      this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
      this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
      this.dataGridTextBoxColumn4 = new System.Windows.Forms.DataGridTextBoxColumn();
      this.panel1 = new System.Windows.Forms.Panel();
      this.btnApply = new System.Windows.Forms.Button();
      this.btnDelete = new System.Windows.Forms.Button();
      this.btnOK = new System.Windows.Forms.Button();
      this.btnCancel = new System.Windows.Forms.Button();
      ((System.ComponentModel.ISupportInitialize)(this.dataGridAdmin)).BeginInit();
      ((System.ComponentModel.ISupportInitialize)(this.dataSetAdmin)).BeginInit();
      ((System.ComponentModel.ISupportInitialize)(this.dataTableAdmin)).BeginInit();
      this.SuspendLayout();
      // 
      // dataGridAdmin
      // 
      this.dataGridAdmin.CaptionVisible = false;
      this.dataGridAdmin.DataMember = "Admins";
      this.dataGridAdmin.DataSource = this.dataSetAdmin;
      this.dataGridAdmin.HeaderForeColor = System.Drawing.SystemColors.ControlText;
      this.dataGridAdmin.Location = new System.Drawing.Point(15, 15);
      this.dataGridAdmin.Name = "dataGridAdmin";
      this.dataGridAdmin.Size = new System.Drawing.Size(378, 216);
      this.dataGridAdmin.TabIndex = 0;
      this.dataGridAdmin.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
                                                                                              this.dataGridTableStyle1});
      // 
      // dataSetAdmin
      // 
      this.dataSetAdmin.DataSetName = "NewDataSet";
      this.dataSetAdmin.Locale = new System.Globalization.CultureInfo("zh-CN");
      this.dataSetAdmin.Tables.AddRange(new System.Data.DataTable[] {
                                                                      this.dataTableAdmin});
      // 
      // dataTableAdmin
      // 
      this.dataTableAdmin.TableName = "Admins";
      // 
      // dataGridTableStyle1
      // 
      this.dataGridTableStyle1.DataGrid = this.dataGridAdmin;
      this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
                                                                                                          this.dataGridTextBoxColumn1,
                                                                                                          this.dataGridTextBoxColumn2,
                                                                                                          this.dataGridTextBoxColumn3,
                                                                                                          this.dataGridTextBoxColumn4});
      this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
      this.dataGridTableStyle1.MappingName = "Admins";
      // 
      // dataGridTextBoxColumn1
      // 
      this.dataGridTextBoxColumn1.Format = "";
      this.dataGridTextBoxColumn1.FormatInfo = null;
      this.dataGridTextBoxColumn1.HeaderText = "用户ID";
      this.dataGridTextBoxColumn1.MappingName = "admin_ID";
      this.dataGridTextBoxColumn1.Width = 75;
      // 
      // dataGridTextBoxColumn2
      // 
      this.dataGridTextBoxColumn2.Format = "";
      this.dataGridTextBoxColumn2.FormatInfo = null;
      this.dataGridTextBoxColumn2.HeaderText = "用户姓名";
      this.dataGridTextBoxColumn2.MappingName = "admin_name";
      this.dataGridTextBoxColumn2.Width = 75;
      // 
      // dataGridTextBoxColumn3
      // 
      this.dataGridTextBoxColumn3.Format = "";
      this.dataGridTextBoxColumn3.FormatInfo = null;
      this.dataGridTextBoxColumn3.HeaderText = "用户权限";
      this.dataGridTextBoxColumn3.MappingName = "admin_level";
      this.dataGridTextBoxColumn3.Width = 75;
      // 
      // dataGridTextBoxColumn4
      // 
      this.dataGridTextBoxColumn4.Format = "";
      this.dataGridTextBoxColumn4.FormatInfo = null;
      this.dataGridTextBoxColumn4.HeaderText = "用户密码";
      this.dataGridTextBoxColumn4.MappingName = "admin_password";
      this.dataGridTextBoxColumn4.Width = 75;
      // 
      // panel1
      // 
      this.panel1.BackColor = System.Drawing.SystemColors.GrayText;
      this.panel1.Location = new System.Drawing.Point(12, 240);
      this.panel1.Name = "panel1";
      this.panel1.Size = new System.Drawing.Size(472, 1);
      this.panel1.TabIndex = 1;
      // 
      // btnApply
      // 
      this.btnApply.Location = new System.Drawing.Point(408, 16);
      this.btnApply.Name = "btnApply";
      this.btnApply.TabIndex = 2;
      this.btnApply.Text = "应用";
      this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
      // 
      // btnDelete
      // 
      this.btnDelete.Location = new System.Drawing.Point(408, 48);
      this.btnDelete.Name = "btnDelete";
      this.btnDelete.TabIndex = 3;
      this.btnDelete.Text = "删除";
      this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
      // 
      // btnOK
      // 
      this.btnOK.Location = new System.Drawing.Point(320, 256);
      this.btnOK.Name = "btnOK";
      this.btnOK.TabIndex = 4;
      this.btnOK.Text = "确定";
      this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
      // 
      // btnCancel
      // 
      this.btnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
      this.btnCancel.Location = new System.Drawing.Point(408, 256);
      this.btnCancel.Name = "btnCancel";
      this.btnCancel.TabIndex = 5;
      this.btnCancel.Text = "取消";
      this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
      // 
      // UserManagement
      // 
      this.AcceptButton = this.btnApply;
      this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
      this.CancelButton = this.btnCancel;
      this.ClientSize = new System.Drawing.Size(496, 294);
      this.Controls.Add(this.btnCancel);
      this.Controls.Add(this.btnOK);
      this.Controls.Add(this.btnDelete);
      this.Controls.Add(this.btnApply);
      this.Controls.Add(this.panel1);
      this.Controls.Add(this.dataGridAdmin);
      this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
      this.HelpButton = true;
      this.MaximizeBox = false;
      this.MinimizeBox = false;
      this.Name = "UserManagement";
      this.ShowInTaskbar = false;
      this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
      this.Text = "系统用户管理";
      this.Closed += new System.EventHandler(this.UserManagement_Closed);
      ((System.ComponentModel.ISupportInitialize)(this.dataGridAdmin)).EndInit();
      ((System.ComponentModel.ISupportInitialize)(this.dataSetAdmin)).EndInit();
      ((System.ComponentModel.ISupportInitialize)(this.dataTableAdmin)).EndInit();
      this.ResumeLayout(false);

    }
		#endregion

    private void btnApply_Click(object sender, System.EventArgs e)
    {
      try
      {
        objAdapter.Update(dataSetAdmin,"Admins");
      }
      catch(Exception e1)
      {
        MessageBox.Show(e1.Message);
      }
    }

    private void btnDelete_Click(object sender, System.EventArgs e)
    {
      dataSetAdmin.Tables["Admins"].Rows[dataGridAdmin.CurrentRowIndex].Delete();
      dataSetAdmin.Tables["Admins"].AcceptChanges();
    }

    private void btnOK_Click(object sender, System.EventArgs e)
    {
      try
      {
        objAdapter.Update(dataSetAdmin,"Admins");
      }
      catch(Exception e1)
      {
        MessageBox.Show(e1.Message);
        return;
      }
      this.Close();
    }

    private void UserManagement_Closed(object sender, System.EventArgs e)
    {
      this.Dispose();
      System.GC.Collect();
    }

    private void btnCancel_Click(object sender, System.EventArgs e)
    {
      this.Close();
    }
	}
}