/// <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();
}
