/// <summary>
/// 繫結資料到控制項
/// </summary>
/// <param name="vdb"></param>
private void QueryData()
{
#region
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
DataTable dt = null;
dt = BCO.QUERY_TRN_CODE_MAIN(GetQueryParams());
Session[SessionIDName] = dt;
Int32 iRowCount = 0;
aryParamsPKey.Clear();
GridView1.DataSource = dt;
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
if (dt != null && dt.Rows.Count > 0)
{
iRowCount = dt.Rows.Count;
foreach (DataRow dr in dt.Rows)
{
#region
aryParamsPKey.Add(dr["ID"].ToString());
#endregion
}
}
else
{
ErrorMsgLabel.Text = "查無資料";
}
Session[string.Format("{0}_{1}", strPreFixed, PageTimeStamp.Value)] = aryParamsPKey;
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount);
#endregion
}
public static string GetCategoryNameAtServer(string str_CATEGORY)
{
#region
string strResult = "";
try
{
string strPID = "", strCategory_Name = "";
TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
DataTable dt = null;
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(str_CATEGORY);
ParameterList.Add(null);
ParameterList.Add(1);
dt = BCO.QUERY_TRN_CODE_MAIN(ParameterList);
/*
m.ID, m.code, m.NAME, m.createdate, m.createuid, m.updatedate,
m.updateuid, m.ENABLE, m.EXPLAIN
*/
if (dt != null && dt.Rows.Count > 0)
{
strPID = dt.Rows[0][0].ToString();
strCategory_Name = dt.Rows[0][2].ToString();
}
else
{
strCategory_Name = "查無資料";
}
strResult = string.Format("{0}||{1}||{2}", strPID, str_CATEGORY, strCategory_Name);
}
catch (Exception ex)
{
throw ex;
}
return strResult;
#endregion
}