图书流通管理/frmBookFine.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

public partial class 图书管理_frmBookFine : System.Web.UI.Page
{
    private static int readid =-1;
    public void bind(string sql, string sql1)
    {
        DataSet dsbook = new DataSet();
        DataSet dsuse = new DataSet();
        dataOperate data = new dataOperate();
        dsbook = data.getDataSet(sql1,"book");
        gvBookBorrow.DataSource = dsbook.Tables["book"].DefaultView;
        gvBookBorrow.DataBind();
        dsuse = data.getDataSet(sql, "use");
        GridView1.DataSource = dsuse.Tables["use"].DefaultView;
        GridView1.DataBind();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        string type = "";
        try
        {
            //id = Session["id"].ToString();
            type = Session["type"].ToString();
            readid = Convert.ToInt32(Request.QueryString["readid"].ToString());
            if (type == "普通人员")
            {
                RegisterStartupScript("", "<script>show();</script>");
                Response.Redirect("~\\frmReadHome.aspx");
            }
            else
            {
                //调用存储过程
                //string str = "data source=.\\SQLEXPRESS;database=dbLibrary;integrated security=true";
                string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbLibrary.mdf;Integrated Security=True;User Instance=True";
                SqlConnection conn = new SqlConnection(str);
                SqlCommand cmd = new SqlCommand("pro_bookfine", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@readid", SqlDbType.Int));
                cmd.Parameters["@readid"].Direction = ParameterDirection.Input;
                cmd.Parameters["@readid"].Value = readid;
                cmd.Parameters.Add(new SqlParameter("@rname", SqlDbType.VarChar, 20));
                cmd.Parameters["@rname"].Direction = ParameterDirection.Output;
                cmd.Parameters.Add(new SqlParameter("@rsex", SqlDbType.Char, 2));
                cmd.Parameters["@rsex"].Direction = ParameterDirection.Output;
                cmd.Parameters.Add(new SqlParameter("@fine", SqlDbType.Money));
                cmd.Parameters["@fine"].Direction = ParameterDirection.Output;
                cmd.Parameters.Add(new SqlParameter("@jiao", SqlDbType.Money));