Beispiel #1
0
        /// <summary>
        /// PIU08_2報表(匯出鈕)-依儲位排序
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
        /// <param name="EOT">匯出Excel方式</param>           
        /// <returns>回傳查詢結果</returns>
        public DataTable PUR08_2(ArrayList ParameterList,
                                 string ReportOutputFormat,
                                 ref ReportList.ExcelOtherType EOT
                                 )
        {

            #region

            PURModel.PUR08_BCO BCO = new PURModel.PUR08_BCO(ConntionDB);
            DataTable Dt = BCO.GetPurchaseDetailData(ParameterList);

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

            //設定使用第三方元件匯出EXCEL
            if (ReportOutputFormat == "EXCEL")
            {
                #region 表頭



                #endregion

                EOT = ReportList.ExcelOtherType.None;
            }


            return Dt;
            #endregion
        }
Beispiel #2
0
        /// <summary>
        /// PIU08_1報表(列印鈕)
        /// </summary>
        /// <param name="ParameterList">變數清單</param>        
        /// <returns>回傳查詢結果</returns>
        public DataTable PUR08_1(ArrayList ParameterList)
        {

            #region

            PURModel.PUR08_BCO BCO = new PURModel.PUR08_BCO(ConntionDB);
            DataTable Dt = BCO.GetPurchaseDetailData(ParameterList);

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

            #endregion
        }