/// <summary> /// databind 繫結查詢資料到GridView1 /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "VGR021_" + PageTimeStamp.Value; VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB); DataTable Dt; ParameterList.Add(this.txtBatchNo.Text); ParameterList.Add(this.SLP_SLPDate1.Text); ParameterList.Add(this.SLP_SLPDate2.Text); ParameterList.Add(this.SLP_StoreChain1.Text); ParameterList.Add(this.SLP_Store1.Text); ParameterList.Add(this.txtChanSourceNo.Text); if (this.rdoStatus.SelectedValue == " ") ParameterList.Add(null); else ParameterList.Add(this.rdoStatus.SelectedValue); ParameterList.Add(this.SLP_SKU1.Text); ParameterList.Add(this.SLP_ItemPeriod1.Text); ParameterList.Add(int.Parse(this.TextBoxRowCountLimit.Text)); Dt = BCO.QueryMainByLike(ParameterList); if (Dt.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR021.aspx", "alert(' 查無資料 ');", true); } Session[SessionIDName] = Dt; GridView1.DataSource = Dt; ArrayList IDList = new ArrayList(); ArrayList Batch_NoList = new ArrayList(); ArrayList Chan_NoList = new ArrayList(); ArrayList Sign_DateList = new ArrayList(); ArrayList P_DATEList = new ArrayList(); ArrayList StoreList = new ArrayList(); ArrayList Chan_Source_NoList = new ArrayList(); ArrayList STATUS_EXPLAINList = new ArrayList(); ArrayList UPDATEDATEList = new ArrayList(); ArrayList UPDATEUIDList = new ArrayList(); for (int i = 0; i < Dt.Rows.Count; i++) { IDList.Add(Dt.Rows[i]["ID"].ToString()); Batch_NoList.Add(Dt.Rows[i]["Batch_No"].ToString()); Chan_NoList.Add(Dt.Rows[i]["Chan_No"].ToString()); Sign_DateList.Add(Dt.Rows[i]["Sign_Date"].ToString()); P_DATEList.Add(Dt.Rows[i]["P_DATE"].ToString()); StoreList.Add(Dt.Rows[i]["Store"].ToString()); Chan_Source_NoList.Add(Dt.Rows[i]["Chan_Source_No"].ToString()); STATUS_EXPLAINList.Add(Dt.Rows[i]["Status"].ToString()); UPDATEDATEList.Add(DateTime.Parse(Dt.Rows[i]["UPDATEDATE"].ToString()).ToString("yyyyMMddHHmmssfffff")); UPDATEUIDList.Add(Dt.Rows[i]["UPDATEUID"].ToString()); } Session["VGR02QueryID"] = IDList; Session["VGR02QueryBatch_No"] = Batch_NoList; Session["VGR02QueryChan_No"] = Chan_NoList; Session["VGR02QuerySign_Date"] = Sign_DateList; Session["VGR02QueryP_DATE"] = P_DATEList; Session["VGR02QueryStore"] = StoreList; Session["VGR02QueryChan_Source_No"] = Chan_Source_NoList; Session["VGR02QuerySTATUS_EXPLAIN"] = STATUS_EXPLAINList; Session["VGR02QueryUPDATEDATE"] = UPDATEDATEList; Session["VGR02QueryUPDATEUID"] = UPDATEUIDList; //設定分頁大小 GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); // GridView1.PageIndex = 0; GridView1.DataBind(); }