buybooks.cs

图书馆信息管理系统 Library Information Management System

					dr.Read();
					if(dr.HasRows)
					{
						MessageBox.Show("该条码已经存在！请重新填写条码！","错误");
						textBox1.Text = "";
						textBox1.Focus();
					}
					dr.Close();
				}
				catch(Exception ex)
				{
					if(dr!= null)dr.Close();
					MessageBox.Show(ex.ToString() + "错误");
					return;
				}
				//创建事务
				SqlTransaction trans = Global.conn.BeginTransaction();
				cmd.Transaction = trans;

				try
				{
					str = "insert into 图书资料 values('" + textBox1.Text + "','" +
						textBox2.Text + "','" + textBox3.Text + "','" +
						textBox4.Text + "','" + textBox5.Text + "'," + Convert.ToDecimal(textBox6.Text) + ",'" +
						comboBox1.Text + "','" + dateTimePicker1.Value.ToShortDateString() + "','" +
						comboBox2.Text + "','" + dateTimePicker2.Value.ToShortDateString() + "','" +
						dateTimePicker2.Value.ToShortDateString() + "','" + 
						comboBox3.Text + "',0,0,0)";  //此处3个0分别表示借阅次数、挂失标志、注销标志
					cmd.CommandText = str;
					cmd.ExecuteNonQuery();
					trans.Commit();
					if(MessageBox.Show("成功添加记录！\n是否继续添加？","提示与询问",MessageBoxButtons.YesNo) == DialogResult.Yes)
					{
						initializeScreen();
					}
					else
					{
						this.Close();
					}
				}
				catch(Exception ex)
				{
					try
					{
						trans.Rollback();
					}
					catch (SqlException e1)
					{
						if (trans.Connection != null)
						{
							MessageBox.Show(e1.ToString());
						}
					}
					MessageBox.Show(ex.ToString(),"错误");
					initializeScreen();
				}
			}
		}
		/// <summary>
		/// 窗体加载代码
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void BuyBooks_Load(object sender, System.EventArgs e)
		{
		}
		/// <summary>
		/// 初始化
		/// </summary>
		private void initializeScreen()
		{
			this.Text = "新增图书";
			textBox1.Text = "";
			textBox2.Text = "";
			textBox3.Text = "";
			textBox4.Text = "";
			textBox5.Text = "";
			textBox6.Text = "0";
			comboBox1.Items.Clear();
			comboBox2.Items.Clear();
			comboBox3.Items.Clear();
			dateTimePicker1.Value = DateTime.Now.Date;
			dateTimePicker2.Value = DateTime.Now.Date;
			btnAddNewBook.Text = "新增";

			Global.sbpGlobal.Text = "当前模块：图书资料";

			string str = "";

			str = "select 出版社名称 from 出版社";
			cmd.CommandText = str;
			try
			{
				dr = cmd.ExecuteReader();
				while(dr.Read())
				{
					comboBox1.Items.Add(dr.GetString(0));
				}
				dr.Close();
			}
			catch(Exception ex)
			{
				if(dr!= null)dr.Close();
				MessageBox.Show(ex.ToString());
				return;
			}
			str = "select 类型名称 from 图书类型";
			cmd.CommandText = str;
			try
			{
				dr = cmd.ExecuteReader();
				while(dr.Read())
				{
					comboBox2.Items.Add(dr.GetString(0));
				}
				dr.Close();
			}
			catch(Exception ex)
			{
				if(dr!= null)dr.Close();
				MessageBox.Show(ex.ToString());
				return;
			}
			str = "select 书架名称 from 存放位置";
			cmd.CommandText = str;
			try
			{
				dr = cmd.ExecuteReader();
				while(dr.Read())
				{
					comboBox3.Items.Add(dr.GetString(0));
				}
				dr.Close();
			}
			catch(Exception ex)
			{
				if(dr != null)dr.Close();
				MessageBox.Show(ex.ToString(),"错误");
				return;
			}
			textBox1.Focus();
		}
		/// <summary>
		///  修改记录时初始化界面
		/// </summary>
		/// <param name="bt">图书条形码</param>
		private void initializeScreen(string bt)
		{
			comboBox1.Items.Clear();
			comboBox2.Items.Clear();
			comboBox3.Items.Clear();
			this.Text = "修改图书信息";
			btnAddNewBook.Text = "保存";
			string str;
			str = "select 出版社名称 from 出版社";
			cmd.CommandText = str;
			try
			{
				dr = cmd.ExecuteReader();
				while(dr.Read())
				{
					comboBox1.Items.Add(dr.GetString(0));
				}
				dr.Close();
			}
			catch(Exception ex)
			{
				if(dr!= null)dr.Close();
				MessageBox.Show(ex.ToString());
				return;
			}
			str = "select 类型名称 from 图书类型";
			cmd.CommandText = str;
			try
			{
				dr = cmd.ExecuteReader();
				while(dr.Read())
				{
					comboBox2.Items.Add(dr.GetString(0));
				}
				dr.Close();
			}
			catch(Exception ex)
			{
				if(dr!= null)dr.Close();
				MessageBox.Show(ex.ToString());
				return;
			}
			str = "select 书架名称 from 存放位置";
			cmd.CommandText = str;
			try
			{
				dr = cmd.ExecuteReader();
				while(dr.Read())
				{
					comboBox3.Items.Add(dr.GetString(0));
				}
				dr.Close();
			}
			catch(Exception ex)
			{
				if(dr != null)dr.Close();
				MessageBox.Show(ex.ToString(),"错误");
				return;
			}
			str = "select * from 图书资料 where 条形码='" + bt + "'";
			cmd.CommandText = str;
			try
			{
				dr = cmd.ExecuteReader();
				dr.Read();
				if(dr.HasRows)
				{
					string s1 = dr.GetString(1);
					string s2 = dr.GetString(2);
					string s3 = dr.GetString(3);
					string s4 = dr.GetString(4);
					string s5 = dr.GetString(5);
					string s6 = dr.GetDecimal(6).ToString();
					string s7 = dr.GetString(7);
					DateTime dt1 = dr.GetDateTime(8);
					string s8 = dr.GetString(9);
					DateTime dt2 = dr.GetDateTime(10);
					DateTime dt3 = dr.GetDateTime(11);
					string s9 = dr.GetString(12);
					if(dr!=null)dr.Close();
					textBox1.Text = s1;
					textBox2.Text = s2;
					textBox3.Text = s3;
					textBox4.Text = s4;
					textBox5.Text = s5;
					comboBox1.Text = s7;
					textBox6.Text = s6;
					dateTimePicker1.Value = dt1;
					comboBox2.Text = s8;
					dateTimePicker2.Value = dt2;
					dateTimePicker3.Value = dt3;
					comboBox3.Text = s9;
				}
				if(dr!=null)dr.Close();
			}
			catch(Exception ex)
			{
				if(dr!=null)dr.Close();
				MessageBox.Show(ex.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
				return;
			}
		}
		/// <summary>
		/// ISBN
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void textBox4_TextChanged(object sender, System.EventArgs e)
		{
			if(textBox4.Text == "")
			{
				comboBox1.Text = "";
			}
			else
			{
				string str = "select 出版社名称 from 出版社 where ISBN like '" + textBox4.Text + "%'";
				cmd.CommandText = str;
				try
				{
					dr = cmd.ExecuteReader();
					while(dr.Read())
					{
						if(dr.HasRows)
						{
							comboBox1.Text = dr.GetString(0);
						}
					}
					dr.Close();
				}
				catch(Exception ex)
				{
					if(dr!= null)dr.Close();
					MessageBox.Show(ex.ToString() + "错误");
					initializeScreen();
					textBox1.Focus();
					return;
				}
			}
		}
		/// <summary>
		/// 分类号
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void textBox2_TextChanged(object sender, System.EventArgs e)
		{
			if(textBox2.Text == "")
			{
				comboBox2.Text = "";
			}
			else
			{
				TextInfo myTI = new CultureInfo("en-US",false).TextInfo;
				textBox2.Text = myTI.ToUpper(textBox2.Text);
				textBox2.SelectionStart = textBox2.Text.Length;
				string str = "select 类型名称 from 图书类型 where 分类号 like '" + textBox2.Text + "%'";
				cmd.CommandText = str;
				try
				{
					dr = cmd.ExecuteReader();
					while(dr.Read())
					{
						if(dr.HasRows)
						{
							comboBox2.Text = dr.GetString(0);
						}
					}
					dr.Close();
				}
				catch(Exception ex)
				{
					if(dr!= null)dr.Close();
					MessageBox.Show(ex.ToString() + "错误");
					initializeScreen();
					textBox1.Focus();
					return;
				}
			}
		}
	}
}