public static string GetHTML(int pageIndex) { NetRadio.Data.AppDataContext db0 = new AppDataContext(); //NetRadio.DataExtension.AppExtensionDataContext db = new AppExtensionDataContext(); var cs = db0.Coordinates.ToArray(); StringBuilder sb = new StringBuilder(); sb.Append(@" <table cellpadding=""0"" cellspacing=""0"" class=""grid alternate fixed""> <thead class=""category""> <th width=""100"" style=""text-align: center""> 警察名称 </th> <th style=""text-align: left;""> 轨迹的定位点 </th> <th width=""100"" style=""text-align: center""> 操作 </th> </thead> "); string sql = @" select pg.*,p.HostName as policeName from (select * from Plugin_GoupCoordinates where GoupUseful=1) pg left join (select h.* from object_HostTag h,object_HostGroup g where g.hostid=h.hostid and g.hostgroupid = 1)p on(pg.ArraginID=p.HostId) "; int recordCount = Convert.ToInt32(Summer.Query.RunQuerySQLString(String.Format("select count(*) from ({0})g", sql), "LocatingMonitor").Rows[0][0]); int pageCount = 0; NetRadio.LocatingMonitor.PageData pd = NetRadio.LocatingMonitor.__Pager.GetPageData(pageIndex, recordCount); DataTable dt = Summer.QueryExtension.GetPageDataTableForMSSQL("LocatingMonitor", sql, pageIndex, pd.PageSize, out pageCount); var q = from _d in dt.AsEnumerable() select new { id = Convert.ToInt32(_d["id"]), policeName = _d["policeName"].ToString(), pointArray = Strings.ParseToArray <int>(_d["PointArray"].ToString(), new char[] { ',' }) }; foreach (var order in q) { sb.AppendFormat(@" <tr> <td width=""100"" style=""text-align: center""> {0} </td> <td style=""text-align: left""> {1} </td> <td width=""100"" style=""text-align: center""> {2} </td> </tr> ", order.policeName, cs.Where(_d => order.pointArray.Contains(_d.Id)).Select(_d1 => _d1.CoordinatesName).ToArray().ConnectAsString(","), "<a href='javascript:__delete(" + order.id + ");'>删除</a>"); } if (sb.Length == 0) { sb.AppendFormat(@" <tr> <td colspan=""4""> 无数据记录 </td> </tr>"); } sb.Append(@"</table>"); sb.Append("<br />" + pd.HtmlCode); return(sb.ToString()); }
public static string GetHTML(int pageIndex, string userids, string begintime, string endtime) { AppDataContext db = new AppDataContext(); string sql = "select * from history_TagPositionLog"; List <PatrolLog> patlog = Patrol.FigerOut(); int recordcount = Convert.ToInt32(patlog.Count); int pageCount = 0; NetRadio.LocatingMonitor.PageData pd = NetRadio.LocatingMonitor.__Pager.GetPageData(pageIndex, recordcount); DataTable dt = Summer.QueryExtension.GetPageDataTableForMSSQL("LocatingMonitor", sql, pageIndex, pd.PageSize, out pageCount); var tt = (from _d in patlog join _d1 in db.HostTags on _d.HostId equals _d1.HostId join _d2 in db.Coordinates on _d.StartCoordinateId equals _d2.Id select new { _d1.HostName, _d2.CoordinatesName, _d.PatrolStartTime, _d.PatrolEndTime, _d.PatrolReturnTime, _d.EndCoordinateId, _d.TimeInteval, _d.PointsCount } ).AsEnumerable(); StringBuilder sb = new StringBuilder(); sb.Append(@" <table cellpadding=""0"" cellspacing=""0"" class=""grid alternate fixed""> <thead class=""category""> <th width=""100"" style=""text-align: center""> 警察名称 </th> <th width=""200"" style=""text-align: center;""> 起始位置 </th> <th width=""150"" style=""text-align: center;""> 起始时间 </th> <th width=""100"" style=""text-align: center;""> 终点位置 </th> <th width=""150"" style=""text-align: center;""> 返回到起点时间 </th> <th width=""100"" style=""text-align: center;""> 巡逻时间 </th> </thead> "); var q = from _d in tt select new { name = _d.HostName, coorname = _d.CoordinatesName, sttime = _d.PatrolStartTime, endId = _d.EndCoordinateId, endtime = _d.PatrolEndTime, returntime = _d.PatrolReturnTime, timeInteval = _d.TimeInteval, pointCount = _d.PointsCount }; foreach (var item in q) { sb.AppendFormat(@" <tr> <td width=""100"" style=""text-align: center""> {0} </td> <td style=""text-align: center;""> {1} </td> <td style=""text-align: center;""> {2} </td> <td style=""text-align: center;""> {3} </td> <td style=""text-align: center;""> {4} </td> <td style=""text-align: center;""> {5} </td> </tr> ", item.name, item.coorname, item.sttime, Coordinates.GetName(item.endId), item.returntime, item.timeInteval); } if (sb.Length == 0) { sb.AppendFormat(@" <tr> <td colspan=""4""> 无数据记录 </td> </tr>"); } sb.Append(@"</table>"); sb.Append("<br />" + pd.HtmlCode); return(sb.ToString()); }