public ActionResult AddBusSta(Station STA)
{
HYMSDTEntities context = new HYMSDTEntities();
ReturnModel1 reModel = new ReturnModel1();
reModel.status = false;
try
{
T_Station model = new T_Station();
model.Sta_Guid = Guid.NewGuid();
model.Sta_Id = STA.Sta_Id;
string wktStr = string.Format("POINT ({0})", STA.Sta_Geo);
model.Sta_Geo = GeoUtils.FromWkt("point", wktStr, 0);
model.Sta_Name = STA.Sta_Name;
context.T_Station.Add(model);
context.SaveChanges();
reModel.status = true;
}
catch (Exception ex)
{
reModel.message = ex.ToString();
}
return(Json(reModel));
}
public ActionResult AddLeisureTourism(Service SV)
{
HYMSDTEntities context = new HYMSDTEntities();
ReturnModel1 reModel = new ReturnModel1();
reModel.status = false;
try
{
T_Service model = new T_Service();
model.S_Guid = Guid.NewGuid();
model.S_Address = SV.S_Address;
model.S_Cost = SV.S_Cost;
model.S_Introduce = SV.S_Introduce;
model.S_Name = SV.S_Name;
model.S_PhotoList = SV.S_PhotoList;
model.S_QH = SV.S_QH;
model.S_Star = SV.S_Star;
model.S_Type = SV.S_Type;
//转WKT
string wktStr = string.Format("POINT ({0})", SV.S_Geo);
model.S_Geo = GeoUtils.FromWkt("point", wktStr, 0);
context.T_Service.Add(model);
context.SaveChanges();
reModel.status = true;
}
catch (Exception ex)
{
reModel.message = ex.ToString();
}
return(Json(reModel));
}
public ActionResult EditLeisureTourism(LeisureTourism LT)
{
HYMSDTEntities context = new HYMSDTEntities();
ReturnModel1 reModel = new ReturnModel1();
reModel.status = false;
try
{
var model = context.T_LeisureTourism.First(i => i.LT_Guid == LT.LT_Guid);
model.LT_Address = LT.LT_Address;
model.LT_Grade = LT.LT_Geo;
model.LT_Introduce = LT.LT_Introduce;
model.LT_Name = LT.LT_Name;
model.LT_QH = LT.LT_QH;
model.LT_Time = LT.LT_Time;
model.LT_Type = LT.LT_Type;
//转WKT
if (!string.IsNullOrEmpty(LT.LT_Geo))
{
string wktStr = string.Format("POINT ({0})", LT.LT_Geo);
model.LT_Geo = GeoUtils.FromWkt("point", wktStr, 0);
}
context.SaveChanges();
reModel.status = true;
}
catch (Exception ex)
{
reModel.message = ex.ToString();
}
return(Json(reModel));
}
public ActionResult AddLeisureTourism(LeisureTourism LT)
{
HYMSDTEntities context = new HYMSDTEntities();
ReturnModel1 reModel = new ReturnModel1();
reModel.status = false;
try
{
T_LeisureTourism model = new T_LeisureTourism();
model.LT_Guid = Guid.NewGuid();
model.LT_Address = LT.LT_Address;
model.LT_Grade = LT.LT_Grade;
model.LT_Introduce = LT.LT_Introduce;
model.LT_Name = LT.LT_Name;
//model.LT_PhotoList = LT.LT_PhotoList;
model.LT_QH = LT.LT_QH;
model.LT_Time = LT.LT_Time;
model.LT_Type = LT.LT_Type;
//转WKT
string wktStr = string.Format("POINT ({0})", LT.LT_Geo);
model.LT_Geo = GeoUtils.FromWkt("point", wktStr, 0);
context.T_LeisureTourism.Add(model);
context.SaveChanges();
reModel.status = true;
}
catch (Exception ex)
{
reModel.message = ex.ToString();
}
return(Json(reModel));
}
public ActionResult RemoveServiceById(string guid)
{
HYMSDTEntities context = new HYMSDTEntities();
ReturnModel1 reModel = new ReturnModel1();
reModel.status = false;
try
{
Guid Id = new Guid(guid);
var obj = context.T_Service.First(i => i.S_Guid == Id);
context.T_Service.Remove(obj);
context.SaveChanges();
reModel.status = true;
}
catch (Exception ex)
{
reModel.message = ex.ToString();
}
return(Json(reModel));
}
public ActionResult EditService(Service SV)
{
HYMSDTEntities context = new HYMSDTEntities();
ReturnModel1 reModel = new ReturnModel1();
reModel.status = false;
try
{
var model = context.T_Service.First(i => i.S_Guid == SV.S_Guid);
model.S_Address = SV.S_Address;
model.S_Cost = SV.S_Cost;
model.S_Introduce = SV.S_Introduce;
model.S_Name = SV.S_Name;
//model.S_PhotoList = SV.S_PhotoList;
model.S_QH = SV.S_QH;
model.S_Star = SV.S_Star;
model.S_Type = SV.S_Type;
//转WKT
if (!string.IsNullOrEmpty(SV.S_Geo))
{
string wktStr = string.Format("POINT ({0})", SV.S_Geo);
model.S_Geo = GeoUtils.FromWkt("point", wktStr, 0);
}
context.SaveChanges();
reModel.status = true;
}
catch (Exception ex)
{
reModel.message = ex.ToString();
}
return(Json(reModel));
}
