网上书店主页面
书目管理页面窗体
代码:
1
namespace BMS
{
/// <summary>
/// BookManage 的摘要说明。
/// </summary>
public class BookManage : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid dgd_booklist;
protected System.Web.UI.WebControls.HyperLink hlk_advsearch;
protected System.Web.UI.WebControls.Button btn_search;
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.TextBox tbx_bid;
protected System.Web.UI.WebControls.HyperLink hlk_userlist;
protected System.Web.UI.WebControls.HyperLink hlk_default;
protected System.Web.UI.WebControls.HyperLink hlk_bookadd;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack) BindGrid();
}
public void DataGrid_Delete(Object sender,DataGridCommandEventArgs E)
{
//从文件Web.con7g中读取连接字符串
string strconn= Con7gurationSettings.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 ;
//创建cm2,用于bookprice表中数据的操作
SqlCommand cm2=new SqlCommand ("bookpricedelete",cn);
cm2.Parameters .Add ("@PPID",SqlDbType.Int );
cm2.CommandType =CommandType.StoredProcedure ;
//从DateGrid中取得更新内容
//Cells [1]为BID列
string bidvalue=E.Item.Cells [1].Text.ToString ();
cm1.Parameters ["@BID"].Value =Convert.ToInt16 (bidvalue);
cm2.Parameters ["@PPID"].Value =Convert.ToInt16 (bidvalue);
cm1.ExecuteNonQuery ();
cm2.ExecuteNonQuery ();
dgd_booklist.EditItemIndex =-1;
2
cn.Close ();
BindGrid();
}
public void DataGrid_Page(Object sender,DataGridPageChangedEventArgs E)
{
dgd_booklist.CurrentPageIndex =E.NewPageIndex ;
BindGrid();
}
public void BindGrid()
{ //从文件Web.con7g中读取连接字符串
string strconn= Con7gurationSettings.AppSettings["dsn"];
//连接本地计算机的BMS数据库
SqlConnection cn= new SqlConnection (strconn);
//创建SqlDataAdapter对象,调用视图
SqlDataAdapter da=new SqlDataAdapter ("booklist",cn);
//创建并填充DataSet
DataSet ds=new DataSet ();
da.Fill (ds);
dgd_booklist.DataSource =ds;
dgd_booklist.DataBind ();
cn.Close ();
}
#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()
{
this.btn_search.Click += new System.EventHandler(this.btn_search_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
3
private void btn_search_Click(object sender, System.EventArgs e)
{ int varbid=Convert.ToInt16 (tbx_bid.Text .ToString ());
Response.Redirect ("bookmodify.aspx?bid="+varbid);
}
}
}
添加书目信息页面窗体
代码:
namespace BMS
{
/// <summary>
/// BookAdd 的摘要说明。
/// </summary>
public class BookAdd : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox tbx_bname;
protected System.Web.UI.WebControls.TextBox tbx_bisbn;
protected System.Web.UI.WebControls.TextBox tbx_bauthor;
protected System.Web.UI.WebControls.TextBox tbx_bpress;
protected System.Web.UI.WebControls.TextBox tbx_bprice;
protected System.Web.UI.WebControls.TextBox tbx_bdescribe;
protected System.Web.UI.WebControls.DropDownList ddl_bgroup;
protected System.Web.UI.WebControls.Button btn_submit;
4
protected System.Web.UI.WebControls.HyperLink hlk_bookmanage;
protected System.Web.UI.WebControls.RegularExpressionValidator rev_bprice;
protected System.Web.UI.WebControls.RequiredFieldValidator rfv_bname;
protected System.Web.UI.WebControls.RequiredFieldValidator rfv_bisbn;
protected System.Web.UI.WebControls.RequiredFieldValidator rfv_banthor;
protected System.Web.UI.WebControls.RequiredFieldValidator rfv_bpress;
protected System.Web.UI.WebControls.RequiredFieldValidator rfv_bprice;
protected System.Web.UI.WebControls.RegularExpressionValidator rev_bisbn;
protected System.Web.UI.WebControls.DropDownList ddl_bdiscount;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}
#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()
{
this.btn_submit.Click += new System.EventHandler(this.btn_submit_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void btn_submit_Click(object sender, System.EventArgs e)
{
if(Page.IsValid )
{//从文件Web.con7g中读取连接字符串
string strconn= Con7gurationSettings.AppSettings["dsn"];
//连接本地计算机的BMS数据库,创建三个,分别供以下三个连接
SqlConnection cn= new SqlConnection (strconn);
5
评论0