bookmodify.aspx.cs

内有图书管理系统数据库 及相关模板文件

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration ;
using System.Data .SqlClient ;
namespace BMS
{
    //该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

	/// <summary>
	/// BookModify 的摘要说明。
	/// </summary>
	public partial class BookModify : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{	//从文件Web.config中读取连接字符串
				string strconn= ConfigurationSettings.AppSettings["dsn"];
				//连接本地计算机的LMS数据库
				SqlConnection cn= new SqlConnection (strconn);
				//创建查询相应书目信息的sql语句
				string mysql="select * from book where book.bid=@bid";
				//创建SqlCommand
				SqlCommand cm=new SqlCommand (mysql,cn);
				//添加并设置参数的值
				cm.Parameters .Add ("@BID", SqlDbType.Int );
				cm.Parameters ["@BID"].Value =Request.QueryString [0];
				//打开连接
				cn.Open ();
				//执行ExecuteReader
				SqlDataReader dr=cm.ExecuteReader ();
				if(dr.Read ())//有数据读出，即有匹配用户
				{
					//进行Label绑定
					lbl_bid.Text =dr["bid"].ToString ();
					tbx_bname.Text =dr["bname"].ToString ();
					tbx_bisbn.Text =dr["bisbn"].ToString ();
					tbx_bauthor.Text =dr["bauthor"].ToString ();
					tbx_bpress.Text =dr["bpress"].ToString ();
					tbx_bprice.Text =dr["bprice"].ToString ();
					tbx_btheme.Text =dr["btheme"].ToString ();
					tbx_bindex.Text =dr["bindex"].ToString ();
					tbx_bseriesname.Text =dr["bseriesname"].ToString ();
					tbx_bclassifytext.Text =dr["bclassifytext"].ToString ();
					tbx_bdescribe.Text =dr["bdescribe"].ToString ();
					cn.Close ();
				}
			
				else
				{
					Response.Write ("该书目不存在，请返回");
					Response.End ();
				}
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void btn_modify_Click(object sender, System.EventArgs e)
		{	//从文件Web.config中读取连接字符串
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的BMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			cn.Open ();
			//创建cm1，用于book表中数据的操作
			SqlCommand cm1=new SqlCommand ("BookModify",cn);
			//添加并给参数付值
			cm1.Parameters .Add ("@BID",SqlDbType.Int);
			cm1.Parameters .Add ("@BISBN",SqlDbType.VarChar);
			cm1.Parameters .Add ("@BName",SqlDbType.VarChar);
			cm1.Parameters .Add ("@BAuthor",SqlDbType.VarChar);
			cm1.Parameters .Add ("@BPress",SqlDbType.VarChar );
			cm1.Parameters .Add ("@BTheme",SqlDbType.VarChar );
			cm1.Parameters .Add ("@BClassifyText",SqlDbType.VarChar );
			cm1.Parameters .Add ("@BIndex",SqlDbType.VarChar );
			cm1.Parameters .Add ("@BPrice",SqlDbType.Money );
			cm1.Parameters .Add ("@BSeriesName",SqlDbType.VarChar );
			cm1.Parameters .Add ("@BDescribe",SqlDbType.VarChar);
			cm1.CommandType =CommandType.StoredProcedure ;
			//从Label中取得要更新内容的书的书目号
			string bidvalue=lbl_bid.Text .ToString ();
			cm1.Parameters ["@BID"].Value =Convert.ToInt16 (bidvalue);
			//从各TextBox中取得要更新的值
			//往book表中参数付值
			cm1.Parameters ["@BName"].Value =tbx_bname.Text .ToString ();
			cm1.Parameters ["@BISBN"].Value =tbx_bisbn.Text .ToString ();
			cm1.Parameters ["@BAuthor"].Value =tbx_bauthor.Text .ToString ();
			cm1.Parameters ["@BPress"].Value =tbx_bpress.Text .ToString ();
			cm1.Parameters ["@BTheme"].Value =tbx_btheme.Text .ToString ();
			cm1.Parameters ["@BClassifyText"].Value =tbx_bclassifytext.Text .ToString ();
			cm1.Parameters ["@BIndex"].Value =tbx_bindex.Text .ToString ();
			cm1.Parameters ["@BPrice"].Value =Convert.ToDouble (tbx_bprice.Text .ToString ());
			cm1.Parameters ["@BSeriesName"].Value =tbx_bseriesname.Text .ToString ();
			cm1.Parameters ["@BDescribe"].Value =tbx_bdescribe.Text .ToString ();
			cm1.ExecuteNonQuery ();
			cn.Close ();
		}

		protected void btn_delete_Click(object sender, System.EventArgs e)
		{
			//从文件Web.config中读取连接字符串
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的BMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			cn.Open ();
			//创建cm1，用于book表中数据的操作
			SqlCommand cm1=new SqlCommand ("bookdelete",cn);
			cm1.Parameters .Add ("@BID",SqlDbType.Int  );
			cm1.CommandType =CommandType.StoredProcedure ;
			//从Label中取得要更新内容的书的书目号
			string bidvalue=lbl_bid.Text .ToString ();
			cm1.Parameters ["@BID"].Value =Convert.ToInt32 (bidvalue);
			cm1.ExecuteNonQuery ();
			cn.Close ();
			Response.Redirect ("bookmanage.aspx");
		}
	}
}