/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/account/auth.aspx
455 строк
31 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Auth.aspx.vb" Inherits="Account_Auth" %> <%--<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit.HTMLEditor" tagprefix="cc1" %>--%> <%@ Register Src="../UserControls/editableGrid.ascx" TagName="editableGrid" TagPrefix="uc1" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %> <!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> <link href="~/Styles/bootstrap.min.css" rel="stylesheet" type="text/css" /> <style type="text/css"> .ajax__tab_tab { height: 30px !important; } fieldset { border-style: solid; border-width: 2px; border-color: Gray; padding-left: 5px; padding-top: 5px; padding-right: 5px; padding-bottom: 5px; background-color: White; } legend { background-color: LightGray; border-style: solid; border-color: Gray; color: Black; padding-left: 10px; padding-right: 10px; padding-bottom: 1px; font-weight: bold; font-size: 10pt; width: auto; margin-bottom: 0px; } </style> </head> <body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> <Scripts> <asp:ScriptReference Path="~/Scripts/jquery-1.9.1.min.js" /> <asp:ScriptReference Path="~/Scripts/bootstrap.min.js" /> <asp:ScriptReference Path="~/Scripts/jquery-ui-1.10.3.custom.min.js" /> </Scripts> </asp:ScriptManager> <div style="text-align: center;"> Authorization management <hr /> <asp:UpdatePanel runat="server" ID="upMain" UpdateMode="Conditional"> <ContentTemplate> <asp:Label ID="lblModule" runat="server" Text="-"></asp:Label> <asp:HiddenField runat ="server" ID="ModuleId" Value="0" /> : <asp:Label ID="lblTable" runat="server" Text="-"></asp:Label> <asp:HiddenField runat ="server" ID="TableId" Value="0" /> : <asp:Label ID="lblGroup" runat="server" Text="-"></asp:Label> <asp:HiddenField runat ="server" ID="GroupId" Value="0" /> <hr /> <div style="margin: 0 auto; text-align: center; width: 80%; border: 1px solid black;"> <asp:TabContainer ID="tcMain" runat="server" ActiveTabIndex="2" Width="100%"> <asp:TabPanel runat="server" HeaderText="Module" ID="tpModules"> <ContentTemplate> <uc1:editableGrid ID="edModules" runat="server" TableId="36" IsReadOnly="true" /> </ContentTemplate> </asp:TabPanel> <asp:TabPanel ID="tpTables" runat="server" HeaderText="Tables"> <ContentTemplate> <uc1:editableGrid ID="edTables" runat="server" TableId="23" IsReadOnly="true" /> </ContentTemplate> </asp:TabPanel> <asp:TabPanel ID="tpGroups" runat="server" HeaderText="Groups"> <HeaderTemplate> Groups </HeaderTemplate> <ContentTemplate> <asp:Panel runat="server" ID="pnlControls" DefaultButton="btnRefresh"> <asp:Label runat ="server" ID="GroupsMessage" /> <table style="margin: 0 auto;"> <tr> <td> Group name </td> <td> Table name </td> <td> Table id </td> <td> </td> <td> </td> </tr> <tr> <td> <asp:TextBox ID="txtGroupName" runat="server" AutoPostBack="True"></asp:TextBox> </td> <td> <asp:TextBox ID="txtTableName" runat="server" AutoPostBack="True"></asp:TextBox> </td> <td> <asp:TextBox ID="txtTAbleId" runat="server" Width="20px" AutoPostBack="True"></asp:TextBox> </td> <td> <asp:ImageButton runat="server" ID="btnRefresh" ImageUrl="~/Images/Refresh.png" /> </td> <td> <asp:Image ID="AddNewGroup" runat="server" ImageUrl="~/Images/Plus.png" data-toggle="modal" href="#AddNewGroupForm" Style="cursor: pointer;" /> </td> </tr> </table> </asp:Panel> <asp:Label ID="MainMessage" runat="server"></asp:Label> <asp:GridView Style="margin: 0 auto;" ID="gvGRoups" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataSourceID="sdsAuthorizationGroups" ForeColor="Black" GridLines="Vertical" PageSize="20"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" /> <asp:BoundField DataField="GroupName" HeaderText="Group Name" SortExpression="GroupName"> <HeaderStyle Font-Bold="True" /> <ItemStyle Font-Bold="True" /> </asp:BoundField> <asp:BoundField DataField="GroupDescription" HeaderText="Group Description" SortExpression="GroupDescription" /> <asp:BoundField DataField="TableName" HeaderText="Table Name" SortExpression="TableName" /> <asp:BoundField DataField="TableDescription" HeaderText="Table Description" SortExpression="TableDescription" /> <asp:BoundField DataField="Access type" HeaderText="Access type" ReadOnly="True" SortExpression="Access type"> <HeaderStyle Font-Bold="True" /> <ItemStyle Font-Bold="True" /> </asp:BoundField> <asp:BoundField DataField="Fields" HeaderText="Fields" SortExpression="Fields" Visible = "False" /> <asp:TemplateField> <ItemTemplate> <asp:Literal ID="SelectedFields" runat="server" Text='<%# Eval("Fields").ToString.Replace(",","<br/>") %>'></asp:Literal> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:Image ID="EditTableFields" runat="server" ImageUrl="~/Images/Buttons/edit.png" data-toggle="modal" href="#TableFields" Style="cursor: pointer;" data-groupid='<%# Eval("id") %>' data-groupname='<%# Eval("GroupName") %>' CssClass="editTableFields" /> </ItemTemplate> </asp:TemplateField> <asp:CommandField ButtonType="Image" SelectImageUrl="~/Images/Buttons/yes.png" ShowSelectButton="True" /> <asp:TemplateField> <ItemTemplate> <asp:ImageButton ID="DeleteRow" runat="server" CommandArgument='<%# Eval("id") %>' CommandName="DEL" ImageUrl="~/Images/Buttons/delete.png" /> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCC99" /> <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" /> <RowStyle BackColor="#F7F7DE" Font-Size="8pt" /> <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#FBFBF2" /> <SortedAscendingHeaderStyle BackColor="#848384" /> <SortedDescendingCellStyle BackColor="#EAEAD3" /> <SortedDescendingHeaderStyle BackColor="#575357" /> </asp:GridView> <asp:SqlDataSource ID="sdsAuthorizationGroups" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="select g.id, g.GroupName, g.GroupDescription, t.TableName, t.TableDescription, a.accessType as 'Access type', a.fieldId as 'Fields' from UserModules.dbo.Groups g left join UserModules.dbo.[Authorization] a on g.id = a.groupId left join UserModules.dbo.ModuleTables t on a.tableId = t.id where t.TableName is not NULL AND ((t.TableName like @TAbleName AND t.id LIKE @TAbleId) AND g.GRoupName like @GroupName)"> <SelectParameters> <asp:ControlParameter ControlID="txtTableName" DefaultValue="%" Name="TAbleName" PropertyName="Text" /> <asp:ControlParameter ControlID="txtTAbleId" DefaultValue="%" Name="TAbleId" PropertyName="Text" /> <asp:ControlParameter ControlID="txtGroupName" DefaultValue="%" Name="GroupName" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> <!-- /.modal --> <div class="modal fade" id="TableFields"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <h4 class="modal-title"> <button type="button" class="close" data-dismiss="modal" > ×</button> Current table fields for group <span id="CurrentGroupName"></span> <span id="CurrentGroupID" runat="server" clientidmode ="Static" style="visibility : hidden;"></span></h4> </div> <div class="modal-body"> <div id ="TableFieldsList"> <asp:PlaceHolder runat="server" ID="PlaceForTableFieldsList"> </asp:PlaceHolder> </div> </div> <div class="modal-footer"> <img src="../Images/Save.png" style="cursor: pointer;" id="SaveTableFields" onclick="SaveTableFieldsClicked();" /> <img src="../Images/Cancel.png" data-dismiss="modal" style="cursor: pointer;" /> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <!-- /.modal --> <!-- /.modal --> <div class="modal fade" id="AddNewGroupForm"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> ×</button> <h4 class="modal-title"> Add new user</h4> </div> <div class="modal-body"> <label for="NewGroupName"> Group Name</label> <asp:TextBox runat="server" type="text" CssClass="form-control" id="NewGroupName" placeholder="Enter group name" ClientIDMode ="Static" /> <label for="NewGroupDescription"> Single ID</label> <asp:TextBox runat="server" type="text" CssClass="form-control" id="NewGroupDescription" placeholder="Enter group description" ClientIDMode ="Static" /> <label for="AccessType"> Access type</label> <asp:PlaceHolder runat="server" ID="AccessOptions"> <asp:CheckBox runat ="server" ID="fullAccess" Text="Full access" CssClass="checkbox" /> <asp:CheckBox runat="server" id="edit" text = "Edit" CssClass="checkbox" /> <asp:CheckBox runat ="server" ID="readOnly" Text = "Read only" CssClass="checkbox" /> <asp:CheckBox runat ="server" ID="insert" Text="Insert" CssClass="checkbox"/> <asp:CheckBox runat ="server" ID="delete" Text="Delete" CssClass="checkbox" /> </asp:PlaceHolder> </div> <div class="modal-footer"> <img src="../Images/Save.png" style="cursor: pointer;" id="Img1" onclick="okGroupClicked();" /> <img src="../Images/Cancel.png" data-dismiss="modal" style="cursor: pointer;" /> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <!-- /.modal --> </ContentTemplate> </asp:TabPanel> <asp:TabPanel ID="tpUsers" runat="server" HeaderText="Users"> <HeaderTemplate> Users </HeaderTemplate> <ContentTemplate> <asp:UpdatePanel runat="server" ID="UsersUpdatePanel" > <ContentTemplate> <asp:Label runat ="server" ID="Message" /> <asp:Panel runat="server" ID="Panel1" DefaultButton="btnRefresh2"> <table style="margin: 0 auto;"> <tr> <td> Group id </td> <td> User Id </td> <td> </td> <td> </td> </tr> <tr> <td> <asp:TextBox ID="txtGroupId" runat="server" AutoPostBack="True" Width="20px"></asp:TextBox> </td> <td> <asp:TextBox ID="txtUserId" runat="server" AutoPostBack="True" Width="100px"></asp:TextBox> </td> <td> <asp:ImageButton runat="server" ID="btnRefresh2" ImageUrl="~/Images/Refresh.png" /> </td> <td> <asp:Image ID="btnAdd" runat="server" ImageUrl="~/Images/Plus.png" data-toggle="modal" href="#AddNewUser" Style="cursor: pointer;" /> </td> </tr> </table> </asp:Panel> <asp:GridView Style="margin: 0 auto;" ID="gvUsers" runat="server" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Vertical" AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="sdsUsers" AllowPaging="True" AllowSorting="True"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" /> <asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" /> <asp:BoundField DataField="UserId" HeaderText="UserId" SortExpression="UserId" /> <asp:BoundField DataField="GroupName" HeaderText="GroupName" SortExpression="GroupName" /> <asp:BoundField DataField="groupId" HeaderText="groupId" SortExpression="groupId" Visible="False" /> <asp:CheckBoxField DataField="Enabled" HeaderText="Enabled" SortExpression="Enabled" /> <asp:TemplateField> <ItemTemplate> <asp:ImageButton ID="Button1" runat="server" ImageUrl="~/Images/Buttons/delete.png" CommandName ="DEL" CommandArgument =<%# Eval("id") %> /> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCC99" /> <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" /> <RowStyle BackColor="#F7F7DE" Font-Size="8pt" /> <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#FBFBF2" /> <SortedAscendingHeaderStyle BackColor="#848384" /> <SortedDescendingCellStyle BackColor="#EAEAD3" /> <SortedDescendingHeaderStyle BackColor="#575357" /> </asp:GridView> <asp:SqlDataSource ID="sdsUsers" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="SELECT u.id, u.UserName, u.UserId, u.groupId, u.Enabled, g.GroupName FROM UserModules.dbo.Users u left join UserModules.dbo.Groups g on u.groupId = g.id WHERE groupid like @groupid and UserId like '%' + @UserID + '%' order by id desc"> <SelectParameters> <asp:ControlParameter ControlID="txtGroupId" DefaultValue="%" Name="groupid" PropertyName="Text" /> <asp:ControlParameter ControlID="txtUserId" DefaultValue="%" Name="UserID" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> <!-- /.modal --> <div class="modal fade" id="AddNewUser"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> ×</button> <h4 class="modal-title"> Add new user</h4> </div> <div class="modal-body"> <label for="UserName"> User Name</label> <asp:TextBox runat="server" type="text" CssClass="form-control" id="username" placeholder="Enter user name" ClientIDMode ="Static" /> <label for="UserId"> Single ID</label> <asp:TextBox runat="server" type="text" CssClass="form-control" id="userid" placeholder="Enter user Single ID" ClientIDMode ="Static" /> <%--<label for="Group"> Authorization group</label> <div class="row"> <div class="col-lg-12"> <div class="input-group"> <div class="input-group-btn"> <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown"> Group <span class="caret"></span> </button> <ul runat="server" id="groupslist" class="dropdown-menu"> </ul> </div> <!-- /btn-group --> <asp:TextBox runat="server" type="text" class="form-control" id="groupname" placeholder="Enter group name" ClientIDMode ="Static" /> </div> <!-- /input-group --> </div> </div>--%> <!-- /.row --> </div> <div class="modal-footer"> <img src="../Images/Save.png" style="cursor: pointer;" id="btnsave" onclick="okClicked();" /> <img src="../Images/Cancel.png" data-dismiss="modal" style="cursor: pointer;" /> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <!-- /.modal --> </ContentTemplate> </asp:UpdatePanel> </ContentTemplate> </asp:TabPanel> </asp:TabContainer> </div> </ContentTemplate> </asp:UpdatePanel> </div> <script type="text/javascript"> // $(".groupsmenu").click(function () { // $("#groupname").val($(this).text()); // }); function SaveTableFieldsClicked() { closeDialog(); var selectedFields; selectedFields = ""; $(".db_field").each(function () { var child = $(this).children("input"); if (child[0].checked == true) { //console.log($(this).data("dbfieldname")); if (selectedFields.length > 0) { selectedFields = selectedFields + "," }; selectedFields = selectedFields + $(this).data("dbfieldname"); //console.log(child[0].checked); } }); console.log(selectedFields); __doPostBack('SaveTableFields', $("#CurrentGroupID").text() + "|" + selectedFields); }; $(document).on("click", ".editTableFields", function () { //alert($(this).data('groupid')); $("#CurrentGroupID").text($(this).data('groupid')); $("#CurrentGroupName").text($(this).data('groupname')); }); function closeDialog() { $('#AddNewUser').modal('hide'); $('#AddNewGroupForm').modal('hide'); $('#TableFields').modal('hide'); }; function okClicked() { if ($("#username").val() == "") { alert("Please input user name"); return; }; if ($("#userid").val() == "") { alert("Please input user id"); return; }; if ($("#groupname").val() == "") { alert("Please select group"); return; }; closeDialog(); __doPostBack('AddNewUser', ''); }; function okGroupClicked() { if ($("#NewGroupName").val() == "") { alert("Please input group name"); return; }; if ($("#NewGroupDescription").val() == "") { alert("Please input group description"); return; }; closeDialog(); __doPostBack('AddNewGroup', ''); }; </script> </form> </body> </html>