public ActionResult RenderToExcel(PubPage fg) { string sql = "select Telephone,Pwd from SystemUser"; var dt = _iSysUserServices.ToDataTable(sql, null); string[] Telephone = { "手机号", "密码" }; for (int i = 0; i < dt.Columns.Count; i++) { dt.Columns[i].ColumnName = Telephone[i]; } var ms = NpoiHelper.RenderToExcel(dt); var xlsx = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; var xls = "application/vnd.ms-excel"; return(File(ms, xls, "用户信息" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls")); }
/// <summary> /// 导出承运单发票 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_DeriveAccept_Click(object sender, EventArgs e) { HAWB hawb = _hawbService.FindHAWBByBarCode(Txt_BarCode.Text.Trim()); if (!string.IsNullOrEmpty(Txt_CarrierHAWBBarCode.Text)) { var NpoiHelper = new NpoiHelper(hawb, Txt_CarrierHAWBBarCode.Text); NpoiHelper.ExportInvoice(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.UTF8; resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(String.Format("{0}.xls", Txt_BarCode.Text + "承运发票"), System.Text.Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('没有承运公司编号,不能导出!')</script>"); } }
/// <summary> /// 导出运单发票 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_DeriveSince_Click(object sender, EventArgs e) { HAWB hawb = _hawbService.FindHAWBByBarCode(Txt_BarCode.Text.Trim()); var NpoiHelper = new NpoiHelper(hawb, Txt_BarCode.Text); NpoiHelper.ExportInvoice(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.UTF8; resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(String.Format("{0}.xls", Txt_BarCode.Text+"运单发票"), System.Text.Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); }
/// <summary> /// 数据源导出总运单和承运单清单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gv_HAWB_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Eidt") { Guid id = (Guid)Session["UserID"]; ModulePrivilege Authority = _sysUserManagementService.GetPrivilegeByUserid(id); bool aPrivilege = (bool)Authority[Privilege.修改.ToString()]; bool aPrivilege2 = (bool)Authority[Privilege.导出.ToString()]; bool aPrivilege1 = (bool)Authority[Privilege.解锁.ToString()]; Response.Redirect("MawbDetails.aspx?Privilege=" + aPrivilege + "&BarCode=" + e.CommandArgument + "&aPrivilege1=" + aPrivilege1 + "&aPrivilege2=" + aPrivilege2 + ""); } if (e.CommandName == "Derive") { string barcode = e.CommandArgument.ToString(); MAWB mawb = _mawbService.FindMAWBByBarcode(barcode); IList<HAWB> hawbs = _hawbService.FindHAWBsByMID(mawb.MID.ToString()); if (hawbs.Count != 0) { var NpoiHelper = new NpoiHelper(mawb, hawbs, ExportType.运单号); NpoiHelper.ExportMAWB(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.UTF8; resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(String.Format("{0}.xls", barcode + "总运单清单"), System.Text.Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", "alert('该总运单下没有运单,不能导出!')", true); } } else if (e.CommandName == "DeriveAccept") { string barcode = e.CommandArgument.ToString(); MAWB mawb = _mawbService.FindMAWBByBarcode(barcode); IList<HAWB> hawbs = _hawbService.FindHAWBsByMID(mawb.MID.ToString()); if (hawbs.Count != 0) { var NpoiHelper = new NpoiHelper(mawb, hawbs, ExportType.承运单号); NpoiHelper.ExportMAWB(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.UTF8; resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(String.Format("{0}.xls", barcode + "承运清单"), System.Text.Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", "alert('该总运单下没有运单,不能导出!')", true); } } }
/// <summary> /// 数据源操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_HAWB_RowCommand(object sender, GridViewCommandEventArgs e) { Guid id = (Guid)Session["UserID"]; ModulePrivilege Authority = _SysUserManagementService.GetPrivilegeByUserid(id); if (e.CommandName == "Eidt") { bool aPrivilege = (bool)Authority[Privilege.修改.ToString()]; bool aPrivilege1 = (bool)Authority[Privilege.导出.ToString()]; int index = Convert.ToInt32(e.CommandArgument); string barCode = Gv_HAWB.DataKeys[index].Value.ToString(); Response.Redirect("HAWBDetails.aspx?BarCode=" + barCode + "&Privilege=" + aPrivilege + "&Privilege1=" + aPrivilege1 + ""); } else if (e.CommandName == "Updata") { string barCode = e.CommandArgument.ToString(); int Update = 1; Response.Redirect("HAWBAdd.aspx?BarCode=" + barCode + "&update=" + Update + ""); } else if (e.CommandName == "Del") { string barCode = e.CommandArgument.ToString(); //_hawbService.RemoveHAWB(barCode); } else if (e.CommandName == "Derive") { string barCode = e.CommandArgument.ToString(); HAWB hawb = _hawbService.FindHAWBByBarCode(barCode); var NpoiHelper = new NpoiHelper(hawb, barCode); NpoiHelper.ExportInvoice(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.UTF8; resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(String.Format("{0}.xls", barCode+"运单发票"), System.Text.Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } else if (e.CommandName == "DeriveAccept") { int index = ((GridViewRow)((LinkButton)(e.CommandSource)).Parent.Parent).RowIndex; string CarrierHAWBBarCode = e.CommandArgument.ToString(); string barCode = Gv_HAWB.DataKeys[index].Value.ToString(); HAWB hawb = _hawbService.FindHAWBByBarCode(barCode); if (!string.IsNullOrEmpty(CarrierHAWBBarCode)) { var NpoiHelper = new NpoiHelper(hawb, CarrierHAWBBarCode); NpoiHelper.ExportInvoice(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.UTF8; resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(String.Format("{0}.xls", barCode+"承运发票"), System.Text.Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", "alert('没有承运公司编号,不能导出!')", true); } } }
/// <summary> /// 导出承运公司清单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_DeriveAccept_Click(object sender, EventArgs e) { MAWB mawb = _mawbService.FindMAWBByBarcode(lbl_MAWBBarCode.Text); IList<HAWB> hawbs = _hawbService.FindHAWBsByMID(mawb.MID.ToString()); if (hawbs.Count != 0) { var NpoiHelper = new NpoiHelper(mawb, hawbs, ExportType.承运单号); NpoiHelper.ExportMAWB(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.UTF8; resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(String.Format("{0}.xls", lbl_MAWBBarCode.Text + "承运清单"), System.Text.Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该总运单下没有运单,不能导出!')</script>"); } }
/// <summary> /// 导出报关文件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, EventArgs e) { IList<HAWB> hawbs = new List<HAWB>();//实例化 for (int i = 0; i < RGMAWB.MasterTableView.Items.Count; i++) { GridDataItem row = RGMAWB.MasterTableView.Items[i]; if (((CheckBox)row.FindControl("CBSelect")).Checked) { //获取选中的运单编号 string hawbBarcode = RGMAWB.MasterTableView.DataKeyValues[row.ItemIndex]["BarCode"].ToString(); //获取运单信息 HAWB hawb = _hawbService.FindHAWBByBarCode(hawbBarcode); hawbs.Add(hawb); } } MAWB mawb = _mawbService.FindMAWBByBarcode(MAWBNo); var NpoiHelper = new NpoiHelper(mawb, hawbs); NpoiHelper.ExportClearance(); var str = (MemoryStream)NpoiHelper.RenderToExcel(); if (str == null) return; var data = str.ToArray(); var resp = Page.Response; resp.Buffer = true; resp.Clear(); resp.Charset = "utf-8"; resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.ContentType = "application/ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode("电子出口清单.xls", Encoding.UTF8)); HttpContext.Current.Response.BinaryWrite(data); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); }