frmtransfer.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 frmTransfer : DevComponents.DotNetBar.Office2007Form
	{
		public frmTransfer()
		{
			InitializeComponent();
		}

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

		private void buttonX20_Click(object sender, EventArgs e)
		{
			//取消
			txtTransferID.Text = "";
			cbxTransferName.Text = "";
			cbxTransferBelong.SelectedIndex = 0;
			cbxTransferAdjust.SelectedIndex = 0;
			tmeTransferTime.Value = DateTime.Now;
			txtTransferReason.Text = "";
			cbxTransferPolice.SelectedIndex = 0;
			txtTransferRemarks.Text = "";
			GetFRDDTable();
			this.Close();
		}

		public void GetFRDDTable()
		{
			SqlAccess saa = new SqlAccess();
			saa.ConnectionString = AppInfo.ConnStr;
			dataGridView3.AutoGenerateColumns = true;
			dataGridView3.DataSource = saa.SQLDataSet(@"SELECT ID AS 编号, (SELECT Name
FROM Prisoner
WHERE (ID = Transfer.Prisoner)) AS 犯人姓名,
(SELECT Name
FROM Jail
WHERE (ID = Transfer.Belong)) AS 原属监区,
(SELECT Name
FROM Jail AS Jail_1
WHERE (ID = Transfer.Adjust)) AS 调入监区, Time AS 调入时间, 
Reason AS 调入原因,
(SELECT Name
FROM Police
WHERE (ID = Transfer.Police)) AS 负责人, Remarks AS 备注
FROM Transfer
").Tables[0];
			SqlDataReader sdr = saa.SQLReader("select [name] from [Jail] order by [ID] asc");
			cbxTransferBelong.Items.Clear();
			cbxTransferAdjust.Items.Clear();
			cbxTransferBelong.Items.Add("==请选择监区==");
			cbxTransferAdjust.Items.Add("==请选择监区==");
			while (sdr.Read())
			{
				cbxTransferBelong.Items.Add("==" + sdr.GetString(0) + "==");
				cbxTransferAdjust.Items.Add("==" + sdr.GetString(0) + "==");
			}
			cbxTransferBelong.SelectedIndex = 0;
			cbxTransferAdjust.SelectedIndex = 0;
			sdr.Dispose();
			tmeTransferTime.Value = DateTime.Now;
			//
			cbxTransferPolice.Items.Clear();
			cbxTransferPolice.Items.Add("==请选负责警员==");
			sdr = saa.SQLReader("select [name] from [Police] order by [ID] asc");
			while (sdr.Read())
			{
				cbxTransferPolice.Items.Add("==" + sdr.GetString(0) + "==");
			}
			cbxTransferPolice.SelectedIndex = 0;
			sdr.Dispose();
			//
			cbxTransferName.Items.Clear();
			cbxTransferName.Items.Add("==请选调动犯人==");
			sdr = saa.SQLReader("select [name] from [Prisoner] order by [ID] asc");
			while (sdr.Read())
			{
				cbxTransferName.Items.Add("==" + sdr.GetString(0) + "==");
			}
			cbxTransferName.SelectedIndex = 0;
			sdr.Dispose();
		}

		private void frmTransfer_Load(object sender, EventArgs e)
		{
			GetFRDDTable();
		}

		private void buttonX21_Click(object sender, EventArgs e)
		{
			//添加
			Transfer tt = new Transfer();
			tt.Prisoner = cbxTransferName.SelectedIndex;
			tt.Belong = cbxTransferBelong.SelectedIndex;
			tt.Adjust = cbxTransferAdjust.SelectedIndex;
			tt.Time = tmeTransferTime.Value;
			tt.Reason = txtTransferReason.Text.Trim();
			tt.Police = cbxTransferPolice.SelectedIndex;
			tt.Remarks = txtTransferRemarks.Text.Trim();
			if (tt.Prisoner == 0)
			{
				MessageBox.Show("请选择要调动的犯人!");
				cbxTransferName.Focus();
				return;
			}
			if (tt.Belong == 0)
			{
				MessageBox.Show("请选择原属监区!");
				cbxTransferBelong.Focus();
				return;
			}
			if (tt.Adjust == 0)
			{
				MessageBox.Show("请选择要调入监区!");
				cbxTransferAdjust.Focus();
				return;
			}

			if (tt.Police == 0)
			{
				MessageBox.Show("请选择负责警员!");
				cbxTransferAdjust.Focus();
				return;
			}

			tt.AddRecord();
			GetFRDDTable();
		}

		private void buttonX22_Click(object sender, EventArgs e)
		{
			//应用
			Transfer tt = new Transfer();
			tt.ID = Convert.ToInt32(txtTransferID.Text.Trim());
			tt.Prisoner = cbxTransferName.SelectedIndex;
			tt.Belong = cbxTransferBelong.SelectedIndex;
			tt.Adjust = cbxTransferAdjust.SelectedIndex;
			tt.Time = tmeTransferTime.Value;
			tt.Reason = txtTransferReason.Text.Trim();
			tt.Police = cbxTransferPolice.SelectedIndex;
			tt.Remarks = txtTransferRemarks.Text.Trim();
			if (tt.Prisoner == 0)
			{
				MessageBox.Show("请选择要调动的犯人!");
				cbxTransferName.Focus();
				return;
			}
			if (tt.Belong == 0)
			{
				MessageBox.Show("请选择原属监区!");
				cbxTransferBelong.Focus();
				return;
			}
			if (tt.Adjust == 0)
			{
				MessageBox.Show("请选择要调入监区!");
				cbxTransferAdjust.Focus();
				return;
			}

			if (tt.Police == 0)
			{
				MessageBox.Show("请选择负责警员!");
				cbxTransferAdjust.Focus();
				return;
			}

			tt.UpDate();
			GetFRDDTable();
		}

		private void dataGridView3_Click(object sender, EventArgs e)
		{
			if (dataGridView3.SelectedRows.Count == 0)
				return;
			string num = dataGridView3.SelectedCells[0].Value.ToString();
			if (num.Trim() == "") return;
			Transfer tt = new Transfer();
			tt.GetInfo(Convert.ToInt32(num));
			txtTransferID.Text = tt.ID.ToString();
			cbxTransferName.Text = tt.Prisoner.ToString();
			cbxTransferBelong.SelectedIndex = tt.Belong;
			cbxTransferAdjust.SelectedIndex = tt.Adjust;
			tmeTransferTime.Value = tt.Time;
			txtTransferReason.Text = tt.Reason;
			cbxTransferPolice.SelectedIndex = tt.Police;
			txtTransferRemarks.Text = tt.Remarks;
			tt = null;
		}
	}
}