uicontrols.cs

实验课预约系统。采用.net+access数据库实现。 管理员对学生教师有管理功能

using System;
using System.Data;
using System.Collections.Generic;
using System.Configuration;
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;
using devBiz.Web.UI;


/// <summary>
/// Summary description for UIControls
/// </summary>
public class UIControls
{
    public static void BindTermsDDL(DropDownList ddl)
    {
        DataTable dt = SingleInitials.DbAccess.GetTermList().Tables[0];
        ddl.DataValueField = "TermName";
        ddl.DataTextField = "TermName";
        ddl.DataSource = dt;
        ddl.DataBind();
        ddl.Items.Insert(0,"请选择...");
    }

    public static void BindCourseDDL(DropDownList ddl,string termStr)
    {
        ddl.Items.Clear();
        List<string> courseList = SingleInitials.DbAccess.GetCourseList(termStr);
        ddl.DataSource = courseList;
        ddl.DataBind();
        ddl.Items.Insert(0, "请选择...");
    }

    public static void BindCourseEDD(devBiz.Web.UI.WebControls.EditableDropDown aEDD, string termStr)
    {
        List<string> courseList = SingleInitials.DbAccess.GetCourseList(termStr);
        aEDD.Items.Clear();
        foreach(string iStr in courseList)
        {
            aEDD.Items.Add(iStr);
        }
        
    }

    public static void BindExperimentsDDL(DropDownList ddl,string termStr,string courseStr)
    {
        DataTable dt = SingleInitials.DbAccess.GetCourseDetailTable(termStr, courseStr);
        ddl.DataValueField = "ID";
        ddl.DataTextField = "CourseDetailName";
        ddl.DataSource = dt;
        ddl.DataBind();
        ddl.Items.Insert(0, "请选择...");
        //if (ddl.Items.Count != 0)
        //    ddl.SelectedIndex = 0;
    }

    public static void BindTeacherDDL(DropDownList ddl)
    {
        DataTable dt = SingleInitials.DbAccess.GetTeachersList().Tables[0];
        ddl.DataValueField = "ID";
        ddl.DataTextField = "Name";
        ddl.DataSource = dt;
        ddl.DataBind();
        ddl.Items.Insert(0, "请选择...");
    }

    public static void BindClassesDDL(DropDownList ddl)
    {
        ddl.Items.Clear();
        List<string> classList = SingleInitials.DbAccess.GetClassList();
        foreach (string iString in classList)
        {
            ListItem iListItem = new ListItem(iString,iString);
            ddl.Items.Add(iListItem);
        }
        ddl.Items.Insert(0, "请选择...");
    }

    public static void BindClassesEDD(devBiz.Web.UI.WebControls.EditableDropDown aEDD)
    {
        aEDD.Items.Clear();
        List<string> classList = SingleInitials.DbAccess.GetClassList();
        foreach (string iString in classList)
        {
            ListItem iListItem = new ListItem(iString, iString);
            aEDD.Items.Add(iListItem);
        }
    }

    public static void BindStudentsDDL(DropDownList ddl,string strClass)
    {
        //GetStudentsList
        DataTable aDt = SingleInitials.DbAccess.GetStudentsList(strClass).Tables[0];
        ddl.DataValueField = "ID";
        ddl.DataTextField = "Name";
        ddl.DataSource = aDt;
        ddl.DataBind();
        ddl.Items.Insert(0, "请选择...");
    }

    public static bool IsPositiveInt(string str)
    {
        string  regexStr=@"(\+)?0*[1-9]+[0-9]*";
        return System.Text.RegularExpressions.Regex.IsMatch(str, regexStr);
    }

    public static string CaculateWeekDay(int y, int m, int d)
    {
        if (m == 1) m = 13;
        if (m == 2) m = 14;
        int week = (d + 2 * m + 3 * (m + 1) / 5 + y + y / 4 - y / 100 + y / 400) % 7;
        string weekstr = "";
        switch (week)
        {
            case 1: weekstr = "星期一"; break;
            case 2: weekstr = "星期二"; break;
            case 3: weekstr = "星期三"; break;
            case 4: weekstr = "星期四"; break;
            case 5: weekstr = "星期五"; break;
            case 6: weekstr = "星期六"; break;
            case 7: weekstr = "星期日"; break;
        }

        return weekstr;
    }

    public static string CaculateWeekDay(DateTime aDateTime)
    {
        return CaculateWeekDay(aDateTime.Year,aDateTime.Month,aDateTime.Day);
    }

    /// <summary>
    /// 　把aPage里面的ToExcelGrid表格导入到excel文件filename.xls中
    /// </summary>
    /// <param name="filename"></param>
    /// <param name="ToExcelGrid"></param>
    /// <param name="aPage"></param>
    /// <remarks>
    /// 注意:
    /// (1) 在page标签中添加AutoEventWireup="true"属性
    /// (2) 覆盖page函数:
    ///      public override void VerifyRenderingInServerForm(Control control)
    ///      {
    ///         base.VerifyRenderingInServerForm(control);
    ///      }
    /// </remarks>
    public static void ExportExcelFromDataGrid(string filename, System.Web.UI.WebControls.GridView ToExcelGrid, Page aPage)
    {
        aPage.Response.Clear();
        aPage.Response.Buffer = true;
        aPage.Response.Charset = "GB2312";
        aPage.Response.AppendHeader("Content-Disposition", "attachment;filename=" + aPage.Server.UrlEncode(filename));
        aPage.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文   
        aPage.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。     
        aPage.EnableViewState = false;
        System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        ToExcelGrid.RenderControl(oHtmlTextWriter);
        aPage.Response.Write(oStringWriter.ToString());
        aPage.Response.End();
    }
}