Beispiel #1
0
        /// <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(""));
            }
        }
Beispiel #2
0
        //
        // 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());
        }