private List <MD_ReportGuideLineItem> GetChildGuideLine(MD_ReportGuideLineItem _fitem, OracleConnection cn) { List <MD_ReportGuideLineItem> _ret = new List <MD_ReportGuideLineItem>(); string _sql = "select ID,FID,ZBMC,ZBZTMC from tj_zbcxdyb where fid =:FID and zbztmc =:ZTMC order by id "; OracleCommand _cmd = new OracleCommand(_sql, cn); _cmd.Parameters.Add(":FID", decimal.Parse(_fitem.ID)); _cmd.Parameters.Add(":ZTMC", _fitem.ZTName); OracleDataReader _dr = _cmd.ExecuteReader(); while (_dr.Read()) { MD_ReportGuideLineItem _item = new MD_ReportGuideLineItem( _dr.IsDBNull(0) ? "" : _dr.GetDecimal(0).ToString(), _dr.IsDBNull(1) ? "" : _dr.GetDecimal(1).ToString(), _dr.IsDBNull(2) ? "" : _dr.GetString(2), _dr.IsDBNull(3) ? "" : _dr.GetString(3), Enum_ReportGuideLineItemType.GuideLine ); _item.Children = GetChildGuideLine(_item, cn); _ret.Add(_item); } _dr.Close(); return(_ret); }
private void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { TreeListNode _cnode = this.treeList1.FocusedNode; if (_cnode != null) { MD_ReportGuideLineItem _item = _cnode.Tag as MD_ReportGuideLineItem; this.reportGuideLineUC_Query1.CurrentGuideLine = _item; this.reportGuideLineUC_Query1.ShowData(); } }
private void LoadChildNode(TreeListNode _fnode, MD_ReportGuideLineItem _fitem) { foreach (MD_ReportGuideLineItem _item in _fitem.Children) { TreeListNode _dwnode = treeList1.AppendNode(null, _fnode); _dwnode.SetValue(this.treeListColumn1, _item.DisplayName); if (_item.Type == Enum_ReportGuideLineItemType.Report) { _dwnode.ImageIndex = 1; } else { _dwnode.ImageIndex = 2; } _dwnode.SelectImageIndex = 0; _dwnode.Tag = _item; LoadChildNode(_dwnode, _item); _dwnode.Expanded = true; } }
public List <MD_ReportGuideLineItem> GetReportGuideLines(MD_ReportName _reportName) { List <MD_ReportGuideLineItem> _ret = new List <MD_ReportGuideLineItem>(); using (OracleConnection cn = OracleHelper.OpenConnection()) { try { OracleCommand _cmd = new OracleCommand(SQL_GetReportGuideLines, cn); _cmd.Parameters.Add(":ZTMC", _reportName.ReportName); OracleDataReader _dr = _cmd.ExecuteReader(); while (_dr.Read()) { MD_ReportGuideLineItem _item = new MD_ReportGuideLineItem( "1", "", _dr.IsDBNull(2) ? "" : _dr.GetString(2), _dr.IsDBNull(0) ? "" : _dr.GetString(0), Enum_ReportGuideLineItemType.Report ); _item.Children = GetChildGuideLine(_item, cn); _ret.Add(_item); } _dr.Close(); cn.Close(); } catch (Exception ex) { string _err = string.Format("取报表指标项时出错,错误信息:{0} SQL语句:{1}", ex.Message, SQL_GetReportGuideLines); OralceLogWriter.WriteSystemLog(_err, "ERROR"); throw ex; } } return(_ret); }