frmprisoner.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 HallySoft.Runtime.Database;
using HallySoft.RFID;

namespace UtPiowmsRFID
{
	public partial class frmPrisoner : DevComponents.DotNetBar.Office2007Form
	{
		public frmPrisoner()
		{
			InitializeComponent();
		}

		private void frmPrisoner_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;
			panel5.Left = this.Width / 2 - panel5.Width / 2;
		}

		private void buttonX18_Click(object sender, EventArgs e)
		{
			//添加
			Prisoner ppp = new Prisoner();
			string pw1 = "";
			ppp.Number = txtPrisonerNumber.Text.Trim();
			ppp.WDNumber = txtPrisonerWDNumber.Text.Trim();
			ppp.Name = txtPrisonerName.Text.Trim();
			ppp.Sex = cbxPrisonerSex.SelectedIndex;
			ppp.CardType = cbxPrisonerCardType.SelectedIndex;
			ppp.CardNum = txtPrisonerCardNum.Text.Trim();
			ppp.CardClass = cbxPrisonerCardClass.SelectedIndex;
			ppp.State = cbxPrisonerState.SelectedIndex;
			ppp.InTime = tmePrisonerInTime.Value;
			ppp.Jail = txtPrisonerJail.SelectedIndex;
			ppp.CardAddress = txtPrisonerCardAddress.Text.Trim();
			ppp.Postal = txtPrisonerPostal.Text.Trim();
			ppp.Address = txtPrisonerAddress.Text.Trim();
			ppp.PostalCode = txtPrisonerPostalCode.Text.Trim();
			ppp.Phone = txtPrisonerPhone.Text.Trim();
			ppp.Remarks = txtPrisonerRemarks.Text.Trim();
			ppp.Resume = txtPrisonerResume.Text.Trim();
			ppp.Characteristic = txtPrisonerCharacteristic.Text.Trim();

			//监区权限
			for (int i = 0; i < tvPp.Nodes.Count; i++)
			{
				for (int j = 0; j < tvPp.Nodes[i].Nodes.Count; j++)
				{
					if (tvPp.Nodes[i].Nodes[j].Checked == true)
					{
						pw1 = pw1 + tvPp.Nodes[i].Nodes[j].Name + ",";
					}
				}
				if (tvPp.Nodes[i].Checked == true)
				{
					pw1 = pw1 + tvPp.Nodes[i].Name + ",";
				}
			}
			ppp.Power = pw1;
			pw1 = "";

			//权限时间
			for (int i = 0; i < tvPt.Nodes.Count; i++)
			{
				if (tvPt.Nodes[i].Checked == true)
				{
					pw1 = pw1 + tvPt.Nodes[i].Name + ",";
				}
			}

			ppp.PowerTime = pw1;

			if (ppp.Number == "")
			{
				MessageBox.Show("犯人编号不能为空!");
				txtPrisonerNumber.Focus();
				return;
			}

			if (ppp.WDNumber == "")
			{
				MessageBox.Show("犯人腕带编号不能为空!");
				txtPrisonerWDNumber.Focus();
				return;
			}

			if (ppp.Name == "")
			{
				MessageBox.Show("犯人姓名不能为空!");
				txtPrisonerName.Focus();
				return;
			}

			ppp.AddRecord();
			GetFRXXTable();
		}

		private void buttonX19_Click(object sender, EventArgs e)
		{
			//应用
			Prisoner ppp = new Prisoner();
			string pw1 = "";
			ppp.ID = Convert.ToInt32(txtPrisonerID.Text.Trim());
			ppp.Number = txtPrisonerNumber.Text.Trim();
			ppp.WDNumber = txtPrisonerWDNumber.Text.Trim();
			ppp.Name = txtPrisonerName.Text.Trim();
			ppp.Sex = cbxPrisonerSex.SelectedIndex;
			ppp.CardType = cbxPrisonerCardType.SelectedIndex;
			ppp.CardNum = txtPrisonerCardNum.Text.Trim();
			ppp.CardClass = cbxPrisonerCardClass.SelectedIndex;
			ppp.State = cbxPrisonerState.SelectedIndex;
			ppp.InTime = tmePrisonerInTime.Value;
			ppp.Jail = txtPrisonerJail.SelectedIndex;
			ppp.CardAddress = txtPrisonerCardAddress.Text.Trim();
			ppp.Postal = txtPrisonerPostal.Text.Trim();
			ppp.Address = txtPrisonerAddress.Text.Trim();
			ppp.PostalCode = txtPrisonerPostalCode.Text.Trim();
			ppp.Phone = txtPrisonerPhone.Text.Trim();
			ppp.Remarks = txtPrisonerRemarks.Text.Trim();
			ppp.Resume = txtPrisonerResume.Text.Trim();
			ppp.Characteristic = txtPrisonerCharacteristic.Text.Trim();

			//监区权限
			for (int i = 0; i < tvPp.Nodes.Count; i++)
			{
				for (int j = 0; j < tvPp.Nodes[i].Nodes.Count; j++)
				{
					if (tvPp.Nodes[i].Nodes[j].Checked == true)
					{
						pw1 = pw1 + tvPp.Nodes[i].Nodes[j].Name + ",";
					}
				}
				if (tvPp.Nodes[i].Checked == true)
				{
					pw1 = pw1 + tvPp.Nodes[i].Name + ",";
				}
			}
			ppp.Power = pw1;
			pw1 = "";

			//权限时间
			for (int i = 0; i < tvPt.Nodes.Count; i++)
			{
				if (tvPt.Nodes[i].Checked == true)
				{
					pw1 = pw1 + tvPt.Nodes[i].Name + ",";
				}
			}

			ppp.PowerTime = pw1;

			if (ppp.Number == "")
			{
				MessageBox.Show("犯人编号不能为空!");
				txtPrisonerNumber.Focus();
				return;
			}

			if (ppp.WDNumber == "")
			{
				MessageBox.Show("犯人腕带编号不能为空!");
				txtPrisonerWDNumber.Focus();
				return;
			}

			if (ppp.Name == "")
			{
				MessageBox.Show("犯人姓名不能为空!");
				txtPrisonerName.Focus();
				return;
			}

			ppp.UpDate();
			GetFRXXTable();
		}

		private void buttonX16_Click(object sender, EventArgs e)
		{
			//取消
			txtPrisonerID.Text = "";
			txtPrisonerNumber.Text = "";
			txtPrisonerWDNumber.Text = "";
			txtPrisonerName.Text = "";
			cbxPrisonerSex.SelectedIndex = 0;
			cbxPrisonerCardType.SelectedIndex = 0;
			txtPrisonerCardNum.Text = "";
			cbxPrisonerCardClass.SelectedIndex = 0;
			cbxPrisonerState.SelectedIndex = 0;
			tmePrisonerInTime.Value = System.DateTime.Now;
			txtPrisonerJail.SelectedIndex = 0;
			txtPrisonerCardAddress.Text = "";
			txtPrisonerPostal.Text = "";
			txtPrisonerAddress.Text = "";
			txtPrisonerPostalCode.Text = "";
			txtPrisonerPhone.Text = "";
			txtPrisonerRemarks.Text = "";
			txtPrisonerResume.Text = "";
			txtPrisonerCharacteristic.Text = "";
			this.Close();
		}

		private void DataGridFR_Click(object sender, EventArgs e)
		{
			try
			{
				if (DataGridFR.SelectedRows.Count == 0)
					return;
				string num = DataGridFR.SelectedCells[0].Value.ToString();
				if (num.Trim() == "") return;
				Prisoner ppp = new Prisoner();
				ppp.GetInfo(num);
				txtPrisonerID.Text = ppp.ID.ToString();
				txtPrisonerNumber.Text = ppp.Number;
				txtPrisonerWDNumber.Text = ppp.WDNumber;
				txtPrisonerName.Text = ppp.Name;
				cbxPrisonerSex.SelectedIndex = ppp.Sex;
				cbxPrisonerCardType.SelectedIndex = ppp.CardType;
				txtPrisonerCardNum.Text = ppp.CardNum;
				cbxPrisonerCardClass.SelectedIndex = ppp.CardClass;
				cbxPrisonerState.SelectedIndex = ppp.State;
				tmePrisonerInTime.Value = ppp.InTime;
				txtPrisonerJail.SelectedIndex = ppp.Jail;
				txtPrisonerCardAddress.Text = ppp.CardAddress;
				txtPrisonerPostal.Text = ppp.Postal;
				txtPrisonerAddress.Text = ppp.Address;
				txtPrisonerPostalCode.Text = ppp.PostalCode;
				txtPrisonerPhone.Text = ppp.Phone;
				txtPrisonerRemarks.Text = ppp.Remarks;
				txtPrisonerResume.Text = ppp.Resume;
				txtPrisonerCharacteristic.Text = ppp.Characteristic;
				ppp = null;
			}
			catch (Exception s)
			{
				MessageBox.Show("请不要非法点击!"+s.Message);
			}
		}

		public void GetFRXXTable()
		{
			SqlAccess saa = new SqlAccess();
			saa.ConnectionString = AppInfo.ConnStr;
			DataGridFR.AutoGenerateColumns = true;
			DataGridFR.DataSource = saa.SQLDataSet(@"select
Number as 犯人编号,
WDNumber as 犯人编号,
Name as 犯人姓名,
CardType as 证件名称,
CardNum as 证件号码,
CardClass as 身份级别,
State as 监控状态,
InTime as 入狱时间,
Jail as 所属监区
from [Prisoner]").Tables[0];
			SqlDataReader sdr = saa.SQLReader("select [name] from [Jail] order by [ID] asc");
			txtPrisonerJail.Items.Clear();
			txtPrisonerJail.Items.Add("==请选择监区==");
			while (sdr.Read())
			{
				txtPrisonerJail.Items.Add("==" + sdr.GetString(0) + "==");
			}
			txtPrisonerJail.SelectedIndex = 0;
			sdr.Dispose();
			cbxPrisonerSex.SelectedIndex = 0;
			cbxPrisonerCardType.SelectedIndex = 0;
			cbxPrisonerCardClass.SelectedIndex = 0;
			cbxPrisonerState.SelectedIndex = 0;
		}

		private void frmPrisoner_Load(object sender, EventArgs e)
		{
			GetFRXXTable();
			AppInfo.GetJailInfo(tvPp);
		}

		
	}
}