/// <summary>
/// 根据对象ID、G|P|B查询对象3GX数据，3GX数据中可包含坐标信息或参数信息或两者都包含
/// </summary>
/// <param name="boid">对象ID</param>
/// <param name="category">枚举值[G|P|B]</param>
/// <returns></returns>
public System.Xml.XmlDocument Get3GXById(string boid, GGGXDataCategory category)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT T.BOID,T.NAME,T1.BOT,T1.FT FROM BO T ");
strSql.Append(" LEFT JOIN OBJECTTYPE T1 ");
strSql.Append(" ON T.BOTID=T1.BOTID ");
strSql.Append(" WHERE T.BOID =@BOID ");
SqlParameter[] parameters =
{
new SqlParameter("BOID", SqlDbType.VarChar, 36)
};
parameters[0].Value = boid;
DataTable dt = SqlServerDBHelper.GetDataTable(strSql.ToString(), parameters);
List <GeoFeature> ftList = new List <GeoFeature>();
foreach (DataRow row in dt.Rows)
{
GeoFeature ft = new GeoFeature();
ft.BOID = row["BOID"].ToString();
ft.BOT = row["BOT"].ToString();
ft.FT = row["FT"].ToString();
ft.NAME = row["NAME"].ToString();
ft.AliasNameList = Comm.GetAliasNameByBoid(ft.BOID);
if (category == GGGXDataCategory.B)
{
ft.PropertyList = Comm.GetPropertyByBoid(ft.BOID);
ft.GeometryList = Comm.GetGeometryByBoid(ft.BOID);
}
else if (category == GGGXDataCategory.P)
{
ft.PropertyList = Comm.GetPropertyByBoid(ft.BOID);
ft.GeometryList = null;
}
else if (category == GGGXDataCategory.G)
{
ft.PropertyList = null;
ft.GeometryList = Comm.GetGeometryByBoid(ft.BOID);
}
ftList.Add(ft);
}
return(GGGXParse.ConvertFT.FeatureToGGGX(ftList));
}
/// <summary>
/// 根据条件获取3GX数据
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public XmlDocument GetFeatures(FeatureFilter filter)
{
string sqlWhere = string.Empty;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT DISTINCT BO.*,OBJECTTYPE.BOT,OBJECTTYPE.FT FROM BO,OBJECTTYPE");
if (!string.IsNullOrEmpty(filter.BBox))
{
strSql.Append(",v_Geometry ");
}
if (filter.Filter != null)
{
strSql.Append(" ,PROPERTY PROPERTY ");
strSql.Append(" WHERE BO.BOTID = OBJECTTYPE.BOTID ");
strSql.Append(" AND PROPERTY.BOID = BO.BOID ");
strSql.Append(string.Format(" AND OBJECTTYPE.FT='{0}' ", filter.FT));
strSql.Append(" AND BO.BOTID=OBJECTTYPE.BOTID ");
}
else
{
strSql.Append(string.Format(" WHERE OBJECTTYPE.FT='{0}' ", filter.FT));
strSql.Append(" AND BO.BOTID=OBJECTTYPE.BOTID ");
}
//对象名称
if (filter.BOs != null && filter.BOs.Count > 0)
{
string bos = string.Empty;
for (int i = 0; i < filter.BOs.Count; i++)
{
if (i == filter.BOs.Count - 1)
{
bos += "'" + filter.BOs[i].Trim() + "'";
}
else
{
bos += "'" + filter.BOs[i].Trim() + "',";
}
}
strSql.Append(string.Format(" AND BO.NAME in {0} ", bos));
}
//空间范围和crs 未启用坐标范围
if (!string.IsNullOrEmpty(filter.BBox))
{
strSql.Append(" AND v_Geometry.BOID=BO.BOID ");
strSql.Append(string.Format(" AND ( v_Geometry.GEOMETRY.STWithin(GEOGRAPHY::STGeomFromText('{0}', 4326))=1 or ", filter.BBox));
strSql.Append(string.Format(" v_Geometry.GEOMETRY.STIntersects(GEOGRAPHY::STGeomFromText('{0}', 4326))=1 ) ", filter.BBox));
}
//属性
if (filter.Filter != null)
{
JObject jObj = JObject.Parse(filter.Filter.ToString());
string bot = SqlServerDBHelper.ExecuteQueryText <string>(string.Format("SELECT BOT FROM OBJECTTYPE WHERE FT='{0}'", filter.FT)).FirstOrDefault();
strSql.Append(" AND " + "( " + MongoJsonToSql.JsonToSql(jObj.ToString(), bot).ToString() + " )");
}
DataTable dt = SqlServerDBHelper.GetDataTable(strSql.ToString());
List <GeoFeature> ftList = new List <GeoFeature>();
foreach (DataRow row in dt.Rows)
{
GeoFeature ft = new GeoFeature();
ft.BOID = row["Boid"].ToString();
ft.BOT = row["BOT"].ToString();
ft.FT = row["FT"].ToString();
ft.NAME = row["Name"].ToString();
ft.AliasNameList = Comm.GetAliasNameByBoid(ft.BOID);
ft.PropertyList = Comm.GetPropertyByBoid(ft.BOID);
ft.GeometryList = Comm.GetGeometryByBoid(ft.BOID);
ftList.Add(ft);
}
return(GGGXParse.ConvertFT.FeatureToGGGX(ftList));
}
/// <summary>
/// 根据查询条件获取GGGX数据
/// </summary>
/// <param name="bot"></param>
/// <param name="bos"></param>
/// <param name="filter"></param>
/// <param name="category"></param>
/// <returns></returns>
public XmlDocument Get3GXByFilter(string bot, List <string> bos, string filter, GGGXDataCategory category)
{
string sqlWhere = string.Empty;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT DISTINCT BO.*,OBJECTTYPE.BOT,OBJECTTYPE.FT FROM BO,OBJECTTYPE");
if (!string.IsNullOrEmpty(filter))
{
strSql.Append(" ,PROPERTY PROPERTY ");
strSql.Append(" WHERE BO.BOTID = OBJECTTYPE.BOTID ");
strSql.Append(" AND PROPERTY.BOID = BO.BOID ");
strSql.Append(string.Format(" AND OBJECTTYPE.BOT='{0}' ", bot));
strSql.Append(" AND BO.BOTID=OBJECTTYPE.BOTID ");
}
else
{
strSql.Append(string.Format(" WHERE OBJECTTYPE.BOT='{0}' ", bot));
strSql.Append(" AND BO.BOTID=OBJECTTYPE.BOTID ");
}
//对象名称
if (bos != null && bos.Count > 0)
{
string strBos = string.Empty;
for (int i = 0; i < bos.Count; i++)
{
if (i == bos.Count - 1)
{
strBos += "'" + bos[i].Trim() + "'";
}
else
{
strBos += "'" + bos[i].Trim() + "',";
}
}
strSql.Append(string.Format(" AND BO.NAME in ({0}) ", strBos));
}
//属性
if (!string.IsNullOrEmpty(filter))
{
strSql.Append(" AND " + "( " + MongoJsonToSql.JsonToSql(filter, bot).ToString() + " )");
}
DataTable dt = SqlServerDBHelper.GetDataTable(strSql.ToString());
List <GeoFeature> ftList = new List <GeoFeature>();
foreach (DataRow row in dt.Rows)
{
GeoFeature ft = new GeoFeature();
ft.BOID = row["Boid"].ToString();
ft.BOT = row["BOT"].ToString();
ft.FT = row["FT"].ToString();
ft.NAME = row["Name"].ToString();
if (category == GGGXDataCategory.B)
{
ft.PropertyList = Comm.GetPropertyByBoid(ft.BOID);
ft.GeometryList = Comm.GetGeometryByBoid(ft.BOID);
}
else if (category == GGGXDataCategory.P)
{
ft.PropertyList = Comm.GetPropertyByBoid(ft.BOID);
ft.GeometryList = null;
}
else if (category == GGGXDataCategory.G)
{
ft.PropertyList = null;
ft.GeometryList = Comm.GetGeometryByBoid(ft.BOID);
}
ftList.Add(ft);
}
return(GGGXParse.ConvertFT.FeatureToGGGX(ftList));
}
