Dim tb As Table= Tables("课程安排")
For Each r As Row In tb.Rows
Dim js As Integer=r("节数")
Dim i As Integer = 1
Dim xqs As New List(Of Integer)
Do While i <= js
Dim xq As Integer = Rand.Next(1,6)
Dim jc As Integer = rand.Next(1,8)
Dim dr As DataRow = DataTables("课程详表").find("班级=\'" & r("班级") & "\' and 星期 = \'" & xq & "\' and 节次=\'" & jc & "\' and 科目 is null")
If dr IsNot Nothing
If xqs.Count....... < Math.Ceiling(r("节数")/5)
dr("科目")=r("科目")
dr("教师姓名")=r("教师姓名")
i=i+1
xqs.Add(xq)
End If
End If
Loop
Next
我的想法是在某一天安排的某学科不能超过周课时的平均数
另外Rand.Next(1,5)是不是不能得到5,我测试了一下好像没有5产生