/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/createtable.aspx
101 строка
4 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="createTable.aspx.vb" Inherits="createTable" EnableEventValidation ="false" %> <%@ Register src="UserControls/gridEditControl.ascx" tagname="gridEditControl" tagprefix="uc1" %> <%@ Register src="UserControls/editableGrid.ascx" tagname="editableGrid" tagprefix="uc2" %> <!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> </head> <body> <form id="form1" runat="server"> <div> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <table> <tr> <td> <table> <tr> <td> Module </td> <td> <asp:DropDownList ID="ddlModule" runat="server" DataSourceID="sdsModules" DataTextField="text" DataValueField="value"> </asp:DropDownList> <asp:SqlDataSource ID="sdsModules" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="SELECT [ModuleName] as text, id as value FROM [UserModules].[dbo].[ModuleMaster] where id <> 3"></asp:SqlDataSource> </td> </tr> <tr> <td> Table Name </td> <td> <asp:TextBox runat="server" ID="txtTableName" /> </td> </tr> <tr> <td> Table Description </td> <td> <asp:TextBox runat="server" ID="txtTableDescription" TextMode="MultiLine" Rows="2" Columns="20" /> </td> </tr> <tr> <td> <asp:Button runat="server" ID="btnSave" Text="SAVE" /> </td> <td> <asp:Button runat="server" ID="btnClear" Text="CLEAR" /> </td> </tr> </table> </td> <td> <asp:DropDownList runat="server" ID="ddlTablesList" DataSourceID="sdsTables" DataTextField="text" AutoPostBack ="true" DataValueField="value"></asp:DropDownList><asp:CheckBox runat ="server" ID="chkDropBEforeCreate" Checked ="false" Text="Drop table before create" /> <asp:SqlDataSource ID="sdsTables" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="SELECT [id] as value ,[dbTableName] as text FROM [UserModules].[dbo].[ModuleTables] WHERE moduleid <> 3"></asp:SqlDataSource> <asp:Button runat ="server" ID="btnCreateTable" Text ="Create" /><br /> <asp:TextBox runat ="server" ID="txtCreateTableScript" TextMode ="MultiLine" Rows="10" Columns ="45"></asp:TextBox> </td> </tr> </table> <hr/> <table style="width: 98%"> <tr> <td style="width: 50%"> <uc2:editableGrid ID="editableGrid1" runat="server" tableName="[ModuleMaster]" /> <hr /> <uc2:editableGrid ID="editableGrid2" runat="server" tableName="[ModuleTables]" /> <hr /> <uc2:editableGrid ID="editableGrid3" runat="server" tableName="[TableFields]" /> </td> <td style="width: 50%"> <uc2:editableGrid ID="editableGrid4" runat="server" sqlQuery="" tableName="" /> </td> </tr> </table> </div> </form> </body> </html>