private void menuItemInformDaysOver14_Click(object sender, EventArgs e) { InformDaysOver14ReportDialog informDaysOver14ReportDialog = new InformDaysOver14ReportDialog(); if (informDaysOver14ReportDialog.ShowDialog() == DialogResult.OK) { SaveFileDialog saveDiag = new SaveFileDialog(); saveDiag.Filter = XLSX_FILTER; if (saveDiag.ShowDialog() == DialogResult.OK) { ClaimOrderDao claimOrderDao = new ClaimOrderDao(); IDictionary <ClaimOrder, double> claimOrders = claimOrderDao.FindInformDaysOver14(informDaysOver14ReportDialog.LastAccountDate.Date); Workbook workbook = Exporter.ReportGenerator.GenerateOver14DaysReport(claimOrders); try { workbook.Save(saveDiag.FileName); SetStatusLabelLinkText("导出成功! 点击打开: " + saveDiag.FileName, saveDiag.FileName); } catch (IOException) { MessageBox.Show("文件被其他程序占用。", "失败!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void menuItemInformDaysOver50_Click(object sender, EventArgs e) { InformDateOver50DaysReportCriteriaDialog criteriaDialog = new InformDateOver50DaysReportCriteriaDialog(); if (criteriaDialog.ShowDialog() == DialogResult.OK) { SaveFileDialog saveDiag = new SaveFileDialog(); saveDiag.Filter = XLSX_FILTER; if (saveDiag.ShowDialog() == DialogResult.OK) { ClaimOrderDao claimOrderDao = new ClaimOrderDao(); IList <ClaimOrder> claimOrders = claimOrderDao.FindInformDaysBetween(50, criteriaDialog.InformDaysUpperLimit); Workbook workbook = Exporter.ReportGenerator.GenerateInformDaysBetweenReport(claimOrders); try { workbook.Save(saveDiag.FileName); SetStatusLabelLinkText("导出成功! 点击打开: " + saveDiag.FileName, saveDiag.FileName); } catch (IOException) { MessageBox.Show("文件被其他程序占用。", "失败!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
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); }
private void menuItemClearOutOfDateData_Click(object sender, EventArgs e) { ClaimOrderDao claimOrderDao = new ClaimOrderDao(); int deletedCnt = claimOrderDao.DeleteCreationDayBefore(DateTime.Today); StatusLabelText = String.Format("成功删除{0}条数据!", deletedCnt); ChangeStatusLabelColor(); }
public IList <string> Validate() { ClaimOrderDao claimOrderDao = new ClaimOrderDao(); Dictionary <ClaimOrderUK, ClaimOrder> yesterdayClaimOrders = new Dictionary <ClaimOrderUK, ClaimOrder>(new ClaimOrderUKEqualityComparer()); foreach (ClaimOrder yesterdayClaimOrder in claimOrderDao.FindYesterdaysClaimOrders()) { ClaimOrderUK uk = new ClaimOrderUK(); uk.claimNo = yesterdayClaimOrder.claimNo; uk.decidedDate = yesterdayClaimOrder.decidedDate; uk.claimAmount = yesterdayClaimOrder.claimAmount; yesterdayClaimOrders[uk] = yesterdayClaimOrder; } IList <string> errorStrs = new List <string>(); for (int i = 0; i < _claimOrders.Count; i++) { ClaimOrder todayClaimOrder = _claimOrders[i]; ClaimOrderUK uk = new ClaimOrderUK(); uk.claimNo = todayClaimOrder.claimNo; uk.decidedDate = todayClaimOrder.decidedDate; uk.claimAmount = todayClaimOrder.claimAmount; if (yesterdayClaimOrders.ContainsKey(uk)) { ClaimOrder yesterdayClaimOrder = yesterdayClaimOrders[uk]; string errorStr = string.Empty; if (yesterdayClaimOrder.gateOutDate.Equals(todayClaimOrder.gateOutDate) == false) { if (!DateTimeUtils.IsEmpty(yesterdayClaimOrder.gateOutDate)) { errorStr = String.Format("第{0}行数据与前一天的出库日期不符。索赔号:{1}。", (i + 1 /*zero base*/ + 1 /*excel header*/), yesterdayClaimOrder.claimNo); } } if (yesterdayClaimOrder.informDate.Equals(todayClaimOrder.informDate) == false) { if (!DateTimeUtils.IsEmpty(yesterdayClaimOrder.informDate)) { errorStr = String.Format("第{0}行数据与前一天的通知日期不符。索赔号:{1}。", (i + 1 /*zero base*/ + 1 /*excel header*/), yesterdayClaimOrder.claimNo); } } if (!string.IsNullOrEmpty(errorStr)) { errorStrs.Add(errorStr); } } } return(errorStrs); }
private void btnSearch_Click(object sender, EventArgs e) { if (IsImporting()) { return; } string supplierNo = txtSuppilerNo.Text; string claimNo = txtClaimNo.Text; ClaimOrderDao claimOrderDao = new ClaimOrderDao(); IList <ClaimOrder> claimOrders = claimOrderDao.Find(supplierNo, claimNo); RefillResultGrid(claimOrders); }
private void bgwImporter_DoWork(object sender, DoWorkEventArgs e) { const int BulkCount = 100; ClaimOrderDao claimOrderDao = new ClaimOrderDao(); int progress = (int)((object[])e.Argument)[1]; List <ClaimOrder> claimOrders = (List <ClaimOrder>)((object[])e.Argument)[0]; int actualBulkCount = Math.Min(BulkCount, claimOrders.Count - progress); claimOrderDao.Save(claimOrders.GetRange(progress, actualBulkCount)); progress += actualBulkCount; object[] results = new object[2]; results[0] = claimOrders; results[1] = progress; e.Result = results; }
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); } } }