利用C#代码将html样式文件与Word文档互换的方法

2019-12-30 18:46:30于丽

4:通过Stream、StreamReader两个类来读取这个模板文件(返回的是html字符串)。

5:2中查询出数据(对应字段)替换4中返回的html字符串中的占位符。

6:关键代码


 StringBuilder sb = new StringBuilder();
  sb.Append(
  "<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://www.easck.com/office/2004/12/omml"xmlns = "http://www.easck.com/TR/REC-html40">");
  sb.Append(html);
  sb.Append("</html>");

7:用法:在页面前端写一个a标签指向这个方法即可下载为Word文件了。

HTML模板文件:


<div class="modal-body">
 <div style="height:600px;width:550px; margin:0 auto;">
 <table style="border-collapse:separate;border-spacing:10px;width: 100%">
  <tr>
  <td style="text-align: center;font-size: 30px;font-weight: bold">中标通知书<hr /></td>
  </tr>
  <tr>
  <td style="text-align: left;font-size:20px;">@BidderName</td>
  </tr>
  <tr>
  <td style="text-align: left"> “XXXX物资平台”@ResourceCode号标的开标结果为贵方中标,现通知如下:</td>
  </tr>
 </table>
 <table border="1" cellspacing="0" cellpadding="10" style="border-collapse:separate;height: 300px;">
  <tr style="text-align:center;">
  <th>品名</th>
  <th>资源编号</th>
  <th>数量(@Unit)</th>
  <th>中标价格(含税总金额:元)</th>
  <th>钢厂</th>
  <th>存放地(提货地)</th>
  </tr>
  <tr style="text-align:center;">
  <td>@ResourceName</td>
  <td>@ResourceCode</td>
  <td>@Count</td>
  <td>@TenderPrice</td>
  <td>@BrandName</td>
  <td>@InventoryPlace</td>
  </tr>
  <tr>
  <td colspan="6">备注:@Remarks</td>
  </tr>
 </table>
 <table style="border-collapse:separate;border-spacing:10px;width: 100%">
  <tr>
  <td style="text-align: left">
   请贵方在收到通知书的5个工作日内交齐全额货款并签订合同。
  </td>
  </tr>
  <tr>
  <td style="text-align: left">
   特此通知。
  </td>
  </tr>
  <tr>
  <td style="text-align: right">
   XXXX物资平台
  </td>
  </tr>
  <tr>
  <td style="text-align:right">
   @Year 年 @Moth 月 @Day 日
  </td>
  </tr>
 </table>

 </div>
</div>

 /// <summary>
 /// 下载中标通知书
 /// 用法:前端一个a标签指向这个控制器的这个方法
 /// </summary>
 /// <param name="id">中标通知书Id</param>
 [AbpMvcAuthorize(BiddingNoticeAppPermissions.BiddingNotice)]

 public ActionResult DownBiddingNoticeModal(long id)
 {
  #region 读取模板 
  var html = GetBidTempStrng();
  #endregion

  #region 根据ID读取中标内容 替换数据
  var model = _biddingNoticeRepository.FirstOrDefault(id);
  if (model != null)
  {
  html = html.Replace("@BrandName", model.BrandName).Replace("@ResourceCode", model.ResourceCode)
   .Replace("@ResourceName", model.ResourceName).Replace("@Count", model.Count.ToString())
   .Replace("@TenderPrice", model.TenderPrice.ToString()).Replace("@BidderName", model.BidderName)
   .Replace("@InventoryPlace", model.InventoryPlace).Replace("@Remarks", model.Remarks)
   .Replace("@Year", model.CreationTime.Year.ToString()).Replace("@Moth", model.CreationTime.Month.ToString())
   .Replace("@Day", model.CreationTime.Day.ToString()).Replace("@Unit", model.Unit);
  }
  else
  {
  html = html.Replace("@BrandName", "XXXXX").Replace("@ResourceCode", "ZYXXXXXXXX")
   .Replace("@ResourceName", "XXXXX").Replace("@Count", "0")
   .Replace("@TenderPrice", "0").Replace("@BidderName", "XXXXX")
   .Replace("@InventoryPlace", "XXXXX").Replace("@Remarks", "XXXXXXXX")
   .Replace("@Year", "XXXX").Replace("@Moth", "XX")
   .Replace("@Day", "XX").Replace("@Unit", "X");
  }
  #endregion

  #region 转换为Word文档样式

  StringBuilder sb = new StringBuilder();
  sb.Append(
  "<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://www.easck.com/office/2004/12/omml"xmlns = "http://www.easck.com/TR/REC-html40">");
  sb.Append(html);
  sb.Append("</html>");
  return File(Encoding.UTF8.GetBytes(sb.ToString()), "application/msword", $"中标通知书.doc");

  #endregion
 }

 /// <summary>
 /// 读取中标通知书模板
 /// </summary>
 /// <returns></returns>
 private string GetBidTempStrng()
 {
  StringBuilder sbHtml = new StringBuilder();
  // 读取模板替换数据
  var path = Server.MapPath("~/Common/BidTemplace/BidTemp.html");
  using (Stream inStream = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Read))
  using (StreamReader outStream = new StreamReader(inStream, Encoding.Default))
  {
  while (!outStream.EndOfStream)
  {
   sbHtml.Append(outStream.ReadLine());
  }
  }
  var html = sbHtml.ToString();
  return html;
 }