public void DropTimeBind()//以下代码为Drop_StartTime 、Drop_EndTime绑定数据
{
ArrayList ArrTime = new ArrayList();
for (int i = NeedDay; i <= BookDay; i++)
{
int IntSelectYear = DateTime.Now.AddDays(i).Year;
int IntSelectMonth = DateTime.Now.AddDays(i).Month;
int IntSelectDay = DateTime.Now.AddDays(i).Day;
string SelectDate = IntSelectYear.ToString() + "年" + IntSelectMonth.ToString() + "月" + IntSelectDay.ToString() + "日";
//for (int j = 0; j <= DtClass.Tables[0].Rows.Count; i++)
//{
// DataSet DsBook = SqlHelper.ExecuteDataset(CommandType.Text, "SELECT * FROM [BookClass].[dbo].[BookList] WHERE Address ='"+DtClass.Tables[0].Rows[1][j]+"'AND ClassNum='"+DtClass.Tables[0].Rows[2][j]+"'");
// if (DsBook.Tables[0].Rows.Count != 6 && DtClass.Tables[0].Rows.Count != 0)
// {
// SqlHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO [BookClass].[dbo].[BookList](Address,ClassNum,BookDate,StartTime,EndTime,IsBooked) VALUES ('" + DtClass.Tables[0].Rows[1][j].ToString() + "','" + DtClass.Tables[0].Rows[2][j].ToString() + "','" + SelectDate + "','8:00', '10:00','0')");
// SqlHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO [BookClass].[dbo].[BookList](Address,ClassNum,BookDate,StartTime,EndTime,IsBooked) VALUES ('" + DtClass.Tables[0].Rows[1][j].ToString() + "','" + DtClass.Tables[0].Rows[2][j].ToString() + "','" + SelectDate + "','10:00','12:00','0')");
// SqlHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO [BookClass].[dbo].[BookList](Address,ClassNum,BookDate,StartTime,EndTime,IsBooked) VALUES ('" + DtClass.Tables[0].Rows[1][j].ToString() + "','" + DtClass.Tables[0].Rows[2][j].ToString() + "','" + SelectDate + "','12:00','14:00','0')");
// SqlHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO [BookClass].[dbo].[BookList](Address,ClassNum,BookDate,StartTime,EndTime,IsBooked) VALUES ('" + DtClass.Tables[0].Rows[1][j].ToString() + "','" + DtClass.Tables[0].Rows[2][j].ToString() + "','" + SelectDate + "','14:00','18:00','0')");
// SqlHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO [BookClass].[dbo].[BookList](Address,ClassNum,BookDate,StartTime,EndTime,IsBooked) VALUES ('" + DtClass.Tables[0].Rows[1][j].ToString() + "','" + DtClass.Tables[0].Rows[2][j].ToString() + "','" + SelectDate + "','19:00','21:00','0')");
// SqlHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO [BookClass].[dbo].[BookList](Address,ClassNum,BookDate,StartTime,EndTime,IsBooked) VALUES ('" + DtClass.Tables[0].Rows[1][j].ToString() + "','" + DtClass.Tables[0].Rows[2][j].ToString() + "','" + SelectDate + "','21:00','23:00','0')");
// }
//}
ArrTime.Add(SelectDate);
}
Drop_StartTime.DataSource = ArrTime;
Drop_StartTime.DataBind();
if (Drop_EndTime.DataSource == null)
{
Drop_EndTime.DataSource = ArrTime;
Drop_EndTime.DataBind();
}
}
protected void Drop_StartTime_SelectedIndexChanged(object sender, EventArgs e) //开始时间改变后为Drop_EndTime绑定数据
{
ArrayList ArrEndTime = new ArrayList();
DateTime StartTime = Convert.ToDateTime(Drop_StartTime.SelectedValue.ToString());
for (int i = 0; i <= NeedDay; i++)
{
int IntSelectEndYear = StartTime.AddDays(i).Year;
int IntSelectEndMonth = StartTime.AddDays(i).Month;
int IntSelectEndDay = StartTime.AddDays(i).Day;
if (IntSelectEndDay > DateTime.Now.Day + NeedDay)
{
break;
}
string SelectEndDate = IntSelectEndYear.ToString() + "年" + IntSelectEndMonth.ToString() + "月" + IntSelectEndDay.ToString() + "日";
ArrEndTime.Add(SelectEndDate);
}
Drop_EndTime.DataSource = ArrEndTime;
Drop_EndTime.DataBind();
}
