protected override bool Execute(CodeActivityContext context)
{
DataTable TempTable = null;
string sql = @"set nocount on;set transaction isolation level read uncommitted;select Meter_ID from Hard_MetersE422_Links where E422_ID=" + E422_ID.Get(context).ToString();
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]);
}
}
MeterList.Set(context, result);
}
}
catch (Exception ex)
{
Error.Set(context, ex.Message);
if (!HideException.Get(context))
{
throw ex;
}
}
return(string.IsNullOrEmpty(Error.Get(context)));
}
