or
2 answers
625 views
hi,
i am using your telerik datagrid, every thing works fine but i need to pass the filter values to the sql datasource (or a simple objectdatasource).
Can you help me?
thanks!
<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="***" ProviderName="System.Data.OracleClient" SelectCommand="select * from MAINITEMS" runat="server"> </asp:SqlDataSource><telerik:RadGrid runat="server" ID="RadGrid1" Width="99%" Height="600px" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" AllowSorting="True" ShowFooter="False" ShowHeader="True" OnPreRender="RadGrid1_OnPreRender" AllowAutomaticDeletes="False" AllowAutomaticUpdates="False" AllowAutomaticInserts="False" AutoGenerateColumns="True" AllowPaging="True" PageSize="30" ShowGroupPanel="True" > <GroupingSettings CaseSensitive="false" ShowUnGroupButton="true"></GroupingSettings> <%--configurazione per spostare le colonne--%> <ClientSettings AllowColumnsReorder="true" ReorderColumnsOnClient="true" AllowKeyboardNavigation="true" AllowDragToGroup="True"> <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true"></Scrolling> </ClientSettings> <MasterTableView CommandItemDisplay="None" DataKeyNames="ID" AllowFilteringByColumn="True" > </MasterTableView> </telerik:RadGrid>
Eyup
Telerik team
answered
on
10 Jul 2015
1 answer
43 views
Hi,
when I selected a row on my grid (A) I load another grid (B) based on the selection.
Grid B is always open on edit mode
When I click on button located into grid A I need to find the edited items on grid B
I try to be more clear...
1. Select row on grid A
2. Open grid B in edit mode
3. Edit cells on grid B
4. Press button on grid A and find the edited cells on grid B
How can I find the edited cells on grid B?
Thank you
Kostadin
Telerik team
answered
on
10 Jul 2015
3 answers
100 views
Hello,
2 questions:
1. I am currently trying to implement a functionality that can expand/collapse all tasks in grantt view. Are there some build-in tools that can be used to implement these functionalities?
2. I also want to load the subtasks of a root task if it is expanded. So I am looking for a function that notifies if a task is expanded.
Thanks.
3 answers
47 views
The adaptive datapager is almost unusable on my android phone.
It starts off fine with
1,2,3, ....
When I click the ...(3dots) it takes me to the end. Still good.
It shows
..., 11,12,13
But when I click the ...(3dots) it only takes me to:
8,9,10, ...
How do I get back to the beginning. The way this works in useless.
Marty
Pavlina
Telerik team
answered
on
09 Jul 2015
1 answer
126 views
Hi all,
I'm trying to get field Description in Calendar List Sharepoint site, then bind them to webpart.
But when show it, the description field has a problem.
Description in Calendar List has line breark , space , etc... when show it to webpart, it has <div>, <br> ,   , : ...
Ex:
Description in Item on Calendar List :
" Time:
•9:00 a.m. – 10:00 a.m. PDT
•10:00 a.m. – 11:00 a.m. MDT
•11:00 a.m. – 12:00 p.m. CDT
•12:00 p.m. – 1:00 p.m. EDT
•1:00 p.m. – 2:00 p.m. ADT
•1:30 p.m. – 2:30 p.m. NDT "
.... and when show it to webpart :
" <div>Time:<br>•9:00 a.m. – 10:00 a.m. PDT<br>•10:00 a.m. – 11:00 a.m. MDT<br>•11:00 a.m. – 12:00 p.m. CDT<br>•12:00 p.m. – 1:00 p.m. EDT<br>•1:00 p.m. – 2:00 p.m. ADT<br>•1:30 p.m. – 2:30 p.m. NDT</div> "
How I show it exactly like Above? I don't like <div> , : ...
Sorry for my English , it's not good :|
Tks for help!
Anh Nguyen
Nencho
Telerik team
answered
on
09 Jul 2015
1 answer
81 views
I have this master page
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPageMain.master.cs" Inherits="MasterPageMain" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>Картотека паспортов ИТ</title> <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> <link rel='shortcut icon' href='~/favicon.ico' type='image/x-icon' /> <link type="text/css" rel="stylesheet" href="styles/MainStyle.css" /> <link type="text/css" rel="stylesheet" href="styles/Menu.css" /> <link type="text/css" rel="stylesheet" href="styles/MNI.css" /> <link type="text/css" rel="stylesheet" href="styles/popup.css" /> <link type="text/css" rel="stylesheet" href="styles/grid.css" /> <%--<script src="scripts\jquery-1.7.1.js" type="text/javascript" charset="windows-1251"></script>--%> <script type="text/javascript"> </script> <style type="text/css"> #suckertree1 { width: 207px; } </style></head><%--<body bgcolor="#F0F8FF">--%><body style="padding: 0; margin: 0; height: 100%; border: black 0 solid;"> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" EnableScriptGlobalization="true" EnablePartialRendering="true" AsyncPostBackTimeout="36000" EnableScriptLocalization="true" runat="server"> <Services> </Services> </asp:ScriptManager> <%--<script type="text/javascript" charset="windows-1251" src="scripts\menu.js"></script>--%> <cc1:AlwaysVisibleControlExtender ID="AlwaysVisibleControlExtender3" TargetControlID="top" runat="server" VerticalSide="Top" VerticalOffset="0" HorizontalOffset="0" ScrollEffectDuration=".1"> </cc1:AlwaysVisibleControlExtender> <asp:Panel ID="top" runat="server"> <table width="100%" cellpadding="0" cellspacing="0" border="0" style="vertical-align: middle; padding: 0; background-color: #f0f0f0; min-width: 1024px"> <tr> <td align="left" valign="middle" style="width: 50%; vertical-align: middle; border-bottom: 5px solid #A5BABB; padding: 0;"> <asp:ImageButton ID="imgShowHide" Style="vertical-align: middle;" runat="server" OnClick="ButtonFilterClick" ToolTip="Скрыть боковую панель" ImageUrl="images\back.png" Visible="false" /> <asp:Label ID="lblTitleHeader" ForeColor="#888888" Style="vertical-align: middle; text-align: left; font-family: Calibri; font-style: normal;" runat="server" Font-Size="20" Text="TEST"></asp:Label> </td> <td align="right" valign="middle" style="vertical-align: middle; border-bottom: 5px solid #A5BABB; padding: 0; text-align: right;"> <asp:Label runat="server" ID="lblLoginUser" ForeColor="#888888" Style="vertical-align: middle; font-family: Calibri; font-style: normal; padding-bottom: 11pt" Font-Size="10"></asp:Label> </td> <td style="width: 2%; vertical-align: middle; border-bottom: 5px solid #A5BABB; padding: 0;"> <asp:LinkButton ID="SuperButton1" OnClick="Button1_Click" runat="server"> <asp:Image ID="imgExit" runat="server" ToolTip="Выход" ImageUrl="~/images/exit.png" Height="32" /> </asp:LinkButton> </td> </tr> </table> </asp:Panel> <cc1:AlwaysVisibleControlExtender ID="AlwaysVisibleControlExtender1" TargetControlID="menu" runat="server" VerticalSide="Top" VerticalOffset="38" HorizontalSide="Left" HorizontalOffset="0"> </cc1:AlwaysVisibleControlExtender> <asp:Panel ID="menu" runat="server" Style="vertical-align: text-top; width: 205px; border-right: 5px solid #A5BABB; padding: 0; background-color: #f0f0f0; z-index:999999;" > <telerik:RadMenu ID="rmMain" runat="server" Flow="Vertical" Width="205px" OnItemClick="rmMain_ItemClick" EnableRoundedCorners="true" EnableShadows="true" BackColor="ControlLightLight" Skin="Office2007" BorderColor="ControlLight" CssClass="mainMenu"> <Items> <telerik:RadMenuItem Text="text1" Value="text1" PostBack="true" runat="server" BackColor="ControlLightLight" CssClass="mainMenu" FocusedCssClass="mainMenuFocused"> </telerik:RadMenuItem> <telerik:RadMenuItem Text="text2" Value="text2" PostBack="true" runat="server" BackColor="ControlLightLight" CssClass="mainMenu" FocusedCssClass="mainMenuFocused"> </telerik:RadMenuItem> <telerik:RadMenuItem Text="text3" Value="text3" PostBack="true" runat="server" BackColor="ControlLightLight" CssClass="mainMenu" FocusedCssClass="mainMenuFocused"> </telerik:RadMenuItem> </Items> </telerik:RadMenu> <div id="lineHR1" runat="server" style="height: 5px; background-color: #A5BABB; width: 100%; vertical-align: top; margin-bottom: 5px; margin-top: 0px; padding-bottom: 0px;"> </div> <%--<hr id="lineHR1" runat="server" style="height: 5px; color: #A5BABB; width: 100%; vertical-align: top; margin-bottom: 0px; margin-top: 0px; padding-bottom: 0px;"/>--%> <asp:ContentPlaceHolder ID="C2" runat="server"> </asp:ContentPlaceHolder> <div id="lineHR2" runat="server" style="height: 5px; background-color: #A5BABB; width: 100%; vertical-align: top; margin-bottom: 5px; margin-top: 5px; padding-bottom: 0px;" visible="false"> </div> <asp:ContentPlaceHolder ID="C3" runat="server"> </asp:ContentPlaceHolder> <div id="lineHR3" runat="server" style="height: 5px; background-color: #A5BABB; width: 100%; vertical-align: top; margin-bottom: 5px; margin-top: 5px; padding-bottom: 0px;" visible="false"> </div> <asp:ContentPlaceHolder ID="C4" runat="server"> </asp:ContentPlaceHolder> </asp:Panel> <table id="Table1" runat="server" style="vertical-align: text-top; position: absolute; top: 38px; left: 210px; overflow: hidden; padding: 0; border-collapse: collapse;" border="0"> <tr> <%--<td runat="server" id="t" valign="top" style="vertical-align: text-top; width: 205px; background-color: #f0f0f0; border-right: 5px solid #A5BABB; padding: 0;"> <asp:TextBox ID="T1" Style="visibility: hidden;" Width="199px" runat="server"></asp:TextBox> </td>--%> <td valign="top" style="vertical-align: text-top; padding: 0; height: 100%;"> <asp:Panel ID="pnl1" runat="server" Height="100%" Width="100%" HorizontalAlign="Left" ScrollBars="None"> <asp:ContentPlaceHolder ID="C1" runat="server"> </asp:ContentPlaceHolder> </asp:Panel> </td> </tr> </table> <%--Ошибки--%> <asp:Button ID="btnErr_Main" runat="server" Style="display: none" /> <cc1:ModalPopupExtender ID="mpeError_Main" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlError_Main" TargetControlID="btnErr_Main" BehaviorID="bError_Main" RepositionMode="RepositionOnWindowResizeAndScroll"> </cc1:ModalPopupExtender> <div id="pnlError_Main" runat="server" style="display: none; width: 500px; height: 120px;" class="popup_Container"> <asp:UpdatePanel ID="upError_Main" runat="server" UpdateMode="Always"> <ContentTemplate> <asp:Panel ID="pnlErrorHeader_Main" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="pnl7" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td style="width: 25px"> <asp:Image ID="imgErrorTitle_Main" runat="server" ImageUrl="~/images/warning.png" /> </td> <td valign="middle"> <asp:Label ID="lblErrorTitle_Main" runat="server" Text=""></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel ID="pnl8" runat="server" CssClass="PUTitlebarRight" onclick="$find('bError_Main').hide();"> </asp:Panel> <div style="text-align: center; width: 100%"> <table style="width: 95%; vertical-align: middle; text-align: left;" cellpadding="10px" cellspacing="2px" border="0"> <tr> <td class="lblHeader"> <asp:Label ID="lblErrorText_Main" runat="server" Text="" CssClass="LabelError"></asp:Label> </td> </tr> </table> </div> </asp:Panel> </ContentTemplate> </asp:UpdatePanel> </div> <%--!Ошибки--%> </form></body></html>RadGrid added to the page
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPageMain.master" AutoEventWireup="true" CodeFile="mniArchive.aspx.cs" Inherits="controlMNI_mniArchive" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="t" %><%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="act" %><asp:Content ID="Content1" ContentPlaceHolderID="C1" runat="Server"> <script src="../scripts/jquery-1.7.1.js" type="text/javascript"></script> <script src="../scripts/mni_Archive.js" type="text/javascript"></script> <script type="text/javascript"> $(window).resize(mniArchiveResize); </script> <t:RadAjaxManager ID="ram" runat="server"> <AjaxSettings> <t:AjaxSetting AjaxControlID="rgMNI"> <UpdatedControls> <t:AjaxUpdatedControl ControlID="rgMNI" LoadingPanelID="ralp" /> <t:AjaxUpdatedControl ControlID="rtbExt_Sticker" /> </UpdatedControls> </t:AjaxSetting> <t:AjaxSetting AjaxControlID="rbtnFilter"> <UpdatedControls> <t:AjaxUpdatedControl ControlID="rgMNI" LoadingPanelID="ralp" /> </UpdatedControls> </t:AjaxSetting> <t:AjaxSetting AjaxControlID="rbtnUnFilter"> <UpdatedControls> <t:AjaxUpdatedControl ControlID="rgMNI" LoadingPanelID="ralp" /> </UpdatedControls> </t:AjaxSetting> <t:AjaxSetting AjaxControlID="btnMNIInfo"> <UpdatedControls> <t:AjaxUpdatedControl ControlID="rgInfo_ExtRet" /> </UpdatedControls> </t:AjaxSetting> <t:AjaxSetting AjaxControlID="rcbExt_MNIType"> <UpdatedControls> <t:AjaxUpdatedControl ControlID="rcbExt_MNIType" /> </UpdatedControls> </t:AjaxSetting> <t:AjaxSetting AjaxControlID="rbtnUpload"> <UpdatedControls> <t:AjaxUpdatedControl ControlID="rauUpload" LoadingPanelID="ralp" /> </UpdatedControls> </t:AjaxSetting> <t:AjaxSetting AjaxControlID="ram"> <UpdatedControls> <t:AjaxUpdatedControl ControlID="rcbExt_MNIType" /> <t:AjaxUpdatedControl ControlID="rcbExt_UPFR" /> <t:AjaxUpdatedControl ControlID="rdpExt_DateExt" /> <t:AjaxUpdatedControl ControlID="rcbExt_SubDiv" /> <t:AjaxUpdatedControl ControlID="rcbExt_User" /> <t:AjaxUpdatedControl ControlID="rntbExt_Count" /> <t:AjaxUpdatedControl ControlID="rcbExt_Category" /> <t:AjaxUpdatedControl ControlID="rtbExt_Sticker" /> <t:AjaxUpdatedControl ControlID="rtbExt_assign" /> <t:AjaxUpdatedControl ControlID="rtbExt_Note" /> <t:AjaxUpdatedControl ControlID="rcbExtUPFR_MNIType" /> <t:AjaxUpdatedControl ControlID="rcbExtUPFR_SubDiv" /> <t:AjaxUpdatedControl ControlID="rcbExtUPFR_User" /> <t:AjaxUpdatedControl ControlID="rdpExtUPFR_DateExt" /> <t:AjaxUpdatedControl ControlID="rntbExtUPFR_Count" /> <t:AjaxUpdatedControl ControlID="rtbExtUPFR_Sticker" /> <t:AjaxUpdatedControl ControlID="rtbExtUPFR_assign" /> <t:AjaxUpdatedControl ControlID="rbtnExtUPFR_buList" /> <t:AjaxUpdatedControl ControlID="rauUpload" /> <%-- <t:AjaxUpdatedControl ControlID="rgMNI" />--%> </UpdatedControls> </t:AjaxSetting> </AjaxSettings> </t:RadAjaxManager> <t:RadAjaxLoadingPanel ID="ralp" runat="server" Skin="Office2007" MinDisplayTime="100"> </t:RadAjaxLoadingPanel> <asp:Panel ID="pnlMain" runat="server" Width="1100px" Height="100%" Style="margin-left: 5pt; margin-top: 3pt;"> <asp:Label ID="Label4" runat="server" CssClass="mainControlMNI" Text="Выберите журнал"></asp:Label> <table cellpadding="10px"> <tr> <td valign="middle"> <t:RadButton ID="RadButton1" runat="server" PostBackUrl="~/controlMNI/mniArchive.aspx?Page=MNI" Text="" AutoPostBack="true" Skin="Office2007" Font-Size="14pt" Font-Bold="true" Font-Names="Times New Roman" Height="128px" Width="128px" ToolTip="Журнал учета и выдачи лазерных дисков и дискет"> <Image ImageUrl="../images/128/disk.png" IsBackgroundImage="true" /> </t:RadButton> </td> <td> <t:RadButton ID="RadButton2" runat="server" PostBackUrl="~/controlMNI/mniArchive.aspx?Page=USB" Text="" Skin="Office2007" Font-Size="14pt" Font-Bold="true" Font-Names="Times New Roman" Height="128px" Width="128px" ToolTip="Журнал учета и выдачи flash-накопителей и внешних НЖМД"> <Image ImageUrl="../images/128/usb.png" IsBackgroundImage="true" /> </t:RadButton> </td> <td> <t:RadButton ID="RadButton3" runat="server" PostBackUrl="~/controlMNI/mniArchive.aspx?Page=TAPE" Text="" Skin="Office2007" Font-Size="14pt" Font-Bold="true" Font-Names="Times New Roman" Height="128px" Width="128px" ToolTip="Журнал учета и выдачи магнитных лент"> <Image ImageUrl="../images/128/tape.png" IsBackgroundImage="true" /> </t:RadButton> </td> </tr> <tr class="mainControlMNI"> <td> <t:RadButton ID="RadButton4" runat="server" PostBackUrl="~/controlMNI/mniArchive.aspx?Page=SC" Text="" Skin="Office2007" Font-Size="14pt" Font-Bold="true" Font-Names="Times New Roman" Height="128px" Width="128px" ToolTip="Журнал учета и выдачи смарт-карт"> <Image ImageUrl="../images/128/sc.png" IsBackgroundImage="true" /> </t:RadButton> </td> <td> <t:RadButton ID="RadButton5" runat="server" PostBackUrl="~/controlMNI/mniArchive.aspx?Page=MNKI" Text="" Skin="Office2007" Font-Size="14pt" Font-Bold="true" Font-Names="Times New Roman" Height="128px" Width="128px" ToolTip="Журнал учета и выдачи МНКИ"> <Image ImageUrl="../images/128/key.png" IsBackgroundImage="true" /> </t:RadButton> </td> <td> <t:RadButton ID="RadButton6" runat="server" PostBackUrl="~/controlMNI/mniArchive.aspx?Page=REESTR" Text="" Skin="Office2007" Font-Size="14pt" Font-Bold="true" Font-Names="Times New Roman" Height="128px" Width="128px" ToolTip="Журнал реестров"> <Image ImageUrl="../images/128/byreestr.png" IsBackgroundImage="true" /> </t:RadButton> </td> </tr> </table> </asp:Panel> <table class="datatable" width="1200px" style="margin-left: 0; margin-top: 0;" border="0"> <tr class="datarow1" style="width: 100%"> <td style="width: 100%; vertical-align: middle"> <t:RadMenu ID="rmTop" runat="server" Flow="Horizontal" Skin="Office2007" EnableRoundedCorners="true" EnableSelection="false" BackColor="ControlLightLight" BorderColor="ControlLight" OnItemClick="rmTop_ItemClick" OnClientItemClicking="onClicking" Visible="false" CssClass="mainMenu"> <Items> <t:RadMenuItem Text="Журналы" ToolTip="" CssClass="mainMenu" FocusedCssClass="mainMenuFocused" Value="journal" PostBack="false" runat="server"> <Items> <t:RadMenuItem Text="Журнал учета и выдачи лазерных дисков и дискет" ToolTip="Переход в журнал учета и выдачи лазерных дисков и дискет" Value="mniArchive_MNI" runat="server" PostBack="false" CssClass="mainSubMenu" NavigateUrl="~/controlMNI/mniArchive.aspx?Page=MNI" ImageUrl="~/images/16/disk.png"> </t:RadMenuItem> <t:RadMenuItem Text="Журнал учета и выдачи flash-накопителей и внешних НЖМД" ToolTip="Переход в журнал учета и выдачи flash-накопителей и внешних НЖМД" Value="mniArchive_USB" runat="server" PostBack="true" CssClass="mainSubMenu" NavigateUrl="~/controlMNI/mniArchive.aspx?Page=USB" ImageUrl="~/images/16/usb.png"> </t:RadMenuItem> <t:RadMenuItem Text="Журнал учета и выдачи магнитных лент" ToolTip="Переход в журнал учета и выдачи магнитных лент" Value="mniArchive_TAPE" runat="server" PostBack="true" CssClass="mainSubMenu" NavigateUrl="~/controlMNI/mniArchive.aspx?Page=TAPE" ImageUrl="~/images/16/tape.png"> </t:RadMenuItem> <t:RadMenuItem Text="Журнал учета и выдачи смарт-карт" ToolTip="Переход в журнал учета и выдачи смарт-карт" Value="mniArchive_SC" runat="server" PostBack="true" CssClass="mainSubMenu" NavigateUrl="~/controlMNI/mniArchive.aspx?Page=SC" ImageUrl="~/images/16/sc.png"> </t:RadMenuItem> <t:RadMenuItem Text="Журнал учета и выдачи МНКИ" ToolTip="Переход в журнал учета и выдачи МНКИ" Value="mniArchive_MNKI" runat="server" PostBack="true" CssClass="mainSubMenu" NavigateUrl="~/controlMNI/mniArchive.aspx?Page=MNKI" ImageUrl="~/images/16/key.png"> </t:RadMenuItem> </Items> </t:RadMenuItem> <t:RadMenuItem Text="Действия" ToolTip="" CssClass="mainMenu" FocusedCssClass="mainMenuFocused" Value="action" PostBack="false" runat="server"> <Items> <t:RadMenuItem Text="Возврат" ToolTip="Показать форму возврата МНИ" Value="action_RET" runat="server" PostBack="true" CssClass="mainSubMenu" ImageUrl="~/images/16/back.png"> </t:RadMenuItem> <t:RadMenuItem Text="Выдача" ToolTip="Показать форму выдачи МНИ" Value="action_EXT" runat="server" PostBack="true" CssClass="mainSubMenu" ImageUrl="~/images/16/forward.png"> </t:RadMenuItem> <t:RadMenuItem Text="Передать на уничтожение" ToolTip="Передать выделенные МНИ на уничтожение" Value="action_DESTR" runat="server" PostBack="true" CssClass="mainSubMenu" ImageUrl="~/images/16/d.png"> </t:RadMenuItem> </Items> </t:RadMenuItem> <t:RadMenuItem Text="Экспорт" ToolTip="" CssClass="mainMenu" FocusedCssClass="mainMenuFocused" Value="export" PostBack="false" runat="server"> </t:RadMenuItem> <t:RadMenuItem Text="Свободные МНИ" ToolTip="" CssClass="mainMenu" FocusedCssClass="mainMenuFocused" Value="freemni" PostBack="false" runat="server"> </t:RadMenuItem> </Items> </t:RadMenu> </td> </tr> <tr class="datarow2"> <td style="padding-top: 3pt; padding-bottom: 3pt; text-align: left"> <asp:Label ID="lblTitleJournal" runat="server" Font-Bold="true" Font-Names="Times New Roman CYR" Font-Size="16pt"></asp:Label> </td> </tr> <tr class="datarow3"> <td><t:RadGrid ID="rgMNI" runat="server" Visible="true" Skin="Office2007" AutoGenerateColumns="false" Width="1200px" Style="margin-left: 0; margin-top: 0;" AllowMultiRowSelection="true" GridLines="None" AllowSorting="true" AllowPaging="true" OnNeedDataSource="rgMNI_NeedDataSource" OnItemDataBound="rgMNI_ItemDataBound" OnSortCommand="rgMNI_SortCommand"> <ClientSettings> <Scrolling AllowScroll="true" UseStaticHeaders="True" ScrollHeight="510" /> <Resizing AllowResizeToFit="true" /> <Selecting AllowRowSelect="true" /> <ClientEvents OnRowSelected="rg_RowSelected" OnRowDeselected="rg_RowDeselected" OnRowSelecting="rg_RowSelecting" /> </ClientSettings> <PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" /> <MasterTableView runat="server" AllowPaging="true" AllowSorting="true" PageSize="100" AllowMultiColumnSorting="true" NoDetailRecordsText="Нет данных для отображения" NoMasterRecordsText="Нет данных для отображения" culture="ru-RU" GridLines="Vertical" BorderWidth="0" Width="100%" CommandItemDisplay="None" TableLayout="Fixed"> <NoRecordsTemplate> <div>Нет данных для отображения</div> </NoRecordsTemplate> <HeaderStyle CssClass="gridHeader1lvl" Font-Bold="true" /> <ItemStyle CssClass="gridItem1lvl" /> <PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" /> <Columns> <t:GridClientSelectColumn UniqueName="gcsc"> <HeaderStyle Width="20" /> <ItemStyle Width="20" /> </t:GridClientSelectColumn> <t:GridTemplateColumn UniqueName="rtcbtnMNIinfo" InitializeTemplatesFirst="false"> <ItemTemplate> <asp:ImageButton ID="btnMNIInfo" runat="server" ImageUrl="~/images/24/info.png" ToolTip="Карточка МНИ" OnClick="btnMNIInfo_Click" /> </ItemTemplate> <ItemStyle HorizontalAlign="Center" Width="20" VerticalAlign="Middle" /> <HeaderStyle Width="20" /> </t:GridTemplateColumn> <t:GridBoundColumn DataField="IDMNIARCH" HeaderText="IDMNIARCH" UniqueName="IDMNIARCH" Display="false"> </t:GridBoundColumn> <t:GridBoundColumn DataField="IDTYPE" HeaderText="IDTYPE" UniqueName="IDTYPE" Display="false"> </t:GridBoundColumn> <t:GridBoundColumn DataField="state_text" HeaderText="state_text" UniqueName="state_text" Display="false"> </t:GridBoundColumn> <t:GridImageColumn DataType="System.String" DataImageUrlFields="state" DataImageUrlFormatString="~/images/MNI/state/{0}.png" HeaderTooltip="Статус МНИ" AlternateText="Статус" HeaderText="Ст." ImageAlign="Middle" DataAlternateTextField="state_text" ImageHeight="24px" ImageWidth="24px"> <ItemStyle Width="30" HorizontalAlign="Center" /> <HeaderStyle Width="30" HorizontalAlign="Center" /> </t:GridImageColumn> <t:GridImageColumn DataType="System.String" DataImageUrlFields="ICON" DataImageUrlFormatString="~/images/MNI/{0}.png" UniqueName="ICON" HeaderTooltip="Тип МНИ" HeaderText="Тип" DataAlternateTextField="name" ImageAlign="Middle" DataAlternateTextFormatString="{0}" ImageHeight="24px" ImageWidth="24px"> <ItemStyle Width="30" HorizontalAlign="Center" /> <HeaderStyle Width="30" HorizontalAlign="Center" /> </t:GridImageColumn> <t:GridBoundColumn DataField="category" HeaderText="Кат." UniqueName="category" ConvertEmptyStringToNull="true" HeaderTooltip="Категория" EmptyDataText="-"> <ItemStyle HorizontalAlign="Center" Width="50" Wrap="true" /> <HeaderStyle HorizontalAlign="Center" Width="50" Wrap="true" /> </t:GridBoundColumn> <t:GridBoundColumn DataField="state" HeaderText="" UniqueName="state" Display="false"> <ItemStyle Width="30" HorizontalAlign="Center" /> <HeaderStyle Width="30" HorizontalAlign="Center" /> </t:GridBoundColumn> <t:GridBoundColumn DataField="regnmbr" HeaderText="Учетный номер" UniqueName="regnmbr"> <ItemStyle Width="120" HorizontalAlign="Center" /> <HeaderStyle Width="120" HorizontalAlign="Center" /> </t:GridBoundColumn> <t:GridBoundColumn DataType="System.DateTime" DataFormatString="{0:dd/MM/yyyy}" DataField="DATEreg" HeaderText="Дата учета" UniqueName="DATEreg"> <ItemStyle Width="70" HorizontalAlign="Center" /> <HeaderStyle Width="70" HorizontalAlign="Center" /> </t:GridBoundColumn> <t:GridBoundColumn DataField="UPFR_Dev" HeaderText="УПФР \ Структурное подразделение" UniqueName="UPFR_Dev" ConvertEmptyStringToNull="true" EmptyDataText="-"> <ItemStyle Width="200" HorizontalAlign="Center" /> <HeaderStyle Width="200" HorizontalAlign="Center" /> </t:GridBoundColumn> <t:GridBoundColumn DataField="fio" DataFormatString="{0}" HeaderText="ФИО получателя" UniqueName="fio" ConvertEmptyStringToNull="true" EmptyDataText="-"> <ItemStyle /> <HeaderStyle HorizontalAlign="Center" /> </t:GridBoundColumn> <t:GridBoundColumn DataType="System.DateTime" DataFormatString="{0:dd/MM/yyyy}" DataField="DATEExt" HeaderText="Дата выдачи" UniqueName="DATEExt" ConvertEmptyStringToNull="true" EmptyDataText="-"> <ItemStyle Width="70" HorizontalAlign="Center" /> <HeaderStyle Width="70" HorizontalAlign="Center" /> </t:GridBoundColumn> <t:GridImageColumn DataType="System.String" DataImageUrlFields="bylist" DataImageUrlFormatString="~/images/24/bylist{0}.png" HeaderTooltip="Выдан по реестру" HeaderText="Р." ImageAlign="Middle" ImageHeight="24px" UniqueName="bylist" ImageWidth="24px"> <ItemStyle Width="30" HorizontalAlign="Center" /> <HeaderStyle Width="30" HorizontalAlign="Center" /> </t:GridImageColumn> <t:GridBoundColumn DataField="IDEXT" HeaderText="IDEXT" UniqueName="IDEXT" Display="false"> </t:GridBoundColumn> </Columns> </MasterTableView> <HeaderStyle Font-Bold="true" Font-Size="13pt" Font-Names="Times New Roman, sans-serif" /> </t:RadGrid> </td> </tr> </table> <asp:HiddenField ID="hfSelectedMNI" runat="server" Value="" /> <asp:HiddenField ID="hfSelectedSD" runat="server" Value="" /> <asp:HiddenField ID="hfJournal" runat="server" Value="" /></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="C2" runat="Server"> <div runat="server" id="buttons" style="text-align: center"> <table cellpadding="1"> <tr> <td> <asp:Label ID="Label10" runat="server" CssClass="lblHeader" Text="Загрузить архив МНИ" Style="padding-bottom: 5px"></asp:Label> </td> </tr> <tr> <td> <t:RadAsyncUpload ID="rUpload" runat="server" ControlObjectsVisibility="None" MultipleFileSelection="Disabled" AllowedFileExtensions=".csv" EnableFileInputSkinning="false" EnableTheming="false" TemporaryFolder="../Templates/tmp" TargetFolder="../Import" OverwriteExistingFiles="true" ReadOnlyFileInputs="true" AutoAddFileInputs="false" OnClientFileUploaded="fileUploaded" OnClientValidationFailed="validationFailed" OnClientFileUploadRemoved="fileUploadRemoved" InputSize="16" Width="180px"> <Localization Select="Выбрать" Remove="Изменить выбор" Cancel="Отмена" /> <FileFilters> <t:FileFilter Description="Текстовый с разделителем (*.csv)" Extensions=".csv" /> </FileFilters> </t:RadAsyncUpload> </td> </tr> <tr> <td> <t:RadButton ID="rbtnUpload" runat="server" Text="" AutoPostBack="true" Skin="Office2007" Font-Size="14pt" Font-Bold="true" Font-Names="Times New Roman" Height="48px" Style="display: none;" Width="48px" ToolTip="Загрузить архив в БД" OnClick="rbtnUpload_Click"> <Image ImageUrl="../images/48/upload.png" IsBackgroundImage="true" /> </t:RadButton> </td> </tr> </table> <t:RadProgressManager ID="RPM" runat="server" BackColor="#f9d8a6" ForeColor="#825208" Skin="Office2007" /> <t:RadProgressArea runat="server" ID="RPA" Width="100%" Skin="Office2007" Font-Names="Times New Roman" Font-Size="10pt" Culture="ru-RU" BackColor="#f9d8a6" ForeColor="#825208"> <Localization Cancel="Отмена" Uploaded="Прочитано: " Total="Всего: " ElapsedTime="Время загрузки: " /> </t:RadProgressArea> </div> <div runat="server" id="filters"> <asp:UpdatePanel ID="upFilter" runat="server"> <ContentTemplate> <table width="100%" style="text-align: center"> <tr> <td align="center"> <asp:Label ID="Label1" runat="server" Text="Фильтры" CssClass="filterHeaderControlMNI"></asp:Label> </td> </tr> <tr> <td align="center"> <t:RadTextBox ID="rtbFilter" runat="server" Width="99%" CssClass="filterTextControlMNI"> </t:RadTextBox> </td> </tr> <tr> <td align="left"> <asp:CheckBox ID="chbFilterDate" runat="server" Text="Дата выдачи" CssClass="filterHeaderControlMNI"></asp:CheckBox> </td> </tr> <tr> <td align="left"> <asp:Label ID="Label2" runat="server" Text="С" Width="20" CssClass="filterHeaderControlMNI"></asp:Label> <t:RadDatePicker ID="rdpFilterBegin" runat="server" CssClass="filterTextControlMNI" Skin="Office2007" Culture="ru-RU" Enabled="true"> <DateInput ID="DateInput1" DateFormat="dd.MM.yyyy" runat="server" Style="text-align: center" ReadOnly="true"> </DateInput> <ClientEvents OnPopupOpening="chbFilterDate_onclick" /> </t:RadDatePicker> </td> </tr> <tr> <td align="left"> <asp:Label ID="Label3" runat="server" Text="По" Width="20" CssClass="filterHeaderControlMNI"></asp:Label> <t:RadDatePicker ID="rdpFilterEnd" runat="server" CssClass="filterTextControlMNI" Skin="Office2007" Culture="ru-RU" Enabled="true"> <DateInput ID="DateInput2" DateFormat="dd.MM.yyyy" runat="server" Style="text-align: center" ReadOnly="true"> </DateInput> <ClientEvents OnPopupOpening="chbFilterDate_onclick" /> </t:RadDatePicker> </td> </tr> <tr> <td align="left"> <asp:Label ID="Label5" runat="server" Text="Статус" CssClass="filterHeaderControlMNI"></asp:Label> </td> </tr> <tr> <td align="center"> <t:RadComboBox ID="rcbState" runat="server" Width="99%" CssClass="filterTextControlMNI" Skin="Office2007" OnClientDropDownOpening="coloringCombobox"> <Items> <t:RadComboBoxItem Text="Все" Value="All" Selected="true" /> <t:RadComboBoxItem Text="Учтенный свободный" Value="Uch" ImageUrl="../images/MNI/state/16/2.png" /> <t:RadComboBoxItem Text="Выдан в УПФР" Value="extUPFR" ImageUrl="../images/MNI/state/16/3.png" /> <t:RadComboBoxItem Text="Выдан пользователю" Value="extUser" ImageUrl="../images/MNI/state/16/4.png" /> <t:RadComboBoxItem Text="Готов к выдаче" Value="extKey" ImageUrl="../images/MNI/state/16/5.png" /> <t:RadComboBoxItem Text="Возврат" Value="ret" ImageUrl="../images/MNI/state/16/6.png" /> <t:RadComboBoxItem Text="На уничтожение" Value="toDes" ImageUrl="../images/MNI/state/16/7.png" /> <t:RadComboBoxItem Text="Уничтоженные" Value="Des" ImageUrl="../images/MNI/state/16/8.png" /> </Items> </t:RadComboBox> </td> </tr> <tr> <td align="left"> <asp:Label ID="Label6" runat="server" Text="Тип МНИ" CssClass="filterHeaderControlMNI"></asp:Label> </td> </tr> <tr> <td align="center"> <t:RadComboBox ID="rcbTypeMNI" runat="server" Width="99%" CssClass="filterTextControlMNI" EmptyMessage="" Skin="Office2007" OnClientDropDownOpening="coloringCombobox"> </t:RadComboBox> </td> </tr> <tr id="trUPFR_lbl" runat="server"> <td align="left"> <asp:Label ID="Label7" runat="server" Text="Территориальный орган" CssClass="filterHeaderControlMNI"></asp:Label> </td> </tr> <tr id="trUPFR" runat="server"> <td align="center"> <t:RadComboBox ID="rcbUPFR" runat="server" Width="99%" CssClass="filterTextControlMNI" EmptyMessage="" Skin="Office2007" OnClientDropDownOpening="coloringCombobox"> </t:RadComboBox> </td> </tr> <tr> <td> <t:RadButton ID="rbtnFilter" runat="server" Text="Применить" OnClick="rbtnFilter_Click"> </t:RadButton> <t:RadButton ID="rbtnUnFilter" runat="server" Text="Сбросить" OnClick="rbtnFilter_Click"> </t:RadButton> </td> </tr> </table> </ContentTemplate> </asp:UpdatePanel> </div></asp:Content><asp:Content ID="Content3" ContentPlaceHolderID="C3" runat="Server"> <%--Информация о МНИ--%> <asp:Button ID="btnMNIinfo" runat="server" Style="display: none" /> <act:ModalPopupExtender ID="mpeMNIinfo" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlMNIinfo" TargetControlID="btnMNIinfo" BehaviorID="bMNIinfo" RepositionMode="RepositionOnWindowResizeAndScroll"> </act:ModalPopupExtender> <div id="pnlMNIinfo" runat="server" style="display: none; width: 650px; height: 460px;" class="popup_Container"> <asp:Panel ID="pnlMNIinfoHeader" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="Panel5" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td valign="middle"> <asp:Label ID="lblMNIinfoTitle" runat="server" Text="Карточка МНИ"></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel ID="Panel6" runat="server" CssClass="PUTitlebarRight" onclick="$('#ctl00_C1_hfSelectedMNI').val('');$find('bMNIinfo').hide();"> </asp:Panel> </asp:Panel> <div style="text-align: center; width: 100%"> <t:RadTabStrip ID="rtsMNIinfo" runat="server" Skin="Office2007" MultiPageID="rmpMNIinfo" Align="Justify" SelectedIndex="0"> <Tabs> <t:RadTab Text="Основные" Font-Bold="true" Selected="True"> </t:RadTab> <t:RadTab Text="Выдача/Возврат" Font-Bold="true"> </t:RadTab> </Tabs> </t:RadTabStrip> <t:RadMultiPage ID="rmpMNIinfo" runat="server" SelectedIndex="0" Font-Names="Times New Roman"> <t:RadPageView ID="rpvMNIinfo_main" runat="server"> <asp:UpdatePanel ID="upmainMNIinfo" runat="server"> <ContentTemplate> <table style="width: 95%; vertical-align: middle; text-align: left;" cellpadding="10px" cellspacing="2px" border="0"> <tr> <td class="lblHeader" style="width: 250px;"> <asp:Label ID="lblMNIinfo_State" runat="server" Text="Статус"></asp:Label> </td> <td align="center"> <t:RadBinaryImage ID="rbiMNIinfo_State" runat="server" Height="24" Width="24" /> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblMNIinfo_Regnmbr" runat="server" Text="Учетный номер"></asp:Label> </td> <td valign="middle"> <asp:Label ID="lblMNIinfo_Regnmbr_val" runat="server" CssClass="lblBorder" Width="100%"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblMNIinfo_type" runat="server" Text="Тип МНИ"></asp:Label> </td> <td> <asp:Label ID="lblMNIinfo_type_val" runat="server" CssClass="lblBorder" Width="100%"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblMNIinfo_category" runat="server" Text="Категория МНИ"></asp:Label> </td> <td> <asp:Label ID="lblMNIinfo_category_val" runat="server" CssClass="lblBorder" Width="100%"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblMNIinfo_datereg" runat="server" Text="Дата учета"></asp:Label> </td> <td> <asp:Label ID="lblMNIinfo_datereg_val" runat="server" CssClass="lblBorder" Width="100%"></asp:Label> </td> </tr> <tr style="height: 80px"> <td class="lblHeader"> <asp:Label ID="lblMNIinfo_note" runat="server" Text="Примечание"></asp:Label> </td> <td> <asp:TextBox ID="lblMNIinfo_note_val" runat="server" Width="100%" Height="100%" ReadOnly="true" TextMode="MultiLine" Style="display: none;"></asp:TextBox> <t:RadListBox ID="rlbMNIInfo_note_val" runat="server" SelectionMode="Single" Width="100%" CssClass="lblBorder" Height="100%"> <ItemTemplate> <span style="font-weight: bold"> <%# DataBinder.Eval(Container, "Value")%></span> <span> <%# DataBinder.Eval(Container, "Text")%></span> </ItemTemplate> </t:RadListBox> </td> </tr> </table> </ContentTemplate> </asp:UpdatePanel> </t:RadPageView> <t:RadPageView ID="rpvMNIinfo_extret" runat="server"> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <table style="width: 95%; vertical-align: middle; text-align: left;" cellpadding="3px" cellspacing="2px" border="0"> <tr> <td class="lblHeader" style="width: 180px;"> <asp:Label ID="lblInfo_UPFR" runat="server" Text="УПФР/Подразделение"></asp:Label> </td> <td style="width: 420px;"> <asp:Label ID="lblInfo_UPFR_val" runat="server" CssClass="lblBorder" Width="95%" Height="60px"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblInfo_Giver" runat="server" Text="ФИО получившего"></asp:Label> </td> <td> <asp:Label ID="lblInfo_Giver_val" runat="server" CssClass="lblBorder" Width="95%" Height="40px"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblInfo_UserExt" runat="server" Text="ФИО пользователя"></asp:Label> </td> <td valign="middle"> <asp:Label ID="lblInfo_UserExt_val" runat="server" CssClass="lblBorder" Width="95%" Height="40px"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblInfo_DateExt" runat="server" Text="Дата выдачи"></asp:Label> </td> <td> <asp:Label ID="lblInfo_DateExt_val" runat="server" CssClass="lblBorder" Width="95%"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblInfo_AssignExt" runat="server" Text="Цель выдачи"></asp:Label> </td> <td> <asp:Label ID="lblInfo_AssignExt_val" runat="server" CssClass="lblBorder" Width="95%" Height="40px"></asp:Label> </td> </tr> <%--<tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblInfo_UserRet" runat="server" Text="ФИО вернувшего"></asp:Label> </td> <td> <asp:Label ID="lblInfo_UserRet_ret" runat="server" CssClass="lblBorder" Width="95%"></asp:Label> </td> </tr>--%> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblInfo_DateRet" runat="server" Text="Дата возврата"></asp:Label> </td> <td> <asp:Label ID="lblInfo_DateRet_val" runat="server" CssClass="lblBorder" Width="95%"></asp:Label> </td> </tr> <tr style="height: 40px"> <td class="lblHeader"> <asp:Label ID="lblInfo_AssignRet" runat="server" Text="Причина возврата"></asp:Label> </td> <td> <asp:Label ID="lblInfo_AssignRet_val" runat="server" CssClass="lblBorder" Width="95%" Height="40px"></asp:Label> </td> </tr> </table> </ContentTemplate> </asp:UpdatePanel> </t:RadPageView> </t:RadMultiPage> </div> </div> <%--!Информация о МНИ--%> <%--Выдача--%> <asp:Button ID="btnExt" runat="server" Style="display: none" /> <act:ModalPopupExtender ID="mpeExt" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlExt" TargetControlID="btnExt" BehaviorID="bExt" RepositionMode="RepositionOnWindowResizeAndScroll"> </act:ModalPopupExtender> <div id="pnlExt" runat="server" style="display: none; width: 900px; height: 450px;" class="popup_Container"> <asp:Panel ID="pnlExtHeader" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="Panel1" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td valign="middle"> <asp:Label ID="lblExtTitle" runat="server" Text="Выдача"></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel ID="Panel2" runat="server" CssClass="PUTitlebarRight" onclick="$find('bExt').hide();"> </asp:Panel> </asp:Panel> <div style="text-align: center; width: 100%;"> <table id="extData" style="height: 380px; margin-left: 5px; margin-right: 5px; text-align: left" cellpadding="2px" border="0"> <tr> <td colspan="2" class="legend">Информация о МНИ </td> <td colspan="2" class="legend">Выдача МНИ </td> </tr> <tr> <td class="lblHeader" style="width: 200px"> <asp:Label ID="lblExt_MNIType" runat="server" Text="Тип МНИ"> <%-- <asp:RequiredFieldValidator ID="rfev_Ext_MNIType" runat="server" ValidationGroup="vgExt" Display="Static" ControlToValidate="rcbExt_MNIType" ErrorMessage="*" Font-Size="Medium"></asp:RequiredFieldValidator>--%> </asp:Label> </td> <td style="width: 280px"> <t:RadComboBox ID="rcbExt_MNIType" runat="server" EmptyMessage="Выберите тип МНИ" Skin="Office2007" Width="260px" AutoPostBack="true" Height="150" EnableLoadOnDemand="true" LoadingMessage="Подождите. Данные загружаются." MaxHeight="100" ShowDropDownOnTextboxClick="true" OnClientSelectedIndexChanged="onrcbExt_MNITypeSelectedIndexChanged" OnClientDropDownOpening="onrcbExt_MNITypeDropDownOpening" OnItemsRequested="rcbExt_MNIType_ItemsRequested"> </t:RadComboBox> </td> <td class="lblHeader" style="width: 200px"> <asp:Label ID="lblExt_UPFR" runat="server" Text="Территориальный орган"> </asp:Label> </td> <td style="width: 280px"> <t:RadComboBox ID="rcbExt_UPFR" runat="server" EmptyMessage="Выберите территориальный орган" Skin="Office2007" Width="260px" AutoPostBack="true" Height="200" EnableLoadOnDemand="false" LoadingMessage="Подождите. Данные загружаются." MaxHeight="200" ShowDropDownOnTextboxClick="true" ShowMoreResultsBox="false" Filter="None" OnClientDropDownOpening="coloringExtMniCombobox" OnClientSelectedIndexChanged="onrcbExt_UPFRSelectedIndexChanged"> </t:RadComboBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="LlblExt_DateExt" runat="server" Text="Дата выдачи"> <asp:RequiredFieldValidator ID="rfev_Ext_DateExt" runat="server" ValidationGroup="vgExt" Display="Dynamic" ControlToValidate="rdpExt_DateExt" ErrorMessage="*" Font-Size="Medium"></asp:RequiredFieldValidator> </asp:Label> </td> <td> <t:RadDatePicker ID="rdpExt_DateExt" runat="server" Skin="Office2007" Width="150px"> <DateInput ID="DateInput3" DateFormat="dd.MM.yyyy" Width="150px" runat="server" Style="text-align: center;"> </DateInput> <DatePopupButton ToolTip="Выберите дату выдачи" /> </t:RadDatePicker> </td> <td class="lblHeader"> <asp:Label ID="lblExt_SubDiv" runat="server" Text="Подразделение"> </asp:Label> </td> <td> <t:RadComboBox ID="rcbExt_SubDiv" runat="server" EmptyMessage="Выберите подразделение" Skin="Office2007" Width="260px" AutoPostBack="true" Height="300px" EnableLoadOnDemand="true" EnableVirtualScrolling="true" ShowMoreResultsBox="false" LoadingMessage="Подождите. Данные загружаются." MaxHeight="100" ShowDropDownOnTextboxClick="true" NoWrap="false" Enabled="true" OnClientDropDownOpening="coloringExtMniCombobox" OnItemsRequested="rcbExt_SubDiv_ItemsRequested" OnClientSelectedIndexChanged="onrcbExt_SubDivSelectedIndexChanged"> </t:RadComboBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExt_Count" runat="server" Text="Количество"></asp:Label> </td> <td> <t:RadNumericTextBox ID="rntbExt_Count" runat="server" ShowSpinButtons="false" MinValue="1" Width="60" MaxValue="999" Style="text-align: center" Value="1" ReadOnly="true"> <NumberFormat DecimalDigits="0" /> <IncrementSettings InterceptArrowKeys="true" InterceptMouseWheel="true" Step="1" /> </t:RadNumericTextBox> </td> <td class="lblHeader"> <asp:Label ID="lblExt_User" runat="server" Text="Пользователь"> </asp:Label> </td> <td> <t:RadComboBox ID="rcbExt_User" runat="server" EmptyMessage="Выберите пользователя" Skin="Office2007" Width="260px" AutoPostBack="true" Height="200px" EnableLoadOnDemand="true" EnableVirtualScrolling="true" ShowMoreResultsBox="true" LoadingMessage="Подождите. Данные загружаются." MaxHeight="100" ShowDropDownOnTextboxClick="true" NoWrap="true" Enabled="true" OnItemsRequested="rcbExt_User_ItemsRequested" OnClientDropDownOpening="coloringExtMniCombobox" OnClientSelectedIndexChanged="onrcbExt_UserSelectedIndexChanged"> </t:RadComboBox> </td> </tr> <tr> <td class="lblHeader" rowspan="3" valign="top"> <asp:Label ID="lblExt_Sticker" runat="server" Text="Стикер"></asp:Label> </td> <td rowspan="3" valign="top"> <t:RadTextBox ID="rtbExt_Sticker" runat="server" Width="250" Height="150" TextMode="MultiLine" ReadOnly="true" Text="" EmptyMessage="Введите номера стикеров через запятую"> <ClientEvents OnValueChanged="rtbExt_Sticker_OnValueChanged" /> </t:RadTextBox> </td> <td class="lblHeader"> <asp:Label ID="Label8" runat="server" Text="Категория"> </asp:Label> </td> <td> <t:RadComboBox ID="rcbExt_Category" runat="server" EmptyMessage="Выберите категорию" Skin="Office2007" AutoPostBack="true" Width="260px" EnableLoadOnDemand="true" EnableVirtualScrolling="false" ShowMoreResultsBox="false" LoadingMessage="Подождите. Данные загружаются." MaxHeight="100" ShowDropDownOnTextboxClick="true" OnClientDropDownOpening="coloringCombobox" OnClientSelectedIndexChanged="onrcbExt_CategorySelectedIndexChanged" NoWrap="true" Enabled="true"> </t:RadComboBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExt_fiogives" runat="server" Text="ФИО получившего"></asp:Label> </td> <td> <t:RadTextBox ID="rtbExt_fiogives" runat="server" Width="250px" MaxLength="250" TextMode="SingleLine"> </t:RadTextBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExt_assign" runat="server" Text="Цель использования"></asp:Label> </td> <td> <t:RadTextBox ID="rtbExt_assign" runat="server" Height="50" Width="250" LabelWidth="0" ShowButton="false" ShouldResetWidthInPixels="true" MaxLength="250" TextMode="MultiLine"> </t:RadTextBox> </td> </tr> <tr> <td class="lblHeader" align="center"></td> <td align="center"></td> <td class="lblHeader"> <asp:Label ID="Label9" runat="server" Text="Примечание"></asp:Label> </td> <td> <t:RadTextBox ID="rtbExt_Note" runat="server" Height="50" MaxLength="250" Width="250" TextMode="MultiLine"> </t:RadTextBox> </td> </tr> </table> <div class="popup_Buttons"> <table width="100%"> <tr> <td align="left"> <asp:Button ID="btnExtOK" runat="server" Text="OK" Width="90px" OnClientClick="return validatorExt();" OnClick="btnExtOK_Click" ValidationGroup="vgExt" /> </td> <td align="right"> <asp:Button ID="btnExtCancel" runat="server" Text="Отмена" Width="90px" OnClientClick="$find('bExt').hide();return false;" /> </td> </tr> </table> </div> </div> </div> <%--!Выдача--%> <%--Выдача УПФР--%> <asp:Button ID="btnExtUPFR" runat="server" Style="display: none" /> <act:ModalPopupExtender ID="mpeExtUPFR" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlExtUPFR" TargetControlID="btnExtUPFR" BehaviorID="bExtUPFR" RepositionMode="RepositionOnWindowResizeAndScroll"> </act:ModalPopupExtender> <div id="pnlExtUPFR" runat="server" style="display: none; width: 500px; height: 450px;" class="popup_Container"> <asp:Panel ID="pnlExtUPFRHeader" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="Panel15" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td valign="middle"> <asp:Label ID="Label11" runat="server" Text="Выдача"></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel ID="Panel16" runat="server" CssClass="PUTitlebarRight" onclick="$find('bExtUPFR').hide();"> </asp:Panel> </asp:Panel> <div style="text-align: center; width: 100%;"> <table id="extUPFRData" style="height: 380px; margin-left: 5px; margin-right: 5px; text-align: left" cellpadding="2px" border="0"> <tr> <td class="lblHeader" style="width: 200px"> <asp:Label ID="lblExtUPFR_MNIType" runat="server" Text="Тип МНИ"> </asp:Label> </td> <td style="width: 280px"> <t:RadComboBox ID="rcbExtUPFR_MNIType" runat="server" EmptyMessage="Выберите тип МНИ" Skin="Office2007" Width="260px" AutoPostBack="true" EnableLoadOnDemand="true" EnableVirtualScrolling="false" LoadingMessage="Подождите. Данные загружаются." MaxHeight="100" ShowDropDownOnTextboxClick="true" OnClientDropDownOpening="onrcbExtUPFR_MNITypeDropDownOpening"> </t:RadComboBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="LlblExtUPFR_DateExt" runat="server" Text="Дата выдачи"> <asp:RequiredFieldValidator ID="rfev_ExtUPFR_DateExt" runat="server" ValidationGroup="vgExtUPFR" Display="Dynamic" ControlToValidate="rdpExtUPFR_DateExt" ErrorMessage="*" Font-Size="Medium"></asp:RequiredFieldValidator> </asp:Label> </td> <td> <t:RadDatePicker ID="rdpExtUPFR_DateExt" runat="server" Skin="Office2007" Width="150px"> <DateInput ID="DateInput5" DateFormat="dd.MM.yyyy" Width="150px" runat="server" Style="text-align: center;"> </DateInput> <DatePopupButton ToolTip="Выберите дату выдачи" /> </t:RadDatePicker> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExtUPFR_SubDiv" runat="server" Text="Подразделение"> </asp:Label> </td> <td> <t:RadComboBox ID="rcbExtUPFR_SubDiv" runat="server" EmptyMessage="Выберите подразделение" Skin="Office2007" Width="260px" AutoPostBack="true" Height="300px" EnableLoadOnDemand="true" EnableVirtualScrolling="false" ShowMoreResultsBox="false" LoadingMessage="Подождите. Данные загружаются." MaxHeight="100" ShowDropDownOnTextboxClick="true" NoWrap="false" Enabled="true" OnItemsRequested="rcbExtUPFR_SubDiv_ItemsRequested" OnClientSelectedIndexChanged="onrcbExtUPFR_SubDivSelectedIndexChanged"> </t:RadComboBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExtUPFR_User" runat="server" Text="Пользователь"> </asp:Label> </td> <td> <t:RadComboBox ID="rcbExtUPFR_User" runat="server" EmptyMessage="Выберите пользователя" Skin="Office2007" Width="260px" AutoPostBack="true" Height="200px" EnableLoadOnDemand="true" EnableVirtualScrolling="false" ShowMoreResultsBox="true" LoadingMessage="Подождите. Данные загружаются." MaxHeight="100" ShowDropDownOnTextboxClick="true" NoWrap="true" Enabled="true" OnItemsRequested="rcbExtUPFR_User_ItemsRequested" OnClientDropDownOpening="onrcbExtUPFR_DropDownOpening" OnClientSelectedIndexChanged="onrcbExtUPFR_UserSelectedIndexChanged"> </t:RadComboBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExtUPFR_Count" runat="server" Text="Количество"></asp:Label> </td> <td> <t:RadNumericTextBox ID="rntbExtUPFR_Count" runat="server" ShowSpinButtons="false" MinValue="1" Width="60" MaxValue="999" Style="text-align: center" Value="1" ReadOnly="true"> <NumberFormat DecimalDigits="0" /> <IncrementSettings InterceptArrowKeys="true" InterceptMouseWheel="true" Step="1" /> </t:RadNumericTextBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExtUPFR_Sticker" runat="server" Text="Стикер"></asp:Label> </td> <td> <t:RadTextBox ID="rtbExtUPFR_Sticker" runat="server" Width="250" Height="50" TextMode="MultiLine" ReadOnly="true"> </t:RadTextBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="lblExtUPFR_assign" runat="server" Text="Цель использования"></asp:Label> </td> <td> <t:RadTextBox ID="rtbExtUPFR_assign" runat="server" Height="50" Width="250" LabelWidth="0" ShowButton="false" ShouldResetWidthInPixels="true" MaxLength="250" TextMode="MultiLine"> </t:RadTextBox> </td> </tr> <tr> <td class="lblHeader" align="center"> <asp:Label ID="Label20" runat="server" Text="Для резервного сохранения"> </asp:Label> </td> <td align="center" colspan="2"> <asp:CheckBox ID="chnExtUPFR_byList" runat="server" onclick="chbByList_onclick()" Width="30" Text="" TextAlign="Left" Visible="false"></asp:CheckBox> <t:RadButton ID="rbtnExtUPFR_buList" runat="server" ToggleType="CheckBox" ButtonType="ToggleButton" Checked="false" Width="32" Height="32" AutoPostBack="false"> <ToggleStates> <t:RadButtonToggleState ImageUrl="../images/32/uncheck.png" IsBackgroundImage="true" /> <t:RadButtonToggleState ImageUrl="../images/32/check.png" IsBackgroundImage="true" Selected="true" /> </ToggleStates> </t:RadButton> </td> </tr> </table> <div class="popup_Buttons"> <table width="100%"> <tr> <td align="left"> <asp:Button ID="btnExtUPFROK" runat="server" Text="OK" Width="90px" OnClientClick="return validatorExtUPFR();" OnClick="btnExtUPFROK_Click" ValidationGroup="vgExt" /> </td> <td align="right"> <asp:Button ID="btnExtUPFRCancel" runat="server" Text="Отмена" Width="90px" OnClientClick="$find('bExtUPFR').hide();return false;" /> </td> </tr> </table> </div> </div> </div> <%--!Выдача УПФР--%> <%--Возврат--%> <asp:Button ID="btnRet" runat="server" Style="display: none" /> <act:ModalPopupExtender ID="mpeRet" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlRet" TargetControlID="btnRet" BehaviorID="bRet" RepositionMode="RepositionOnWindowResizeAndScroll"> </act:ModalPopupExtender> <div id="pnlRet" runat="server" style="display: none; width: 450px; height: 225px;" class="popup_Container"> <asp:Panel ID="Panel10" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="Panel11" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td valign="middle"> <asp:Label ID="Label12" runat="server" Text="Возврат"></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel runat="server" CssClass="PUTitlebarRight" onclick="$find('bRet').hide();"> </asp:Panel> </asp:Panel> <div style="text-align: center; width: 100%; margin-top: 5px;"> <table id="retData" width="95%" style="margin-left: 5px; margin-right: 5px; text-align: left" cellpadding="2px" border="0"> <tr> <td class="lblHeader" style="width: 160px"> <asp:Label ID="Label13" runat="server" Text="Дата возврата"></asp:Label> </td> <td> <t:RadDatePicker ID="rdpRet_Date" runat="server" Skin="Office2007" Width="150px"> <DateInput ID="DateInput4" DateFormat="dd.MM.yyyy" Width="150px" runat="server" Style="text-align: center;" ReadOnly="true"> </DateInput> </t:RadDatePicker> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="Label14" runat="server" Text="Причина возврата"></asp:Label> </td> <td> <t:RadTextBox ID="rtbRet_assign" runat="server" Height="50" Width="250" LabelWidth="0" ShowButton="false" ShouldResetWidthInPixels="true" MaxLength="250" TextMode="MultiLine"> </t:RadTextBox> </td> </tr> <tr> <td class="lblHeader"> <asp:Label ID="Label15" runat="server" Text="Примечание"></asp:Label> </td> <td> <t:RadTextBox ID="rtbRet_Note" runat="server" Height="50" MaxLength="250" Width="250" TextMode="MultiLine"> </t:RadTextBox> </td> </tr> </table> <div class="popup_Buttons"> <table width="100%"> <tr> <td align="left"> <asp:Button ID="btnRetOk" runat="server" Text="OK" Width="90px" OnClick="btnRetOK_Click" /> </td> <td align="right"> <asp:Button ID="btnRetCancel" runat="server" Text="Отмена" Width="90px" OnClientClick="$find('bRet').hide(); return false;" /> </td> </tr> </table> </div> <%--</ContentTemplate> </asp:UpdatePanel>--%> </div> </div> <%--!Возврат--%> <%--Уничтожение--%> <asp:Button ID="btnDest" runat="server" Style="display: none" /> <act:ModalPopupExtender ID="mpeDest" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlDest" TargetControlID="btnDest" BehaviorID="bDest" RepositionMode="RepositionOnWindowResizeAndScroll"> </act:ModalPopupExtender> <div id="pnlDest" runat="server" style="display: none; width: 400px; height: 130px;" class="popup_Container"> <asp:Panel ID="Panel3" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="Panel4" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td valign="middle"> <asp:Label ID="Label16" runat="server" Text="Отметка на уничтожение"></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel ID="Panel9" runat="server" CssClass="PUTitlebarRight" onclick="$find('bDest').hide();" ToolTip="Закрыть"> </asp:Panel> </asp:Panel> <div style="text-align: center; width: 100%;"> <div> <table style="width: 95%; vertical-align: middle; text-align: left;" cellpadding="10px" cellspacing="2px" border="0"> <tr> <td class="lblHeader"> <asp:Label ID="Label17" runat="server" Text="Вы действительно хотите отметить на уничтожение выбранные МНИ?" CssClass="LabelError" Style="font-size: 12pt"></asp:Label> </td> </tr> </table> </div> <div class="popup_Buttons"> <table width="100%"> <tr> <td align="left"> <asp:Button ID="btnDestOK" runat="server" Text="OK" Width="90px" OnClick="btnDestOK_Click" /> </td> <td align="right"> <asp:Button ID="btnDestCancel" runat="server" Text="Отмена" Width="90px" OnClientClick="$find('bDest').hide(); return false;" /> </td> </tr> </table> </div> </div> </div> <%--!Уничтожение--%> <%--Свобоные МНИ--%> <asp:Button ID="btnFreeMNI" runat="server" Style="display: none" /> <act:ModalPopupExtender ID="mpeFreeMNI" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlFreeMNI" TargetControlID="btnFreeMNI" BehaviorID="bFreeMNI" RepositionMode="RepositionOnWindowResizeAndScroll"> </act:ModalPopupExtender> <div id="pnlFreeMNI" runat="server" style="display: none; width: 1200px; height: 500px;" class="popup_Container"> <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Always"> <ContentTemplate> <asp:Panel ID="pnlFreeMNIHeader" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="Panel13" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td style="width: 25px"> <asp:Image ID="Image1" runat="server" ImageUrl="~/images/warning.png" Visible="false" /> </td> <td valign="middle"> <asp:Label ID="Label18" runat="server" Text="Количество свободных МНИ"></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel ID="Panel14" runat="server" CssClass="PUTitlebarRight" onclick="$find('bFreeMNI').hide();"> </asp:Panel> <div id="pnlFreeMNIBody" style="text-align: center; width: 100%"> <t:RadGrid ID="rgFreeMNICount" runat="server" OnPreRender="rgFreeMNICount_PreRender" OnNeedDataSource="rgFreeMNICount_NeedDataSource" Skin="Office2007" ShowHeader="false"> <ClientSettings> <Scrolling AllowScroll="true" UseStaticHeaders="True" ScrollHeight="470" /> <Resizing AllowResizeToFit="true" /> <Selecting AllowRowSelect="false" CellSelectionMode="None" /> </ClientSettings> <MasterTableView TableLayout="Fixed"> <ItemTemplate> <%# (((GridItem)Container).ItemIndex != 0)? "</td></tr></table>" : "" %> <asp:Panel ID="ItemContainer" CssClass='<%# (((GridItem)Container).ItemType == GridItemType.Item)? "item" : "alternatingItem" %>' runat="server"> <table cellpadding="2" cellspacing="2" border="0" width="100%" style="border: 0px none; height: 95%"> <tr> <td rowspan="2" style="width: 52px"> <asp:Image ID="imgIcon" runat="server" ImageUrl='<%# "~/images/MNI/" + Eval("ICON")+".png"%>' AlternateText='<%# Eval("NAME")%>' Width="48" /> </td> <td style="width: 80px"> <b>Тип МНИ:</b> </td> <td> <%# Eval("NAME")%> </td> </tr> <tr> <td> <b>Количество:</b> </td> <td> <%# Eval("COL")%> </td> </tr> </table> </asp:Panel> </ItemTemplate> </MasterTableView> </t:RadGrid> </div> </asp:Panel> </ContentTemplate> </asp:UpdatePanel> </div> <%--!Свободные МНИ--%> <%--Ошибки--%> <asp:Button ID="btnErr" runat="server" Style="display: none" /> <act:ModalPopupExtender ID="mpeError" runat="server" BackgroundCssClass="ModalPopupBG" PopupControlID="pnlError" TargetControlID="btnErr" BehaviorID="bError" RepositionMode="RepositionOnWindowResizeAndScroll"> </act:ModalPopupExtender> <div id="pnlError" runat="server" style="display: none; width: 500px; height: 120px;" class="popup_Container"> <asp:UpdatePanel ID="upError" runat="server" UpdateMode="Always"> <ContentTemplate> <asp:Panel ID="pnlErrorHeader" runat="server" CssClass="popup_Titlebar"> <asp:Panel ID="Panel7" runat="server" CssClass="PUTitlebarLeft"> <table> <tr> <td style="width: 25px"> <asp:Image ID="imgErrorTitle" runat="server" ImageUrl="~/images/warning.png" /> </td> <td valign="middle"> <asp:Label ID="lblErrorTitle" runat="server" Text=""></asp:Label> </td> </tr> </table> </asp:Panel> <asp:Panel ID="Panel8" runat="server" CssClass="PUTitlebarRight" onclick="$find('bError').hide();"> </asp:Panel> <div style="text-align: center; width: 100%"> <table style="width: 95%; vertical-align: middle; text-align: left;" cellpadding="10px" cellspacing="2px" border="0"> <tr> <td class="lblHeader"> <asp:Label ID="lblErrorText" runat="server" Text="" CssClass="LabelError"></asp:Label> </td> </tr> </table> </div> </asp:Panel> </ContentTemplate> </asp:UpdatePanel> </div> <%--!Ошибки--%></asp:Content><asp:Content ID="Content4" ContentPlaceHolderID="C4" runat="Server"></asp:Content>Why RadGrid appears incorrect? (first attach file)
Row RadGrid join the previous table. (second attach file)
But when RadGrid is empty, RadGrid displays correctly
Pavlina
Telerik team
answered
on
09 Jul 2015
3 answers
79 views
I built a small test application following the documention on the website and part of the functionality I have included is changing the color of the markers based on some conditions. The markers are either green, yellow or red. After I got everything working the way I wanted it I deployed my solution to my server and when running from the server every marker is reddish orange with a solid white circle in the center when run from IE 11. When running from chrome the makers work normally (but the selection checkboxes disappear in my combobox).
1 answer
78 views
Hello,
I try to export RadGrid using the following code.
static GridItemType[] supportedItemTypes = new GridItemType[] {
GridItemType.GroupHeader,
GridItemType.Header,
GridItemType.AlternatingItem,
GridItemType.Item,
GridItemType.Footer,
GridItemType.GroupFooter
};
private void AddGrid(Worksheet pWS,pssRadGrid pGrid) {
foreach (GridItem item in pGrid.MasterTableView.GetItems(supportedItemTypes))
etc....
within the foreach loop i get the items in that order:
header
footer
item
item
etc.
Is there a way to get the items in the right order for exporting
header
item
item
.
.
.
footer
Thanks in advance
Daniel
Telerik team
answered
on
09 Jul 2015
1 answer
85 views
Hello,
First i don't know if this is the correct place to post or i should have posted in the HTMLChart section,
Anyways I'm binding RadHTML Chart to a PivotGrid and everything is working perfectly excepts that the series names of the htmlchart are in an incorrect order, for example:
If i have the below pivot:
Name : Col1 | Col2 | Col3 | Col4
A : 1 | 4 | 5 | 2
B : 7 | 3 | 2 | 1
C : 5 | 1 | 4 | 2
I get it in the HTML Chart as follows:
X Axis name of Col3 with Series and Y value of Col2 and so on for the rest
------------------------------------------------------------------------------------------------------------------
The ASP code is:
<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" OnCellDataBound="RadPivotGrid1_CellDataBound"> <Fields> <telerik:PivotGridColumnField UniqueName="column" DataField="ProjectName" Caption="Project"></telerik:PivotGridColumnField> <telerik:PivotGridRowField UniqueName="column1" DataField="DisplayName" Caption="Name"></telerik:PivotGridRowField> <telerik:PivotGridAggregateField GrandTotalAggregateFormatString="" CalculationExpression="" UniqueName="column2" DataField="Duration" Caption="Duration"> <TotalFormat Level="0" Axis="Rows" TotalFunction="NoCalculation" SortOrder="Ascending"></TotalFormat> </telerik:PivotGridAggregateField> </Fields> <ConfigurationPanelSettings DefaultDeferedLayoutUpdate="True"></ConfigurationPanelSettings> </telerik:RadPivotGrid> <telerik:RadHtmlChart ID="RadHtmlChart1" runat="server" DataSourceID="SqlDataSource1"> <Legend> <Appearance Position="Bottom"> </Appearance> </Legend> </telerik:RadHtmlChart>I have SQLDataSource which is populated from Code behind, The code behind as follows:
Private columnNames As New HashSet(Of String)() Private columnSeriesByRowName As New Dictionary(Of String, ColumnSeries)() Protected Sub RadPivotGrid1_CellDataBound(sender As Object, e As PivotGridCellDataBoundEventArgs) Dim dataCell As PivotGridDataCell = TryCast(e.Cell, PivotGridDataCell) If columnNames.Count = 0 Then Me.RadHtmlChart1.PlotArea.XAxis.Items.Clear() Me.RadHtmlChart1.PlotArea.Series.Clear() End If If dataCell IsNot Nothing AndAlso dataCell.CellType = PivotGridDataCellType.DataCell Then Dim rowName As String = GetName(dataCell.ParentRowIndexes) Dim columnName As String = GetName(dataCell.ParentColumnIndexes) columnName = columnName.Replace("'", " ") If columnNames.Add(columnName) Then Dim axisItem As New AxisItem(columnName) RadHtmlChart1.PlotArea.XAxis.Items.Add(axisItem) End If RadHtmlChart1.PlotArea.XAxis.LabelsAppearance.RotationAngle = 45 Dim columnSeries As ColumnSeries = Nothing If columnSeriesByRowName.ContainsKey(rowName) Then columnSeries = columnSeriesByRowName(rowName) Else columnSeries = New ColumnSeries() columnSeriesByRowName.Add(rowName, columnSeries) columnSeries.Name = rowName ' columnSeries.LabelsAppearance.DataFormatString = "C" columnSeries.LabelsAppearance.Visible = False columnSeries.LabelsAppearance.RotationAngle = 45 columnSeries.TooltipsAppearance.DataFormatString = "{0} " & rowName columnSeries.Stacked = True Me.RadHtmlChart1.PlotArea.Series.Add(columnSeries) End If Dim item As New CategorySeriesItem() Dim value As Decimal = 0 If e.Cell.DataItem IsNot Nothing AndAlso Decimal.TryParse(e.Cell.DataItem.ToString(), value) Then item.Y = value Else item.Y = Nothing End If columnSeries.SeriesItems.Add(item) End If End Sub Private Function GetName(indexes As Object()) As String Dim builder As New StringBuilder() For Each index As Object In indexes builder.Append(index.ToString()) builder.Append(" / ") Next builder.Remove(builder.Length - 3, 3) Return builder.ToString() End Function Private Sub PopulateSQLDataSource() SqlDataSource1.SelectCommand = "SELECT Project.ProjectName, SUM( DATEDIFF(HOUR, DbProvider_Classes.Start, DbProvider_Classes.[End])) AS Duration, Users.DisplayNameFROM Project INNER JOIN DbProvider_Classes ON Project.ProjectID = DbProvider_Classes.ProjectID INNER JOIN Users ON DbProvider_Classes.UserID = Users.UserID INNER JOIN Tasks ON DbProvider_Classes.TaskID = Tasks.TaskID WHERE Tasks.DepartmentID <> 6 GROUP BY Project.ProjectName , Users.DisplayName ORDER BY Project.ProjectName ASC" SqlDataSource1.Select(DataSourceSelectArguments.Empty) SqlDataSource1.DataBind() RadPivotGrid1.DataBind() End SubPrivate Sub btnViewAll_Click(sender As Object, e As EventArgs) Handles btnViewAll.Click PopulateSQLDataSource() lblReportDate.Text = "Report Date: Until " & Today.Date.ToString End Sub
If i create the same report with report designer everything works fine and i can load the generated report file from report viewer within my page but i want the client side capabilities of the HTMLChart
Thanks
Maria Ilieva
Telerik team
answered
on
09 Jul 2015
4 answers
558 views
Hi,
I have been facing the following problem.
The grid is declared as follows.
<
telerik:RadGrid ID="RadGrid1" EnableViewState="true" runat="server" GridLines="Vertical" AllowFilteringByColumn="false" AutoGenerateColumns="false" AllowPaging="true" AllowCustomPaging="true" AllowSorting="true" ShowStatusBar="true" AllowMultiRowSelection="true" Height="600px">
Grid columns are defined as follows; Please note the DataKeyNames property.
<MasterTableView BorderStyle="None" BorderWidth="0" AllowCustomSorting="true" DataKeyNames="col1">
<telerik:GridBoundColumn UniqueName="item_num" DataField="item_num" DataType="System.Int32" SortExpression="item_num"
HeaderText="item number">
</telerik:GridBoundColumn>
I have multi row select enabled on the grid. After selecting multiple rows, I run the following Javascript to get the value of the data key for those rows but it returns null for
var radgrdItems = $find("<%=RadGrid1.ClientID %>");
var mtv = radgrdItems.get_masterTableView();
// Get array of GridDataItem
var selectedRows = mtv.get_selectedItems();
// Works as expected. Returns the count of selected rows.
alert(selectedRows.length);
for (var i = 0; i < selectedRows.length; i++) {
var row = selectedRows[i];
if (row == null)
alert("row is null");
else {
// Works as expected - Returns the id
alert("get_id()= " + row.get_id());
// Does not work! Returns null for the get_dataItem()["item_num"]
alert("item #=" + row.get_dataItem()["item_num"]);
// Does not work! Returns null for the row.getDataKeyValue("col1")
alert("col1 key value=" + row.getDataKeyValue("col1"));
}
}
What am I doing wrong?
I have already looked @ http://demos.telerik.com/aspnet-ajax/grid/examples/client/keys/defaultcs.aspx page and could not find the issue in my code (may be I am missing something?)
Any help is appreciated.
Thanks,
Manny
Daniel
Telerik team
answered
on
09 Jul 2015
