/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(JC_MONITOR_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" SELECT IMBID, TTBH, IMBTIME, JD, WD, SPJ, FYJ, IMBIMGURL, MANSTATE, MANRESULT, MANTIME,MANUSERID"); sb.AppendFormat(" from JC_MONITOR"); sb.AppendFormat(" WHERE 1 = 1"); if (string.IsNullOrEmpty(sw.IMBID) == false) { sb.AppendFormat(" AND IMBID = '{0}'", ClsSql.EncodeSql(sw.IMBID)); } if (string.IsNullOrEmpty(sw.TTBH) == false) { sb.AppendFormat(" AND TTBH = '{0}'", ClsSql.EncodeSql(sw.TTBH)); } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND IMBTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND IMBTIME<='{0} 23:59:59'", sw.DateEnd); } if (string.IsNullOrEmpty(sw.MANSTATE) == false) { sb.AppendFormat(" AND MANSTATE = '{0}'", ClsSql.EncodeSql(sw.MANSTATE)); } string sql = sb.ToString() + " order by IMBTIME DESC"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 根据查询条件获取某一条信息记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static JC_MONITOR_Model getModelMonitor(JC_MONITOR_SW sw) { DataTable dt = BaseDT.JC_MONITOR.getDT(sw); JC_MONITOR_Model m = new JC_MONITOR_Model(); if (dt.Rows.Count > 0) { int i = 0; m.IMBID = dt.Rows[i]["IMBID"].ToString(); m.TTBH = dt.Rows[i]["TTBH"].ToString(); m.IMBTIME = ClsSwitch.SwitTM(dt.Rows[i]["IMBTIME"].ToString()); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.SPJ = dt.Rows[i]["SPJ"].ToString(); m.FYJ = dt.Rows[i]["FYJ"].ToString(); m.IMBIMGURL = dt.Rows[i]["IMBIMGURL"].ToString(); m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString(); m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString(); m.MANTIME = ClsSwitch.SwitTM(dt.Rows[i]["MANTIME"].ToString()); m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString(); if (!string.IsNullOrEmpty(m.MANUSERID)) { DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { USERID = m.MANUSERID }); DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'"); if (drUser.Length > 0) { m.ManUserName = drUser[0]["USERNAME"].ToString(); } dtUser.Clear(); dtUser.Dispose(); } m.BasicInfoModel = getModel(new JC_MONITOR_BASICINFO_SW { TTBH = m.TTBH }); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 电子监控火情监测信息 /// </summary> /// <returns></returns> /// <summary> public JsonResult GetMonitorListHtmlAjax() { Message ms = null; StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table id=\"sample-table-1\" class=\"table table-striped table-bordered table-hover\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr> "); sb.AppendFormat(" <th>序号</th>"); sb.AppendFormat(" <th>塔台编码</th>"); sb.AppendFormat(" <th>监控名称</th>"); sb.AppendFormat(" <th>所属机构</th>"); sb.AppendFormat(" <th>报警时间</th>"); sb.AppendFormat(" <th>水平角</th>"); sb.AppendFormat(" <th>俯仰角</th>"); sb.AppendFormat(" <th>图片地址</th>"); sb.AppendFormat(" <th>状态</th>"); sb.AppendFormat(" <th>操作</th>"); sb.AppendFormat(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); string txtStartTime = Request.Params["txtStartTime"]; //开始时间 string txtEndTime = Request.Params["txtEndTime"]; //结束时间 string status = Request.Params["status"]; //处理结果 var sw = new JC_MONITOR_SW(); sw.DateBegin = txtStartTime; sw.DateEnd = txtEndTime; if (status != "3")//0 未处理1已处理 2 已转为火情 3全部 { sw.MANSTATE = status; } var list = JC_MONITORCls.getListModelMonitor(sw); if (list.Any()) { var imgurl = System.Configuration.ConfigurationManager.AppSettings["ImageUrl"].ToString(); int i = 0; foreach (var item in list) { sb.AppendFormat("<tr>"); sb.AppendFormat("<td>{0}</td>", ++i); sb.AppendFormat("<td>{0}</td>", item.BasicInfoModel.TTBH); sb.AppendFormat("<td>{0}</td>", item.BasicInfoModel.EMNAME); sb.AppendFormat("<td>{0}</td>", item.BasicInfoModel.ORGNAME); sb.AppendFormat("<td>{0}</td>", item.IMBTIME); sb.AppendFormat("<td>{0}</td>", item.SPJ); sb.AppendFormat("<td>{0}</td>", item.FYJ); sb.AppendFormat("<td>{0}</td>", item.IMBIMGURL); if (item.MANSTATE == "0")//0 未处理 1 为已处理 2 为已转为火情 { sb.AppendFormat("<td><a class=\"label label-danger\">未处理</a></td>"); sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"removeMonitor(" + item.IMBID + ")\">删除</a> <a href=\"javascript:void(0);\" onClick=\"convertFire('../JCFireInfo/FireHtmlIndex','4'," + item.IMBID + ")\">处理</a></td>"); } else if (item.MANSTATE == "2") { sb.AppendFormat("<td><a class=\"label label-success\">已转为火情</a></td>"); sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"removeMonitor(" + item.IMBID + ")\">删除</a></td>"); } else { sb.AppendFormat("<td><a class=\"label label-success\">已处理</a></td>"); sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"removeMonitor(" + item.IMBID + ")\">删除</a></td>"); } //class=\"icon-flag\" sb.AppendFormat("</tr>"); } } else { sb.AppendFormat("<tr>"); sb.AppendFormat("<td colspan=\"10\">暂无电子监控信息</td>"); sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); ms = new Message(true, sb.ToString(), ""); return(Json(ms)); }