Example #1
0
        /// <summary>
        /// IVM21_2報表(列印鈕)-依廠商排序
        /// </summary>
        /// <param name="ParameterList">變數清單</param>        
        /// <returns>回傳查詢結果</returns>
        public DataTable IVM21_2(ArrayList ParameterList)
        {

            #region

            IVMModel.PrintStockAmt BCO = new IVMModel.PrintStockAmt(ConntionDB);
            DataTable Dt = BCO.PrintRpt02(ParameterList);


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

            #endregion
        }
Example #2
0
        /// <summary>
        /// IVM21_5報表(匯出鈕)-依廠商排序
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
        /// <param name="EOT">匯出Excel方式</param>           
        /// <returns>回傳查詢結果</returns>
        public DataTable IVM21_5(ArrayList ParameterList,
                                 string ReportOutputFormat,
                                 ref ReportList.ExcelOtherType EOT
                                 )
        {

            #region

            IVMModel.PrintStockAmt BCO = new IVMModel.PrintStockAmt(ConntionDB);

            DataTable Dt = BCO.PrintRpt02(ParameterList);

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

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



                #endregion

                EOT = ReportList.ExcelOtherType.None;
            }

            return Arrange_CrystalReport_Data(ParameterList, Dt);

            #endregion
        }