protected void DebugRender(HtmlTextWriter writer)
{
SPSEditorPartsTools editorTools = new SPSEditorPartsTools(writer);
if (DebugQuery)
{
string resultQuery = editorTools.FormatXml(CamlQuery);
writer.Write("<font color=red>DEBUG CAML Query (Original)</font><br><font color=blue>");
writer.Write("<pre>" + SPEncode.HtmlEncode(resultQuery) + "</pre>");
writer.Write("</font><br>");
resultQuery = editorTools.FormatXml(_camlPreprocessor.Preprocess());
writer.Write("<font color=red>DEBUG CAML Query (Processed)</font><br><font color=blue>");
writer.Write("<pre>" + SPEncode.HtmlEncode(resultQuery) + "</pre>");
writer.Write("</font><br>");
}
if (DebugResults)
{
writer.Write("<font color=red>DEBUG XML DATA</font><br><font color=blue>");
writer.Write("<pre>" +
SPEncode.HtmlEncode(editorTools.FormatXml(_rollupEngine.Data.GetXml())) +
"</pre>");
writer.Write("</font><br>");
}
if (DebugEvaluator)
{
writer.Write("<font color=red>DEBUG Evaluator</font><br>");
writer.Write(EvaluatorSample());
writer.Write("<br>");
}
}
internal void AddMenuItem(IDictionary inst, string id, string caption, string img, string desc, string clickUrl, string clickScript, int cmdNo)
{
MenuItemTemplate child = new MenuItemTemplate(caption, img)
{
ID = id,
Description = desc,
PermissionContext = this.PermContext,
Permissions = this.Perms
};
if (string.IsNullOrEmpty(clickScript))
{
child.ClientOnClickNavigateUrl = SPEncode.ScriptEncode(clickUrl);
}
else
{
child.ClientOnClickScript = clickScript;
}
this.Controls.Add(child);
if (ProductPage.Is14)
{
this.ribbons.Add(new RibbonItem(child, inst, this.ClientID + id, caption, img, desc, clickUrl, clickScript, cmdNo));
this.WebPartIDs.ToString();
}
}
public void RecuperaDadosInternacao(int varIDInternacao)
{
//Acessando a lista Visita
SPList lstInternacao = web.Lists["Internações"];
//Construindo a Query CAML
SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where>" +
"<Eq>" +
"<FieldRef Name='ID' /><Value Type='Number'>" + intIDInternacao + "</Value>" +
"</Eq>" +
"</Where>";
//Criando uma coleção de itens, utilizando a Query CAML
SPListItemCollection collListItems = lstInternacao.GetItems(oQuery);
//Recupera o item
foreach (SPListItem oListItem in collListItems)
{
//Guarda resultado nas variáveis
strProntuario = SPEncode.HtmlEncode(oListItem["Prontu_x00e1_rio"].ToString());
strPaciente = SPEncode.HtmlEncode(oListItem["Paciente"].ToString());
}
}
public string RecuperaDadosMedico(string strMedico)
{
strMedico = strMedico.Substring(strMedico.IndexOf("#") + 1);
string strEspecialidade = "";
//Acessando a lista Visita
SPList lstMedico = web.Lists["Medicos"];
//Construindo a Query CAML
SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where>" +
"<Eq>" +
"<FieldRef Name='Title' /><Value Type='Text'>" + strMedico + "</Value>" +
"</Eq>" +
"</Where>";
//Criando uma coleção de itens, utilizando a Query CAML
SPListItemCollection collListItems = lstMedico.GetItems(oQuery);
//Recupera o item
foreach (SPListItem oListItem in collListItems)
{
strEspecialidade = oListItem["Especialidade"].ToString() != null?SPEncode.HtmlEncode(oListItem["Especialidade"].ToString()) : "";
}
return(strEspecialidade);
}
// Thank you to the following blog for the code to enable AJAX use of the TaxonomyWebTaggingControl
// http://pholpar.wordpress.com/2010/03/03/ajax-enabling-the-taxonomywebtaggingcontrol/
private string GetReloadJavaScript(TaxonomyWebTaggingControl taxonomyControl)
{
String script = String.Empty;
String containerId = SPEncode.ScriptEncode(taxonomyControl.Controls[1].ClientID);
Type type_TaxonomyWebTaggingControl = typeof(TaxonomyWebTaggingControl);
MethodInfo mi_getOnloadJavascript = type_TaxonomyWebTaggingControl.GetMethod("getOnloadJavascript", BindingFlags.NonPublic | BindingFlags.Instance);
String fullScript = (String)mi_getOnloadJavascript.Invoke(taxonomyControl, null);
int pos = fullScript.IndexOf(String.Format("function {0}_load()", containerId));
if (pos > -1)
{
string endRequestFunctionName = string.Format("{0}_EndRequest", containerId);
StringBuilder builder = new StringBuilder();
builder.Append("var myPrm = Sys.WebForms.PageRequestManager.getInstance();");
builder.Append("myPrm.add_endRequest(").Append(endRequestFunctionName).Append(");");
builder.Append("function ").Append(endRequestFunctionName).Append("(sender, args)");
builder.Append("{");
// we get te first part of the script needed to initialization
// we start from pos 1, because we don't need the leading '{'
builder.Append(fullScript.Substring(1, pos - 1));
builder.Append("Microsoft.SharePoint.Taxonomy.ScriptForWebTaggingUI.onLoad('");
builder.Append(containerId);
builder.Append("');");
builder.Append("}}");
script = builder.ToString();
}
return(script);
}
protected override void OnInit(EventArgs e)
{
string tmp = string.Empty, siteUrl = SPContext.Current.Web.Url.TrimEnd('/'), html, tmpCssClass = "c" + ProductPage.GuidLower(Guid.NewGuid(), false);
bool hasL = ProductPage.LicEdition(ProductPage.GetContext(), (ProductPage.LicInfo)null, 0), is14Popup = "1".Equals(Context.Request.QueryString ["roxDlg"]);
Random rnd = new Random();
if (!(ProductPage.Config <bool> (null, "_nojquery") || Page.Items.Contains("jquery")))
{
Page.Items ["jquery"] = new object();
Page.ClientScript.RegisterClientScriptInclude("jquery", siteUrl + "/_layouts/" + ProductPage.AssemblyName + "/jQuery.js?v=" + ProductPage.Version);
}
Page.ClientScript.RegisterClientScriptInclude(ProductPage.AssemblyName, siteUrl + "/_layouts/" + ProductPage.AssemblyName + "/" + ProductPage.AssemblyName + ".js?r=" + "&v=" + ProductPage.Version);
base.OnInit(e);
if (!string.IsNullOrEmpty(Context.Request.QueryString ["roxPrintZen"]))
{
html = "<div class=\"rox-prz-toolbar\"><button type=\"button\" onclick=\"roxDoPrint();\">" + (is14Popup ? " " : string.Empty) + ProductPage.GetProductResource("ToolBar_PrintNow" + (is14Popup ? "Ctx" : string.Empty)) + "</button> <span>" + ProductPage.GetProductResource("ToolBar_PrintPreview" + (is14Popup ? "Ctx" : string.Empty));
if (is14Popup)
{
html += (" | Zoom: <select id=\"roxpzzoomer\" onchange=\"roxPrintZoom(this.options[this.selectedIndex].value);\"><option value=\"100\">100%</option><option value=\"120\">120%</option><option value=\"150\">150%</option><option value=\"200\">200% " + ProductPage.GetResource("Recommended") + "</option></select>");
}
html += "</span></div>";
if (!ProductPage.LicEdition(ProductPage.GetContext(), (ProductPage.LicInfo)null, 2))
{
html += ("<div class=\"" + tmpCssClass + "\">Powered by <b>SharePoint-Tools.net/PrintZen</b></div><style type=\"text/css\"> ." + tmpCssClass + " { text-align: center; font-size: " + rnd.Next(24, 37) + "px; padding-bottom: 12px; display: none; } @media print { div." + tmpCssClass + " { display: block !important; } } </style>");
}
tmp += "<link type=\"text/css\" rel=\"stylesheet\" href=\"" + siteUrl + "/_layouts/" + ProductPage.AssemblyName + "/" + ProductPage.AssemblyName + ".css?r=" + "&v=" + ProductPage.Version + "\"/>";
tmp += "<style type=\"text/css\"> div.rox-prz-toolbar button { padding-left: 18px; padding-right: 18px; } </style>";
tmp += "<script> roxPrintPage = '" + SPEncode.ScriptEncode(html) + "'; roxDlgOnLoad = " + "1".Equals(Context.Request.QueryString ["roxDlgShow"]).ToString().ToLowerInvariant() + "; " + (hasL ? string.Empty : "setInterval(function() { jQuery('div.ms-bodyareacell').hide(); }, 250);") + " </script>";
Page.ClientScript.RegisterClientScriptInclude(ProductPage.AssemblyName + "2", siteUrl + "/_layouts/" + ProductPage.AssemblyName + "/mash.tl.aspx?op=r&r=" + rnd.Next(100, 1000) + "&o=" + Context.Server.UrlEncode(tmp));
}
}
public bool LoadPostData(string postDataKey, NameValueCollection postCollection)
{
selectedItems = new List <string>();
var postValues = postCollection[postDataKey];
foreach (var postValue in postValues.Split(','))
{
selectedItems.Add(SPEncode.HtmlDecode(postValue));
}
fillInValue = postCollection[postDataKey + "$FillInChoiceValue"];
if (!string.IsNullOrEmpty(fillInValue))
{
fillInValue = fillInValue.Trim();
}
if (!string.IsNullOrEmpty(fillInValue))
{
selectedItems.Add(fillInValue);
}
var oldSelectedItems = new List <string>();
if (!string.IsNullOrEmpty(selectedItemsString))
{
oldSelectedItems.AddRange(selectedItemsString.Split(new [] { ";#" }, StringSplitOptions.None));
}
// Sort
selectedItems.Sort();
oldSelectedItems.Sort();
return(!selectedItems.SequenceEqual(oldSelectedItems));
}
public bool LoadPostData(string postDataKey, NameValueCollection postCollection)
{
var keys = new List <string>(postCollection.AllKeys);
if (!keys.Contains(postDataKey) && !keys.Contains(postDataKey + "$FillInChoice"))
{
return(false);
}
var postedValue = postCollection[postDataKey];
if (string.Equals(postedValue, FillInChoiceValue))
{
postedValue = Utilities.Trim(postCollection[postDataKey + "$FillInChoice"]);
}
else
{
postedValue = SPEncode.HtmlDecode(postedValue);
}
if (!string.Equals(postedValue, Value))
{
Value = postedValue;
return(true);
}
return(false);
}
/// <summary>
/// Gets and ensure the field data.
/// </summary>
/// <param name="item">The item.</param>
/// <param name="fieldName">Name of the field.</param>
/// <returns>The field content</returns>
private string GetFieldData(SPItem item, string fieldName)
{
string fieldData = string.Empty;
if (item[fieldName] != null)
{
fieldData = SPEncode.HtmlDecode(item[fieldName].ToString());
// Dates in ISO8601
if (_bDateTimeISO8601 &&
item.Fields.GetField(fieldName).Type == SPFieldType.DateTime)
{
fieldData = SPUtility.CreateISO8601DateTimeFromSystemDateTime(
DateTime.Parse(fieldData, CultureInfo.InvariantCulture).ToUniversalTime().ToLocalTime());
}
else
{
// fix: lookup fields
if (_bFixLookUp)
{
if (fieldData.IndexOf(LOOKUP_FIELD_SEPARATOR) > 0)
{
fieldData = fieldData.Substring(fieldData.IndexOf(LOOKUP_FIELD_SEPARATOR) + 2);
}
}
}
}
return(fieldData);
}
internal void ProcessPostBack()
{
// Get Postback data
if (Page.IsPostBack)
{
// Decode data
string eventArg = Page.Request["__EVENTARGUMENT"];
string eventId = Page.Request["__EVENTTARGET"];
if (eventArg != null && eventId == ID)
{
_eventArgs = SPEncode.HtmlDecode(eventArg);
}
// Get data
if (!string.IsNullOrEmpty(_eventArgs) &&
(_eventArgs.StartsWith("ProCopy|") ||
_eventArgs.StartsWith("ProCut|")))
{
PasteHere();
}
// Get data
if (!string.IsNullOrEmpty(_eventArgs) &&
(_eventArgs.StartsWith("ProCopyPic|") ||
_eventArgs.StartsWith("ProCutPic|")))
{
PastePicsHere();
}
}
}
/// <summary>
/// Render this Tool part to the output parameter
/// specified.
/// </summary>
/// <param name="output">
/// The HTML writer to write out to
/// </param>
protected override void RenderToolPart(HtmlTextWriter output)
{
// Establish a reference to the Web Part.
SharePointForumWebPart wp1 = (SharePointForumWebPart)this.ParentToolPane.SelectedWebPart;
output.Write("Enter your custom text: ");
output.Write("<input name= '" + inputname);
output.Write("' type='text' value='" + SPEncode.HtmlEncode(ForumApplication.Instance.Title) + "'> <br>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string encodedListId = SPEncode.UrlEncode(this.ListGuid.ToString("B").ToUpper());
linkNewView.NavigateUrl += "List=" + encodedListId;
linkNewViewCalendar.NavigateUrl += "List=" + encodedListId;
}
}
protected override void CreateChildControls()
{
Controls.Clear();
SPWeb web = SPContext.Current.Web;
newItemPanel = new Panel()
{
ID = "panelNewItem"
};
string navigateUrl = "javascript:void(0);";
string webUrl = SPContext.Current.Web.ServerRelativeUrl.TrimEnd('/');
string listId = SPEncode.UrlEncode(this.List.Id.ToString("B").ToUpper());
if (!this.IsMultiContentTypeList)
{
navigateUrl = string.Format("javascript:SP.UI.ModalDialog.ShowPopupDialog('{0}')",
BuidUri(string.Format(URL_FORMAT, webUrl, this.List.DefaultContent.NewItemUrl.TrimStart('/'), listId), this.UrlParamsFromParent));
}
HyperLink addNewLink = new HyperLink {
ID = "linkAddNewItem", ToolTip = "new item",
CssClass = "ms-heroCommandLink " + this.List.Id.ToString("N"),
NavigateUrl = navigateUrl
};
Label addNewImgLabel = new Label()
{
CssClass = "ms-list-addnew-imgSpan20"
};
Image addNewImg = new Image {
ImageUrl = "/_layouts/15/images/spcommon.png?rev=23",
CssClass = "ms-list-addnew-img20"
};
Label addNewLabel = new Label()
{
Text = "new item"
};
addNewImgLabel.Controls.Add(addNewImg);
addNewLink.Controls.Add(addNewImgLabel);
addNewLink.Controls.Add(addNewLabel);
// add extra hidden SELECT control to access all list Content types from Ribbon Button
DropDownList ctList = new DropDownList {
ID = "listOfContentTypes", CssClass = "ct-for-" + this.List.Id.ToString("N").ToUpper()
};
ctList.Style.Add("display", "none");
ctList.Items.AddRange(this.VisibleContentTypes.Select(item => new ListItem(item.Name,
BuidUri(string.Format(URL_FORMAT, webUrl, item.NewItemUrl.TrimStart('/'), listId), UrlParamsFromParent))).ToArray());
newItemPanel.Controls.Add(addNewLink);
newItemPanel.Controls.Add(ctList);
this.Controls.Add(newItemPanel);
}
protected override void RenderFieldForDisplay(HtmlTextWriter writer)
{
if (SPContext.Current.FormContext.FormMode == SPControlMode.New)
{
writer.Write(" ");
}
else
{
writer.Write(ItemFieldValue == null ? " " : SPEncode.HtmlEncode(ItemFieldValue.ToString()));
}
}
protected override void ValidateInstance(IDictionary inst, ref string clickScript)
{
string str;
bool flag = false;
string str2 = ",";
if (inst["unix"] != null)
{
try
{
flag = (bool)inst["unix"];
}
catch
{
flag = false;
}
}
if (flag && !ZenMenuItem.IsLic(2))
{
flag = false;
clickScript = "alert('" + SPEncode.ScriptEncode(ProductPage.GetResource("NopeEd", new object[] { ProductPage.GetProductResource("PC_" + base.SchemaName + "_unix", new object[0]), "Basic" })) + "');";
}
if (!string.IsNullOrEmpty(str = inst["sep"] + string.Empty))
{
if (str == "s")
{
str2 = ";";
}
else if (str == "t")
{
str2 = "\t";
}
}
else if (inst["excel"] != null)
{
try
{
if ((bool)inst["excel"])
{
str2 = ";";
}
}
catch
{
}
}
if ((str2 != ",") && !ZenMenuItem.IsLic(2))
{
str2 = ",";
clickScript = "alert('" + SPEncode.ScriptEncode(ProductPage.GetResource("NopeEd", new object[] { ProductPage.GetProductResource("PC_" + base.SchemaName + "_sep", new object[0]), "Basic" })) + "');";
}
this.seps[inst["id"]] = str2;
this.unixes[inst["id"]] = flag;
}
private string GetMenuJsScript()
{
var webUrl = SPContext.Current.Web.ServerRelativeUrl.TrimEnd('/');
var listId = SPEncode.UrlEncode(this.List.Id.ToString("B").ToUpper());
const string menuItemFormat = "\"{0}\": {{name: \"{0}\", callback: function(key, opt){{ SP.UI.ModalDialog.ShowPopupDialog('{1}'); }}}}";
var menuItems = VisibleContentTypes.Select(item => string.Format(menuItemFormat,
item.Name, BuidUri(string.Format(URL_FORMAT, webUrl, item.NewItemUrl.TrimStart('/'), listId), UrlParamsFromParent))).ToList();
return(string.Format("{{{0}}}", string.Join(",", menuItems)));
}
public override string GetCellTextValue(DataRow row)
{
var value = row[FieldName];
if (value is DBNull)
{
return(DefaultValue);
}
return(SPEncode.HtmlEncode(value.ToString()));
}
public virtual void RenderCell(HtmlTextWriter writer, IGrouping <object, DataRow> grouping)
{
var groupKey = Convert.ToString(grouping.Key);
if (string.IsNullOrEmpty(groupKey))
{
groupKey = EmptyGroupString;
}
writer.Write(SPEncode.HtmlEncode(groupKey));
}
private void InitializeApplication()
{
UrlQuery query = new UrlQuery(this.Page.Request.Url.ToString());
ForumApplication.Instance.BasePath = SPEncode.UrlEncodeAsUrl(query.Url);
ForumApplication.Instance.Title = this.Name;
ForumApplication.Instance.ForumCache = this.Page.Cache;
ForumApplication.Instance.ClassResourcePath = this.ClassResourcePath;
ForumApplication.Instance.SpUser = SPControl.GetContextWeb(Context).CurrentUser;
ForumApplication.Instance.AppPoolUser = SPControl.GetContextSite(Context).OpenWeb().CurrentUser;
ForumApplication.Instance.SpWeb = SPControl.GetContextSite(Context).OpenWeb();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
if (this.List == null)
{
throw new Exception("List not found");
}
// init List name
lblListName.Text = this.List.Name;
// Add fields
var allFields = this.List.ListMetadataContentTypes.SelectMany(ct => ct.ListMetadataFieldContentTypes.Select(ctf => new {
ContentType = ct.Name,
FieldId = ctf.ListMetadataFieldId,
Field = ctf.ListMetadataField
}));
ColumnsRepeater.DataSource = allFields.GroupBy(g => g.FieldId).Select(g => new {
Id = g.Key,
FieldName = g.First().Field.FieldName,
FieldType = g.First().Field.FieldType,
UsedIn = string.Join(", ", g.Select(x => x.ContentType))
}).OrderBy(f => f.FieldName);
ColumnsRepeater.DataBind();
// Add Content Types
ContTypesRepeater.DataSource = this.List.ListMetadataContentTypes.OrderBy(ct => ct.IsDefault);
ContTypesRepeater.DataBind();
// Add Views
ViewsRepeater.DataSource = this.ListViews.OrderBy(f => f.Name);
ViewsRepeater.DataBind();
// add 'List' url param to links
string encodedListId = SPEncode.UrlEncode(this.ListGuid.ToString("B").ToUpper());
linkNewField.NavigateUrl += "?List=" + encodedListId;
linkNewView.NavigateUrl += "?List=" + encodedListId;
linkNewContentType.NavigateUrl += "?List=" + encodedListId;
linkListPermissions.NavigateUrl += "?ListId=" + encodedListId;
}
catch (Exception ex) {
panelErrror.Controls.Add(new Microsoft.SharePoint.Mobile.Controls.Label()
{
Text = ex.Message
});
}
}
}
protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)
{
SPWeb web = __Context.Web;
SPList list = web.Lists[Microsoft.SharePoint.WorkflowActions.Helper.GetListGuid(__Context, ListId)];
SPFolder folder = list.RootFolder;
SPFile file = folder.Files.Add(FileName, Encoding.UTF8.GetBytes(Xml), Overwrite);
FileItemId = new SPItemKey(file.Item.ID);
FileUrl = SPEncode.UrlEncode(web.Url + "/" + file.Url);
return(ActivityExecutionStatus.Closed);
}
public override void RenderCell(HtmlTextWriter writer, DataRow row)
{
var value = Convert.ToString(row[FieldName]);
if (string.IsNullOrEmpty(value))
{
writer.Write(DefaultValue);
return;
}
value = SPEncode.HtmlEncode(value);
var split = value.Split(new[] { ";#" }, StringSplitOptions.RemoveEmptyEntries);
writer.Write(string.Join("; ", split));
}
protected override void ValidateInstance(IDictionary inst, ref string clickScript)
{
bool unix = false;
string acsep, sep = ",";
if (inst ["unix"] != null)
{
try {
unix = (bool)inst ["unix"];
} catch {
unix = false;
}
}
if (unix && !IsLic(2))
{
unix = false;
clickScript = "alert(\'" + SPEncode.ScriptEncode(ProductPage.GetResource("NopeEd", ProductPage.GetProductResource("PC_" + SchemaName + "_unix"), "Basic")) + "\');";
}
if (!string.IsNullOrEmpty(acsep = inst ["sep"] + string.Empty))
{
if (acsep == "s")
{
sep = ";";
}
else if (acsep == "t")
{
sep = "\t";
}
}
else if (inst ["excel"] != null)
{
try {
if ((bool)inst ["excel"])
{
sep = ";";
}
} catch {
}
}
if ((sep != ",") && !IsLic(2))
{
sep = ",";
clickScript = "alert(\'" + SPEncode.ScriptEncode(ProductPage.GetResource("NopeEd", ProductPage.GetProductResource("PC_" + SchemaName + "_sep"), "Basic")) + "\');";
}
seps [inst ["id"]] = sep;
unixes [inst ["id"]] = unix;
}
/// <summary>
/// Relative url for zoom builder
/// </summary>
/// <returns>The relative Url</returns>
private static string ZoomBuilderRelativeUrl()
{
HttpContext current = HttpContext.Current;
SPWeb web = SPControl.GetContextWeb(current);
string relative = web.ServerRelativeUrl;
if (relative == "/")
{
relative = "/_layouts/zoombldr.aspx";
}
else
{
relative += "/_layouts/zoombldr.aspx";
}
return(SPEncode.UrlEncodeAsUrl(relative));
}
/// <summary>
/// Debugs the render.
/// </summary>
/// <param name="writer">The writer.</param>
/// <param name="transformed">The transformated.</param>
internal void DebugRender(HtmlTextWriter writer, string transformed)
{
SPSEditorPartsTools tools = new SPSEditorPartsTools(writer);
//if (DebugSource)
//{
// writer.Write("<font color=red>DEBUG XML DATA</font><br><font color=blue>");
// writer.Write("<pre>" + SPEncode.HtmlEncode(tools.FormatXml(XmlData)) + "</pre>");
// writer.Write("</font><br>");
//}
if (DebugTransformation)
{
writer.Write("<font color=red>DEBUG XML TRANSFORM</font><br><font color=blue>");
writer.Write("<pre>" + SPEncode.HtmlEncode(tools.FormatXml(transformed)) + "</pre>");
writer.Write("</font><br>");
}
}
/// <summary>
/// Gets the folder from query string.
/// </summary>
protected void GetFolderFromQueryString()
{
if (Page != null)
{
string folder = Page.Request.QueryString[RootFolderParameter];
string view = Page.Request.QueryString[ViewParameter];
if (folder != null && view != null)
{
if (SPHttpUtility.UrlKeyValueEncode(GetView().ID) == view)
{
CurrentFolder =
SPEncode.UrlDecodeAsUrl(
SPHttpUtility.UrlKeyValueDecode(folder));
}
}
}
}
public Hashtable CreateFolderInLibrary(SPUserCodeWorkflowContext context, string folderName, string libraryName, string folderPath)
{
char[] filenameChars = folderName.ToCharArray();
foreach (char c in filenameChars)
{
if (!SPEncode.IsLegalCharInUrl(c))
{
folderName = folderName.Replace(c.ToString(), "");
}
}
results["result"] = string.Empty;
try
{
using (SPSite site = new SPSite(context.CurrentWebUrl))
{
using (SPWeb web = site.OpenWeb())
{
SPList library = web.Lists[libraryName];
if (library != null)
{
string folderUrl = CreateFolder(library, folderName, folderPath, web);
results["result"] += "Created Finished";
results["folderUrl"] = folderUrl;
}
else
{
results["result"] = string.Format("Library ({0}) not found.", libraryName);
results["folderUrl"] = string.Empty;
}
}
}
}
catch (Exception e)
{
results = new Hashtable();
results["result"] = e.ToString();
results["folderUrl"] = string.Empty;
}
return(results);
}
/// <summary>
/// Gets and ensure the field data.
/// </summary>
/// <param name="item">The item.</param>
/// <param name="fieldName">Name of the field.</param>
/// <returns>The field content</returns>
private string GetFieldData(SPItem item, string fieldName)
{
string fieldData = string.Empty;
if (ItemContainsFieldAndData(item, fieldName))
{
try
{
fieldData = SPEncode.HtmlDecode(item[fieldName].ToString());
fieldData = ProcessFieldData(item, fieldName, fieldData);
}
catch (FormatException ex)
{
Debug.WriteLine(fieldName);
Debug.WriteLine("GetFieldData " + ex);
}
}
Debug.WriteLine("GetFieldData " + fieldName + "=" + fieldData);
return(fieldData);
}
static void Main(string[] args)
{
using (SPSite site = new SPSite("http://testsp2007"))
{
using (SPWeb web = site.OpenWeb("/ik"))
{
SPList list = web.GetList(web.Url + "/Lists/Departmanlar");
SPQuery query = new SPQuery();
query.RowLimit = 5000;
string sp2016url = "http://testsp2016/ik";
string saatbody = string.Empty, saatoutlookbody = string.Empty;
string listurl = "_api/web/Lists?$expand=ListItemAllFields&$filter=Title eq 'Departmanlar'";
string encodedlisturl = SPEncode.UrlEncode(listurl);
string listguid = RestHelper.GetIdOfList(sp2016url + SPEncode.UrlDecodeAsUrl(encodedlisturl),
sp2016url + "_api/contextinfo");
SPListItemCollection items = list.GetItems(query);
foreach (SPListItem item in items)
{
try
{
if (item != null)
{
var sirket = Helper.Get_LookUp("Sirket", item, web, sp2016url, "SirketId");
var title = Helper.Get_String("Title", item, web, sp2016url, "Title");
var mudur = Helper.Get_Group("Mudur", item, web, sp2016url, "MudurId");
RestHelper.RestYap("{'__metadata': {'type': 'SP.Data.DepartmanlarListItem'}," + sirket + "," + title + "," + mudur + " }",
sp2016url + "_api/contextinfo",
listguid + "/items",
listguid,
false, false, false, false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
}
public void MontaListaVisita(int varIDInternacao)
{
string varLinha = "";
lblProntuario.Text = strProntuario.ToString();
lblPaciente.Text = strPaciente.ToString();
//Acessando a lista Visita
SPList lstVisita = web.Lists["Visitas"];
//Construindo a Query CAML
SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where>" +
"<Eq>" +
"<FieldRef Name='Registro_x0020_de_x0020_interna_' /><Value Type='Lookup'>" + intIDInternacao + "</Value>" +
"</Eq>" +
"</Where>";
//Criando uma coleção de itens, utilizando a Query CAML
SPListItemCollection collListItems = lstVisita.GetItems(oQuery);
//Recupera o item
foreach (SPListItem oListItem in collListItems)
{
//Busca Especialidade do médico da visita
string strEspecMedico = RecuperaDadosMedico(SPEncode.HtmlEncode(oListItem["M_x00e9_dico_x0020_da_x0020_Visi"].ToString()));
//Monta linha da grid com os resultados
varLinha += "<tr><td valign='top' class='ms-formbody'>" + oListItem["M_x00e9_dico_x0020_da_x0020_Visi"] != null?SPEncode.HtmlEncode(oListItem["M_x00e9_dico_x0020_da_x0020_Visi"].ToString()) : "" + "</td>" +
"<td valign='top' class='ms-formbody'>" + SPEncode.HtmlEncode(strEspecMedico.ToString()) + "</td>" +
"<td valign='top' class='ms-formbody'>" + oListItem["Tipo_x0020_de_x0020_Visita"] != null?SPEncode.HtmlEncode(oListItem["Tipo_x0020_de_x0020_Visita"].ToString()) : "" + "</td>" +
"<td valign='top' class='ms-formbody'>" + oListItem["Hora_x0020_de_x0020_In_x00ed_cio"] != null?SPEncode.HtmlEncode(oListItem["Hora_x0020_de_x0020_In_x00ed_cio"].ToString()) : "" + "</td>" +
"<td valign='top' class='ms-formbody'>" + oListItem["Hora_x0020_de_x0020_Fim_x0020_da"] != null?SPEncode.HtmlEncode(oListItem["Hora_x0020_de_x0020_Fim_x0020_da"].ToString()) : "" + "</td>" +
"<td valign='top' class='ms-formbody'>" + oListItem["Observa_x00e7__x00e3_o"] != null?SPEncode.HtmlEncode(oListItem["Observa_x00e7__x00e3_o"].ToString()) : "" + "</td></tr>";
}
ltrListaVisita.Text = varLinha.ToString();
}
