frmbillmanage.vb

生产管理系统。vb.net sql2

        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))
        '