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