public JsonResult Delete(string id)
{
if (!string.IsNullOrWhiteSpace(id))
{
string usid = LoginUser.User.UserName;
gis_layerDefine m = new gis_layerDefine()
{
ID = int.Parse(id)
};
CommandResult r = DeleteObj <gis_layerDefine>(m);
// if (m_BLL.Delete(ref errors, id))
if (r.IntResult > 0)
{
LogHandler.WriteServiceLog(usid, "Id:" + id, "成功", "删除", "图层定义");
return(Json(JsonHandler.CreateMessage(1, Suggestion.DeleteSucceed)));
}
else
{
string ErrorCol = r.Message;
LogHandler.WriteServiceLog(usid, "Id" + id + "," + ErrorCol, "失败", "删除", "图层定义");
return(Json(JsonHandler.CreateMessage(0, Suggestion.DeleteFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.DeleteFail)));
}
}
public ActionResult Details(string id)
{
ViewBag.Perm = GetPermission();
gis_layerDefine entity = GetObjByID <gis_layerDefine>(id);
return(View(entity));
}
public JsonResult CreateXY(GIS_BASEMAP model)
{
if (model != null && ModelState.IsValid)
{
LoginInfo _login = LoginUser;
GIS_BASEMAP obj = null;
obj = GetObjByID <GIS_BASEMAP>(model.LayerID.ToString(), null, "LayerID");
if (obj != null)
{
obj.LayerCode = model.LayerCode;
obj.LAYERNAME = model.LAYERNAME;
obj.DSOURCE = model.DSOURCE;
obj.SERVICEURL = model.SERVICEURL;
obj.SERVICEINDEX = model.SERVICEINDEX;
obj.EDITBY = _login.User.UserName;
obj.EDITON = DateTime.Now;
}
else
{
obj = new GIS_BASEMAP();
gis_layerDefine _layer = GetObjByID <gis_layerDefine>(model.LayerID.ToString());
obj.LayerCode = _layer.LAYERCODE;
obj.LAYERNAME = _layer.LAYERNAME;
obj.DSOURCE = _layer.DSOURCE;
obj.SERVICEURL = _layer.SERVICEURL;
obj.SERVICEINDEX = _layer.SERVICEINDEX;
obj.ADDBY = _login.User.UserName;
}
obj.LayerID = model.LayerID;
obj.XMAX = model.XMAX;
obj.YMAX = model.YMAX;
obj.XMIN = model.XMIN;
obj.YMIN = model.YMIN;
obj.COORSYS = model.COORSYS;
obj.YEAR = model.YEAR;
CommandResult r = SaveObj <GIS_BASEMAP>(obj);
if (r.IntResult > 0)
{
LogHandler.WriteServiceLog(GetUserName(), "Id" + model.ID + ",Name" + model.LAYERNAME, "成功", "修改", "图层范围设置");
return(Json(JsonHandler.CreateMessage(1, Suggestion.EditSucceed)));
}
else
{
string ErrorCol = r.Message;
LogHandler.WriteServiceLog(GetUserName(), "Id" + model.ID + ",Name" + model.LAYERNAME + "," + ErrorCol, "失败", "修改", "图层范围设置");
return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail)));
}
}
public string inserintolayer(string logininfo, List <Glayer> layers)
{
LoginInfo _login = (LoginInfo)(Session["loginuser"]);
if (_login == null)
{
_login = LoginInfo.Parse <LoginInfo>(logininfo);
}
if (_login != null)
{
EntityProviderOP <gis_layerDefine> _op = new EntityProviderOP <gis_layerDefine>(_login, DataProvider.GetEAP_Provider());
try
{
foreach (Glayer g in layers)
{
gis_layerDefine l = null;
SearchCriteria _search = new SearchCriteria("GIS_LAYERDEFINE");
//LAYERCODENEW是精确查询
_search["LAYERCODENEW"] = g.ename;
SearchResult <gis_layerDefine> _rs = _op.Search(_search);
//有则修改，没有新增
if (_rs.Items.Count > 0)
{
l = _rs.Items[0];
l.EDITBY = _login.User.UserName;
}
else
{
l = new gis_layerDefine();
l.ADDBY = _login.User.UserName;
}
l.LAYERCODE = g.ename;
l.LAYERNAME = g.cname;
int _dt = 0;
int.TryParse(g.datatype, out _dt);
l.DATATYPE = _dt;
int _st = 0;
int.TryParse(g.shptype, out _st);
l.SHPTYPE = _st;
int k = _op.Save(l);
}
return("1");
}
catch (Exception ee)
{
return("0");
}
}
return("0");
}
public ActionResult Edit(string id)
{
ViewBag.Perm = GetPermission();
gis_layerDefine entity = GetObjByID <gis_layerDefine>(id);
ViewBag.shptypelist = initlist(1, entity.SHPTYPE.ToString());
ViewBag.datatypelist = initlist(2, entity.DATATYPE.ToString());
ViewBag.layertypelist = initlist(3, entity.LAYERTYPE.ToString());
//SysRoleModel entity = m_BLL.GetById(id);
ViewBag.specShowModelist = initlist(10, entity.SpecShowMode.ToString(), entity.SpecDS);
ViewBag.specGroupFNlist = initlist(11, entity.SpecGroupFN, entity.SpecDS);
ViewBag.specStatModeList = initlist(12, entity.SpecStatMode.ToString(), entity.SpecDS);
ViewBag.SpecStatFNlist = initlist(13, entity.SpecStatFN, entity.SpecDS);
return(View(entity));
}
public ActionResult Create()
{
ViewBag.Perm = GetPermission();
ViewBag.shptypelist = initlist(1);
ViewBag.datatypelist = initlist(2);
ViewBag.layertypelist = initlist(3);
//ViewBag.specShowModelist= initlist(10);
//ViewBag.specGroupFNlist = initlist(11);
//ViewBag.specStatModeList = initlist(12);
//ViewBag.SpecStatFNlist = initlist(13);
gis_layerDefine m = new gis_layerDefine();
return(View(m));
}
public JsonResult Edit(gis_layerDefine model)
{
if (model != null && ModelState.IsValid)
{
LoginInfo _login = LoginUser;
gis_layerDefine o = GetObjByID <gis_layerDefine>(model.ID.ToString());
o.LAYERCODE = model.LAYERCODE;
o.LAYERNAME = model.LAYERNAME;
o.LAYERTYPE = model.LAYERTYPE;
o.DATATYPE = model.DATATYPE;
o.SHPTYPE = model.SHPTYPE;
o.ISHISTORY = model.ISHISTORY;
o.DSOURCE = model.DSOURCE;
o.SERVICEURL = model.SERVICEURL;
o.SERVICEINDEX = model.SERVICEINDEX;
o.EDITBY = _login.User.UserName;
o.EDITON = DateTime.Now;
o.DataYears = model.DataYears;
o.GisDataFields = model.GisDataFields;
o.VLEVEL = model.VLEVEL;
o.SpecDS = model.SpecDS;
o.SpecGroupFN = model.SpecGroupFN;
o.SpecShowMode = model.SpecShowMode;
o.SpecStatFN = model.SpecStatFN;
o.SpecStatMode = model.SpecStatMode;
o.FEATURESERVICEURL = model.FEATURESERVICEURL;
o.FEATURESERVICEINDEX = model.FEATURESERVICEINDEX;
CommandResult r = SaveObj <gis_layerDefine>(o);
if (r.IntResult > 0)
{
LogHandler.WriteServiceLog(GetUserName(), "Id" + model.ID + ",Name" + model.LAYERNAME, "成功", "修改", "图层设置");
return(Json(JsonHandler.CreateMessage(1, Suggestion.EditSucceed)));
}
else
{
string ErrorCol = r.Message;
LogHandler.WriteServiceLog(GetUserName(), "Id" + model.ID + ",Name" + model.LAYERNAME + "," + ErrorCol, "失败", "修改", "图层设置");
return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail)));
}
}
public JsonResult GetLayerList(GridPager pager, string ClassId, string queryStr)
{
EntityProviderOP <gis_layerDefine> _op = new EntityProviderOP <gis_layerDefine>(LoginUser, DataProvider.GetEAP_Provider());
SearchCriteria _search = new SearchCriteria("GIS_LAYERDEFINE");
ToSearchCriteria(pager, ref _search);
_search["LAYERNAME"] = queryStr;
SearchResult <gis_layerDefine> _rs = _op.Search(_search);
EntityProviderOP <gis_LayerClassD> _detailop = new EntityProviderOP <gis_LayerClassD>(LoginUser, DataProvider.GetEAP_Provider());
SearchCriteria _Detailsearch = new SearchCriteria("GIS_LAYERCLASSD");
_Detailsearch.PageSize = -1;
_Detailsearch["CLASSID"] = ClassId;
SearchResult <gis_LayerClassD> _Deatilrs = _detailop.Search(_Detailsearch);
//设置图层的选中状态；
if (_Deatilrs.Items.Count > 0)
{
foreach (gis_LayerClassD o in _Deatilrs.Items)
{
gis_layerDefine obj = _rs.Items.Find((m) => { return(m.ID == o.LAYERID); });
if (obj != null)
{
obj.IsCheck_G = (obj.ID == o.LAYERID);
}
}
}
var json = new
{
total = _rs.TotalCount,
rows = _rs.Items.ToArray()
};
return(Json(json));
}
public JsonResult Create(gis_layerDefine model)
{
if (model != null && ModelState.IsValid)
{
LoginInfo _login = LoginUser;
model.ADDBY = _login.User.UserName;
CommandResult r = SaveObj <gis_layerDefine>(model);
if (r.IntResult > 0)
{
LogHandler.WriteServiceLog(_login.User.UserID.ToString(), "Id:" + model.ID + ",Name:" + model.LAYERNAME, "成功", "保存", "图层定义");
return(Json(JsonHandler.CreateMessage(1, Suggestion.Save), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = r.Message;
LogHandler.WriteServiceLog(_login.User.UserID.ToString(), "Id:" + model.ID + ",Name:" + model.LAYERNAME + "," + ErrorCol, "失败", "保存", "图层定义");
return(Json(JsonHandler.CreateMessage(0, Suggestion.SaveFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.SaveFail), JsonRequestBehavior.AllowGet));
}
}
public string inserintolayerCol(string logininfo, string layername, List <Glayercol> layerCols)
{
LoginInfo _login = (LoginInfo)(Session["loginuser"]);
if (_login == null)
{
_login = LoginInfo.Parse <LoginInfo>(logininfo);
}
if (_login != null)
{
try
{
EntityProviderOP <gis_layerDefine> _oplayer = new EntityProviderOP <gis_layerDefine>(_login, DataProvider.GetEAP_Provider());
gis_layerDefine l = null;
SearchCriteria _searchalyer = new SearchCriteria("GIS_LAYERDEFINE");
//LAYERCODENEW是精确查询
_searchalyer["LAYERCODENEW"] = layername;
SearchResult <gis_layerDefine> _rslayer = _oplayer.Search(_searchalyer);
if (_rslayer.Items.Count > 0)
{
l = _rslayer.Items[0];
}
else
{
return("01");
}
EntityProviderOP <gis_layerVersionCol> _op = new EntityProviderOP <gis_layerVersionCol>(_login, DataProvider.GetEAP_Provider());
int _ordernum = 0;
foreach (Glayercol g in layerCols)
{
_ordernum = _ordernum + 1;
gis_layerVersionCol col = null;
SearchCriteria _search = new SearchCriteria("GIS_LAYERVERSIONCOL");
_search["LAYERID"] = l.ID;
_search["COLCODE"] = g.colename;
SearchResult <gis_layerVersionCol> _rs = _op.Search(_search);
//有则修改，没有新增
if (_rs.Items.Count > 0)
{
col = _rs.Items[0];
col.EDITBY = _login.User.UserName;
}
else
{
col = new gis_layerVersionCol();
col.ADDBY = _login.User.UserName;
col.LayerID = l.ID;
}
col.COLCODE = g.colename;
col.COLNAME = g.colcname;
col.COLTYPE = g.coltype.ToString();
col.ColLen = g.colLen;
col.ColXSLen = g.colXSLen;
col.ODERNUM = _ordernum;
int k = _op.Save(col);
}
return("1");
}
catch (Exception ee)
{
return("02");
}
}
return("03");
}
