/// <summary> /// 导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { if (lstCalculateRatio == null || lstCalculateRatio.Count == 0) { MessageBox.Show("没有修正因子数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excel文件 (*.xls)|*.xls"; dlg.OverwritePrompt = true; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = zedGraphControlPic.GraphPane.Title.Text; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List <string> lstContent = GetFileContent(lstCalculateRatio); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); } if (strFilePath.EndsWith(".xls")) { DataTable table = GetExcelTable(lstCalculateRatio); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = GetExcelCloumn(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出文件\"" + strFilePath + "\"成功"); } }
/// <summary> /// 导出WeightSortData类型实例至XML/XLS文件 /// </summary> /// <param name="sortData">WeightSortData类型</param> public static void ExportDataToDataFile(WeightSortData sortData) { if (sortData == null) { XLog.Write("没有数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excel文件 (*.xls)|*.xls"; dlg.OverwritePrompt = true; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = sortData.sortName; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List <string> lstContent = MainForm.GetDesignResultFlieContent(sortData); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); } if (strFilePath.EndsWith(".xls")) { DataTable table = MainForm.GetDesignResultTable(sortData); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = MainForm.GetDesignResultExcleCloumn(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出文件\"" + strFilePath + "\"成功"); } }
/// <summary> /// 导出事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { if (treeViewParameterList.Nodes.Count == 0) { XLog.Write("没有数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "PMC文件 (*.PMC)|*.PMC|xls文件 (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = "ParameterCollection"; List <ParaData> lstTempParaDagta = lstParaData; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".PMC")) { SaveFile(strFilePath, lstTempParaDagta); } if (strFilePath.EndsWith(".xls")) { DataTable table = GetTableData(lstTempParaDagta); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = GetColumnName(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出成功"); } }
/// <summary> /// 导出事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { if (selNode == null || selNode.Level == 0) { XLog.Write("请选择重重心包线设计数据"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excle文件 (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = selNode.Text; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List<string> lstContent = GetListContent(); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); } if (strFilePath.EndsWith(".xls")) { DataTable table = GetTableExcleData(); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = GetExcleColumn(); ; commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导入文件\"" + strFilePath + "\"成功"); } }
/// <summary> /// 导出重心数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExportCoreData_Click(object sender, EventArgs e) { if (treeCoreEnvelope.Nodes.Count == 0) { XLog.Write("没有数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excel文件 (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = txtDesignDataName.Text; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List<string> lstContent = MainForm.GetCoreEnvelopeDesignFileContent(gridCoreEnvelope); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); } if (strFilePath.EndsWith(".xls")) { DataTable table = MainForm.GetCoreEnvelopeDesignResultTable(gridCoreEnvelope); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = MainForm.GetCoreEnvelopeDesignResultExcleCloumn(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出文件\"" + strFilePath + "\"成功"); } }
/// <summary> /// 导出WeightSortData类型实例至XML/XLS文件 /// </summary> /// <param name="sortData">WeightSortData类型</param> public static void ExportDataToDataFile(WeightSortData sortData) { if (sortData == null) { XLog.Write("没有数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excel文件 (*.xls)|*.xls"; dlg.OverwritePrompt = true; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = sortData.sortName; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List<string> lstContent = MainForm.GetDesignResultFlieContent(sortData); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); } if (strFilePath.EndsWith(".xls")) { DataTable table = MainForm.GetDesignResultTable(sortData); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = MainForm.GetDesignResultExcleCloumn(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出文件\"" + strFilePath + "\"成功"); } }
/// <summary> /// 导出事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { if (treeViewParameterList.Nodes.Count == 0) { XLog.Write("没有数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "PMC文件 (*.PMC)|*.PMC|xls文件 (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = "ParameterCollection"; List<ParaData> lstTempParaDagta = lstParaData; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".PMC")) { SaveFile(strFilePath, lstTempParaDagta); } if (strFilePath.EndsWith(".xls")) { DataTable table = GetTableData(lstTempParaDagta); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = GetColumnName(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出成功"); } }
/// <summary> /// 导出事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { if (selNode == null || selNode.Level == 0) { XLog.Write("请选择重量设计数据"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excle文件 (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = selNode.Text; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List<string> lstContent = GetListContent(); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); XLog.Write("导出文件\"" + strFilePath + "\"成功"); } if (strFilePath.EndsWith(".xls")) { if (lstDesignData.Count > 0) { WeightDesignData weightData = GetWeightDesignData(Convert.ToInt32(selNode.Name)); WeightSortData sortData = clsStringToWeightSortData(weightData.MainSystem_Name); DataTable table = GetTableExcleData(weightData, sortData); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件\"" + strFilePath + "\"再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = GetExcleCloumn(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); XLog.Write("导出文件\"" + strFilePath + "\"成功"); } } } } }
/// <summary> /// 导出重量数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExportWeightData_Click(object sender, EventArgs e) { WeightSortData tempWeightSort = new WeightSortData(); if (strOperType == CommonMessage.operNew || strOperType == CommonMessage.operJYNew || strOperType == CommonMessage.operEdit) { tempWeightSort = clsStringToWeightSortData(weightDesinData.MainSystem_Name); if (tempWeightSort == null) { XLog.Write("没有数据不能导出"); return; } } else { if (selNode == null || selNode.Level == 0) { XLog.Write("请选择重量设计数据"); return; } WeightDesignData tempWeightDesinData = GetWeightDesignData(Convert.ToInt32(selNode.Name)); tempWeightSort = clsStringToWeightSortData(tempWeightDesinData.MainSystem_Name); } if (tempWeightSort == null) { XLog.Write("没有数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excel文件 (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = txtDesignDataName.Text; if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List<string> lstContent = MainForm.GetDesignResultFlieContent(tempWeightSort); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); } if (strFilePath.EndsWith(".xls")) { DataTable table = MainForm.GetDesignResultTable(tempWeightSort); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = MainForm.GetDesignResultExcleCloumn(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出文件\"" + strFilePath + "\"成功"); } }
/// <summary> /// 导出修正因子数据至数据文件 /// </summary> /// <param name="sortData"></param> private void ExportRatioDataToDataFile(List<ParaData> lstPara) { if (lstPara == null || lstPara.Count == 0) { XLog.Write("没有数据不能导出"); return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "xml文件 (*.xml)|*.xml|Excel文件 (*.xls)|*.xls"; dlg.OverwritePrompt = true; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; dlg.FileName = lstPara[0].paraName.Substring(0, 4); if (dlg.ShowDialog() == DialogResult.OK) { string strFilePath = dlg.FileName; if (strFilePath.EndsWith(".xml")) { List<string> lstContent = GetFileContent(lstPara); CommonFunction.mWriteListStringToFile(strFilePath, lstContent); } if (strFilePath.EndsWith(".xls")) { DataTable table = GetExcelTable(lstPara); int result = XCommon.FileStatus.FileIsOpen(strFilePath); if (result == 1) { MessageBox.Show("请关闭文件" + strFilePath + ",再导出"); } else { CommonExcel commonExcel = new CommonExcel(); commonExcel.lstColumn = GetExcelCloumn(); commonExcel.CreateExcel("example", strFilePath, "sheet1", table); } } XLog.Write("导出文件\"" + strFilePath + "\"成功"); } }