private void btn_ExportOk_Click(object sender, EventArgs e) { docDataSet = new DataSet("Documents"); fileDataSet = new DataSet("Files"); boxDataSet = new DataSet("Boxs"); string savePath = txt_ExportEFilePath.Text + @"\\" + DateTime.Now.ToString("yyyyMMddHHmm"); if (!string.IsNullOrEmpty(savePath)) { if (treeView1.Nodes.Count > 0) { bool isData = chk_Data.Checked; DataTable table = new DataTable(); ExportEFile(treeView1.Nodes[0], savePath, isData, ref table); if (isData) { docDataSet.WriteXml(savePath + @"\Documents.xml"); fileDataSet.WriteXml(savePath + @"\Files.xml"); boxDataSet.WriteXml(savePath + @"\Boxs.xml"); if (table.Rows.Count > 0) { MicrosoftWordHelper.GetCsvFromDataTable(table, savePath + @"\" + DateTime.Now.ToString("yyyyMMddHHmm") + ".csv", 0); } } DialogResult dialogResult = XtraMessageBox.Show("导出完毕,是否立即打开文件夹?", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); if (dialogResult == DialogResult.OK) { WinFormOpenHelper.OpenWinForm(0, "open", null, null, savePath, ShowWindowCommands.SW_NORMAL); } } else { XtraMessageBox.Show("尚无文件可导出。"); } } else { XtraMessageBox.Show("请先选择导出路径。"); } }
/// <summary> /// 导出文件列表清单 /// </summary> private void CreateFileList() { SplashScreenManager.ShowDefaultWaitForm(this, false, false); idList = new List <object>(); //普通计划 string querySQL = $"SELECT A.pi_id id, pi.pi_name '计划名称', pt.pt_code '案卷编号/档号', pt.pt_name '案卷题名', " + $"A.pi_code '项目编号', A.pi_name '项目名称', A.pi_unit '项目承担单位', A.pi_prouser '项目负责人', A.pi_start_datetime '项目开始时间', A.pi_end_datetime '项目结束时间', " + "'' '课题编号','' '课题名称', '' '课题负责人','' '课题承担单位', " + $"pb.pb_gc_id '馆藏号', pb.pb_box_number '盒号', B.fcount '文件数量', " + $"pfl.pfl_code '文件编号', pfl.pfl_box_sort+1 '文件盒内序号', pfl.pfl_name '文件题名', pfl.pfl_amount '文件移交份数', pfl_pages '文件页数' FROM transfer_registration_pc trp " + $"LEFT JOIN project_info pi ON (pi.trc_id = trp.trp_id AND pi.pi_categor = 1) " + $"LEFT JOIN ( " + $"SELECT pi_id, pi_code, pi_name, pi_unit, pi_prouser, pi_start_datetime, pi_end_datetime, pi_obj_id FROM project_info WHERE pi_categor= 2 UNION ALL " + $"SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor= -3) A ON A.pi_obj_id = pi.pi_id " + $"LEFT JOIN processing_box pb ON pb.pb_obj_id = A.pi_id " + $"LEFT JOIN processing_tag pt ON pt.pt_id = pb.pt_id " + $"LEFT JOIN (SELECT pfl_box_id, COUNT(pfl_id) fcount FROM processing_file_list GROUP BY pfl_box_id )B ON B.pfl_box_id = pb.pb_id " + $"LEFT JOIN processing_file_list pfl ON pfl.pfl_box_id = pb.pb_id " + $"WHERE trp.trp_id = '{trpId}' AND pi.pi_id IS NOT NULL "; DataTable table = SqlHelper.ExecuteQuery(querySQL); if (table.Rows.Count > 0) { DataTable _table = table.Copy(); foreach (DataRow row in table.Rows) { object projectID = row["id"]; if (idList.Contains(projectID)) { continue; } else { idList.Add(projectID); } string topicQuerySql = $"SELECT C.ti_id id, '{row["计划名称"]}' AS '计划名称', pt.pt_code '案卷编号/档号', pt.pt_name '案卷题名', " + $"'{row["项目编号"]}' '项目编号', '{row["项目名称"]}' '项目名称', '{row["项目承担单位"]}' '项目承担单位', '{row["项目负责人"]}' '项目负责人', '{row["项目开始时间"]}' '项目开始时间', '{row["项目结束时间"]}' '项目结束时间', C.ti_code '课题编号', C.ti_name '课题名称', C.ti_prouser '课题负责人', C.ti_unit '课题承担单位', C.ti_start_datetime '项目开始时间', C.ti_end_datetime '项目结束时间', " + $"pb.pb_gc_id '馆藏号', pb.pb_box_number '盒号', B.fcount '文件数量', " + $"pfl.pfl_code '文件编号', pfl.pfl_box_sort+1 '文件盒内序号', pfl.pfl_name '文件题名', pfl.pfl_amount '文件移交份数', pfl_pages '文件页数' " + $"FROM ( " + $"SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor= 3 UNION ALL " + $"SELECT si_id, si_code, si_name, si_unit, si_prouser, si_start_datetime, si_end_datetime, si_obj_id FROM subject_info) C " + $"LEFT JOIN processing_box pb ON pb.pb_obj_id = C.ti_id " + $"LEFT JOIN processing_tag pt ON pt.pt_id = pb.pt_id " + $"LEFT JOIN (SELECT pfl_box_id, COUNT(pfl_id) fcount FROM processing_file_list GROUP BY pfl_box_id )B ON B.pfl_box_id = pb.pb_id " + $"LEFT JOIN processing_file_list pfl ON pfl.pfl_box_id = pb.pb_id " + $"WHERE C.ti_obj_id='{projectID}' "; DataTable topicTable = SqlHelper.ExecuteQuery(topicQuerySql); _table.Merge(topicTable); } SplashScreenManager.CloseDefaultSplashScreen(); saveFileDialog1.Title = "请选择导出位置"; saveFileDialog1.Filter = "CSV文件|*.csv"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string savePath = saveFileDialog1.FileName; bool flag = MicrosoftWordHelper.GetCsvFromDataTable(_table, savePath, 0); { if (XtraMessageBox.Show("导出文件列表清单成功,是否立即打开?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { WinFormOpenHelper.OpenWinForm(0, "open", savePath, null, null, ShowWindowCommands.SW_NORMAL); } } } } else { querySQL = $"SELECT A.pi_id id, idi.imp_name '计划名称', pt.pt_code '案卷编号/档号', pt.pt_name '案卷题名', " + $"A.pi_code '项目编号', A.pi_name '项目名称', A.pi_unit '项目承担单位', A.pi_prouser '项目负责人', A.pi_start_datetime '项目开始时间', A.pi_end_datetime '项目结束时间', " + "'' '课题编号','' '课题名称', '' '课题负责人','' '课题承担单位', " + $"pb.pb_gc_id '馆藏号', pb.pb_box_number '盒号', B.fcount '文件数量', " + $"pfl.pfl_code '文件编号', pfl.pfl_box_sort+1 '文件盒内序号', pfl.pfl_name '文件题名', pfl.pfl_amount '文件移交份数', pfl_pages '文件页数' FROM transfer_registration_pc trp " + $"LEFT JOIN imp_info ii ON ii.imp_obj_id=trp.trp_id " + $"LEFT JOIN imp_dev_info idi ON idi.imp_obj_id = ii.imp_id " + $"LEFT JOIN ( " + $"SELECT pi_id, pi_code, pi_name, pi_unit, pi_prouser, pi_start_datetime, pi_end_datetime, pi_obj_id FROM project_info WHERE pi_categor= 2 UNION ALL " + $"SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor= -3)A ON A.pi_obj_id = idi.imp_id " + $"LEFT JOIN processing_box pb ON pb.pb_obj_id = A.pi_id " + $"LEFT JOIN processing_tag pt ON pt.pt_id = pb.pt_id " + $"LEFT JOIN ( " + $"SELECT pfl_box_id, COUNT(pfl_id) fcount FROM processing_file_list GROUP BY pfl_box_id )B ON B.pfl_box_id = pb.pb_id " + $"LEFT JOIN processing_file_list pfl ON pfl.pfl_box_id = pb.pb_id " + $"WHERE trp.trp_id = '{trpId}' AND idi.imp_id IS NOT NULL "; DataTable speTable = SqlHelper.ExecuteQuery(querySQL); if (speTable.Rows.Count > 0) { DataTable _table = speTable.Copy(); foreach (DataRow row in speTable.Rows) { object projectID = row["id"]; if (idList.Contains(projectID)) { continue; } else { idList.Add(projectID); } string topicQuerySql = $"SELECT C.ti_id id, '{row["计划名称"]}' AS '计划名称', pt.pt_code '案卷编号/档号', pt.pt_name '案卷题名', " + $"'{row["项目编号"]}' '项目编号', '{row["项目名称"]}' '项目名称', '{row["项目承担单位"]}' '项目承担单位', '{row["项目负责人"]}' '项目负责人', '{row["项目开始时间"]}' '项目开始时间', '{row["项目结束时间"]}' '项目结束时间', " + $"C.ti_code '项目编号', C.ti_name '项目名称', C.ti_unit '承担单位', C.ti_prouser '项目负责人', C.ti_start_datetime '项目开始时间', C.ti_end_datetime '项目结束时间', " + $"pb.pb_gc_id '馆藏号', pb.pb_box_number '盒号', B.fcount '文件数量', " + $"pfl.pfl_code '文件编号', pfl.pfl_box_sort+1 '文件盒内序号', pfl.pfl_name '文件题名', pfl.pfl_amount '文件移交份数', pfl_pages '文件页数' " + $"FROM ( " + $"SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor= 3 UNION ALL " + $"SELECT si_id, si_code, si_name, si_unit, si_prouser, si_start_datetime, si_end_datetime, si_obj_id FROM subject_info) C " + $"LEFT JOIN processing_box pb ON pb.pb_obj_id = C.ti_id " + $"LEFT JOIN processing_tag pt ON pt.pt_id =pb.pt_id " + $"LEFT JOIN (SELECT pfl_box_id, COUNT(pfl_id) fcount FROM processing_file_list GROUP BY pfl_box_id )B ON B.pfl_box_id = pb.pb_id " + $"LEFT JOIN processing_file_list pfl ON pfl.pfl_box_id = pb.pb_id " + $"WHERE C.ti_id='{projectID}' "; DataTable topicTable = SqlHelper.ExecuteQuery(topicQuerySql); _table.Merge(topicTable); } SplashScreenManager.CloseDefaultSplashScreen(); saveFileDialog1.Title = "请选择导出位置"; saveFileDialog1.Filter = "CSV文件|*.csv"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string savePath = saveFileDialog1.FileName; bool flag = MicrosoftWordHelper.GetCsvFromDataTable(_table, savePath, 0); { if (XtraMessageBox.Show("导出文件列表清单成功,是否立即打开?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { WinFormOpenHelper.OpenWinForm(0, "open", savePath, null, null, ShowWindowCommands.SW_NORMAL); } } } } else { SplashScreenManager.CloseDefaultSplashScreen(); XtraMessageBox.Show("当前批次下尚无项目/课题。", "导出文件列表清单失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btn_Export_Click(object sender, EventArgs e) { object KEY = "SAVE_PATH"; object value = SQLiteHelper.ExecuteOnlyOneQuery($"SELECT dd_name FROM data_dictionary WHERE dd_code='{KEY}'"); if (value != null) { /* ----复制文件----*/ pro_Show.Maximum = GetTotalFileAmountBySpiId(UserHelper.GetUser().UserSpecialId); int count = pro_Show.Maximum, okcount = 0, nocount = 0; string rootFolder = value + "\\" + SQLiteHelper.ExecuteOnlyOneQuery($"SELECT spi_name FROM special_info WHERE spi_id='{UserHelper.GetUser().UserSpecialId}'"); if (!Directory.Exists(rootFolder)) { Directory.CreateDirectory(rootFolder); } //专项下的文件 CopyFile(ref okcount, ref nocount, rootFolder, GetFileLinkByObjId(UserHelper.GetUser().UserSpecialId)); //专项下的项目 List <object[]> list2 = SQLiteHelper.ExecuteColumnsQuery($"SELECT pi_id, pi_name FROM project_info WHERE pi_obj_id='{UserHelper.GetUser().UserSpecialId}'", 2); for (int i = 0; i < list2.Count; i++) { string _rootFolder = rootFolder + "\\" + list2[i][1]; if (!Directory.Exists(_rootFolder)) { Directory.CreateDirectory(_rootFolder); } //项目下的文件 CopyFile(ref okcount, ref nocount, _rootFolder, GetFileLinkByObjId(list2[i][0])); //项目下的课题 List <object[]> list5 = SQLiteHelper.ExecuteColumnsQuery($"SELECT ti_id, ti_name FROM topic_info WHERE ti_obj_id='{list2[i][0]}'", 2); for (int j = 0; j < list5.Count; j++) { string _rootFolder2 = _rootFolder + "\\" + list5[j][1]; if (!Directory.Exists(_rootFolder2)) { Directory.CreateDirectory(_rootFolder2); } //课题下的文件 CopyFile(ref okcount, ref nocount, _rootFolder2, GetFileLinkByObjId(list5[j][0])); //课题下的子课题 List <object[]> list6 = SQLiteHelper.ExecuteColumnsQuery($"SELECT si_id, si_name FROM subject_info WHERE si_obj_id='{list5[j][0]}'", 2); for (int k = 0; k < list6.Count; k++) { string _rootFolder3 = _rootFolder2 + "\\" + list6[k][1]; if (!Directory.Exists(_rootFolder3)) { Directory.CreateDirectory(_rootFolder3); } CopyFile(ref okcount, ref nocount, _rootFolder3, GetFileLinkByObjId(list6[k][0])); } } //项目下的子课题 List <object[]> list7 = SQLiteHelper.ExecuteColumnsQuery($"SELECT si_id, si_name FROM subject_info WHERE si_obj_id='{list2[i][0]}'", 2); for (int j = 0; j < list7.Count; j++) { string _rootFolder2 = _rootFolder + "\\" + list7[j][1]; if (!Directory.Exists(_rootFolder2)) { Directory.CreateDirectory(_rootFolder2); } CopyFile(ref okcount, ref nocount, _rootFolder2, GetFileLinkByObjId(list7[j][0])); } } //专项下的课题 List <object[]> list4 = SQLiteHelper.ExecuteColumnsQuery($"SELECT ti_id, ti_name FROM topic_info WHERE ti_obj_id='{UserHelper.GetUser().UserSpecialId}'", 2); for (int i = 0; i < list4.Count; i++) { string _rootFolder = rootFolder + "\\" + list4[i][1]; if (!Directory.Exists(_rootFolder)) { Directory.CreateDirectory(_rootFolder); } //课题下的文件 CopyFile(ref okcount, ref nocount, _rootFolder, GetFileLinkByObjId(list4[i][0])); //课题下的子课题 List <object[]> list6 = SQLiteHelper.ExecuteColumnsQuery($"SELECT si_id, si_name FROM subject_info WHERE si_obj_id='{list4[i][0]}'", 2); for (int k = 0; k < list6.Count; k++) { string _rootFolder3 = _rootFolder + "\\" + list6[k][1]; if (!Directory.Exists(_rootFolder3)) { Directory.CreateDirectory(_rootFolder3); } CopyFile(ref okcount, ref nocount, _rootFolder3, GetFileLinkByObjId(list6[k][0])); } } MessageBox.Show($"备份完成,共计{count}个文件,成功{okcount}个,失败{nocount}个。", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); /* ----合成文件清单----*/ string filePath = value + "\\重大专项项目(课题)档案交接清单"; MicrosoftWordHelper.WriteDocument(filePath, list); if (MessageBox.Show("文件清单合成完毕, 是否需要现在打开?", "温馨提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { LoadDocumnet(filePath); } Close(); } else { MessageBox.Show("尚未指定文件存放路径。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
/// <summary> /// 导出缺失文件清单 /// </summary> private void CreateLostFileList() { SplashScreenManager.ShowDefaultWaitForm(this, false, false); idList = new List <object>(); string querySQL = "SELECT A.pi_id id, A.pi_code '项目/课题编号', A.pi_name '项目/课题名称', A.pi_unit '承担单位', A.pi_prouser '项目负责人', A.pi_start_datetime '项目开始时间', A.pi_end_datetime '项目结束时间', dd.dd_name '缺失文件类别', dd.dd_note '缺失文件名称', dd2.dd_name '缺失原因', pfo.pfo_remark '备注' " + "FROM transfer_registration_pc trp " + "LEFT JOIN imp_info ii ON ii.imp_obj_id=trp.trp_id " + "LEFT JOIN imp_dev_info idi ON idi.imp_obj_id=ii.imp_id " + "LEFT JOIN( " + "SELECT pi_id, pi_code, pi_name, pi_unit, pi_prouser, pi_start_datetime, pi_end_datetime, pi_obj_id FROM project_info WHERE pi_categor=2 UNION ALL " + "SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor=-3)A ON A.pi_obj_id=idi.imp_id " + "INNER JOIN processing_file_lost pfo ON (pfo.pfo_obj_id = A.pi_id AND pfo.pfo_ismust=1) " + "LEFT JOIN data_dictionary dd ON pfo.pfo_categor = dd.dd_name " + "LEFT JOIN data_dictionary dd2 ON pfo.pfo_reason = dd2.dd_id " + $"WHERE trp.trp_id='{trpId}' AND A.pi_id IS NOT NULL ORDER BY A.pi_code, dd.dd_name "; DataTable table = SqlHelper.ExecuteQuery(querySQL); if (table.Rows.Count > 0) { DataTable _table = table.Copy(); foreach (DataRow row in table.Rows) { object projectID = row["id"]; if (idList.Contains(projectID)) { continue; } else { idList.Add(projectID); } string topicQuerySql = "SELECT B.ti_id id, B.ti_code '项目/课题编号', B.ti_name '项目/课题名称', B.ti_unit '承担单位', B.ti_prouser '项目负责人', B.ti_start_datetime '项目开始时间', B.ti_end_datetime '项目结束时间', dd.dd_name '缺失文件类别', dd.dd_note '缺失文件名称', dd2.dd_name '缺失原因', pfo.pfo_remark '备注' FROM (" + "SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor=3 UNION ALL " + "SELECT si_id, si_code, si_name, si_unit, si_prouser, si_start_datetime, si_end_datetime, si_obj_id FROM subject_info) B " + "INNER JOIN processing_file_lost pfo ON (pfo.pfo_obj_id = B.ti_id AND pfo.pfo_ismust=1) " + "LEFT JOIN data_dictionary dd ON pfo.pfo_categor = dd.dd_name " + "LEFT JOIN data_dictionary dd2 ON pfo.pfo_reason = dd2.dd_id " + $"WHERE B.ti_obj_id='{projectID}' ORDER BY B.ti_code, dd.dd_name "; DataTable topicTable = SqlHelper.ExecuteQuery(topicQuerySql); _table.Merge(topicTable); } SplashScreenManager.CloseDefaultSplashScreen(); saveFileDialog1.Title = "请选择导出位置"; saveFileDialog1.Filter = "CSV文件|*.csv"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string savePath = saveFileDialog1.FileName; bool flag = MicrosoftWordHelper.GetCsvFromDataTable(_table, savePath, 0); { if (XtraMessageBox.Show("导出缺失文件清单成功,是否立即打开?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { WinFormOpenHelper.OpenWinForm(0, "open", savePath, null, null, ShowWindowCommands.SW_NORMAL); } } } } else { string querySQL2 = "SELECT A.pi_id id, A.pi_code '项目/课题编号', A.pi_name '项目/课题名称', A.pi_unit '承担单位', A.pi_prouser '项目负责人', A.pi_start_datetime '项目开始时间', A.pi_end_datetime '项目结束时间', dd.dd_name '缺失文件类别', dd.dd_note '缺失文件名称', dd2.dd_name '缺失原因', pfo.pfo_remark '备注' " + "FROM transfer_registration_pc trp " + "LEFT JOIN project_info pi ON pi.pi_categor=1 AND pi.trc_id=trp.trp_id " + "LEFT JOIN( " + "SELECT pi_id, pi_code, pi_name, pi_unit, pi_prouser, pi_start_datetime, pi_end_datetime, pi_obj_id FROM project_info WHERE pi_categor=2 UNION ALL " + "SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor=-3) A ON A.pi_obj_id=pi.pi_id " + "INNER JOIN processing_file_lost pfo ON (pfo.pfo_obj_id = A.pi_id AND pfo_ismust=1) " + "LEFT JOIN data_dictionary dd ON pfo.pfo_categor = dd.dd_name " + "LEFT JOIN data_dictionary dd2 ON pfo.pfo_reason = dd2.dd_id " + $"WHERE trp.trp_id='{trpId}' AND pi.pi_id IS NOT NULL ORDER BY A.pi_code, dd.dd_name"; DataTable table2 = SqlHelper.ExecuteQuery(querySQL2); if (table2.Rows.Count > 0) { DataTable _table = table2.Copy(); foreach (DataRow row in table2.Rows) { object projectID = row["id"]; if (idList.Contains(projectID)) { continue; } else { idList.Add(projectID); } string topicQuerySql = "SELECT B.ti_id id, B.ti_code '项目/课题编号', B.ti_name '项目/课题名称', B.ti_unit '承担单位', B.ti_prouser '项目负责人', B.ti_start_datetime '项目开始时间', B.ti_end_datetime '项目结束时间', dd.dd_name '缺失文件类别', dd.dd_note '缺失文件名称', dd2.dd_name '缺失原因', pfo.pfo_remark '备注' " + "FROM ( " + "SELECT ti_id, ti_code, ti_name, ti_unit, ti_prouser, ti_start_datetime, ti_end_datetime, ti_obj_id FROM topic_info WHERE ti_categor=3 UNION ALL " + "SELECT si_id, si_code, si_name, si_unit, si_prouser, si_start_datetime, si_end_datetime, si_obj_id FROM subject_info) B " + "INNER JOIN processing_file_lost pfo ON (pfo.pfo_obj_id = B.ti_id AND pfo.pfo_ismust=1) " + "LEFT JOIN data_dictionary dd ON pfo.pfo_categor = dd.dd_name " + "LEFT JOIN data_dictionary dd2 ON pfo.pfo_reason = dd2.dd_id " + $"WHERE B.ti_obj_id='{projectID}' ORDER BY B.ti_code, dd.dd_name "; DataTable topicTable = SqlHelper.ExecuteQuery(topicQuerySql); _table.Merge(topicTable); } SplashScreenManager.CloseDefaultSplashScreen(); saveFileDialog1.Title = "请选择导出位置"; saveFileDialog1.Filter = "CSV文件|*.csv"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string savePath = saveFileDialog1.FileName; bool flag = MicrosoftWordHelper.GetCsvFromDataTable(_table, savePath, 0); { if (XtraMessageBox.Show("导出缺失文件清单成功,是否立即打开?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { WinFormOpenHelper.OpenWinForm(0, "open", savePath, null, null, ShowWindowCommands.SW_NORMAL); } } } } else { SplashScreenManager.CloseDefaultSplashScreen(); XtraMessageBox.Show("当前批次下尚无缺失文件记录。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } }