/// <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));
}
