/// <summary> /// 检索结果报警定位 /// </summary> /// <returns></returns> public JsonResult GetLocaAlarmAjax() { string alarmid = Request.Params["alarmid"]; MessageObject ms = null; if (string.IsNullOrEmpty(alarmid)) { ms = new MessageObject(false, null); return(Json(ms)); } var sw = new T_IPS_ALARM_SW(); sw.ALARMID = alarmid; var model = T_IPS_ALARMCls.getModel(sw); ms = new MessageObject(true, model); return(Json(ms)); }
/// <summary> /// 获取一键报警信息 /// </summary> /// <returns></returns> public JsonResult GetAlarmInfoAjax() { MessageObject ms = null; string alarmid = Request.Params["alarmid"]; var sw = new T_IPS_ALARM_SW(); sw.ALARMID = alarmid; var model = T_IPS_ALARMCls.getModel(sw); if (model != null) { ms = new MessageObject(true, model); } else { ms = new MessageObject(false, null); } return(Json(ms)); }
/// <summary> /// 报警信息(一键报警) /// </summary> /// <returns></returns> public JsonResult GetAlarmListAjax() { string state = Request.Params["state"]; //处理状态 string starttime = Request.Params["starttime"]; //开始时间 string endtime = Request.Params["endtime"]; //开始时间 MessageListObject ms = null; var sw = new T_IPS_ALARM_SW(); sw.orgNo = SystemCls.getCurUserOrgNo(); sw.MANSTATE = state; sw.DateBegin = starttime; sw.DateEnd = endtime; sw.orgNo = SystemCls.getCurUserOrgNo(); var list = T_IPS_ALARMCls.getModelList(sw); if (list.Any()) { ms = new MessageListObject(true, list); } return(Json(ms)); }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(T_IPS_ALARM_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT ALARMID, LONGITUDE, LATITUDE, HEIGHT, PHONE, ADDRESS, ALARMTIME, ALARMCONTENT, MANSTATE,MANRESULT, MANTIME, MANUSERID"); sb.AppendFormat(" FROM T_IPS_ALARM"); sb.AppendFormat(" WHERE 1=1"); //判断是否是多少,如果是多少,用in,如果只是一个,用= 主要考虑到速度 if (string.IsNullOrEmpty(sw.ALARMID) == false) { if (sw.ALARMID.Split(',').Length > 1) { sb.AppendFormat(" AND ALARMID in({0})", ClsSql.EncodeSql(sw.ALARMID)); } else { sb.AppendFormat(" AND ALARMID ='{0}'", ClsSql.EncodeSql(sw.ALARMID)); } } //if (string.IsNullOrEmpty(sw.PHONE) == false) //{ // if (sw.PHONE.Length == 11)//精确查询 // sb.AppendFormat(" AND PHONE= '{0}'", ClsSql.EncodeSql(sw.PHONE)); // else//模糊查询 // sb.AppendFormat(" AND PHONE like '%{0}%'", ClsSql.EncodeSql(sw.PHONE)); //} if (string.IsNullOrEmpty(sw.MANSTATE) == false) { sb.AppendFormat(" AND MANSTATE ='{0}'", ClsSql.EncodeSql(sw.MANSTATE)); } if (string.IsNullOrEmpty(sw.orgNo) == false) { if (PublicCls.OrgIsShi(sw.orgNo)) { sb.AppendFormat(" and PHONE in (SELECT PHONE FROM T_IPSFR_USER where left(BYORGNO,4)='{0}')", PublicCls.getShiIncOrgNo(sw.orgNo)); } else if (PublicCls.OrgIsXian(sw.orgNo)) { sb.AppendFormat(" and PHONE in (SELECT PHONE FROM T_IPSFR_USER where left(BYORGNO,6)='{0}')", PublicCls.getXianIncOrgNo(sw.orgNo)); } else { sb.AppendFormat(" and PHONE in (SELECT PHONE FROM T_IPSFR_USER where BYORGNO='{0}')", PublicCls.getZhenIncOrgNo(sw.orgNo)); } //if (sw.orgNo.Substring(4, 5) == "00000")//获取所有县的 // sb.AppendFormat(" AND PHONE in (SELECT PHONE FROM T_IPSFR_USER where SUBSTRING(BYORGNO,1,4)) = '{0}'", ClsSql.EncodeSql(sw.orgNo.Substring(0, 4))); //else if (sw.orgNo.Substring(6, 3) == "000")//获取所有市的 // sb.AppendFormat(" AND PHONE in (SELECT PHONE FROM T_IPSFR_USER where SUBSTRING(BYORGNO,1,6)) = '{0}'", ClsSql.EncodeSql(sw.orgNo.Substring(0, 6))); //else // sb.AppendFormat(" AND PHONE in (SELECT PHONE FROM T_IPSFR_USER where BYORGNO = '{0}')", ClsSql.EncodeSql(sw.orgNo)); } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND ALARMTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND ALARMTIME<='{0} 23:59:59'", sw.DateEnd); } sb.AppendFormat(" ORDER BY ALARMTIME DESC "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 获取一条数据 /// </summary> /// <example> /// sw.ALARMID 报警ID /// </example> /// <param name="sw">参见条件模型T_IPS_ALARM_SW</param> /// <returns>参见模型T_IPS_ALARM_Model</returns> public static T_IPS_ALARM_Model getModel(T_IPS_ALARM_SW sw) { DataTable dt = BaseDT.T_IPS_ALARM.getDT(sw); T_IPS_ALARM_Model m = new T_IPS_ALARM_Model(); if (dt.Rows.Count > 0) { int i = 0; m.ALARMID = dt.Rows[i]["ALARMID"].ToString(); m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString(); //******************计算坐标偏移量 string[] arr = PublicCls.switJWD(m.LATITUDE, m.LONGITUDE); m.LATITUDE = arr[0]; m.LONGITUDE = arr[1]; //******************计算坐标偏移量 End m.HEIGHT = dt.Rows[i]["HEIGHT"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.ALARMTIME = dt.Rows[i]["ALARMTIME"].ToString(); if (string.IsNullOrEmpty(m.ALARMTIME) == false) { m.ALARMTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.ALARMTIME); } m.ALARMCONTENT = dt.Rows[i]["ALARMCONTENT"].ToString(); m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString(); m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString(); m.MANTIME = dt.Rows[i]["MANTIME"].ToString(); if (string.IsNullOrEmpty(m.MANTIME) == false) { m.MANTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.MANTIME); } m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString(); DataTable dtHRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { PHONE = m.PHONE }); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { USERID = m.MANUSERID }); DataRow[] drHRUser = dtHRUser.Select("PHONE='" + m.PHONE + "'"); if (drHRUser.Length > 0) { m.OrgNoName = drHRUser[0]["ORGNAME"].ToString(); m.HName = drHRUser[0]["HNAME"].ToString(); m.HID = drHRUser[0]["HID"].ToString(); m.OrgNo = drHRUser[0]["BYORGNO"].ToString(); } if (!string.IsNullOrEmpty(m.MANUSERID)) { DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'"); if (drUser.Length > 0) { m.ManUserName = drUser[0]["USERNAME"].ToString(); } } dtUser.Clear(); dtUser.Dispose(); dtHRUser.Clear(); dtHRUser.Dispose(); ////权限获取 //var userid = SystemCls.getUserID(); //var rightsw = new T_SYSSEC_IPSUSER_SW(); //rightsw.USERID = userid; //m.Rights = T_SYSSEC_RIGHTCls.getRightStrByUID(rightsw); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 检索报警信息列表Html /// </summary> /// <returns></returns> public JsonResult GetAlarmAjax() { Message ms = null; StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); 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("</tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); string txtAlarmStartTime = Request.Params["txtAlarmStartTime"]; //开始时间 string txtAlarmEndTime = Request.Params["txtAlarmEndTime"]; //结束时间 string status = Request.Params["status"]; //处理结果 var sw = new T_IPS_ALARM_SW(); sw.DateBegin = txtAlarmStartTime; sw.DateEnd = txtAlarmEndTime; sw.orgNo = SystemCls.getCurUserOrgNo(); if (status != "2")//0 未处理1已处理 2全部 { sw.MANSTATE = status; } var list = T_IPS_ALARMCls.getModelList(sw); if (list.Any()) { int i = 0; foreach (var item in list) { sb.AppendFormat("<tr>"); sb.AppendFormat("<td>{0}</td>", ++i); sb.AppendFormat("<td>{0}</td>", item.OrgNoName); sb.AppendFormat("<td>{0}</td>", item.HName); sb.AppendFormat("<td>{0}</td>", item.PHONE); sb.AppendFormat("<td>{0}</td>", item.ALARMTIME); if (item.MANSTATE == "0") { sb.AppendFormat("<td><a class=\"label label-danger\">未处理</a></td>"); } else { sb.AppendFormat("<td><a class=\"label label-success\">已处理</a></td>"); } sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"getLocaAlarm(" + item.ALARMID + ")\">定位</a></td>"); sb.AppendFormat("</tr>"); } } else { sb.AppendFormat("<tr>"); sb.AppendFormat("<td colspan=\"7\">暂无报警信息</td>"); sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); ms = new Message(true, sb.ToString(), ""); return(Json(ms)); }