/// <summary>
/// 数据导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private DataSet dDataLoad(ref string sFileName)
{
DataSet dExcelDataSet = new DataSet();
//sEquipmentElement.Clear();
//sEquipmentLine.Clear();
OpenFileDialog dialog = new OpenFileDialog();//open the path
dialog.FileName = sFileName;
dialog.Filter = "Excel Worksheets | *.xls;*.xlsx";
if (dialog.ShowDialog() == true)
{
sPath = dialog.FileName;
sFileName = dialog.FileName;
}
else
{
return(null);
}
if (sPath != null)
{
dExcelDataSet = NpoiExcelFunction.ExcelRead(sPath);
//DataTableToOutPutList();
}
return(dExcelDataSet);
}
void InitializeParametr()
{
try
{
string sTableName;
//配置参数初始化
DataSet dConfigTable = new DataSet();
string sConFilePath = ConfigurationSettings.AppSettings["Config.FilePath"];
//ConveyorSheetName初始化
dConfigTable = NpoiExcelFunction.ExcelRead(sConFilePath);
/*//Conveyor Sheet Name & Conveyor Column Name初始化
* sTableName = ConfigurationSettings.AppSettings["ConveyorTaName"];
* sTableToStringArrary(dConfigTable.Tables[sTableName], out sConveyorSheetName, out sConveyorColName);
* //BaseList Sheet Name & Conveyor Column Name初始化
* sTableName = ConfigurationSettings.AppSettings["BaseTaName"];
* sTableToStringArrary(dConfigTable.Tables[sTableName], out sBaseListSheetName, out sBaseListColName);
*/
//TestDataTemplate
sTableName = ConfigurationSettings.AppSettings["TestDaTeTaName"];
sTestDaActive = (string)dConfigTable.Tables[sTableName].Rows[0][0];
sTestDaTemplateL1 = (string)dConfigTable.Tables[sTableName].Rows[1][0];
sTestDaTemplateL2 = (string)dConfigTable.Tables[sTableName].Rows[2][0];
//XmlTemplate
sTableName = ConfigurationSettings.AppSettings["XmlTeTaName"];
sXmlTextBlock = (string)dConfigTable.Tables[sTableName].Rows[0][0];
sXmlElement = (string)dConfigTable.Tables[sTableName].Rows[1][0];
//L1AlarmDataTemplate
sTableName = ConfigurationSettings.AppSettings["L1AlmDaTeTaName"];
Level1DataExcelData = dConfigTable.Tables[sTableName];
//OPCDataTemplate
sTableName = ConfigurationSettings.AppSettings["OpcDaTeTaName"];
sOPCDaSingleTemplate = (string)dConfigTable.Tables[sTableName].Rows[0][0];
sOPCDaCommandTemplate = (string)dConfigTable.Tables[sTableName].Rows[1][0];
sOPCDaHourTemplate = (string)dConfigTable.Tables[sTableName].Rows[2][0];
//dConfigTable.Clear();
}
catch
{
}
}
/// <summary>
/// 测试记录表格输出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TestListOutputbutton_Click(object sender, RoutedEventArgs e)
{
string sFileStyle = "Excel(.xlsx) | *.xlsx|Excel(.xls) | *.xls";
string UIKey = "TestListOutPutFilePathteBox";
string UIKey1 = "OutPutDatasteBox";
string UIKey2 = "TestListTemplateteBox";
string sFilePath = UIdictionary[UIKey].MyString;
UIdictionary[UIKey1].MyString = "";
//try
//{
bool bOpenEnable = Outputfile(ref sFilePath, sFileStyle);
if (bOpenEnable == true)
{
BaseFactory factory = new BaseFactory();
factory.BaseParameter = CreateConvertParameter();
TestList listData = (TestList)factory.CreatDataClass("TestList");
CreateDataMath <List <TestSheetRow>, ConveyorRow> testdataMath = listData.CreateTestRows;
CreateDataMath <List <string>, ConveyorRow> cmcdataMath = listData.CreateCMCRows;
List <List <TestSheetRow> > testDataRows = listData.CreateList(testdataMath);
List <List <string> > cmcDataRows = listData.CreateList(cmcdataMath);
NpoiExcelFunction.ExcelWrite(sFilePath, "CMC", cmcDataRows);
NpoiExcelFunction.ExcelWrite(sFilePath, "Test", testDataRows);
UIdictionary[UIKey].MyString = sFilePath;
//NpoiExcelFunction.ExcelWrite(sFilePath, (ListData as TestList).ListData);
UIdictionary[UIKey1].MyString = "Output Test List successful!";
}
//}
//catch (Exception ex)
//{
// MessageBox.Show("Build Test List Error： " + ex.Message);
//}
GC.Collect();
}
