courselist.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_CourseList : System.Web.UI.Page
{
    String co_Description = "";
    String co_Name = "";
    int co_Time = 0;
    int co_Credit = 0;
    int co_Type = 1;
    static int formID = 0; //在下面表单中记录的ＩＤ号
    static int parentID = 0;
    LoginInfo My;

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

        Courses.CodeSelected += new uctl_CodeTree.CodeSelectedEventHander(ShowDataViewAndForm);
        //  Response.Write("DE=" + Courses.Value);
        if (!IsPostBack)
        {
            ShowDataViewAndForm(Courses.Value);
        }
    }

    private void showDataView(int pID)
    {
        parentID = pID;
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add("ID", parentID.ToString());
        //        Response.Write("parentID=" + parentID);
        GridView1.DataBind();
        Path.Text = Courses.Path;
    }

    protected void ShowDataViewAndForm(int pID)
    {
        showDataView(pID);
        showForm();
    }


    private void showForm()
    {
        if (formID==0 && GridView1.Rows.Count > 0)
        {
            formID = Convert.ToInt32(GridView1.Rows[0].Cells[0].Text);
        }

        String sql = "SELECT * FROM J_Course WHERE co_ID=" + formID;
        DataTable dt = DBExec.ExecDataTable(sql);
        if (dt.Rows.Count != 0)
        {
            DataRow sdr = dt.Rows[0];
            txtName.Text = sdr["co_Name"].ToString().Trim();
            txtTime.Text = sdr["co_Time"].ToString().Trim();
            txtCredit.Text = sdr["co_Credit"].ToString().Trim();
            ddlType.Text = sdr["co_Type"].ToString();
            ddlParent.Text = sdr["co_Parent"].ToString();
            txtDescription.Text = sdr["co_Description"].ToString().Trim();

            lblMessageResult.Text = "修改" + formID + "号:" + txtName.Text + "的课程记录:";
        }
        else
        {
            clearForm();
        }
    }

    private bool getFormData()
    {
        co_Name = txtName.Text.Trim();
        co_Description = txtDescription.Text.Trim();
        try
        {
            if (txtCredit.Text.Trim() != "")
            {
                co_Credit = Convert.ToInt32(txtCredit.Text);
            }
            if (txtTime.Text.Trim() != "")
            {
                co_Time = Convert.ToInt32(txtTime.Text);
            }
            if (ddlType.Text.Trim() != "")
            {
                co_Type = Convert.ToInt32(ddlType.Text);
            }
            if (ddlParent.Text.Trim() != "")
            {
                parentID = Convert.ToInt32(ddlParent.Text);
            }
        }
        catch
        {
            ErrMsg.Text +="输入数据的格式不对,可能应该输入数字的地方没有输入数字!<br />";
            return false;
        }
        if (parentID == formID)
        {
            ErrMsg.Text += "一个类别不能同时是自己的父类！";
            return false;
        }
        return true;
    }

    private void clearForm()
    {
        txtName.Text = "";
        txtTime.Text = "";
        txtCredit.Text = "";
        ddlType.Text = "1";
        ddlParent.Text = "1";
        txtDescription.Text = "";
        formID = 0;
        lblMessageResult.Text = "请在下面输入新课程记录:";
    }

    protected void btnOK_Click(object sender, EventArgs e)
    {
        string sql;
        List<SqlParameter> sp = new List<SqlParameter>();
        if (!getFormData()) return;
        sp.Add(new SqlParameter("@co_Credit", co_Credit));
        sp.Add(new SqlParameter("@co_Time", co_Time));
        sp.Add(new SqlParameter("@co_Description", co_Description));
        sp.Add(new SqlParameter("@co_Type", co_Type));
        sp.Add(new SqlParameter("@co_Name", co_Name));
        sp.Add(new SqlParameter("@co_Parent", parentID));
        if (formID > 0)
        {

            sql = "UPDATE J_Course SET co_Name=@co_Name, co_Parent=@co_Parent, co_Description=@co_Description, co_Credit=@co_Credit, co_Time=@co_Time, co_Type=@co_Type WHERE co_ID=" + formID + " AND "+parentID+"<>"+formID;

            DBExec.ExecParamQuery(sql, sp);
            lblMessageResult.Text = "成功修改了课程信息" + formID + "号：" + co_Name;
        }
        else
        {
            sql = "INSERT INTO J_Course (co_Name,co_Parent,co_Credit,co_Description,co_Time,co_Type) Values(@co_Name,@co_Parent,@co_Credit,@co_Description,@co_Time,@co_Type)";
            DBExec.ExecParamQuery(sql, sp);
            lblMessageResult.Text = "成功新增了一个课程" + formID + "号：" + co_Name;
            clearForm();
        }
        showDataView(parentID);
        ddlParent.DataBind();
        Courses.ReDraw();
    }

    protected void btnAddNew_Click(object sender, EventArgs e)
    {
        clearForm();
    }

    protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        lblCounter.Text = "(" + e.AffectedRows + "个)";
    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlDataSource1.DeleteParameters.Clear();
        SqlDataSource1.DeleteParameters.Add("DeleteID", formID.ToString());
    }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridViewRow row = GridView1.SelectedRow;
        formID = Convert.ToInt32(row.Cells[0].Text);
        showForm();
    }

    protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {
        clearForm();
        Courses.ReDraw();
    }
}