C# (CSharp) PIC.VDS2G.GFM.STM MaintainStoreHoliday.QueryByFind Examples

Example #1

File: STM321.aspx.cs Project: ChiangHanLung/PIC_VDS

    /// <summary>
    /// 處理查詢資料
    /// </summary>
    /// <returns></returns>
    public DataTable searchData()
    {
        #region 清空靜態變數
        Session["STM321_" + PageTimeStamp.Value] = null;
        #endregion

        #region 處理查詢

        ParameterList.Clear();
        ParameterList.Add(GetValueSetParameter(this.SLP_TYPE.Text.Trim(), "string"));   
        ParameterList.Add(GetValueSetParameter(this.STORE_YY.Text.Trim(), "string"));
        ParameterList.Add(GetValueSetParameter(this.STORE_MM.Text.Trim(), "string"));

        ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text, "int"));

        BCO.MaintainStoreHoliday bco = new MaintainStoreHoliday(ConntionDB);
        DataTable Dt = bco.QueryByFind(ParameterList, int.Parse(TextBoxRowCountLimit.Text));


        #endregion
        return Dt;

    }