Beispiel #1
0
 private void ExportDocRec()
 {
     saveFileDialog1.Title  = "请选择导出档案接收确认函Word文件位置...";
     saveFileDialog1.Filter = "Word文件|*.doc";
     if (saveFileDialog1.ShowDialog() == DialogResult.OK)
     {
         SplashScreenManager.ShowDefaultWaitForm(this, false, false);
         string       savePath = saveFileDialog1.FileName;
         StreamWriter sw;
         try
         {
             sw = new StreamWriter(savePath, false, Encoding.Default);
             sw.WriteLine(GetDomRecHTML());
             sw.Flush();
             sw.Close();
             SplashScreenManager.CloseDefaultSplashScreen();
             if (XtraMessageBox.Show("导出档案接收确认函成功,是否立即打开?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
             {
                 WinFormOpenHelper.OpenWinForm(0, "open", savePath, null, null, ShowWindowCommands.SW_NORMAL);
             }
         }
         catch (Exception ex)
         {
             LogsHelper.AddErrorLogs("导出错误", ex.Message);
         }
     }
 }
Beispiel #2
0
        private void listBox1_MouseDoubleClick(object sender, System.Windows.Forms.MouseEventArgs e)
        {
            EntityList item = (EntityList)listBox1.SelectedItem;

            if (XtraMessageBox.Show("是否打开文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
            {
                if (System.IO.File.Exists(item.Path))
                {
                    Hide();
                    WinFormOpenHelper.OpenWinForm(0, "open", item.Path, null, null, ShowWindowCommands.SW_NORMAL);
                }
                else
                {
                    XtraMessageBox.Show("文件不存在。");
                }
            }
        }
Beispiel #3
0
        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("请先选择导出路径。");
            }
        }
Beispiel #4
0
        /// <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);
                }
            }
        }
Beispiel #5
0
        /// <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);
                }
            }
        }