⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 usertype.aspx

📁 2007年华中科技大学数据库课程设计参考程序[图书销售系统]+报告
💻 ASPX
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="usertype.aspx.cs" Inherits="ljian_admin_group_usertype" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!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 id="Head1" runat="server">
    <title>无标题页</title>
    <link href="../../../ljian/admin/style/style_main.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <asp:UpdatePanel runat="server" ID="up" ><ContentTemplate>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="usertype_id"
            DataSourceID="SqlDataSource1" Width="767px" OnRowCommand="GridView1_RowCommand">
             <HeaderStyle CssClass="headstyle" />
             <RowStyle CssClass ="itemstyle" />
            <Columns>
                <asp:BoundField DataField="usertype_id" HeaderText="usertype_id" InsertVisible="False"
                    ReadOnly="True" SortExpression="usertype_id" Visible="False" />
                <asp:BoundField DataField="usertype_name" HeaderText="会员组名" SortExpression="usertype_name" />
                <asp:BoundField DataField="discount" HeaderText="折扣" SortExpression="discount" />
                <asp:BoundField DataField="integral_low" HeaderText="积分下限" SortExpression="integral_low" />
                <asp:BoundField DataField="integral_up" HeaderText="积分上限" SortExpression="integral_up" />
                <asp:CommandField CausesValidation="False" HeaderText="操作" ShowEditButton="True" />
               <asp:TemplateField HeaderText="删除">
                <ItemTemplate>
                <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="false" CommandArgument='<%#Eval("usertype_id") %>' CommandName="del" Text ="删除" OnClientClick="javascript:if(confirm('确定删除该会员组吗?'))  return true;else return false;"></asp:LinkButton>
                </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        
  <div style ="float :left; width:400px; margin-top :30px; margin-left :25px">      
        <table width="100%" border="0" cellspacing="0" cellpadding="0" >
  <tr>
    <td width="6" style="height: 21px"><img src="../../images/left.gif" alt="" width="6" height="21"/></td>
    <td width="99%" background="../../images/center.gif" class="colorbai" style="height: 21px; font-size:14px; vertical-align:middle; color :White; ">
        添加新会员组</td>
    <td width="7" style="height: 21px"><img src="../../images/right.gif" alt="" width="6" height="21"/></td>
  </tr>
</table>
         <table border="0" bgcolor="#8fb9d0" width="100%" cellpadding="4" cellspacing="1" ><%--style ="border-left :1px solid #cfc7b2; border-right :1px solid #cfc7b2"--%>
       <tr><td bgcolor="#e7f5fd" vAlign=bottom align=left style=" padding-top :2px; padding-left :2px; height: 23px; width :27%"><strong>会员组名称:</strong></td>
       <td align=left bgcolor="#e7f5fd" style="text-align :left; width :80%; height: 23px;"><asp:TextBox id="name" runat="server" Width="156px"></asp:TextBox> <asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ErrorMessage="*" Display="Dynamic" ControlToValidate="name"></asp:RequiredFieldValidator></td></tr>
             <tr>
                 <td bgcolor="#e7f5fd" align="left" style="padding-left: 2px; width: 27%; padding-top: 2px; height: 19px"
                     valign="bottom">
                     <strong>会员组折扣:</strong></td>
                 <td bgcolor="#e7f5fd" align="left" style="width: 80%; height: 19px; text-align: left">
                     <asp:TextBox ID="zhekou" runat="server" Width="80px"></asp:TextBox>
                     <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="zhekou"
                         Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator></td>
             </tr>
             <tr>
                 <td bgcolor="#e7f5fd" align="left" style="padding-left: 2px; width: 27%; padding-top: 2px; height: 19px"
                     valign="bottom">
                     <strong>会员组积分下限:</strong></td>
                 <td bgcolor="#e7f5fd" align="left" style="width: 80%; height: 19px; text-align: left">
                     <asp:TextBox ID="xia" runat="server" Width="156px"></asp:TextBox>
                     <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="xia"
                         Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator></td>
             </tr>
             <tr>
                 <td bgcolor="#e7f5fd" align="left" style="padding-left: 2px; width: 27%; padding-top: 2px; height: 19px"
                     valign="bottom">
                     <strong>会员组积分上限:</strong></td>
                 <td bgcolor="#e7f5fd" align="left" style="width: 80%; height: 19px; text-align: left">
                     <asp:TextBox ID="shang" runat="server" Width="156px"></asp:TextBox>
                     <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="shang"
                         Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator></td>
             </tr>

       <tr><td bgcolor="#e7f5fd" colspan =2 align="left" height=31>
           &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;
           &nbsp;&nbsp;
           <asp:Button id="fabiao" onclick="fabiao_click" runat="server" Text="添加" Width="71px"></asp:Button>&nbsp;
            <asp:Label ID="error" runat="server" ForeColor="#C00000" Visible="False"></asp:Label>  
            <!--------------------------->
             <asp:UpdateProgress runat="server" id="up1" AssociatedUpdatePanelID="up">
         <ProgressTemplate> <span id="duquzhong" style=" font-size:12px; color :Green;"><img src="../../images/loading.gif" alt="读取中..."  />正在提交,请稍后...</span>  </ProgressTemplate>
        </asp:UpdateProgress>
             <!---------------------------></td></tr></table>
            <%-- <table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td><img height=4 alt="" src="../../images/06default_0726_03_1.gif" width=4></td>
<td width="99%" background=../../images/06default_0726_03_3.gif></td>
<td><img height=4 alt="" src="../../images/06default_0726_03_2.gif" width=4></td></tr></table>--%>

</div>
             
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:OnlineBookSellConnectionString %>"
            DeleteCommand="delete from usertype where usertype_id=@usertype_id" SelectCommand="SELECT usertype_id, usertype_name, discount, integral_low, authentication, description, integral_up FROM UserType order by integral_low"
            UpdateCommand="UPDATE UserType SET usertype_name = @usertype_name, discount = @discount, integral_low = @integral_low, integral_up = @integral_up WHERE (usertype_id = @usertype_id)" InsertCommand="INSERT INTO UserType(usertype_name, discount, integral_low, integral_up) VALUES (@usertype, @discount, @integral_low, @integral_up)">
            <DeleteParameters>
                <asp:Parameter Name="usertype_id" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="usertype_name" />
                <asp:Parameter Name="discount" />
                <asp:Parameter Name="integral_low" />
                <asp:Parameter Name="integral_up" />
                <asp:Parameter Name="usertype_id" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="usertype" />
                <asp:Parameter Name="discount" />
                <asp:Parameter Name="integral_low" />
                <asp:Parameter Name="integral_up" />
            </InsertParameters>
        </asp:SqlDataSource>
    </ContentTemplate></asp:UpdatePanel>
    </div>
    </form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -