public virtual int GetRecordsCount() { string condition = " 1 = 1 "; string statement = SqlStatememtGenerator.Select_ReadSomeColumnsByCondition(tableName, new string[] { "count(*)" }, condition); return Convert.ToInt32(executer.ExecuteScalarSelectStatement(statement, null)); }
public int GetAssociationsCountOfSecondTable(T2 secondTableVO) { string condition = string.Format("{0}=@{0}", secondTableIdColumnName); string statement = SqlStatememtGenerator.Select_ReadSomeColumnsByCondition(tableName, new string[] { "count(*)" }, condition); SqlCeParameter[] parameters = new SqlCeParameter[1]; parameters[0] = MakeSqlParameter(secondTableIdColumnName, secondTableVO.Id); int count = Convert.ToInt32(executer.ExecuteScalarSelectStatement(statement, parameters).ToString()); return(count); }
public int GetMaxId() { string[] temp = new string[]{ string.Format("max({0})", idColumnName) }; string statement = SqlStatememtGenerator.Select_ReadSomeColumnsByCondition(tableName, temp, "1=1"); try { int result = Convert.ToInt32(executer.ExecuteScalarSelectStatement(statement, null)); return result; } catch { return -1; } }