public static DataTable SelectDataTable_baseProfile(string tableName, string lineOrProductName, bool isLine)
{
DataTable Dt = new DataTable();
try
{
using (MySqlConnection connection = AccessDBBase.getMySqlCon("ReflowerTester", "root", "pempenn", GlobalData.MySqlPort))
{
connection.Open();
Dt = AccessDBBase.GetDataTable(connection, SqlCmd_selectDataTable1(tableName, lineOrProductName, isLine));
}
}
catch (MySqlException ex)
{
LogClass.WriteLogFile("Reflower Tester:查询成DataTable数据1失败" + ex.Message);
Dt = null;
}
return(Dt);
}
public static DataTable SelectDataTable_baseProfile(string tableName, string line, string productName, string beginTime, string overTime)
{
DataTable Dt = new DataTable();
try
{
using (MySqlConnection connection = AccessDBBase.getMySqlCon("ReflowerTester", "root", "pempenn", GlobalData.MySqlPort))
{
connection.Open();
Dt = AccessDBBase.GetDataTable(connection, SqlCmd_selectDataTable4(tableName, line, productName), new MySqlParameter(@"beginTime", beginTime), new MySqlParameter(@"overTime", overTime));
}
}
catch (MySqlException ex)
{
LogClass.WriteLogFile("Reflower Tester:查询成DataTable数据4失败" + ex.Message);
Dt = null;
}
return(Dt);
}
public static DataTable SelectDataTable_baseProfileUsePage(string tableName, string line, string productName, string beginIndex, string num)
{
DataTable Dt = new DataTable();
try
{
using (MySqlConnection connection = AccessDBBase.getMySqlCon("ReflowerTester", "root", "pempenn", GlobalData.MySqlPort))
{
connection.Open();
Dt = AccessDBBase.GetDataTable(connection, SqlCmd_selectDataTable2UsePage(tableName, line, productName, beginIndex, num));
}
}
catch (MySqlException ex)
{
LogClass.WriteLogFile("Reflower Tester:查询成DataTable数据2失败（分页）" + ex.Message);
Dt = null;
}
return(Dt);
}