public string GetDeviceListByArea(QueryDevice query) { StringBuilder sbTree = new StringBuilder(); // var result = new ResultDevice(); // result.DeviceUnitList = new List<DeviceUnit>(); List<Device> deviceList; if(query.ItemCode=="00000") { deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and areaid=" + query.AreaID, " order by deviceid"); } else { string itemCodeAll = query.ItemCode; var itemcodeList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by itemcodeid")[0]; var itemcodeListChild = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ParentID=" + itemcodeList.ParentID, " order by itemcodeid"); itemCodeAll = itemcodeListChild.Aggregate(itemCodeAll, (current, itemcode) => current + ("," + itemcode.ItemcodeID)); deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and ItemCodeID in (" + itemCodeAll + ") and areaid=" + query.AreaID, " order by deviceid"); } sbTree.Append("["); for (var device=0; device< deviceList.Count;device++) { sbTree.Append("{\"text\": \"" + deviceList[device].DeviceName + "\",\"id\": " + deviceList[device].DeviceID + ",\"classes\": \"equip\"}"); sbTree.Append(device == deviceList.Count - 1 ? "" : ","); } sbTree.Append("]"); return sbTree.ToString(); }
public string GetDeviceListByArea(QueryDevice query) { StringBuilder sbTree = new StringBuilder(); // var result = new ResultDevice(); // result.DeviceUnitList = new List<DeviceUnit>(); List <NTS.WEB.Model.Device> deviceList; if (query.ItemCode == "00000" || string.IsNullOrEmpty(query.ItemCode)) { deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and areaid=" + query.AreaID, " order by deviceid"); } else { string itemCodeAll = query.ItemCode; string tempCode = string.Empty; var itemcodeList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by itemcodeid")[0]; var itemcodeListChild = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ParentID=" + itemcodeList.ItemcodeID, " order by itemcodeid"); foreach (NTS.WEB.Model.Itemcode itemcode in itemcodeListChild) { tempCode += ",'" + itemcode.ItemCodeNumber + "'"; } itemCodeAll = tempCode.Length > 0 ? tempCode.Substring(1) : "'" + itemCodeAll + "'"; deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and ItemCodeID in (" + itemCodeAll + ") and areaid=" + query.AreaID, " order by deviceid"); } sbTree.Append("["); for (var device = 0; device < deviceList.Count; device++) { sbTree.Append("{\"text\": \"" + deviceList[device].DeviceName + "\",\"id\": " + deviceList[device].DeviceID + ",\"classes\": \"equip\"}"); sbTree.Append(device == deviceList.Count - 1 ? "" : ","); } sbTree.Append("]"); return(sbTree.ToString()); }
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 string GetDeviceListByArea(QueryDevice query) { StringBuilder sbTree = new StringBuilder(); // var result = new ResultDevice(); // result.DeviceUnitList = new List<DeviceUnit>(); List <Device> deviceList; if (query.ItemCode == "00000") { deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and areaid=" + query.AreaID, " order by deviceid"); } else { string itemCodeAll = query.ItemCode; var itemcodeList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by itemcodeid")[0]; var itemcodeListChild = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ParentID=" + itemcodeList.ParentID, " order by itemcodeid"); itemCodeAll = itemcodeListChild.Aggregate(itemCodeAll, (current, itemcode) => current + ("," + itemcode.ItemcodeID)); deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and ItemCodeID in (" + itemCodeAll + ") and areaid=" + query.AreaID, " order by deviceid"); } sbTree.Append("["); for (var device = 0; device < deviceList.Count; device++) { sbTree.Append("{\"text\": \"" + deviceList[device].DeviceName + "\",\"id\": " + deviceList[device].DeviceID + ",\"classes\": \"equip\"}"); sbTree.Append(device == deviceList.Count - 1 ? "" : ","); } sbTree.Append("]"); return(sbTree.ToString()); }
/// <summary> /// 首页电分类占比图 /// </summary> /// <returns></returns> public ResultIndexPieChart IndexElectricityPieChart() { var result = new ResultIndexPieChart { ItemCode = new List <Itemcode>(), ItemCodeEnery = new List <decimal>() }; var itemList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and ParentID=(select itemcodeid from Becm_ItemCode where ItemCodeNumber='{0}')", "01000"), " order by ItemcodeID"); result.ItemCode = itemList; var eneryList = new NTS.WEB.BLL.Charts().GetIndexPieChart(); result.ItemCodeEnery = eneryList; return(result); }
public override string FormateContent(object primaryKey) { try { #region 变量 string content = string.Empty; int id = (int)primaryKey; string itemCodeName = string.Empty; string objectDes = string.Empty; string editTime = string.Empty; string quotaDate = string.Empty; string type = string.Empty; string oldValue = string.Empty; string newValue = string.Empty; string objectUnit = string.Empty; OperateQuotaBll quotaOper = new OperateQuotaBll(); #endregion #region 数据来源 var quotaInfo = quotaOper.GetQuotaInfoById(id); var itemCodeInfo = new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and itemcodenumber='{0}'", quotaInfo.QuotaData.ItemCode), "")[0]; QuotaLog newQoutaLog = quotaInfo.QuotaLogList[0]; #endregion #region 组织数据 itemCodeName = itemCodeInfo.ItemCodeName; objectUnit = itemCodeInfo.Unit; objectDes = quotaInfo.QuotaData.ObjectDesc; newValue = quotaInfo.QuotaData.QuotaValue.ToString(); editTime = newQoutaLog.LogTime.ToString("yyyy年MM月dd日HH时mm分ss秒"); type = quotaInfo.QuotaData.QuotaType == QuotaType.Month ? "月" : "年"; if (quotaInfo.QuotaData.QuotaType == QuotaType.Month) { quotaDate = string.Format("{0}年{1}月", quotaInfo.QuotaData.QuotaTime.Year, quotaInfo.QuotaData.QuotaTime.Month); } else if (quotaInfo.QuotaData.QuotaType == QuotaType.Year) { quotaDate = string.Format("{0}年", quotaInfo.QuotaData.QuotaTime.Year); } if (quotaInfo.QuotaLogList.Count > 1) { QuotaLog oldQUotaLog = quotaInfo.QuotaLogList[1]; oldValue = oldQUotaLog.QuotaValue.ToString(); content = string.Format("{0}用户于{1}修改\"{2}-{3}-{4}定额\":修改前为{5}kwh,修改后为{6}{7}。", _userName, editTime, objectDes, itemCodeName, type, oldValue, newValue, objectUnit); } else if (quotaInfo.QuotaLogList.Count == 1) { content = string.Format("{0}用户于{1}添加\"{2}-{3}-{4}定额\":{5}{6}。", _userName, editTime, objectDes, itemCodeName, type, newValue, objectUnit); } return(content); #endregion } catch (Exception ex) { return(ex.Message); } }
public override string FormateContent(object primaryKey) { try { #region 变量 string content = string.Empty; int id = (int)primaryKey; string itemCodeName = string.Empty; string objectDes = string.Empty; string editTime = string.Empty; string quotaDate = string.Empty; string type = string.Empty; string oldValue = string.Empty; string newValue = string.Empty; string objectUnit = string.Empty; OperateQuotaBll quotaOper = new OperateQuotaBll(); #endregion #region 数据来源 var quotaInfo = quotaOper.GetQuotaInfoById(id); var itemCodeInfo = new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and itemcodenumber='{0}'", quotaInfo.QuotaData.ItemCode), "")[0]; QuotaLog newQoutaLog = quotaInfo.QuotaLogList[0]; #endregion #region 组织数据 itemCodeName = itemCodeInfo.ItemCodeName; objectUnit = itemCodeInfo.Unit; objectDes = quotaInfo.QuotaData.ObjectDesc; newValue = quotaInfo.QuotaData.QuotaValue.ToString(); editTime = newQoutaLog.LogTime.ToString("yyyy年MM月dd日HH时mm分ss秒"); type = quotaInfo.QuotaData.QuotaType == QuotaType.Month ? "月" : "年"; if (quotaInfo.QuotaData.QuotaType == QuotaType.Month) { quotaDate = string.Format("{0}年{1}月", quotaInfo.QuotaData.QuotaTime.Year, quotaInfo.QuotaData.QuotaTime.Month); } else if (quotaInfo.QuotaData.QuotaType == QuotaType.Year) { quotaDate = string.Format("{0}年", quotaInfo.QuotaData.QuotaTime.Year); } if (quotaInfo.QuotaLogList.Count > 1) { QuotaLog oldQUotaLog = quotaInfo.QuotaLogList[1]; oldValue = oldQUotaLog.QuotaValue.ToString(); content = string.Format("{0}用户于{1}修改\"{2}-{3}-{4}定额\":修改前为{5}kwh,修改后为{6}{7}。", _userName, editTime, objectDes, itemCodeName, type, oldValue, newValue, objectUnit); } else if (quotaInfo.QuotaLogList.Count == 1) { content = string.Format("{0}用户于{1}添加\"{2}-{3}-{4}定额\":{5}{6}。", _userName, editTime, objectDes, itemCodeName, type, newValue, objectUnit); } return content; #endregion } catch (Exception ex) { return ex.Message; } }
public string GetDeviceListByArea(QueryDevice query) { StringBuilder sbTree = new StringBuilder(); // var result = new ResultDevice(); // result.DeviceUnitList = new List<DeviceUnit>(); List<Device> deviceList; if (query.ItemCode == "00000" || string.IsNullOrEmpty(query.ItemCode)) { deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and areaid=" + query.AreaID, " order by deviceid"); } else { string itemCodeAll = query.ItemCode; string tempCode = string.Empty; var itemcodeList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by itemcodeid")[0]; var itemcodeListChild = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ParentID=" + itemcodeList.ItemcodeID, " order by itemcodeid"); foreach (Model.Itemcode itemcode in itemcodeListChild) tempCode += ",'" + itemcode.ItemCodeNumber + "'"; itemCodeAll = tempCode.Length > 0 ? tempCode.Substring(1) : "'" + itemCodeAll + "'"; deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and ItemCodeID in (" + itemCodeAll + ") and areaid=" + query.AreaID, " order by deviceid"); } sbTree.Append("["); for (var device = 0; device < deviceList.Count; device++) { sbTree.Append("{\"text\": \"" + deviceList[device].DeviceName + "\",\"id\": " + deviceList[device].DeviceID + ",\"classes\": \"equip\"}"); sbTree.Append(device == deviceList.Count - 1 ? "" : ","); } sbTree.Append("]"); return sbTree.ToString(); }
public ItemList IndexItems(QueryEnergyIterm qery) { var pAction = new ExecuteProcess(); try { Itemcode itcode = new NTS.WEB.BLL.Itemcode(); List<Model.Itemcode> itemList = new List<Model.Itemcode>(); if (qery.ItemCode != "00000") { var itemParent = itcode.GetItemcodeList( string.Format(" and ItemCodeNumber='{0}'", qery.ItemCode), " order by ItemcodeID"); if (itemParent.Count > 0) { itemList = itcode.GetItemcodeList( string.Format("and PARENTID= {0} ", itemParent[0].ItemcodeID.ToString()), " order by ItemcodeID"); } } else { itemList = itcode.GetItemcodeList( string.Format("and PARENTID= {0} ", 0), " order by ItemcodeID"); } ItemList result = new ItemList(); result.ItemLst = new List<ItemSet>(); foreach (Model.Itemcode ic in itemList) { ItemSet its = new ItemSet(); its.ItemCode = ic.ItemCodeNumber; its.ItemName = ic.ItemCodeName; result.ItemLst.Add(its); } pAction.Success = true; result.ActionInfo = pAction; return result; } catch (Exception ex) { pAction.Success = false; pAction.ExceptionMsg = ex.Message; return new ItemList() { ActionInfo = pAction }; } }
public ResultItemCode GetTwoQueryLineChart(BasicQuery query, BasicQuery query2, int tabId) { #region 定义区 var queryCode = query.ItemCode; var resultList = new ResultView.ResultItemCode { ObjectName = new List<string>(), Enery = new Dictionary<string, List<decimal>>(), Dept = new List<string>() }; #endregion ResultItemCode result = GetQueryLineChart(query); ResultItemCode result2 = GetQueryLineChart(query2); resultList.Dept = result.Dept; foreach (var oname in result.ObjectName) { resultList.ObjectName.Add(""); } // resultList.ObjectName = result.ObjectName; decimal[] Arr = new decimal[result.Enery[result.Enery.Keys.First<string>()].Count]; decimal[] ArrNew = new decimal[result2.Enery[result2.Enery.Keys.First<string>()].Count]; if (queryCode == "00000") { foreach (var re in result.Enery) { for (int i = 0; i < re.Value.Count; i++) { Arr[i] += re.Value[i]; } } foreach (var re2 in result2.Enery) { for (int i = 0; i < re2.Value.Count; i++) { ArrNew[i] += re2.Value[i]; } } if (tabId == 1) { resultList.Enery.Add(query.StartTime.ToString("yyyy") + "总能耗", Arr.ToList()); resultList.Enery.Add(query2.StartTime.ToString("yyyy") + "总能耗", ArrNew.ToList()); } else { resultList.Enery.Add(query.StartTime.ToString("yyyy-MM") + "总能耗", Arr.ToList()); resultList.Enery.Add(query2.StartTime.ToString("yyyy-MM") + "总能耗", ArrNew.ToList()); } } else { var itemcodeList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + queryCode + "'", " order by itemcodeid")[0]; foreach (var r1 in result.Enery) { if (tabId == 1) { resultList.Enery.Add(query.StartTime.ToString("yyyy") + r1.Key, r1.Value); } else { resultList.Enery.Add(query.StartTime.ToString("yyyy-MM") + r1.Key, r1.Value); } } foreach (var r2 in result2.Enery) { if (tabId == 1) { resultList.Enery.Add(query2.StartTime.ToString("yyyy") + r2.Key, r2.Value); } else { resultList.Enery.Add(query2.StartTime.ToString("yyyy-MM") + r2.Key, r2.Value); } } } return resultList; }
public ResultQueryPie GetQueryPieChart(DataContact.BasicQuery query) { #region 定义区 var resultList = new ResultView.ResultQueryPie { ObjectName = new List<string>(), Enery = new List<decimal>(), Dept = new List<string>() }; #endregion var objectList = new BLL.BaseLayerObject().GetBaseLayerObjectList( string.Format(" and layerobjectparentid={0}", query.ObjectNum), " order by LayerObjectID"); if (objectList.Count > 0) { decimal eTotal = 0; for (var i = 0; i < objectList.Count; i++) { var querynew = new BasicQuery { StartTime = query.StartTime, EndTime = query.EndTime, ItemCode = query.ItemCode, ObjectNum = objectList[i].LayerObjectID, ObjectType = query.ObjectType, Unit = query.Unit }; //if (i < 5) //{ if (query.ItemCode != "00000") { var item = new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by ItemcodeID")[0]; resultList.Dept.Add(item.Unit); } else { resultList.Dept.Add("T"); } resultList.ObjectName.Add(objectList[i].LayerObjectName); resultList.Enery.Add(new QueryEnery().GetQueryEneryTotal(querynew).TotalEnergy); //} //else //{ // eTotal += new QueryEnery().GetQueryEneryTotal(querynew).TotalEnergy; // if (i == objectList.Count - 1) // { // if (query.ItemCode != "00000") // { // var item = // new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", // " order by ItemcodeID")[0]; // resultList.Dept.Add(item.Unit); // } // else // { // resultList.Dept.Add("T"); // } // resultList.ObjectName.Add("其他"); // resultList.Enery.Add(eTotal); // } //} } if (resultList.Enery.Count > 5) { //resultList.ObjectName[5] = "其他"; List<EnergyRank> lstEnergy = new List<EnergyRank>(); for (var i = 0; i < resultList.Enery.Count; i++) { EnergyRank er = new EnergyRank(); er.ObjName = resultList.ObjectName[i]; er.Energy = resultList.Enery[i]; lstEnergy.Add(er); } lstEnergy = lstEnergy.OrderByDescending(p => p.Energy).ToList(); resultList.Dept.Clear(); resultList.ObjectName.Clear(); resultList.Enery.Clear(); if (lstEnergy.Count < 6) { foreach (EnergyRank er in lstEnergy) { resultList.Dept.Add("T"); resultList.ObjectName.Add(er.ObjName); resultList.Enery.Add(er.Energy); } } else { for (int i = 0; i < 5; i++) { resultList.Dept.Add("T"); resultList.ObjectName.Add(lstEnergy[i].ObjName); resultList.Enery.Add(lstEnergy[i].Energy); } resultList.Dept.Add("T"); resultList.ObjectName.Add("其他"); //统计排名第五以后的能耗总和。 resultList.Enery.Add(lstEnergy.GetRange(5, lstEnergy.Count - 5).Sum(p => p.Energy)); } } return resultList; } else { var deviceList = new List<Device>(); if (query.ItemCode == "00000") { deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and areaid=" + query.ObjectNum, " order by deviceid"); } else { string itemCodeAll = query.ItemCode; string tempCode = string.Empty; var itemcodeList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by itemcodeid")[0]; var itemcodeListChild = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ParentID=" + itemcodeList.ParentID, " order by itemcodeid"); foreach (Model.Itemcode itemcode in itemcodeListChild) tempCode += ",'" + itemcode.ItemCodeNumber + "'"; itemCodeAll = itemCodeAll.Length > 0 ? "'" + itemCodeAll + "'" : itemCodeAll.Substring(1); deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and ItemCodeID in (" + itemCodeAll + ") and areaid=" + query.ObjectNum, " order by deviceid"); } if (deviceList.Count > 0) { decimal eTotal = 0; for (var i = 0; i < deviceList.Count; i++) { var querynew = new BasicQuery { StartTime = query.StartTime, EndTime = query.EndTime, ItemCode = query.ItemCode, ObjectNum = deviceList[i].DeviceID, ObjectType = query.ObjectType, Unit = query.Unit }; if (i < 5) { if (query.ItemCode != "00000") { var item = new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by ItemcodeID")[0]; resultList.Dept.Add(item.Unit); } else { resultList.Dept.Add("T"); } resultList.ObjectName.Add(deviceList[i].DeviceName); resultList.Enery.Add(new QueryEnery().GetDeviceQueryEneryTotal(querynew).TotalEnergy); } else { eTotal += new QueryEnery().GetDeviceQueryEneryTotal(querynew).TotalEnergy; if (i == deviceList.Count - 1) { if (query.ItemCode != "00000") { var item = new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by ItemcodeID")[0]; resultList.Dept.Add(item.Unit); } else { resultList.Dept.Add("T"); } resultList.ObjectName.Add("其他"); resultList.Enery.Add(eTotal); } } } return resultList; } } return null; }
/// <summary> /// 返回首页的电分类占比图 /// </summary> /// <returns></returns> public List<decimal> GetIndexPieChart() { var objectList = new BLL.BaseLayerObject().GetBaseLayerObjectList(string.Format(" and layerobjectparentid={0}", 0), " order by LayerObjectID"); var itemList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and ParentID=(select itemcodeid from Becm_ItemCode where ItemCodeNumber='{0}')", "01000"), " order by ItemcodeID"); var list = (from item in itemList select new BaseQueryModel { IsDevice = 0, ObjectList = (from p in objectList select p.LayerObjectID).ToList<int>(), ItemCode = item.ItemCodeNumber, Unit = ChartUnit.unit_month, Starttime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-1")), Endtime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-1")) } into model select _reportBll.GetBaseEneryDataList(model) into resList select objectList.Sum(o => resList.BaseLayerObjectResults[o.LayerObjectID.ToString()].Total)).ToList(); return list; }
/// <summary> /// 首页电分类占比图 /// </summary> /// <returns></returns> public ResultIndexPieChart IndexElectricityPieChart() { var result = new ResultIndexPieChart {ItemCode = new List<Itemcode>(), ItemCodeEnery = new List<decimal>()}; var itemList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and ParentID=(select itemcodeid from Becm_ItemCode where ItemCodeNumber='{0}')", "01000"), " order by ItemcodeID"); result.ItemCode = itemList; var eneryList = new NTS.WEB.BLL.Charts().GetIndexPieChart(); result.ItemCodeEnery = eneryList; return result; }
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; }