/// <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 }