Example #1
0
    private void BindData()
    {
        CAMCommon CAMCommonBCO = new CAMCommon();
        ArrayList ParameterList = new ArrayList();
        ParameterList.Clear();

        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_VENDOR_S.Text, "string", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_VENDOR_E.Text, "string", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(DDL_PAY_KIND.SelectedValue, "string", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_ITEM_S.Text, "string", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_ITEM_E.Text, "string", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(DDL_TRAN_CORP.SelectedValue, "string", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_CREATEDATE.StartDate, "date", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_CREATEDATE.EndDate, "date", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_CREATEUID.Text, "string", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_UPDATEDATE.StartDate, "date", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_UPDATEDATE.EndDate, "date", false));
        ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_UPDATEUID.Text, "string", false));
        ParameterList.Add(TextBoxRowCountLimit.Text);

        VAM24_BCO BCO = new VAM24_BCO(ConntionDB);
        DataTable dt = BCO.QueryTranShipByFind(ParameterList);

        string SessionIDName = "VAM241_" + PageTimeStamp.Value;
        Session[SessionIDName] = dt;
        GridView1.DataSource = dt;
        GridView1.PageSize = (TextBoxPagesize.Text == "") ? 20 : (int.Parse(TextBoxPagesize.Text) < 0) ? 20 : int.Parse(TextBoxPagesize.Text);
        GridView1.PageIndex = 0;
        GridView1.DataBind();

        if (dt.Rows.Count > 0)
        {
            StringCollection sc = new StringCollection();
            foreach (DataRow dr in dt.Rows)
            {
                sc.Add(dr["VENDOR"].ToString());
            }
            
            Session["VAM24CodeCollection"] = sc;
        }
        else
        {
            ErrorMsgLabel.Text = "查無資料";
        }
    }