public List <SystemICS_SJJH_DataTable> GetSJJHTableList(string _yhm)
{
List <SystemICS_SJJH_DataTable> _ret = new List <SystemICS_SJJH_DataTable>();
StringBuilder _sb = new StringBuilder();
_sb.Append(" select YHM,TABLENAME,WHERECONDITION,SECRETFUN from sjjh_dcsjblb");
_sb.Append(" where YHM=:YHM ");
OracleParameter[] _param =
{
new OracleParameter(":YHM", OracleDbType.Varchar2)
};
_param[0].Value = _yhm;
OracleDataReader dr = OracleHelper.ExecuteReader(OracleHelper.ConnectionStringProfile, CommandType.Text, _sb.ToString(), _param);
while (dr.Read())
{
SystemICS_SJJH_DataTable _item = new SystemICS_SJJH_DataTable(
dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "" : dr.GetString(3),
"");
_item.Columns = GetSJJHTableColumns(_item.TableName);
_ret.Add(_item);
}
dr.Close();
return(_ret);
}
private void ShowColumns()
{
if (TableList.Count < 0 || this.gridView1.FocusedRowHandle < 0)
{
this.gridView2.BeginUpdate();
this.sinoCommonGrid2.DataSource = null;
this.gridView2.EndUpdate();
return;
}
int _index = this.gridView1.FocusedRowHandle;
SystemICS_SJJH_DataTable _selectedTable = this.gridView1.GetRow(_index) as SystemICS_SJJH_DataTable;
this.gridView2.BeginUpdate();
this.sinoCommonGrid2.DataSource = _selectedTable.Columns;
this.gridView2.EndUpdate();
}
