protected List<T> IdenticalMatch(SqlCeParameter[] parameters)
{
StringBuilder builder = new StringBuilder();
if (parameters.Length > 0)
{
for (int i = 0; i < parameters.Length; i++)
{
builder.AppendFormat("{0} = @{0}", parameters[i].ParameterName.Substring(1));
if (i < parameters.Length - 1)
builder.Append(" AND ");
}
}
else
{
builder.AppendFormat("1 = 1");
}
string condition = builder.ToString();
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, parameters);
if (reader == null)
return new List<T>();
return ReadAllRecords(reader);
}
public List <DocumentVO> GetDocumentsOfFolder(FolderVO folder)
{
string condition = string.Format("{0}={1}", documentFolderId, folder.Id);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, null);
return(ReadAllRecords(reader));
}
private List <DocumentVO> ExactFindByStringColumn(string title, string columnName)
{
string condition = string.Format("{0} like '{1}'", columnName, title);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, null);
return(ReadAllRecords(reader));
}
public List <LogEntryVO> Find(Common.Search.DateRange range, OperationVO operation, UserVO user)
{
SqlCeParameter[] parameters = GetParameters(range);
string condition = GetCondition(range, operation, user);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, parameters);
return(ReadAllRecords(reader));
}
public virtual List<T> GetAll()
{
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, "1=1");
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, null);
if (reader == null)
return new List<T>();
return ReadAllRecords(reader);
}
private List <DocumentVO> FindByIntegerColumn(int value, string columnName)
{
string condition = string.Format("{0} = {1}", columnName, value);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, null);
List <DocumentVO> result = ReadAllRecords(reader);
FullLoadList(result);
return(result);
}
private List <DocumentVO> GetItemsInRange(List <int> ids)
{
if (ids == null || ids.Count == 0)
{
return(new List <DocumentVO>());
}
string cond = string.Format("{0} in {1}", idColumnName, MakeCommaSeparatedValues(ids));
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, cond);
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, null);
return(ReadAllRecords(reader));
}
public List <FileVO> FindFilesByArchivingDate(DateRange range)
{
string rStart = "rangeStart";
string rEnd = "rEnd";
string condition = string.Format("{0} >= @{1} and {0} < @{2}", fileAdditionDate, rStart, rEnd);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeParameter[] paramters = new SqlCeParameter[]
{
MakeSqlParameter(rStart, range.Start, SqlDbType.DateTime),
MakeSqlParameter(rEnd, range.End, SqlDbType.DateTime)
};
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, paramters);
List <FileVO> result = ReadAllRecords(reader);
return(result);
}
private List <DocumentVO> FindByDateRangeColumn(DateRange range, string columName)
{
string rStart = "rangeStart";
string rEnd = "rEnd";
string condition = string.Format("{0} >= @{1} and {0} < @{2}", columName, rStart, rEnd);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeParameter[] paramters = new SqlCeParameter[]
{
MakeSqlParameter(rStart, range.Start, SqlDbType.DateTime),
MakeSqlParameter(rEnd, range.End, SqlDbType.DateTime)
};
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, paramters);
List <DocumentVO> result = ReadAllRecords(reader);
FullLoadList(result);
return(result);
}
private List <int> GetAssociationsOfTable(VO tableElement, string providedTableColumnName, string requiredTableColumnName)
{
List <int> result = new List <int>();
string condition = string.Format("{0} = @{0}", providedTableColumnName);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeParameter[] parameters = new SqlCeParameter[] { MakeSqlParameter(providedTableColumnName, tableElement.Id) };
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, parameters);
try
{
while (reader.Read())
{
result.Add(reader.GetInt32(reader.GetOrdinal(requiredTableColumnName)));
}
}
catch
{ }
reader.Close();
return(result);
}