employeein.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_EmployeeIn : System.Web.UI.Page
{
    int formID;
    int em_Duty = 0;
    int em_Department = 0;

    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"]);
        PersonInput.PersonID = formID;
        
        if (!IsPostBack)
        {
            String sql = "SELECT * FROM J_Employee WHERE em_ID=" + formID;
            DataTable dt =DBExec.ExecDataTable(sql);
            if (dt.Rows.Count != 0)
            {
                DataRow sdr = dt.Rows[0];
                tpBuMen.SelectedValue = sdr["em_Department"].ToString();
                tpZhiWu.SelectedValue = Convert.ToInt32(sdr["em_Duty"]);
                lblMessageResult.Text = formID + "号员工的记录：";
            }
            else
                lblMessageResult.Text = "请在下面输入新员工记录";
            DualList.DepartmentID = formID;
        }
        else
        {
            em_Duty = Convert.ToInt32(tpZhiWu.SelectedValue);
            em_Department = Convert.ToInt32(tpBuMen.SelectedValue);
            ErrMsg.Text = "";
        }

    }

    private void ModifyDepartmentEmployee()
    {
        String selectedCourse = DualList.AllValues.Trim();
        
        String unSelectedCourse = DualList.AllUnSelect.Trim();
        if (unSelectedCourse == "") unSelectedCourse = "0";
        //清除以前的选课,前提是该课程从未上过 
        String sql = "DELETE FROM J_EmDeCourse WHERE ed_Employee=" + formID + " AND ed_DeCourse IN ("+unSelectedCourse+")";
        try
        {
            DBExec.ExecNonQuery(sql);
        }
        catch (SqlException e)
        {
            ErrMsg.Text += e.Message;
        }

        if (selectedCourse != "")
        {
            String[] selDepartment = selectedCourse.Split(',');
            for (int i = 0; i < selDepartment.Length; i++)
            {
                //查找在EmDeCourse表中是否已经有了与课程[i]有关当前任课．
                sql = "SELECT dbo.f_DeCourseAvaiable(" + selDepartment[i] + ")";
                int n = DBExec.ExecGetInt(sql);
                if (n == 1)
                {
                    sql = "INSERT INTO J_EmDeCourse (ed_Employee, ed_DeCourse) VALUES (" + formID + ", " + selDepartment[i] + ")";
                    DBExec.ExecNonQuery(sql);
                }
                else
                {
                    ErrMsg.Text += "某些课程无法添加, 因为该课程已经有其他员工任教．<BR />";
                }
            }
        }
    }

    protected void btnOK_Click(object sender, EventArgs e)
    {
       string sql;
       if (!IsValid) return;
       PersonInput.AddorModify();
       List<SqlParameter> sp = new List<SqlParameter>();
       formID = PersonInput.PersonID;
       sp.Add(new SqlParameter("@em_ID",formID));
       sp.Add(new SqlParameter("@em_Duty", em_Duty));
       sp.Add(new SqlParameter("@em_Department", em_Department));
       if (PersonInput.Operation == uctl_PersonInput.Modified)
        {
            sql = "UPDATE J_Employee SET em_Duty=@em_Duty,em_Department=@em_Department WHERE em_ID=@em_ID";
            DBExec.ExecParamQuery(sql, sp);
            lblMessageResult.Text = "成功修改了员工信息";
        }
        else
        {
            sql="INSERT INTO J_Employee (em_ID,em_Duty,em_Department) " + 
           "VALUES (@em_ID, @em_Duty, @em_Department)";
            DBExec.ExecParamQuery(sql, sp);
            lblMessageResult.Text = "成功新增了员工信息";
            Response.Redirect(Request.Path + "?ID="+ formID);
       　}
        ModifyDepartmentEmployee();
        lblMessageResult.Text += formID + "号：" + PersonInput.PersonName;
        DualList.DepartmentID = formID;
    }
}