/// <summary>

         /// 导出word培训班自然情况表

         /// </summary>

         [HttpPost]

         public void PrintWord()

         {

             int id = Int32.Parse(Request.Form["id"]);

             var query = from n in db.Nature

                         where n.NatureId == id && n.IsDelete == false

                         select new NatureInfo

                         {

                             NatureBeginTime = n.NatureBeginTime,

                             NatureEndTime = n.NatureEndTime,

                             ActualNum = n.ActualNum,

                             PlanNum = n.PlanNum,

                             NaturePlace = n.NaturePlace,

                             NatureMajor = n.NatureMajor,

                             TrainName = n.TrainName,

                             TotalHours = n.TotalHours,

                             TeachingHours = n.TeachingHours,

                             Remark = n.Remark

                         };

             DataTable dt = query.ToDataTable(rec => new object[] { query });

             #region 培训班自然情况表

             XWPFDocument doc = new XWPFDocument();//创建word文档

             MemoryStream ms = new MemoryStream();//创建流

             XWPFParagraph p0 = doc.CreateParagraph();//创建段落

             p0.Alignment = ParagraphAlignment.CENTER;//居中显示

             XWPFRun r0 = p0.CreateRun();

             //设置字体

             r0.FontFamily = "宋体";

             //设置字体大小

             r0.FontSize = ;

             //字体是否加粗，这里加粗了

             r0.SetBold(true);

             r0.SetText("培训班自然情况表");//写入文本

             XWPFParagraph p1 = doc.CreateParagraph();

             p1.Alignment = ParagraphAlignment.LEFT;

             XWPFRun r1 = p1.CreateRun();

             r1.SetText("培训机构：石家庄职工培训基地");

             XWPFTable table = doc.CreateTable(, );//创建table

             table.RemoveRow();//去掉第一行空白的

             table.SetColumnWidth(,  * );//设置列的宽度

             table.SetColumnWidth(,  * );

             table.SetColumnWidth(,  * );

             table.SetColumnWidth(,  * );

             CT_Tbl m_CTTbl = doc.Document.body.GetTblArray()[];//获得文档第一张表

             m_CTTbl.AddNewTblPr().jc = new CT_Jc();

             m_CTTbl.AddNewTblPr().jc.val = ST_Jc.center;//表在页面水平居中

             foreach (DataRow r in dt.Rows)

             {

                 CT_Row nr = new CT_Row();

                 XWPFTableRow mr = new XWPFTableRow(nr, table);//创建行

                 mr.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong);//设置行高

                 nr.AddNewTrPr().AddNewTrHeight().val = (ulong);//设置行高（这两行都得有）

                 table.AddRow(mr);//将行添加到table中 

                 mr.CreateCell().SetText("培训班名称");

                 mr.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);//文字垂直居中（即上下居中）

                 XWPFTableCell c1 = mr.CreateCell();//创建单元格

                 CT_Tc ct = c1.GetCTTc();

                 CT_TcPr cp = ct.AddNewTcPr();

                 cp.gridSpan = new CT_DecimalNumber();

                 cp.gridSpan.val = ""; //合并3列

                 cp.AddNewVAlign().val = ST_VerticalJc.center;

                 ct.GetPList()[].AddNewPPr().AddNewJc().val = ST_Jc.center;//单元格内容居中显示

                 ct.GetPList()[].AddNewR().AddNewT().Value = r["TrainName"].ToString();

                 CT_Row cr1 = new CT_Row();

                 XWPFTableRow tr1 = new XWPFTableRow(cr1, table);

                 tr1.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong);

                 cr1.AddNewTrPr().AddNewTrHeight().val = (ulong);

                 table.AddRow(tr1);

                 tr1.CreateCell().SetText("培训地点");

                 tr1.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 tr1.CreateCell().SetText(r["NaturePlace"].ToString());

                 tr1.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 tr1.CreateCell().SetText("培训时间");

                 tr1.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 tr1.CreateCell().SetText(Convert.ToDateTime(r["NatureBeginTime"].ToString()).ToShortDateString() + "~" + Convert.ToDateTime(r["NatureEndTime"].ToString()).ToShortDateString());

                 tr1.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 CT_Row cr2 = new CT_Row();

                 XWPFTableRow tr2 = new XWPFTableRow(cr2, table);

                 tr2.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong);

                 cr2.AddNewTrPr().AddNewTrHeight().val = (ulong);

                 table.AddRow(tr2);

                 tr2.CreateCell().SetText("计划人数");

                 tr2.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 tr2.CreateCell().SetText(r["PlanNum"].ToString());

                 tr2.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 tr2.CreateCell().SetText("实际人数");

                 tr2.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 tr2.CreateCell().SetText(r["ActualNum"].ToString());

                 tr2.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 CT_Row cr3 = new CT_Row();

                 XWPFTableRow tr3 = new XWPFTableRow(cr3, table);//创建行

                 tr3.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong);

                 cr3.AddNewTrPr().AddNewTrHeight().val = (ulong);

                 table.AddRow(tr3);//将行添加到table中

                 tr3.CreateCell().SetText("总学时");

                 tr3.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 XWPFTableCell tc3 = tr3.CreateCell();//创建单元格

                 CT_Tc ct3 = tc3.GetCTTc();

                 CT_TcPr cp3 = ct3.AddNewTcPr();

                 cp3.gridSpan = new CT_DecimalNumber();

                 cp3.gridSpan.val = ""; //合并3列

                 ct3.GetPList()[].AddNewPPr().AddNewJc().val = ST_Jc.left;//单元格内容居中显示

                 ct3.GetPList()[].AddNewR().AddNewT().Value = r["TotalHours"].ToString();

                 tr3.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 CT_Row cr4 = new CT_Row();

                 XWPFTableRow tr4 = new XWPFTableRow(cr4, table);//创建行

                 tr4.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong);

                 cr4.AddNewTrPr().AddNewTrHeight().val = (ulong);

                 table.AddRow(tr4);//将行添加到table中

                 tr4.CreateCell().SetText("课程");

                 tr4.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 XWPFTableCell tc4 = tr4.CreateCell();//创建单元格

                 CT_Tc ct4 = tc4.GetCTTc();

                 CT_TcPr cp4 = ct4.AddNewTcPr();

                 cp4.gridSpan = new CT_DecimalNumber();

                 cp4.gridSpan.val = ""; //合并3列

                 ct4.GetPList()[].AddNewPPr().AddNewJc().val = ST_Jc.left;//单元格内容居中显示

                 ct4.GetPList()[].AddNewR().AddNewT().Value = r["NatureMajor"].ToString();

                 tr4.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 CT_Row cr5 = new CT_Row();

                 XWPFTableRow tr5 = new XWPFTableRow(cr5, table);//创建行

                 tr5.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong);

                 cr5.AddNewTrPr().AddNewTrHeight().val = (ulong);

                 table.AddRow(tr5);//将行添加到table中

                 tr5.CreateCell().SetText("授课学时");

                 tr5.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 XWPFTableCell tc5 = tr5.CreateCell();//创建单元格

                 CT_Tc ct5 = tc5.GetCTTc();

                 CT_TcPr cp5 = ct5.AddNewTcPr();

                 cp5.gridSpan = new CT_DecimalNumber();

                 cp5.gridSpan.val = ""; //合并3列

                 ct5.GetPList()[].AddNewPPr().AddNewJc().val = ST_Jc.left;//单元格内容居中显示

                 ct5.GetPList()[].AddNewR().AddNewT().Value = r["TeachingHours"].ToString();

                 tr5.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 CT_Row cr6 = new CT_Row();

                 XWPFTableRow tr6 = new XWPFTableRow(cr6, table);//创建行

                 tr6.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong);

                 cr6.AddNewTrPr().AddNewTrHeight().val = (ulong);

                 table.AddRow(tr6);//将行添加到table中

                 tr6.CreateCell().SetText("备注");

                 tr6.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

                 XWPFTableCell tc6 = tr6.CreateCell();//创建单元格

                 CT_Tc ct6 = tc6.GetCTTc();

                 CT_TcPr cp6 = ct6.AddNewTcPr();

                 cp6.gridSpan = new CT_DecimalNumber();

                 cp6.gridSpan.val = ""; //合并3列

                 ct6.GetPList()[].AddNewPPr().AddNewJc().val = ST_Jc.left;//单元格内容居中显示

                 ct6.GetPList()[].AddNewR().AddNewT().Value = r["Remark"].ToString();

                 tr6.GetCell().SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);

             }

             #endregion

             // 写入到客户端

             doc.Write(ms);

             // 添加头信息，为"文件下载/另存为"对话框指定默认文件名

             Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.doc", "培训班自然情况表" + System.DateTime.Now.ToString("yyyymmddhhmmssfff ")));

             Response.Charset = "UTF-8";

             Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");

             // 指定返回的是一个不能被客户端读取的流，必须被下载

             Response.ContentType = "application/ms-word";

             // 把文件流发送到客户端

             Response.BinaryWrite(ms.ToArray());

             doc = null;

             ms.Close();

             ms.Dispose();

         }