booksubscription.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_BookSubscription : System.Web.UI.Page
{
    
    public static string Query_Flag;
    SqlConnection conn = new SqlConnection("server=(local);database=school;uid=sa;pwd=");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Query_Flag = Request.QueryString["Query_Flag"];
            BindData();
        }
    }

    public void BindData()
    {
        string strBind = "select * from BookSubscription";

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

        SqlDataAdapter adapter = new SqlDataAdapter(strBind, conn);

        DataSet dsSelect = new DataSet();

        conn.Open();

        adapter.Fill(dsSelect, "Book");

        conn.Close();

        grdBook.DataSource = dsSelect.Tables["Book"].DefaultView;
        grdBook.DataBind();

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

    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('BookSubscriptionEdit.aspx?ID=" + strID + "','','status=no,scrollbars=no,top=200,left=150,width=750,height=380')</script>");
    }
 
    
    protected void grdBook_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        grdBook.PageIndex = e.NewPageIndex;

        BindData();
    }

    protected void grdBook_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string strID = grdBook.Rows[e.RowIndex].Cells[0].Text;
        string strDel = "delete BookSubscription where ID= '" + strID + "'";
        SqlCommand cmd = new SqlCommand(strDel, conn);
        conn.Open();
        int n = cmd.ExecuteNonQuery();
        if (n != 0)
        {
            Response.Write("<script>alert('删除成功！')</script>");
        }
        conn.Close();
        BindData();
        
    }
}