asp.net 动态生成Table课表

最新推荐文章于 2022-06-22 01:40:58 发布

beMyselfeveryday

最新推荐文章于 2022-06-22 01:40:58 发布

阅读量1.4k

点赞数 1

分类专栏： ASP.net 文章标签： asp.net 动态生成Table课表

ASP.net 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

出处：http://hi.baidu.com/yore2003/item/8f5b1558fcd9f6abadc8573a

#region 生成课表
        /// <summary>
        /// 生成课表
        /// </summary>
        /// <param name="p_intAmCount">每天上午或下午的节数</param>
        /// <param name="p_intWeekDayCount">每周上课的天数</param>
        /// <param name="p_intStartRowNum">每天从第几节开始生成课表</param>
        /// <param name="p_table">需要装载课时的Table</param>
        /// <param name="p_strAmOrPm">课表前面要显示的文字一般为“上午”“下午”</param>
        private void SetAmCurShe(int p_intAmCount, int p_intWeekDayCount,int p_intStartRowNum,ref Table p_table,string p_strAmOrPm)
        {
            bool bol_SetRowSpan = false;
            int int_TotalRow=p_intAmCount + p_intStartRowNum;
            //行循环
            for (int intRow = p_intStartRowNum; intRow < int_TotalRow; intRow++)
            {
                TableRow tblr = new TableRow();
                tblr.ID = "tr_" + intRow;
                //列循环
                for (int intCell = 0; intCell < 2 + p_intWeekDayCount; intCell++)
                {
                    TableCell tblc = new TableCell();
                    tblc.BorderColor = System.Drawing.Color.Gray;
                    tblc.BorderStyle = BorderStyle.Solid;
                    tblc.BorderWidth = 1;
                    //判断是否是第一列
                    if (intCell == 0 && !bol_SetRowSpan)
                    {
                        tblc.RowSpan = p_intAmCount;
                        tblc.ID = "tc_" + intRow + "_" + intCell;
                        tblc.Text = p_strAmOrPm;
                        bol_SetRowSpan = true;
                        tblr.Cells.Add(tblc);
                        tblc.Width = 20;
                    }
                    //判断是否是第二列
                    else if (intCell == 1)
                    {
                        tblc.ID = "tc_" + intRow + "_" + intCell;
                        tblc.Text = intRow.ToString();
                        tblr.Cells.Add(tblc);
                        tblc.Width = 30;
                    }
                    //判断是否是其它列
                    else if(intCell !=0)
                    {
                        tblc.ID = "tc_" + intRow + "_" + intCell;
                        //========动态生成按钮控件===============
                        Button btnNew = new Button();
                        btnNew.BorderStyle = BorderStyle.Inset;
                        btnNew.BorderWidth = 0;
                        btnNew.BackColor = System.Drawing.Color.Transparent;
                        btnNew.Click += new EventHandler(btnNew_Click);
                        btnNew.ID = "btn_"+intRow +"_"+(intCell-1 );
                        btnNew.Width = 120;
                        btnNew.Height = 40;
                        //btnNew.OnClientClick = "btnNew_Click";
                        //btnNew.Attributes["type"]="button";
                        btnNew.Text = " ";
                        btnNew.Style.Value = "cursor:hand;";
                        //=========================================
                        tblc.Controls.Add(btnNew);
                        tblr.Cells.Add(tblc);
                    }

                }
                p_table.Rows.Add(tblr);
            }
        }
        #endregion

#region 动态生成课表表头
        /// <summary>
        /// 动态生成课表表头
        /// </summary>
        /// <param name="p_intWeekDayCount">每周上课的天数</param>
        /// <param name="p_table">需要装载课时的Table</param>
        private void SetCurSheTitle(int p_intWeekDayCount,ref Table p_table)
        {
            TableRow tblr = new TableRow();
            tblr.ID = "tr_0";
            //列循环
            for (int intCell = 0; intCell < 1 + p_intWeekDayCount; intCell++)
            {
                TableCell tblc = new TableCell();
                tblc.BorderColor = System.Drawing.Color.Gray;
                tblc.BorderStyle = BorderStyle.Solid;
                tblc.BorderWidth = 1;
                //是否是第一列
                if (intCell == 0)
                {
                    tblc.ColumnSpan = 2;
                    tblc.Text = "排";
                    tblc.ID = "tc_" + 0 + "_" + intCell;
                    tblc.BackColor = System.Drawing.Color.DarkGray;
                }
                else
                {
                    //设置其他列的标题
                    string str_WeekDay = DateTimeHelper.GetWeekDayByNumber(intCell);
                    tblc.Text = str_WeekDay;
                    tblc.ID = "tc_" + 0 + "_" + intCell;
                    tblc.ForeColor = System.Drawing.Color.WhiteSmoke;
                    tblc.BackColor = System.Drawing.Color.DarkBlue;
                }
                tblr.Cells.Add(tblc);
            }
            p_table.Rows.Add(tblr);
        }
        #endregion

        #region 设置课程表
        private void setCurSheInfo()
        {
            int int_WeekDayCount = 5;
            int int_AmCount = 4;
            int int_PmCount = 3;
            if (dropTerm.SelectedIndex != -1)
            {
                DataSet ds_CourseParameter = new DataSet();
                ds_CourseParameter = TeachMgmt.getCourseParameter(CurrentSchoolId.ToString(), dropTerm.SelectedValue);
                if (ds_CourseParameter.Tables.Count != 0 && ds_CourseParameter.Tables[0].Rows.Count != 0)
                {
                    int_WeekDayCount = int.Parse(ds_CourseParameter.Tables[0].Rows[0]["WEEK_NUM_DAY"].ToString());
                     int_AmCount = int.Parse(ds_CourseParameter.Tables[0].Rows[0]["AM_COUNT"].ToString());
                     int_PmCount = int.Parse(ds_CourseParameter.Tables[0].Rows[0]["PM_COUNT"].ToString());
                }
            }
            int_WeekDayCount = (int_WeekDayCount > 7 ? 7 : int_WeekDayCount);
            //生成课程表表头
            SetCurSheTitle(int_WeekDayCount, ref tabCurShe);
            //生成上午课表
            SetAmCurShe(int_AmCount, int_WeekDayCount, 1, ref tabCurShe, "上午");
            //生成下午课表
            SetAmCurShe(int_PmCount, int_WeekDayCount, int_AmCount + 1, ref tabCurShe, "下午");

}
#endregion

另外一种：

出处：http://www.jb51.net/article/33687.htm

GridView，ASP.NET中很常用的数据显示控件，这里，我将用这个控件来实现课程表的显示。首先说说课程表的显示与普通记录的显示有何不同？这里所说的普通记录是指直接从数据库中查询出来的、没有经过任何处理的记录。通常，我们用GridView显示这些普通记录，只需直接将这些记录表绑定到GridView中即可。但是，课程表的显示可不是这么简单，它需要将普通记录继续加工，需要根据记录中具体的数据来确定数据需要显示在哪一行、哪一列，而且需要根据课程开始时间和结束时间动态合并单元格，最后才是数据的显示。这就是课程表显示的难点之所在。好了，下面就看看我是如何实现的吧。

.aspx文件中代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="DataBind.test" %> 
<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head runat="server"> 
<title></title> 
</head> 
<body> 
<form id="form1" runat="server"> 
<div> 
<asp:GridView ID="GridView1" runat="server" 
onrowdatabound="GridView1_RowDataBound1" BorderWidth="1"> 
<HeaderStyle Wrap="False" /> 
<RowStyle HorizontalAlign="Center" VerticalAlign="Middle" /> 
</asp:GridView> 
</div> 
</form> 
</body> 
</html>

.aspx.cs文件中代码：

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Data.SqlClient; 
using System.Data; 
using System.Text.RegularExpressions; 
namespace DataBind 
{ 
public partial class test : System.Web.UI.Page 
{ 
protected void Page_Load(object sender, EventArgs e) 
{ 
SqlConnection con = DB.createCon();//创建连接对象 
SqlDataAdapter sda = new SqlDataAdapter(); 
sda.SelectCommand = new SqlCommand("Select * from Schedule ", con); 
DataSet ds = new DataSet(); 
sda.Fill(ds); 
DataTable table = new DataTable(); 
table = ds.Tables[0]; 
DataTable dtSchedule = new DataTable();//此表用于存放转换后的课程表（格式与日常见到的一样） 
//添加八列 
dtSchedule.Columns.Add("课程表"); 
for (int i = 1; i < 8; i++) 
{ 
dtSchedule.Columns.Add("星期" + WeekConvertToChinese(i)); 
} 
//添加八行 
for (int i = 0; i < 8; i++) 
{ 
dtSchedule.Rows.Add(); 
} 
//添加左侧固定信息（第几节课） 
for (int i = 0; i < 8; i++) 
{ 
dtSchedule.Rows[i][0] = "第" + ConvertToChinese(i+1) + "节"; 
} 
//此数组用于存放需要合并的单元格信息。如：需要合并第一列的一、二单元格 
//那么，数组中一行的三个数分别为1,1,2 
int[][] tempArray = new int[table.Rows.Count][]; 
//数组初始化 
for (int i = 0; i < table.Rows.Count; i++) 
{ 
tempArray[i] = new int[3]; 
for (int j = 0; j < 3; j++) 
{ 
tempArray[i][j] = 0; 
} 
} 
//遍历table，将每条课表信息填在tab中适当的位置。 
for (int i = 0; i < table.Rows.Count; i++) 
{ 
//课是周几的课 
string week = Convert.ToString(table.Rows[i]["Week"]); 
//课开始时间 
string startTime =Convert.ToString( table.Rows[i]["StartTime"]); 
//课结束时间 
string endTime = Convert.ToString(table.Rows[i]["EndTime"]); 
for (int weekCount = 1; weekCount < 8; weekCount++)//确定本条数据将来显示在哪一列 
{ 
if (week == Convert.ToString(dtSchedule.Columns[weekCount].ColumnName))//跟星期做比较，确定数据应该写在那一列 
{ 
tempArray[i][0] = weekCount;//记录星期（确定将来的数据显示在哪一列） 
break; 
} 
} 
for (int j = 0; j < dtSchedule.Rows.Count; j++)//确定课程的开始时间和结束时间，并填写数据 
{ 
string section =Convert.ToString( dtSchedule.Rows[j][0]);//当前行是第几节课 
if (section == startTime)//判断课程开始时间，确定位置，填写数据 
{ 
tempArray[i][1] = j;//记录上课开始时间（确定数据数据显示在哪一行） 
dtSchedule.Rows[j][tempArray[i][0]] = Convert.ToString(table.Rows[i]["CourseName"]) + "<br />" + 
Convert.ToString(table.Rows[i]["TeacherName"]); 
} 
if (section == endTime)//判断课程结束时间，记录位置 
{ 
tempArray[i][2] = j;//记录课结束时间 
break; 
} 
} 
} 
GridView1.DataSource = dtSchedule; 
GridView1.DataBind(); 
//合并单元格 
for (int i = 0; i < table.Rows.Count; i++) 
GroupCol(GridView1, tempArray[i][0], tempArray[i][1], tempArray[i][2]); 
} 
/// <summary> 
/// 合并某列中的多个单元格 
/// </summary> 
/// <param name="GridView1"></param> 
/// <param name="cols">要合并的那一列</param> 
/// <param name="sRow">开始行</param> 
/// <param name="eRow">结束行</param> 
public static void GroupCol(GridView GridView1, int cols, int sRow, int eRow) 
{ 
//if (GridView1.Rows.Count < 1 || cols > GridView1.Columns.Count - 1) 
//{ 
// return; 
//} 
//if (GridView1.Rows.Count < 1 || cols > GridView1.Rows[0].Cells.Count - 1) 
//{ 
// return; 
//} 
TableCell oldTc = GridView1.Rows[sRow].Cells[cols]; 
for (int i = 1; i <= eRow - sRow; i++) 
{ 
TableCell tc = GridView1.Rows[sRow + i].Cells[cols]; 
tc.Visible = false; 
if (oldTc.RowSpan == 0) 
{ 
oldTc.RowSpan = 1; 
} 
oldTc.RowSpan++; 
oldTc.VerticalAlign = VerticalAlign.Middle; 
} 
} 
string ConvertToChinese(int x) 
{ 
string cstr = ""; 
switch (x) 
{ 
case 0: cstr = "零"; break; 
case 1: cstr = "一"; break; 
case 2: cstr = "二"; break; 
case 3: cstr = "三"; break; 
case 4: cstr = "四"; break; 
case 5: cstr = "五"; break; 
case 6: cstr = "六"; break; 
case 7: cstr = "七"; break; 
case 8: cstr = "八"; break; 
case 9: cstr = "九"; break; 
} 
return (cstr); 
} 
//转换星期几 
string WeekConvertToChinese(int x) 
{ 
string cstr = ""; 
switch (x) 
{ 
case 1: cstr = "一"; break; 
case 2: cstr = "二"; break; 
case 3: cstr = "三"; break; 
case 4: cstr = "四"; break; 
case 5: cstr = "五"; break; 
case 6: cstr = "六"; break; 
case 7: cstr = "日"; break; 
} 
return (cstr); 
} 
/// <summary> 
/// 使得GridView中的内容可以换行 
/// </summary> 
/// <param name="sender"></param> 
/// <param name="e"></param> 
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e) 
{ 
if (e.Row.RowType == DataControlRowType.DataRow) 
{ 
TableCellCollection cells = e.Row.Cells; 
foreach (TableCell cell in cells) 
{ 
cell.Text = Server.HtmlDecode(cell.Text); //注意：此处所有的列所有的html代码都会按照html格式输出，如果只需要其中的哪一列的数据需要转换，此处需要小的修改即可。 
} 
} 
} 
} 
}

最终显示效果：

beMyselfeveryday

关注

1
点赞
踩
6

收藏

觉得还不错? 一键收藏
2
评论
asp.net 动态生成Table课表

出处：http://hi.baidu.com/yore2003/item/8f5b1558fcd9f6abadc8573a#region 生成课表 /// /// 生成课表 /// /// 每天上午或下午的节数 /// 每周上课的天数 /// 每天从第几节开始生成课表
复制链接

扫一扫