示例#1
0
        public List <Device> GetDeviceListByAreaId()
        {
            LayerObjectBll bllObjectBll;
            var            inputValue = _ntsPage.Request.Form["Inputs"];
            var            query      = Newtonsoft.Json.JsonConvert.DeserializeObject <QueryDevice>(inputValue);

            // 递归树
            if (query.treeInfo == 1)
            {
                bllObjectBll = new LayerFunObject(query.areaid);
            }
            else
            {
                bllObjectBll = new LayerBaseObject(query.areaid);
            }

            var itemcodelist = new StringBuilder();
            var list         =
                new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and (parentid=(select ItemcodeID from Becm_ItemCode where ItemCodeNumber='{0}')) or ItemCodeNumber='{0}' ", query.itemCode), string.Empty);

            foreach (var l in list)
            {
                itemcodelist.Append(string.Format(",'{0}'", l.ItemCodeNumber));
            }
            var whereStr = query.treeInfo == 1
                ? string.Format(" and areaid2 in({0}) and itemCodeID in({1})", bllObjectBll.GetTreeObjects(), itemcodelist.ToString().Substring(1))
                : string.Format(" and areaid in({0}) and itemCodeID in({1})", bllObjectBll.GetTreeObjects(), itemcodelist.ToString().Substring(1));
            var devicelist = new WEB.BLL.BaseLayerObject().GetDeviceObjectList(whereStr,
                                                                               string.Empty);

            return(devicelist);
        }
示例#2
0
        public List<Device> GetDeviceListByAreaId()
        {
            LayerObjectBll bllObjectBll;
            var inputValue = _ntsPage.Request.Form["Inputs"];
            var query = Newtonsoft.Json.JsonConvert.DeserializeObject<QueryDevice>(inputValue);

            // 递归树
            if (query.treeInfo == 1)
            {
                bllObjectBll = new LayerFunObject(query.areaid);
            }
            else
            {
                bllObjectBll = new LayerBaseObject(query.areaid);
            }

            var itemcodelist = new StringBuilder();
            var list =
                new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and (parentid=(select ItemcodeID from Becm_ItemCode where ItemCodeNumber='{0}')) or ItemCodeNumber='{0}' ", query.itemCode), string.Empty);
            foreach (var l in list)
            {
                itemcodelist.Append(string.Format(",'{0}'", l.ItemCodeNumber));
            }
            var whereStr = query.treeInfo == 1
                ? string.Format(" and areaid2 in({0}) and itemCodeID in({1})", bllObjectBll.GetTreeObjects(), itemcodelist.ToString().Substring(1))
                : string.Format(" and areaid in({0}) and itemCodeID in({1})", bllObjectBll.GetTreeObjects(), itemcodelist.ToString().Substring(1));
            var devicelist = new WEB.BLL.BaseLayerObject().GetDeviceObjectList(whereStr,
                string.Empty);
            return devicelist;
        }