formmain.cs

.net2003 C# 基于pda的winsock通讯

			this.cb_xz.Items.Add("阀型");
			this.cb_xz.Items.Add("车钩型号");
			this.cb_xz.Items.Add("闸调器");
			this.cb_xz.Items.Add("空重调整型号");
			this.cb_xz.Items.Add("缓冲器型号");
			this.cb_xz.Items.Add("厂修单位");
			this.cb_xz.Items.Add("段修单位");
			this.cb_xz.Items.Add("辅修单位");
			this.cb_xz.Items.Add("修程");
			this.cb_xz.Items.Add("自备车所属单位");
			this.cb_xz.Location = new System.Drawing.Point(56, 96);
			this.cb_xz.Size = new System.Drawing.Size(128, 20);
			// 
			// label34
			// 
			this.label34.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold);
			this.label34.ForeColor = System.Drawing.Color.CornflowerBlue;
			this.label34.Location = new System.Drawing.Point(32, 72);
			this.label34.Size = new System.Drawing.Size(120, 16);
			this.label34.Text = "数据字典项目：";
			// 
			// label17
			// 
			this.label17.Font = new System.Drawing.Font("黑体", 15F, System.Drawing.FontStyle.Bold);
			this.label17.ForeColor = System.Drawing.Color.DarkTurquoise;
			this.label17.Location = new System.Drawing.Point(64, 24);
			this.label17.Size = new System.Drawing.Size(136, 24);
			this.label17.Text = "下载数据字典";
			// 
			// mainMenu1
			// 
			this.mainMenu1.MenuItems.Add(this.menuItem3);
			this.mainMenu1.MenuItems.Add(this.menuItem7);
			this.mainMenu1.MenuItems.Add(this.menuItem6);
			this.mainMenu1.MenuItems.Add(this.menuItem5);
			this.mainMenu1.MenuItems.Add(this.menuItem4);
			this.mainMenu1.MenuItems.Add(this.menuItem2);
			// 
			// menuItem3
			// 
			this.menuItem3.Text = "选择车辆";
			this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
			// 
			// menuItem7
			// 
			this.menuItem7.Text = "刷新";
			this.menuItem7.Click += new System.EventHandler(this.menuItem7_Click);
			// 
			// menuItem6
			// 
			this.menuItem6.Text = "读取";
			this.menuItem6.Click += new System.EventHandler(this.menuItem6_Click);
			// 
			// menuItem5
			// 
			this.menuItem5.Text = "保存";
			this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
			// 
			// menuItem4
			// 
			this.menuItem4.Text = "删除";
			this.menuItem4.Click += new System.EventHandler(this.menuItem4_Click);
			// 
			// menuItem2
			// 
			this.menuItem2.Text = "退出";
			this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click_1);
			// 
			// Formmain
			// 
			this.BackColor = System.Drawing.Color.AliceBlue;
			this.Controls.Add(this.tabControl1);
			this.Menu = this.mainMenu1;
			this.Text = "Formmain";
			this.GotFocus += new System.EventHandler(this.Formmain_GotFocus);
			this.Load += new System.EventHandler(this.Formmain_Load);
			client = new  Client();
			client = pubics.clients ;
		}
		#endregion
		
		public class MessageEventArgst:EventArgs 
		{
			public string Smessage;
			public MessageEventArgst(string smessage) 
			{
				this.Smessage = smessage;
			}
		}
		public delegate void MessageEventHandlert(object sender,MessageEventArgst as_e);
		public event MessageEventHandlert MessageReceivedt;

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

		private void Formmain_Load(object sender, System.EventArgs e)
		{
			Bind_data1();
			client.MessageReceived += new SocketBase.MessageEventHandler(_server_MessageReceived);
			this.MessageReceivedt += new MessageEventHandlert(_MessageReceived);
		
		}
		private void _server_MessageReceived(object sender, SocketBase.MessageEventArgs e) 
		{
			//接到winsock信息后促发MessageReceivedt事件
			string ls_preff,ls_reseive;
			int    li_end;
			ls_preff = e.Message.MessageBody.Substring(0,4);
			if(ls_preff == mypreff)
			{
				li_end = e.Message.MessageBody.IndexOf(mypreff + "end");
				ls_reseive =e.Message.MessageBody.Substring(4,li_end - 4);
				this.MessageReceivedt(this,new MessageEventArgst(ls_reseive));
			}
		}
		private void Bind_data1()
		{
			//绑定本地基础数据到页面一的下拉数据集中
			string strSql = "select cx  from ch_czcx";
			SqlCeConnection conn;
			conn = new SqlCeConnection (@"Data Source = \windows\程序\SmartD\yj.sdf");
			conn.Open();
			SqlCeCommand cmd = conn.CreateCommand();
			try
			{
				cmd.CommandText = strSql;
				SqlCeDataReader rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					tb_cz.Items.Add(rdr[0].ToString());
				}

				tb_cz.Text =pubics.gs_cz;

				rdr.Close();
				strSql = "select name  from zx";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					tb_zx.Items.Add(rdr[0].ToString());
				}
        
				rdr.Close();
				strSql = "select name  from xc";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					tb_xc.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from tsbj";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					tb_tsbj.Items.Add(rdr[0].ToString());
				}
				rdr.Close();
				conn.Close();
			}
			catch (SqlCeException ee) 
			{
				MessageBox.Show(ee.Message.ToString());
			}
            
		}

		private void Bind_data2()
		{
			//绑定本地基础数据到页面二的下拉数据集中
			string strSql = "select name  from szdj";
			SqlCeConnection conn;
			conn = new SqlCeConnection (@"Data Source = \windows\程序\SmartD\yj.sdf");
			conn.Open();
			SqlCeCommand cmd = conn.CreateCommand();
			try
			{
				cmd.CommandText = strSql;
				SqlCeDataReader rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_szdj.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from zdg";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_zdg.Items.Add(rdr[0].ToString());
				}
        
				rdr.Close();
				strSql = "select name  from fx";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_fx.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from cgxh";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_cgxh.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from ztq";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_ztq.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from kztzxh";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_kzxh.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from hcq";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_hcq1.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from hcq";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_hcq2.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from zxj";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					tb_zxj.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from zdl";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					tb_zdl.Items.Add(rdr[0].ToString());
				}
				rdr.Close();
				conn.Close();
			}
			catch (SqlCeException ee) 
			{
				MessageBox.Show(ee.Message.ToString());
			}
            
		}
		private void Bind_data3()
		{
			//绑定本地基础数据到页面三的下拉数据集中
			string strSql = "select name  from cxdw where name <>'' ";
			SqlCeConnection conn;
			conn = new SqlCeConnection (@"Data Source = \windows\程序\SmartD\yj.sdf");
			conn.Open();
			SqlCeCommand cmd = conn.CreateCommand();
			try
			{
				cmd.CommandText = strSql;
				SqlCeDataReader rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_cxdw.Items.Add(rdr[0].ToString());
				}

				rdr.Close();
				strSql = "select name  from dxdw where name <>'' ";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_dxdw.Items.Add(rdr[0].ToString());
				}
        
				rdr.Close();
				strSql = "select name  from fxdw where name <>'' ";
				cmd.CommandText = strSql;
				rdr = cmd.ExecuteReader();
				while (rdr.Read())
				{
					cb_fxdw.Items.Add(rdr[0].ToString());
				}
				rdr.Close();
				conn.Close();
			}
			catch (SqlCeException ee) 
			{
				MessageBox.Show(ee.Message.ToString());
			}
            
		}
		private void tabControl1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			//绑定本地基础数据到页面二三的下拉数据集中
			if (tabControl1.SelectedIndex ==1 & !bind2)
			{
				Bind_data2();
				bind2 =true;
			}
			if (tabControl1.SelectedIndex ==2 & !bind3)
			{
				Bind_data3();
				bind3 =true;
			}
		
		}


		private void button1_Click(object sender, System.EventArgs e)
		{
			//下载基础数据
			string ls_sql;
			if (cb_xz.Text.Length  ==0 )
			{
				MessageBox.Show("请选择要下载的数据字典项!");
			}
			else
			{
				if (cb_xz.Text =="车种车型")
				{
					mypreff ="f301";
					ls_sql =mypreff +  "select uaux,ch_min,ch_max  from hmis.ch_czcx_field";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="轴型")
				{
					mypreff ="f302";
					ls_sql =mypreff +  "select zx_code,zx_name  from HMIS.B_DICT_ZX";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="转向架")
				{
					mypreff ="f303";
					ls_sql =mypreff +  "select sys_code,sys_name  from HMIS.B_DICT_ZXJ";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="制动梁")
				{
					mypreff ="f304";
					ls_sql =mypreff +  "select sys_code,sys_name  from HMIS.B_DICT_ZDL";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="修程")
				{
					mypreff ="f305";
					ls_sql =mypreff +  "select xc_code,xc_name  from HMIS.B_DICT_XC";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="特殊标记")
				{
					mypreff ="f306";
					ls_sql =mypreff +  "select sys_code,sys_name  from HMIS.B_DICT_TSBJ";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="手制动机型号")
				{
					mypreff ="f307";
					ls_sql =mypreff +  "select sys_code,sys_name  from HMIS.B_DICT_SZDJ";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="制动缸型别")
				{
					mypreff ="f308";
					ls_sql =mypreff +  "select sys_code,sys_name  from HMIS.B_DICT_ZDG";	
					sendyj(ls_sql);
				}
				if (cb_xz.Text =="阀型")