/// <summary>
/// databind 繫結查詢資料到GridView1
/// </summary>
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "CGD061_" + PageTimeStamp.Value;
CGDModel.ProcessDeliverTransDPS BCO = new CGDModel.ProcessDeliverTransDPS(ConntionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(this.slp_ST_ACCEPT_DATE.StartDate);
ParameterList.Add(this.slp_ST_ACCEPT_DATE.EndDate.ToString());
ParameterList.Add(this.txtPickNo.Text);
Dt = BCO.QueryDeilyDPSitem(ParameterList);
if (Dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "查無資料";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD061.aspx", "alert(' 查無資料 ');", true);
}
//#region 使用XML放置到前端資料
//MasterOLDData.InnerHtml = Dt.DataSet.GetXml();
//#endregion
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
GridView1.PageIndex = 0;
GridView1.DataBind();
}
private void GetCGD061Data(string strDate, string endDate, string pickNo)
{
string SessionIDName = "CGD062_01_" + Request.QueryString["SessionTimeStamp"];
CGDModel.ProcessDeliverTransDPS BCO = new CGDModel.ProcessDeliverTransDPS(ConntionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(strDate);
ParameterList.Add(endDate);
ParameterList.Add(pickNo);
Dt = BCO.QueryDeilyDPSitem(ParameterList);
Session[SessionIDName] = Dt;
}