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