ModuleMaster/usercontrols/editablegrid.ascx - main - ivan/ModMas

ModuleMaster/usercontrols/editablegrid.ascx
412 строк21 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:4900d9fb6
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="editableGrid.ascx.vb"
    Inherits="UserControls_editableGrid" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Src="gridEditControl.ascx" TagName="gridEditControl" TagPrefix="uc1" %>
<%@ Register Src="advancedFilesList.ascx" TagName="advancedFilesList" TagPrefix="uc2" %>
<%@ Register Src="txtDatePicker.ascx" TagName="txtDatePicker" TagPrefix="uc3" %>
<%@ Register Src="confirmationPopup.ascx" TagName="confirmationPopup" TagPrefix="uc4" %>
<%@ Register Src="gridActionControl.ascx" TagName="gridActionControl" TagPrefix="uc5" %>
<%@ Register Src="gridStatusControl.ascx" TagName="gridStatusControl" TagPrefix="uc6" %>
<%@ Register Src="numberValidator.ascx" TagName="numberValidator" TagPrefix="uc7" %>
<%@ Register Src="Graph.ascx" TagName="Graph" TagPrefix="uc8" %>
<%@ Register Src="~/UserControls/graphForTable.ascx" TagPrefix="uc1" TagName="graphForTable" %>
<%--<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit.HTMLEditor"    TagPrefix="cc1" %>--%>
<%@ Register src="condensedText.ascx" tagname="condensedText" tagprefix="uc9" %>


<link id="gridStyle" runat ="server"  rel="stylesheet" />
<link id="pageStyle" runat ="server"  rel="stylesheet" />


<asp:Panel ID="pnlGrid" runat="server" Visible="false">
    <asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server">
        <Services>
            <asp:ServiceReference Path="~/Services/Service.svc" />
        </Services>
        <Scripts>
            <asp:ScriptReference Path="~/Scripts/jquery-1.9.1.min.js" />
            <asp:ScriptReference  Path="~/Scripts/editableGrid.js" />
        </Scripts>
    </asp:ScriptManagerProxy>
    <asp:HiddenField ID="InstanceId" runat="server" />
    <asp:UpdatePanel runat="server" ID="upMain" UpdateMode="Conditional">
        <ContentTemplate>
            <uc4:confirmationPopup ID="confirmationPopup1" runat="server" />
            <asp:UpdatePanel ID="upParams" runat="server" UpdateMode="Always">
                <ContentTemplate>
                    <asp:HiddenField ID="lblMessage" runat="server" Value="" />
                    <asp:HiddenField ID="lblGridStatus" runat="server" Value="VIEW" />
                    <asp:HiddenField ID="lblEditingObject" runat="server" Value="" />
                    <asp:HiddenField ID="lblTableName" runat="server" Value="" />
                    <asp:HiddenField ID="lblTableId" runat="server" Value="" />
                    <asp:HiddenField ID="lblViewId" runat="server" Value="" />
                    <asp:HiddenField ID="hfUserName" runat="server" Value="" />
                    <asp:HiddenField ID="formulas" runat="server" />
                </ContentTemplate>
            </asp:UpdatePanel>
            
            <table style="margin: 0 auto;" id="tblFilters" runat="server">
                <tr>
                    <td>
                        <asp:PlaceHolder ID="phFilters" runat="server"></asp:PlaceHolder>
                    </td>
                    <td style="vertical-align: middle; padding-left: 5px;">
                        <asp:ImageButton ID="btnRefresh" runat="server" ImageUrl="~/Images/Refresh.png" />
                    </td>
                    <td style="vertical-align: middle; padding-left: 5px;">
                        <asp:Image ID="ExDown" runat="server" 
                            AlternateText="Excel Download" 
                            Height="28px" 
                            ImageUrl="~/Images/Microsoft Office 2003 Excel.png" 
                            ToolTip="Excel download"
                            CssClass="click exdown"
                            Width="28px" />
                    </td>
                    <td style="vertical-align: middle; padding-left: 5px;">
                        <asp:ImageButton ID="AddNewItem" runat="server" AlternateText="AddNewItem" ImageUrl="~/Images/Buttons/24/Plus.png"
                            ToolTip="Add new item" />
                    </td>
                    <td style="vertical-align: middle; padding-left: 5px;">
                        <asp:PlaceHolder ID="phActions" runat="server"></asp:PlaceHolder>
                    </td>
                    <td style="vertical-align: middle; padding-left: 5px;">
                        <asp:Image
                            ID="DataUpload" 
                            CssClass="click dataupload"
                            runat="server" 
                            AlternateText="Data Upload" 
                            ImageUrl="~/Images/Buttons/24/Database.png"
                            ToolTip="Data bulk upload" 
                            Visible="false" />
                    </td>
                    <td style="vertical-align: middle; padding-left: 5px;">
                        <asp:Image ID="ibSendEmail" 
                            runat="server" 
                            AlternateText="Send email" 
                            ImageUrl="~/Images/Buttons/24/mail.png"
                            ToolTip="Send this grid by email" 
                            CssClass="click sendemail"
                            Visible="False" />
                    </td>
                    <td style="vertical-align: middle; padding-left: 15px;">
                        <asp:Image
                            ID="ibDeleteData" 
                            CssClass="click deleteall"
                            runat="server" 
                            AlternateText="Delete all selected data" 
                            ImageUrl="~/Images/Buttons/24/trash_red.png"
                            ToolTip="Delete all selected data" 
                            Visible="False" />
                    </td>
                </tr>
                <tr>
                    <td colspan="4">
                        <div style="margin: 0 auto; width: 90%; text-align: center; vertical-align: middle">
                            Total records selected:
                            <asp:Literal ID="lblStatus" runat="server"></asp:Literal>
                            (<asp:TextBox ID="txtPagerSIze" runat="server" Width="20px" AutoPostBack="True"></asp:TextBox>per page)
                        </div>
                    </td>
                </tr>
            </table>
            <hr />
            <div style="text-align: center">
                <asp:Label runat="server" ID="lblCaption" Text=" Caption" Font-Size="Large" ForeColor="Blue"></asp:Label>
            </div>
            <hr />
            <%-- -----------Add new item------------ --%>
            <asp:Panel runat="server" 
                ID="pnlAddNewItem" 
                CssClass="borderRadius popup"
                ClientIDMode="Static"
                Widht="300px"
                Visible="false" 
                DefaultButton="ibSaveNewItem">
                <div id="dvHeader" style="font-weight: bold;">
                    <table style="width: 100%; cursor: move;">
                        <tr>
                            <td style="width: 100%; text-align: center;">
                                Add new item
                            </td>
                            <td style="padding-left: 10px">
                                <asp:ImageButton runat="server" ID="ibSaveNewItem" ImageUrl="~/Images/Save.png" />
                            </td>
                            <td style="padding-left: 10px">
                                <asp:ImageButton runat="server" ID="ibCancelNewItem" ImageUrl="~/Images/Cancel.png" />
                            </td>
                        </tr>
                    </table>
                </div>
                <hr />

                <asp:PlaceHolder runat="server" ID="AddFormFields" >
                </asp:PlaceHolder>

                <table runat="server" id="tblAddNewItem">
                </table>
                <asp:HiddenField ID="tempNewItemId" runat="server" Value ="0" />
            </asp:Panel>

            <asp:DragPanelExtender 
                ID="pnlAddNewItem_DragPanelExtender" 
                runat="server" 
                DragHandleID="dvHeader"
                Enabled="True" TargetControlID="pnlAddNewItem"></asp:DragPanelExtender>
            <%-- -----------Bulk data upload------------ --%>
            <asp:Panel runat="server" 
                ID="pnlDataUpload" 
                CssClass="borderRadius popup hidden" 
                Width="500px">
                <div id="dvHeaderDataUpload" style="font-weight: bold;">
                    <table style="width: 100%; cursor: move;">
                        <tr>
                            <td style="width: 100%; text-align: center;">
                                Data upload from Excel<br />
                                <span style="color: Navy; font-size: small;">First download excel form for this table,
                                    arrange your data in excel according to the given format and copy/paste data from
                                    excel to text box below (without header). </span>
                            </td>
                            <td style="padding-left: 10px">
                                <asp:Image runat="server" 
                                    ID="CancelDataUpload" 
                                    CssClass="closepopup"
                                    ImageUrl="~/Images/Cancel.png" />
                            </td>
                        </tr>
                    </table>
                </div>
                <hr />
                <table style="width: 100%; display: none;">
                    <tr>
                        <td>
                            Select your decimal notation format:
                        </td>
                        <td>
                            <asp:RadioButtonList ID="rblDecimalNotation" runat="server" RepeatDirection="Horizontal">
                                <asp:ListItem Value="1" Selected="True">0.000</asp:ListItem>
                                <asp:ListItem Value="0">0,000</asp:ListItem>
                            </asp:RadioButtonList>
                        </td>
                        <td>
                            Select your date format:
                        </td>
                        <td>
                            <asp:RadioButtonList ID="rblDateFormat" runat="server" RepeatDirection="Horizontal">
                                <asp:ListItem Value="0" Selected="True">dd.MM.yyyy</asp:ListItem>
                                <asp:ListItem Value="1">yyyy-MM-dd</asp:ListItem>
                            </asp:RadioButtonList>
                        </td>
                    </tr>
                </table>
                <hr />
                <table class="center centerAlign ">
                    <tr>
                        <td>
                            <asp:ImageButton ID="ibUpload" 
                                CssClass="closepopup"
                                runat="server" 
                                ImageUrl="~/Images/Buttons/24/Download.png"
                                ToolTip="Upload" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <asp:Literal ID="ltrUploadResults" runat="server"></asp:Literal>
                        </td>
                    </tr>
                </table>
                <asp:TextBox ID="txtDataToUpload" runat="server" TextMode="MultiLine" Height="242px"
                    Width="500px"></asp:TextBox>
            </asp:Panel>
            <asp:DragPanelExtender ID="DragPanelExtender1" runat="server" DragHandleID="dvHeaderDataUpload"
                Enabled="True" TargetControlID="pnlDataUpload"></asp:DragPanelExtender>

            <%-- -----------Mail recipients------------ --%>
            <asp:Panel runat="server" 
                ID="pnlMailRecepients" 
                CssClass="borderRadius popup hidden" 
                Width="300px">
                <div id="Div1" style="font-weight: bold;">
                    <table style="width: 100%; cursor: move;">
                        <tr>
                            <td style="width: 100%; text-align: center;">
                                Send data to mail<br />
                                <span style="color: Navy; font-size: small;">Copy/Paste as list of mail recepients -
                                    Single Id's - to the textbox below</span>
                            </td>
                            <td>
                                <asp:ImageButton ID="doSendEmail" 
                                   runat="server" 
                                    CssClass="closepopup"
                                    AlternateText="Send email" 
                                    ImageUrl="~/Images/Buttons/24/mail.png"
                                    ToolTip="Send" />
                            </td>
                            <td style="padding-left: 10px">
                                <asp:Image runat="server" 
                                    ID="CancelEmail" 
                                    ImageUrl="~/Images/Cancel.png"
                                    CssClass="click closepopup"
                                    ToolTip="Cancel" />
                            </td>
                        </tr>
                    </table>
                </div>
                <asp:TextBox ID="txtMailRecepients" runat="server" TextMode="MultiLine" Height="50px"
                    Width="200px"></asp:TextBox>
                <br />
                Enter message body text:
                <br />
                <asp:TextBox ID="txtMessageText" runat="server" />
            </asp:Panel>
            <asp:DragPanelExtender ID="DragPanelExtender2" runat="server" DragHandleID="Div1"
                Enabled="True" TargetControlID="pnlMailRecepients">
            </asp:DragPanelExtender>
            
            <%-------------Excel download options--------------%>
            <asp:Panel runat="server" ID="pnlEXcelDownloadOptions" 
                CssClass="borderRadius hidden popup" 
                Width="200px">
                <div id="dvExcelDownloadOptions" style="font-weight: bold;">
                    <table style="width: 100%; cursor: move;">
                        <tr>
                            <td style="width: 100%; text-align: center;">
                                Excel download options
                            </td>
                            <td>
                                <asp:ImageButton ID="ibExcelDownloadWithOoptions" 
                                    runat="server" 
                                    CssClass="closepopup"
                                    AlternateText="Start excel download"
                                    ImageUrl="~/Images/Microsoft Office 2003 Excel.png" 
                                    ToolTip="Download" 
                                    Height="28px"
                                    Width="28px" />
                            </td>
                            <td style="padding-left: 10px">
                                <asp:Image runat="server" 
                                    ID="ExDownCancel" 
                                    CssClass="click closepopup"
                                    ImageUrl="~/Images/Cancel.png"
                                    ToolTip="Cancel" />
                            </td>
                        </tr>
                    </table>
                </div>
                <asp:CheckBox ID="chkWithInvisibleFields" runat="server" Text="With invisible fields" />
            </asp:Panel>
            <asp:DragPanelExtender ID="DragPanelExtender3" runat="server" DragHandleID="dvExcelDownloadOptions"
                Enabled="True" TargetControlID="pnlEXcelDownloadOptions">
            </asp:DragPanelExtender>
            <%----------------------------------------%>
            <%------------- Delete all data --------------%>
            <asp:Panel ID="pnlDeleteAll" 
                runat="server" 
                CssClass="borderRadius popup hidden"
                Width="200px">
            <strong><p id="confirmationMessage">Are you sure to delete all selected items?</p></strong>
            <table style="width: 100%; border-style: none; border-collapse: collapse;" class="center centerAlign">
                <tr>
                    <td>
                        <asp:ImageButton ID="btnYes" 
                            CssClass="closepopup"
                            runat="server" 
                            Text="Yes" 
                            ImageUrl ="~/Images/ok.png" />
                    </td>
                    <td>
                        <asp:Image ID="btnNo" 
                            CssClass="click closepopup"
                            runat="server" 
                            Text="No" 
                            ImageUrl ="~/Images/cancel.png" />
                    </td>
                </tr>
            </table>
            <asp:HiddenField ID="hfItemId" ClientIDMode="Static" runat ="server" Value="-1" />
        </asp:Panel>
           <%---------------------File upload-----------------------------%>
            <div id="choosefile" runat="server" clientidmode="static" class="popup" style="display: none; background-color: lightyellow; border: 2px solid Gray; text-align: center; padding: 5px;">
                <input id="selectedfile"  ClientIDMode ="Static" runat="server" type="file" style="background-color: lightgreen;" class="selectedfile" />
                <br />
                <br />
                <asp:Image ID="savefile" ClientIDMode ="Static" runat="server" ImageUrl ="~/Images/Buttons/save.png" CssClass ="savefile click" />
                <asp:Image ID="cancelfile" ClientIDMode ="Static" runat="server" ImageUrl ="~/Images/Buttons/cancel.png" CssClass ="cancelfile click" />
            </div>
            <%--------------------------------------------------%>

           <%---------------------File delete-----------------------------%>
            <div id="confirmdeletefile" runat="server" clientidmode="static" class="popup" style="display: none; background-color: lightyellow; border: 2px solid Red; text-align: center; padding: 5px;">
                Sure to delete?
                <br />
                <br />
                <asp:Image ID="deletefile" ClientIDMode ="Static" runat="server" ImageUrl ="~/Images/Buttons/save.png" CssClass ="deletefile click" />
                <asp:Image ID="Image3canceldeletefile" ClientIDMode ="Static" runat="server" ImageUrl ="~/Images/Buttons/cancel.png" CssClass ="canceldeletefile click" />
            </div>
            <%--------------------------------------------------%>

            <div style="text-align: center">
                <asp:PlaceHolder ID="phSubReport" runat="server"></asp:PlaceHolder>
                <br />
                <asp:Label runat="server" ID="lblMessageText" Visible="true"></asp:Label>
            </div>
            <asp:GridView ID="GridView1" runat="server" 
                AllowPaging="True" 
                AllowSorting="True" 
                CellPadding="4" 
                EmptyDataText="No Data found" 
                ForeColor="#333333" 
                GridLines="Both"
                ShowFooter="True" 
                ShowHeaderWhenEmpty="True" 
                Style="margin: 0 auto;" 
                CssClass="ScrollTable edtable"
                Font-Size="8pt" CaptionAlign="Top">
                <AlternatingRowStyle BackColor="White" />
                <EditRowStyle BackColor="#2461BF" />
                <EmptyDataRowStyle BackColor="Red" />
                <FooterStyle BackColor="#229EE5" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#229EE5" Font-Bold="True" ForeColor="White" />
                <PagerSettings Mode="NumericFirstLast" PageButtonCount="5" />
                <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"  />
                <RowStyle BackColor="#EFF3FB" />
                <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                <SortedAscendingCellStyle BackColor="#F5F7FB" />
                <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                <SortedDescendingCellStyle BackColor="#E9EBEF" />
                <SortedDescendingHeaderStyle BackColor="#4870BE" />
            </asp:GridView>
            <div id="dvPlaySound" runat="server" style="visibility :hidden ;" />

        </ContentTemplate>
        <Triggers>
            <asp:PostBackTrigger ControlID="btnRefresh" />
           <%-- <asp:PostBackTrigger ControlID="AddNewItem" />--%>
            <asp:PostBackTrigger ControlID="ibExcelDownloadWithOoptions" />
        </Triggers>
    </asp:UpdatePanel>
    <asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="upMain"
        DisplayAfter="50" style="text-align: center;">
        <ProgressTemplate>
            <asp:Image ID="Image1" runat="server" ImageUrl="~/Images/gif/24.gif" Style="position: absolute;
                left: 48%; top: 30%;" />
        </ProgressTemplate>
    </asp:UpdateProgress>
</asp:Panel>



<asp:Panel ID="pnlNoAccess" runat="server" HorizontalAlign="Center">
    <h2>
        Sorry, you don&#39;t have an access to view that table.
    </h2>
    <br />
    <h3>
        Please, contact the person resposible:
        <asp:Label runat="server" ID="lblResponsble"></asp:Label>
    </h3>
</asp:Panel>
<asp:Panel ID="pnlNoTableInfo" runat="server" Visible="false" HorizontalAlign="Center">
    <h2>
        No table selected</h2>
</asp:Panel>