/// <summary>
/// 结构是否存在自增长字段id
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
internal bool HasAutoIncrementID(Type t)
{
try
{
string cmdStr = SqliteTabelCmdStrTool.GetAutoIncrement(t);
DataTable dt = OperateQuery(cmdStr);
return(dt.Rows[0][0].ToString().Contains("INTEGER PRIMARY KEY AUTOINCREMENT"));
}
catch (SqliteException e)
{
LogOperator.AddWarnningRecord("执行查询结构是否存在自增长字段id时异常", e.Message);
return(false);
}
}
/// <summary>
/// 是否有主键id
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
internal bool HasIdPK(Type t)
{
try
{
string cmdStr = SqliteTabelCmdStrTool.GetAutoIncrement(t);
DataTable dt = OperateQuery(cmdStr);
if (dt.Rows.Count > 0 && dt.Columns.Count > 0)
{
return(dt.Rows[0][0].ToString().ToUpper().Contains("ID INTEGER PRIMARY KEY"));
}
{
return(false);
}
}
catch (SqliteException e)
{
LogOperator.AddWarnningRecord("执行查询结构是否存在自增长字段id时异常", e.Message);
return(false);
}
}