App_Code/common.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

/// <summary>
///common 的摘要说明
/// </summary>
public class common
{
	public common()
	{
		//
		//TODO: 在此处添加构造函数逻辑
		//
	}
    //绑定初识毕业年份
    public static void BindDrop(DropDownList ddl)
    {
        int lastYear = Convert.ToInt16(DateTime.Now.ToString().Substring(0, 4));
        ddl.Items.Clear();
        for (int i = 1939; i <= lastYear; i++)
        {
            ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
        }
       
    }

    //绑定初识班级
    //public static void BindBj(DropDownList ddl, string sql)
    //{
    //    string strsql = "select * from tb_banji where bj_bynf=@nf order by id";
    //    SqlParameter[] p = new SqlParameter[] {
    //            new SqlParameter ("@nf","1939"),
    //        };
    //    common.BindDdl(Ddlbybj, strsql, p);
    //}

    //绑定数据到dropdownlist中
    public static void BindDdl(DropDownList ddl, string sql)
    {
        DataTable dt = SqlHelper.ExecuteQuery(sql, null);
        ddl.Items.Clear();
        DataRow[] dr = dt.Select();
        foreach (DataRow d in dr)
        {
            string ksid = d["id"].ToString();
            string ksmcname = d["bj_bynf"].ToString();
            
            ddl.Items.Add(new ListItem(ksmcname, ksid));
        }
        ddl.DataBind();
    
    }

    public static void   BindZjClass(DropDownList ddl,string sql )
    {