C# (CSharp) Class_ExcelWork.WriteExcel_Sheet_4 Examples

Example #1

File: Form_OutPutAggregate.cs Project: k-matsuda-85/dev-P-PC

        //ここから================================================イベント=========================================================

        private void Btn_OutPutAggregate_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.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);
            ew.WriteExcel_Sheet_2(this.Dtp_AggregateMonth.Value, 0);
            ew.WriteExcel_Sheet_3(this.Dtp_AggregateMonth.Value, 0);
            ew.WriteExcel_Sheet_4(this.Dtp_AggregateMonth.Value, 0);
            ew.WriteExcel_Sheet_6(this.Dtp_AggregateMonth.Value, 0);

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