}//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