/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" SELECT a.smid, a.tpa, a.recvdatetime, a.mmsfilesid, a.MANSTATE, a.MANRESULT, a.MANTIME, a.MANUSERID, b.filetype, b.filename");
sb.AppendFormat(" FROM tb_rcvtmp AS a LEFT OUTER JOIN tb_rcvmmsfiles AS b ON a.mmsfilesid = b.mmsfilesid");
sb.AppendFormat(" WHERE (b.filetype = 'IMG')");
if (string.IsNullOrEmpty(sw.smid) == false)
{
sb.AppendFormat(" AND smid = '{0}'", ClsSql.EncodeSql(sw.smid));
}
if (string.IsNullOrEmpty(sw.tpa) == false)
{
sb.AppendFormat(" AND tpa = '{0}'", ClsSql.EncodeSql(sw.tpa));
}
if (!string.IsNullOrEmpty(sw.DateBegin))
{
sb.AppendFormat(" AND recvdatetime>='{0} 00:00:00'", sw.DateBegin);
}
if (!string.IsNullOrEmpty(sw.DateEnd))
{
sb.AppendFormat(" AND recvdatetime<='{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 recvdatetime DESC";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// ajax 获取图片
/// </summary>
/// <returns></returns>
public JsonResult ShowAjaxImageIndex()
{
MessageListObject ms = null;
//StringBuilder sb = new StringBuilder();
//sb.Append("<li style=\"transform-origin: center 256px 0px; transform: translate(0 px, 0 px) scale(0.4) translateZ(0px); opacity: 0.6; z-index: 8;\">");
var count = System.Configuration.ConfigurationManager.AppSettings["ImageCount"].ToString();
if (string.IsNullOrEmpty(count))
{
count = "10";
}
var sw = new JC_INFRAREDCAMERA_PHOTO_SW();
sw.TopCount = count;
var imagelist = JC_INFRAREDCAMERACls.getListModelTopPhoto(sw);
var imgurl = System.Configuration.ConfigurationManager.AppSettings["ImageUrl"].ToString();
foreach (var item in imagelist)
{
item.filename = item.filename.Replace(imgurl, "");
//sb.Append("<img src=\"" + item.filename + "\" class=\"sc-image\">");
//sb.Append("<div class=\"sc-content\">");
//sb.Append("<h2>设备: " + item.BasicInfoModel.INFRAREDCAMERANAME + "</h2>");
//sb.Append("<p>所属单位：【" + item.BasicInfoModel.ORGNAME + "】 手机号码：【" + item.tpa + "】 拍摄地点：【" + item.BasicInfoModel.ADDRESS + "】 接收时间：【" + item.recvdatetime + "】 </p>");
//sb.Append("</div>>");
//sb.Append("</li>");
}
ms = new MessageListObject(true, imagelist);
return(Json(ms));
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_INFRAREDCAMERA_PHOTO_Model getModelNewPhoto(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
DataTable dt = BaseDT.JC_INFRAREDCAMERA_PHOTO.getNewDT(sw);
JC_INFRAREDCAMERA_PHOTO_Model m = new JC_INFRAREDCAMERA_PHOTO_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.JC_INFRAREDCAMERA_PHOTOID = dt.Rows[i]["JC_INFRAREDCAMERA_PHOTOID"].ToString();
m.INFRAREDCAMERAID = dt.Rows[i]["INFRAREDCAMERAID"].ToString();
m.PHOTOTIME = dt.Rows[i]["PHOTOTIME"].ToString();
m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getNewDT(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" SELECT JC_INFRAREDCAMERA_PHOTOID,INFRAREDCAMERAID,PHOTOTIME,PHOTOTITLE");
sb.AppendFormat(" FROM JC_INFRAREDCAMERA_PHOTO");
sb.AppendFormat(" WHERE 1=1 ");
if (string.IsNullOrEmpty(sw.INFRAREDCAMERAID) == false)
{
sb.AppendFormat(" AND INFRAREDCAMERAID = '{0}'", ClsSql.EncodeSql(sw.INFRAREDCAMERAID));
}
string sql = sb.ToString()
+ " order by PHOTOTIME DESC";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(JC_INFRAREDCAMERA_PHOTO_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM tb_rcvtmp AS a LEFT OUTER JOIN tb_rcvmmsfiles AS b ON a.mmsfilesid = b.mmsfilesid");
sb.AppendFormat(" WHERE (b.filetype = 'IMG')");
if (string.IsNullOrEmpty(sw.smid) == false)
{
sb.AppendFormat(" AND smid = '{0}'", ClsSql.EncodeSql(sw.smid));
}
if (string.IsNullOrEmpty(sw.tpa) == false)
{
sb.AppendFormat(" AND tpa like '%{0}%'", ClsSql.EncodeSql(sw.tpa));
}
if (!string.IsNullOrEmpty(sw.DateBegin))
{
sb.AppendFormat(" AND recvdatetime>='{0} 00:00:00'", sw.DateBegin);
}
if (!string.IsNullOrEmpty(sw.DateEnd))
{
sb.AppendFormat(" AND recvdatetime<='{0} 23:59:59'", sw.DateEnd);
}
if (string.IsNullOrEmpty(sw.MANSTATE) == false)
{
sb.AppendFormat(" AND MANSTATE = '{0}'", ClsSql.EncodeSql(sw.MANSTATE));
}
string sql = "SELECT a.smid, a.tpa, a.recvdatetime, a.mmsfilesid, a.MANSTATE, a.MANRESULT, a.MANTIME, a.MANUSERID, b.filetype, b.filename"
+ sb.ToString()
+ " order by recvdatetime DESC";
string sqlC = "select count(1) " + sb.ToString();
total = int.Parse(DataBaseClass.ReturnSqlField(sqlC));
sw.curPage = PagerCls.getCurPage(new PagerSW {
curPage = sw.curPage, pageSize = sw.pageSize, rowCount = total
});
DataSet ds = DataBaseClass.FullDataSet(sql, (sw.curPage - 1) * sw.pageSize, sw.pageSize, "a");
return(ds.Tables[0]);
}
/// <summary>
/// 图片展示1
/// </summary>
/// <returns></returns>
public ActionResult ShowImagePIndex()
{
var count = System.Configuration.ConfigurationManager.AppSettings["ImageCount"].ToString();
if (string.IsNullOrEmpty(count))
{
count = "10";
}
var sw = new JC_INFRAREDCAMERA_PHOTO_SW();
sw.TopCount = count;
var imagelist = JC_INFRAREDCAMERACls.getListModelTopPhoto(sw);
var imgurl = System.Configuration.ConfigurationManager.AppSettings["ImageUrl"].ToString();
foreach (var item in imagelist)
{
item.filename = item.filename.Replace(imgurl, "");
}
ViewBag.imagelist = imagelist;
return(View());
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getTopDT(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
StringBuilder sb = new StringBuilder();
if (string.IsNullOrEmpty(sw.TopCount)) //获取最新记录个数
{
sw.TopCount = "10"; //默认10条
}
sb.AppendFormat(" SELECT top {0} a.smid, a.tpa, a.recvdatetime, a.mmsfilesid, a.MANSTATE, a.MANRESULT, a.MANTIME, a.MANUSERID, b.filetype, b.filename", sw.TopCount);
sb.AppendFormat(" FROM tb_rcvtmp AS a LEFT OUTER JOIN tb_rcvmmsfiles AS b ON a.mmsfilesid = b.mmsfilesid");
sb.AppendFormat(" WHERE (b.filetype = 'IMG')");
if (string.IsNullOrEmpty(sw.MANSTATE) == false)
{
sb.AppendFormat(" AND MANSTATE = '{0}'", ClsSql.EncodeSql(sw.MANSTATE));
}
string sql = sb.ToString()
+ " order by recvdatetime DESC";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_INFRAREDCAMERA_PHOTO_Model> getListModelPhoto(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
DataTable dt = BaseDT.JC_INFRAREDCAMERA_PHOTO.getDT(sw);//列表
var result = new List <JC_INFRAREDCAMERA_PHOTO_Model>();
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_INFRAREDCAMERA_PHOTO_Model m = new JC_INFRAREDCAMERA_PHOTO_Model();
m.smid = dt.Rows[i]["smid"].ToString();
m.tpa = dt.Rows[i]["tpa"].ToString();
m.recvdatetime = ClsSwitch.SwitTM(dt.Rows[i]["recvdatetime"].ToString());
m.filename = dt.Rows[i]["filename"].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))
{
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
}
m.BasicInfoModel = getModel(new JC_INFRAREDCAMERA_BASICINFO_SW {
PHONE = m.tpa
});
result.Add(m);
}
dtUser.Clear();
dtUser.Dispose();
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_INFRAREDCAMERA_PHOTO_Model> getListNewModelPhoto(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
DataTable dt = BaseDT.JC_INFRAREDCAMERA_PHOTO.getNewDT(sw);//列表
var result = new List <JC_INFRAREDCAMERA_PHOTO_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_INFRAREDCAMERA_PHOTO_Model m = new JC_INFRAREDCAMERA_PHOTO_Model();
m.JC_INFRAREDCAMERA_PHOTOID = dt.Rows[i]["JC_INFRAREDCAMERA_PHOTOID"].ToString();
m.INFRAREDCAMERAID = dt.Rows[i]["INFRAREDCAMERAID"].ToString();
m.PHOTOTIME = dt.Rows[i]["PHOTOTIME"].ToString();
m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取相机图片检索
/// </summary>
/// <returns></returns>
public JsonResult GetPhotoListHtmlAjax()
{
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(" </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_INFRAREDCAMERA_PHOTO_SW();
sw.DateBegin = txtStartTime;
sw.DateEnd = txtEndTime;
if (status != "3")//0 未处理1已处理 2 已转为火情 3全部
{
sw.MANSTATE = status;
}
var list = JC_INFRAREDCAMERACls.getListModelPhoto(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.INFRAREDCAMERANAME);
sb.AppendFormat("<td>{0}</td>", item.BasicInfoModel.ORGNAME);
sb.AppendFormat("<td>{0}</td>", item.tpa);
sb.AppendFormat("<td>{0}</td>", item.recvdatetime);
sb.AppendFormat("<td><a href='{0}' target=_blank><image src='{0}' style='width:70px;height:70px' title='点击看大图'></a></td>", item.filename.Replace(imgurl, ""));
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=\"removePhoto(" + item.smid + ")\">删除</a> <a href=\"javascript:void(0);\" onClick=\"convertFire('../JCFireInfo/FireHtmlIndex','1'," + item.smid + ")\">处理</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=\"removePhoto(" + item.smid + ")\">删除</a></td>");
}
else
{
sb.AppendFormat("<td><a class=\"label label-success\">已处理</a></td>");
sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"removePhoto(" + item.smid + ")\">删除</a></td>");
}
//class=\"icon-flag\"
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));
}
