public IList <string> Validate()
        {
            ClaimOrderDao      claimOrderDao = new ClaimOrderDao();
            IList <ClaimOrder> yesterdayOver64DaysDestoryReport =
                claimOrderDao.Find64DaysDestory(ClaimOrderDao.Day.Yesterday);

            IList <string> errorMsgs = new List <string>();

            foreach (ClaimOrder yesterdayOver64DaysClaimOrder in yesterdayOver64DaysDestoryReport)
            {
                for (int i = 0; i < _claimOrders.Count; i++)
                {
                    if (yesterdayOver64DaysClaimOrder.claimNo == _claimOrders[i].claimNo)
                    {
                        if (DateTimeUtils.IsEmpty(_claimOrders[i].destoryInformDate))
                        {
                            errorMsgs.Add(
                                String.Format("第{0}行销毁通知日期不能为空。索赔号:{1}",
                                              (i + 1 /*excel header*/ + 1 /*zero-based*/), _claimOrders[i].claimNo));
                        }
                    }
                }
            }

            return(errorMsgs);
        }
Пример #2
0
        private void menuItemDestoryOver64Days_Click(object sender, EventArgs e)
        {
            SaveFileDialog saveDiag = new SaveFileDialog();

            saveDiag.Filter = XLSX_FILTER;

            if (saveDiag.ShowDialog() == DialogResult.OK)
            {
                ClaimOrderDao      claimOrderDao = new ClaimOrderDao();
                IList <ClaimOrder> claimOrders   = claimOrderDao.Find64DaysDestory(ClaimOrderDao.Day.Today);
                Workbook           workbook      = Exporter.ReportGenerator.Generate64DaysDestoryReport(claimOrders);

                try
                {
                    workbook.Save(saveDiag.FileName);
                    SetStatusLabelLinkText("导出成功! 点击打开: " + saveDiag.FileName, saveDiag.FileName);
                }
                catch (IOException)
                {
                    MessageBox.Show("文件被其他程序占用。", "失败!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }