using JiangSu.cs;
|
using JiangSu.Models;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web.Http;
|
|
namespace JiangSu.Controllers
|
{
|
public class GridController : ApiController
|
{
|
[HttpGet]
|
public object SelectAll()
|
{
|
try
|
{
|
List<Grid> grids = GridDAL.SelectAll();
|
List<JObject> list = GetJObjects(grids);
|
|
Dictionary<string, object> dict = GetDict();
|
dict.Add("features", list);
|
|
return dict;
|
}
|
catch (Exception ex)
|
{
|
LogOut.Error(ex.Message + "\r\n" + ex.StackTrace);
|
return null;
|
}
|
}
|
|
private Dictionary<string, object> GetDict()
|
{
|
string crs = "{ \"type\": \"name\", \"properties\": { \"name\": \"urn:ogc:def:crs:OGC:1.3:CRS84\" } }";
|
JObject crsJObj = JsonConvert.DeserializeObject<JObject>(crs);
|
|
Dictionary<string, object> dict = new Dictionary<string, object>();
|
dict.Add("type", "FeatureCollection");
|
dict.Add("name", "网格4549");
|
dict.Add("crs", crsJObj);
|
|
return dict;
|
}
|
|
private List<JObject> GetJObjects(List<Grid> grids)
|
{
|
List<JObject> list = new List<JObject>();
|
if (null != grids && grids.Count > 0)
|
{
|
foreach (Grid g in grids)
|
{
|
JObject obj = JsonConvert.DeserializeObject<JObject>(g.json);
|
list.Add(obj);
|
}
|
}
|
|
return list;
|
}
|
|
[HttpGet]
|
public object SelectById(long id)
|
{
|
try
|
{
|
Grid grid = GridDAL.SelectById(id);
|
List<JObject> list = GetJObjects(null == grid ? null : new List<Grid> { grid });
|
|
Dictionary<string, object> dict = GetDict();
|
dict.Add("features", list);
|
|
return dict;
|
}
|
catch (Exception ex)
|
{
|
LogOut.Error(ex.Message + "\r\n" + ex.StackTrace);
|
return null;
|
}
|
}
|
|
[HttpGet]
|
public int DeleteByIds([FromUri] List<int> ids)
|
{
|
try
|
{
|
if (null == ids || ids.Count == 0) return 0;
|
|
return GridDAL.DeleteByIds(ids);
|
}
|
catch (Exception ex)
|
{
|
LogOut.Error(ex.Message + "\r\n" + ex.StackTrace);
|
return 0;
|
}
|
}
|
|
[HttpGet]
|
public int DelAll()
|
{
|
try
|
{
|
return GridDAL.DelAll();
|
}
|
catch (Exception ex)
|
{
|
LogOut.Error(ex.Message + "\r\n" + ex.StackTrace);
|
return 0;
|
}
|
}
|
|
[HttpPost]
|
public int Insert([FromBody] Grid grid)
|
{
|
try
|
{
|
if (null == grid) return 0;
|
|
return GridDAL.Insert(grid);
|
}
|
catch (Exception ex)
|
{
|
LogOut.Error(ex.Message + "\r\n" + ex.StackTrace);
|
return 0;
|
}
|
}
|
|
[HttpPost]
|
public int UpdateById([FromBody] Grid grid)
|
{
|
try
|
{
|
if (null == grid) return 0;
|
|
return GridDAL.UpdateById(grid);
|
}
|
catch (Exception ex)
|
{
|
LogOut.Error(ex.Message + "\r\n" + ex.StackTrace);
|
return 0;
|
}
|
}
|
}
|
}
|
