public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
string action = context.Request["Action"];
string AdminName = (string)context.Session["LoginAdminName"];
if (AdminName == null)
{
var data = new { Title = "现代科技体验中心", Msg = "" };
string html = CommonHelper.RenderHtml("../html/AdminLogin.htm", data);
context.Response.Write(html);
}
else
{
if (action == "NoClass")
{
string Count = context.Request["count"];//已预约人数
string TimeofDay = context.Request["TimeofDay"];//当前时间
string TimeofAP = context.Request["TimeofAP"];
DataTable grade = SqlHelper.ExecuteDataTable("select distinct Grade from T_Student order by Grade desc");
// DataTable grade = SqlHelper.ExecuteDataTable("select distinct Grade from T_Student");
//context.Response.Write("已预约人数" + Count);//测试Count是否传值正确
//context.Response.Write("时间安排" + TimeofDay + TimeofAP);//测试时间传值
var data = new
{
Title = "选择班级之前",
Name = AdminName,
day = TimeofDay,
time = TimeofAP,
count = Count,//已预约人数
Grade=grade.Rows
};
string html = CommonHelper.RenderHtml("../html/SelectClass.htm", data);
context.Response.Write(html);
}
else if (action == "HaveClass")
{
string Count = context.Request["Count"];//已预约人数
string TimeofDay = context.Request["Day"];//当前时间
string TimeofAP = context.Request["Time"];
//context.Response.Write("已预约人数" + Count);//测试Count是否传值正确
//context.Response.Write("时间安排" + TimeofDay + TimeofAP);//测试时间传值
//string str = @"用户: " + username + " 欢迎您";
string Grade = context.Request["grade"];
string Class = context.Request["class"];
DateTime now = DateTime.Now;
int month = now.Month;
int year=now.Year;
if (month < 9) year = year - 1;
DataTable student = SqlHelper.ExecuteDataTable("select * from T_Student where Grade=@Grade and Class=@class and Year=@year", new SqlParameter("@Grade", Grade),
new SqlParameter("@Class", Class),new SqlParameter("@year", year.ToString()));
DataTable grade = SqlHelper.ExecuteDataTable("select distinct Grade from T_Student order by Grade desc");
Order[] order = new Order[student.Rows.Count];
for (int i = 0; i < student.Rows.Count; ++i)
{
order[i] = new Order();
order[i].Id = i + 1;
order[i].StuAccount = (string)student.Rows[i]["StuAccount"];
order[i].StuName = (string)student.Rows[i]["StuName"];
}
var data = new
{
Title = "用户列表",
//stu = student.Rows,
groupOrder = order,
Name = AdminName,
count = Count,//已预约人数
Grade=grade.Rows,
CurrentGrade = Grade,
CurrentClass = Class,
day = TimeofDay,
time = TimeofAP,
stuCount = student.Rows.Count//学生人数
};
string html = CommonHelper.RenderHtml("../html/SelectClass.htm", data);
context.Response.Write(html);
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
string AdminName = (string)context.Session["LoginAdminName"];
if (AdminName == null)
{
var data = new { Title = "现代科技体验中心", Msg = "" };
string html = CommonHelper.RenderHtml("../html/AdminLogin.htm", data);
context.Response.Write(html);
}
else
{
string state = null;
Order[] order = new Order[14];
for (int i = 0; i < 14; ++i)
{
order[i] = new Order();
if (i % 2 == 0)
{
order[i].Id = i + 1;
order[i].Date = DateTime.Now.AddDays(i / 2).ToString("yyyy年MM月dd日");
order[i].Time = "上午";
string orderNum = (string)SqlHelper.ExecuteScalar("select OrderUser from T_TimeNumber where TimeOfDay=@TimeOfDay and TimeOfAP=@TimeOfAP"
, new SqlParameter[] { new SqlParameter("@TimeOfDay", order[i].Date),
new SqlParameter("@TimeOfAP", order[i].Time)});
if (Convert.ToInt32(orderNum) <= 0)
{
order[i].NotOrderNumber = 50;//可以预约的人数
order[i].OrderNumber = 0;//已预约人数
}
else
{
order[i].OrderNumber = Convert.ToInt32(orderNum);
order[i].NotOrderNumber = 50 - Convert.ToInt32(orderNum);
}
state = order[i].Date;
}
else
{
order[i].Id = i + 1;
order[i].Date = state;
order[i].Time = "下午";
string orderNum = (string)SqlHelper.ExecuteScalar("select OrderUser from T_TimeNumber where TimeOfDay=@TimeOfDay and TimeOfAP=@TimeOfAP"
, new SqlParameter[] { new SqlParameter("@TimeOfDay", order[i].Date),
new SqlParameter("@TimeOfAP", order[i].Time)});
if (Convert.ToInt32(orderNum) <= 0)
{
order[i].NotOrderNumber = 50;//可以预约的人数
order[i].OrderNumber = 0;//已预约人数
}
else
{
order[i].OrderNumber = Convert.ToInt32(orderNum);
order[i].NotOrderNumber = 50 - Convert.ToInt32(orderNum);
}
}
}
var data = new { Order = order, Name = AdminName };
string html = CommonHelper.RenderHtml("../html/GroupOrder.htm", data);
context.Response.Write(html);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
string username = (string)context.Session["LoginUserName"];
if (username == null)
{
context.Response.Redirect("UserLogin.ashx?Action=Log");
}
else
{
string action = context.Request["Action"];
if (action == "Order")
{
string date = context.Request["Date"];
string time = context.Request["Time"];
TimeNumber tn = TimeNumberDAL.List(date, time);
if (tn == null)
{
TimeUser tu = new TimeUser();
tu.TimeOfDay = date;
tu.TimeOfAP = time;
tu.UserName = username;
TimeUserDAL.Insert(tu);
TimeNumber t = new TimeNumber();
t.TimeOfDay = date;
t.TimeOfAP = time;
t.OrderUser = 1;
TimeNumberDAL.Insert(t);
}
else
{
TimeUser tu = new TimeUser();
tu.TimeOfDay = date;
tu.TimeOfAP = time;
tu.UserName = username;
TimeUserDAL.Insert(tu);
TimeNumberDAL.Update(date, time);
}
context.Response.Redirect("UserOrder.ashx");
}
else
{
string past = null;
Order[] order = new Order[14];
for (int i = 0; i < 14; ++i)
{
order[i] = new Order();
if (i % 2 == 0)
{
order[i].Id = i + 1;
order[i].Date = DateTime.Now.AddDays(i / 2).ToString("yyyy年MM月dd日");
order[i].Time = "上午";
TimeNumber tn = TimeNumberDAL.List(order[i].Date, order[i].Time);
if (tn == null)
{
order[i].NotOrderNumber = 0;
order[i].OrderNumber = 50;
}
else
{
order[i].NotOrderNumber = tn.OrderUser;
order[i].OrderNumber = 50 - order[i].NotOrderNumber;
}
TimeSet timeset = TimeSetDAL.List(order[i].Date, order[i].Time);
if (timeset == null)//开馆
{
CheckUserOrderYesOrNo check = new CheckUserOrderYesOrNo();
string s = check.Check(order[i].Date, order[i].Time, username);
if (s == "yes")
{
order[i].State = "";
order[i].OrderYesOrNo = "White";
order[i].ButtonValue = "可预约";
}
else if (s == "mian")
{
order[i].State = "disabled";
order[i].OrderYesOrNo = "#ddd";
order[i].ButtonValue = "不可预约";
}
else
{
order[i].State = "disabled";
order[i].OrderYesOrNo = "Orange";
order[i].ButtonValue = "已预约";
}
}
else//闭馆
{
order[i].State = "disabled";
order[i].OrderYesOrNo = "#ddd";
order[i].ButtonValue = "闭馆";
}
past = order[i].Date;
}
else
{
order[i].Id = i + 1;
order[i].Date = past;
order[i].Time = "下午";
TimeNumber tn = TimeNumberDAL.List(order[i].Date, order[i].Time);
if (tn == null)
{
order[i].NotOrderNumber = 0;
order[i].OrderNumber = 50;
}
else
{
order[i].NotOrderNumber = tn.OrderUser;
order[i].OrderNumber = 50 - order[i].NotOrderNumber;
}
TimeSet timeset = TimeSetDAL.List(order[i].Date, order[i].Time);
if (timeset == null)//开馆
{
CheckUserOrderYesOrNo check = new CheckUserOrderYesOrNo();
string s = check.Check(order[i].Date, order[i].Time, username);
if (s == "yes")
{
order[i].State = "";
order[i].OrderYesOrNo = "White";
order[i].ButtonValue = "可预约";
}
else
{
order[i].State = "disabled";
order[i].OrderYesOrNo = "Orange";
order[i].ButtonValue = "已预约";
}
}
else//闭馆
{
order[i].State = "disabled";
order[i].OrderYesOrNo = "#ddd";
order[i].ButtonValue = "闭馆";
}
}
}
string str = @"用户: " + username + " 欢迎您";
var data = new { Title = "个人预约", str, Order = order };
string html = CommonHelper.RenderHtml("../html/UserOrder.htm", data);
context.Response.Write(html);
}
}
}
