예제 #1
0
        /// <summary>
        /// COM04報表
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable COM04_1(ArrayList ParameterList,
                                 string ReportOutputFormat,
                                 ref ReportList.ExcelOtherType EOT
                                 )
        {
            COMModel.QueryQtySumByStore bco = new COMModel.QueryQtySumByStore(ConntionDB);
            DataTable Dt = bco.QueryByStore(ParameterList);

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

    public DataTable searchData()
    {
        #region 前置檢查與參數過濾
        string txt_SLP_SKU = this.SLP_SKU.Text;
        string txt_SLP_ItemPeriod = this.SLP_ItemPeriod.Text;
        string txt_SLP_StoreChain = this.SLP_StoreChain.Text;
        string txt_SLP_Store = this.SLP_Store.Text;
        string txt_SLP_Z_O = this.SLP_Z_O.Text;
        string txt_SLP_User = this.SLP_User.Text;

        #endregion

        #region 清空靜態變數
        dt_Detail = null;
        #endregion

        #region 處理查詢

        ParameterList.Clear();
        ParameterList.Add(GetValueSetParameter(txt_SLP_SKU, "string"));//[品號]
        ParameterList.Add(GetValueSetParameter(txt_SLP_ItemPeriod, "string"));//[期別]
        ParameterList.Add(GetValueSetParameter(txt_SLP_StoreChain, "string"));
        ParameterList.Add(GetValueSetParameter(txt_SLP_Store, "string"));
        ParameterList.Add(GetValueSetParameter(txt_SLP_Z_O, "string"));
        ParameterList.Add(GetValueSetParameter(txt_SLP_User, "string"));
        ParameterList.Add(GetValueSetParameter(this.TextBoxRowCountLimit.Text, "int"));//筆數
        ParameterList.Add(SLP_BUS_DATE.StartDate); //進貨日期起
        ParameterList.Add(SLP_BUS_DATE.EndDate); //進貨日期迄
        BCO.QueryQtySumByStore bco = new QueryQtySumByStore(ConntionDB);
        DataTable Dt = bco.QueryByStore(ParameterList);
       
        #endregion