kecheng.aspx

系统使用VS2005编写 数据库 使用SQL server 2000 或 SQL server 2005 测试前请先修改app.config 或web.config 的数据库连接字符串

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"   CodeFile="KECheng.aspx.cs" Inherits="KeC" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
    <script language="javascript" type="text/javascript">
function CheckAll()
{
	//点击全部选择，选取本页面全部记录
	//因为在Form1中找不到chkSel的CheckBox,所以只好遍历整个document
	var cked=false;
	cked = document.getElementById("chkSelAll").checked;
	for(var i=0;i<document.all.length;i++)
	{
		var e = document.all(i);
		try
		{//因为有些document的元素没有name属性，所以加上异常处理。
		//alert(e.name.substring(e.name.length-6,e.name.length));
			if(e.name.substring(e.name.length-6,e.name.length)=="chkSel")
			{
				e.checked = cked;
			}
		}
		catch(exception)
		{
		}
	}	
}
function WhetherSelect()
{
	//点击全部选择，选取本页面全部记录
	//因为在Form1中找不到chkSel的CheckBox,所以只好遍历整个document
	var cked=false;
	cked = document.getElementById("chkSelAll").checked;
	for(var i=0;i<document.all.length;i++)
	{
		var e = document.all(i);
		try
		{//因为有些document的元素没有name属性，所以加上异常处理。
		//alert(e.name.substring(e.name.length-6,e.name.length));
			if(e.name.substring(e.name.length-6,e.name.length)=="chkSel")
			{
			if(e.checked )//有选择数据
			    {
			        if( confirm('你确认删除此项数据吗?'))
			        {
    			    return true;
			        }
			        else //不删除
			        {
			       
			        return false;
			        }
			        
			    }
				
			}
		}
		catch(exception)
		{
		}
	}	
	 alert("你没有选择任何数据");
	return false; //没有数据被选择
}
    </script>

    <div>
        <asp:Label ID="Label1" runat="server" Text="请选择年份:"></asp:Label>
        <asp:DropDownList ID="ddlNian" runat="server" AppendDataBoundItems="True">
        </asp:DropDownList>
        <asp:Label ID="Label2" runat="server" Text="请选择级别:"></asp:Label>
        <asp:DropDownList ID="ddlJIBie" runat="server" AppendDataBoundItems="True">
        </asp:DropDownList>
        <asp:Button ID="Button3" runat="server" Text="查询" OnClick="Button3_Click" />
        <asp:Button ID="btnDel" runat="server" Text="删除" OnClick="btnDel_Click" />
        <asp:Button ID="btnAdd" runat="server" Text="添加" OnClick="btnAdd_Click" />&nbsp;
        <asp:Label ID="lblMsg" runat="server" Text="Label"></asp:Label>
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="KCID" AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None" OnPageIndexChanging="GridView1_PageIndexChanging" PageSize="3">
            <Columns>
                <asp:TemplateField>
                    <HeaderTemplate>
                        全选<input id="chkSelAll" name="chkSelAll" onclick="javascript:CheckAll();" type="checkbox">
                    </HeaderTemplate>
                    <HeaderStyle Width="50px" />
                    <ItemTemplate>
                        <asp:CheckBox ID="chkSel" runat="server" />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:HyperLinkField DataNavigateUrlFields="KCID" DataNavigateUrlFormatString="addKC.aspx?KCID={0}"
                    DataTextField="KCID" HeaderText="课程序号" />
                <asp:BoundField DataField="KCName" HeaderText="课程名称" />
                <asp:BoundField DataField="KCFZR" HeaderText="负责人" />
                <asp:BoundField HeaderText="负责人职称" DataField="KCZC" />
                
                <asp:TemplateField HeaderText="学年">
                <ItemTemplate>
                <asp:Label runat="server" ID="XN" Text='<%# Eval("XUENIAN.XNName") %>'></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="级别">
                <ItemTemplate>
                <asp:Label runat="server" ID="JB" Text='<%# Eval("JIBIE.JBName") %>'></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>
                
                <asp:TemplateField HeaderText="申报日期">
                <ItemTemplate>
                <asp:Label ID="lblKCSBSJ" runat="server" Text='<%# Bind("KCSBSJ", "{0:yyyy-mm-dd}") %>'></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="批准日期">
                <ItemTemplate>
                <asp:Label ID="lblKCPZSJ" runat="server" Text='<%# Bind("KCPZSJ", "{0:yyyy-mm-dd}") %>'></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>
                
                <asp:HyperLinkField HeaderText="课程网站"  Target="_blank" Text="打开" DataNavigateUrlFields="KCIndexPage" DataNavigateUrlFormatString="{0}" />
                
               
            </Columns>
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#EFF3FB" />
            <EditRowStyle BackColor="#2461BF" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
    
    </div>
</asp:Content>