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);
}
