public static List <EquipmentData> GetChild(DataSet ds, EquipmentData pnode) { try { List <EquipmentData> Nodes = new List <EquipmentData>(); DataRow[] dr = ds.Tables[0].Select("ParentId=" + pnode.id); for (int i = 0; i < dr.Length; i++) { EquipmentData node = new EquipmentData(); node.id = dr[i]["ID"].ToString(); node.ParentId = dr[i]["ParentId"].ToString(); node.EquipmentCode = dr[i]["EquipmentCode"].ToString(); node.text = dr[i]["EquipmentName"].ToString(); node.EquipmentDesc = dr[i]["EquipmentDesc"].ToString(); node.Team = dr[i]["Team"].ToString(); node.EquipmentImg = dr[i]["EquipmentImg"].ToString(); node.PLCIP = dr[i]["PLCIP"].ToString(); node.PLCDB = dr[i]["PLCDB"].ToString(); node.IsPayPoint = dr[i]["IsPayPoint"].ToString(); node.DesignCycletime = dr[i]["DesignCycletime"].ToString(); node.DesignJPH = dr[i]["DesignJPH"].ToString(); node.EquipmentSupplier = dr[i]["EquipmentSupplier"].ToString(); node.Counter = dr[i]["Counter"].ToString(); node.children = GetChild(ds, node); Nodes.Add(node); } return(Nodes); } catch (Exception ex) { return(new List <EquipmentData>()); } }
public static List <EquipmentData> GetEquipmentTree(string nodeid) { try { string sql = "select * from EquipmentData(nolock)"; DataSet ds = SQLHelper.GetDataSet(sql); List <EquipmentData> rootNode = new List <EquipmentData>(); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataRow[] dr = ds.Tables[0].Select("ParentId=" + nodeid); for (int i = 0; i < dr.Length; i++) { EquipmentData node = new EquipmentData(); node.id = dr[i]["ID"].ToString(); node.ParentId = dr[i]["ParentId"].ToString(); node.EquipmentCode = dr[i]["EquipmentCode"].ToString(); node.text = dr[i]["EquipmentName"].ToString(); node.EquipmentDesc = dr[i]["EquipmentDesc"].ToString(); node.Team = dr[i]["Team"].ToString(); node.EquipmentImg = dr[i]["EquipmentImg"].ToString(); node.PLCIP = dr[i]["PLCIP"].ToString(); node.PLCDB = dr[i]["PLCDB"].ToString(); node.IsPayPoint = dr[i]["IsPayPoint"].ToString(); node.DesignCycletime = dr[i]["DesignCycletime"].ToString(); node.DesignJPH = dr[i]["DesignJPH"].ToString(); node.EquipmentSupplier = dr[i]["EquipmentSupplier"].ToString(); node.Counter = dr[i]["Counter"].ToString(); node.children = GetChild(ds, node); rootNode.Add(node); } } return(rootNode); } catch (Exception ex) { return(null); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string EId = HttpContext.Current.Request.Params["eid"]; double totalSpandTime = 0; double totalshifttime = 0; string sqlSearch = @"select * from WorkShift(nolock)"; DataSet dsSearch = SQLHelper.GetDataSet(sqlSearch); DateTime dt = DateTime.Now; DateTime dtbegin, dtend; dtbegin = dtend = dt; DateTime dtbeginx, dtendx; dtbeginx = dtendx = dt; if (dsSearch != null && dsSearch.Tables[0].Rows.Count > 0) { //获取当前班次的开始时间和结束时间 for (int i = 0; i < dsSearch.Tables[0].Rows.Count; i++) { dtbegin = DateTime.Parse(dt.ToString("yyyy-MM-dd ") + dsSearch.Tables[0].Rows[i]["BeginTime"].ToString().Trim()); dtend = DateTime.Parse(dt.ToString("yyyy-MM-dd ") + dsSearch.Tables[0].Rows[i]["EndTime"].ToString().Trim()); if (dtbegin >= dtend) { dtend = dtend.AddDays(1); //跨天结束时间加1天 } if (dtbegin <= dt && dt <= dtend) { dtbeginx = dtbegin; dtendx = dtend; } } totalSpandTime = (dt - dtbeginx).TotalMinutes; totalshifttime = (dtendx - dtbeginx).TotalMinutes; //获取班次小休 DataSet dsrest = SQLHelper.GetDataSet("select * from Rest(nolock)"); double spandrest = 0; if (dsrest != null && dsrest.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsrest.Tables[0].Rows.Count; i++) { dtbegin = DateTime.Parse(dt.ToString("yyyy-MM-dd ") + dsSearch.Tables[0].Rows[i]["BeginTime"].ToString().Trim()); dtend = DateTime.Parse(dt.ToString("yyyy-MM-dd ") + dsSearch.Tables[0].Rows[i]["EndTime"].ToString().Trim()); if (dtbegin >= dtend) { dtend = dtend.AddDays(1); //跨天结束时间加1天 } if (dt >= dtend) { spandrest = (dtend - dtbegin).TotalMinutes; } else if (dt > dtbegin && dt <= dtend) { spandrest = (dt - dtbegin).TotalMinutes; } totalSpandTime -= spandrest; totalshifttime -= spandrest; } } } string sqle = "select * from EquipmentData(nolock)"; DataSet ds = SQLHelper.GetDataSet(sqle); List <EquipmentData> rootNode = new List <EquipmentData>(); string lieid = EId; if (ds != null && ds.Tables[0].Rows.Count > 0) { DataRow[] dr = ds.Tables[0].Select("ParentId=" + EId); for (int i = 0; i < dr.Length; i++) { EquipmentData node = new EquipmentData(); lieid += "," + dr[i]["ID"].ToString(); node.id = dr[i]["ID"].ToString(); node.ParentId = dr[i]["ParentId"].ToString(); node.EquipmentCode = dr[i]["EquipmentCode"].ToString(); node.text = dr[i]["EquipmentName"].ToString(); node.EquipmentDesc = dr[i]["EquipmentDesc"].ToString(); node.Team = dr[i]["Team"].ToString(); node.EquipmentImg = dr[i]["EquipmentImg"].ToString(); node.PLCIP = dr[i]["PLCIP"].ToString(); node.PLCDB = dr[i]["PLCDB"].ToString(); node.IsPayPoint = dr[i]["IsPayPoint"].ToString(); node.DesignCycletime = dr[i]["DesignCycletime"].ToString(); node.DesignJPH = dr[i]["DesignJPH"].ToString(); node.EquipmentSupplier = dr[i]["EquipmentSupplier"].ToString(); node.Counter = dr[i]["Counter"].ToString(); node.children = GetChild(ds, node, ref lieid); rootNode.Add(node); } } string sqlwhere = ""; //测试时候注释 //sqlwhere += " AND EquipmentId in (" + lieid.Trim() + ")"; //sqlwhere += " AND FaultBeginTime>=N'" + dtbeginx.ToString("yyyy-MM-dd HH:mm:ss") + "'"; //sqlwhere += " AND FaultBeginTime<=N'" + dtbeginx.ToString("yyyy-MM-dd HH:mm:ss") + "'"; string sql = string.Format(@" select top 10 equipmentid,faultid,faultdesc, count(1) as xcount from EquipmentFault(nolock) where 1=1 {0} group by equipmentid,faultid,faultdesc order by xcount desc", sqlwhere); DataSet dsr = SQLHelper.GetDataSet(sql); string result = JsonConvert.SerializeObject(dsr.Tables[0], new DataTableConverter()); HttpContext.Current.Response.Write(result); }