private void ShowTerminals() { var totalRecords = 0; var pageIndex = "" == hidPageIndex.Value ? 1 : int.Parse(hidPageIndex.Value); var list = TerminalInstance.FindPageList <TB_Terminal>(pageIndex, PageSize, out totalRecords, f => f.Delete == false && f.HasBound == false && f.Type == TerminalType, "Number"); var totalPages = totalRecords / PageSize + (totalRecords % PageSize > 0 ? 1 : 0); string html = ""; if (totalRecords < 1) { html = "<tr><td colspan=\"6\">No records</tr>"; } else { var cnt = (pageIndex - 1) * PageSize; var n = (int?)null; foreach (var obj in list) { cnt++; var id = Utility.UrlEncode(Utility.Encrypt(obj.id.ToString())); html += "<tr>" + "<td style=\"text-align: center;\"><input type=\"radio\" name=\"satId\" id=\"cb_" + id + "\" /></td>" + "<td style=\"text-align: center;\">" + cnt + "</td>" + "<td><a>" + obj.Number + "</a></td>" + "<td>" + obj.Sim + "</td>" + "<td>" + (n == obj.Satellite ? "-" : obj.TB_Satellite.CardNo) + "</td>" + "<td>" + TerminalTypes.GetTerminalType(obj.Type.Value) + "</td>" + "<td></td>" + "</tr>"; } } tbodyBody.InnerHtml = html; divPagging.InnerHtml = ""; if (totalRecords > 0) { ShowPaggings(pageIndex, totalPages, totalRecords, "./terminals.aspx", divPagging); } }
private void ShowFlow() { var month = int.Parse(selectedMonths.Value); spanMonthly.InnerText = string.Format("for {0}{1:00}", selectedYears.Value, (month == 0 ? " full year" : ("/" + month.ToString("00")))); var query = txtQueryNumber.Value.Trim(); // 模糊查询时页码置为空 if (!string.IsNullOrEmpty(query)) { hidPageIndex.Value = ""; } var totalRecords = 0; var pageIndex = "" == hidPageIndex.Value ? 1 : int.Parse(hidPageIndex.Value); var list = TerminalInstance.FindPageList <TB_Terminal>(pageIndex, PageSize, out totalRecords, f => f.Delete == false && (f.Sim.Contains(query) || f.TB_Satellite.CardNo.Contains(query)), "Number"); var totalPages = totalRecords / PageSize + (totalRecords % PageSize > 0 ? 1 : 0); var monthly = int.Parse(string.Format("{0}{1:00}", selectedYears.Value, month)); string html = ""; if (totalRecords < 1) { html = "<tr><td colspan=\"13\">No records, Change condition and try again.</td></tr>"; } else { var cnt = (pageIndex - 1) * PageSize; var n = (int?)null; foreach (var obj in list) { cnt++; // var id = Utility.UrlEncode(Utility.Encrypt(obj.id.ToString())); // 查找绑定的设备信息 var equipment = obj.TB_Equipment.FirstOrDefault(); // 查找选定月的流量统计 var flow = obj.TB_TerminalFlow.Where <TB_TerminalFlow>(o => (month == 0 ? (o.Monthly >= monthly && o.Monthly <= monthly + 100) : o.Monthly == monthly)); var _flow = FlowInstance.GetObject(); _flow.GPRSDeliver = flow.Select(s => s.GPRSDeliver).Sum(); _flow.GPRSReceive = flow.Select(s => s.GPRSReceive).Sum(); _flow.SMSDeliver = flow.Select(s => s.SMSDeliver).Sum(); _flow.SMSReceive = flow.Select(s => s.SMSReceive).Sum(); // 查找选定月的铱星流量 var _sat = IridiumInstance.GetObject(); if (obj.Satellite != n) { var sat = obj.TB_Satellite.TB_IridiumFlow.Where(w => (month == 0 ? (w.Monthly >= monthly && w.Monthly <= monthly + 100) : w.Monthly == monthly)); _sat.MOPayload = sat.Select(s => s.MOPayload).Sum(); _sat.MOTimes = sat.Select(s => s.MOTimes).Sum(); _sat.MTPayload = sat.Select(s => s.MTPayload).Sum(); _sat.MTTimes = sat.Select(s => s.MTTimes).Sum(); } html += "<tr>" + "<td class=\"in-tab-txt-b\">" + cnt + "</td>" + "<td class=\"in-tab-txt-b\" style=\"text-align: left;\">" + (null == equipment ? "not bind" : EquipmentInstance.GetFullNumber(equipment)) + "</td>" + "<td class=\"in-tab-txt-rb\" style=\"text-align: left;\">" + obj.Number + "</td>" + "<td class=\"in-tab-txt-b\">" + CustomConvert.FormatSize(_flow.GPRSReceive.Value) + "</td>" + "<td class=\"in-tab-txt-rb\">" + CustomConvert.FormatSize(_flow.GPRSDeliver.Value) + "</td>" + "<td class=\"in-tab-txt-b\">" + _flow.SMSReceive.Value.ToString() + "</td>" + "<td class=\"in-tab-txt-rb\">" + _flow.SMSDeliver.Value.ToString() + "</td>" + "<td class=\"in-tab-txt-rb\" style=\"text-align: left;\">" + (n == obj.Satellite ? "not bind" : obj.TB_Satellite.CardNo) + "</td>" + "<td class=\"in-tab-txt-b\">" + _sat.MOTimes.Value.ToString() + "</td>" + "<td class=\"in-tab-txt-rb\">" + CustomConvert.FormatSize(_sat.MOPayload.Value) + "</td>" + "<td class=\"in-tab-txt-b\">" + _sat.MTTimes.Value.ToString() + "</td>" + "<td class=\"in-tab-txt-b\">" + CustomConvert.FormatSize(_sat.MTPayload.Value) + "</td>" + "<td class=\"in-tab-txt-b\"></td>" + "</tr>"; } } tbodyBody.InnerHtml = html; divPagging.InnerHtml = ""; if (totalRecords > 0) { ShowPaggings(pageIndex, totalPages, totalRecords, "./terminal_flow.aspx", divPagging); } }
private void ShowTerminalsNotBind(int pageIndex) { var totalRecords = 0; // 表达式 Expression <Func <TB_Terminal, bool> > expression = PredicateExtensions.True <TB_Terminal>(); expression = expression.And(a => a.Delete == false); // 是否绑定卫星 -1:ignore,0:not,1:bound var sat = int.Parse(selectedSatellite.Value); spanSatellite.InnerHtml = "Satellite:" + GotSelectedType(sat); if (sat >= 0) { if (sat == 0) { expression = expression.And(a => a.Satellite == null); } else { expression = expression.And(a => a.Satellite != null); } } // 是否绑定设备-1:ignore,0:not,1:bound var equ = int.Parse(selectedEquipment.Value); spanEquipment.InnerHtml = "Equipment:" + GotSelectedType(equ); if (equ >= 0) { if (equ == 0) { expression = expression.And(a => a.HasBound == false); } } // 模糊查询 var query = txtNumber.Value.Trim(); if (!string.IsNullOrEmpty(query)) { expression = expression.And(a => a.Number.Contains(query) || a.TB_Satellite.CardNo.Contains(query)); } var list = TerminalInstance.FindPageList <TB_Terminal>(pageIndex, PageSize, out totalRecords, expression, "Number"); var totalPages = totalRecords / PageSize + (totalRecords % PageSize > 0 ? 1 : 0); string html = ""; if (totalRecords < 1) { html = "<tr><td colspan=\"11\">No records, You can change condition and try again or " + " <a href=\"./terminal_register.aspx\">ADD</a> new one.</td></tr>"; } else { var cnt = (pageIndex - 1) * PageSize; //var n = (int?)null; foreach (var obj in list) { cnt++; var id = Utility.UrlEncode(Utility.Encrypt(obj.id.ToString())); //-1:ignore,0:not,1:bound var equipment = EquipmentInstance.Find(f => f.TB_Terminal.id == obj.id && f.Deleted == false); //if(equ==0&&equi) html += "<tr>" + //"<td class=\"in-tab-txt-rb\"><input type=\"checkbox\" id=\"cb_" + id + "\" /></td>" + "<td class=\"in-tab-txt-rb\">" + cnt + "</td>" + "<td class=\"in-tab-txt-rb\" style=\"text-align: left !important;\"><a href=\"./terminal_register.aspx?key=" + id + "\" >" + CheckQueryString(obj.Number) + "</a></td>" + "<td class=\"in-tab-txt-rb\" style=\"text-align: left !important; cursor: pointer;\" title=\"Click to show advanced options\">" + CheckQueryString(TerminalInstance.GetSatellite(obj, true)) + "</td>" + "<td class=\"in-tab-txt-rb\">" + obj.Firmware + "</td>" + "<td class=\"in-tab-txt-rb\">" + obj.Revision.ToString() + "</td>" + "<td style=\"text-align: left !important;\" class=\"in-tab-txt-rb\">" + TerminalTypes.GetTerminalType(obj.Type.Value) + "</td>" + "<td class=\"in-tab-txt-rb\" style=\"text-align: left !important;\">" + obj.ProductionDate.Value.ToString("yyyy/MM/dd") + "</td>" + "<td class=\"in-tab-txt-rb\">" + (obj.HasBound == true ? "yes" : "no") + "</td>" + "<td class=\"in-tab-txt-rb\" style=\"text-align: left !important;\">" + CheckQueryString(GetEquipment(obj, equipment)) + "</td>" + "<td class=\"in-tab-txt-b\">" + Utility.GetOnlineStyle(obj.OnlineStyle, obj.OnlineTime, false) + "</td>" + //"<td class=\"in-tab-txt-rb\" style=\"text-align: left !important;\">" + obj.Sim + "</td>" + "<td class=\"in-tab-txt-b\"></td>" + "</tr>"; } } ShowFooter(totalRecords, pageIndex, totalPages, html); }