【正文】 on1_Click(object sender, EventArgs e) { string id = 。 string name = 。 string xinghao = 。 string leixing = 。 string jinhuoren = 。 string connString = @Data Source=pankangpc\SQLEXPRESS。Initial Catalog=Depot。Integrated Security = SSPI。Persist Security Info=False。 SqlConnection connection = new SqlConnection(connString)。 string sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,time as 進(jìn)貨時間from Thing where Id=39。{0}39。, id)。 if (() == amp。amp。 () == amp。amp。 () == amp。amp。 () == amp。amp。 () == ) { (請輸入查詢條件！, 警告)。 return。 } if (() != ){ sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,time as 進(jìn)貨時間from Thing where Id=39。{0}39。, id)。 } else if (() == amp。amp。 () != ){ sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,time as 進(jìn)貨時間from Thing where name=39。{0}39。, name)。 } else if (() == amp。amp。 () == amp。amp。 () != ){ sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,time as 進(jìn)貨時間from Thing where xinghao=39。{0}39。, xinghao)。 } else if (() == amp。amp。 () == amp。amp。 () == amp。amp。 () != ){sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,time as 進(jìn)貨時間from Thing where leibie=39。{0}39。, leixing)。 } else if (() == amp。amp。 () == amp。amp。 () == amp。amp。 () == amp。amp。 () != ){sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,time as 進(jìn)貨時間from Thing where jinhuoren=39。{0}39。,jinhuoren )。 }()。 SqlDataAdapter adp = new SqlDataAdapter(sql, connection)。 DataSet ds = new DataSet()。()。(ds, material)。 = [0].DefaultView。 ()。 } 查看所有物品信息可以查看得倉庫所有的物品的信息，查看所有物品信息模塊部分代碼如下所示：private void button1_Click(object sender, EventArgs e) { string connString = @Data Source=pankangpc\SQLEXPRESS。Initial Catalog=Depot。Integrated Security = SSPI。Persist Security Info=False。 SqlConnection connection = new SqlConnection(connString)。 string sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,time as 進(jìn)貨時間from Thing )。 ()。 SqlDataAdapter adp = new SqlDataAdapter(sql, connection)。 DataSet ds = new DataSet()。 ()。 (ds, material)。 = [0].DefaultView。 ()。}進(jìn)貨人信息查詢可以根據(jù)編號，姓名等進(jìn)行查詢，查詢進(jìn)貨人信息模塊部分代碼如下所示：private void button1_Click(object sender, EventArgs e) { string id = 。 string name = 。 string connString = @Data Source=pankangpc\SQLEXPRESS。Initial Catalog=Depot。Integrated Security = SSPI。Persist Security Info=False。 SqlConnection connection = new SqlConnection(connString)。 string sql = (select ID as 編號,name as 姓名,sex as 性別,phone as 電話,address as 地址from Jinhuo where Id=39。{0}39。, id)。 if (() == amp。amp。 () == ) { (請輸入查詢條件！, 警告)。 return。 } if (() != ) { sql = (select ID as 編號,name as 姓名,sex as 性別,phone as 電話,address as 地址from Jinhuo where Id=39。{0}39。, id)。 } else if (() == amp。amp。 () != ) { sql = (select ID as 編號,name as 姓名,sex as 性別,phone as 電話,address as 地址from Jinhuo where name=39。{0}39。, name)。 } ()。 SqlDataAdapter adp = new SqlDataAdapter(sql, connection)。 DataSet ds = new DataSet()。 ()。 (ds, material)。 = [0].DefaultView。 ()。 }收貨人信息查詢可以根據(jù)編號，姓名等進(jìn)行查詢，查詢收貨人信息模塊部分代碼如下所示：private void button1_Click(object sender, EventArgs e) {string id = 。 string name = 。 string connString = @Data Source=pankangpc\SQLEXPRESS。Initial Catalog=Depot。Integrated Security = SSPI。Persist Security Info=False。 SqlConnection connection = new SqlConnection(connString)。 string sql = (select ID as 編號,name as 姓名,sex as 性別,phone as 電話,address as 地址from Shouhuo where Id=39。{0}39。, id)。 if (() == amp。amp。 () == ){ (請輸入查詢條件！, 警告)。 return。 } if (() != ) { sql = (select ID as 編號,name as 姓名,sex as 性別,phone as 電話,address as 地址from Shouhuo where Id=39。{0}39。, id)。 } else if (() == amp。amp。 () != ) { sql = (select ID as 編號,name as 姓名,sex as 性別,phone as 電話,address as 地址from Shouhuo where name=39。{0}39。, name)。 } ()。 SqlDataAdapter adp = new SqlDataAdapter(sql, connection)。 DataSet ds = new DataSet()。()。(ds, material)。 = [0].DefaultView。 ()。 }查詢出庫物品信息可以通過編號，名稱，型號，類型，進(jìn)貨人，收貨人等進(jìn)行查詢，查詢出庫物品信息模塊部分代碼如下所示：private void button1_Click(object sender, EventArgs e) { string id = 。 string name = 。 string xinghao = 。 string leixing = 。 string jinhuoren = 。 string shouhuoren = 。 string connString = @Data Source=pankangpc\SQLEXPRESS。Initial Catalog=Depot。Integrated Security = SSPI。Persist Security Info=False。 SqlConnection connection = new SqlConnection(connString)。 string sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,shouhuoren as 收貨人,time as 進(jìn)貨時間,time1 as 出貨時間from Chuku where Id=39。{0}39。, id)。 if (() == amp。amp。 () == amp。amp。 () == amp。amp。 () == amp。amp。 () == amp。amp。 () == ) { (請輸入查詢條件！, 警告)。return。 } if (() != ) { sql = (select ID as 編號,name as 名稱,xinghao as 型號,leibie as 類型,shuliang as 數(shù)量,jinhuoren as 進(jìn)貨人,shouhuoren as 收貨人,time as 進(jìn)貨時間,time1 as 出貨時間from Chuku where Id=39。{0}39。, id)。 } else if (() == amp。amp。 () != )