choosebook.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.Data.SqlClient;
namespace BookManager
{
	/// <summary>
	/// ChooseBook 的摘要说明。
	/// </summary>
	public class ChooseBook : System.Web.UI.Page
	{
		protected System.Data.SqlClient.SqlDataAdapter sqlAdapter;
		protected System.Data.SqlClient.SqlConnection sqlConn;
		protected BookManager.dsChooseBook dsChooseBookInfo;
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand2;
		protected System.Web.UI.WebControls.DropDownList dpClass;
		protected System.Web.UI.WebControls.Button btSumbit;
		protected System.Web.UI.WebControls.Button btReset;
		protected System.Web.UI.WebControls.DataGrid dgChoose;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{
				if(Session["Role"].ToString()!="0")
				{
					
					Response.Redirect("NotAllow.htm");
					Response.Write("<script language='javascript'>alert('您的权限不相符');</script>");
					return;
				}
				this.DataBinds();
				this.ClassBind();
				if(dgChoose.Items.Count==0)
				{
					Response.Redirect("NoData.aspx");
				}
			}

		}

		private void DataBinds()
		{
			sqlAdapter.Fill(dsChooseBookInfo);
			dgChoose.DataBind();
		}
		private void ClassBind()
		{
			string sqlStr="select * from tblClass";
			SqlCommand cmd=new SqlCommand(sqlStr,sqlConn);
			sqlConn.Open();
			SqlDataReader rder=cmd.ExecuteReader();
			while(rder.Read())
			{
				dpClass.Items.Add(rder["ClassName"].ToString());
			}
			rder.Close();
			sqlConn.Close();
		}

		private void AddClassBook(string ClassId,string BookId,string TakenNum,string TrueTaken)
		{
			string sqlStr;
			sqlStr="insert into tblClassChsBook values(@ClassId,@BookId,@TakenNum,@TrueTaken)";
			SqlCommand cmd=new SqlCommand(sqlStr,sqlConn);
			cmd.Parameters.Add("@ClassId",ClassId);
			cmd.Parameters.Add("@BookId",BookId);
			cmd.Parameters.Add("@TakenNum",TakenNum);
			cmd.Parameters.Add("@TrueTaken",TrueTaken);
			sqlConn.Open();
			cmd.ExecuteNonQuery();
			sqlConn.Close();
		}

		private void SubBookNum(string BookId,string TakenNum)
		{
			string sqlStr;
			sqlStr="update tblBookStorage set Storage=@Storage where BookId=@BookId ";
			SqlCommand cmd=new SqlCommand(sqlStr,sqlConn);
			cmd.Parameters.Add("@Storage",TakenNum);
			cmd.Parameters.Add("@BookId",BookId);
			sqlConn.Open();
			cmd.ExecuteNonQuery();
			sqlConn.Close();

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.sqlAdapter = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
			this.sqlConn = new System.Data.SqlClient.SqlConnection();
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.dsChooseBookInfo = new BookManager.dsChooseBook();
			((System.ComponentModel.ISupportInitialize)(this.dsChooseBookInfo)).BeginInit();
			this.btSumbit.Click += new System.EventHandler(this.btSumbit_Click);
			this.btReset.Click += new System.EventHandler(this.btReset_Click);
			// 
			// sqlAdapter
			// 
			this.sqlAdapter.SelectCommand = this.sqlSelectCommand2;
			this.sqlAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								 new System.Data.Common.DataTableMapping("Table", "tblBookInfo", new System.Data.Common.DataColumnMapping[] {
																																																				new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																				new System.Data.Common.DataColumnMapping("BookName", "BookName"),
																																																				new System.Data.Common.DataColumnMapping("Author", "Author"),
																																																				new System.Data.Common.DataColumnMapping("BookMark", "BookMark"),
																																																				new System.Data.Common.DataColumnMapping("Attribute", "Attribute"),
																																																				new System.Data.Common.DataColumnMapping("Storage", "Storage"),
																																																				new System.Data.Common.DataColumnMapping("Expr1", "Expr1")})});
			// 
			// sqlSelectCommand2
			// 
			this.sqlSelectCommand2.CommandText = @"SELECT tblBookInfo.ID, tblBookInfo.BookName, tblBookInfo.Author, tblBookInfo.BookMark, tblBookInfo.Attribute, tblBookStorage.Storage, tblBookStorage.ID AS Expr1 FROM tblBookInfo INNER JOIN tblBookStorage ON tblBookInfo.ID = tblBookStorage.BookId WHERE (tblBookInfo.Attribute = 1)";
			this.sqlSelectCommand2.Connection = this.sqlConn;
			// 
			// sqlConn
			// 
			this.sqlConn.ConnectionString = "workstation id=QMX;packet size=4096;user id=sa;data source=\"QMX\\THUNDER\";persist " +
				"security info=True;initial catalog=BookManager;password=gliu0307";
			// 
			// dsChooseBookInfo
			// 
			this.dsChooseBookInfo.DataSetName = "dsChooseBook";
			this.dsChooseBookInfo.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dsChooseBookInfo)).EndInit();

		}
		#endregion

		private void btSumbit_Click(object sender, System.EventArgs e)
		{
			//添加班级选择的教材信息
			int NoChecked=0;
			foreach(DataGridItem dgi in dgChoose.Items)
			{
				CheckBox cb = (CheckBox)dgi.FindControl("cbSelect");
				TextBox tbNum=(TextBox)dgi.FindControl("tbNeedChoose");
				TextBox tbTrue=(TextBox)dgi.FindControl("tbTrueChoose");
				if(cb.Checked)
				{
					string BookId = dgi.Cells[0].Text.ToString();
					string ClassId=Convert.ToString(dpClass.SelectedIndex+1);
					if(tbNum.Text.ToString().Trim()=="")
					{
						Response.Write("<script language='javascript'>alert('请输入"+dgi.Cells[2].Text.ToString() +"的需求数量');</script>" );
						return;
					}
					if(tbTrue.Text.ToString().Trim()=="")
					{
						Response.Write("<script language='javascript'>alert('请输入"+dgi.Cells[2].Text.ToString()+"的实际取出数量');</script>");
						return;
					}
					if(int.Parse(tbNum.Text)<int.Parse(tbTrue.Text))
					{
						Response.Write("<script language='javascript'>alert('"+dgi.Cells[2].Text.ToString()+"的实际取出数量大于取出数量，请重新填写');</script>");
						return;
					}
					if(int.Parse(tbTrue.Text)>int.Parse(dgi.Cells[5].Text))
					{
						Response.Write("<script language='javascript'>alert('"+dgi.Cells[2].Text.ToString()+"的库存不足');</script>");
						return;
					}
					int Storage=int.Parse(dgi.Cells[5].Text)-int.Parse(tbTrue.Text);
					this.SubBookNum(BookId,Convert.ToString(Storage));
					this.AddClassBook(ClassId,BookId,tbNum.Text.ToString(),tbTrue.Text.ToString());
				}
				else
				{
					NoChecked=NoChecked+1;
				}
			}
			if(NoChecked==dgChoose.Items.Count)
			{
				Response.Write("<script language='javascript'>alert('请选择您需要的教材！');</script>");
				return;
			}
			//修改库存表里的信息，即减去被提取的教材数量
			Response.Redirect("SubmitOk.aspx");
		}

		private void btReset_Click(object sender, System.EventArgs e)
		{
			foreach(DataGridItem dgi in dgChoose.Items)
			{
				CheckBox cb = (CheckBox)dgi.FindControl("cbSelect");
				TextBox tbNum=(TextBox)dgi.FindControl("tbNeedChoose");
				TextBox tbTrue=(TextBox)dgi.FindControl("tbTrueChoose");
				cb.Checked=false;
				tbNum.Text="";
				tbTrue.Text="";
			}
		}
	}
}