borrowbook.aspx.cs

管理系统源码 很好的用于参考很好对开发毕业设计很有帮助

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;
//该源码下载自【编程联盟】ASp.Net下载中心 【 http://aspx.bcbbs.net 】
//该源码下载自【编程联盟】ASp.Net下载中心 【 http://aspx.bcbbs.net 】
//该源码下载自【编程联盟】ASp.Net下载中心 【 http://aspx.bcbbs.net 】

public partial class Pages_BorrowBook : System.Web.UI.Page
{
    public static string Query_Flag;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //获得参数
            Query_Flag = Request.QueryString["Query_Flag"];

            //绑定数据
            BindData();
        }
    }

    protected void BindData()
    {
        SqlConnection conn = new SqlConnection("server=(local);database=school;uid=sa;pwd=");

        string strSql = "select * from BookBorrow ";

        if (Query_Flag != null && Query_Flag != "")
        {
            strSql += " where " + Session["strWhere"];
        }

        SqlDataAdapter adapter = new SqlDataAdapter(strSql, conn);

        DataSet dsBook = new DataSet();

        conn.Open();

        adapter.Fill(dsBook, "Book");

        conn.Close();

        grdBook.DataSource = dsBook;
        grdBook.DataBind();

        for (int i = 0; i <= grdBook.Rows.Count - 1; i++)
        {
            DataRowView mydrv;
            string gIntro;
            if (grdBook.PageIndex == 0)
            {
                mydrv = dsBook.Tables[0].DefaultView[i];
                gIntro = Convert.ToString(mydrv["Remark"]);
                grdBook.Rows[i].Cells[8].Text = SubStr(gIntro, 6);
            }
            else
            {
                mydrv = dsBook.Tables[0].DefaultView[i + (grdBook.PageSize * grdBook.PageIndex)];
                gIntro = Convert.ToString(mydrv["Remark"]);
                grdBook.Rows[i].Cells[8].Text = SubStr(gIntro, 6);
            }
        }

        dsBook.Dispose();
    }

    public string SubStr(string sString, int nLeng)
    {
        if (sString.Length <= nLeng)
        {
            return sString;
        }
        string sNewStr = sString.Substring(0, nLeng);
        sNewStr = sNewStr + "...";
        return sNewStr;
    }

    protected void grdBook_RowEditing(object sender, GridViewEditEventArgs e)
    {
        //取得记录编号
        string strID = grdBook.Rows[e.NewEditIndex].Cells[0].Text;

        //打开子窗体
        Response.Write("<script>window.open('BorrowBookEdit.aspx?ID=" + strID + "','','status=no,scrollbars=no,top=200,left=300,width=480,height=280')</script>");
    }

    protected void grdBook_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string strID = grdBook.Rows[e.RowIndex].Cells[0].Text;

        SqlConnection conn = new SqlConnection("server=(local);database=school;uid=sa;pwd=");

        string strDel = "delete from BookBorrow where BorrowID='" + strID + "'";

        SqlCommand cmd = new SqlCommand(strDel, conn);

        try
        {
            conn.Open();

            //删除记录
            cmd.ExecuteNonQuery();

            //绑定数据
            BindData();
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('" + ex.Message + "');</script>");
        }
        finally
        {
            conn.Close();
        }
    }
    protected void grdBook_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        //更改GridView当前页的索引
        grdBook.PageIndex = e.NewPageIndex;

        //绑定数据
        BindData();
    }
}