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