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)));
}
//Does not load the fileData column
public override List <FileVO> GetAll()
{
string[] columns = { idColumnName, fileName, fileDocumentId, fileType, fileAdditionDate };
string statement = SqlStatememtGenerator.Select_ReadSomeColumnsByCondition(tableName, columns, "1 = 1");
return(ReadAllRecords(executer.ExecuteSelectStatement(statement, null)));
}
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);
}
}
public int GetAssociationsCountOfSecondTable(T2 secondTableVO)
{
try
{
string condition = string.Format("{0}=@{0}", secondTableIdColumnName);
string statement = SqlStatememtGenerator.Select_ReadSomeColumnsByCondition(tableName, new string[] { "count(*)" }, condition);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = MakeSqlParameter(secondTableIdColumnName, secondTableVO.Id);
int count = Convert.ToInt32(executer.ExecuteScalarSelectStatement(statement, parameters).ToString());
return(count);
}
catch
{
return(-1);
}
}