Get list items from sharepoint site and assigning that values to one splistitemcollection(IN SERVER SIDE)
// Function to get selected PPElistitems
SPListItemCollection ProjectPPEsCol = GetSelectedPPEListItems("ProjectPPEs");
private SPListItemCollection GetSelectedPPEListItems(string listName)
{
SPListItemCollection spListItems = null;
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite pSitecol = SPContext.Current.Site)
{
using (SPWeb oWeb = pSitecol.OpenWeb())
{
SPList list = oWeb.Lists[listName];
// listname="ProjectPPEs";
SPQuery spQuery = new SPQuery();
// query.Query = "<Query><Where><And><Eq><FieldRef Name=;ProjectNumber;/><Value Type='Number'>" + Pid1
//+ "</Value></Eq><And><Eq><FieldRef Name = 'PNum3Digit'/><Value Type = 'Number' >" + Pid2
//+ "</ Value ></ Eq >< And >< Eq >< FieldRef Name = 'TaskNumber' />< Value Type = 'Number' >" + taskId
//+ "</ Value ></ Eq >< IsNotNull >< FieldRef Name = 'PPEIDs' /></ IsNotNull ></ And ></ And ></ And ></ Where ></ Query >";
spListItems = list.GetItems(spQuery);
}
}
});
return spListItems;
}
Get list items from sharepoint site and assigning that values to one string array(IN SERVER SIDE)
// Get selected PPE Text values
string[] selectedPPEArrValues = GetSelectedPPETextArrayValue(ProjectPPEsCol,ProjNoPart1,ProjNo3DigPart2, TaskNo);
//Created separate function
private string[] GetSelectedPPETextArrayValue(SPListItemCollection selectedPPEListItemCol,string ProjNoPart1, string ProjNo3DigPart2, string taskNo)
{
string[] ppeTextArrValue = null;
if (selectedPPEListItemCol != null)
{
string ppeTextValues = string.Empty;
foreach (SPListItem listItem in selectedPPEListItemCol)
{
if (listItem["PPEText"] != null && listItem["ProjectNumber"] != null && listItem["PNum3Digit"] != null && listItem["TaskNumber"] != null)
{
if (listItem["ProjectNumber"].ToString() == ProjNoPart1 && listItem["PNum3Digit"].ToString() == ProjNo3DigPart2 && listItem["TaskNumber"].ToString() == taskNo)
{
if (string.IsNullOrEmpty(ppeTextValues))
{
ppeTextValues = listItem["PPEText"].ToString();
if (ppeTextValues.StartsWith("|"))
{
//ppeTextValues.Remove(0, 1);
ppeTextValues.Substring(1);
}
}
else
ppeTextValues += "|" + listItem["PPEText"].ToString();
}
}
return ppeTextValues ;
}
// Function to get selected PPElistitems
SPListItemCollection ProjectPPEsCol = GetSelectedPPEListItems("ProjectPPEs");
private SPListItemCollection GetSelectedPPEListItems(string listName)
{
SPListItemCollection spListItems = null;
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite pSitecol = SPContext.Current.Site)
{
using (SPWeb oWeb = pSitecol.OpenWeb())
{
SPList list = oWeb.Lists[listName];
// listname="ProjectPPEs";
SPQuery spQuery = new SPQuery();
// query.Query = "<Query><Where><And><Eq><FieldRef Name=;ProjectNumber;/><Value Type='Number'>" + Pid1
//+ "</Value></Eq><And><Eq><FieldRef Name = 'PNum3Digit'/><Value Type = 'Number' >" + Pid2
//+ "</ Value ></ Eq >< And >< Eq >< FieldRef Name = 'TaskNumber' />< Value Type = 'Number' >" + taskId
//+ "</ Value ></ Eq >< IsNotNull >< FieldRef Name = 'PPEIDs' /></ IsNotNull ></ And ></ And ></ And ></ Where ></ Query >";
spListItems = list.GetItems(spQuery);
}
}
});
return spListItems;
}
Get list items from sharepoint site and assigning that values to one string array(IN SERVER SIDE)
// Get selected PPE Text values
string[] selectedPPEArrValues = GetSelectedPPETextArrayValue(ProjectPPEsCol,ProjNoPart1,ProjNo3DigPart2, TaskNo);
//Created separate function
private string[] GetSelectedPPETextArrayValue(SPListItemCollection selectedPPEListItemCol,string ProjNoPart1, string ProjNo3DigPart2, string taskNo)
{
string[] ppeTextArrValue = null;
if (selectedPPEListItemCol != null)
{
string ppeTextValues = string.Empty;
foreach (SPListItem listItem in selectedPPEListItemCol)
{
if (listItem["PPEText"] != null && listItem["ProjectNumber"] != null && listItem["PNum3Digit"] != null && listItem["TaskNumber"] != null)
{
if (listItem["ProjectNumber"].ToString() == ProjNoPart1 && listItem["PNum3Digit"].ToString() == ProjNo3DigPart2 && listItem["TaskNumber"].ToString() == taskNo)
{
if (string.IsNullOrEmpty(ppeTextValues))
{
ppeTextValues = listItem["PPEText"].ToString();
if (ppeTextValues.StartsWith("|"))
{
//ppeTextValues.Remove(0, 1);
ppeTextValues.Substring(1);
}
}
else
ppeTextValues += "|" + listItem["PPEText"].ToString();
}
}
return ppeTextValues ;
}
No comments:
Post a Comment