adocmdmanager.ascx

这是我编的一小软件。请等级等待指教。呵呵。ASP的

<%@ Control Language="c#" AutoEventWireup="false" Codebehind="AdoCmdManager.ascx.cs" Inherits="Seaskyer.WebApp.skyNews.Pages.AdminMSC.AdoCmdManager" TargetSchema="http://schemas.microsoft.com/intellisense/ie5" %>
<script language="javascript" type="text/javascript">
<!--
function oop(id)
{
	var obj = document.getElementById(id);
	
	if(obj.style.display == "block")
		obj.style.display = "none";
	else
		obj.style.display = "block";
}


//-->
</script>
<table width="98%" align="center" cellspacing="0" cellpadding="0">
	<tr>
		<td class="mframe-t-left"></td>
		<td class="mframe-t-mid"><span class="mframe-t-text"><%= lang.AppName%>(当前采用数据库类型：<%= config[Seaskyer.WebApp.Utility.ConfigType.AdoCmd, "DataType"]%>)</span> </td>
		<td class="mframe-t-right"></td>
	</tr>
</table>
<table width="98%" align="center" cellspacing="0" cellpadding="0">
	<tr>
		<td class="mframe-m-left"></td>
		<td class="mframe-m-mid">
			<asp:Panel ID="Panel1" Runat="server">
				<asp:DataGrid id="DataGrid1" runat="server" Width="100%" ShowHeader="True" ShowFooter="false"
					AutoGenerateColumns="false" AllowPaging="False" DataKeyField="@Name" ItemStyle-CssClass="tdbg"
					CellSpacing="0" CellPadding="5" OnItemCreated="DataGrid1_ItemCreated">
					<HeaderStyle HorizontalAlign="center" CssClass="summary-title" Height="25" />
					<ItemStyle Height="22" />
					<EditItemStyle CssClass="tdbg-dark" />
					<Columns>
						<asp:TemplateColumn HeaderText="表名">
							<ItemStyle Width="200" />
							<ItemTemplate>
								<img src="/skyNews/Images/Skin/table.gif" width="20" border="0" align="absmiddle">
								<asp:HyperLink ID="btnChange" Runat="server">
									<font style="font-size: 14px; color:brown;">
										<%# DataBinder.Eval(Container.DataItem, "@Name")%>
									</font>
								</asp:HyperLink>
							</ItemTemplate>
						</asp:TemplateColumn>
						<asp:BoundColumn HeaderText="描述" DataField="@reMark">
							<ItemStyle />
						</asp:BoundColumn>
					</Columns>
				</asp:DataGrid>
			</asp:Panel>
			<asp:Panel ID="Panel2" Runat="server">
				<table width="100%" align="center" cellspacing="0" cellpadding="5" rules="all" border="1"
					style="border-collapse:collapse;">
					<tr Class="summary-title">
						<td width="50"></td>
						<td width="150">命令索引ID</td>
						<td width="100">所属表名</td>
						<td width="80">自定义</td>
						<td>功能描述</td>
						<td width="20"><input type="checkbox" onclick="checkFormAll(this.form, this.checked)"></td>
					</tr>
					<asp:Repeater id="Repeater1" Runat="server">
						<ItemTemplate>
							<tr class="tdbg" onmouseover="this.className='tdbg-dark';" onmouseout="this.className='tdbg';">
								<td align="center">
									<a href='/skyNews/Admin/AdoCmdManager.aspx?tableName=<%= Request.QueryString["tableName"]%>&indexID=<%# DataBinder.Eval(Container.DataItem, "@id")%>'>
										修改</a>
								</td>
								<td width="150">
									<span style="cursor:hand;" onclick="oop('<%# DataBinder.Eval(Container.DataItem, "@id")%>');">
										<%# DataBinder.Eval(Container.DataItem, "@id")%>
									</span>
								</td>
								<td>
									<%= Request.QueryString["tableName"]%>
								</td>
								<td>
									<%# (DataBinder.Eval(Container.DataItem, "@System").ToString() == "1" ? "<font color=red>系统</font>" : "自定义")%>
								</td>
								<td>
									<%# DataBinder.Eval(Container.DataItem, "description")%>
								</td>
								<td>
									<%# DataBinder.Eval(Container.DataItem, "@System").ToString() == "0" ? "<input type=\"checkbox\" name=\"chk\" value=\"" + DataBinder.Eval(Container.DataItem, "@id") + "\" /> " : ""%>
								</td>
							</tr>
							<tr style="display: none;" id="<%# DataBinder.Eval(Container.DataItem, "@id")%>">
								<td colspan="10" style="padding-left:15px;padding-top:10px; background-color:#ffffff;">
									命令行：<font color="BlueViolet"><%# DataBinder.Eval(Container.DataItem, "sqlStr")%></font>
								</td>
							</tr>
						</ItemTemplate>
					</asp:Repeater>
				</table>
			</asp:Panel>
			<asp:Panel ID="Panel3" Runat="server">
				<input type="hidden" id="id" runat="server" />
				<table width="90%" align="center" cellspacing="0" cellpadding="5" rules="all" border="1"
					style="border-collapse:collapse;">
					<tr>
						<td width="120">命令索引ID：</td>
						<td>
							<asp:TextBox ID="CmdID" Runat="server" Columns="30" />
							<asp:RequiredFieldValidator ControlToValidate="CmdID" ErrorMessage="*" Display="Dynamic" runat="server" ID="Requiredfieldvalidator1" />
							<asp:RegularExpressionValidator runat="server" ControlToValidate="CmdID" ValidationExpression="[^']+" ErrorMessage="*"
								Display="Dynamic" ID="Regularexpressionvalidator1" /></td>
					</tr>
					<tr>
						<td>所属表名：</td>
						<td>
							<asp:TextBox ID="TableName" Runat="server" />
							<asp:RequiredFieldValidator ControlToValidate="TableName" ErrorMessage="*" Display="Dynamic" runat="server"
								ID="Requiredfieldvalidator2" />
							<asp:RegularExpressionValidator runat="server" ControlToValidate="TableName" ValidationExpression="[^']+" ErrorMessage="*"
								Display="Dynamic" ID="Regularexpressionvalidator2" /></td>
					</tr>
					<tr>
						<td>是否系统必备命令：</td>
						<td>
							<asp:RadioButtonList id="isSYS" RepeatDirection="Horizontal" Width="120px" runat="server">
								<asp:ListItem value="1">是</asp:ListItem>
								<asp:ListItem value="0" Selected="True">否</asp:ListItem>
							</asp:RadioButtonList></td>
					</tr>
					<tr>
						<td>语句命令行：</td>
						<td>
							<asp:TextBox ID="sqlStr" Runat="server" TextMode="MultiLine" Wrap="True" Width="100%" Height="100" />
							<asp:RequiredFieldValidator ControlToValidate="sqlStr" ErrorMessage="*" Display="Dynamic" runat="server"
								ID="Requiredfieldvalidator3" /></td>
					</tr>
					<tr>
						<td>命令行功能注释：</td>
						<td>
							<asp:TextBox ID="description" Runat="server" TextMode="MultiLine" Wrap="True" Width="100%" Height="100" /></td>
					</tr>
				</table>
			</asp:Panel>
			<table align="center" width="100%" height="30">
				<tr>
					<td width="200"><asp:Label ID="pageLabel" Runat="server" /></td>
					<td align="center"><asp:Button ID="Button1" Runat="server" OnClick="Button1_OnClick" /><asp:Button ID="Submit" Runat="server" OnClick="Submit_OnClick" /><input type="button" id="AddNew" Runat="server" value="新建命令" />&nbsp;&nbsp;<input type="button" id="Back" Runat="server" value="返 回" />&nbsp;&nbsp;<asp:Button ID="Copy" Runat="server" OnClick="Copy_OnClick" Text="复 制" /></td>
					<td width="200" align="right"><asp:Button ID="Delete" Runat="server" OnClick="Delete_OnClick" Text="删 除" />&nbsp;</td>
				</tr>
			</table>
		</td>
		<td class="mframe-m-right"></td>
	</tr>
</table>
<table width="98%" align="center" cellspacing="0" cellpadding="0">
	<tr>
		<td class="mframe-b-left"></td>
		<td class="mframe-b-mid">&nbsp;</td>
		<td class="mframe-b-right"></td>
	</tr>
</table>
<!-- #Include File="Footer.Inc" -->