Beispiel #1
0
    private DataTable QuerySales()
    {
        BCO.COM15_BCO bco = new BCO.COM15_BCO(ConntionDB);

        #region 前置檢查與參數過濾
        string strSLP_StoreChain = this.SLP_StoreChain.Text;
        string strSLP_SKU = this.SLP_SKU.Text;
        string strSLP_ItemPeriod = this.SLP_ItemPeriod.Text;
        #endregion

        #region 組合查詢條件至ArrayList
        ParameterList.Clear();
        ParameterList.Add(GetValueSetParameter(strSLP_StoreChain, "string"));
        ParameterList.Add(GetValueSetParameter(strSLP_SKU, "string"));
        ParameterList.Add(GetValueSetParameter(strSLP_ItemPeriod, "string"));
        ParameterList.Add(GetValueSetParameter(SLP_DateR.StartDate, "string"));
        ParameterList.Add(GetValueSetParameter(SLP_DateR.EndDate, "string"));
        #endregion

        DataTable dt = bco.QuerySales(ParameterList);

        return dt;
    }