public List <ObjectRelayStatus> getObjectRelayStatus(int objectID)
{
List <ObjectRelayStatus> list = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ObjectID", objectID)
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGET_ObjectRelayStatus", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
list = new List <ObjectRelayStatus>();
foreach (DataRow row in table.Rows)
{
ObjectRelayStatus model = new ObjectRelayStatus();
model.ObjectID = Convert.ToInt32(row["ObjectID"]);
model.Device = row["Device"].ToString();
model.Name = row["Name"].ToString();
model.Current = Convert.ToDouble(row["Current"]);
model.Voltage = Convert.ToDouble(row["Voltage"]);
model.Fault = Convert.ToBoolean(row["Fault"]);
model.Status = row["Status"].ToString();
model.Category = row["Category"].ToString();
model.SensorId = Convert.ToInt32(row["SensorId"]);
model.DateTimeStamp = Convert.ToDateTime(row["DateTimeStamp"]);
list.Add(model);
}
}
}
return(list);
}
protected void RepeatergroupDetail_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string objectID = (e.Item.FindControl("hfObjectId") as HiddenField).Value;
string[] arr = objectID.Split(',');
bool RS = false;
if (arr[1] == "0")
{
RS = false;
}
if (arr[1] == "1")
{
RS = true;
}
Repeater rptGroups = e.Item.FindControl("rptgroup") as Repeater;
List <ObjectRelayStatus> LRstatus = new List <ObjectRelayStatus>();
List <ObjectRelayStatus> LRstatus2 = new List <ObjectRelayStatus>();
LRstatus = obj.getObjectRelays(Convert.ToInt32(arr[0]), RS);
if (LRstatus != null)
{
for (int i = 0; i < LRstatus.Count; i++)
{
ObjectRelayStatus lsi = new ObjectRelayStatus();
lsi.Name = LRstatus[i].Name;
lsi.Category = LRstatus[i].Category;
lsi.Status = LRstatus[i].Status;
lsi.StatusIOTClass = LRstatus[i].StatusIOTClass;
LRstatus2.Add(lsi);
}
}
rptGroups.DataSource = LRstatus2;
rptGroups.DataBind();
}
}
