department.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_Department : System.Web.UI.Page
{
    LoginInfo My;
    protected void Page_Load(Object sender, EventArgs e)
    {
        My = new LoginInfo(Session["LoginID"]);
        if (!My.IsAdmin()) Response.Redirect("~/Signin.aspx",true);

        Departments.CodeSelected += new uctl_CodeTree.CodeSelectedEventHander(ShowDataView);
        if (!IsPostBack)
        {
          int parentID = CommOp.ToInt(Request.QueryString["ClassID"]);
            if (parentID == 0) parentID = Departments.Value;
            ShowDataView(parentID);
        }
    }

    protected void ShowDataView(int parentID)
    {
        Departments.Value = parentID;
        Session["ClassID"] = parentID;
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add("ID",parentID.ToString());
        GridView1.DataBind();
        Path.Text = Departments.Path;
        hypAddNew.NavigateUrl = "~/Personal/DepartmentIn.aspx?ClassID=" + parentID;
    }

    protected void btnMove_Click(object sender, EventArgs e)
    {
        string selectedCodes = CommOp.ToStr(Request["CheckBox1"]);
        int pCode = Convert.ToInt32(ddlDepartments.SelectedValue);
        if (selectedCodes != "")
        {
            String sql = "UPDATE J_Department SET de_Parent =" + pCode + " WHERE de_ID in (" + selectedCodes + ") AND de_ID <> "+pCode;
            DBExec.ExecNonQuery(sql);
            ShowDataView(Departments.Value);
        }
    }
   protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
   {
       lblCounter.Text = "(" + e.AffectedRows + ")";
   }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        int formID = Convert.ToInt32(GridView1.SelectedRow.Cells[0].Text);
        Response.Redirect("DepartmentIn.aspx?ID=" + formID);
    }

    protected void onRowDeleted(object sender, GridViewDeletedEventArgs e)
    {
        if (e.Exception != null)
            CommOp.ShowError("Delete_Department_Error");
        Departments.ReDraw();
    }
}