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);
}
}
}
