mainform.cs

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

				cmSQL.Dispose();
				cnSQL.Dispose();
				setComplate(strName);
				MessageBox.Show("数据保存成功！","系统提示",MessageBoxButtons.OK, MessageBoxIcon.Warning);
				this.Save.Enabled  =false;
            
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");

			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
			}

		}

		private string GetTradeMark()
		{
			OleDbCommand cmSQL;
			OleDbDataReader drSQL;
			OleDbConnection cnSQL; 
			string strNum="";
			try 
			{
				string strSQL="select 车牌号 from 汽车资料 "; 
				cnSQL = new OleDbConnection(Connstring); 
				cnSQL.Open(); 
				cmSQL = new OleDbCommand(strSQL,cnSQL); 
				drSQL = cmSQL.ExecuteReader();
				if(drSQL.Read())
				{
					strNum= drSQL["车牌号"].ToString();
				}
				drSQL.Close();
				cnSQL.Close();
				cmSQL.Dispose();
				cnSQL.Dispose();
				return (strNum!=""?strNum:"");
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");
				return "";
			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
				return "";
			}
		}

		private void GetLineState()
		{
			OleDbCommand cmSQL;
			OleDbDataAdapter drSQL;
			OleDbConnection cnSQL; 
			DataTable dtTask = new DataTable();
			try 
			{
				string strSQL="select packet_id,packet_name from sendpacket where state=1"; 
				cnSQL = new OleDbConnection(Connstring); 
				cnSQL.Open(); 
				cmSQL = new OleDbCommand(strSQL,cnSQL); 
				drSQL = new OleDbDataAdapter(cmSQL);
				OleDbCommandBuilder scb =new OleDbCommandBuilder (drSQL);
				drSQL.Fill(dtTask);
				this.grdState.DataSource =dtTask;
				MaxRows=dtTask.Rows.Count;
				if (MaxRows==0)
					this.Save.Enabled =false;
				cnSQL.Close();
				cmSQL.Dispose();
				cnSQL.Dispose();
            
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");
			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
			}
		}

		private void timer1_Tick(object sender, System.EventArgs e)
		{
			GetLineState();
			this.grdState.Refresh();
		}

		private void timer2_Tick(object sender, System.EventArgs e)
		{
			OleDbCommand cmSQL;
			OleDbDataAdapter drSQL;
			OleDbConnection cnSQL; 
			DataTable dtTask = new DataTable();
			try 
			{
				string strSQL="select packet_id,packet_data, from sendpacket"; 
				cnSQL = new OleDbConnection(Connstring); 
				cnSQL.Open(); 
				cmSQL = new OleDbCommand(strSQL,cnSQL); 
				drSQL = new OleDbDataAdapter(cmSQL);
				OleDbCommandBuilder scb =new OleDbCommandBuilder (drSQL);
				drSQL.Fill(dtTask);
				this.grdState.DataSource =dtTask;
				this.grdState.Refresh();

				cnSQL.Close();
				cmSQL.Dispose();
				cnSQL.Dispose();
            
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");
			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
			}		
		}

		private void grdState_Click(object sender, System.EventArgs e)
		{
			DataTable dtAccept = new DataTable();
			DataRow myDataRow;
			dtAccept=(DataTable)grdState.DataSource;
			int li_i=Int32.Parse(grdState.CurrentRowIndex.ToString());
			if (grdState.CurrentRowIndex==-1||MaxRows==0)
			{
				return;
			}
			myDataRow=dtAccept.Rows[grdState.CurrentRowIndex];
			strName=myDataRow["Packet_Name"].ToString();
			OleDbCommand cmSQL;
			OleDbDataReader drSQL;
			OleDbConnection cnSQL; 
			string[] strNum=new string[6];
			try 
			{
				string strSQL="select packet_name,packet_data,send_date from sendpacket where state=1 and packet_name='"+strName+"'"; 
				cnSQL = new OleDbConnection(Connstring); 
				cnSQL.Open(); 
				cmSQL = new OleDbCommand(strSQL,cnSQL); 
				drSQL = cmSQL.ExecuteReader();
				if(drSQL.Read())
				{
					strDate =drSQL["send_date"].ToString();
					strNote=drSQL["packet_data"].ToString();
					strNum=drSQL["packet_data"].ToString().Split('#');
					this.taskcarReport1.SerialNo =strNum[1];
					this.Note.Text ="======================================================"+"\r\n"+strName+"\r\n"+strDate+"\r\n"+strNum[2];
				}
				drSQL.Close();
				cnSQL.Close();
				cmSQL.Dispose();
				cnSQL.Dispose();
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");
			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
			}
			this.Save.Enabled =true;
		}

		private void grdState_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
		{
		
		}

		private void cmdQuery_Click(object sender, System.EventArgs e)
		{
			OleDbCommand cmSQL;
			OleDbDataAdapter drSQL;
			OleDbConnection cnSQL; 
			DataTable dtTask = new DataTable();
			try 
			{
				string strSQL="select packet_id,packet_name from sendpacket where send_date="+dateTimePicker1.Value.ToShortDateString() ; 
				cnSQL = new OleDbConnection(Connstring); 
				cnSQL.Open(); 
				cmSQL = new OleDbCommand(strSQL,cnSQL); 
				drSQL = new OleDbDataAdapter(cmSQL);
				OleDbCommandBuilder scb =new OleDbCommandBuilder (drSQL);
				drSQL.Fill(dtTask);
				this.grdState.DataSource =dtTask;
				cnSQL.Close();
				cmSQL.Dispose();
				cnSQL.Dispose();
            
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");
			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
			}
		}

		private void Exit_Click(object sender, System.EventArgs e)
		{
			Application.Exit();
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			getRowData(0);
			this.grdState.CurrentRowIndex=0;

		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			if (this.grdState.CurrentRowIndex==0)
                getRowData(0);
			else
				getRowData(--this.grdState.CurrentRowIndex);
		}

		private void button3_Click(object sender, System.EventArgs e)
		{
			if (this.grdState.CurrentRowIndex==MaxRows-1)
			{
				getRowData(MaxRows-1);
				this.grdState.CurrentRowIndex=MaxRows-1;
			}
			else
			{
				getRowData(++this.grdState.CurrentRowIndex);
			}
		}

		private void button4_Click(object sender, System.EventArgs e)
		{
			getRowData(MaxRows-1);
			this.grdState.CurrentRowIndex=MaxRows-1;
		
		}

		private void getRowData(int RowIndex)
		{
			DataTable dtAccept = new DataTable();
			DataRow myDataRow;
			dtAccept=(DataTable)grdState.DataSource;
			if ( RowIndex<=0 ) return;
			myDataRow=dtAccept.Rows[RowIndex];
			strName=myDataRow["Packet_Name"].ToString();

			OleDbCommand cmSQL;
			OleDbDataReader drSQL;
			OleDbConnection cnSQL; 
			string[] strNum=new string[6];
			try 
			{
				string strSQL="select packet_name,packet_data,send_date from sendpacket where state=1 and packet_name='"+strName+"'"; 
				cnSQL = new OleDbConnection(Connstring); 
				cnSQL.Open(); 
				cmSQL = new OleDbCommand(strSQL,cnSQL); 
				drSQL = cmSQL.ExecuteReader();
				if(drSQL.Read())
				{
					strDate =drSQL["send_date"].ToString();
					strNote=drSQL["packet_data"].ToString();
					strNum=drSQL["packet_data"].ToString().Split('#');
					this.taskcarReport1.SerialNo =strNum[1];
					this.Note.Text ="======================================================"+"\r\n"+strName+"\r\n"+strDate+"\r\n"+strNum[2];
				}
				drSQL.Close();
				cnSQL.Close();
				cmSQL.Dispose();
				cnSQL.Dispose();
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");
			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
			}
			this.Save.Enabled =true;

		}
		private void setComplate(string sName)
		{
			OleDbCommand cmSQL;
			OleDbDataReader drSQL;
			OleDbConnection cnSQL; 
			try 
			{
				string strSQL="update sendPacket set state=2 where packet_name='"+sName +"'"; 
				cnSQL = new OleDbConnection(Connstring); 
				cnSQL.Open(); 
				cmSQL = new OleDbCommand(strSQL,cnSQL); 
				cmSQL.ExecuteNonQuery();
				cnSQL.Close();
				cmSQL.Dispose();
				cnSQL.Dispose();
			}
			catch(OleDbException ms)
			{
				MessageBox.Show(ms.Message,  "SQL语句错误！");
			} 
			catch(Exception ms)
			{
				MessageBox.Show(ms.Message, "General Error");
			}


		}
	}
}