/// <summary> /// 获取上传数据 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static DataTable getUploadDT(T_IPSCOL_COLLECT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT COLLECTUPLOADID, COLLECTID, UPLOADURL, UPLOADNAME, UPLOADDESCRIBE"); sb.AppendFormat(" FROM T_IPSCOL_DATAUPLOAD"); sb.AppendFormat(" WHERE 1=1"); //判断是否是多少,如果是多少,用in,如果只是一个,用= 主要考虑到速度 if (string.IsNullOrEmpty(sw.COLLECTID) == false) { if (sw.COLLECTID.Split(',').Length > 1) { sb.AppendFormat(" AND COLLECTID in({0})", ClsSql.EncodeSql(sw.COLLECTID)); } else { sb.AppendFormat(" AND COLLECTID ='{0}'", ClsSql.EncodeSql(sw.COLLECTID)); } } sb.AppendFormat(" ORDER BY COLLECTUPLOADID DESC "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 删除明细 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static Message DelDetail(T_IPSCOL_COLLECT_SW sw) { if (string.IsNullOrEmpty(sw.COLLECTDETAILID) && string.IsNullOrEmpty(sw.COLLECTID)) { return(new Message(false, "删除失败,请选择要处理的记录!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("DELETE FROM T_IPSCOL_DATADETAIL"); sb.AppendFormat(" where 1=1"); if (string.IsNullOrEmpty(sw.COLLECTDETAILID) == false) { sb.AppendFormat(" and COLLECTDETAILID= '{0}'", ClsSql.EncodeSql(sw.COLLECTDETAILID)); } if (string.IsNullOrEmpty(sw.COLLECTID) == false) { sb.AppendFormat(" and COLLECTID= '{0}'", ClsSql.EncodeSql(sw.COLLECTID)); } bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 获取采集信息List /// </summary> /// <returns>参见模型</returns> public JsonResult GetCollectDataListAjax() { string state = Request.Params["state"]; //获取处理状态 string type = Request.Params["type"]; //采集数据类型 string strarttime = Request.Params["strarttime"]; //开始时间 string endtime = Request.Params["endtime"]; //结束时间 var sw = new T_IPSCOL_COLLECT_SW(); if (state != "2") { sw.MANSTATE = state; } sw.DateBegin = strarttime; sw.DateEnd = endtime; sw.SYSTYPEVALUE = type; //采集类型 sw.orgNo = SystemCls.getCurUserOrgNo(); //当前单位 var list = T_IPSCOL_COLLECTCls.getModelList(sw); if (list.Any()) { return(Json(new MessageListObject(true, list))); } else { return(Json(new MessageListObject(false, null))); } }
/// <summary> /// 根据ID获取采集文件 /// </summary> /// <param name="sw">sw.COLLECTID</param> /// <returns>参见模型T_IPSCOL_COLLECT_Model</returns> public static IEnumerable <T_IPSCOL_COLLECT_Model> getUploadlModelList(T_IPSCOL_COLLECT_SW sw) { var result = new List <T_IPSCOL_COLLECT_Model>(); DataTable dt = BaseDT.T_IPSCOL_COLLECT.getUploadDT(new T_IPSCOL_COLLECT_SW { COLLECTID = sw.COLLECTID }); for (int i = 0; i < dt.Rows.Count; i++) { T_IPSCOL_COLLECT_Model m = new T_IPSCOL_COLLECT_Model(); m.COLLECTUPLOADID = dt.Rows[i]["COLLECTUPLOADID"].ToString(); m.COLLECTID = dt.Rows[i]["COLLECTID"].ToString(); m.UPLOADURL = dt.Rows[i]["UPLOADURL"].ToString(); if (!string.IsNullOrEmpty(m.UPLOADURL)) { var wcfservice = System.Configuration.ConfigurationManager.AppSettings["SpringerWcfService"];//wcf服务地址 if (!string.IsNullOrEmpty(wcfservice)) { m.UPLOADURL = wcfservice + m.UPLOADURL; } } m.UPLOADNAME = dt.Rows[i]["UPLOADNAME"].ToString(); m.UPLOADDESCRIBE = dt.Rows[i]["UPLOADDESCRIBE"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取明细 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static DataTable getDetailDT(T_IPSCOL_COLLECT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT COLLECTDETAILID, COLLECTID, LONGITUDE, LATITUDE, HEIGHT, DIRECTION, COLLECTTIME"); sb.AppendFormat(" FROM T_IPSCOL_DATADETAIL"); sb.AppendFormat(" WHERE 1=1"); //判断是否是多少,如果是多少,用in,如果只是一个,用= 主要考虑到速度 if (string.IsNullOrEmpty(sw.COLLECTID) == false) { if (sw.COLLECTID.Split(',').Length > 1) { sb.AppendFormat(" AND COLLECTID in({0})", ClsSql.EncodeSql(sw.COLLECTID)); } else { sb.AppendFormat(" AND COLLECTID ='{0}'", ClsSql.EncodeSql(sw.COLLECTID)); } } sb.AppendFormat(" ORDER BY COLLECTTIME DESC "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 获取详细采集点集合 /// </summary> /// <returns></returns> public JsonResult DataCollectDetailList() { string cid = Request.Params["cid"];//数据采集id var sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var list = T_IPSCOL_COLLECTCls.getDetailModelList(sw); return(Json(list)); }
/// <summary> /// 采集数据详细查看 /// </summary> /// <returns></returns> public ActionResult DataCollectDetailViewIndex() { string cid = Request.Params["cid"];//数据采集id var sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var model = T_IPSCOL_COLLECTCls.getModel(sw); return(View(model)); }
/// <summary> /// 获取采集图片List /// </summary> /// <returns>参见模型</returns> public JsonResult GetPhotoInfoAjax() { string cid = Request.Params["cid"]; if (string.IsNullOrEmpty(cid)) { return(Json(new Message(false, "cid参数传递失败", ""))); } var sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var list = T_IPSCOL_COLLECTCls.getUploadlModelList(sw); return(Json(new MessageListObject(true, list))); }
/// <summary> /// 获取采集明细 /// </summary> /// <returns>参见模型</returns> public JsonResult GetCollectModelInfoAjax() { string cid = Request.Params["cid"]; if (string.IsNullOrEmpty(cid)) { return(Json(new Message(false, "cid参数传递失败", ""))); } var sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var model = T_IPSCOL_COLLECTCls.getModel(sw); return(Json(new MessageObject(true, model))); }
/// <summary> /// 采集点详细Html /// </summary> /// <returns>参见模型</returns> public JsonResult GetCollectDetailAjax() { 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(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); string cid = Request.Params["cid"]; if (string.IsNullOrEmpty(cid)) { return(Json(new Message(false, "cid参数传递失败", ""))); } var sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var list = T_IPSCOL_COLLECTCls.getDetailModelList(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.LONGITUDE); sb.AppendFormat("<td>{0}</td>", item.LATITUDE); sb.AppendFormat("<td>{0}</td>", item.COLLECTTIME); sb.AppendFormat("</tr>"); } } else { sb.AppendFormat("<tr>"); sb.AppendFormat("<td colspan=\"4\">暂无经纬度信息</td>"); sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); return(Json(new Message(true, sb.ToString(), ""))); }
/// <summary> /// 根据ID获取采集数据 /// </summary> /// <example> /// sw.MANSTATE 处理状态 0未处理1已处理 /// sw.DateBegin 开始日期 /// sw.DateEnd 结束日期 /// </example> /// <param name="sw">参见条件模型T_IPSCOL_COLLECT_SW</param> /// <returns>参见模型T_IPSCOL_COLLECT_Model</returns> public static T_IPSCOL_COLLECT_Model getModel(T_IPSCOL_COLLECT_SW sw) { DataTable dt = BaseDT.T_IPSCOL_COLLECT.getDT(sw); T_IPSCOL_COLLECT_Model m = new T_IPSCOL_COLLECT_Model(); if (dt.Rows.Count > 0) { int i = 0; m.COLLECTID = dt.Rows[i]["COLLECTID"].ToString(); m.HID = dt.Rows[i]["HID"].ToString(); m.SYSTYPEVALUE = dt.Rows[i]["SYSTYPEVALUE"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.COLLECTTIME = ClsSwitch.SwitTM(dt.Rows[i]["COLLECTTIME"].ToString()); m.COLLECTNAME = dt.Rows[i]["COLLECTNAME"].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(); DataTable dtHRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { HID = m.HID }); if (dtHRUser.Rows.Count > 0) { m.HName = dtHRUser.Rows[0]["HNAME"].ToString(); m.Phone = dtHRUser.Rows[0]["PHONE"].ToString(); } dtHRUser.Clear(); dtHRUser.Dispose(); 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(); } } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取采集明细List /// </summary> /// <returns>参见模型</returns> public JsonResult GetCollectInfoAjax() { string cid = Request.Params["cid"]; string maptype = Request.Params["maptype"]; if (string.IsNullOrEmpty(cid)) { return(Json(new Message(false, "cid参数传递失败", ""))); } var sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; sw.MapType = maptype; var list = T_IPSCOL_COLLECTCls.getDetailModelList(sw); return(Json(new MessageListObject(true, list))); }
/// <summary> /// 获取数据 联护林员 /// </summary> /// <param name="sw">参见模型</param> /// <returns>DataTable</returns> public static DataTable getDtUnionHUser(T_IPSCOL_COLLECT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT a.COLLECTID, a.HID, a.SYSTYPEVALUE, a.ADDRESS, a.COLLECTTIME, a.COLLECTNAME, a.MANSTATE, a.MANRESULT, a.MANTIME, a.MANUSERID"); sb.AppendFormat(" FROM T_IPSCOL_COLLECTDATA a"); sb.AppendFormat(" left join T_IPSFR_USER b on a.HID=b.HID"); sb.AppendFormat(" WHERE 1=1"); if (!string.IsNullOrEmpty(sw.HUserName)) { sb.AppendFormat(" And b.HNAME like '%{0}%'", sw.HUserName); } if (!string.IsNullOrEmpty(sw.SYSTYPEVALUE)) { sb.AppendFormat(" AND a.SYSTYPEVALUE ='{0}'", ClsSql.EncodeSql(sw.SYSTYPEVALUE)); } if (string.IsNullOrEmpty(sw.orgNo) == false) { if (sw.orgNo.Substring(4, 5) == "00000")//获取所有县的 { sb.AppendFormat(" AND a.HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO like '{0}%')", ClsSql.EncodeSql(sw.orgNo.Substring(0, 4))); } else if (sw.orgNo.Substring(6, 3) == "000")//获取所有市的 { sb.AppendFormat(" AND a.HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO like '{0}%')", ClsSql.EncodeSql(sw.orgNo.Substring(0, 6))); } else { sb.AppendFormat(" AND a.HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO = '{0}')", ClsSql.EncodeSql(sw.orgNo)); } } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND a.COLLECTTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND a.COLLECTTIME<='{0} 23:59:59'", sw.DateEnd); } sb.AppendFormat(" ORDER BY a.COLLECTTIME DESC "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 获取采集信息model /// </summary> /// <returns>参见模型</returns> public JsonResult GetCollectModelDataAjax() { string cid = Request.Params["cid"];//获取处理状态 string maptype = Request.Params["maptype"]; var sw = new T_IPSCOL_COLLECT_SW(); if (!string.IsNullOrEmpty(maptype)) { sw.MapType = maptype;//地图类型 } sw.COLLECTID = cid; var list = T_IPSCOL_COLLECTCls.getModelList(sw); if (list.Any()) { return(Json(new MessageListObject(true, list))); } else { return(Json(new MessageListObject(false, null))); } }
private string getCollectHidDetailStr(T_IPSCOL_COLLECT_SW sw) { 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(" </tr>"); var list = T_IPSCOL_COLLECTCls.getModelList(sw); int i = 1; sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); foreach (var v in list) { sb.AppendFormat("<tr>"); sb.AppendFormat("<td class=\"center\">{0}</td>", i.ToString()); sb.AppendFormat("<td class=\"center\">{0}</td>", v.OrgNoName); sb.AppendFormat("<td class=\"center\">{0}</td>", v.HName); sb.AppendFormat("<td class=\"center\">{0}</td>", v.Phone); sb.AppendFormat("<td class=\"center\">{0}</td>", v.COLLECTTIME); sb.AppendFormat("<td class=\"center\">{0}</td>", (v.MANSTATE == "0") ? "×" : "√"); sb.AppendFormat("<td class=\"left\">{0}</td>", v.COLLECTNAME); sb.AppendFormat("<td class=\"left\">{0}</td>", v.ADDRESS); sb.AppendFormat("</tr>"); i++; } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); return(sb.ToString()); }
/// <summary> /// 获取上报与护林员、单位组合查询 用于统计 /// </summary> /// <param name="sw">参见模型 sw.TopORGNO 顶级单位编码 sw.DateBegin 开始日期 年月日 sw.DateEnd 结束日期 年月日</param> /// <returns>返回DataTable HID, SYSTYPEVALUE, REPORTTIME, HNAME,ORGNAME,ORGNO</returns> public static DataTable getDTByOrgHUse(T_IPSCOL_COLLECT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT a.HID, a.SYSTYPEVALUE, a.COLLECTTIME, b.HNAME,c.ORGNAME,c.ORGNO"); sb.AppendFormat(" FROM T_IPSCOL_COLLECTDATA a "); sb.AppendFormat(" left outer join T_IPSFR_USER b on a.hid=b.hid"); sb.AppendFormat(" left outer join T_SYS_ORG c on b.BYORGNO=c.ORGNO"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.TopORGNO) == false) { if (sw.TopORGNO.Substring(4, 5) == "00000")//获取所有市的 { sb.AppendFormat(" AND SUBSTRING(ORGNO,1,4) = '{0}'", ClsSql.EncodeSql(sw.TopORGNO.Substring(0, 4))); } else if (sw.TopORGNO.Substring(6, 3) == "000")//获取所有县的 { sb.AppendFormat(" AND SUBSTRING(ORGNO,1,6) = '{0}'", ClsSql.EncodeSql(sw.TopORGNO.Substring(0, 6))); } else { sb.AppendFormat(" AND ORGNO = '{0}'", ClsSql.EncodeSql(sw.TopORGNO)); } } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND COLLECTTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND COLLECTTIME<='{0} 23:59:59'", sw.DateEnd); } DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 根据ID获取明细 /// </summary> /// <param name="sw">sw.COLLECTID</param> /// <returns>参见模型T_IPSCOL_COLLECT_Model</returns> public static IEnumerable <T_IPSCOL_COLLECT_Model> getDetailModelList(T_IPSCOL_COLLECT_SW sw) { var result = new List <T_IPSCOL_COLLECT_Model>(); DataTable dt = BaseDT.T_IPSCOL_COLLECT.getDetailDT(new T_IPSCOL_COLLECT_SW { COLLECTID = sw.COLLECTID }); for (int i = 0; i < dt.Rows.Count; i++) { T_IPSCOL_COLLECT_Model m = new T_IPSCOL_COLLECT_Model(); m.COLLECTDETAILID = dt.Rows[i]["COLLECTDETAILID"].ToString(); m.COLLECTID = dt.Rows[i]["COLLECTID"].ToString(); m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString(); m.ORILONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); //原始经度 m.ORILATITUDE = dt.Rows[i]["LATITUDE"].ToString(); //原始纬度 //******************计算坐标偏移量 if (sw.MapType != "Skyline") { 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.DIRECTION = dt.Rows[i]["DIRECTION"].ToString(); m.COLLECTTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["COLLECTTIME"].ToString()); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 采集管理 /// </summary> /// <returns>参见模型</returns> public JsonResult SaveCollectDataAjax() { string cid = Request.Params["cid"]; string describe = Request.Params["describe"]; string result = Request.Params["result"]; string typeid = Request.Params["typeid"]; string state = Request.Params["state"]; if (string.IsNullOrEmpty(cid)) { return(Json(new Message(false, "cid参数传递失败", ""))); } var m = new T_IPSCOL_COLLECT_Model(); m.opMethod = "Man"; m.COLLECTID = cid; m.MANUSERID = SystemCls.getUserID(); m.MANRESULT = result; m.COLLECTNAME = describe; var ms = T_IPSCOL_COLLECTCls.Manager(m); var sde = System.Configuration.ConfigurationManager.AppSettings["IsInsertSDE"].ToString(); if (sde == "1") { #region 空间数据库 //空间数据库处理 if (state != "1") //1表示已处理 { if (typeid != "3") //非线类型 { T_IPSCOL_COLLECT_SW sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var reocrdlist = T_IPSCOL_COLLECTCls.getDetailModelList(sw); if (reocrdlist.Any()) { var point = reocrdlist.OrderByDescending(p => p.COLLECTTIME).FirstOrDefault(); T_COLLECTPOINTS_Model pointmodel = new T_COLLECTPOINTS_Model();//点 pointmodel.TypeId = Convert.ToInt32(typeid); pointmodel.NAME = m.COLLECTNAME; //POINT (117.14508056640625 31.764892578125) //geometry::STGeomFromText('POINT(103.397553 23.365441)',4326) pointmodel.Shape = " POINT (" + point.LONGITUDE + " " + point.LATITUDE + ")"; pointmodel.opMethod = "ADD"; T_COLLECTPOINTSCls.Manager(pointmodel); } } else//线 { T_IPSCOL_COLLECT_SW sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var reocrdlist = T_IPSCOL_COLLECTCls.getDetailModelList(sw); if (reocrdlist.Any()) { string line = ""; int i = 0; foreach (var item in reocrdlist) { if (i == reocrdlist.Count() - 1)//最后一条记录 { line += item.LONGITUDE + " " + item.LATITUDE; } else { line += item.LONGITUDE + " " + item.LATITUDE + ","; } i++; } T_COLLECTLINES_Model linemodel = new T_COLLECTLINES_Model();//线 linemodel.TypeId = Convert.ToInt32(typeid); linemodel.NAME = m.COLLECTNAME; //LINESTRING (116.9428721060001 31.786694108000063, 117.22840742700009 31.74386381000005) //geometry::STGeomFromText() linemodel.Shape = "geometry::STGeomFromText('LINESTRING (" + line + ")',4326)"; linemodel.opMethod = "ADD"; T_COLLECTLINESCls.Manager(linemodel); } } } #endregion } return(Json(ms)); }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(T_IPSCOL_COLLECT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT COLLECTID, HID, SYSTYPEVALUE, ADDRESS, COLLECTTIME, COLLECTNAME, MANSTATE, MANRESULT, MANTIME, MANUSERID"); sb.AppendFormat(" FROM T_IPSCOL_COLLECTDATA"); sb.AppendFormat(" WHERE 1=1"); //判断是否是多少,如果是多少,用in,如果只是一个,用= 主要考虑到速度 if (string.IsNullOrEmpty(sw.COLLECTID) == false) { if (sw.COLLECTID.Split(',').Length > 1) { sb.AppendFormat(" AND COLLECTID in({0})", ClsSql.EncodeSql(sw.COLLECTID)); } else { sb.AppendFormat(" AND COLLECTID ='{0}'", ClsSql.EncodeSql(sw.COLLECTID)); } } if (string.IsNullOrEmpty(sw.SYSTYPEVALUE) == false) { sb.AppendFormat(" AND SYSTYPEVALUE ='{0}'", ClsSql.EncodeSql(sw.SYSTYPEVALUE)); } if (string.IsNullOrEmpty(sw.MANSTATE) == false) { sb.AppendFormat(" AND MANSTATE ='{0}'", ClsSql.EncodeSql(sw.MANSTATE)); } //根据护林员ID查询 if (string.IsNullOrEmpty(sw.HID) == false) { sb.AppendFormat(" AND HID ='{0}'", ClsSql.EncodeSql(sw.HID)); } if (string.IsNullOrEmpty(sw.orgNo) == false) { if (sw.orgNo.Substring(4, 5) == "00000")//获取所有县的 { sb.AppendFormat(" AND HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO like '{0}%')", ClsSql.EncodeSql(sw.orgNo.Substring(0, 4))); } else if (sw.orgNo.Substring(6, 3) == "000")//获取所有市的 { sb.AppendFormat(" AND HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO like '{0}%')", ClsSql.EncodeSql(sw.orgNo.Substring(0, 6))); } else { sb.AppendFormat(" AND HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO = '{0}')", ClsSql.EncodeSql(sw.orgNo)); } } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND COLLECTTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND COLLECTTIME<='{0} 23:59:59'", sw.DateEnd); } sb.AppendFormat(" ORDER BY COLLECTTIME DESC "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 采集数据统计 /// </summary> /// <param name="sw">参见模型 sw.TopORGNO 顶级单位编码 sw.DateBegin 开始日期 年月日 sw.DateEnd 结束日期 年月日</param> /// <param name="typeModel">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <T_IPSCOL_COLLECT_OrgCountModel> getModelCount(T_IPSCOL_COLLECT_SW sw, out IEnumerable <T_IPSCOL_COLLECT_TypeCountModel> typeModel) { var result = new List <T_IPSCOL_COLLECT_OrgCountModel>(); //获取采集信息 DataTable dt = BaseDT.T_IPSCOL_COLLECT.getDTByOrgHUse(sw); //获取单位 T_SYS_ORGSW swOrg = new T_SYS_ORGSW(); swOrg.SYSFLAG = ConfigCls.getSystemFlag(); swOrg.TopORGNO = sw.TopORGNO; if (PublicCls.OrgIsShi(sw.TopORGNO)) { swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县 } if (PublicCls.OrgIsXian(sw.TopORGNO)) { swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇 } DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg); //采集类别 DataTable dtReportType = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "4" }); //采集类别 //out 类别 var resultReportType = new List <T_IPSCOL_COLLECT_TypeCountModel>(); for (int i = 0; i < dtReportType.Rows.Count; i++) { T_IPSCOL_COLLECT_TypeCountModel m = new T_IPSCOL_COLLECT_TypeCountModel(); m.typeName = dtReportType.Rows[i]["DICTNAME"].ToString(); resultReportType.Add(m); } typeModel = resultReportType; if (1 == 1) { T_IPSCOL_COLLECT_OrgCountModel m = new T_IPSCOL_COLLECT_OrgCountModel(); m.HName = BaseDT.T_SYS_ORG.getName(sw.TopORGNO) + "合计"; m.ORGName = m.HName; m.CollectCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, "");//总数 var typeResult = new List <T_IPSCOL_COLLECT_TypeCountModel>(); //循环类别 for (int k = 0; k < dtReportType.Rows.Count; k++) { T_IPSCOL_COLLECT_TypeCountModel mm = new T_IPSCOL_COLLECT_TypeCountModel(); mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString(); mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString(); mm.typeCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, mm.typeID);//分类别统计 typeResult.Add(mm); } m.TypeCountModel = typeResult; result.Add(m); } if (PublicCls.OrgIsZhen(sw.TopORGNO) == false) { //循环单位 for (int i = 0; i < dtOrg.Rows.Count; i++) { T_IPSCOL_COLLECT_OrgCountModel m = new T_IPSCOL_COLLECT_OrgCountModel(); m.ORGName = dtOrg.Rows[i]["ORGNAME"].ToString(); m.ORGNo = dtOrg.Rows[i]["ORGNO"].ToString(); //m.HID = dt.Rows[i]["HID"].ToString(); m.CollectCount = BaseDT.T_IPSCOL_COLLECT.getCountByOrgHUse(dt, m.ORGNo, "");//总数 var typeResult = new List <T_IPSCOL_COLLECT_TypeCountModel>(); //循环类别 for (int k = 0; k < dtReportType.Rows.Count; k++) { T_IPSCOL_COLLECT_TypeCountModel mm = new T_IPSCOL_COLLECT_TypeCountModel(); mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString(); mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString(); mm.typeCount = BaseDT.T_IPSCOL_COLLECT.getCountByOrgHUse(dt, m.ORGNo, mm.typeID);//分类别统计 typeResult.Add(mm); } m.TypeCountModel = typeResult; result.Add(m); } } else//if (PublicCls.OrgIsZhen(sw.TopORGNO))//如果查询的单位为镇,显示所有护林员的统计信息 { DataTable dtHUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = sw.TopORGNO }); for (int i = 0; i < dtHUser.Rows.Count; i++) { T_IPSCOL_COLLECT_OrgCountModel m = new T_IPSCOL_COLLECT_OrgCountModel(); m.HID = dtHUser.Rows[i]["HID"].ToString(); m.HName = dtHUser.Rows[i]["HNAME"].ToString(); m.CollectCount = BaseDT.T_IPSCOL_COLLECT.getCountByHID(dt, m.HID, "");//总数 var typeResult = new List <T_IPSCOL_COLLECT_TypeCountModel>(); //循环类别 for (int k = 0; k < dtReportType.Rows.Count; k++) { T_IPSCOL_COLLECT_TypeCountModel mm = new T_IPSCOL_COLLECT_TypeCountModel(); mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString(); mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString(); mm.typeCount = BaseDT.T_IPSCOL_COLLECT.getCountByHID(dt, m.HID, mm.typeID);//分类别统计 typeResult.Add(mm); } m.TypeCountModel = typeResult; result.Add(m); } dtHUser.Clear(); dtHUser.Dispose(); } dt.Clear(); dt.Dispose(); dtOrg.Clear(); dtOrg.Dispose(); dtReportType.Clear(); dtReportType.Dispose(); return(result); }
/// <summary> /// 获取多条数据 /// </summary> /// <example> /// sw.orgNo 机构编码,用于获取该机构编码下所有的采集信息 /// sw.MANSTATE 处理状态 0未处理1已处理 /// sw.DateBegin 开始日期 /// sw.DateEnd 结束日期 /// </example> /// <param name="sw">参见条件模型T_IPSCOL_COLLECT_SW</param> /// <returns>参见模型T_IPSCOL_COLLECT_Model</returns> public static IEnumerable <T_IPSCOL_COLLECT_Model> getModelList(T_IPSCOL_COLLECT_SW sw) { DataTable dtHRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = sw.orgNo }); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { }); DataTable dtCollectType = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTFLAG = "数据采集" }); var result = new List <T_IPSCOL_COLLECT_Model>(); DataTable dt = null; if (sw.UnionHUser) { dt = BaseDT.T_IPSCOL_COLLECT.getDtUnionHUser(sw); //关联护林员表 } else { dt = BaseDT.T_IPSCOL_COLLECT.getDT(sw); } string IDList = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (i > 0) { IDList += ","; } IDList += dt.Rows[i]["COLLECTID"].ToString(); } DataTable dtDetail = BaseDT.T_IPSCOL_COLLECT.getDetailDT(new T_IPSCOL_COLLECT_SW { COLLECTID = IDList }); DataTable dtUpload = BaseDT.T_IPSCOL_COLLECT.getUploadDT(new T_IPSCOL_COLLECT_SW { COLLECTID = IDList }); //var userid = SystemCls.getUserID(); //var rightsw = new T_SYSSEC_IPSUSER_SW(); //rightsw.USERID = userid; for (int i = 0; i < dt.Rows.Count; i++) { T_IPSCOL_COLLECT_Model m = new T_IPSCOL_COLLECT_Model(); m.HID = dt.Rows[i]["HID"].ToString(); m.COLLECTID = dt.Rows[i]["COLLECTID"].ToString(); m.SYSTYPEVALUE = dt.Rows[i]["SYSTYPEVALUE"].ToString(); m.SYSTYPEName = BaseDT.T_SYS_DICT.getName(dtCollectType, m.SYSTYPEVALUE); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.COLLECTTIME = ClsSwitch.SwitTM(dt.Rows[i]["COLLECTTIME"].ToString()); m.COLLECTNAME = dt.Rows[i]["COLLECTNAME"].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(); DataRow[] drDetail = dtDetail.Select("COLLECTID='" + m.COLLECTID + "'", "COLLECTTIME"); if (drDetail.Length > 0) { m.COLLECTDETAILID = drDetail[0]["COLLECTDETAILID"].ToString(); m.LONGITUDE = drDetail[0]["LONGITUDE"].ToString(); m.LATITUDE = drDetail[0]["LATITUDE"].ToString(); if (sw.MapType != "Skyline") { //******************计算坐标偏移量 string[] arr = PublicCls.switJWD(m.LATITUDE, m.LONGITUDE); m.LATITUDE = arr[0]; m.LONGITUDE = arr[1]; //******************计算坐标偏移量 End } m.HEIGHT = drDetail[0]["HEIGHT"].ToString(); m.DIRECTION = drDetail[0]["DIRECTION"].ToString(); // m.COLLECTTIME = ClsSwitch.SwitTM(drDetail[0]["COLLECTTIME"].ToString()); } DataRow[] drUpload = dtUpload.Select("COLLECTID='" + m.COLLECTID + "'", "COLLECTUPLOADID"); if (drUpload.Length > 0) { m.COLLECTUPLOADID = drUpload[0]["COLLECTUPLOADID"].ToString(); m.UPLOADURL = drUpload[0]["UPLOADURL"].ToString(); m.UPLOADNAME = drUpload[0]["UPLOADNAME"].ToString(); m.UPLOADDESCRIBE = drUpload[0]["UPLOADDESCRIBE"].ToString(); } DataRow[] drHRUser = dtHRUser.Select("HID='" + m.HID + "'"); if (drHRUser.Length > 0) { m.OrgNoName = drHRUser[0]["ORGNAME"].ToString(); m.HName = drHRUser[0]["HNAME"].ToString(); m.Phone = drHRUser[0]["PHONE"].ToString(); m.OrgNo = drHRUser[0]["BYORGNO"].ToString(); m.Phone = drHRUser[0]["PHONE"].ToString(); } if (!string.IsNullOrEmpty(m.MANUSERID)) { DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'"); if (drUser.Length > 0) { m.ManUserName = drUser[0]["USERNAME"].ToString(); } } //权限获取 //m.Rights = T_SYSSEC_RIGHTCls.getRightStrByUID(rightsw); result.Add(m); } dtUser.Clear(); dtUser.Dispose(); dtHRUser.Clear(); dtHRUser.Dispose(); dtDetail.Clear(); dtDetail.Dispose(); dtUpload.Clear(); dtUpload.Dispose(); dtCollectType.Clear(); dtCollectType.Dispose(); dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 转换为护林员巡检线和责任区 /// </summary> /// <returns></returns> public JsonResult ConvertHlyLineArea() { Message msg = new Message(false, "转化失败!", ""); string cid = Request.Params["cid"]; //采集id string hid = Request.Params["hid"]; //护林员id string htype = Request.Params["htype"]; //护林员转换类型 0 表是线 1 表示面 var sw = new T_IPSCOL_COLLECT_SW(); sw.COLLECTID = cid; var list = T_IPSCOL_COLLECTCls.getDetailModelList(sw); if (list.Any()) { string pointstr = string.Empty; int j = 0; string str = string.Empty; foreach (var item in list) { if (htype == "1")//面 特殊处理 { if (j == 0) { str = item.LONGITUDE + "," + item.LATITUDE + "|"; } } //pointstr += item.ORILONGITUDE + "," + item.ORILATITUDE + ",,|"; pointstr += item.LONGITUDE + "," + item.LATITUDE + "|"; j++; } pointstr += str; var m = new T_IPSFR_ROUTERAIL_Model();//巡检线和责任区 m.HID = hid; m.longitLatitList = pointstr; m.longitLatitList = m.longitLatitList.Replace("|", ", , |"); m.longitLatitList = m.longitLatitList + ";"; m.opMethod = "AddBatch"; m.ROADTYPE = htype; var ms = T_IPSFR_ROUTERAILCls.Manager(m); if (ms.Success) { string jd = ""; string wd = ""; string line = ""; string polygon = ""; //入三维空间库 #region 责任线 if (htype == "0") { m.longitLatitList = m.longitLatitList.Substring(0, m.longitLatitList.LastIndexOf(";")); m.longitLatitList = m.longitLatitList.Replace(",,", ""); if (!string.IsNullOrEmpty(m.longitLatitList)) { var result = T_IPSFR_USERCls.getListModel(new T_IPSFR_USER_SW { HID = hid }).FirstOrDefault(); //获取护林员信息 var m1 = new TD_DUTYROUTE_Model(); //三维责任路线模型 m1.opMethod = m.opMethod; m1.NAME = result.HNAME; m1.OBJECTID = result.HID; m1.ORGNAME = result.ORGNAME; m1.TELEPHONE = result.PHONE; string[] arr = m.longitLatitList.Split('|'); for (int i = 0; i < arr.Length; i++) { if (!string.IsNullOrEmpty(arr[i])) { string[] brr = arr[i].Split(','); double[] drr = ClsPositionTrans.GpsTransform(double.Parse(brr[1]), double.Parse(brr[0]), ConfigCls.getSDELonLatTransform());//坐标系转换 wd = drr[0].ToString(); jd = drr[1].ToString(); } if (i == arr.Length - 1)//最后一条记录 { line += jd + " " + wd; } else { line += jd + " " + wd + ","; } } #region 中心点获取 if (arr.Length % 2 == 0) { string[] crr = arr[arr.Length / 2].Split(','); double[] drr = ClsPositionTrans.GpsTransform(double.Parse(crr[1]), double.Parse(crr[0]), ConfigCls.getSDELonLatTransform()); m1.DISPLAY_X = drr[1].ToString(); m1.DISPLAY_Y = drr[0].ToString(); } else { string[] crr = arr[(arr.Length + 1) / 2].Split(','); double[] drr = ClsPositionTrans.GpsTransform(double.Parse(crr[1]), double.Parse(crr[0]), ConfigCls.getSDELonLatTransform());//中心点偏移 m1.DISPLAY_X = drr[1].ToString(); m1.DISPLAY_Y = drr[0].ToString(); } #endregion m1.Shape = "geometry::STGeomFromText('LINESTRING(" + line + ")',4326).MakeValid()"; DC_DUTYROUTECls.Manager(m1); } } #endregion #region 责任面 else { m.longitLatitList = m.longitLatitList.Substring(0, m.longitLatitList.LastIndexOf(";")); m.longitLatitList = m.longitLatitList.Replace(",,", ""); if (!string.IsNullOrEmpty(m.longitLatitList)) { var result = T_IPSFR_USERCls.getListModel(new T_IPSFR_USER_SW { HID = hid }).FirstOrDefault(); //获取护林员信息 var m2 = new TD_DUTYAREA_Model(); //三维责任区模型 m2.opMethod = m.opMethod; m2.NAME = result.HNAME; m2.OBJECTID = result.HID; m2.ORGNAME = result.ORGNAME; m2.TELEPHONE = result.PHONE; string[] arr = m.longitLatitList.Split('|'); for (int i = 0; i < arr.Length; i++) { if (!string.IsNullOrEmpty(arr[i])) { string[] brr = arr[i].Split(','); double[] drr = ClsPositionTrans.GpsTransform(double.Parse(brr[1]), double.Parse(brr[0]), ConfigCls.getSDELonLatTransform());//坐标系转换 wd = drr[0].ToString(); jd = drr[1].ToString(); } if (i == arr.Length - 1)//最后一条记录 { polygon += jd + " " + wd; } else { polygon += jd + " " + wd + ","; } } #region 中心点获取 if (arr.Length % 2 == 0) { string[] crr = arr[arr.Length / 2].Split(','); double[] drr = ClsPositionTrans.GpsTransform(double.Parse(crr[1]), double.Parse(crr[0]), ConfigCls.getSDELonLatTransform()); m2.DISPLAY_X = drr[1].ToString(); m2.DISPLAY_Y = drr[0].ToString(); } else { string[] crr = arr[(arr.Length + 1) / 2].Split(','); double[] drr = ClsPositionTrans.GpsTransform(double.Parse(crr[1]), double.Parse(crr[0]), ConfigCls.getSDELonLatTransform());//中心点偏移 m2.DISPLAY_X = drr[1].ToString(); m2.DISPLAY_Y = drr[0].ToString(); } #endregion m2.Shape = "geometry::STGeomFromText('Polygon((" + polygon + "))',4326).MakeValid()"; DC_DUTYAREACls.Manager(m2); } } msg = new Message(true, "转换成功!", ""); #endregion } } return(Json(msg)); }
//private string getCollectCountStr(T_IPSCOL_COLLECT_SW sw) public ActionResult getCollectCountJson() { T_IPSCOL_COLLECT_SW sw = new T_IPSCOL_COLLECT_SW(); sw.TopORGNO = Request.Params["TopORGNO"]; sw.DateBegin = Request.Params["DateBegin"]; sw.DateEnd = Request.Params["DateEnd"]; IEnumerable <T_IPSCOL_COLLECT_TypeCountModel> typeModel; var list = T_IPSCOL_COLLECTCls.getModelCount(sw, out typeModel); StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table id=\"tb\" cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr>"); sb.AppendFormat(" <th>单位/姓名</th>"); sb.AppendFormat(" <th>总数</th>"); foreach (var v in typeModel) { sb.AppendFormat(" <th>{0}</th>", v.typeName); } sb.AppendFormat(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); int i = 0; foreach (var v in list) { i++; if (i % 2 == 0) { sb.AppendFormat("<tr>"); } else { sb.AppendFormat("<tr class='row1'>"); } if (string.IsNullOrEmpty(v.ORGNo)) { sb.AppendFormat("<td class=\"center\" style=\"{1}\">{0}</td>", v.HName, ""); } else { sb.AppendFormat("<td class=\"center\" style=\"{1}\">{0}</td>", v.ORGName, ""); } sb.AppendFormat("<td class=\"center\">{0}</td>", v.CollectCount);//总 var vvList = v.TypeCountModel; foreach (var vv in vvList) { //if (string.IsNullOrEmpty(v.HID)) sb.AppendFormat("<td class=\"center\">{0}</td>", vv.typeCount); //else //{ // if (vv.typeCount == "0") // sb.AppendFormat("<td class=\"center\">{0}</td>", vv.typeCount); // else // sb.AppendFormat("<td class=\"center\"><a href='/HUReport/CollectCount?trans={1}'>{0}</a></td>" // , vv.typeCount, ClsStr.EncryptA01(sw.TopORGNO + "|" + sw.DateBegin + "|" + sw.DateEnd + "|" + v.HID + "|" + vv.typeID, "kkkkkkkk")); //} } sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); //return sb.ToString(); return(Content(JsonConvert.SerializeObject(new Message(true, sb.ToString(), "")), "text/html;charset=UTF-8")); }
/// <summary> /// 获取检索上报数据ListHtml /// </summary> /// <returns>参见模型</returns> public JsonResult GetCollectDataHtmlAjax() { Message ms = null; string person = Request.Params["person"]; string starttime = Request.Params["strarttime"]; string endtime = Request.Params["endtime"]; string state = Request.Params["state"]; string type = Request.Params["cid"]; string Skytype = Request.Params["type"]; StringBuilder sb = new StringBuilder(); if (Skytype == "Skyline") { 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>"); } else { 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(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); var sw = new T_IPSCOL_COLLECT_SW(); sw.DateBegin = starttime; sw.DateEnd = endtime; sw.SYSTYPEVALUE = type; sw.UnionHUser = false; if (!string.IsNullOrEmpty(person)) { sw.HUserName = person; sw.UnionHUser = true; } if (state != "2") { sw.MANSTATE = state; } var cuurorg = SystemCls.getCurUserOrgNo(); if (!string.IsNullOrEmpty(cuurorg)) { sw.orgNo = cuurorg; } var list = T_IPSCOL_COLLECTCls.getModelList(sw); if (list.Any()) { var url = System.Configuration.ConfigurationManager.AppSettings["SkylineUrl"].ToString(); var personPopurl = url + @"/SkylineManger/PersonDetailIndex"; var collectViewPopurl = url + @"/SkylineManger/DataCollectDetailViewIndex"; int i = 0; foreach (var item in list) { sb.AppendFormat("<tr>"); sb.AppendFormat("<td>{0}</td>", ++i); if (Skytype == "Skyline") { sb.AppendFormat("<td><a href=\"javascript:void(0);\" title=\"人员信息\" onclick=\"PopUrlCollect('" + personPopurl + "'," + item.HID + ")\">{0}</a></td>", item.HName); // sb.AppendFormat("<td>{0}</td>", item.PHONE); sb.AppendFormat("<td title=\"{0}\">{1}</td>", item.COLLECTTIME, Convert.ToDateTime(item.COLLECTTIME).ToString("MM-dd HH:mm")); } else { sb.AppendFormat("<td>{0}</td>", item.SYSTYPEName); sb.AppendFormat("<td>{0}</td>", item.HName); sb.AppendFormat("<td>{0}</td>", item.Phone); sb.AppendFormat("<td>{0}</td>", item.COLLECTNAME); sb.AppendFormat("<td>{0}</td>", item.COLLECTTIME); 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>"); } } //class=\"icon-flag\" if (Skytype == "Skyline") { sb.AppendFormat("<td class=\"center\"> "); sb.AppendFormat("<a href=\"javascript:void(0);\" onClick=\"getLocaCollect(" + item.COLLECTID + ")\" class=\"dw option\" title=\"展示\"></a><a href=\"javascript:void(0);\" onClick=\"getCollectView('" + collectViewPopurl + "'," + item.COLLECTID + ")\" class=\"ck option\" title=\"查看\"></a>"); //if (sw.SYSTYPEVALUE == "3") //{ // StringBuilder sb1 = new StringBuilder(); // sb1.AppendFormat("<a href=\"javascript:void(0);\" onClick=\"ConvertType(" + item.COLLECTID + "," + item.HID + ",0)\" class=\"xjx option\" title=\"转为巡检线\"></a><a href=\"javascript:void(0);\" onClick=\"ConvertType(" + item.COLLECTID + "," + item.HID + ",1)\" class=\"zrq option\" title=\"转为责任区\"></a>"); // sb.Append(sb1.ToString()); //} sb.AppendFormat("<a href=\"javascript:void(0);\" class=\"dj option\" title=\"对讲\"></a>"); sb.AppendFormat("</td>"); } else { sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"getLocaCollect(" + item.COLLECTID + ")\">定位</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)); }