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