?? frmbookdoc.vb

?? 數(shù)據(jù)庫課程設(shè)計。
?? VB
?? 第 1 頁 / 共 4 頁
字號:
        '
        'txbCode
        '
        Me.txbCode.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DataSet11, "圖書信息.條形碼"))
        Me.txbCode.Location = New System.Drawing.Point(16, 32)
        Me.txbCode.Name = "txbCode"
        Me.txbCode.Size = New System.Drawing.Size(88, 21)
        Me.txbCode.TabIndex = 3
        Me.txbCode.Text = ""
        '
        'Label4
        '
        Me.Label4.Location = New System.Drawing.Point(13, 16)
        Me.Label4.Name = "Label4"
        Me.Label4.Size = New System.Drawing.Size(56, 16)
        Me.Label4.TabIndex = 2
        Me.Label4.Text = "條形碼"
        '
        'SqlDataAdapter1
        '
        Me.SqlDataAdapter1.DeleteCommand = Me.SqlDeleteCommand1
        Me.SqlDataAdapter1.InsertCommand = Me.SqlInsertCommand1
        Me.SqlDataAdapter1.SelectCommand = Me.SqlSelectCommand1
        Me.SqlDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "圖書信息", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("條形碼", "條形碼"), New System.Data.Common.DataColumnMapping("編號", "編號"), New System.Data.Common.DataColumnMapping("書名", "書名"), New System.Data.Common.DataColumnMapping("類型", "類型"), New System.Data.Common.DataColumnMapping("作者", "作者"), New System.Data.Common.DataColumnMapping("譯者", "譯者"), New System.Data.Common.DataColumnMapping("ISBN", "ISBN"), New System.Data.Common.DataColumnMapping("出版社", "出版社"), New System.Data.Common.DataColumnMapping("價格", "價格"), New System.Data.Common.DataColumnMapping("頁碼", "頁碼"), New System.Data.Common.DataColumnMapping("書架名稱", "書架名稱"), New System.Data.Common.DataColumnMapping("現(xiàn)存量", "現(xiàn)存量"), New System.Data.Common.DataColumnMapping("庫存總量", "庫存總量"), New System.Data.Common.DataColumnMapping("入庫時間", "入庫時間"), New System.Data.Common.DataColumnMapping("操作員", "操作員"), New System.Data.Common.DataColumnMapping("簡介", "簡介"), New System.Data.Common.DataColumnMapping("借出次數(shù)", "借出次數(shù)"), New System.Data.Common.DataColumnMapping("是否注銷", "是否注銷")})})
        Me.SqlDataAdapter1.UpdateCommand = Me.SqlUpdateCommand1
        '
        'SqlDeleteCommand1
        '
        Me.SqlDeleteCommand1.CommandText = "DELETE FROM 圖書信息 WHERE (編號 = @Original_編號) AND (ISBN = @Original_ISBN OR @Origina" & _
        "l_ISBN IS NULL AND ISBN IS NULL) AND (書名 = @Original_書名 OR @Original_書名 IS NULL " & _
        "AND 書名 IS NULL) AND (書架名稱 = @Original_書架名稱 OR @Original_書架名稱 IS NULL AND 書架名稱 IS" & _
        " NULL) AND (價格 = @Original_價格 OR @Original_價格 IS NULL AND 價格 IS NULL) AND (作者 = " & _
        "@Original_作者 OR @Original_作者 IS NULL AND 作者 IS NULL) AND (借出次數(shù) = @Original_借出次數(shù) " & _
        "OR @Original_借出次數(shù) IS NULL AND 借出次數(shù) IS NULL) AND (入庫時間 = @Original_入庫時間 OR @Origi" & _
        "nal_入庫時間 IS NULL AND 入庫時間 IS NULL) AND (出版社 = @Original_出版社 OR @Original_出版社 IS " & _
        "NULL AND 出版社 IS NULL) AND (庫存總量 = @Original_庫存總量 OR @Original_庫存總量 IS NULL AND 庫" & _
        "存總量 IS NULL) AND (操作員 = @Original_操作員 OR @Original_操作員 IS NULL AND 操作員 IS NULL) " & _
        "AND (是否注銷 = @Original_是否注銷) AND (條形碼 = @Original_條形碼 OR @Original_條形碼 IS NULL AN" & _
        "D 條形碼 IS NULL) AND (現(xiàn)存量 = @Original_現(xiàn)存量 OR @Original_現(xiàn)存量 IS NULL AND 現(xiàn)存量 IS NULL" & _
        ") AND (簡介 = @Original_簡介 OR @Original_簡介 IS NULL AND 簡介 IS NULL) AND (類型 = @Orig" & _
        "inal_類型 OR @Original_類型 IS NULL AND 類型 IS NULL) AND (譯者 = @Original_譯者 OR @Origi" & _
        "nal_譯者 IS NULL AND 譯者 IS NULL) AND (頁碼 = @Original_頁碼 OR @Original_頁碼 IS NULL AN" & _
        "D 頁碼 IS NULL)"
        Me.SqlDeleteCommand1.Connection = Me.SqlConnection1
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_編號", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "編號", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ISBN", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ISBN", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_書名", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "書名", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_書架名稱", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "書架名稱", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_價格", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "價格", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_作者", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "作者", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_借出次數(shù)", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "借出次數(shù)", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_入庫時間", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "入庫時間", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_出版社", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "出版社", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_庫存總量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "庫存總量", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_操作員", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "操作員", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_是否注銷", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "是否注銷", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "條形碼", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_現(xiàn)存量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "現(xiàn)存量", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_簡介", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "簡介", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_類型", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "類型", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_譯者", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "譯者", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_頁碼", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "頁碼", System.Data.DataRowVersion.Original, Nothing))
        '
        'SqlConnection1
        '
        Me.SqlConnection1.ConnectionString = "workstation id=CS;packet size=4096;integrated security=SSPI;data source=CS;persis" & _
        "t security info=False;initial catalog=libbook"
        '
        'SqlInsertCommand1
        '
        Me.SqlInsertCommand1.CommandText = "INSERT INTO 圖書信息(條形碼, 編號, 書名, 類型, 作者, 譯者, ISBN, 出版社, 價格, 頁碼, 書架名稱, 現(xiàn)存量, 庫存總量, 入庫時" & _
        "間, 操作員, 簡介, 借出次數(shù), 是否注銷) VALUES (@條形碼, @編號, @書名, @類型, @作者, @譯者, @ISBN, @出版社, @價格," & _
        " @頁碼, @書架名稱, @現(xiàn)存量, @庫存總量, @入庫時間, @操作員, @簡介, @借出次數(shù), @是否注銷); SELECT 條形碼, 編號, 書名, 類" & _
        "型, 作者, 譯者, ISBN, 出版社, 價格, 頁碼, 書架名稱, 現(xiàn)存量, 庫存總量, 入庫時間, 操作員, 簡介, 借出次數(shù), 是否注銷 FROM 圖書" & _
        "信息 WHERE (編號 = @編號)"
        Me.SqlInsertCommand1.Connection = Me.SqlConnection1
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 40, "條形碼"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@編號", System.Data.SqlDbType.VarChar, 50, "編號"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@書名", System.Data.SqlDbType.VarChar, 200, "書名"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@類型", System.Data.SqlDbType.VarChar, 100, "類型"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@作者", System.Data.SqlDbType.VarChar, 100, "作者"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@譯者", System.Data.SqlDbType.VarChar, 100, "譯者"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ISBN", System.Data.SqlDbType.VarChar, 40, "ISBN"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@出版社", System.Data.SqlDbType.VarChar, 100, "出版社"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@價格", System.Data.SqlDbType.Money, 8, "價格"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@頁碼", System.Data.SqlDbType.Int, 4, "頁碼"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@書架名稱", System.Data.SqlDbType.VarChar, 200, "書架名稱"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@現(xiàn)存量", System.Data.SqlDbType.Int, 4, "現(xiàn)存量"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@庫存總量", System.Data.SqlDbType.Int, 4, "庫存總量"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@入庫時間", System.Data.SqlDbType.DateTime, 4, "入庫時間"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@操作員", System.Data.SqlDbType.VarChar, 20, "操作員"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@簡介", System.Data.SqlDbType.VarChar, 100, "簡介"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@借出次數(shù)", System.Data.SqlDbType.Int, 4, "借出次數(shù)"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@是否注銷", System.Data.SqlDbType.Bit, 1, "是否注銷"))
        '
        'SqlSelectCommand1
        '
        Me.SqlSelectCommand1.CommandText = "SELECT 條形碼, 編號, 書名, 類型, 作者, 譯者, ISBN, 出版社, 價格, 頁碼, 書架名稱, 現(xiàn)存量, 庫存總量, 入庫時間, 操作員, 簡介" & _
        ", 借出次數(shù), 是否注銷 FROM 圖書信息"
        Me.SqlSelectCommand1.Connection = Me.SqlConnection1
        '
        'SqlUpdateCommand1
        '
        Me.SqlUpdateCommand1.CommandText = "UPDATE 圖書信息 SET 條形碼 = @條形碼, 編號 = @編號, 書名 = @書名, 類型 = @類型, 作者 = @作者, 譯者 = @譯者, ISB" & _
        "N = @ISBN, 出版社 = @出版社, 價格 = @價格, 頁碼 = @頁碼, 書架名稱 = @書架名稱, 現(xiàn)存量 = @現(xiàn)存量, 庫存總量 = @庫存總" & _
        "量, 入庫時間 = @入庫時間, 操作員 = @操作員, 簡介 = @簡介, 借出次數(shù) = @借出次數(shù), 是否注銷 = @是否注銷 WHERE (編號 = @O" & _
        "riginal_編號) AND (ISBN = @Original_ISBN OR @Original_ISBN IS NULL AND ISBN IS NUL" & _
        "L) AND (書名 = @Original_書名 OR @Original_書名 IS NULL AND 書名 IS NULL) AND (書架名稱 = @O" & _
        "riginal_書架名稱 OR @Original_書架名稱 IS NULL AND 書架名稱 IS NULL) AND (價格 = @Original_價格 " & _
        "OR @Original_價格 IS NULL AND 價格 IS NULL) AND (作者 = @Original_作者 OR @Original_作者 I" & _
        "S NULL AND 作者 IS NULL) AND (借出次數(shù) = @Original_借出次數(shù) OR @Original_借出次數(shù) IS NULL AND " & _
        "借出次數(shù) IS NULL) AND (入庫時間 = @Original_入庫時間 OR @Original_入庫時間 IS NULL AND 入庫時間 IS N" & _
        "ULL) AND (出版社 = @Original_出版社 OR @Original_出版社 IS NULL AND 出版社 IS NULL) AND (庫存總" & _
        "量 = @Original_庫存總量 OR @Original_庫存總量 IS NULL AND 庫存總量 IS NULL) AND (操作員 = @Origi" & _
        "nal_操作員 OR @Original_操作員 IS NULL AND 操作員 IS NULL) AND (是否注銷 = @Original_是否注銷) AN" & _
        "D (條形碼 = @Original_條形碼 OR @Original_條形碼 IS NULL AND 條形碼 IS NULL) AND (現(xiàn)存量 = @Ori" & _
        "ginal_現(xiàn)存量 OR @Original_現(xiàn)存量 IS NULL AND 現(xiàn)存量 IS NULL) AND (簡介 = @Original_簡介 OR @O" & _
        "riginal_簡介 IS NULL AND 簡介 IS NULL) AND (類型 = @Original_類型 OR @Original_類型 IS NUL" & _
        "L AND 類型 IS NULL) AND (譯者 = @Original_譯者 OR @Original_譯者 IS NULL AND 譯者 IS NULL)" & _
        " AND (頁碼 = @Original_頁碼 OR @Original_頁碼 IS NULL AND 頁碼 IS NULL); SELECT 條形碼, 編號," & _
        " 書名, 類型, 作者, 譯者, ISBN, 出版社, 價格, 頁碼, 書架名稱, 現(xiàn)存量, 庫存總量, 入庫時間, 操作員, 簡介, 借出次數(shù), 是否注銷 F" & _
        "ROM 圖書信息 WHERE (編號 = @編號)"
        Me.SqlUpdateCommand1.Connection = Me.SqlConnection1
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 40, "條形碼"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@編號", System.Data.SqlDbType.VarChar, 50, "編號"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@書名", System.Data.SqlDbType.VarChar, 200, "書名"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@類型", System.Data.SqlDbType.VarChar, 100, "類型"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@作者", System.Data.SqlDbType.VarChar, 100, "作者"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@譯者", System.Data.SqlDbType.VarChar, 100, "譯者"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ISBN", System.Data.SqlDbType.VarChar, 40, "ISBN"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@出版社", System.Data.SqlDbType.VarChar, 100, "出版社"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@價格", System.Data.SqlDbType.Money, 8, "價格"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@頁碼", System.Data.SqlDbType.Int, 4, "頁碼"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@書架名稱", System.Data.SqlDbType.VarChar, 200, "書架名稱"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@現(xiàn)存量", System.Data.SqlDbType.Int, 4, "現(xiàn)存量"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@庫存總量", System.Data.SqlDbType.Int, 4, "庫存總量"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@入庫時間", System.Data.SqlDbType.DateTime, 4, "入庫時間"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@操作員", System.Data.SqlDbType.VarChar, 20, "操作員"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@簡介", System.Data.SqlDbType.VarChar, 100, "簡介"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@借出次數(shù)", System.Data.SqlDbType.Int, 4, "借出次數(shù)"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@是否注銷", System.Data.SqlDbType.Bit, 1, "是否注銷"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_編號", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "編號", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ISBN", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ISBN", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_書名", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "書名", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_書架名稱", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "書架名稱", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_價格", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "價格", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_作者", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "作者", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_借出次數(shù)", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "借出次數(shù)", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_入庫時間", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "入庫時間", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_出版社", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "出版社", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_庫存總量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "庫存總量", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_操作員", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "操作員", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_是否注銷", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "是否注銷", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "條形碼", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_現(xiàn)存量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "現(xiàn)存量", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_簡介", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "簡介", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_類型", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "類型", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_譯者", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "譯者", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_頁碼", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "頁碼", System.Data.DataRowVersion.Original, Nothing))
        '
        'frmBookDoc
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(608, 317)
        Me.Controls.Add(Me.GroupBox1)
        Me.Name = "frmBookDoc"
        Me.Controls.SetChildIndex(Me.GroupBox1, 0)
        Me.GroupBox1.ResumeLayout(False)
        CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub#End Region    Public Overrides Sub Prepare()
        Me.Text = "圖書檔案管理"
        Me.Label1.Text = "  條形碼"
        Me.Label2.Text = "    編號"
        Me.Label3.Text = "    書名"
?? 文件大小 598 K
?? 上傳用戶 szdoudou
?? 所屬分類數(shù)據(jù)庫系統(tǒng)
??? 相關(guān)標(biāo)簽

#數(shù)據(jù)庫
?? 快捷鍵說明

復(fù)制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? frmbookdoc.vb

?? 快捷鍵說明
