sc.ascx.cs

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

using System;
using System.Data;
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 uctl_SC : System.Web.UI.UserControl
{
    private String sqlProcedureName;  //执行哪个存储过程得到数据列表
    private int departmentID; //要显示哪个部门课程的部门号
   // private int rootClassID; //课程关键字在J_AllCode中的根目录ID, 今后最好用名称替换掉便于使用
    protected void Page_Load(object sender, EventArgs e)
    {
        btnRemove.Attributes["onclick"] = "exchange(0);return false;";
        btnAdd.Attributes["onclick"] = "exchange(1);return false;";
        lblForLastJS.Text = "<script>initControl('" + lstSelectedCourse.ClientID + "','" + lstAvaiableCourse.ClientID + "','" + hiddenValues.ClientID + "','"+hiddenUnSelect.ClientID +"');getValue(0);</script>";
    }

    public void SourceGetData()
    {
        DataSet ds = DBExec.ExecDataSet("EXEC " + sqlProcedureName + " " + departmentID + ",0");
        lstAvaiableCourse.DataSource = ds;
        lstAvaiableCourse.DataTextField = "theName";
        lstAvaiableCourse.DataValueField = "theID";
        lstAvaiableCourse.DataBind();
    }

    public void TargetGetData()
    {
        DataSet ds = DBExec.ExecDataSet("EXEC " + sqlProcedureName + " " + departmentID + ",1");
        
        lstSelectedCourse.DataSource = ds;
        lstSelectedCourse.DataTextField = "theName";
        lstSelectedCourse.DataValueField = "theID";
        lstSelectedCourse.DataBind();
    }

    public String SqlProcedureName { set { sqlProcedureName = value; } }
   
    public int DepartmentID
    {
        set 
        { 
            departmentID = value; 
            SourceGetData(); 
            TargetGetData(); 
        } 
    }

    public String AllValues { get { return hiddenValues.Value; } }

    public String AllUnSelect { get { return hiddenUnSelect.Value; } }

    public String SourceName { set { lblSourceName.Text = value; } }

    public String TargetName { set { lblTargetName.Text = value; } }


}