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

            #region

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


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

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

            #region

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

            DataTable Dt = BCO.PrintRpt01(ParameterList);

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

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



                #endregion

                EOT = ReportList.ExcelOtherType.None;
            }


            return Dt;
            #endregion
        }