binddownlist.cs

C#2.0宝典源码,C#经典书籍,很多例子

using System;
using System.Web;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using StudentsMIS.DataAccess;

namespace StudentsMIS.CommonClassLibrary
{
	/// <summary>
	/// BindDownList 实现所有DropDownList的动态数据邦定。
	/// </summary>
	public class BindDownList
	{
		public static void Bind_CollegeList(DropDownList ddList)
		{
			ddList.Items.Clear();
      ddList.Items.Add(new ListItem("选择学院","0"));
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select * From colleges");
      OleDbDataReader objReader = objCommand.ExecuteReader();
      while(objReader.Read())
      {
        ddList.Items.Add(new ListItem(objReader["college_name"].ToString().Trim(),objReader["college_ID"].ToString().Trim()));
      }
      ddList.DataBind();
      objReader.Close();
		}

    public static void Bind_SpecialityList(DropDownList ddList,string collegeID)
    {
      ddList.Items.Clear();
      ddList.Items.Add(new ListItem("选择专业","0"));
      OleDbCommand objCommand;
      if(collegeID == "0")
      {
        objCommand = CommandBuilder.BuildOleDbCommand("Select * From speciality");
      }
      else
      {
        objCommand = CommandBuilder.BuildOleDbCommand("Select * From speciality Where speciality_college=@CollegeID");
        objCommand.Parameters.Add("@CollegeID",collegeID);
      }
      OleDbDataReader objReader = objCommand.ExecuteReader();
      while(objReader.Read())
      {
        ddList.Items.Add(new ListItem(objReader["speciality_name"].ToString().Trim(),objReader["speciality_ID"].ToString().Trim()));
      }
      ddList.DataBind();
      objReader.Close();
    }

    public static void Bind_ClassList(DropDownList ddList,string specialityID)
    {
      ddList.Items.Clear();
      ddList.Items.Add(new ListItem("选择班级","0"));
      OleDbCommand objCommand;
      if(specialityID == "0")
      {
        objCommand = CommandBuilder.BuildOleDbCommand("Select * From classes");
      }
      else
      {
        objCommand = CommandBuilder.BuildOleDbCommand("Select * From classes Where class_speciality=@specialityID");
        objCommand.Parameters.Add("@specialityID",specialityID);
      }
      OleDbDataReader objReader = objCommand.ExecuteReader();
      while(objReader.Read())
      {
        ddList.Items.Add(new ListItem(objReader["class_ID"].ToString().Trim()+" - "+objReader["class_name"].ToString().Trim(),objReader["class_ID"].ToString().Trim()));
      }
      ddList.DataBind();
      objReader.Close();
    }

    public static void Bind_EnterYearList(DropDownList ddList)
    {
      ddList.Items.Clear();
      int i = System.DateTime.Now.Year,start=i-4,end=i+2;
      for(i=start;i<=end;i++)
      {
        ddList.Items.Add(new ListItem(i.ToString()+"年",i.ToString()));        
      }      
      ddList.SelectedValue = System.DateTime.Now.Year.ToString();
      ddList.DataBind();      
    }

    public static void Bind_BirthdayDayList(DropDownList ddList,string year,string month)
    {
      ddList.Items.Clear();
      int days = System.DateTime.DaysInMonth(int.Parse(year),int.Parse(month));
      for(int i=1;i<=days;i++)
      {
        ddList.Items.Add(i.ToString());
      }
      ddList.DataBind();
    }

    public static void Bind_BirthdayMonthList(DropDownList ddList)
    {
      ddList.Items.Clear();
      for(int i=1;i<=12;i++)
      {
        ddList.Items.Add(i.ToString());
      }
      ddList.DataBind();
    }

    public static void Bind_BirthdayYearList(DropDownList ddList)
    {
      ddList.Items.Clear();
      int i = System.DateTime.Now.Year,start=i-60,end=i;
      for(i=end;i>=start;i--)
      {
        ddList.Items.Add(i.ToString());        
      }      
      ddList.DataBind();
    }

    public static void Bind_ChangeTypesList(DropDownList ddList)
    {
      ddList.Items.Clear();
      OleDbDataReader objReader = CommandBuilder.BuildOleDbDataReader("Select * From changeTypes"); 
      while(objReader.Read())
      {
        ddList.Items.Add(new ListItem(objReader["changeType_name"].ToString().Trim(),objReader["changeType_ID"].ToString().Trim()));
      }
      ddList.DataBind();
    }

    public static void Bind_PunishmentTypesList(DropDownList ddList)
    {
      ddList.Items.Clear();
      OleDbDataReader objReader = CommandBuilder.BuildOleDbDataReader("Select * From punishmentTypes");
      while(objReader.Read())
      {
        ddList.Items.Add(new ListItem(objReader["punishmentType_name"].ToString().Trim(),objReader["punishmentType_ID"].ToString().Trim()));
      }
    }
	}
}