private bool GetExist(string tableName, string condition)
{
//List<string> newList = new List<string>();
//if (m_pWorkspace == null) return newList;
//DropTable("tempTable");
//m_pWorkspace.ExecuteSQL("create table tempTable as select " + Key + " from " + tableName + " where " + condition );
//IFeatureWorkspace pWs = m_pWorkspace as IFeatureWorkspace;
//ITable pTable = pWs.OpenTable("tempTable");
//ICursor pCursor = pTable.Search(null ,false);
//try
//{
// if (pCursor != null)
// {
// IRow row = pCursor.NextRow();
// while (row != null)
// {
// newList.Add(row.get_Value(0).ToString());
// row = pCursor.NextRow();
// }
// }
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.ToString());
//}
//finally
//{
// DropTable("tempTable");
// if (pCursor != null)
// {
// System.Runtime.InteropServices.Marshal.ReleaseComObject(pCursor);
// }
//}
//return newList;
bool bExist = false;
SysCommon.Gis.SysGisTable pTable = new SysCommon.Gis.SysGisTable(m_pWorkspace);
try
{
if (pTable.ExistData(tableName, condition))
{
bExist = true;
}
}
catch (System.Exception ex)
{
bExist = false;
}
pTable = null;
return(bExist);
}
/// <summary>
/// 从系统表中删除该条记录
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public bool DeleteTableRow(string strTableName, string condition)
{
Exception exError = null;
bool Bdelete = true;
SysCommon.Gis.SysGisTable sysTable = new SysCommon.Gis.SysGisTable(m_Workspace);
if (sysTable.ExistData(strTableName, condition))
{
if (!sysTable.DeleteRows(strTableName, condition, out exError))
{
return(Bdelete = false);
}
}
sysTable = null;
return(Bdelete);
}
/// <summary>
/// 更新系统表的数据记录
/// </summary>
/// <param name="tablename"></param>
/// <param name="condition"></param>
/// <param name="dicValues"></param>
/// <returns></returns>
public bool UpTableRow(string tablename, string condition, Dictionary <string, object> dicValues)
{
Exception exError = null;
bool Bdelete = true;
SysCommon.Gis.SysGisTable sysTable = new SysCommon.Gis.SysGisTable(m_Workspace);
if (sysTable.ExistData(tablename, condition))
{
return(Bdelete = sysTable.UpdateRow(tablename, condition, dicValues, out exError));
}
else
{
Bdelete = false;
}
sysTable = null;
return(Bdelete);
}
