public void GetTotalReport() { //for each files merge total reports foreach (LogFile logFile in LogFiles) { foreach (KeyValuePair <Guid, TotalReportItem> item in logFile.GetTotalReportFile()) { if (TotalReport.ContainsKey(item.Key)) { TotalReport[item.Key].UserCount++; TotalReport[item.Key].FileCount += item.Value.FileCount; } else { TotalReport.Add(item.Key, new TotalReportItem(item.Key, item.Value.UserCount, item.Value.FileCount)); } } } string pathString = SavePath + "\\TotalReport.csv"; //get list for serialize List <TotalReportItem> list = new List <TotalReportItem>(); list = TotalReport.Values.ToList(); //sort descending list.Sort((x, y) => x.UserCount < y.UserCount?1:x.UserCount == y.UserCount?0:-1); //write in file Serialize(list, pathString); }
public __WEEK_OPTIONS_Signal(object _ctx) : base(_ctx) { this.Range = 150; __cList = new List<Report[]>(4096); __cExchange = ProductManager.Manager.GetExchange("TWSE"); __cTReports = new TotalReport[7]; for (int i = 0; i < 7; i++) { __cTReports[i] = new TotalReport(); } }
/// <summary> /// Get similar report, recommend report, report detail /// </summary> /// <param name="reportId"></param> /// <param name="topSimilarCompany"></param> /// <param name="topRecommended"></param> /// <returns></returns> public ReportPageDetail GetSimilarReportAndRecommendReportAndDetailReport(int reportId, int topSimilarCompany, int topRecommended) { IMultipleResultSet multipleResult = DbContext.QueryMultipleResult("spReportSelectDetailAndSimilarCompanyAndRecommendReport", new { reportId, topSimilarCompany, topRecommended }); Report _report = multipleResult.GetSingle<Report>(); List<Report> lstSimilarReport = multipleResult.Get<Report>().ToList(); List<Report> lstRecommendedReport = multipleResult.Get<Report>().ToList(); TotalReport totalReport = multipleResult.GetSingle<TotalReport>(); ReportPageDetail reportPageDetail = new ReportPageDetail(); reportPageDetail.ReportDetail = _report; reportPageDetail.SimilarReports = lstSimilarReport; reportPageDetail.RecommendedReports = lstRecommendedReport; reportPageDetail.TotalCompanyReport = totalReport.TotalSameCompanyReport; return reportPageDetail; }
private void xemBaoCaoForm_Load(object sender, EventArgs e) { if (reportType == "monthly") { this.Text = "EMS - Báo Cáo Điện " + monthlyReportType + " Tháng " + thang.ToString() + ", Năm " + nam.ToString() + ", Trạm Số " + soTram; if (monthlyReportType == "Sinh Hoạt") { shReport = new MonthlyReport_SH(); shReport.SetDataSource(DataTier.fillMonthlyReport(tramID, thang, nam, 1)); string[] giaSH = DataTier.getPrice("e00f133e-f43c-4dc5-8ebb-a747200416c9").Split(','); shReport.SetParameterValue("giaDienMuc1", giaSH[0]); shReport.SetParameterValue("giaDienMuc2", giaSH[1]); shReport.SetParameterValue("giaDienMuc3", giaSH[2]); shReport.SetParameterValue("giaDienMuc4", giaSH[3]); shReport.SetParameterValue("giaDienMuc5", giaSH[4]); shReport.SetParameterValue("giaDienMuc6", giaSH[5]); shReport.SetParameterValue("soTram", soTram); shReport.SetParameterValue("ngayBatDau", DataTier.getDuration(tramID)); shReport.SetParameterValue("ngayKetThuc", DataTier.getDuration(tramID)); if (thang == 1) { shReport.SetParameterValue("thangBatDau", "12"); shReport.SetParameterValue("namBatDau", (nam - 1).ToString()); } else { shReport.SetParameterValue("thangBatDau", (thang - 1).ToString()); shReport.SetParameterValue("namBatDau", nam.ToString()); } shReport.SetParameterValue("thangKetThuc", thang.ToString()); shReport.SetParameterValue("namKetThuc", nam.ToString()); shReport.SetParameterValue("ngayKy", DataTier.getReportDate(tramID)); shReport.SetParameterValue("thangKy", thang.ToString()); shReport.SetParameterValue("namKy", nam.ToString()); double tongTien = DataTier.getTongTienPhatSinh(tramID, thang, nam, "1") + DataTier.getTongNo(tramID, thang, nam, "1"); shReport.SetParameterValue("moneyReader", Program.moneyReader(System.Math.Round(tongTien).ToString())); crvReport.ReportSource = shReport; } else if (monthlyReportType == "Mục Đích Khác") { mdkReport = new MonthlyReport_MDK(); mdkReport.SetDataSource(DataTier.fillMonthlyReport(tramID, thang, nam, 0)); mdkReport.SetParameterValue("giaHC", DataTier.getPrice("068b5479-814c-4576-86ea-8684b07ffb4a")); mdkReport.SetParameterValue("giaKD1", DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb")); mdkReport.SetParameterValue("giaKD2", DataTier.getPrice("3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d")); mdkReport.SetParameterValue("giaSX1", DataTier.getPrice("a8794644-b056-41dd-b515-bec60477947a")); mdkReport.SetParameterValue("giaSX2", DataTier.getPrice("d4770373-51bb-4d7a-90d1-327c7043cdeb")); mdkReport.SetParameterValue("gia30SX3", DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb")); mdkReport.SetParameterValue("gia70SX3", DataTier.getPrice("422cf080-b750-411d-a895-9550b8950b66")); mdkReport.SetParameterValue("soTram", soTram); mdkReport.SetParameterValue("ngayBatDau", DataTier.getDuration(tramID)); mdkReport.SetParameterValue("ngayKetThuc", DataTier.getDuration(tramID)); if (thang == 1) { mdkReport.SetParameterValue("thangBatDau", "12"); mdkReport.SetParameterValue("namBatDau", (nam - 1).ToString()); } else { mdkReport.SetParameterValue("thangBatDau", (thang - 1).ToString()); mdkReport.SetParameterValue("namBatDau", nam.ToString()); } mdkReport.SetParameterValue("thangKetThuc", thang.ToString()); mdkReport.SetParameterValue("namKetThuc", nam.ToString()); mdkReport.SetParameterValue("ngayKy", DataTier.getReportDate(tramID)); mdkReport.SetParameterValue("thangKy", thang.ToString()); mdkReport.SetParameterValue("namKy", nam.ToString()); double tongTien = DataTier.getTongTienPhatSinh(tramID, thang, nam, "0") + DataTier.getTongNo(tramID, thang, nam, "0"); mdkReport.SetParameterValue("moneyReader", Program.moneyReader(System.Math.Round(tongTien).ToString())); crvReport.ReportSource = mdkReport; } } else if (reportType == "tongHop") { this.Text = "EMS - Báo Cáo Tổng Hợp Tháng " + thang.ToString() + ", Năm " + nam.ToString() + ", Trạm Số " + soTram; bcth = new TotalReport(); bcth.SetParameterValue("thang", thang.ToString()); bcth.SetParameterValue("nam", nam.ToString()); bcth.SetParameterValue("ngayKy", DataTier.getReportDate(tramID)); bcth.SetParameterValue("soTram", "Số " + soTram); bcth.SetParameterValue("tongHoSH", soHoSH); bcth.SetParameterValue("tongHoMDK", soHoMDK); bcth.SetParameterValue("tongDienNhan", tongDienNhan); bcth.SetParameterValue("dienSH", tongNhanSH); bcth.SetParameterValue("dienMDK", tongNhanMDK); bcth.SetParameterValue("tongThanhToan", tongTienThanhToan); int tongDienThu = DataTier.getTongDienByMD(tramID, thang, nam, "all"); bcth.SetParameterValue("tongDienThu", tongDienThu); bcth.SetParameterValue("dienThuSH", DataTier.getTongDienByMD(tramID, thang, nam, "e00f133e-f43c-4dc5-8ebb-a747200416c9")); bcth.SetParameterValue("dienThuMDK", DataTier.getTongDienByMD(tramID, thang, nam, "0")); double tyLeTonThat = tongDienNhan - tongDienThu; tyLeTonThat = tyLeTonThat / tongDienNhan; tyLeTonThat = tyLeTonThat * 100; bcth.SetParameterValue("tyLeTonThat", tyLeTonThat.ToString("N2") + "%"); bcth.SetParameterValue("tienPhatSinh", DataTier.getTongTienPhatSinh(tramID, thang, nam, "all")); bcth.SetParameterValue("tienNoCu", DataTier.getTongNo(tramID, thang, nam, "all")); crvReport.ReportSource = bcth; } else if (reportType == "thuChi") { this.Text = "EMS - Báo Cáo Thu Chi"; } else if (reportType == "theoDoiChuyenTien") { this.Text = "EMS - Bảng Theo Dõi Chuyển Tiền"; tdctReport = new TheoDoiChuyenTien(); tdctReport.SetDataSource(this.DataSource); crvReport.ReportSource = tdctReport; } else if (reportType == "theoDoiHHDV") { this.Text = "EMS - Bảng Theo Dõi Hàng Hóa Dịch Vụ"; hhdvReport = new TheoDoiHHDV(); hhdvReport.SetDataSource(this.DataSource); crvReport.ReportSource = hhdvReport; } else if (reportType == "theoDoiGTGT") { this.Text = "EMS - Bảng Theo Dõi Thuế GTGT"; gtgtReport = new TheoDoiGTGT(); gtgtReport.SetDataSource(this.DataSource); crvReport.ReportSource = gtgtReport; } else if (reportType == "nhatKyChung") { this.Text = "EMS - Sổ Nhật Ký Chung"; nhatKyChungReport = new NhatKyChung(); nhatKyChungReport.SetDataSource(this.DataSource); crvReport.ReportSource = nhatKyChungReport; } }