/// <summary>
/// 获取热点信息
/// </summary>
/// <returns></returns>
public JsonResult GetHotPoinInfoAJax()
{
MessageObject ms = null;
string hotid = Request.Params["hotid"];
if (string.IsNullOrEmpty(hotid))
{
ms = new MessageObject(false, null);
return(Json(ms));
}
var sw = new T_IPS_HOTS_SW();
sw.HOTSID = hotid;
var model = T_IPS_HOTSCls.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 GetHotPontListAjax()
{
MessageListObject ms = null;
string state = Request.Params["state"];
var sw = new T_IPS_HOTS_SW();
sw.MANSTATE = state;
var list = T_IPS_HOTSCls.getModelList(sw);
if (list.Any())
{
ms = new MessageListObject(true, list);
}
return(Json(ms));
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(T_IPS_HOTS_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT HOTSID, BH, WXBH, DQRDBH, HLY, ZQWZ, JD, WD, XS, DL, YY, JXHQSJ, FXSJ, SBSJ, BZW, FJBH, WLBH, XZQH, CZW, MANSTATE, MANRESULT, MANTIME, MANUSERID");
sb.AppendFormat(" FROM T_IPS_HOTS");
sb.AppendFormat(" WHERE 1=1");
//判断是否是多少，如果是多少，用in，如果只是一个，用= 主要考虑到速度
if (string.IsNullOrEmpty(sw.HOTSID) == false)
{
if (sw.HOTSID.Split(',').Length > 1)
{
sb.AppendFormat(" AND HOTSID in({0})", ClsSql.EncodeSql(sw.HOTSID));
}
else
{
sb.AppendFormat(" AND HOTSID ='{0}'", ClsSql.EncodeSql(sw.HOTSID));
}
}
if (string.IsNullOrEmpty(sw.MANSTATE) == false)
{
sb.AppendFormat(" AND MANSTATE ='{0}'", ClsSql.EncodeSql(sw.MANSTATE));
}
if (!string.IsNullOrEmpty(sw.DateBegin))
{
sb.AppendFormat(" AND FXSJ>='{0} 00:00:00'", sw.DateBegin);
}
if (!string.IsNullOrEmpty(sw.DateEnd))
{
sb.AppendFormat(" AND FXSJ<='{0} 23:59:59'", sw.DateEnd);
}
sb.AppendFormat(" AND XS is not null ");
sb.AppendFormat(" ORDER BY FXSJ DESC ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 获取热点列表Html
/// </summary>
/// <returns></returns>
public JsonResult GetHotPointAjax()
{
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("<th>状态</th>");
sb.AppendFormat("<th>操作</th>");
sb.AppendFormat("</tr>");
sb.AppendFormat("</thead>");
sb.AppendFormat("<tbody>");
string txtHotStartTime = Request.Params["txtHotStartTime"]; //开始时间
string txtHotEndTime = Request.Params["txtHotEndTime"]; //结束时间
string hotstatus = Request.Params["hotstatus"]; //处理结果
var sw = new T_IPS_HOTS_SW();
sw.DateBegin = txtHotStartTime;
sw.DateEnd = txtHotEndTime;
if (hotstatus != "2")//0 未处理1已处理 2全部
{
sw.MANSTATE = hotstatus;
}
var list = T_IPS_HOTSCls.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.DQRDBH);
sb.AppendFormat("<td>{0}</td>", item.ZQWZ);
sb.AppendFormat("<td>{0}</td>", item.FXSJ);
sb.AppendFormat("<td>{0}</td>", item.XS);
sb.AppendFormat("<td>{0}</td>", item.YY);
sb.AppendFormat("<td>{0}</td>", (item.JXHQSJ == "无") ? "非连续" : "连续");
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=\"getLocaHot(" + item.HOTSID + ")\">定位</a></td>");
sb.AppendFormat("</tr>");
}
}
else
{
sb.AppendFormat("<tr>");
sb.AppendFormat("<td colspan=\"8\">暂无热点信息</td>");
sb.AppendFormat("</tr>");
}
sb.AppendFormat("</tbody>");
sb.AppendFormat("</table>");
ms = new Message(true, sb.ToString(), "");
return(Json(ms));
}
/// <summary>
/// 保存热点信息
/// </summary>
/// <returns></returns>
public JsonResult SaveHotPointInfoAjax()
{
Message ms = null;
string hotid = Request.Params["hotid"];
string hotresult = Request.Params["hotresult"];
if (string.IsNullOrEmpty(hotid))
{
ms = new Message(false, "hotid参数传递错误!", "");
return(Json(ms));
}
var m = new T_IPS_HOTS_Model();
m.opMethod = "Man";
m.HOTSID = hotid;
m.MANRESULT = hotresult;
m.MANUSERID = SystemCls.getUserID();
ms = T_IPS_HOTSCls.Manager(m);
var jctype = System.Configuration.ConfigurationManager.AppSettings["ISJcFire"].ToString();
if (jctype.Trim() == "1")//增加至监测火情表
{
var list = JC_FIRECls.GetListModel(new JC_FIRE_SW()
{
FIREFROMID = m.HOTSID
});
if (!list.Any())
{
if (ms.Success)
{
//红外相机 = 1,
//卫星热点 = 2,
//人工报警 = 3,
//电子报警 = 4,
//护林员火情上报 = 5
var sw = new T_IPS_HOTS_SW();
sw.HOTSID = hotid;
var record = T_IPS_HOTSCls.getModel(sw);
if (record != null)
{
JC_FIRE_Model model = new JC_FIRE_Model();
model.opMethod = "Add";
model.FIREFROMID = m.HOTSID;
model.FIREFROM = "2";//卫星热点
model.FIRENAME = record.WXBH + record.ZQWZ + ClsSwitch.SwitTM(record.FXSJ) + "卫星热点火情";
model.FIRETIME = record.FXSJ;
model.JD = record.JD;
model.WD = record.WD;
model.ZQWZ = record.ZQWZ;
model.WXBH = record.WXBH;
model.DQRDBH = record.DQRDBH;
model.RSMJ = record.XS;
model.DL = record.DL;
model.YY = record.YY;
model.JXHQSJ = record.JXHQSJ;
model.RECEIVETIME = record.SBSJ;
var mm = JC_FIRECls.Manager(model);
}
}
}
}
return(Json(ms));
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <example>
/// sw.ALARMID 热点ID
/// </example>
/// <param name="sw">参见条件模型T_IPS_HOTS_SW</param>
/// <returns>参见模型T_IPS_HOTS_Model</returns>
public static T_IPS_HOTS_Model getModel(T_IPS_HOTS_SW sw)
{
DataTable dt = BaseDT.T_IPS_HOTS.getDT(sw);
T_IPS_HOTS_Model m = new T_IPS_HOTS_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.HOTSID = dt.Rows[i]["HOTSID"].ToString();
m.BH = dt.Rows[i]["BH"].ToString();
m.WXBH = dt.Rows[i]["WXBH"].ToString();
m.DQRDBH = dt.Rows[i]["DQRDBH"].ToString();
m.HLY = dt.Rows[i]["HLY"].ToString();
m.ZQWZ = dt.Rows[i]["ZQWZ"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
//******************计算坐标偏移量
string[] arr = PublicCls.switJWD(m.WD, m.JD);
m.WD = arr[0];
m.JD = arr[1];
//******************计算坐标偏移量 End
m.XS = dt.Rows[i]["XS"].ToString();
m.DL = dt.Rows[i]["DL"].ToString();
m.YY = dt.Rows[i]["YY"].ToString();
m.JXHQSJ = dt.Rows[i]["JXHQSJ"].ToString();
m.FXSJ = dt.Rows[i]["FXSJ"].ToString();
if (string.IsNullOrEmpty(m.FXSJ) == false)
{
m.FXSJ = PublicClassLibrary.ClsSwitch.SwitTM(m.FXSJ);
}
m.SBSJ = dt.Rows[i]["SBSJ"].ToString();
if (string.IsNullOrEmpty(m.SBSJ) == false)
{
m.SBSJ = PublicClassLibrary.ClsSwitch.SwitTM(m.SBSJ);
}
m.BZW = dt.Rows[i]["BZW"].ToString();
m.FJBH = dt.Rows[i]["FJBH"].ToString();
m.WLBH = dt.Rows[i]["WLBH"].ToString();
m.XZQH = dt.Rows[i]["XZQH"].ToString();
m.CZW = dt.Rows[i]["CZW"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = 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();
}
//权限获取
//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);
}
