Ejemplo n.º 1
0
        protected void btnViewAvailability_Click(object sender, EventArgs e)
        {
            SPLimitedWebPartManager webPartManager = null;

            try
            {
                SPList list = null;
                SPView view = null;

                // get WebPartManager to identify current List/View
                SPWeb web = SPContext.Current.Web;
                webPartManager = SPContext.Current.File.GetLimitedWebPartManager(PersonalizationScope.Shared);
                foreach (System.Web.UI.WebControls.WebParts.WebPart wp in webPartManager.WebParts)
                {
                    XsltListViewWebPart xlvwp = wp as XsltListViewWebPart;
                    if (xlvwp != null)
                    {
                        list = web.Lists[xlvwp.ListId];
                        view = xlvwp.View;
                        break;
                    }
                }

                // get list data by Filters
                FieldFilterOperatorsLayer fol = new FieldFilterOperatorsLayer(this.FilterConditions);
                CamlFiltersLayer          fl  = new CamlFiltersLayer(list, this.FilterQuery, fol);
                string myQuery = fl.GetQueryByFilters();
                SPListItemCollection navigator = list.GetItems(new SPQuery()
                {
                    Query = myQuery, ViewFields = "<FieldRef Name=\"ID\" />", RowLimit = view.RowLimit
                });

                // get filter IDs
                string filteredIDs = string.Empty;
                if (navigator != null && navigator.Count > 0)
                {
                    filteredIDs = String.Join(",", navigator.Cast <SPListItem>().Select(x => x.ID.ToString()).ToArray());
                }

                string redigUrl = string.Format("{0}/{1}?FilteredIDs={2}&OrigSchiftId={3}{4}{5}",
                                                web.ServerRelativeUrl.TrimEnd('/'), this.RedirectUrl.TrimStart('/'),
                                                filteredIDs, this.Page.Request.QueryString["SchiftId"],
                                                string.IsNullOrEmpty(this.CalendarPeriod) ? "" : string.Format("&CalendarPeriod={0}", this.CalendarPeriod),
                                                FormatedCalendarDate);
                SPUtility.Redirect(redigUrl, SPRedirectFlags.Default, this.Context);
            }
            catch (Exception ex)
            {
                lblError.Text    = ex.Message;
                lblError.Visible = true;
            }
            finally
            {
                if (webPartManager != null)
                {
                    webPartManager.Web.Dispose();
                }
            }
        }
Ejemplo n.º 2
0
        private bool RenderListData(SPView view, TextWriter output)
        {
            if (view == null)
            {
                return(false);
            }

            FieldFilterOperatorsLayer fol       = new FieldFilterOperatorsLayer(base.Web);
            CamlFiltersLayer          fl        = new CamlFiltersLayer(this.List, HttpContext.Current.Request.QueryString, fol);
            SPListItemCollection      navigator = this.List.GetItems(new SPQuery()
            {
                Query      = fl.GetQueryByFilters(),
                ViewFields = CamlFiltersLayer.GetViewFieldsFromView(this.View),
                RowLimit   = this.View.RowLimit
            });

            StringBuilder newFilterLink = new StringBuilder();

            foreach (string fKey in HttpContext.Current.Request.QueryString.AllKeys.Where(x => x.StartsWith("Filter") || x.StartsWith("Sort")))
            {
                newFilterLink.AppendFormat("{0}={1}&", fKey, HttpContext.Current.Request.QueryString[fKey]);
            }

            output.Write("{ \"Row\" : \n");
            if ((navigator == null) || (navigator != null && navigator.Count == 0))
            {
                output.Write("[]");
                if (!string.IsNullOrEmpty(newFilterLink.ToString()))
                {
                    output.Write(",\"FilterLink\" : \"");
                    output.Write(JsonTextWriter.EscapeJScriptString("?" + newFilterLink.ToString()));
                    output.Write("\"");
                }
            }
            else
            {
                int num8;
                int num9;
                output.Write("[");

                bool              isFirstElem = true;
                string            lastField   = this.View.ViewFields.Cast <string>().Last();
                SPFieldCollection allFields   = this.List.Fields;
                foreach (SPListItem itm in navigator)
                {
                    output.WriteLine(isFirstElem ? "{" : ",{");

                    // general fields
                    output.WriteLine("\"{0}\": \"{1}\",", "ID", JsonTextWriter.EscapeJScriptString(itm.ID.ToString()));
                    try {
                        output.WriteLine("\"{0}\": \"{1}\",", "Title", JsonTextWriter.EscapeJScriptString(itm.Title ?? string.Empty));
                    } catch (Exception ex) {
                        output.WriteLine("\"{0}\": \"{1}\",", "Title", JsonTextWriter.EscapeJScriptString(ex.Message));
                    }
                    try {
                        output.WriteLine("\"{0}\": \"{1}\",", "ContentTypeId", JsonTextWriter.EscapeJScriptString(itm["ContentTypeId"].ToString()));
                    } catch (Exception ex) {
                        output.WriteLine("\"{0}\": \"{1}\",", "ContentTypeId", JsonTextWriter.EscapeJScriptString(ex.Message));
                    }
                    try {
                        output.WriteLine("\"{0}\": \"{1}\",", "PermMask", JsonTextWriter.EscapeJScriptString((string)itm["PermMask"] ?? string.Empty));
                    } catch (Exception ex) {
                        output.WriteLine("\"{0}\": \"{1}\",", "PermMask", JsonTextWriter.EscapeJScriptString(ex.Message));
                    }
                    try {
                        output.WriteLine("\"{0}\": \"{1}\",", "FSObjType", JsonTextWriter.EscapeJScriptString((string)itm["FSObjType"] ?? string.Empty));
                    } catch (Exception ex) {
                        output.WriteLine("\"{0}\": \"{1}\",", "FSObjType", JsonTextWriter.EscapeJScriptString(ex.Message));
                    }
                    try {
                        output.WriteLine("\"{0}\": \"{1}\",", "FileLeafRef", JsonTextWriter.EscapeJScriptString((string)itm["FileLeafRef"] ?? string.Empty));
                    } catch (Exception ex) {
                        output.WriteLine("\"{0}\": \"{1}\",", "FileLeafRef", JsonTextWriter.EscapeJScriptString(ex.Message));
                    }
                    try {
                        output.WriteLine("\"{0}\": \"{1}\",", "FileRef", JsonTextWriter.EscapeJScriptString((string)itm["FileRef"] ?? string.Empty));
                    } catch (Exception ex) {
                        output.WriteLine("\"{0}\": \"{1}\",", "FileRef", JsonTextWriter.EscapeJScriptString(ex.Message));
                    }
                    try {
                        output.WriteLine("\"{0}\": \"{1}\",", "File_x0020_Type", JsonTextWriter.EscapeJScriptString((string)itm["File_x0020_Type"] ?? string.Empty));
                    } catch (Exception ex) {
                        output.WriteLine("\"{0}\": \"{1}\",", "File_x0020_Type", JsonTextWriter.EscapeJScriptString(ex.Message));
                    }

                    // view fields
                    string valAsJson = string.Empty;
                    foreach (string fld in this.View.ViewFields)
                    {
                        valAsJson = "";
                        try
                        {
                            valAsJson = allFields.GetFieldByInternalName(fld).RenderFieldValueAsJson(itm[fld]);

                            // !!! not all SPFields override RenderFieldValueAsJson method
                            if (valAsJson == null)
                            {
                                valAsJson = (itm[fld] == null) ? "\"\"" : "\"" + JsonTextWriter.EscapeJScriptString(itm[fld].ToString()) + "\"";
                            }
                        }
                        catch (Exception ex)
                        {
                            valAsJson = "Field: " + fld + ". Error: " + ex.Message;
                        }

                        output.WriteLine("\"{0}\": {1}{2}", JsonTextWriter.EscapeJScriptString(fld), valAsJson, fld != lastField ? "," : string.Empty);
                    }

                    output.WriteLine("}");
                    isFirstElem = false;
                }

                output.Write("],");

                // FirstRow
                num8 = Convert.ToInt32(this.Context.Request.QueryString["FirstRow"], CultureInfo.InvariantCulture);
                if (num8 < 1)
                {
                    num8 = 1;
                }
                output.WriteLine("\"FirstRow\" : {0},", num8);

                // LastRow
                num9 = Math.Min((num8 + ((int)view.RowLimit)) - 1, navigator.Count); // xslWebPart.GridDataSerializer.ExplicitRowFilterCount.Value
                output.WriteLine("\"LastRow\" : {0}", num9);

                StringBuilder builder = new StringBuilder();
                StringBuilder sb      = new StringBuilder();

                // add FilterLink
                if (HttpContext.Current.Request.QueryString.HasKeys())
                {
                    output.Write(",\"FilterLink\" : \"");
                    output.Write(JsonTextWriter.EscapeJScriptString("?" + newFilterLink.ToString()));
                    output.Write("\"\n");
                }
                // add SortField
                if (HttpContext.Current.Request.QueryString.AllKeys.Contains("SortField"))
                {
                    output.Write(",\"SortField\" : \"");
                    output.Write(JsonTextWriter.EscapeJScriptString(HttpContext.Current.Request.QueryString["SortField"]));
                    output.Write("\"\n");
                }

                // add FilterFields
                var filterFieldsKeys = HttpContext.Current.Request.QueryString.AllKeys.Where(x => x.StartsWith("FilterField"));
                var fValAr           = filterFieldsKeys.Select(x => HttpContext.Current.Request.QueryString[x]);
                var fVal             = String.Join(";", fValAr);
                if (!string.IsNullOrEmpty(fVal))
                {
                    output.Write(",\"FilterFields\" : \"");
                    output.Write(JsonTextWriter.EscapeJScriptString(";" + fVal + ";"));
                    output.Write("\"\n");
                }

                // add SortDir
                if (HttpContext.Current.Request.QueryString.AllKeys.Contains("SortDir"))
                {
                    output.Write(",\"SortDir\" : \"");
                    output.Write(JsonTextWriter.EscapeJScriptString(HttpContext.Current.Request.QueryString["SortDir"] == "Asc" ? "ascending" : "descending"));
                    output.Write("\"\n");
                }

                // Hierarchy
                output.Write(",\"ForceNoHierarchy\" : \"1\"\n");
                output.Write(",\"HierarchyHasIndention\" : \"\"\n");
            }
            output.Write("\n}");

            return(true);
        }