图书馆管理系统ASP.net C#+sql数据库

一个完整的ASp.net C# 开发的小型系统，里面有水晶报表、各个页面的代码比较规范，易懂，适合学习。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class addBookcase : System.Web.UI.Page
{
    string id = ““;
    protected void Page_Load（object sender EventArgs e）
    {
        id = Request.QueryString[“bookcaseID“].ToString（）;           //获取对图书操作的方式
        if （!IsPostBack）                                    //判断是否是首次加载
        {
            //自定义方法绑定书架
            if （id != “add“）                                  //判断是否是添加操作
            {
                this.title = “修改书架信息“;
                string sql = “select * from tb_bookcase where bookcaseID=“ + id;            //调用自定义方法生成条形码
                SqlDataReader sdr = dataOperate.getRow（sql）;
                sdr.Read（）;
                txtBookcase.Text = sdr[“bookcaseName“].ToString（）;
                sdr.Close（）;
            }
            else
                this.title = “添加书架信息“;
        }
    }

    protected void btnSave_Click（object sender EventArgs e）
    {
        string bookcaseName = txtBookcase.Text;
        string sql = ““;
        if （id == “add“）
        {
            sql = “insert into tb_bookcase values（‘“ + bookcaseName + “‘）“;
        }
        else
            sql = “update tb_bookcase set bookcaseName=‘“ + bookcaseName + “‘ where bookcaseID=“+id;

        if （dataOperate.execSQL（sql））   //判断添加或修改是否成功
        {
            Response.Write（“ript language=javascript>alert（‘保存成功！‘）;window.opener.location.href=window.opener.location=‘bookcaseManage.aspx‘;window.close（）;ript>“）;
        }
        else
        {
            RegisterStartupscript（““ “ript>alert（‘保存失败！‘）ript>“）;
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      16384  2007-12-13 18:26  libraryManage\CrystalReport1.rpt

     文件       4699  2010-08-16 16:38  libraryManage\Web.Config

     文件       5400  2007-12-14 23:19  libraryManage\addBookInfo.aspx

     文件       5578  2007-12-25 00:46  libraryManage\addBookInfo.aspx.cs

     文件       2052  2007-12-19 21:36  libraryManage\addBookType.aspx

     文件       2208  2007-12-19 21:50  libraryManage\addBookType.aspx.cs

     文件       1670  2007-12-18 23:29  libraryManage\addBookcase.aspx

     文件       2085  2007-12-19 21:51  libraryManage\addBookcase.aspx.cs

     文件       6209  2007-12-19 17:50  libraryManage\addReaderInfo.aspx

     文件       4518  2007-12-19 18:11  libraryManage\addReaderInfo.aspx.cs

     文件       2052  2007-12-19 22:22  libraryManage\addReaderType.aspx

     文件       2174  2007-12-19 22:29  libraryManage\addReaderType.aspx.cs

     文件       3139  2007-12-14 22:54  libraryManage\addUser.aspx

     文件       1014  2007-12-19 19:38  libraryManage\addUser.aspx.cs

     文件       2934  2007-12-25 00:37  libraryManage\admSet.aspx

     文件       3031  2007-12-13 17:58  libraryManage\admSet.aspx.cs

     文件       8062  2007-12-25 21:23  libraryManage\bookBorrow.aspx

     文件       8821  2007-12-25 21:15  libraryManage\bookBorrow.aspx.cs

     文件       5003  2007-12-25 00:38  libraryManage\bookBorrowSearch.aspx

     文件       2646  2007-12-20 22:15  libraryManage\bookBorrowSearch.aspx.cs

     文件       4430  2007-12-20 22:43  libraryManage\bookInfoManage.aspx

     文件       4122  2007-12-15 01:43  libraryManage\bookInfoManage.aspx.cs

     文件       1796  2010-08-12 18:45  libraryManage\bookInfoPrint.aspx

     文件       1521  2010-08-12 19:16  libraryManage\bookInfoPrint.aspx.cs

     文件       4797  2007-12-20 23:35  libraryManage\bookInfoSearch.aspx

     文件       4327  2007-12-20 22:39  libraryManage\bookInfoSearch.aspx.cs

     文件       7984  2007-12-19 22:37  libraryManage\bookRenewal.aspx

     文件       6992  2007-12-25 18:29  libraryManage\bookRenewal.aspx.cs

     文件       7982  2007-12-19 22:37  libraryManage\bookReturn.aspx

     文件       4625  2007-12-25 18:29  libraryManage\bookReturn.aspx.cs

............此处省略161个文件信息