private void Courses()
{
DataTable Tab_Courses = db.View_Courses();
if (Tab_Courses.Rows.Count != 0)
{
DropDownList_Course.DataTextField = "cname";
DropDownList_Course.DataSource = Tab_Courses;
DropDownList_Course.DataBind();
DropDownList_Course.Items.Insert(0, "-Select-");
}
}
//生成该年级该学科组所包含的所有科目，为下拉框绑定数据
protected void ProvideDataForSelectSubject()
{
string grade = DropDownList_Grade.SelectedValue;
//debug1.Text = "年级：" + grade;
string subjectGroupName = Label_SubjectGroup.Text;
string sql0 = "select subjectGroupNo from gcgSubjectGroup where subjectGroupName ='" + subjectGroupName + "'";
DBManipulation dbm = new DBManipulation();
Object o = dbm.ExecuteScalar(sql0, null);
if (o == null)
{
//说明没有这个学科组
System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('没有该学科组存在！')", true);
return;//不再查询数据
}
string subjectGroupNo = o.ToString();
dbm.Close();
string sql1 = "select CourseNo,subjectname from gcgSubject,gcgCourse where gcgCourse.SubjectNo = gcgSubject.subjectno and Grade = @Grade and subjectGroupNo = @subjectGroupNo";
ParameterStruct p1 = new ParameterStruct("@Grade", grade);
ParameterStruct p2 = new ParameterStruct("@subjectGroupNo", subjectGroupNo);
ArrayList pList1 = new ArrayList();
pList1.Add(p1);
pList1.Add(p2);
/*
* SqlDataReader dr = dbm.ExecuteQueryOnLine(sql1,pList1);
* while (dr.Read()) {
* ListItem item = new ListItem(dr.GetString(1),dr.GetString(0));
* item.Attributes.Add("style", "color:red");
* DropDownList_Course.Items.Add(item);
* }*/
DataSet ds_Course = dbm.ExecuteQueryOffLine(sql1, pList1);
DropDownList_Course.AutoPostBack = true;
DropDownList_Course.DataSource = ds_Course.Tables["defaultTable"];
DropDownList_Course.DataTextField = ds_Course.Tables["defaultTable"].Columns[1].ColumnName;
DropDownList_Course.DataValueField = ds_Course.Tables["defaultTable"].Columns[0].ColumnName;
ListItem item = new ListItem();
//DropDownList_Subject.SelectedIndex = 0;
DropDownList_Course.DataBind();
//要先清洗掉上一个年级残存的老师集合
foreach (DropDownList d in DropDownList_select)
{
d.Items.Clear();
}
setDataForEachTeacherDropDownList();
}
//function to load courses
private void LoadCourses()
{
BusinessLogic obj = new BusinessLogic();
DataTable tab = new DataTable();
tab = obj.View_Courses();
if (tab.Rows.Count > 0)
{
DropDownList_Course.Items.Clear();
DropDownList_Course.DataSource = tab;
DropDownList_Course.DataTextField = "Cname";
DropDownList_Course.DataValueField = "Cname";
DropDownList_Course.DataBind();
DropDownList_Course.Items.Insert(0, "- Select -");
}
}
void BindDropDownList()
{
DropDownList_Course.Items.Clear();
List <Qualification> objQuals = new List <Qualification>();
objQuals = (from xyzl in QualManagement.GetInstance.GetQualsList()
where xyzl.QualType == "C"
select xyzl).ToList();
DropDownList_Course.DataSource = objQuals;
DropDownList_Course.DataTextField = "QualCode";
DropDownList_Course.DataValueField = "QualID";
DropDownList_Course.DataBind();
DropDownList_Course.Items.Insert(0, new ListItem(MicroConstants.DROPDOWNLIST_DEFAULT_ITEMTEXT));
DropDownList_Stream.DataSource = StreamManagement.GetInstance.GetStreamList();
DropDownList_Stream.DataTextField = "StreamName"; //StreamManagement.GetInstance.DisplayMember;
DropDownList_Stream.DataValueField = "StreamID"; //StreamManagement.GetInstance.ValueMember;
DropDownList_Stream.DataBind();
DropDownList_Stream.Items.Insert(0, new ListItem(MicroConstants.DROPDOWNLIST_DEFAULT_ITEMTEXT));
}
