예제 #1
0
        /// <summary>
        /// ALO25_1報表_列印鈕
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable ALO25_1(ArrayList ParameterList,
                                 ref ReportList.ExcelOtherType EOT
                                 )
        {

            #region
            ALOModel.VDS_ALO25_BCO BCO = new ALOModel.VDS_ALO25_BCO(ConntionDB);

            DataTable Dt = null;

            Dt = BCO.QueryForALO25(ParameterList);

            if (Dt == null || Dt.Rows.Count == 0)
            {
                throw new Exception("查無資料");
            }

            return Dt;
            #endregion
        }
예제 #2
0
    /// <summary>
    /// 輸出為EXCEL
    /// </summary>
    public void WriteToXls()
    {
        #region
        try
        {
            #region
            ALOModel.VDS_ALO25_BCO BCO = new ALOModel.VDS_ALO25_BCO(ConnectionDB);

            DataTable dt = null;

            dt = BCO.QueryForALO25(GetQueryParams());

            if (dt == null || dt.Rows.Count <= 0)
            {
                throw new Exception("查無資料");
            }
            #endregion

            #region
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=" +
                        HttpUtility.UrlEncode("不貼標商品報表", System.Text.UTF8Encoding.UTF8) + ".xls");
            Response.ContentType = "application/vnd.ms-excel;charset='utf-8'";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
            this.EnableViewState = false;

            System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

            gv_Export.DataSource = dt;
            gv_Export.DataBind();
            gv_Export.RenderControl(oHtmlTextWriter);
            Response.Write(oStringWriter.ToString());

            Response.Flush();
            Response.End();
            #endregion
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        finally
        {
            gv_Export.DataSource = null;
            gv_Export.DataBind();
        }
        #endregion
    }