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