/// <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, "编辑采集点传递失败", ""))); } }