?? frmbillmanage.vb
字號:
Me.TextBox20 = New System.Windows.Forms.TextBox
Me.Label23 = New System.Windows.Forms.Label
Me.TextBox19 = New System.Windows.Forms.TextBox
Me.Label22 = New System.Windows.Forms.Label
Me.TextBox18 = New System.Windows.Forms.TextBox
Me.Label21 = New System.Windows.Forms.Label
Me.TextBox17 = New System.Windows.Forms.TextBox
Me.Label20 = New System.Windows.Forms.Label
Me.TextBox16 = New System.Windows.Forms.TextBox
Me.Label19 = New System.Windows.Forms.Label
Me.TextBox15 = New System.Windows.Forms.TextBox
Me.Label18 = New System.Windows.Forms.Label
Me.TextBox14 = New System.Windows.Forms.TextBox
Me.Label17 = New System.Windows.Forms.Label
Me.TextBox13 = New System.Windows.Forms.TextBox
Me.Label16 = New System.Windows.Forms.Label
Me.TextBox12 = New System.Windows.Forms.TextBox
Me.Label15 = New System.Windows.Forms.Label
Me.TextBox11 = New System.Windows.Forms.TextBox
Me.Label14 = New System.Windows.Forms.Label
Me.TextBox10 = New System.Windows.Forms.TextBox
Me.Label13 = New System.Windows.Forms.Label
Me.TextBox9 = New System.Windows.Forms.TextBox
Me.Label12 = New System.Windows.Forms.Label
Me.TextBox8 = New System.Windows.Forms.TextBox
Me.Label11 = New System.Windows.Forms.Label
Me.TextBox7 = New System.Windows.Forms.TextBox
Me.Label10 = New System.Windows.Forms.Label
Me.Label9 = New System.Windows.Forms.Label
Me.TextBox5 = New System.Windows.Forms.TextBox
Me.Label8 = New System.Windows.Forms.Label
Me.Label7 = New System.Windows.Forms.Label
Me.TextBox3 = New System.Windows.Forms.TextBox
Me.Label6 = New System.Windows.Forms.Label
Me.TextBox2 = New System.Windows.Forms.TextBox
Me.Label5 = New System.Windows.Forms.Label
Me.TextBox1 = New System.Windows.Forms.TextBox
Me.Label4 = New System.Windows.Forms.Label
CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).BeginInit()
Me.GroupBox1.SuspendLayout()
Me.SuspendLayout()
'
'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("計劃類別", "計劃類別"), New System.Data.Common.DataColumnMapping("狀態類別", "狀態類別"), New System.Data.Common.DataColumnMapping("歸屬類別", "歸屬類別"), New System.Data.Common.DataColumnMapping("價值類別", "價值類別"), New System.Data.Common.DataColumnMapping("物料特性a", "物料特性a"), New System.Data.Common.DataColumnMapping("物料特性b", "物料特性b"), New System.Data.Common.DataColumnMapping("物料特性c", "物料特性c"), New System.Data.Common.DataColumnMapping("物料特性d", "物料特性d"), 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("進貨提前期", "進貨提前期"), 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("庫存期限", "庫存期限"), 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("生產車間", "生產車間")})})
Me.SqlDataAdapter1.UpdateCommand = Me.SqlUpdateCommand1
'
'SqlDeleteCommand1
'
Me.SqlDeleteCommand1.CommandText = "DELETE FROM 物料主文件 WHERE (物料編號 = @Original_物料編號) AND (價值類別 = @Original_價值類別 OR @Or" & _
"iginal_價值類別 IS NULL AND 價值類別 IS NULL) AND (低層碼 = @Original_低層碼 OR @Original_低層碼 " & _
"IS NULL AND 低層碼 IS NULL) AND (凈重 = @Original_凈重 OR @Original_凈重 IS NULL AND 凈重 I" & _
"S NULL) AND (準備周期 = @Original_準備周期 OR @Original_準備周期 IS NULL AND 準備周期 IS NULL) A" & _
"ND (品牌 = @Original_品牌 OR @Original_品牌 IS NULL AND 品牌 IS NULL) AND (定貨策略 = @Origi" & _
"nal_定貨策略 OR @Original_定貨策略 IS NULL AND 定貨策略 IS NULL) AND (寬 = @Original_寬 OR @Or" & _
"iginal_寬 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 N" & _
"ULL) 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 @O" & _
"riginal_指定供貨商 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 NU" & _
"LL AND 最小包裝量 IS NULL) AND (最高庫存 = @Original_最高庫存 OR @Original_最高庫存 IS NULL AND 最" & _
"高庫存 IS NULL) AND (條碼 = @Original_條碼 OR @Original_條碼 IS NULL AND 條碼 IS NULL) AND " & _
"(物料名稱 = @Original_物料名稱) AND (物料特性a = @Original_物料特性a OR @Original_物料特性a IS NULL " & _
"AND 物料特性a IS NULL) AND (物料特性b = @Original_物料特性b OR @Original_物料特性b IS NULL AND 物" & _
"料特性b IS NULL) AND (物料特性c = @Original_物料特性c OR @Original_物料特性c IS NULL AND 物料特性c " & _
"IS NULL) AND (物料特性d = @Original_物料特性d OR @Original_物料特性d IS NULL AND 物料特性d IS NU" & _
"LL) AND (狀態類別 = @Original_狀態類別 OR @Original_狀態類別 IS NULL AND 狀態類別 IS NULL) 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_" & _
"規格型號 IS NULL AND 規格型號 IS NULL) AND (計劃類別 = @Original_計劃類別 OR @Original_計劃類別 IS N" & _
"ULL AND 計劃類別 IS NULL) AND (計量單位 = @Original_計量單位) AND (進貨提前期 = @Original_進貨提前期 O" & _
"R @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)"
Me.SqlDeleteCommand1.Connection = Me.SqlConnection1
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_物料編號", System.Data.SqlDbType.VarChar, 14, 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, 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.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.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, 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, 10, 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, 10, 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.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, 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, 5, 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, 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.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(4, Byte), "批量", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_拼音編碼", System.Data.SqlDbType.VarChar, 10, 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, 10, 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.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, Byte), "最低庫存", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_最低銷售量", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, Byte), "最低銷售量", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_最小包裝量", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, Byte), "最小包裝量", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_最高庫存", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, Byte), "最高庫存", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_條碼", System.Data.SqlDbType.VarChar, 14, 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, 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_物料特性a", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "物料特性a", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_物料特性b", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "物料特性b", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_物料特性c", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "物料特性c", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_物料特性d", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "物料特性d", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_狀態類別", System.Data.SqlDbType.VarChar, 5, 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, 10, 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, 10, 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.VarChar, 5, 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, 10, 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.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, Byte), "長", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_顏色", System.Data.SqlDbType.VarChar, 10, 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.Decimal, 9, System.Data.ParameterDirection.Input, False, CType(18, Byte), CType(3, Byte), "高", System.Data.DataRowVersion.Original, Nothing))
'
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -