/// <summary> /// 返回单灯分组 /// </summary> /// <returns></returns> public JsonResult ReturnLightGroup(string sGUID) { LumluxSSYDB.BLL.tLightGroupInfoes blllightgroup = new LumluxSSYDB.BLL.tLightGroupInfoes(); LumluxSSYDB.Model.tLightGroupInfoes modlightgroup = new LumluxSSYDB.Model.tLightGroupInfoes(); LightGroupViewModel lightGroupVM = new LightGroupViewModel(); LightGroupInfoeVM lgvm; if (!string.IsNullOrWhiteSpace(sGUID)) { //查询单灯分组 List <LumluxSSYDB.Model.tLightGroupInfoes> dt2 = blllightgroup.GetModelListByHostGUID(sGUID); if (dt2 != null) { foreach (var item2 in dt2) { lgvm = new LightGroupInfoeVM(); lgvm.GUID = item2.sGUID.ToString(); if (string.IsNullOrWhiteSpace(item2.sName)) { lgvm.Name = "未命名"; } else { lgvm.Name = item2.sName.ToString(); } lightGroupVM.LightGroupInfoes.Add(lgvm); } } return(Json(lightGroupVM)); } else { return(Json("")); } }
/// <summary> /// 获取组名 /// </summary> /// <param name="sGUID"></param> /// <returns></returns> private string GetGroupNameByGUID(string sGUID) { string GroupName = null; LumluxSSYDB.BLL.tLightGroupInfoes lbtg = new LumluxSSYDB.BLL.tLightGroupInfoes(); LumluxSSYDB.Model.tLightGroupInfoes lmtg = lbtg.GetModel(sGUID); if (lmtg != null) { GroupName = lmtg.sName; } return(GroupName); }
// // GET: /Lamp/TimeControl/ public ActionResult Index() { #region 加载左侧所有主机信息 ViewBag.PrjectGUID = PrjGUID; LumluxSSYDB.BLL.tHostInfo bllhost = new LumluxSSYDB.BLL.tHostInfo(); List <HostInfoVM> list = new List <HostInfoVM>(); List <TimeInterval> TableOTList = new List <TimeInterval>(); List <TimeInterval> TableTTList = new List <TimeInterval>(); LumluxSSYDB.BLL.tLightGroupInfoes blllightgroup = new LumluxSSYDB.BLL.tLightGroupInfoes(); LumluxSSYDB.BLL.tRelayInfoes lbt = new LumluxSSYDB.BLL.tRelayInfoes(); //mainVM.MapCenterLat = GetLat("Prject_CenterPoint_Lat"); //mainVM.MapCenterLng = GetLng("Prject_CenterPoint_Lng"); DataTable allhostdt = bllhost.GetHostInfo("dbo.tHostInfo.sProjectInfoGUID='" + PrjGUID + "'"); if (allhostdt != null) { allhostdt.Columns.Add("hostByLightCount"); allhostdt.Columns.Add("hostByAlarmLightCount"); HostInfoVM hvm; foreach (DataRow dr in allhostdt.Rows) { hvm = addInfo(dr); list.Add(hvm); } } #endregion if (list.Count > 0) { ViewBag.hostlist = list; // 初始化主机下的24个时段 InitTimeControl(list[0].GUID); if (!lbt.ExistLoop(list[0].GUID)) { AddLoop(lbt, list[0].GUID); } ViewBag.LightGroup = blllightgroup.GetModelListByHostGUID(list[0].GUID) == null ? (new List <LumluxSSYDB.Model.tLightGroupInfoes>()) : (blllightgroup.GetModelListByHostGUID(list[0].GUID)); if (Convert.ToInt32(list[0].iHardware_Type) == Convert.ToInt32(EnumClass.SYType.eSixLoop)) { ViewBag.LoopInfo = lbt.GetModelList(" sHostInfoGUID='" + list[0].GUID + "' and iID between 0 and 6 order by iID") == null ? (new List <LumluxSSYDB.Model.tRelayInfoes>()) : lbt.GetModelList(" sHostInfoGUID='" + list[0].GUID + "' and iID between 0 and 6 order by iID"); } else { ViewBag.LoopInfo = lbt.GetModelList(" sHostInfoGUID='" + list[0].GUID + "' and iID between 0 and 3 order by iID") == null ? (new List <LumluxSSYDB.Model.tRelayInfoes>()) : lbt.GetModelList(" sHostInfoGUID='" + list[0].GUID + "' and iID between 0 and 3 order by iID"); } //查询单灯分组 //List<LumluxSSYDB.Model.tLightGroupInfoes> dt2 = } else { ViewBag.hostlist = new List <HostInfoVM>(); ViewBag.TableOT = new List <TimeInterval>(); ViewBag.TableTT = new List <TimeInterval>(); ViewBag.LightGroup = new List <LumluxSSYDB.Model.tLightGroupInfoes>(); ViewBag.LoopInfo = new List <LumluxSSYDB.Model.tRelayInfoes>(); } return(View()); }