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

            #region

            IVMModel.PrintStockOutDetl BCO = new IVMModel.PrintStockOutDetl(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
        }
Exemple #2
0
        /// <summary>
        /// IVM20_1報表(列印鈕)
        /// </summary>
        /// <param name="ParameterList">變數清單</param>        
        /// <returns>回傳查詢結果</returns>
        public DataTable IVM20_1(ArrayList ParameterList)
        {

            #region

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


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

            #endregion
        }
Exemple #3
0
    public DataTable queryData()
    {
        ResultMsgLabel.Text = "";
        
        BCO.PrintStockOutDetl bco = new BCO.PrintStockOutDetl(ConntionDB);

        DataTable Dt = null;

        ArrayList aList = this.getParameterList();

        Dt = bco.PrintRpt01(aList);
        
        return Dt;
    }