//查询数据库获取班级的个数
private void GetClass()
{
string sql = "select ClassId,ClassName from dbo.Class";
DataSet ForTable = DBHelpSQL.Query(sql);
ClassIdArr = new string[ForTable.Tables[0].Rows.Count];
ClassNameArr = new string[ForTable.Tables[0].Rows.Count];
for (int i = 0; i < ForTable.Tables[0].Rows.Count; i++)
{
ClassIdArr[i] = ForTable.Tables[0].Rows[i]["ClassId"].ToString();
ClassNameArr[i] = ForTable.Tables[0].Rows[i]["ClassName"].ToString();
}
}
//判断是否选中
public Boolean OrNotCho(int Day, string ClassId, string SlotNo)
{
string TMonth = this.DropDownList1.SelectedValue;
string slotTime = "";
string sql = "select TimeSlot from dbo.PlanTable where Year=" + Year + " and Month=" + TMonth + " and Day=" + Day + " and ClassId=" + ClassId;
DataSet ForPlanTable = DBHelpSQL.Query(sql);
if (ForPlanTable.Tables[0].Rows.Count != 0)
{
if (ForPlanTable.Tables[0].Rows.Count > 1)
{
for (int n = 0; n < ForPlanTable.Tables[0].Rows.Count; n++)
{
slotTime += ForPlanTable.Tables[0].Rows[n]["TimeSlot"].ToString();
if (n < ForPlanTable.Tables[0].Rows.Count - 1)
{
slotTime += ",";
}
}
}
else
{
slotTime = ForPlanTable.Tables[0].Rows[0]["TimeSlot"].ToString();
}
}
if (slotTime == "")
{
return(false);
}
else
{
int r = slotTime.IndexOf(SlotNo);
if (slotTime.IndexOf(SlotNo) >= 0)
{
return(true);
}
else
{
return(false);
}
}
}