/// <summary>
/// 繫結資料到控制項
/// </summary>
/// <param name="vdb"></param>
private void QueryData()
{
#region
try
{
string SessionIDName_FEE = string.Format("{0}_{1}_FEE", PAGE_DT_01, PageTimeStamp.Value);
TRNModel.VDS_TRN16_BCO BCO = new TRNModel.VDS_TRN16_BCO(ConnectionDB);
DataTable dt_FEE = null;
dt_FEE = BCO.QUERY_TRN_DRIVER_FEE(GetQueryParams());
if (dt_FEE != null)
dtFee = dt_FEE.Copy();
bAfterQueryDataBinding = true;
#region FEE
#region original
if (dt_FEE != null)
{
if (!dt_FEE.Columns.Contains("CHECKED"))//增加欄位以方便判別是否可
dt_FEE.Columns.Add("CHECKED");
if (!dt_FEE.Columns.Contains("ROWID"))//增加欄位以判別勾選與否
dt_FEE.Columns.Add("ROWID");
if (!dt_FEE.Columns.Contains("CODE"))//增加欄位以判別勾選與否
dt_FEE.Columns.Add("CODE");
if (!dt_FEE.Columns.Contains("ROWNUM"))//增加欄位以判別勾選與否
dt_FEE.Columns.Add("ROWNUM");
}
#endregion
#region editing
if (!dtFee.Columns.Contains("CHECKED"))//增加欄位以方便判別是否可
dtFee.Columns.Add("CHECKED");
if (!dtFee.Columns.Contains("ROWID"))//增加欄位以判別勾選與否
dtFee.Columns.Add("ROWID");
if (!dtFee.Columns.Contains("CODE"))//增加欄位以判別勾選與否
dtFee.Columns.Add("CODE");
if (!dtFee.Columns.Contains("ROWNUM"))//增加欄位以判別勾選與否
dtFee.Columns.Add("ROWNUM");
#endregion
#endregion
if (dt_FEE == null || dt_FEE.Rows.Count <= 0)
{
if (CurrentPageMode != PageCurrentMode.Insert)
{
ErrorMsgLabel.Text = "查無資料";
}
}
else
{
Panel_FEE.Visible = true;
if (CurrentPageMode == PageCurrentMode.Insert)
{
CurrentPageMode = PageCurrentMode.Edit;
}
else
{
CurrentPageMode = PageCurrentMode.Readonly;
SetControlsByCurrentPageMode();
}
#region
hidden_RowID_MaxID_FEE.Value = dt_FEE == null ? "-1" : (dt_FEE.Rows.Count - 1).ToString();//記錄最大ROWID
hidden_RowID_Selected_FEE.Value = "";//清空已選ROWID_FEE
Session[SessionIDName_FEE] = dt_FEE;
SetRowIDToDataTable(false, EditingGridview.FEE);//設定ROWID_FEE
gv_Fee.DataSource = dt_FEE;
gv_Fee.PageIndex = 0;
gv_Fee.DataBind();
gv_Fee.SelectedIndex = -1;
#endregion
}
bAfterQueryDataBinding = false;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
