protected int CountFromDatabase(ObjectFilter objectFilter)
{
SqlParameter[] procParams = new SqlParameter[2];
procParams[0] = DataAccess.CreateParameter("@View", SqlDbType.NVarChar, GetViewName());
procParams[1] = DataAccess.CreateParameter("@Where", SqlDbType.NVarChar, objectFilter.Where);
return(ConvertHelper.Convert <int>(DataAccess.ExecuteScalar(GetProcName(EnumProcType.Count), procParams), 0));
}
protected int IndexFromDatabase(ObjectFilter objectFilter, int objectID)
{
SqlParameter[] procParams = new SqlParameter[4];
procParams[0] = DataAccess.CreateParameter("@View", SqlDbType.NVarChar, GetViewName());
procParams[1] = DataAccess.CreateParameter("@ID", SqlDbType.Int, objectID);
procParams[2] = DataAccess.CreateParameter("@Where", SqlDbType.NVarChar, objectFilter.Where);
procParams[3] = DataAccess.CreateParameter("@OrderBy", SqlDbType.NVarChar, objectFilter.OrderBy);
return(ConvertHelper.Convert <int>(DataAccess.ExecuteScalar(GetProcName(EnumProcType.Index), procParams), -1));
}
public static VarType ReadField <VarType>(DataRowView DRV, string FieldName, VarType DefVal)
{
VarType Ret = DefVal;
object val = ReadField(DRV, FieldName);
if (null != val)
{
Ret = ConvertHelper.Convert <VarType>(val, DefVal);
}
return(Ret);
}
public static VarType Request <VarType>(string Key, VarType def)
{
return(ConvertHelper.Convert <VarType>(Request(Key), def));
}
public static VarType Load <VarType>(string Key, VarType def)
{
return(ConvertHelper.Convert <VarType>(Items[Key], def));
}
public VarType Load <VarType>(string Key, VarType def)
{
return(ConvertHelper.Convert <VarType>(_ViewState[Key], def));
}