需求;根据审批结果,统计上月个人,部门。财务已批准和未批准的综合。各种复杂技术不赘述。
新浪微博 jasondct
/// <summary>
/// 计算时间范围内各类审批统计/// </summary>
/// <param name="monthfirst">月处</param>
/// <param name="monthend">月末</param>
protected void GetCostBudge(DateTime monthfirst, DateTime monthend)
{
//转换时间
string monthfirst1 = SPUtility.CreateISO8601DateTimeFromSystemDateTime(monthfirst);
string monthend1 = SPUtility.CreateISO8601DateTimeFromSystemDateTime(monthend);
//获得当前列表
using (SPSite site = new SPSite(SPContext.Current.Site.ID))
{
using (SPWeb web = site.OpenWeb("expense"))
{
SPList list = web.Lists["EBRL"];
SPQuery Query = new SPQuery();
Query.Query = string.Format(@"<Where><And><Geq><FieldRef Name='SubmitTime' /><Value IncludeTimeValue='TRUE' Type='DateTime'>{0}</Value>
</Geq><Leq><FieldRef Name='SubmitTime' /><Value IncludeTimeValue='TRUE' Type='DateTime'>{1}</Value></Leq></And></Where>",monthfirst1, monthend1 );
Query.ViewFields = @"<FieldRef Name='FreeType' />
<FieldRef Name='Total'/>
<FieldRef Name='State'/>
<FieldRef Name='Dep'/>
<FieldRef Name='DepID'/>
<FieldRef Name='ApplyName'/> ";