public BusinessTripManagementService()
{
var webUrl = SPContext.Current.Web.Url;
_businessTripEmployeeDetailDAL = new BusinessTripEmployeeDetailDAL(webUrl);
_businessTripManagementDAL = new BusinessTripManagementDAL(webUrl);
_businessTripScheduleDAL = new BusinessTripScheduleDAL(webUrl);
}
private XElement BuildViewString(EmployeeInfo employeeInfo, string siteUrl)
{
XElement filterElement = null;
string filterStr = "<Eq><FieldRef Name='ID' /><Value Type='Counter'>0</Value></Eq>";
if (employeeInfo == null)
{
return(XElement.Parse(filterStr));
}
BusinessTripEmployeeDetailDAL _businessTripEmployeeDetailDAL = new BusinessTripEmployeeDetailDAL(siteUrl);
string taskQueryStr = string.Format(@"<Where>
<Eq>
<FieldRef Name='Employee' LookupId='TRUE' />
<Value Type='Lookup'>{0}</Value>
</Eq>
</Where>", employeeInfo.ID);
List <BusinessTripEmployeeDetail> employeeDetailCollection = _businessTripEmployeeDetailDAL.GetByQuery(taskQueryStr);
if (employeeDetailCollection.Any())
{
List <int> itemIds = employeeDetailCollection.Select(t => t.BusinessTripManagementID.LookupId).Distinct().ToList();
if (itemIds != null && itemIds.Count > 0)
{
filterStr = "";
foreach (var itemId in itemIds)
{
filterStr += string.Format("<Value Type='Counter'>{0}</Value>", itemId);
}
if (!string.IsNullOrEmpty(filterStr))
{
filterStr = string.Format("<In><FieldRef Name='ID'/><Values>{0}</Values></In>", filterStr);
}
}
}
filterElement = XElement.Parse(filterStr);
return(filterElement);
}