addgroup.aspx.vb

基于.net科研管理信息系统 毕业设计参考代码

Imports System.Data
Imports System.Data.SqlClient
Partial Class addgroup1
    Inherits System.Web.UI.Page

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

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

    End Sub


    '注意: 以下占位符声明是 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

    Private connectionstring As String
    Dim mycmd As SqlCommand

    Dim sql, uid, depid As String
    Dim conn As SqlConnection
    Dim ds As DataSet = New DataSet
    Dim da As SqlDataAdapter







    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        conn = New SqlConnection(connectionstring)
        conn.ConnectionString = "server=HP-PC;Database=SRM;uid=sa;pwd=sa;"

        sql = "select * from sci_group where group_id='" + group_id.Value + "'"
        Dim da As SqlDataAdapter = New SqlDataAdapter(sql, conn)
        da.Fill(ds)
        conn.Open()
        If Not IsPostBack Then

            If Session("user_id") = "" Then
                Response.Redirect("login.aspx")
            Else

                uid = Session("user_id")
            End If

        End If


    End Sub


    Private Sub Submit1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.ServerClick

        If group_id.Value = "" Then
            Response.Write("<script>alert('请输入项目组编号号！ ');</script>")
        ElseIf (group_name.Value = "") Then
            Response.Write("<script>alert('请输入项目组名称！ ');</script>")
        ElseIf (ds.Tables(0).Rows.Count <> 0) Then
            Response.Write("<script>alert('该项目组已存在！');</script>")
        Else

            sql = "select sci_group.dep_id from sci_user,sci_group where (sci_user.group_id=sci_group.group_id and sci_user.user_id='" + Session("user_id") + "')"
            da = New SqlDataAdapter(sql, conn)
            Dim dateset1 As DataSet = New DataSet
            da.Fill(dateset1)

            sql = "insert into sci_group(group_id,group_name,dep_id)values('" + group_id.Value + "',  '" + group_name.Value + "',  '" + dateset1.Tables(0).Rows(0)(0).ToString.Trim() + "') "

            mycmd = New SqlCommand(sql, conn)
            mycmd.ExecuteNonQuery()
            mycmd.Dispose()
            conn.Close()

            Response.Write("<script>alert('添加成功！！！');</script>")
            group_id.Value = ""
            group_name.Value = ""

        End If

    End Sub


    Private Sub reset_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles reset.ServerClick

    End Sub

    Private Sub Button1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ServerClick
        Response.Redirect("groupinfor.aspx")
    End Sub



    Private Sub Submit2_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit2.ServerClick


        If (ds.Tables(0).Rows.Count <> 0) Then
            Response.Write("<script>alert('该项目组已存在！');</script>")
        Else
            Response.Write("<script>alert('不存在该项目组,请继续添加！');</script>")
        End If
    End Sub

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

    End Sub
End Class