cdlgws.cs

功能设计：平台管理、收费点维护、收费项目管理、缴费管理

using System;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.OracleClient;
using GlobleUtility;

namespace Charge
{
	/// <summary>
	/// CdlgWs 的摘要说明。
	/// </summary>
	public class CdlgWs : System.Windows.Forms.Form
	{
		private System.Windows.Forms.ListView lvWs;//视图列表控件
		private System.Windows.Forms.Button btnAdd;//“增加”按钮
		private System.Windows.Forms.Button btnExit;//“退出”按钮
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

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

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
			//设置ListView显示格式
			//设置ListView控件显示属性
			lvWs.BeginUpdate();//防止闪烁
			lvWs.FullRowSelect =true;  //整行选择
			lvWs.HideSelection = false; //当listview没有焦点时，选定项是否仍然突出显示
			lvWs.View=View.Details;  
			lvWs.GridLines=true; 
			lvWs.Clear();

			string[] Field = {"工作站ID","工作站IP"};
			for (int i = 0; i <= 1; i++)
			{
				lvWs.Columns.Add(Field[i], 80, HorizontalAlignment.Center);
			}
			//设定各列长度
			lvWs.Columns[0].Width =100;
			lvWs.Columns[1].Width =100;
			
			lvWs.EndUpdate();
		}

		/// <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.lvWs = new System.Windows.Forms.ListView();
			this.btnAdd = new System.Windows.Forms.Button();
			this.btnExit = new System.Windows.Forms.Button();
			this.SuspendLayout();
			// 
			// lvWs
			// 
			this.lvWs.BackColor = System.Drawing.SystemColors.Info;
			this.lvWs.Location = new System.Drawing.Point(0, 0);
			this.lvWs.Name = "lvWs";
			this.lvWs.Size = new System.Drawing.Size(272, 97);
			this.lvWs.TabIndex = 0;
			// 
			// btnAdd
			// 
			this.btnAdd.Location = new System.Drawing.Point(32, 112);
			this.btnAdd.Name = "btnAdd";
			this.btnAdd.TabIndex = 1;
			this.btnAdd.Text = "增加";
			this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
			// 
			// btnExit
			// 
			this.btnExit.Location = new System.Drawing.Point(160, 112);
			this.btnExit.Name = "btnExit";
			this.btnExit.TabIndex = 2;
			this.btnExit.Text = "退出";
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// CdlgWs
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(274, 138);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.btnAdd);
			this.Controls.Add(this.lvWs);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
			this.Name = "CdlgWs";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "工作站管理";
			this.Load += new System.EventHandler(this.CdlgWs_Load);
			this.ResumeLayout(false);

		}
		#endregion
        //页面载入函数,导入已经存在的工作站信息
		private void CdlgWs_Load(object sender, System.EventArgs e)
		{
			//页面载入函数,导入已经存在的工作站信息
			System.Data.OracleClient.OracleConnection myconn = Connection.DBConnection;
			if(myconn==null)
			{
				return;
			}
			string mysql="select wsid,IPAddr from charge_ws_info";
			OracleCommand mycommand=new OracleCommand(mysql, myconn);
			OracleDataReader myreader=null;
			try
			{
				myreader = mycommand.ExecuteReader();
			}
			catch(Exception ee)
			{
				MessageBox.Show("数据库查询出错，消息如下：\r\n"+ee.Message,"消息：",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				return;
			}
			//将工作站信息逐条加入ListView控件
			while(myreader.Read())
			{
				ListViewItem lvi=null;
				lvi=lvWs.Items.Add(Convert.ToString(myreader.GetInt32(0)));
				lvi.SubItems.Add(myreader.GetString(1));
				
			}
			myreader.Close();
			myreader.Dispose();
			myconn.Close();

		}
        //增加工作站
		private void btnAdd_Click(object sender, System.EventArgs e)
		{
		     CdlgAddWs dlgAddWs=new CdlgAddWs();
			if(dlgAddWs.ShowDialog()==DialogResult.OK)//新增工作站数据库操作成功
			{
				//将新增工作站信息添加进ListView控件
				ListViewItem lvi=null;
				lvi=lvWs.Items.Add(dlgAddWs.ID.ToString());
				lvi.SubItems.Add(dlgAddWs.IP);
				lvi.Selected=true;//设为选中状态
			}
		}

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