查询
统计查询结果的数量:
public int QueryFeatureCount(int LayerID,String FieldName,String SearchStr)
{
try{
fuzhou.QueryFilter m_queryFilter=new fuzhou.QueryFilter();
m_queryFilter.WhereClause = FieldName + " like ''%" + SearchStr + "%''";
int i = map.QueryFeatureCount(map.GetDefaultMapName(), LayerID, m_queryFilter);
return i;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "An error has occurred");
}
return 0;
}
public int QueryFeatureCount(String LayerName, String FieldName, String SearchStr)
{
try
{
String m_sDataFrame = map.GetDefaultMapName();
fuzhou.MapServerInfo mapi = map.GetServerInfo(m_sDataFrame);
for (int i = 0; i < mapi.MapLayerInfos.GetLength(0); i++)
{
if (mapi.MapLayerInfos[i].Name == LayerName)
{
int LayerID = mapi.MapLayerInfos[i].LayerID;
fuzhou.QueryFilter m_queryFilter = new fuzhou.QueryFilter();
m_queryFilter.WhereClause = FieldName + " like ''%" + SearchStr + "%''";
int j = map.QueryFeatureCount(map.GetDefaultMapName(), LayerID, m_queryFilter);
return j;
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "An error has occurred");
}
return 0;
}
查询结果:
public fuzhou.RecordSet QueryFeatureData(int LayerID, String FieldName, String SearchStr)
{
try
{
fuzhou.QueryFilter m_queryFilter = new fuzhou.QueryFilter();
m_queryFilter.WhereClause = FieldName + " like ''%" + SearchStr + "%''";
fuzhou.RecordSet m_recordset = map.QueryFeatureData(map.GetDefaultMapName(), LayerID, m_queryFilter);
return m_recordset;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "An error has occurred");
}
return null;
}
public fuzhou.RecordSet QueryFeatureData(String LayerName, String FieldName, String SearchStr)
{
try
{
String m_sDataFrame = map.GetDefaultMapName();
fuzhou.MapServerInfo mapi = map.GetServerInfo(m_sDataFrame);
for (int i = 0; i < mapi.MapLayerInfos.GetLength(0); i++)
{
if (mapi.MapLayerInfos[i].Name == LayerName)
{
int LayerID = mapi.MapLayerInfos[i].LayerID;
fuzhou.QueryFilter m_queryFilter = new fuzhou.QueryFilter();
m_queryFilter.WhereClause = FieldName + " like ''%" + SearchStr + "%''";
fuzhou.RecordSet m_recordset = map.QueryFeatureData(map.GetDefaultMapName(), LayerID, m_queryFilter);
return m_recordset;
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "An error has occurred");
}
return null;
}
public fuzhou.RecordSet QueryFeatureData(String LayerName, String FieldName, String SearchStr,String SqlWhere)
{
try
{
String m_sDataFrame = map.GetDefaultMapName();
fuzhou.MapServerInfo mapi = map.GetServerInfo(m_sDataFrame);
for (int i = 0; i < mapi.MapLayerInfos.GetLength(0); i++)
{
if (mapi.MapLayerInfos[i].Name == LayerName)
{
int LayerID = mapi.MapLayerInfos[i].LayerID;
fuzhou.QueryFilter m_queryFilter = new fuzhou.QueryFilter();
m_queryFilter.WhereClause = FieldName + " like ''%" + SearchStr + "%'' " + SqlWhere;
fuzhou.RecordSet m_recordset = map.QueryFeatureData(map.GetDefaultMapName(), LayerID, m_queryFilter);
return m_recordset;
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "An error has occurred");
}
return null;
}
本文来源【学网】网站链接是http://www.xue5.com