insertnew.aspx.vb

这是用ASP.NET和SQLserver编写的购物网站的程序

Imports System.Data.SqlClient

Public Class insertnew
    Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label
    Protected WithEvents Label3 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label4 As System.Web.UI.WebControls.Label
    Protected WithEvents Label5 As System.Web.UI.WebControls.Label
    Protected WithEvents Textbox3 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label6 As System.Web.UI.WebControls.Label
    Protected WithEvents Textbox4 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents DrList As System.Web.UI.WebControls.DropDownList
    Protected WithEvents Button2 As System.Web.UI.WebControls.Button
    Protected WithEvents Label7 As System.Web.UI.WebControls.Label
    Protected WithEvents Textbox5 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label8 As System.Web.UI.WebControls.Label

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region
    Dim cm As SqlCommand
    Dim Cstring As String = ConfigurationSettings.AppSettings("ConnectionString")
    Dim nwindConn As SqlConnection = New SqlConnection(Cstring)
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        If Not IsPostBack Then
            Try
                If (Session("userpower") <> 2) Then
                    Response.End()
                End If
            Catch ex As Exception
                Response.Write("您不是管理者,不能打开该页,<a href='managerlogin.aspx'>管理员登录</a>")
                Response.End()
            End Try
            Session("userpower") = -1
            nwindConn.Open()
            Dim connSQL As String = "select name,productid from product"
            Dim DS As New DataSet
            Dim adapter As New SqlDataAdapter(connSQL, nwindConn)
            adapter.Fill(DS)
            DrList.DataSource = DS.Tables(0)
            DrList.DataTextField() = DS.Tables(0).Columns("name").ToString
            DrList.DataValueField() = DS.Tables(0).Columns("productid").ToString
            DrList.DataBind()
            DS.Dispose()
            adapter.Dispose()
            nwindConn.Close()
        End If
        Button1.Attributes.Add("onclick", "JavaScript :return confirm('您真的要提交吗?');")
    End Sub

    Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)

    End Sub

    Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        nwindConn.Open()
        Dim b As String
        Dim strscript As String
        Dim cmd As New SqlCommand
        If TextBox1.Text = "" Then
            strscript = "<script language=javascript>alert('产品编号不能为空')</script>"
            RegisterClientScriptBlock("系统消息", strscript)
        Else

            cmd.CommandText = "select itemid from item where itemid='" & TextBox1.Text & "'"
            cmd.Connection = nwindConn
            Dim a As String = cmd.ExecuteScalar()
            If a <> "" Then
                strscript = "<script language=javascript>alert('产品编号:" & TextBox1.Text & "已经存在,请重新输入')</script>"
                RegisterClientScriptBlock("系统消息", strscript)
                TextBox1.Text = ""
            Else
                If TextBox2.Text = "" Then
                    strscript = "<script language=javascript>alert('产品名不能为空')</script>"
                    RegisterClientScriptBlock("系统消息", strscript)

                Else
                    cmd.CommandText = "select itemid from item where itemname='" & TextBox2.Text & "'"
                    cmd.Connection = nwindConn
                    Dim s As String = cmd.ExecuteScalar()
                    If s <> "" Then
                        strscript = "<script language=javascript>alert('产品名:" & TextBox2.Text & "请进行旧商品的添加')</script>"
                        RegisterClientScriptBlock("系统消息", strscript)
                        TextBox2.Text = ""
                    Else
                        If Textbox3.Text = "" Then
                            strscript = "<script language=javascript>alert('价格不能为空')</script>"
                            RegisterClientScriptBlock("系统消息", strscript)
                        Else
                            If Textbox4.Text = "" Then
                                strscript = "<script language=javascript>alert('数量不能为空')</script>"
                                RegisterClientScriptBlock("系统消息", strscript)
                            Else
                                cmd.CommandText = "insert into item values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & DrList.SelectedValue & "'," & Textbox3.Text & "," & Textbox4.Text & ",'','" & Textbox5.Text & "')"
                                cmd.Connection = nwindConn
                                cmd.ExecuteNonQuery()
                                strscript = "<script language=javascript>alert('提交成功')</script>"
                                RegisterClientScriptBlock("系统消息", strscript)
                                TextBox1.Text = ""
                                TextBox2.Text = ""
                                Textbox3.Text = ""
                                Textbox4.Text = ""
                                Textbox5.Text = ""
                            End If
                        End If

                    End If
                End If
            End If
        End If
        nwindConn.Close()

    End Sub

   
    Private Sub DrList_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DrList.SelectedIndexChanged

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Session("userpower") = 2
        Response.Redirect("manager.aspx")
    End Sub
End Class