public List <SystemICS_SJJH_Node> GetSJJHNodeList()
{
List <SystemICS_SJJH_Node> _ret = new List <SystemICS_SJJH_Node>();
StringBuilder _sb = new StringBuilder();
_sb.Append(" select id,fid,displayName,yhm,lx,xh from sjjh_nodes");
_sb.Append(" order by xh ");
OracleDataReader dr = OracleHelper.ExecuteReader(OracleHelper.ConnectionStringProfile, CommandType.Text, _sb.ToString());
while (dr.Read())
{
SystemICS_SJJH_Node _item = new SystemICS_SJJH_Node(
dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "" : dr.GetString(3),
dr.IsDBNull(4) ? "" : dr.GetString(4),
dr.IsDBNull(5) ? 0 : Convert.ToInt32(dr.GetDecimal(5))
);
_ret.Add(_item);
}
dr.Close();
return(_ret);
}
public void ShowInfo(SystemICS_SJJH_Node _selectedItem)
{
_toBeQuery = _selectedItem;
if (!this.backgroundWorker1.IsBusy)
{
QueryData();
}
}
public void ShowInfo(SystemICS_SJJH_Node _selectedItem)
{
_toBeQuery = _selectedItem;
DateTime _now = DateTime.Now.Date;
this.te_end.EditValue = _now;
this.te_start.EditValue = _now.AddDays(-1);
this.bt_Refresh.Enabled = false;
if (!this.backgroundWorker1.IsBusy)
{
QueryData();
}
}
private void ShowSelectedItem()
{
if (!HaveSelected)
{
ClearInfo();
return;
}
SystemICS_SJJH_Node _selectNode = this.treeList1.FocusedNode.Tag as SystemICS_SJJH_Node;
this.imuC_SJJH_DataDefine1.ShowInfo(_selectNode);
this.imuC_SJJH_AccessLog1.ShowInfo(_selectNode);
this.imuC_SJJH_InterfaceInfo1.ShowInfo(_selectNode);
RaiseMenuChanged();
}
private void QueryData()
{
if (_toBeQuery != null)
{
lock (_toBeQuery)
{
_yhm = _toBeQuery.UserName;
_toBeQuery = null;
}
if (!this.backgroundWorker1.IsBusy)
{
this.panelWait.Visible = true;
this.backgroundWorker1.RunWorkerAsync();
}
}
}
private void LoadChildNode(TreeListNode _fnode, SystemICS_SJJH_Node _fdw, List <SystemICS_SJJH_Node> _nodeList)
{
SystemICS_SJJH_NodeFinder _finder = new SystemICS_SJJH_NodeFinder(_fdw.ID);
List <SystemICS_SJJH_Node> olist = _nodeList.FindAll(new Predicate <SystemICS_SJJH_Node>(_finder.FindByFatherID));
olist.Sort(new SystemICS_SJJH_NodeComparer());
foreach (SystemICS_SJJH_Node _dw in olist)
{
TreeListNode _dwnode = treeList1.AppendNode(null, _fnode);
_dwnode.SetValue(this.treeListColumn1, _dw.DisplayName);
_dwnode.ImageIndex = (_dw.LX == "用户") ? 2 : 1;
_dwnode.SelectImageIndex = (_dw.LX == "用户") ? 2 : 1;;
_dwnode.Tag = _dw;
LoadChildNode(_dwnode, _dw, _nodeList);
_dwnode.Expanded = true;
}
}
private void bt_Refresh_Click(object sender, EventArgs e)
{
_toBeQuery = LastNode;
QueryData();
}
public void ShowInfo(SystemICS_SJJH_Node _selectNode)
{
this.ICS_Name.Text = _selectNode.DisplayName;
this.ICS_State.Text = "ÆôÓÃ";
}