private void Button1_Click(object sender, EventArgs e) { RealabilityReport realability = new RealabilityReport(); DateTime from = dtPickerFrom.Value; DateTime to = dtPickerTo.Value; // realability.GetDataBackLogToExport(out listShipingResult); List <RawReliability> realabilityItems = realability.GetDataRawReliability(from, to); var temp = realabilityItems.Where(d => d.DepartmentCode == "").ToList(); Dictionary <string, Dictionary <string, List <ReliabilitySummary> > > GetdataGroupByClient = realability.SortbyClientRealitykeyValuePairs(realabilityItems); List <ReliabilitySummary> listReliabilityToShow = new List <ReliabilitySummary>(); foreach (var ClientsGroup in GetdataGroupByClient) { foreach (var DeptGroup in ClientsGroup.Value) { foreach (var item in DeptGroup.Value) { listReliabilityToShow.Add(item); } } } dataGridView1.DataSource = listReliabilityToShow; }
private void Button4_Click(object sender, EventArgs e) { DateTime from = dtPickerFrom.Value; DateTime to = dtPickerTo.Value; //Class.DateTimeControl.ReturnDateTimeForWeekly(ref from, ref to); //Class.DateTimeControl.ReturnDateTimeForMonthly(ref from, ref to); ExportExcelTool exportExcelTool = new ExportExcelTool(); string path = @"C:\ERP_Temp\Reliability Report_" + DateTime.Now.ToString("ddMMyy HHmmss") + ".xlsx"; string pathTemplate = Environment.CurrentDirectory + @"\Resources\Reliability.xlsx"; RealabilityReport realabilityReport = new RealabilityReport(); // realabilityReport.SendMailReliabilityReportWeekly(); List <ReliabilitySummary> ListReliability = new List <ReliabilitySummary>(); List <ReliabilitySummary> ListReliabilityDept = new List <ReliabilitySummary>(); ListReliability = realabilityReport.GetDataForReliability(from, to, out ListReliabilityDept); exportExcelTool.ExportToReliabilityReport(pathTemplate, path, ListReliability, ListReliabilityDept, from, to); }
private void Button2_Click(object sender, EventArgs e) { RealabilityReport realability = new RealabilityReport(); DateTime from = dtPickerFrom.Value; DateTime to = dtPickerTo.Value; // realability.GetDataBackLogToExport(out listShipingResult); List <RawReliability> realabilityItems = realability.GetDataRawReliability(from, to); //Dictionary<string, Dictionary<string, List<ReliabilitySummary>>> // GetdataGroupByClient = realability.SortbyClientRealitykeyValuePairs(realabilityItems); //List<ReliabilitySummary> listReliabilityToShow = new List<ReliabilitySummary>(); //foreach (var ClientsGroup in GetdataGroupByClient) //{ // foreach (var DeptGroup in ClientsGroup.Value) // { // foreach (var item in DeptGroup.Value) // { // listReliabilityToShow.Add(item); // } // } //} dataGridView1.DataSource = realabilityItems; }