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