protected override bool Execute(CodeActivityContext context) { DataTable TempTable = null; try { var serverData = ARM_Service.REP_Query_Report(Sql.Get(context), new List <QueryParameter>()); if (!string.IsNullOrEmpty(serverData.Value)) { Error.Set(context, serverData.Value); } else { TempTable = serverData.Key; } } catch (Exception ex) { Error.Set(context, ex.Message); if (!HideException.Get(context)) { throw ex; } } List <DataRow> L = new List <DataRow>(); if (TempTable != null) { foreach (DataRow row in TempTable.Rows) { L.Add(row); } } ResultRows.Set(context, L); return(string.IsNullOrEmpty(Error.Get(context))); }
protected override bool Execute(CodeActivityContext context) { DataTable TempTable = null; string sql = @"set nocount on;set transaction isolation level read uncommitted;select TI_ID from Info_Meters_TO_TI join Hard_MetersUSPD_Links on Hard_MetersUSPD_Links.METER_ID=Info_Meters_TO_TI.METER_ID where USPD_ID=" + USPD_ID.Get(context); try { var serverData = ARM_Service.REP_Query_Report( sql, new List <QueryParameter>()); if (!string.IsNullOrEmpty(serverData.Value)) { Error.Set(context, serverData.Value); } else if (serverData.Key != null) { TempTable = serverData.Key; var result = new List <int>(); foreach (DataRow r in TempTable.Rows) { if (r.ItemArray != null && r.ItemArray.Length > 0) { result.Add((int)r.ItemArray[0]); } } TIList.Set(context, result); } } catch (Exception ex) { Error.Set(context, ex.Message); if (!HideException.Get(context)) { throw ex; } } return(string.IsNullOrEmpty(Error.Get(context))); }
public override void ShowDialog(PropertyValue propertyValue, IInputElement commandSource) { ReportIDDialog dialogcontent = new ReportIDDialog(); InArgument <string> propVal = (InArgument <string>)propertyValue.Value; string CurrRepId = null; if (propVal != null) { CurrRepId = propVal.Expression.ToString(); } var tree = dialogcontent.treeView1; tree.Items.Clear(); DataTable TempTable = null; string sql = @"set nocount on;set transaction isolation level read uncommitted; SELECT Info_Report.Report_UN, Info_Report.StringName, Info_Report.HierLev0_ID, Info_Report.HierLev1_ID, Info_Report.HierLev2_ID, Info_Report.HierLev3_ID, Info_Report.PS_ID, Info_Report.User_ID, Info_Report.CreateDateTime, Info_Report.DispatchDateTime, Info_Report.DateTimeDialog, Dict_HierLev0.StringName AS Lev0, Dict_HierLev1.StringName AS Lev1, Dict_HierLev2.StringName AS Lev2, Dict_HierLev3.StringName AS Lev3, Dict_PS.StringName AS PSNAme FROM Info_Report LEFT JOIN Dict_PS ON Info_Report.PS_ID = Dict_PS.PS_ID LEFT OUTER JOIN Dict_HierLev2 ON Info_Report.HierLev2_ID = Dict_HierLev2.HierLev2_ID LEFT OUTER JOIN Dict_HierLev1 ON Info_Report.HierLev1_ID = Dict_HierLev1.HierLev1_ID AND Info_Report.HierLev1_ID = Dict_HierLev1.HierLev1_ID LEFT OUTER JOIN Dict_HierLev3 ON Info_Report.HierLev3_ID = Dict_HierLev3.HierLev3_ID AND Info_Report.HierLev3_ID = Dict_HierLev3.HierLev3_ID AND Dict_HierLev2.HierLev2_ID = Dict_HierLev3.HierLev2_ID LEFT OUTER JOIN Dict_HierLev0 ON Info_Report.HierLev0_ID = Dict_HierLev0.HierLev0_ID ORDER BY Info_Report.HierLev0_ID, Info_Report.HierLev1_ID, Info_Report.HierLev2_ID, Info_Report.HierLev3_ID, Info_Report.PS_ID"; try { var serverData = ARM_Service.REP_Query_Report(sql, new List <QueryParameter>()); TempTable = serverData.Key; } catch (Exception e) { } TreeViewItem Lev1 = null; TreeViewItem Lev2 = null; TreeViewItem Lev3 = null; TreeViewItem LevPs = null; TreeViewItem lastlev = null; if (TempTable != null) { foreach (DataRow row in TempTable.Rows) { var rClass = new RepClass { Report_UN = row["Report_UN"].ToString(), ReportName = row["StringName"].ToString(), HierLev1_Name = row["Lev1"] as string, HierLev2_Name = row["Lev2"] as string, HierLev3_Name = row["Lev3"] as string, PS_Name = row["PSNAme"] as string }; if ((Lev1 == null) || (Lev1 != null && Lev1.Header != null && Lev1.Header.ToString() != rClass.HierLev1_Name)) { Lev1 = new TreeViewItem(); if (string.IsNullOrEmpty(rClass.HierLev1_Name)) { Lev1.Header = rClass.ReportName; } else { Lev1.Header = rClass.HierLev1_Name; } Lev1.IsExpanded = true; tree.Items.Add(Lev1); lastlev = Lev1; } if ((Lev2 == null && !string.IsNullOrEmpty(rClass.HierLev2_Name)) || (Lev2 != null && Lev2.Header != null && Lev2.Header.ToString() != rClass.HierLev2_Name)) { Lev2 = new TreeViewItem(); Lev2.Header = rClass.HierLev2_Name; if (Lev1 != null) { Lev1.Items.Add(Lev2); } Lev2.IsExpanded = true; lastlev = Lev2; } if ((Lev3 == null && !string.IsNullOrEmpty(rClass.HierLev3_Name)) || (Lev3 != null && Lev3.Header != null && Lev3.Header.ToString() != rClass.HierLev3_Name)) { Lev3 = new TreeViewItem { Header = rClass.HierLev3_Name, IsExpanded = true }; if (Lev2 != null) { Lev2.Items.Add(Lev3); } lastlev = Lev3; } if ((LevPs == null && !string.IsNullOrEmpty(rClass.PS_Name)) || (LevPs != null && LevPs.Header != null && LevPs.Header.ToString() != rClass.PS_Name)) { LevPs = new TreeViewItem { Header = rClass.PS_Name, IsExpanded = true }; if (Lev3 != null) { Lev3.Items.Add(LevPs); } lastlev = LevPs; } if (lastlev != null) { var repLev = new TreeViewItem { Header = rClass.ReportName, Tag = rClass }; lastlev.Items.Add(repLev); if (CurrRepId == rClass.Report_UN) { repLev.IsSelected = true; } } } } if (dialogcontent.ShowOkCancel()) { if (tree.SelectedItem != null) { var selitem = tree.SelectedItem as TreeViewItem; if (selitem != null && selitem.Tag != null) { var RClass = selitem.Tag as RepClass; if (RClass != null) { var sel = RClass.Report_UN; propertyValue.Value = new InArgument <string>(sel); } } } } }
public override void ShowDialog(PropertyValue propertyValue, IInputElement commandSource) { ReportObjectClassIDDialog dialogcontent = new ReportObjectClassIDDialog(); InArgument <string> propVal = (InArgument <string>)propertyValue.Value; string CurrRepId = null; if (propVal != null) { CurrRepId = propVal.Expression.ToString(); } TreeView tree = dialogcontent.treeView1; tree.Items.Clear(); DataTable TempTable = null; string sql = @"set nocount on;set transaction isolation level read uncommitted; SELECT ReportObjectClass_UN ,ObjectClass ,StringName FROM Report_Reports_For_ObjectClass_List order by ObjectClass, StringName"; try { var serverData = ARM_Service.REP_Query_Report(sql, new List <QueryParameter>()); TempTable = serverData.Key; } catch (Exception e) { } TreeViewItem Lev1 = null; int LastOClas = -1; if (TempTable != null) { foreach (DataRow row in TempTable.Rows) { var RClass = new RepClass { Report_UN = row["ReportObjectClass_UN"].ToString(), ReportName = row["StringName"].ToString(), ObjectClass = (int)row["ObjectClass"] }; string Level0Name = "Неизвестный"; switch (RClass.ObjectClass) { case 1: Level0Name = "Отчеты для ПС"; break; case 2: Level0Name = "Отчеты для ТП"; break; case 3: Level0Name = "Отчеты для МКД"; break; } if (LastOClas != RClass.ObjectClass) { LastOClas = RClass.ObjectClass; Lev1 = new TreeViewItem { Header = Level0Name, IsExpanded = true }; tree.Items.Add(Lev1); } var repLev = new TreeViewItem { Header = RClass.ReportName, Tag = RClass }; Lev1.Items.Add(repLev); if (CurrRepId == RClass.Report_UN) { repLev.IsSelected = true; } } } if (dialogcontent.ShowOkCancel()) { if (tree.SelectedItem != null) { var selitem = tree.SelectedItem as TreeViewItem; if (selitem != null && selitem.Tag != null) { var RClass = selitem.Tag as RepClass; if (RClass != null) { var sel = RClass.Report_UN; //propVal.Expression = new VisualBasicValue<string>(sel); //propertyValue.Value = new InArgument<string>(new VisualBasicValue<string>(sel)); propertyValue.Value = new InArgument <string>(sel); } } } } }