private void button1_Click(object sender, EventArgs e)
        {
            var ret = MessageBox.Show("集計には時間がかかりますが、よろしいですか?", "月次データ", MessageBoxButtons.OKCancel);

            if (ret == System.Windows.Forms.DialogResult.Cancel)
            {
                return;
            }

            start = this.Dtp_AggregateMonth.Value.ToString("yyyyMM") + "01";
            end   = this.Dtp_AggregateMonth.Value.ToString("yyyyMM") + DateTime.DaysInMonth(this.Dtp_AggregateMonth.Value.Year, this.Dtp_AggregateMonth.Value.Month).ToString().PadLeft(2, '0');

            HospReports = new List <ExtReports>();

            foreach (var hosp in HospDistMsts)
            {
                if (hosp.Hospital.Name_DB == "KHM")
                {
                    int xx = 0;
                    xx++;
                }


                if (hosp.Hospital.IsCopy == "0")
                {
                    GetTargetReport(hosp);
                }
                else
                {
                    hosp.ParentCd = GetTargetReport_Child(hosp);
                }
            }

            Class_ExcelWork ew = new Class_ExcelWork();

            ew.HospReports     = HospReports;
            ew.HospDistMsts    = HospDistMsts;
            ew.RetdocList      = RetdocList;
            ew.ModalityList    = ModalityList;
            ew.ModalityDocList = ModalityDocList;
            ew.WriteExcel_Sheet_1(this.Dtp_AggregateMonth.Value, 0);

            MessageBox.Show("集計出力が完了いたしました。");
        }
        private void Btn_Accounting_Click(object sender, EventArgs e)
        {
            var ret = MessageBox.Show("集計には時間がかかりますが、よろしいですか?", "会計連携", MessageBoxButtons.OKCancel);

            if (ret == System.Windows.Forms.DialogResult.Cancel)
            {
                return;
            }

            start = this.Dtp_AggregateMonth.Value.ToString("yyyyMM") + "01";
            end   = this.Dtp_AggregateMonth.Value.ToString("yyyyMM") + DateTime.DaysInMonth(this.Dtp_AggregateMonth.Value.Year, this.Dtp_AggregateMonth.Value.Month).ToString().PadLeft(2, '0');

            Form_EditHosp edit = new Form_EditHosp();

            edit.form_menu = this;
            YayoiHosps     = new List <string>();
            edit.ShowDialog();

            if (YayoiHosps.Count == 0)
            {
                MessageBox.Show("出力施設が選択されていません。");
                return;
            }

            HospReports = new List <ExtReports>();

            foreach (var hosp in HospDistMsts)
            {
                if (!YayoiHosps.Contains(hosp.Hospital.Name_DB))
                {
                    continue;
                }

                if (hosp.Hospital.IsCopy == "0")
                {
                    GetTargetReport(hosp);
                }
                else
                {
                    hosp.ParentCd = GetTargetReport_Child(hosp);
                }
            }


            Class_ExcelWork ew = new Class_ExcelWork();

            ew.HospReports     = HospReports;
            ew.HospDistMsts    = HospDistMsts;
            ew.RetdocList      = RetdocList;
            ew.ModalityList    = ModalityList;
            ew.ModalityDocList = ModalityDocList;
            ew.YayoiHosps      = YayoiHosps;

            string msg_1;
            string msg_2;

            if (!CheckMod(out msg_1, out msg_2))
            {
                if (!string.IsNullOrEmpty(msg_1))
                {
                    ret = MessageBox.Show("設定されていないモダリティが集計されています。\n処理を継続してもよろしいですか?\n\n" + msg_1, "会計連携", MessageBoxButtons.OKCancel);
                    if (ret == System.Windows.Forms.DialogResult.Cancel)
                    {
                        return;
                    }
                }
                //if (!string.IsNullOrEmpty(msg_2))
                //{
                //    ret = MessageBox.Show("設定されているモダリティの中に、件数が0件のものが存在します。\n処理を継続してもよろしいですか?\n\n" + msg_2, "会計連携", MessageBoxButtons.OKCancel);
                //    if (ret == System.Windows.Forms.DialogResult.Cancel)
                //        return;
                //}
            }

            ew.WriteExcel_Sheet_5(this.Dtp_AggregateMonth.Value, 0);

            MessageBox.Show("出力が完了いたしました。");
        }