frmjail.cs

很久 宏观经济韩国锦湖国家交换机海关核发个回复光滑

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Imaging;
using HallySoft.Runtime.Database;
using HallySoft.RFID;
using System.IO;

namespace UtAbmsRFID
{
	public partial class frmJail : DevComponents.DotNetBar.Office2007Form
	{
		bool isDraw = false;
		bool isNew = false;
		PictureBox dd;
		Device dev;
		int JailID = 0;
		string wzmc = "";
		int DeviceID = 0;
		int MapID = 0;

		public frmJail()
		{
			InitializeComponent();
		}

		private void frmJail_Resize(object sender, EventArgs e)
		{
			panel1.Left = this.Width / 2 - panel1.Width / 2;
			panel2.Left = this.Width / 2 - panel2.Width / 2;
			panel3.Left = this.Width / 2 - panel3.Width / 2;
			panel4.Left = this.Width / 2 - panel4.Width / 2;
		}

		private void buttonX6_Click(object sender, EventArgs e)
		{
			//添加
			JailDistrict jd = new JailDistrict();
			jd.Class = cbxJailClass.SelectedIndex;
			jd.Name = txtJailName.Text.Trim();
			jd.Number = txtJailNumber.Text.Trim();
			jd.Police = cbxJailPolice.SelectedIndex;
			jd.Remarks = txtJailRemarks.Text.Trim();
			jd.Jail = txtJailJail.Text.Trim();

			if (jd.Name == "")
			{
				MessageBox.Show("请输入监区名称!");
				txtJailName.Focus();
				return;
			}

			if (jd.Number == "")
			{
				MessageBox.Show("请输入监区编号!");
				txtJailNumber.Focus();
				return;
			}

			if (jd.AddRecord())
				MessageBox.Show("添加监区成功!");
		}

		private void buttonX7_Click(object sender, EventArgs e)
		{
			//应用
			if (JailID == 0) return;
			JailDistrict jd = new JailDistrict();
			jd.ID = JailID;
			jd.Class = cbxJailClass.SelectedIndex;
			jd.Name = txtJailName.Text.Trim();
			jd.Number = txtJailNumber.Text.Trim();
			jd.Police = cbxJailPolice.SelectedIndex;
			jd.Remarks = txtJailRemarks.Text.Trim();
			jd.Jail = txtJailJail.Text.Trim();

			if (jd.Name == "")
			{
				MessageBox.Show("请输入监区名称!");
				txtJailName.Focus();
				return;
			}

			if (jd.Number == "")
			{
				MessageBox.Show("请输入监区编号!");
				txtJailNumber.Focus();
				return;
			}

			jd.UpDate();
			Program.fm.GetInfo();
		}

		private void buttonX5_Click(object sender, EventArgs e)
		{
			//取消
			JailID = 0;
			cbxJailClass.SelectedIndex = 0;
			txtJailName.Text = "";
			txtJailNumber.Text = "";
			cbxJailPolice.SelectedIndex = 0;
			txtJailRemarks.Text = "";
			txtJailJail.Text = "";
			this.Close();
		}

		private void frmJail_Load(object sender, EventArgs e)
		{
			SqlAccess saa = new SqlAccess();
			saa.ConnectionString = AppInfo.ConnStr;
			SqlDataReader sdr = saa.SQLReader("select [name] from [Jail] order by [ID] asc");
			cbxJailClass.Items.Clear();
			cbxJailClass.Items.Add("==顶级监区==");
			while (sdr.Read())
			{
				cbxJailClass.Items.Add("==" + sdr.GetString(0) + "==");
			}
			cbxJailClass.SelectedIndex = 0;
			sdr.Dispose();
			sdr = saa.SQLReader("select [name] from [Police] order by [ID] asc");
			cbxJailPolice.Items.Clear();
			cbxJailPolice.Items.Add("==请选择警员==");
			while (sdr.Read())
			{
				cbxJailPolice.Items.Add("==" + sdr.GetString(0) + "==");
			}
			cbxJailPolice.SelectedIndex = 0;
			sdr.Dispose();
		}

		public void setTab(int tt)
		{
			switch (tt)
			{
				case 1:
					tabControl2.SelectedTab = tabMap;
					break;
				case 2:
					tabControl2.SelectedTab = tabDevice;
					break;
				default:
					tabControl2.SelectedTab = tabBase;
					break;
			}
		}

		public void GetInfo(string name)
		{
			JailDistrict jd = new JailDistrict();
			jd.GetInfo(name);
			JailID = jd.ID;
			cbxJailClass.SelectedIndex = jd.Class;
			txtJailName.Text = jd.Name;
			txtDeviceName.Text = jd.Name;
			txtJailNumber.Text = jd.Number;
			cbxJailPolice.SelectedIndex = jd.Police;
			txtJailRemarks.Text = jd.Remarks;
			txtJailJail.Text = jd.Jail;
			jd = null;
			SqlAccess saa = new SqlAccess();
			saa.ConnectionString = AppInfo.ConnStr;
			SqlDataReader sdr = saa.SQLReader("select * from [MapInfo] where [Jail]=" + JailID + " order by [ID] asc");
			lstMap.Items.Clear();
			while (sdr.Read())
			{
				lstMap.Items.Add(sdr.GetInt32(0).ToString() + ":" + sdr.GetString(2));
			}
			saa.Dispose();
			sdr.Dispose();
		}

		private void buttonX9_Click(object sender, EventArgs e)
		{
			if (JailID == 0)
			{
				MessageBox.Show("请先选择或创建监区!", "错误!", MessageBoxButtons.OK, MessageBoxIcon.Error);
				return;
			}
			else
			{
				openFile.ShowDialog();
				if (openFile.FileName == "")
					return;

				try
				{
					Image map = Image.FromFile(openFile.FileName);
					picMap.BackgroundImage = map;
					MapInfo mi = new MapInfo();
					mi.Jail = JailID;
					mi.Name = txtMapName.Text.Trim();
					mi.Type = cbxMapType.SelectedIndex;
					mi.Content = map;

					if (mi.Name == "")
					{
						MessageBox.Show("请输入地图名称!", "错误!", MessageBoxButtons.OK, MessageBoxIcon.Error);
						txtMapName.Focus();
						return;
					}

					if (mi.AddRecord() == false)
					{
						MessageBox.Show("保存地图信息失败!", "错误!", MessageBoxButtons.OK, MessageBoxIcon.Error);
						return;
					}
				}
				catch
				{
					MessageBox.Show("读取图片错误!", "错误!", MessageBoxButtons.OK, MessageBoxIcon.Error);
				}
				GetMap();
			}
		}

		private void GetMap()
		{
			SqlAccess saa = new SqlAccess();
			saa.ConnectionString = AppInfo.ConnStr;
			SqlDataReader sdr = saa.SQLReader("select * from [MapInfo] where [Jail]=" + JailID + " order by [ID] asc");
			lstMap.Items.Clear();
			while (sdr.Read())
			{
				lstMap.Items.Add(sdr.GetInt32(0).ToString() + ":" + sdr.GetString(2));
			}
			saa.Dispose();
			sdr.Dispose();
		}

		private void buttonX8_Click(object sender, EventArgs e)
		{
			MapInfo mapinfo = new MapInfo();
			if(mapinfo.Delete(MapID))
				MessageBox.Show("删除地图成功!", "删除地图成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
			else
				MessageBox.Show("删除地图失败!", "删除地图失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
			GetMap();
		}

		private void AddDevice_Click(object sender, EventArgs e)
		{
			//添加设备
			if (JailID == 0)
			{
				MessageBox.Show("请先选择或创建监区!");
				return;
			}
			else
			{
				wzmc = "";
				dd = new PictureBox();
				dd.Parent = picMap;
				dd.Visible = false;
				dd.Width = picDevice.Width;
				dd.Height = picDevice.Height;
				dd.Image = picDevice.Image;
				dd.Left = 10;
				dd.Top = 10;
				dd.Click += new EventHandler(DeviceClick);
				isNew = true;
			}
		}

		public void DeviceClick(object sender, EventArgs e)
		{
			if (isDraw)
			{
				isDraw = false;
			}
			else
			{
				isDraw = true;
				dd = (PictureBox)sender;
			}
		}

		private void DelDevice_Click(object sender, EventArgs e)
		{
			if (DeviceID != 0)
			{
				Device d = new Device();
				d.Delete(DeviceID);
				txtDeviceActive.Text = "";
				txtDeviceArea.Text = "";
				txtDeviceX.Text = "";
				txtDeviceY.Text = "";
				txtDeviceReceiveID.Text = "";
				txtDeviceReceiveIP.Text = "";
				txtDeviceMe.Text = "";
				GetAllDevice();
			}
		}

		private void SaveDevice_Click(object sender, EventArgs e)
		{
			//保存设备
			if (wzmc == "")
			{
				dev = new Device();
				dev.Jail = JailID;
				dev.Activate = txtDeviceActive.Text.Trim();
				dev.Position = txtDeviceArea.Text.Trim();
				dev.X = Convert.ToInt32(txtDeviceX.Text.Trim());
				dev.Y = Convert.ToInt32(txtDeviceY.Text.Trim());
				dev.ReceiveID = txtDeviceReceiveID.Text.Trim();
				dev.ReceiveIP = txtDeviceReceiveIP.Text.Trim();
				dev.LookMe = txtDeviceMe.Text.Trim();
				if (dev.AddRecord())
					MessageBox.Show("添加成功!", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
				else
					MessageBox.Show("添加失败!", "添加失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
				txtDeviceActive.Text = "";
				txtDeviceArea.Text = "";
				txtDeviceX.Text = "";
				txtDeviceY.Text = "";
				txtDeviceReceiveID.Text = "";
				txtDeviceReceiveIP.Text = "";
				txtDeviceMe.Text = "";
				GetAllDevice();
			}
			else
			{
				dev = new Device();
				dev.Jail = JailID;
				dev.ID = DeviceID;
				dev.Position = wzmc;
				dev.Activate = txtDeviceActive.Text.Trim();
				dev.X = Convert.ToInt32(txtDeviceX.Text.Trim());
				dev.Y = Convert.ToInt32(txtDeviceY.Text.Trim());
				dev.ReceiveID = txtDeviceReceiveID.Text.Trim();
				dev.ReceiveIP = txtDeviceReceiveIP.Text.Trim();
				dev.LookMe = txtDeviceMe.Text.Trim();
				if (dev.UpDate())
					MessageBox.Show("保存成功!", "保存成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
				else
					MessageBox.Show("保存失败!", "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
			}
		}

		private void picMap_MouseUp(object sender, MouseEventArgs e)
		{
			if (isDraw)
			{
				dd.Left = e.X - 7;
				dd.Top = e.Y - 7;
				isDraw = false;
				isNew = false;
				txtDeviceX.Text = (e.X - 7).ToString();
				txtDeviceY.Text = (e.Y - 7).ToString();
			}
		}

		private void picMap_MouseMove(object sender, MouseEventArgs e)
		{
			//
			if (isDraw)
			{
				dd.Left = e.X - 7;
				dd.Top = e.Y - 7;
				txtDeviceX.Text = (e.X - 7).ToString();
				txtDeviceY.Text = (e.Y - 7).ToString();
			}
		}

		private void picMap_MouseDown(object sender, MouseEventArgs e)
		{
			if (isNew)
			{
				isDraw = true;
				dd.Visible = true;
				dd.Left = e.X - 7;
				dd.Top = e.Y - 7;
				txtDeviceX.Text = (e.X - 7).ToString();
				txtDeviceY.Text = (e.Y - 7).ToString();
			}
		}

		public void GetAllDevice()
		{
			picMap.Controls.Clear();
			SqlAccess saa = new SqlAccess();
			saa.ConnectionString = AppInfo.ConnStr;
			SqlDataReader sdr = saa.SQLReader("select * from [Device] where [Jail]=" + JailID + " order by [ID] asc");
			while (sdr.Read())
			{
				dd = new PictureBox();
				dd.Name = sdr.GetInt32(0).ToString() + ":" + sdr.GetString(2).Trim();
				dd.Parent = picMap;
				dd.Visible = true;
				dd.Width = picDevice.Width;
				dd.Height = picDevice.Height;
				dd.Image = picDevice.Image;
				dd.Left = (int)sdr.GetInt32(3);
				dd.Top = (int)sdr.GetInt32(4);
				dd.Click += new EventHandler(Device_Click);
			}
			saa.Dispose();
			sdr.Dispose();
		}

		public void Device_Click(object sender, EventArgs e)
		{
			if (isDraw)
			{
				isDraw = false;
			}
			else
			{
				isDraw = true;
				dd = (PictureBox)sender;
				dev = new Device();
				DeviceID = Convert.ToInt32(dd.Name.Substring(0, dd.Name.IndexOf(':')));
				dev.GetInfo(DeviceID);
				txtDeviceActive.Text = dev.Activate;
				txtDeviceArea.Text = dev.Position;
				wzmc = dev.Position;
				txtDeviceX.Text = dev.X.ToString();
				txtDeviceY.Text = dev.Y.ToString();
				txtDeviceReceiveID.Text = dev.ReceiveID;
				txtDeviceReceiveIP.Text = dev.ReceiveIP;
				txtDeviceMe.Text = dev.LookMe;
			}
		}

		private void tabDevice_Click(object sender, EventArgs e)
		{
			GetAllDevice();
		}

		private void tabMap_Click(object sender, EventArgs e)
		{
			picMap.Controls.Clear();
		}

		private void tabBase_Click(object sender, EventArgs e)
		{
			picMap.Controls.Clear();
		}

		private void lstMap_Click(object sender, EventArgs e)
		{
			MapID = Convert.ToInt32(lstMap.SelectedItem.ToString().Substring(0, lstMap.SelectedItem.ToString().IndexOf(':')));
		}

		private void lstMap_DoubleClick(object sender, EventArgs e)
		{
			MapInfo mapinfo = new MapInfo();
			mapinfo.GetInfo(MapID);
			picMap.BackgroundImage = mapinfo.Content;
			mapinfo = null;
		}
	}
}