📄 company_manage.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Company_manage.aspx.cs" Inherits="_Default" %>
<!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 style="background-color: #ffffff; text-align: center">
<form id="form1" runat="server">
<div style="text-align: center">
<span style="font-size: 10pt; color: #990000; font-family: 宋体">基本信息→公司信息管理<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:db_sellConnectionString %>"
DeleteCommand="DELETE FROM [tb_Company] WHERE [id] = @id" InsertCommand="INSERT INTO [tb_Company] ([CompanyName], [CompanyType], [Linkman], [AddTime], [UserName]) VALUES (@CompanyName, @CompanyType, @Linkman, @AddTime, @UserName)"
SelectCommand="SELECT [id], [CompanyName], [CompanyType], [Linkman], [AddTime], [UserName] FROM [tb_Company]"
UpdateCommand="UPDATE [tb_Company] SET [CompanyName] = @CompanyName, [CompanyType] = @CompanyType, [Linkman] = @Linkman, [AddTime] = @AddTime, [UserName] = @UserName WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CompanyName" Type="String" />
<asp:Parameter Name="CompanyType" Type="String" />
<asp:Parameter Name="Linkman" Type="String" />
<asp:Parameter Name="AddTime" Type="String" />
<asp:Parameter Name="UserName" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="CompanyName" Type="String" />
<asp:Parameter Name="CompanyType" Type="String" />
<asp:Parameter Name="Linkman" Type="String" />
<asp:Parameter Name="AddTime" Type="String" />
<asp:Parameter Name="UserName" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</span></div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="id" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"
Style="border-right: #003399 0px solid; border-top: #003399 0px solid; font-size: smaller;
border-left: #003399 0px solid; border-bottom: #003399 0px solid;" Width="500px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnSelectedIndexChanging="GridView1_SelectedIndexChanging">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id"
Visible="False" />
<asp:BoundField DataField="CompanyName" HeaderText="公司名称" SortExpression="CompanyName" />
<asp:BoundField DataField="CompanyType" HeaderText="公司类型" SortExpression="CompanyType" />
<asp:BoundField DataField="Linkman" HeaderText="联系人" SortExpression="Linkman" />
<asp:BoundField DataField="UserName" HeaderText="操作用户" SortExpression="UserName" />
<asp:BoundField DataField="AddTime" HeaderText="最后修改时间" SortExpression="AddTime" />
<asp:CommandField HeaderText="详细信息" SelectText="详细信息" ShowSelectButton="True" />
<asp:TemplateField HeaderText="删除" ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete"
OnClientClick='javascript:return confirm("您确认要删除此项消息吗？")' Text="删除"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#003399" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -