or
namespace
ReportingTest2
{
[System.ComponentModel.DataObject()]
public
class
UrenSpecificatieDS : List<UrenSpecificatieItemObj>
{
[System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select)]
public
List<UrenSpecificatieItemObj> GetUrenBetweenDates(DateTime beginDate, DateTime endDate)
{
if
(beginDate !=
null
&& endDate !=
null
)
{
using
(SPSite site =
new
SPSite(
"http://devserver"
))
{
using
(SPWeb web = site.OpenWeb())
{
SPList spUrenSpecificatieList = web.Lists[
"HourRegistration"
];
SPQuery query =
new
SPQuery();
query.Query =
"<Query><Where><And><Geq>"
+
"<FieldRef Name=\"Date\" /><Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">2011-04-01T02:18:48Z</Value>"
+
"</Geq><Leq>"
+
"<FieldRef Name=\"Date\" /><Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">2011-04-24T02:18:50Z</Value>"
+
"</Leq></And></Where></Query>"
;
foreach
(SPItem item
in
spUrenSpecificatieList.GetItems(query))
{
UrenSpecificatieItemObj ur =
new
UrenSpecificatieItemObj();
ur._Date = getDateField(item,
"Date"
);
string
[] split = {
";#"
};
ur.Company = getStringField(item,
"Company"
).Split(split, StringSplitOptions.None)[1];
ur.Hours = getDecField(item,
"Hours"
);
ur.Distance = getDecField(item,
"Distance"
);
ur.Description = getStringField(item,
"Title"
);
this
.Add(ur);
}
}
}
return
this
;
}
return
null
;
}
// omitted the helper methods.
}
IReportDocument document = null;
using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(dataFile))
{
System.Xml.Serialization.XmlSerializer xmlSerializer =
new System.Xml.Serialization.XmlSerializer(typeof(Telerik.Reporting.ReportBook));
document = (Telerik.Reporting.ReportBook)xmlSerializer.Deserialize(xmlReader);
}
<
StyleSheet
>
<
StyleRule
>
<
Style
BackgroundColor
=
"Transparent"
Color
=
"Black"
VerticalAlign
=
"Middle"
>
<
BorderStyle
Bottom
=
"Solid"
/>
<
BorderColor
Default
=
"DimGray"
/>
<
BorderWidth
Default
=
"1px"
/>
<
Font
Size
=
"11pt"
Style
=
"Bold"
/>
<
Padding
Left
=
"0cm"
/>
</
Style
>
<
Selectors
>
<
StyleSelector
>
<
Type
>ReportItemBase</
Type
>
<
StyleName
>Test</
StyleName
>
</
StyleSelector
>
</
Selectors
>
</
StyleRule
>
</
StyleSheet
>