mysql自动排课_高校智能排课系统算法

1 ///

2 ///取最优的时间片id3 ///

4 /// 教室id

5 /// 星期id

6 /// 授课id

7 /// 班级id

8 /// 教室id(S)

9 ///

10 private int GetBestTime(int roomid,int wk,int tlid,intclid)11 {12 //定义初始化存放已排的时间片的数组

13 ArrayList uTime = newArrayList();14 //定义初始化存放空时间片的数组

15 ArrayList nTime = newArrayList();16

17 for (int i = 1; i <= 20; i++)18 {19 if (i != 7 && i != 8)20 {21 //==判断当前时间片是否为空

22 int timeid =wbgd.GetTimeID(wk, i);23 int rtlid =wbgd.GetTlIDByRoomATime(roomid, timeid);24 if (rtlid == 0)25 {26 //检测冲突

27 bool flag = true;28 DataTable dtteach =wbgd.GetTeachNameByTLID(tlid);29 for (int t = 0; t < dtteach.Rows.Count; t++)30 {31 int teachid = int.Parse(dtteach.Rows[t]["id"].ToString());32 if (!wbgd.CheckClash(timeid, teachid, roomid, clid))33 {34 flag = false;3