\u0421\u043e\u0437\u0434\u0430\u0435\u043c VisualWebPart<\/p>\n\n\n\n
aspx<\/p>\n\n\n\n
<asp:Panel ID="FilterPanel" runat="server">\n \n <asp:Label ID="_title_lbl" runat="server" Text="\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435: "><\/asp:Label>\n <asp:TextBox ID="_title_box" runat="server"><\/asp:TextBox>\n <br\/><br\/>\n <asp:Label ID="_user_lbl" runat="server" Text="\u0421\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a: "><\/asp:Label>\n <asp:TextBox ID="_user_box" runat="server"><\/asp:TextBox>\n <br\/><br\/>\n <asp:Button ID="_search_btn" runat="server" Text="\u041d\u0430\u0439\u0442\u0438" OnClick="_search_btn_Click" \/>\n \n <asp:Panel ID="ResultsPanel" runat="server"><\/asp:Panel>\n\n<\/asp:Panel><\/code><\/pre>\n\n\n\nascx.cs<\/p>\n\n\n\n
UpdatePanel mainUpdatePanel;\nSPList list;\nListViewWebPart lvwp;\n\nprotected void Page_Load(object sender, EventArgs e)\n{\n \/\/ \u0421\u043f\u0438\u0441\u043e\u043a\n list = SPContext.Current.Web.GetList(SPUrlUtility.CombineUrl(SPContext.Current.Web.Url, "Lists\/FiltredList"));\n \/\/ \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b\n lvwp = new ListViewWebPart();\n lvwp.ListName = list.ID.ToString("B").ToUpper();\n lvwp.ViewGuid = list.DefaultView.ID.ToString("B").ToUpper();\n lvwp.ChromeType = PartChromeType.Default;\n\n mainUpdatePanel = new UpdatePanel();\n mainUpdatePanel.UpdateMode = UpdatePanelUpdateMode.Conditional;\n\n mainUpdatePanel.ContentTemplateContainer.Controls.Add(_search_btn);\n mainUpdatePanel.ContentTemplateContainer.Controls.Add(lvwp);\n\n\n ResultsPanel.Controls.Add(mainUpdatePanel);\n\n \/\/ \u0421\u0442\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u0435\n string query = string.Empty;\n string additionalCondition = "<Or><Eq><FieldRef Name='ID' \/><Value Type='Counter'>1<\/Value><\/Eq><Eq><FieldRef Name='ID' \/><Value Type='Counter'>2<\/Value><\/Eq><\/Or>";\n query = (query.Length > 0 ? "<And>" + query + additionalCondition + "<\/And>" : additionalCondition);\n\n LoadData(query);\n}\n\n\/\/\/ <summary>\n\/\/\/ \u041a\u043d\u043e\u043f\u043a\u0430 \u043f\u043e\u0438\u0441\u043a\u0430\n\/\/\/ <\/summary>\n\/\/\/ <param name="sender"><\/param>\n\/\/\/ <param name="e"><\/param>\nprotected void _search_btn_Click(object sender, EventArgs e)\n{\n string query = string.Empty;\n string tempAdding = string.Empty;\n if (!string.IsNullOrEmpty(_title_box.Text))\n {\n query = "<Contains><FieldRef Name='Title' \/><Value Type='Text'>" + _title_box.Text + "<\/Value><\/Contains>";\n }\n if (!string.IsNullOrEmpty(_user_box.Text))\n {\n tempAdding = "<Contains><FieldRef Name='Users' \/><Value Type='UserMulti'>" + _user_box.Text + "<\/Value><\/Contains>";\n query = (query.Length > 0 ? "<And>" + query + tempAdding + "<\/And>" : tempAdding);\n }\n\n \/\/ \u0421\u0442\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u0435\n string additionalCondition = "<Or><Eq><FieldRef Name='ID' \/><Value Type='Counter'>1<\/Value><\/Eq><Eq><FieldRef Name='ID' \/><Value Type='Counter'>2<\/Value><\/Eq><\/Or>";\n query = (query.Length > 0 ? "<And>" + query + additionalCondition + "<\/And>" : additionalCondition);\n\n\n LoadData(query);\n}\n\n\/\/\/ <summary>\n\/\/\/ \u0417\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445\n\/\/\/ <\/summary>\n\/\/\/ <param name="query"><\/param>\nprivate void LoadData(string query)\n{\n XmlDocument doc = new XmlDocument();\n doc.LoadXml(lvwp.ListViewXml);\n XmlNode queryNode = doc.SelectSingleNode("\/\/Query");\n XmlNode whereNode = queryNode.SelectSingleNode("Where");\n\n if (whereNode != null) queryNode.RemoveChild(whereNode);\n XmlNode newNode = doc.CreateNode(XmlNodeType.Element, "Where", String.Empty);\n newNode.InnerXml = query.ToString();\n queryNode.AppendChild(newNode);\n lvwp.ListViewXml = doc.OuterXml;\n}<\/code><\/pre>\n\n\n\n\u0414\u043b\u044f \u044d\u043a\u0441\u043f\u043e\u0440\u0442\u0430 \u0432 Excel \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c \u043a\u043b\u0438\u0435\u043d\u0442\u0441\u043a\u0438\u0439 \u043a\u043e\u0434, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 IE<\/p>\n\n\n\n
<script language="javascript" type="text\/javascript">\n\tfunction generateexcel() {\n\t\tvar x = document.getElementById('{7BA8873E-1B90-4EAB-B446-23F93A590249}-{73FEA2BD-79BD-4F55-A8FE-E6DB310018DD}').rows;\n\t\tvar xls = new ActiveXObject("Excel.Application");\n\t\txls.visible = true\n\t\txls.Workbooks.Add\n\t\tfor (i = 0; i < x.length; i++) {\n\t\t\tvar y = x[i].cells;\n\t\t\tfor (j = 0; j < y.length; j++) {\n\t\t\t\txls.cells(i + 1, j + 1).value = y[j].innerText;\n\t\t\t}\n\t\t}\n\t}\n <\/script>\n<input type='button' value='Export To Excel' onclick="generateexcel();"\/>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u0421\u043e\u0437\u0434\u0430\u0435\u043c VisualWebPart aspx ascx.cs \u0414\u043b\u044f \u044d\u043a\u0441\u043f\u043e\u0440\u0442\u0430 \u0432 Excel \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c \u043a\u043b\u0438\u0435\u043d\u0442\u0441\u043a\u0438\u0439 \u043a\u043e\u0434, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 IE<\/p>\n","protected":false},"author":1,"featured_media":170,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,11],"tags":[40,28,33],"class_list":["post-167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-javascript","category-sharepoint","tag-excel","tag-javascript","tag-sharepoint"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=167"}],"version-history":[{"count":3,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/167\/revisions"}],"predecessor-version":[{"id":176,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/167\/revisions\/176"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/media\/170"}],"wp:attachment":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}