public void ConnectAccessF(int DtcNum, string c9DctnumCode) //传入参数
{
C9BackTDCnumcode = c9DctnumCode;
int C9dtc = Convert.ToInt32(C9BackTDCnumcode, 16);
_9DTCID = DtcNum + 1;
try
{
SQLData.AccessDbClass mybd = new AccessDbClass(MyMeans.strConn1);
con = new OleDbConnection(MyMeans.strConn1);
con.Open();
string select = "SELECT * FROM ECU9DTC where DTCMNUM= " + C9dtc;
cmd = new OleDbCommand(select, con);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
C9dtcname = (string)reader[18];
C9S_Descrition_English = (string)reader[2];
C9S_Descrition_Chinese = (string)reader[3];
}
con.Close();
}
catch
{
}
C9WorkFuc();
}
/// <summary>
/// 查询芯片
/// </summary>
public static void QueryTL()
{
string sql = "select * from TL718";
accessdb = new AccessDbClass(MyMeans.strConn1);
DataTable tl718 = accessdb.SelectToDataTable(sql);
tl718.Columns.Remove("ID");
for (int i = 0; i < tl718.Rows.Count; i++)
{
string value = tl718.Rows[i][0].ToString();
TL718NUM.Add(value);
}
}
/// <summary>
/// 初始证书列表
/// </summary>
public void InitLicenseList()
{
Quality.AccessDbClass accClass = new AccessDbClass(Application.StartupPath + "/DATA/license.mdb");
DataTable dt = new DataTable();
dt = accClass.SelectToDataTable("select * from license");
advTree_licenseList.Nodes.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
advTree_licenseList.Nodes.Add(CreateLicenseNode(dt.Rows[i]["证书编号"].ToString(), dt.Rows[i]["受检单位"].ToString(), Convert.ToDateTime(dt.Rows[i]["受检日期"].ToString()), int.Parse(dt.Rows[i]["ID"].ToString()), dt.Rows[i]["计量器具名称"].ToString(), dt.Rows[i]["检定员"].ToString(), dt.Rows[i]["型号"].ToString(), dt.Rows[i]["出厂编号"].ToString()));
}
//关闭数据库
accClass.Close();
}
public void Tp_SaveExcel()
{
string sql = "select * from Trip";
accessdb = new AccessDbClass(MyMeans.strConn1);
DataTable a = accessdb.SelectToDataTable(sql);
DataTable dt = a;
string outError = "";
string fileName = " dtc.xls";
AsposeExcelTools.Tp_DataTableToExcel(dt, fileName, out outError);
if (!string.IsNullOrEmpty(outError))
{
MessageBox.Show(outError);
}
else
{
Process.Start(fileName);
}
}
