frmaccept.cs

车载GPS？今天这个就是最好的工具

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

namespace GEROSYS
{
	/// <summary>
	/// frmAccept 的摘要说明。
	/// </summary>
	public class frmAccept : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Panel panel3;
		private System.Windows.Forms.Button cmdCancel;
		private System.Windows.Forms.TextBox txtComTime;
		private System.Windows.Forms.Label lblComTime;
		private System.Windows.Forms.TextBox txtState;
		private System.Windows.Forms.Label lblState;
		private System.Windows.Forms.TextBox txtAEmp;
		private System.Windows.Forms.Label lblAEmp;
		private System.Windows.Forms.TextBox txtTime;
		private System.Windows.Forms.Label lblTime;
		private System.Windows.Forms.TextBox txtDate;
		private System.Windows.Forms.Label lblDate;
		private System.Windows.Forms.TextBox txtNo;
		private System.Windows.Forms.Label lblNO;
		private System.Windows.Forms.Label lblCaption;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.TextBox txtDescribe;
		private System.Windows.Forms.Label lblDescribe;
		private System.Windows.Forms.TextBox txtAddress;
		private System.Windows.Forms.Label lblAddress;
		private System.Windows.Forms.RadioButton rdoNTime;
		private System.Windows.Forms.RadioButton rdoYTime;
		private System.Windows.Forms.Label lblIsTime;
		private System.Windows.Forms.ComboBox cboArea;
		private System.Windows.Forms.Label lblArea;
		private System.Windows.Forms.ComboBox cboVerdict;
		private System.Windows.Forms.Label lblVerdict;
		private System.Windows.Forms.ComboBox cboSpot;
		private System.Windows.Forms.Label lblSpot;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.TextBox txtCom;
		private System.Windows.Forms.Label lblCom;
		private System.Windows.Forms.TextBox txtPhone;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox txtEmp;
		private System.Windows.Forms.Label lblEmp;
		private System.Windows.Forms.ComboBox cboContent;
		private System.Windows.Forms.Label lblContent;
		private System.Windows.Forms.ComboBox cboSource;
		private System.Windows.Forms.Label lblSource;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;
		private GEROMain frm;
//		protected const string SQL_CONNECTION_STRING  = @"Data Source=diaodushi;DataBase=gero;user id=sa;password=sasa";
		protected const string SQL_CONNECTION_STRING  = @"Server=(local)\PCMS;DataBase=gero;user id=sa;password=pcms;Integrated Security=SSPI";
		private System.Windows.Forms.TextBox txtWeek;
		private System.Windows.Forms.Label lblWeek;
		private System.Windows.Forms.RadioButton rdoOther;
		private System.Windows.Forms.RadioButton rdoEmpX;
		private System.Windows.Forms.RadioButton rdoMan;
		private System.Windows.Forms.RadioButton rdoEmpS;
		private System.Windows.Forms.ComboBox cboArea1;
		private System.Windows.Forms.Label lblArea1;
		private string strConn= new AccessData().ConnectionString ;

		public frmAccept(GEROMain frm)
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();
			this.frm  = frm ;
			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <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.panel3 = new System.Windows.Forms.Panel();
			this.txtWeek = new System.Windows.Forms.TextBox();
			this.lblWeek = new System.Windows.Forms.Label();
			this.cmdCancel = new System.Windows.Forms.Button();
			this.txtComTime = new System.Windows.Forms.TextBox();
			this.lblComTime = new System.Windows.Forms.Label();
			this.txtState = new System.Windows.Forms.TextBox();
			this.lblState = new System.Windows.Forms.Label();
			this.txtAEmp = new System.Windows.Forms.TextBox();
			this.lblAEmp = new System.Windows.Forms.Label();
			this.txtTime = new System.Windows.Forms.TextBox();
			this.lblTime = new System.Windows.Forms.Label();
			this.txtDate = new System.Windows.Forms.TextBox();
			this.lblDate = new System.Windows.Forms.Label();
			this.txtNo = new System.Windows.Forms.TextBox();
			this.lblNO = new System.Windows.Forms.Label();
			this.lblCaption = new System.Windows.Forms.Label();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.txtDescribe = new System.Windows.Forms.TextBox();
			this.lblDescribe = new System.Windows.Forms.Label();
			this.txtAddress = new System.Windows.Forms.TextBox();
			this.lblAddress = new System.Windows.Forms.Label();
			this.rdoNTime = new System.Windows.Forms.RadioButton();
			this.rdoYTime = new System.Windows.Forms.RadioButton();
			this.lblIsTime = new System.Windows.Forms.Label();
			this.cboArea = new System.Windows.Forms.ComboBox();
			this.lblArea = new System.Windows.Forms.Label();
			this.cboVerdict = new System.Windows.Forms.ComboBox();
			this.lblVerdict = new System.Windows.Forms.Label();
			this.cboSpot = new System.Windows.Forms.ComboBox();
			this.lblSpot = new System.Windows.Forms.Label();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.rdoOther = new System.Windows.Forms.RadioButton();
			this.rdoEmpX = new System.Windows.Forms.RadioButton();
			this.rdoMan = new System.Windows.Forms.RadioButton();
			this.rdoEmpS = new System.Windows.Forms.RadioButton();
			this.label2 = new System.Windows.Forms.Label();
			this.txtCom = new System.Windows.Forms.TextBox();
			this.lblCom = new System.Windows.Forms.Label();
			this.txtPhone = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.txtEmp = new System.Windows.Forms.TextBox();
			this.lblEmp = new System.Windows.Forms.Label();
			this.cboContent = new System.Windows.Forms.ComboBox();
			this.lblContent = new System.Windows.Forms.Label();
			this.cboSource = new System.Windows.Forms.ComboBox();
			this.lblSource = new System.Windows.Forms.Label();
			this.cboArea1 = new System.Windows.Forms.ComboBox();
			this.lblArea1 = new System.Windows.Forms.Label();
			this.panel3.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.groupBox1.SuspendLayout();
			this.SuspendLayout();
			// 
			// panel3
			// 
			this.panel3.BackColor = System.Drawing.SystemColors.Control;
			this.panel3.Controls.Add(this.txtWeek);
			this.panel3.Controls.Add(this.lblWeek);
			this.panel3.Controls.Add(this.cmdCancel);
			this.panel3.Controls.Add(this.txtComTime);
			this.panel3.Controls.Add(this.lblComTime);
			this.panel3.Controls.Add(this.txtState);
			this.panel3.Controls.Add(this.lblState);
			this.panel3.Controls.Add(this.txtAEmp);
			this.panel3.Controls.Add(this.lblAEmp);
			this.panel3.Controls.Add(this.txtTime);
			this.panel3.Controls.Add(this.lblTime);
			this.panel3.Controls.Add(this.txtDate);
			this.panel3.Controls.Add(this.lblDate);
			this.panel3.Controls.Add(this.txtNo);
			this.panel3.Controls.Add(this.lblNO);
			this.panel3.Controls.Add(this.lblCaption);
			this.panel3.Controls.Add(this.groupBox2);
			this.panel3.Controls.Add(this.groupBox1);
			this.panel3.ForeColor = System.Drawing.SystemColors.ControlText;
			this.panel3.Location = new System.Drawing.Point(0, -8);
			this.panel3.Name = "panel3";
			this.panel3.Size = new System.Drawing.Size(792, 448);
			this.panel3.TabIndex = 11;
			// 
			// txtWeek
			// 
			this.txtWeek.Enabled = false;
			this.txtWeek.Location = new System.Drawing.Point(656, 32);
			this.txtWeek.Name = "txtWeek";
			this.txtWeek.Size = new System.Drawing.Size(88, 21);
			this.txtWeek.TabIndex = 20;
			this.txtWeek.Text = "";
			// 
			// lblWeek
			// 
			this.lblWeek.Location = new System.Drawing.Point(608, 40);
			this.lblWeek.Name = "lblWeek";
			this.lblWeek.Size = new System.Drawing.Size(48, 23);
			this.lblWeek.TabIndex = 19;
			this.lblWeek.Text = "星期：";
			this.lblWeek.TextAlign = System.Drawing.ContentAlignment.TopRight;
			// 
			// cmdCancel
			// 
			this.cmdCancel.Location = new System.Drawing.Point(672, 392);
			this.cmdCancel.Name = "cmdCancel";
			this.cmdCancel.Size = new System.Drawing.Size(75, 32);
			this.cmdCancel.TabIndex = 16;
			this.cmdCancel.Text = "退出(&E)";
			this.cmdCancel.Click += new System.EventHandler(this.cmdCancel_Click);
			// 
			// txtComTime
			// 
			this.txtComTime.Enabled = false;
			this.txtComTime.Location = new System.Drawing.Point(608, 360);
			this.txtComTime.Name = "txtComTime";
			this.txtComTime.Size = new System.Drawing.Size(136, 21);
			this.txtComTime.TabIndex = 14;
			this.txtComTime.Text = "";
			// 
			// lblComTime
			// 
			this.lblComTime.Location = new System.Drawing.Point(504, 368);
			this.lblComTime.Name = "lblComTime";
			this.lblComTime.Size = new System.Drawing.Size(104, 23);
			this.lblComTime.TabIndex = 13;
			this.lblComTime.Text = "接警单完成时间：";
			this.lblComTime.TextAlign = System.Drawing.ContentAlignment.TopRight;
			// 
			// txtState
			// 
			this.txtState.Enabled = false;
			this.txtState.Location = new System.Drawing.Point(352, 360);
			this.txtState.Name = "txtState";
			this.txtState.Size = new System.Drawing.Size(144, 21);
			this.txtState.TabIndex = 12;
			this.txtState.Text = "";
			// 
			// lblState
			// 
			this.lblState.Location = new System.Drawing.Point(272, 368);
			this.lblState.Name = "lblState";
			this.lblState.Size = new System.Drawing.Size(80, 23);
			this.lblState.TabIndex = 11;
			this.lblState.Text = "接警单状态：";
			this.lblState.TextAlign = System.Drawing.ContentAlignment.TopRight;
			// 
			// txtAEmp
			// 
			this.txtAEmp.Enabled = false;
			this.txtAEmp.Location = new System.Drawing.Point(112, 360);
			this.txtAEmp.Name = "txtAEmp";
			this.txtAEmp.Size = new System.Drawing.Size(144, 21);
			this.txtAEmp.TabIndex = 10;
			this.txtAEmp.Text = "";
			// 
			// lblAEmp
			// 
			this.lblAEmp.Location = new System.Drawing.Point(16, 368);
			this.lblAEmp.Name = "lblAEmp";
			this.lblAEmp.Size = new System.Drawing.Size(96, 23);
			this.lblAEmp.TabIndex = 9;
			this.lblAEmp.Text = "接警单经手人：";
			this.lblAEmp.TextAlign = System.Drawing.ContentAlignment.TopRight;
			// 
			// txtTime
			// 
			this.txtTime.Enabled = false;
			this.txtTime.Location = new System.Drawing.Point(512, 32);
			this.txtTime.Name = "txtTime";
			this.txtTime.Size = new System.Drawing.Size(96, 21);