C# (CSharp) PIC.VDS2G.VSM.IVM VDS_IVM38_BCO.QueryByFind Examples

Example #1

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

    public DataTable searchData()
    {
        #region 清空靜態變數
        Session["IVM381_" + PageTimeStamp.Value] = null;
        #endregion

        #region 處理查詢

        ParameterList.Clear();
        ParameterList.Add(GetValueSetParameter(this.slp_ITEM_B.Text.Trim(), "string"));
        ParameterList.Add(GetValueSetParameter(this.slp_ITEM_E.Text.Trim(), "string"));
        ParameterList.Add(GetValueSetParameter(this.txt_PERIOD_B.Text.Trim(), "string"));
        ParameterList.Add(GetValueSetParameter(this.txt_PERIOD_E.Text.Trim(), "string"));
        ParameterList.Add(GetValueSetParameter(this.slp_Vendor_B.Text.Trim(), "string"));
        ParameterList.Add(GetValueSetParameter(this.slp_Vendor_E.Text.Trim(), "string"));

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

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


        #endregion
        return Dt;

    }