Esempio n. 1
0
        /// <summary>
        /// COM07報表
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable COM08_1(ArrayList ParameterList,
                                 string ReportOutputFormat,
                                 ref ReportList.ExcelOtherType EOT
                                 )
        {
            COMModel.QuerySalesSumByStore bco = new COMModel.QuerySalesSumByStore(ConntionDB);
            DataTable Dt = bco.QueryItemSaleByPos(ParameterList);

            if (Dt.Rows.Count == 0)
            {
                throw new Exception("查無資料");
            }
            else
            {
                return Dt;
            }
        }
Esempio n. 2
0
    public DataTable queryData()
    {
        ResultMsgLabel.Text = "";
        BCO.QuerySalesSumByStore bco = new BCO.QuerySalesSumByStore(ConntionDB);

        ArrayList aList = this.getParameterList();

        DataTable Dt = null;
        if (this.RadioType2.Checked == true)
        {
            Dt = bco.QueryByALO(aList);
        }
        else if (this.RadioType1.Checked == true)
        {
            Dt = bco.QueryByTemplate(aList);
        }
        return Dt;
    }