protected void btnSearch_Click(object sender, EventArgs e) { if (fileImport.HasFile) { if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"))) { Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")); } string date = DateTime.Now.ToString("yyyyMMddHHmmss"); string path = Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv"; if (File.Exists(path)) { File.Delete(path); } fileImport.PostedFile.SaveAs(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv"); if (File.Exists(path)) { DataTable returnTable = ImportExcelToDataTable.ConvertCSVtoDataTable(path); if (returnTable != null && returnTable.Rows.Count > 0) { for (int i = 0; i < returnTable.Rows.Count; i++) { try { DataRow row = returnTable.Rows[i]; #region Import TongHopDanhGiaCaNhanThangInfo info = new TongHopDanhGiaCaNhanThangInfo(); info.BoPhan = row[0].ToString(); info.HoTen = row[1].ToString(); info.KPI = ConvertUtility.ToDouble(row[2].ToString().Replace(".", ",")) * 100; info.DiemDanhGiaDonVi = ConvertUtility.ToDouble(row[3].ToString().Replace(".", ",")) * 100; info.LoiNhuanCongTy = ConvertUtility.ToDouble(row[4].ToString().Replace(".", ",")) * 100; info.LoiNhuanBoPhan = ConvertUtility.ToDouble(row[5].ToString().Replace(".", ",")) * 100; info.QuanLyCongViecVaPhoiHop = ConvertUtility.ToDouble(row[6].ToString().Replace(".", ",")) * 100; info.KyLuatCaNhan = ConvertUtility.ToDouble(row[7].ToString().Replace(".", ",")) * 100; info.DiemThuong = ConvertUtility.ToDouble(row[8].ToString().Replace(".", ",")); info.MucDoHoanThanh = ConvertUtility.ToDouble(row[9].ToString().Replace(".", ",")) * 100; info.XepLoai = row[10].ToString(); info.HeSoLuongMem = ConvertUtility.ToDouble(row[11].ToString().Replace(".", ",")) * 100; info.Nam = ConvertUtility.ToInt32(dropNam.SelectedValue); info.Thang = ConvertUtility.ToInt32(dropThang.SelectedValue); TongHopDanhGiaCaNhanThangController.Insert(info); #endregion } catch { continue; } } lblUpdateStatus.Text = "Bạn đã import thành công file \"" + fileImport.FileName + "\""; } else { lblUpdateStatus.Text = "File import sai định dạng"; } } else { lblUpdateStatus.Text = "File import sai định dạng"; } } else { lblUpdateStatus.Text = "File import sai định dạng"; } }
protected void btnExport_Click(object sender, EventArgs e) { XmlDocument xmlDoc = new XmlDocument(); // Write down the XML declaration XmlDeclaration xmlDeclaration = xmlDoc.CreateXmlDeclaration("1.0", "utf-8", null); // Create the root element XmlElement rootNode = xmlDoc.CreateElement("ReportDataSet"); xmlDoc.InsertBefore(xmlDeclaration, xmlDoc.DocumentElement); xmlDoc.AppendChild(rootNode); DataTable dt = BoPhanController.BoPhan_GetAllActive(); foreach (DataRow item in dt.Rows) { string desc = item["MoTa"].ToString(); string ten = item["Ten"].ToString(); XmlElement Node = xmlDoc.CreateElement("Table" + desc); rootNode.AppendChild(Node); DataTable dtNhanVien = TongHopDanhGiaCaNhanThangController.GetAllNhanVien(ten, ConvertUtility.ToInt32(dropNam.SelectedValue)); int stt = 1; foreach (DataRow itemNhanVien in dtNhanVien.Rows) { DataTable dtDataOfNhanVien = TongHopDanhGiaCaNhanThangController.GetAll(ten, ConvertUtility.ToInt32(dropNam.SelectedValue), itemNhanVien["HoTen"].ToString()); xmlDoc = BuildXmlDocument(dtDataOfNhanVien, xmlDoc, Node, stt, itemNhanVien["HoTen"].ToString()); stt++; } } if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"))) { Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")); } //ds.Dispose(); string datetime = DateTime.Now.ToString("yyyyMMddHHmmss"); FileStream downloadFile = File.Create(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + "TongHopBaoCaoXepLoaiNhanVien_" + datetime + ".xls"); // transform XslTransform xsl = new XslTransform(); xsl.Load(Server.MapPath("/Template/" + "ReportTongHopXepLoaiNhanVien.xsl")); xsl.Transform(xmlDoc, null, downloadFile, null); downloadFile.Flush(); downloadFile.Close(); if (AppEnv.GetLanguage() == "vi-VN") { hplDownload.Text = "Hãy click vào liên kết này để Tải file về"; } else { hplDownload.Text = "Please, click here to download file"; } hplDownload.NavigateUrl = "/UpLoad/Temp/" + CurrentUser.UserID + "/TongHopBaoCaoXepLoaiNhanVien_" + datetime + ".xls"; }