Beispiel #1
0
    }//page_load

    /// <summary>
    /// 繫結資料到控制項
    /// </summary>
    /// <param name="vdb">0:查詢鈕,1:匯出鈕</param>
    private void databind(char src)
    {
        //抓取本頁初次登記的時間
        string SessionIDName = "OUT021_" + PageTimeStamp.Value;

        OUT02 BCO = new OUT02(ConntionDB);
        DataTable Dt = BCO.QuerySKUByFind_2(ParameterList, src);
        DataTable dt = Dt.Copy(); //複製成另一份,因匯出時有將ID及Enable欄位移除
        Session["OUT02" + PageTimeStamp.Value] = dt;
        DataTable dtTemp = Dt.DefaultView.ToTable("TempTable", true, "ID",
             "VENDOR",
             "VENDOR_NAME",
             "VENDOR_OPEN_DATE",
             "VENDOR_CLOSE_DATE",
             "COST_SUBSIDY_PERCENT",
             "CLS_DATE",
             "ACCEPT_COST_TYPE",
             "BUSINESS_ADDR",
             "BUSINESS_FAX",
             "BUSINESS_CONTACT",
             "BUSINESS_EXTENSION",
             "BUSINESS_MAIL",
             "ACCOUNT_CONTACT",
             "ACCOUNT_EXTENSION",
             "ACCOUNT_MAIL",
             "ACC_VENDOR_CODE",
             "ACC_VENDOR_NAME",
             "COM_ADDR",
             "COM_ADDR_2",
             "LIMIT_NUM");

        Session["OUT021_" + PageTimeStamp.Value] = dtTemp;
        if (src == '0')
        {
            ViewState["SortField"] = null;
            GridView1.DataSource = dtTemp;
            //設定分頁大小
            GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
            GridView1.PageIndex = 0;
            GridView1.DataBind();
            #region 將Key值存到Session中
            ArrayList arl_Key = new ArrayList();
            foreach (DataRow drRow in Dt.Rows)
            { arl_Key.Add(drRow["ID"].ToString()); }
            Session["OUT021_SortKey" + PageTimeStamp.Value] = arl_Key;
            #endregion
        }
    }//databind