protected void Page_Load(object sender, EventArgs e) { QUANLYSINHVIENEntities dbContext = new QUANLYSINHVIENEntities(); DmSINHVIENDAP dapSINHVIEN = new DmSINHVIENDAP(dbContext); DmLOPHOCDAP dapLOPHOCDAO = new DmLOPHOCDAP(dbContext); THETHAO_SINHVIENDAP dapTHETHAO_SINHVIEN = new THETHAO_SINHVIENDAP(dbContext); itemId = !string.IsNullOrEmpty(Request["itemid"]) ? Request["itemid"].ToString() : ""; if (itemId.Length > 0) { objSINHVIEN = dapSINHVIEN.GetById(itemId); } ; objLOPHOC.AddRange(dapLOPHOCDAO.getListAll()); lstTHETHAO_SINHVIEN = dapTHETHAO_SINHVIEN.GetById(itemId); if (lstTHETHAO_SINHVIEN.Count() > 0) { foreach (var itemTT in lstTHETHAO_SINHVIEN) { lstTHETHAO += itemTT.TENTHETHAO + " ,"; } lstTHETHAO = lstTHETHAO.Substring(0, lstTHETHAO.Length - 1); } else { } }
/// <summary> /// /// </summary> private void ExportWord() { DmSINHVIEN itemSV = dapSINHVIEN.GetById(itemId); lstTHETHAO_SINHVIEN = dapTHETHAO_SINHVIEN.GetById(itemId); if (itemSV != null) { //Khai báo đường dẫn khi file được lưu về máy string urlFileSave = "/AppFile/tmp/" + itemSV.ID + ".docx"; urlFileSave = Server.MapPath(urlFileSave); //Khai báo đường dẫn file word cần đọc string fileName = Server.MapPath("/AppFile/Docs/ExportWord.docx"); var dob = (itemSV.NGAYSINH).ToString("dd/MM/yyyy"); var sex = (itemSV.GIOITINH) == 1 ? "Nam" : "Nữ"; var lstTHETHAO = ""; using (DocX doc = DocX.Load(fileName)) { doc.ReplaceText("@hovaten", string.IsNullOrEmpty(itemSV.HOVATEN) ? "" : itemSV.HOVATEN); doc.ReplaceText("@sinhnam", dob == null ? "" : dob); doc.ReplaceText("@gioitinh", sex == null ? "" : sex); doc.ReplaceText("@lop", itemSV.DmLOPHOC.TENLOP); doc.ReplaceText("@diachi", string.IsNullOrEmpty(itemSV.DIACHI) ? "" : itemSV.DIACHI); doc.ReplaceText("@sdt", string.IsNullOrEmpty(itemSV.SDT) ? "" : itemSV.SDT); doc.ReplaceText("@email", string.IsNullOrEmpty(itemSV.EMAIL) ? "" : itemSV.EMAIL); doc.ReplaceText("@ttcn", string.IsNullOrEmpty(itemSV.TT_CANHAN) ? "" : itemSV.TT_CANHAN); foreach (var itemtt in lstTHETHAO_SINHVIEN) { lstTHETHAO += itemtt.TENTHETHAO + " ,"; } lstTHETHAO = lstTHETHAO.Trim().Substring(0, lstTHETHAO.Length - 1); doc.ReplaceText("@thethao", string.IsNullOrEmpty(lstTHETHAO) ? "" : lstTHETHAO); doc.SaveAs(urlFileSave); doc.Save(); Response.Buffer = true; Response.Expires = 0; Response.Clear(); string strHttpContext_ContentType = "application/msword"; HttpContext.Current.Response.ContentType = strHttpContext_ContentType; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; HttpContext.Current.Response.Charset = "utf-8"; Response.AddHeader("Content-Disposition", "attachment; filename=ThongTinSinhVien" + ".docx"); Response.TransmitFile(urlFileSave); Response.Flush(); Response.Close(); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { QUANLYSINHVIENEntities dbContext = new QUANLYSINHVIENEntities(); DmSINHVIENDAP dapSINHVIENDAO = new DmSINHVIENDAP(dbContext); DmLOPHOCDAP dapLOPHOCDAO = new DmLOPHOCDAP(dbContext); DmTHETHAODAP dapTHETHAODAP = new DmTHETHAODAP(dbContext); THETHAO_SINHVIENDAP dapTHETHAO_SINHVIEN = new THETHAO_SINHVIENDAP(dbContext); doAction = !string.IsNullOrEmpty(Request["do"]) ? Request["do"].ToString() : ""; itemId = !string.IsNullOrEmpty(Request["itemid"]) ? Request["itemid"].ToString() : ""; if (itemId.Length > 0) { objSINHVIEN = dapSINHVIENDAO.GetById(itemId); } objLOPHOC.AddRange(dapLOPHOCDAO.getListAll()); objTHETHAO.AddRange(dapTHETHAODAP.GetListAll()); lstTHETHAO_SINHVIEN = dapTHETHAO_SINHVIEN.GetById(itemId); lstMONTHETHAO = lstTHETHAO_SINHVIEN.Select(x => x.THETHAOID).ToList(); }