departmentin.aspx.cs

asp.net 2.0的教务管理软件源码

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Personal_DepartmentIn : System.Web.UI.Page
{
    int de_Header = 0;
    int de_Parent = 0;
    String de_Phone = "";
    String de_Description = "";
    String de_Name = "";
    static int formID = 0; //在下面表单中记录的ＩＤ号
    static int parentID = 0;
    bool de_IsTemp = false;
    LoginInfo My;

    protected void Page_Load(object sender, EventArgs e)
    {
        My = new LoginInfo(Session["LoginID"]);
        if (!My.IsAdmin()) Response.Redirect("~/Signin.aspx");

        formID = Convert.ToInt32(Request.QueryString["ID"]);
        parentID = Convert.ToInt32(Request.QueryString["ClassID"]);
        lblErrMsg.Text = "";
        if (!IsPostBack)
        {
            String sql = "SELECT * FROM v_Department WHERE ID=" + formID;
            DataTable dt = DBExec.ExecDataTable(sql);
            if (dt.Rows.Count != 0)
            {
                DataRow sdr = dt.Rows[0];
                formID = Convert.ToInt32(sdr[0]);

                txtName.Text = sdr["部门名称"].ToString().Trim();
                txtPhone.Text = sdr["电话"].ToString().Trim();
                txtHeader.Text = sdr["负责人"].ToString().Trim();
                txtDescription.Text = sdr["简介"].ToString().Trim();
                chkIsTemp.Checked = Convert.ToBoolean(sdr["教学"]);
                lblMessageResult.Text = "修改" + formID + "号:" + txtName.Text + "的部门记录:";
                DualList.DepartmentID = formID;
                ddlParent.Text = sdr["de_Parent"].ToString();
            }
            else
            {
                clearFormData();
            }
        }
        else
        {
            getFormData();
        }
    }

    //得到用户输入的表单数据
    private void getFormData()
    {
        de_Name = txtName.Text.Trim();
        de_Description = txtDescription.Text.Trim();
        string HeaderName = txtHeader.Text.Trim();
        string sql = "SELECT top 1 em_ID FROM v_Employee WHERE pe_Name='" + HeaderName + "'";
        de_Header = DBExec.ExecGetInt(sql);
        if (de_Header == 0)
        {
            txtHeader.Text = "";
        }
        de_Phone = txtPhone.Text;
        de_IsTemp = chkIsTemp.Checked;
        de_Parent = Convert.ToInt32(ddlParent.Text);

    }

   //清除表单
    private void clearFormData()
    {
        txtName.Text = "";
        txtPhone.Text = "";
        txtHeader.Text = "";
        txtDescription.Text = "";
        formID = 0;
        chkIsTemp.Checked = true;
        lblMessageResult.Text = "请输入新部门记录:";
        lblErrMsg.Text = "";
        DualList.DepartmentID = formID;
        ddlParent.Text = parentID.ToString();
    }

    //修改该班级所对应的课程号
    private void ModifyDepartmentCourse()
    {
        String selectedCourse = DualList.AllValues.Trim();
        if (selectedCourse == "") selectedCourse = "0";
        String sql = "DELETE FROM J_DeCourse WHERE dc_Department=" + formID 
        +" AND dc_ID NOT IN ((SELECT ed_DeCourse FROM J_EmDeCourse) "
        +"UNION (SELECT sc_DeCourse FROM J_StCourse) "
        +"UNION (SELECT dc_ID FROM J_DeCourse WHERE dc_ID IN ("+selectedCourse+")))";
        DBExec.ExecNonQuery(sql);
        if (selectedCourse != "0")
        {
            String[] selCourse = selectedCourse.Split(',');
            for (int i = 0; i < selCourse.Length; i++)
            {
                sql = "INSERT INTO J_DeCourse (dc_Department, dc_Course) VALUES (" + formID + ", " + selCourse[i] + ")";
                try
                {
                    DBExec.ExecNonQuery(sql);
                }
                catch (SqlException)
                {
                   // lblErrMsg2.Text = "某些任务无法添加，可能是有重复的任务.<BR />";
                }
            }
        }
        DualList.DepartmentID = formID;
    }

    //新增或修改班级信息
    protected void btnOK_Click(object sender, EventArgs e)
    {
        string sql;
        List<SqlParameter> sp = new List<SqlParameter>();

        //        getFormData();
        if (de_Header == 0)
            sp.Add(new SqlParameter("@de_Header", DBNull.Value));
        else
            sp.Add(new SqlParameter("@de_Header", de_Header));
        sp.Add(new SqlParameter("@de_Phone", de_Phone));
        sp.Add(new SqlParameter("@de_Description", de_Description));
        sp.Add(new SqlParameter("@de_IsTemp", de_IsTemp));
        sp.Add(new SqlParameter("@de_Name", de_Name));
        sp.Add(new SqlParameter("@de_Parent", de_Parent));
        if (formID > 0)
        {
            if (formID == de_Parent)
            {
                lblErrMsg.Text += "该部门的上级部门不能是本身.";
                return;
            }
            sql = "UPDATE J_Department SET de_Name=@de_Name, de_Description=@de_Description, de_Header=@de_header, de_Phone=@de_Phone,de_IsTemp=@de_IsTemp,de_Parent=@de_Parent WHERE de_ID=" + formID + " AND "+de_Parent+" <> "+formID;
            DBExec.ExecParamQuery(sql, sp);
            lblMessageResult.Text = "成功修改了部门信息" + formID + "号：" + de_Name;
        }
        else
        {
            sql = "INSERT INTO J_Department (de_Header,de_Description,de_Phone,de_IsTemp,de_Name,de_Parent) Values(@de_Header,@de_Description,@de_Phone,@de_IsTemp,@de_Name,@de_Parent)";
            DBExec.ExecParamQuery(sql, sp);
            lblMessageResult.Text = "成功新增了一个部门：" + de_Name;
        }
        ModifyDepartmentCourse();
    }

    protected void btnAddNew_Click(object sender, EventArgs e)
    {
        clearFormData();
        Response.Redirect(Request.Url.ToString());
    }
}