/// <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="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Man(T_IPSCOL_COLLECT_Model m)
{
if (string.IsNullOrEmpty(m.COLLECTID))
{
return(new Message(false, "修改失败，请选择要处理的记录！", ""));
}
StringBuilder sb = new StringBuilder();
//(ORGNO,LOGINUSERNAME,USERNAME,USERPWD,REGISTERTIME,LOGINNUM,NOTE)
sb.AppendFormat("UPDATE T_IPSCOL_COLLECTDATA");
sb.AppendFormat(" set ");
sb.AppendFormat(" COLLECTNAME='{0}'", ClsSql.EncodeSql(m.COLLECTNAME));
sb.AppendFormat(" ,MANSTATE='{0}'", "1");
sb.AppendFormat(" ,MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT));
sb.AppendFormat(" ,MANTIME='{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.AppendFormat(" ,MANUSERID='{0}'", SystemCls.getUserID());
sb.AppendFormat(" where COLLECTID= '{0}'", ClsSql.EncodeSql(m.COLLECTID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "处理成功！", ""));
}
else
{
return(new Message(false, "处理失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 删除、处理
/// </summary>
/// <param name="m">参见模型T_IPSCOL_COLLECT_Model</param>
/// <returns>参见模型Message</returns>
public static Message Manager(T_IPSCOL_COLLECT_Model m)
{
if (m.opMethod == "Del")
{
SystemCls.LogSave("5", "采集删除序号:" + m.COLLECTID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.T_IPSCOL_COLLECT.Del(new T_IPSCOL_COLLECT_SW {
COLLECTID = m.COLLECTID
});
return(new Message(msgUser.Success, msgUser.Msg, ""));
}
if (m.opMethod == "DelDetail")
{
SystemCls.LogSave("5", "采集明细删除序号:" + m.COLLECTDETAILID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.T_IPSCOL_COLLECT.DelDetail(new T_IPSCOL_COLLECT_SW {
COLLECTDETAILID = m.COLLECTDETAILID
});
return(new Message(msgUser.Success, msgUser.Msg, ""));
}
if (m.opMethod == "ModifyDetail")
{
SystemCls.LogSave("9", "数据采集坐标点修改" + m.COLLECTID, ClsStr.getModelContent(m));
Message msg = BaseDT.T_IPSCOL_COLLECT.DelDetail(new T_IPSCOL_COLLECT_SW {
COLLECTID = m.COLLECTID
});
if (msg.Success == true)
{
Message msgUser = null;
foreach (var item in m.DataList)
{
msgUser = BaseDT.T_IPSCOL_COLLECT.AddDetail(item);
}
return(new Message(msgUser.Success, "数据采集坐标点修改成功！", ""));
}
return(new Message(msg.Success, "数据采集坐标点修改失败！", ""));
}
if (m.opMethod == "DelUpload")
{
SystemCls.LogSave("5", "采集文件删除序号:" + m.COLLECTUPLOADID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.T_IPSCOL_COLLECT.DelUpload(new T_IPSCOL_COLLECT_SW {
COLLECTUPLOADID = m.COLLECTUPLOADID
});
return(new Message(msgUser.Success, msgUser.Msg, ""));
}
if (m.opMethod == "Man")
{
SystemCls.LogSave("4", "采集处理:" + m.COLLECTDETAILID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.T_IPSCOL_COLLECT.Man(m);
return(new Message(msgUser.Success, msgUser.Msg, ""));
}
return(new Message(false, "无效操作", ""));
}
/// <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>
/// 删除采集数据
/// </summary>
/// <returns>参见模型</returns>
public JsonResult DeleteCollectDataAjax()
{
string cid = Request.Params["cid"];
if (string.IsNullOrEmpty(cid))
{
return(Json(new Message(false, "cid参数传递失败", "")));
}
var m = new T_IPSCOL_COLLECT_Model();
m.opMethod = "Del";
m.COLLECTID = cid;
m.MANUSERID = SystemCls.getUserID();
var ms = T_IPSCOL_COLLECTCls.Manager(m);
return(Json(ms));
}
/// <summary>
/// 修改采集点
/// </summary>
/// <returns>参见模型</returns>
public JsonResult ModifyCollectDataDetailAjax()
{
string editid = Request.Params["editid"];//编辑采集点id
if (string.IsNullOrEmpty(editid))
{
return(Json(new Message(false, "editid参数传递失败", "")));
}
string txt = Request.Params["edittxt"];//修改的点
string[] strList = txt.Split('|');
if (strList.Any())
{
var m = new T_IPSCOL_COLLECT_Model();
m.opMethod = "ModifyDetail";
m.COLLECTID = editid;//采集点
var detailList = new List <T_IPSCOL_COLLECTDETAIL_SW>();
foreach (var item in strList)
{
if (!string.IsNullOrEmpty(item))//不为空
{
var detail = new T_IPSCOL_COLLECTDETAIL_SW();
var lonlat = item.Split(',');
detail.COLLECTID = editid; //采集点
detail.LON = lonlat[0]; //经度
detail.LAT = lonlat[1]; //纬度
detail.COLLECTTIME = DateTime.Now.ToString(); //采集时间
detailList.Add(detail);
}
}
m.DataList = detailList;
var ms = T_IPSCOL_COLLECTCls.Manager(m);
return(Json(ms));
}
else
{
return(Json(new Message(false, "编辑采集点传递失败", "")));
}
}
/// <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>
/// <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 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));
}
