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