public void ExportVisaFeeAll(HttpContext context)

        {

            try

            {

                string title ="签证费用表";

                string[] idArray = context.Request["idStr"].ToString().Split(',');

                DateTime startDate = DateTime.Parse(context.Request["startDate"]);

                DateTime endDate = DateTime.Parse(context.Request["endDate"]).AddDays();

                string unit = context.Request.QueryString["unit"];

                string groupname = context.Request.QueryString["groupname"];

                string countryname = context.Request.QueryString["countryname"];

                string Member = context.Request.QueryString["Member"];

                string LetterNumbers = context.Request.QueryString["LetterNumbers"];

                List<VisaFeeMain> visaFees = new OilDigital.CGGL.Web.VisaApply.VisaApplyProcess().GetVisaFeeByQueryString(startDate, endDate, unit, groupname, countryname, Member, LetterNumbers);

                for (int i = visaFees.Count-; i >=; i--)

                {

                    bool flag = true;

                    for (int j  = ; j < idArray.Length; j++)

                    {

                        if (visaFees[i].Id.ToString() == idArray[j])

                        {

                            flag = false;

                            break;

                        }

                    }

                    if (flag)

                    {

                        visaFees.RemoveAt(i);

                    }

                }

                HSSFWorkbook wb = new HSSFWorkbook();//创建工作薄

                HSSFSheet sheet = (HSSFSheet)wb.CreateSheet(title); //创建工作表

                HSSFRow row_Title = (HSSFRow)sheet.CreateRow(); //创建列头行

                row_Title.HeightInPoints = 19.5F; //设置列头行高

                string[] titleStr = { "批件文号", "申办国家(地区)", "总金额", "人员名单", "总人数", "备注", "创建时间", "创建人"};

                //设置列宽

                for (int i = ; i < titleStr.Length; i++)

                {

                       sheet.SetColumnWidth(i,  * );

                }

                //设置列样式

                HSSFCellStyle cs_Title = (HSSFCellStyle)wb.CreateCellStyle(); //创建列头样式

                cs_Title.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; //水平居中

                cs_Title.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center; //垂直居中

                HSSFFont cs_Title_Font = (HSSFFont)wb.CreateFont(); //创建字体

                cs_Title_Font.FontHeightInPoints = ; //字体大小

                cs_Title_Font.Boldweight = (short)FontBoldWeight.Bold;

                cs_Title.SetFont(cs_Title_Font); //将字体绑定到样式

                //填充列头内容

                for (int i = ; i < titleStr.Length; i++)

                {

                    HSSFCell cell_Title = (HSSFCell)row_Title.CreateCell(i); //创建单元格

                    cell_Title.CellStyle = cs_Title; //将样式绑定到单元格

                    cell_Title.SetCellValue(titleStr[i]);

                }

                //设置单元格样式

                HSSFCellStyle cs_Content = (HSSFCellStyle)wb.CreateCellStyle(); //创建列头样式

                cs_Content.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; //水平居中

                cs_Content.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center; //垂直居中

                //填充单元格

                int r = ;

                for (r = ; r < visaFees.Count; r++)

                {

                    int i = r;

                    HSSFRow row = (HSSFRow)sheet.CreateRow(i + );

                    row.HeightInPoints = ;

                    string[] arr = { visaFees[i].LetterNumbers.ToString(), visaFees[i].EmbassyNames, visaFees[i].Fee, visaFees[i].Names, visaFees[i].TotalAmount.ToString(), visaFees[i].Memo, visaFees[i].CreatedTime.ToString("yyyy-MM-dd"), visaFees[i].CreatedBy };

                    for (int j = ; j < arr.Length; j++)

                    {

                        HSSFCell cell = (HSSFCell)row.CreateCell(j); //创建单元格

                        cell.CellStyle = cs_Content;

                            cell.SetCellValue(arr[j]);

                    }

                }

                HttpResponse httpResponse = HttpContext.Current.Response;

                httpResponse.Clear();

                httpResponse.Buffer = true;

                //httpResponse.Charset = Encoding.UTF8.BodyName;

                httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("签证费用.xls"));

                httpResponse.ContentEncoding = System.Text.Encoding.UTF8;

                httpResponse.ContentType = "application/vnd.ms-excel; charset=UTF-8";

                wb.Write(httpResponse.OutputStream);

                httpResponse.End();

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }