setusers.cs

食堂就餐提醒系统(含源码) 为一个单位开发的

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;

using System.Data;

namespace XFMAS.Admin
{
	/// <summary>
	/// SetUsers 的摘要说明。
	/// </summary>
	public class SetUsers : System.Windows.Forms.Form
	{
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.ListView listView1;
		private System.Windows.Forms.ColumnHeader columnHeader1;
		private System.Windows.Forms.ColumnHeader columnHeader2;
		private System.Windows.Forms.ColumnHeader columnHeader3;
		private System.Windows.Forms.ContextMenu contextMenu1;
		private System.Windows.Forms.MenuItem menuItem1;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.TextBox userID;
		private System.Windows.Forms.TextBox ip;
		private System.Windows.Forms.ColumnHeader columnHeader4;
		private System.Windows.Forms.MenuItem menuItem2;
		private System.Windows.Forms.MenuItem menuItem3;
		private System.Windows.Forms.MenuItem menuItem4;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public SetUsers()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			this.LoadUsers();

			this.menuItem1.Enabled = false;

			if(!Public.CheckIsRule("R_002")){
				this.menuItem2.Enabled = false;
				this.menuItem3.Enabled = false;
			}
		}

		/// <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.groupBox1 = new System.Windows.Forms.GroupBox();
			this.listView1 = new System.Windows.Forms.ListView();
			this.columnHeader1 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader2 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader3 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader4 = new System.Windows.Forms.ColumnHeader();
			this.contextMenu1 = new System.Windows.Forms.ContextMenu();
			this.menuItem1 = new System.Windows.Forms.MenuItem();
			this.menuItem4 = new System.Windows.Forms.MenuItem();
			this.menuItem2 = new System.Windows.Forms.MenuItem();
			this.menuItem3 = new System.Windows.Forms.MenuItem();
			this.label1 = new System.Windows.Forms.Label();
			this.userID = new System.Windows.Forms.TextBox();
			this.ip = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.button1 = new System.Windows.Forms.Button();
			this.button2 = new System.Windows.Forms.Button();
			this.groupBox1.SuspendLayout();
			this.SuspendLayout();
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.listView1);
			this.groupBox1.Location = new System.Drawing.Point(8, 8);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(544, 240);
			this.groupBox1.TabIndex = 0;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "用户->IP列表";
			// 
			// listView1
			// 
			this.listView1.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
																						this.columnHeader1,
																						this.columnHeader2,
																						this.columnHeader3,
																						this.columnHeader4});
			this.listView1.ContextMenu = this.contextMenu1;
			this.listView1.Dock = System.Windows.Forms.DockStyle.Fill;
			this.listView1.FullRowSelect = true;
			this.listView1.Location = new System.Drawing.Point(3, 17);
			this.listView1.MultiSelect = false;
			this.listView1.Name = "listView1";
			this.listView1.Size = new System.Drawing.Size(538, 220);
			this.listView1.TabIndex = 0;
			this.listView1.View = System.Windows.Forms.View.Details;
			this.listView1.Click += new System.EventHandler(this.listView1_Click);
			this.listView1.SelectedIndexChanged += new System.EventHandler(this.listView1_SelectedIndexChanged);
			// 
			// columnHeader1
			// 
			this.columnHeader1.Text = "用户名";
			this.columnHeader1.Width = 115;
			// 
			// columnHeader2
			// 
			this.columnHeader2.Text = "姓名";
			this.columnHeader2.Width = 147;
			// 
			// columnHeader3
			// 
			this.columnHeader3.Text = "IP地址";
			this.columnHeader3.Width = 204;
			// 
			// columnHeader4
			// 
			this.columnHeader4.Text = "管理员";
			// 
			// contextMenu1
			// 
			this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
																						 this.menuItem1,
																						 this.menuItem4,
																						 this.menuItem2,
																						 this.menuItem3});
			// 
			// menuItem1
			// 
			this.menuItem1.Index = 0;
			this.menuItem1.Text = "删除(&D)";
			this.menuItem1.Click += new System.EventHandler(this.menuItem1_Click);
			// 
			// menuItem4
			// 
			this.menuItem4.Index = 1;
			this.menuItem4.Text = "-";
			// 
			// menuItem2
			// 
			this.menuItem2.Index = 2;
			this.menuItem2.Text = "设置管理员/权限(&A)";
			this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
			// 
			// menuItem3
			// 
			this.menuItem3.Index = 3;
			this.menuItem3.Text = "移除管理员(&R)";
			this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(8, 264);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(56, 16);
			this.label1.TabIndex = 1;
			this.label1.Text = "用户名：";
			// 
			// userID
			// 
			this.userID.Location = new System.Drawing.Point(64, 256);
			this.userID.Name = "userID";
			this.userID.TabIndex = 2;
			this.userID.Text = "";
			// 
			// ip
			// 
			this.ip.Location = new System.Drawing.Point(224, 256);
			this.ip.Name = "ip";
			this.ip.Size = new System.Drawing.Size(112, 21);
			this.ip.TabIndex = 4;
			this.ip.Text = "";
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(168, 264);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(56, 16);
			this.label2.TabIndex = 3;
			this.label2.Text = "IP地址：";
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(344, 256);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(64, 23);
			this.button1.TabIndex = 5;
			this.button1.Text = "查 找";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(408, 256);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(144, 23);
			this.button2.TabIndex = 6;
			this.button2.Text = "注册IP地址到服务器";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// SetUsers
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(560, 293);
			this.Controls.Add(this.button2);
			this.Controls.Add(this.button1);
			this.Controls.Add(this.ip);
			this.Controls.Add(this.label2);
			this.Controls.Add(this.userID);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.groupBox1);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "SetUsers";
			this.ShowInTaskbar = false;
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "管理用户&IP";
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// 注册IP地址到服务器
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void button2_Click(object sender, System.EventArgs e) {

			XFMAS.RegisterIP ri = new RegisterIP();
			ri.ShowDialog();

			//重新载入用户
			this.LoadUsers();
		}

		/// <summary>
		/// 载入用户
		/// </summary>
		private void LoadUsers(){
			
			this.listView1.Items.Clear();

			if(this.ip.Text.Trim().Length > 0){
				
				string ipStr = this.ip.Text.Trim();
				string[] xx = ipStr.Split('.');
				for(int i=0;i<xx.Length;i++){
					string xxx = xx[i].ToString();
					try{
						if(xxx.Length > 3) throw new Exception("IP输入不符合要求");
						int __xx = Int32.Parse(xxx);
					}catch{
						MessageBox.Show("IP地址输入不正确！");
						return;
					}
				}

			}

			//获取用户并填充
			try{
				DataSet ds = DBConn.UsersIPs(this.userID.Text.Trim(),this.ip.Text.Trim());

				foreach(DataRow row in ds.Tables[0].Rows){
					
					ListViewItem lvi = new ListViewItem(new string[]{row["username"].ToString(),DBConn.GetUserRealName(row["username"].ToString()),row["userIP"].ToString(),row["isAdmin"].ToString().Replace("0","").Replace("1","√")});
					lvi.Tag = row["autoID"].ToString();
					this.listView1.Items.Add(lvi);
				}

			}catch(Exception ex){
				MessageBox.Show("载入数据时出错：" + ex.Message.ToString());
				return;
			}
		}

		/// <summary>
		/// 重新载入用户列表
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void button1_Click(object sender, System.EventArgs e) {
			this.LoadUsers();
		}

		/// <summary>
		/// 删除
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void listView1_SelectedIndexChanged(object sender, System.EventArgs e) {
			if(this.listView1.SelectedItems.Count == 1){
				this.menuItem1.Enabled = true;
			}else{
				this.menuItem1.Enabled = false;
			}
		}

		/// <summary>
		/// 删除菜单
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void listView1_Click(object sender, System.EventArgs e) {
			if(this.listView1.SelectedItems.Count == 1){
				this.menuItem1.Enabled = true;
			}else{
				this.menuItem1.Enabled = false;
			}
		}

		/// <summary>
		/// 删除
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void menuItem1_Click(object sender, System.EventArgs e) {
			if(this.listView1.SelectedItems.Count == 1){
				string autoID = this.listView1.SelectedItems[0].Tag.ToString();
				string delResult = DBConn.DelUserIp(autoID);
				if(delResult != "OK"){
					MessageBox.Show(delResult);
					return;
				}else{
					this.listView1.Items.Remove(this.listView1.SelectedItems[0]);
				}
			}
		}

		/// <summary>
		/// 加为管理员
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void menuItem2_Click(object sender, System.EventArgs e) {
			if(this.listView1.SelectedItems.Count == 1){
				string autoID = this.listView1.SelectedItems[0].Tag.ToString();

				SetRuleCode src = new SetRuleCode();

				string userID = this.listView1.SelectedItems[0].SubItems[0].Text;

				src.SetRuleCodeStr(DBConn.GetAdminRuleCode(userID));

				src.ShowDialog();

				string delResult = DBConn.UpdateUserAdmin(autoID,"1");

				if(delResult != "OK"){
					MessageBox.Show(delResult);
					return;
				}else{
					if(src.ruleCodeStr != null){
						delResult = DBConn.UpdateAdminRuleCode(userID,src.ruleCodeStr);
					}

					if(delResult != "OK"){
						MessageBox.Show(delResult);
						return;
					}else{
						this.listView1.SelectedItems[0].SubItems[3].Text = "√";
					}
				}
			}
		}

		/// <summary>
		/// 移除管理员
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void menuItem3_Click(object sender, System.EventArgs e) {
			if(this.listView1.SelectedItems.Count == 1){
				string autoID = this.listView1.SelectedItems[0].Tag.ToString();

				string userID = this.listView1.SelectedItems[0].SubItems[0].Text;

				string delResult = DBConn.DeleteAdminRuleCode(userID);
				if(delResult == "OK"){
					delResult = DBConn.UpdateUserAdmin(autoID,"0");
					if(delResult != "OK"){
						MessageBox.Show(delResult);
						return;
					}else{
						this.listView1.SelectedItems[0].SubItems[3].Text = "";
					}
				}else{
					MessageBox.Show(delResult);
					return;
				}
			}
		}
	}
}