using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?Library
{
????public?partial?class?addBook?:?Form
????{
????????private?int?FlAG?=?1;
????????private?string?strConn?=?@“Data?Source=ENVI;Initial?Catalog=Librarymanage;uid=王彬;pwd=123456“;
????????public?addBook（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?ID;
????????????if?（textBox1.Text?==?““）
????????????{
????????????????MessageBox.Show（“圖書編碼不能為空！“?“添加失敗“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????return;
????????????}
????????????else
????????????{
????????????????ID?=?textBox1.Text;
????????????}
????????????string?ISBN?=?textBox2.Text.Trim（）;
????????????string?name?=?textBox3.Text.Trim（）;
????????????string?type?=?textBox4.Text.Trim（）;
????????????string?author?=?textBox5.Text.Trim（）;
????????????string?press?=?textBox6.Text.Trim（）;
????????????string?pressdate?=?textBox7.Text.Trim（）;
????????????string?price?=?textBox8.Text.Trim（）;
????????????string?inputdate?=?textBox9.Text.Trim（）;
????????????string?quantity?=?textBox10.Text.Trim（）;
????????????string?isborrow?=?comboBox1.Text.Trim（）;
????????????try
????????????{
????????????????SqlConnection?conn?=?new?SqlConnection（strConn）;
????????????????SqlCommand?cmd_maxid?=?new?SqlCommand（）;
????????????????cmd_maxid.Connection?=?conn;
????????????????conn.Open（）;
????????????????SqlCommand?cmd_insert?=?new?SqlCommand（）;
????????????????cmd_insert.Connection?=?conn;
????????????????cmd_insert.CommandText?=?“insert?into?Bookinfo（Book_IDBook_ISBNBook_nameBook_typeBook_authorBook_pressBook_pressdateBook_priceBook_inputdateBook_quantityBook_isborrow）“;
????????????????cmd_insert.CommandText?+=?“values（@BookID@BookISBN@Bookname@Booktype@Bookauthor@Bookpress@Bookpressdate@Bookprice@Bookinputdate@Bookquantity@Bookisborrow）“;
????????????????cmd_insert.Parameters.Add（“@BookID“?SqlDbType.NVarChar?8）;
????????????????cmd_insert.Parameters.Add（“@BookISBN“?SqlDbType.NVarChar?30）;
????????????????cmd_insert.Parameters.Add（“@Bookname“?SqlDbType.NVarChar?50）;
????????????????cmd_insert.Parameters.Add（“@Booktype“?SqlDbType.NVarChar?30）;
????????????????cmd_insert.Parameters.Add（“@Bookauthor“?SqlDbType.NVarChar?30）;
????????????????cmd_insert.Parameters.Add（“@Bookpress“?SqlDbType.NVarChar?50）;
????????????????cmd_insert.Parameters.Add（“@Bookpressdate“?SqlDbType.DateTime）;
????????????????cmd_insert.Parameters.Add（“@Bookprice“?SqlDbType.Money）;
????????????????cmd_insert.Parameters.Add（“@Bookinputdate“?SqlDbType.DateTime）;
??????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????..A..H.?????88064??2017-06-28?12:08??C#圖書管理系統\Library\.vs\Library\v14\.suo

?????文件???????4523??2017-06-27?16:05??C#圖書管理系統\Library\Library\addBook.cs

?????文件??????16063??2017-06-27?16:05??C#圖書管理系統\Library\Library\addBook.Designer.cs

?????文件?????107589??2017-06-27?16:05??C#圖書管理系統\Library\Library\addBook.resx

?????文件???????5215??2017-06-27?17:30??C#圖書管理系統\Library\Library\addReader.cs

?????文件??????18234??2017-06-27?17:27??C#圖書管理系統\Library\Library\addReader.Designer.cs

?????文件??????86083??2017-06-27?17:27??C#圖書管理系統\Library\Library\addReader.resx

?????文件???????3314??2017-06-27?16:05??C#圖書管理系統\Library\Library\addUser.cs

?????文件???????9000??2017-06-27?16:05??C#圖書管理系統\Library\Library\addUser.Designer.cs

?????文件?????107589??2017-06-27?16:05??C#圖書管理系統\Library\Library\addUser.resx

?????文件????????521??2017-06-24?11:18??C#圖書管理系統\Library\Library\App.config

?????文件????1902080??2017-06-28?09:06??C#圖書管理系統\Library\Library\bin\Debug\Library.exe

?????文件????????521??2017-06-24?11:18??C#圖書管理系統\Library\Library\bin\Debug\Library.exe.config

?????文件?????534016??2017-06-28?09:06??C#圖書管理系統\Library\Library\bin\Debug\Library.pdb

?????文件??????22696??2017-06-28?12:08??C#圖書管理系統\Library\Library\bin\Debug\Library.vshost.exe

?????文件????????521??2017-06-24?11:18??C#圖書管理系統\Library\Library\bin\Debug\Library.vshost.exe.config

?????文件????????490??2017-03-19?05:00??C#圖書管理系統\Library\Library\bin\Debug\Library.vshost.exe.manifest

?????文件??????10108??2017-06-27?22:30??C#圖書管理系統\Library\Library\borrowBook.cs

?????文件???????9508??2017-06-27?22:30??C#圖書管理系統\Library\Library\borrowBook.Designer.cs

?????文件?????107589??2017-06-27?22:30??C#圖書管理系統\Library\Library\borrowBook.resx

?????文件???????3244??2017-06-27?16:05??C#圖書管理系統\Library\Library\deleteBook.cs

?????文件??????19376??2017-06-27?16:05??C#圖書管理系統\Library\Library\deleteBook.Designer.cs

?????文件?????108210??2017-06-27?16:05??C#圖書管理系統\Library\Library\deleteBook.resx

?????文件???????3463??2017-06-27?16:05??C#圖書管理系統\Library\Library\deleteReader.cs

?????文件???????8937??2017-06-27?16:05??C#圖書管理系統\Library\Library\deleteReader.Designer.cs

?????文件??????86706??2017-06-27?16:05??C#圖書管理系統\Library\Library\deleteReader.resx

?????文件???????3443??2017-06-27?22:44??C#圖書管理系統\Library\Library\deleteUser.cs

?????文件??????14441??2017-06-27?22:44??C#圖書管理系統\Library\Library\deleteUser.Designer.cs

?????文件??????92260??2017-06-27?22:44??C#圖書管理系統\Library\Library\deleteUser.resx

?????文件???????3720??2017-06-27?18:32??C#圖書管理系統\Library\Library\editBook.cs

............此處省略160個文件信息