public static void DropAccess()
{
try
{
MyMeans.AccessLink();
string strInsert = " delete * from ECD_ID ";
OleDbCommand inst = new OleDbCommand(strInsert, Conn);
inst.ExecuteNonQuery();
MyMeans.AccessBreak();
}
catch
{
log.Info("ID数据清除出错！");
MyMeans.AccessBreak();
}
}
public static void InsertAccess(string ID, string Description, string TBytes, string Data, string Value)
{
try
{
MyMeans.AccessLink();
string strInsert = " INSERT INTO [ECD_ID] ([ID],[描述],[类型长度],[数据],[ASCII值]) VALUES ( '" + ID + "','" + Description + "','" + TBytes + "','" + Data + "','" + Value + "')";
OleDbCommand inst = new OleDbCommand(strInsert, Conn);
inst.ExecuteNonQuery();
MyMeans.AccessBreak();
}
catch
{
log.Info("ID数据储存出错！");
MyMeans.AccessBreak();
}
}
/// <summary>
/// 返回DataSet 数据
/// </summary>
/// <returns></returns>
public static DataSet GetEcuTrip(String EcuVersion)
{
DataSet ds = new DataSet();
try
{
MyMeans.AccessLink();
String select = "SELECT * FROM ECU13Tp where EcuVersion='" + EcuVersion + "'";
OleDbDataAdapter da = new OleDbDataAdapter(select, Conn);
da.Fill(ds, "Table1_1");
MyMeans.AccessBreak();
}
catch (Exception e) {
log.Info("read ecu tp by version is error" + e.Message);
MyMeans.AccessBreak();
}
return(ds);
}
public static void DropDTC()
{
try
{
MyMeans.AccessLink();
string strInsert = " delete * from DTC ";
OleDbCommand inst = new OleDbCommand(strInsert, Conn);
inst.ExecuteNonQuery();
strInsert = " ALTER TABLE DTC ALTER COLUMN ID COUNTER (1,1)";
inst = new OleDbCommand(strInsert, Conn);
inst.ExecuteNonQuery();
MyMeans.AccessBreak();
}
catch
{
log.Info("DTC数据库清除出错！");
MyMeans.AccessBreak();
}
}
public static void InsertTrip(string Name1, string Name2, string Name3, string Name4, string Name5,
string Name6, string Name7, string Name8, string Name9, string Name10)
{
try
{
MyMeans.AccessLink();
string strInsert = " INSERT INTO [Trip] ([Name1],[Name2],[Name3],[Name4],[Name5],[Name6],[Name7],[Name8],[Name9],[Name10]) VALUES ( '"
+ Name1 + "','" + Name2 + "','" + Name3 + "','" + Name4 + "','" + Name5 + "','" + Name6 + "','" + Name7 + "','" + Name8
+ "','" + Name9 + "','" + Name10 + "')";
OleDbCommand inst = new OleDbCommand(strInsert, Conn);
inst.ExecuteNonQuery();
MyMeans.AccessBreak();
}
catch
{
log.Info("行程记录数据库储存出错！");
MyMeans.AccessBreak();
}
}