ASP.Net 课程表绑定数据

版权声明:转载原创文章请以超链接形式请注明原文章出处,尊重作者,尊重原创!


恰饭广告




前端:(stuSchedule.aspx)

<table class="table table-bordered">
                    <tr class="tdstyle">
                        <td class="auto-style2"></td>
                        <td>星期一</td>
                        <td>星期二</td>
                        <td>星期三</td>
                        <td>星期四</td>
                        <td>星期五</td>
                        <td>星期六</td>
                        <td>星期日</td>
                    </tr>
                    <tr>
                        <td class="auto-style2">第 1-2 节</td>
                        <td><%=Schedule[0,0] %></td>
                        <td><%=Schedule[0,1] %></td>
                        <td><%=Schedule[0,2] %></td>
                        <td><%=Schedule[0,3] %></td>
                        <td><%=Schedule[0,4] %></td>
                        <td><%=Schedule[0,5] %></td>
                        <td><%=Schedule[0,6] %></td>
                    </tr>
                    <tr>
                        <td class="auto-style2">第 3-4 节</td>
                        <td><%=Schedule[1,0] %></td>
                        <td><%=Schedule[1,1] %></td>
                        <td><%=Schedule[1,2] %></td>
                        <td><%=Schedule[1,3] %></td>
                        <td><%=Schedule[1,4] %></td>
                        <td><%=Schedule[1,5] %></td>
                        <td><%=Schedule[1,6] %></td>
                    </tr>
                    <tr>
                        <td class="auto-style2">第 5-6 节</td>
                        <td><%=Schedule[2,0] %></td>
                        <td><%=Schedule[2,1] %></td>
                        <td><%=Schedule[2,2] %></td>
                        <td><%=Schedule[2,3] %></td>
                        <td><%=Schedule[2,4] %></td>
                        <td><%=Schedule[2,5] %></td>
                        <td><%=Schedule[2,6] %></td>
                    </tr>
                    <tr >
                        <td class="auto-style2">第 7-8 节</td>
                        <td><%=Schedule[3,0] %></td>
                        <td><%=Schedule[3,1] %></td>
                        <td><%=Schedule[3,2] %></td>
                        <td><%=Schedule[3,3] %></td>
                        <td><%=Schedule[3,4] %></td>
                        <td><%=Schedule[3,5] %></td>
                        <td><%=Schedule[3,6] %></td>
                    </tr>
                    <tr>
                        <td class="auto-style2">第 9-10 节</td>
                        <td><%=Schedule[4,0] %></td>
                        <td><%=Schedule[4,1] %></td>
                        <td><%=Schedule[4,2] %></td>
                        <td><%=Schedule[4,3] %></td>
                        <td><%=Schedule[4,4] %></td>
                        <td><%=Schedule[4,5] %></td>
                        <td><%=Schedule[4,6] %></td>
                    </tr>
                    <tr >
                        <td class="auto-style2">第 11-12 节</td>
                        <td><%=Schedule[5,0] %></td>
                        <td><%=Schedule[5,1] %></td>
                        <td><%=Schedule[5,2] %></td>
                        <td><%=Schedule[5,3] %></td>
                        <td><%=Schedule[5,4] %></td>
                        <td><%=Schedule[5,5] %></td>
                        <td><%=Schedule[5,6] %></td>
                    </tr>
                </table>

后台:前端:(stuSchedule.aspx)

using SelectCourse.BLL;
using SelectCourse.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace SelectCourse.student
{
    public partial class stuSchedule : System.Web.UI.Page
    {
        public string[,] Schedule = new string[6, 7];
        StudentBLL studentBLL = new StudentBLL();
        StudentInfo student = new StudentInfo();
        private void loadSchedule(StudentInfo stu)
        {
            string semester = "";
            int year = Convert.ToInt32(DateTime.Now.ToString("yyyy"));
            int month = Convert.ToInt32(DateTime.Now.ToString("MM"));
            if (month >= 3 && month <= 8)
            {
                semester = year + "年下学期";
                labSemester.Text = semester;
            }
            else
            {
                semester = year + "年上学期";
                labSemester.Text = semester;
            }
            DataTable dt = studentBLL.Schedule(stu,semester);
            foreach (DataRow dr in dt.Rows)
            {
                int x = studentBLL.GetWeek(dr["ClassTime"].ToString());
                int y = studentBLL.GetFestival(dr["Classfestival"].ToString());
                string CourseInfo = String.Format("{0}<br>{1}&nbsp;{2}<br>{3}", dr["CName"].ToString(), dr["BuildingName"].ToString(), dr["RoomName"].ToString(), dr["TName"].ToString());
                Schedule[y, x] += CourseInfo;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["id"] == null)
            {
                Response.Redirect("../login.aspx");
            }
            else
            {
                student.id = Convert.ToInt32(Session["id"]);
                if (!IsPostBack)
                {
                    loadSchedule(student);
                }
            }
        }
    }
}

BLL层:

public int GetWeek(string ClassTime)
        {
            int week = 0;
            switch (ClassTime)
            {
                case "星期1":
                    week = 0;
                    break;
                case "星期2":
                    week = 1;
                    break;
                case "星期3":
                    week = 2;
                    break;
                case "星期4":
                    week = 3;
                    break;
                case "星期5":
                    week = 4;
                    break;
                case "星期6":
                    week = 5;
                    break;
                case "星期7":
                    week = 6;
                    break;
            }
            return week;
        }
        public int GetFestival(string Classfestival)
        {
            int Festival = 0;
            switch (Classfestival)
            {
                case "第1-2节":
                    Festival = 0;
                    break;
                case "第3-4节":
                    Festival = 1;
                    break;
                case "第5-6节":
                    Festival = 2;
                    break;
                case "第7-8节":
                    Festival = 3;
                    break;
                case "第9-10节":
                    Festival = 4;
                    break;
                case "第11-12节":
                    Festival = 5;
                    break;
            }
            return Festival;
        }
       public DataTable Schedule(StudentInfo stu, string semester)
        {
            return stuDAL.Schedule(stu, semester);
        }

DAL层:

#region 学生课程表
        public DataTable Schedule(StudentInfo stu,string semester)
        {
            string sql = "SELECT  Course.CName,Schedule.*,Building.BuildingName,Room.RoomName,Teacher.TName FROM SC,Student,Schedule,Course,Building,Room,Teacher WHERE SC.SId=@sid AND SC.SId=Student.SId AND SC.CId=Schedule.CId AND SC.CId=Course.CId AND Schedule.RoomId = Room.RoomId AND Room.BuildingId = Building.BuildingId AND Course.TId=Teacher.TId and Course.Semester=@semester and CisPass=1 and CisDeny=0";
            return mySqlHelper.ExecuteSqlTable(sql,
                new MySqlParameter("@sid", stu.id),
                new MySqlParameter("@semester", semester));
        }
        #endregion

原文链接:https://www.idaobin.com/archives/1316.html

让我恰个饭吧.ヘ( ̄ω ̄ヘ)

支付宝 ——————- 微信
图片加载中图片加载中



恰饭广告

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

÷ 7 = 1