/// <summary>
/// 增加采集明细坐标
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static Message AddDetail(T_IPSCOL_COLLECTDETAIL_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("Insert into T_IPSCOL_DATADETAIL (COLLECTID,LONGITUDE,LATITUDE,COLLECTTIME) values({0},{1},{2},'{3}')", sw.COLLECTID, sw.LON, sw.LAT, sw.COLLECTTIME);
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "增加成功！", ""));
}
else
{
return(new Message(false, "增加失败！", ""));
}
}
/// <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, "编辑采集点传递失败", "")));
}
}
