protected void btnLoadOut_Click(object sender, EventArgs e)
    {
        ChangeTrackingList <EntitySearcher>  changeTrackingList = ViewState["sql"] as ChangeTrackingList <EntitySearcher>;
        List <FineOffice.Modules.CRM_Trader> list = traderBll.GetList(changeTrackingList);

        FineOffice.Web.WebExcelHelper       excelHelper = new FineOffice.Web.WebExcelHelper();
        FineOffice.Common.Excel.ExcelHelper toExcel     = new FineOffice.Common.Excel.ExcelHelper();
        string             serverPath = Server.MapPath("~/Config/Template/CRM_Trader.xml");
        List <ExcelHeader> headerList = toExcel.GetHeaderList(serverPath);

        toExcel.ApplicationName = excelHelper.ApplicationName;
        toExcel.Author          = excelHelper.Author;
        toExcel.Comments        = excelHelper.Comments;
        System.IO.MemoryStream ms = toExcel.Export <FineOffice.Modules.CRM_Trader>(list, traderGrid.Title, headerList);
        byte[] output             = ms.ToArray();

        FineOffice.Web.FileTypeHelper typeHelper = new FineOffice.Web.FileTypeHelper();
        Response.AddHeader("Content-Disposition", "attachment; filename=" + typeHelper.ToHexString(string.Format("{0}{1:yyyyMMdd}", traderGrid.Title, DateTime.Now) + ".xls"));
        Response.AddHeader("Content-Length", output.Length.ToString());
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
        Response.OutputStream.Write(output, 0, output.Length);

        Response.Flush();
        Response.End();
    }
Exemple #2
0
    protected void btnDownAttachment_Click(object sender, EventArgs e)
    {
        int id = int.Parse(attachmentGrid.DataKeys[attachmentGrid.SelectedRowIndex][0].ToString());

        FineOffice.Modules.OA_Attachment model = attBll.GetModel(d => d.ID == id);
        byte[] attachmentData = SharpZipLib.DeCompress(model.AttachmentData);

        FineOffice.Web.FileTypeHelper typeHelper = new FineOffice.Web.FileTypeHelper();
        Response.Clear();
        Response.Buffer  = true;
        Response.Charset = "utf-8";
        Response.AddHeader("Content-Disposition", "attachment; filename=" + typeHelper.ToHexString(model.FileName + "." + model.XType));
        Response.AddHeader("Content-Length", attachmentData.Length.ToString());
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
        Response.OutputStream.Write(attachmentData, 0, attachmentData.Length);
        Response.Flush();
    }
Exemple #3
0
    protected void btnTemplates_Click(object sender, EventArgs e)
    {
        FineOffice.Web.WebExcelHelper       excelHelper = new FineOffice.Web.WebExcelHelper();
        FineOffice.Common.Excel.ExcelHelper toExcel     = new FineOffice.Common.Excel.ExcelHelper();
        string             serverPath = Server.MapPath("~/Config/Template/CNS_CensusMember.xml");
        List <ExcelHeader> headerList = toExcel.GetHeaderList(serverPath);

        toExcel.ApplicationName = excelHelper.ApplicationName;
        toExcel.Author          = excelHelper.Author;
        toExcel.Comments        = excelHelper.Comments;
        System.IO.MemoryStream ms = toExcel.Export <FineOffice.Modules.CNS_CensusMember>(new List <FineOffice.Modules.CNS_CensusMember>(), memberGird.Title, headerList);
        byte[] output             = ms.ToArray();

        FineOffice.Web.FileTypeHelper typeHelper = new FineOffice.Web.FileTypeHelper();
        Response.AddHeader("Content-Disposition", "attachment; filename=" + typeHelper.ToHexString(memberGird.Title + ".xls"));
        Response.AddHeader("Content-Length", output.Length.ToString());
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); //设置输出流的字符集
        Response.OutputStream.Write(output, 0, output.Length);                //输出

        Response.Flush();
        Response.End();
    }