Exemple #1
0
        /// <summary>
        /// VGR03報表
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable VGR03_1(ArrayList ParameterList,
                                 string ReportOutputFormat,
                                 ref ReportList.ExcelOtherType EOT
                                 )
        {
            VGRModel.PrintPreReturnDetl bco = new VGRModel.PrintPreReturnDetl(ConntionDB);

            DataTable Dt = bco.GetPreReturnDetl(ParameterList);

            if (Dt.Rows.Count == 0)
            {
                throw new Exception("查無資料");
            }
            //設定使用第三方元件匯出EXCEL
            if (ReportOutputFormat == "EXCEL")
            {
                EOT = ReportList.ExcelOtherType.None;
            }
            return Dt;
        }
Exemple #2
0
    public DataTable queryData()
    {
        ResultMsgLabel.Text = "";
        BCO.PrintPreReturnDetl bco = new PrintPreReturnDetl(ConntionDB);

        DataTable Dt = null;

        ArrayList aList = this.getParameterList();

        Dt = bco.GetPreReturnDetl(aList);

        return Dt;
    }