public static void Insert(TimeSet ts) { SqlHelper.ExecuteNonQuery(@"insert into T_TimeSet(TimeOfDay,TimeOfAP,TimeOfSet) values(@TimeOfDay,@TimeOfAP,@TimeOfSet)", new SqlParameter("@TimeOfDay", ts.TimeOfDay), new SqlParameter("@TimeOfAP", ts.TimeOfAP), new SqlParameter("@TimeOfSet", ts.TimeOfSet)); }
public static TimeSet ToTimeSet(DataRow row) { TimeSet ts = new TimeSet(); ts.TimeOfDay = (string)row["TimeOfDay"]; ts.TimeOfAP = (string)row["TimeOfAP"]; ts.TimeOfSet = (string)row["TimeOfSet"]; return ts; }
public static TimeSet[] ListAll() { DataTable dt = SqlHelper.ExecuteDataTable("select * from T_TimeSet"); TimeSet[] ts = new TimeSet[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { ts[i] = ToTimeSet(dt.Rows[i]); } return ts; }
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 action = context.Request["Action"]; if (action == "Set") { var data = new { Name = AdminName, C = "" }; string html = CommonHelper.RenderHtml("../html/OrderNumber.htm", data); context.Response.Write(html); } else if (action == "Set_Add") { string year = context.Request["year"]; string month = context.Request["month"]; string day = context.Request["day"]; string time = context.Request["time"]; string sel = context.Request["groub"]; if (Convert.ToInt32(month) < 10) month = "0" + month; if (Convert.ToInt32(day) < 10) day = "0" + day; if (time == "s") time = "上午"; else time = "下午"; TimeSet ts = new TimeSet(); ts.TimeOfDay = year + "年" + month + "月" + day + "日"; ts.TimeOfAP = time; try { if (sel == "p") { DataTable dt = SqlHelper.ExecuteDataTable("select * from T_TimeUser where TimeOfDay=@TimeOfDay and TimeOfAP=@TimeOfAP", new SqlParameter("@TimeOfDay", ts.TimeOfDay), new SqlParameter("@TimeOfAP", ts.TimeOfAP)); int c = dt.Rows.Count; var data = new { Name = AdminName, TS = dt.Rows, C = c }; string html = CommonHelper.RenderHtml("../html/OrderNumber.htm", data); context.Response.Write(html); } else if (sel == "g") { DataTable dt = SqlHelper.ExecuteDataTable("select * from T_TimeStudent where TimeOfDay=@TimeOfDay and TimeOfAP=@TimeOfAP", new SqlParameter("@TimeOfDay", ts.TimeOfDay), new SqlParameter("@TimeOfAP", ts.TimeOfAP)); int c = dt.Rows.Count; var data = new { Name = AdminName, TS = dt.Rows, C = c }; string html = CommonHelper.RenderHtml("../html/OrderNumber.htm", data); context.Response.Write(html); } } catch { var data = new { Name = AdminName, TS = "0" }; string html = CommonHelper.RenderHtml("../html/OrderNumber.htm", data); context.Response.Write(html); } } else if (action == "Set_Delete") { string date = context.Request["Date"]; string time = context.Request["Time"]; TimeSetDAL.Delete(date, time); context.Response.Redirect("OrderSet.ashx"); } else if (action == "Set_OpenTime") { string opentime = context.Request["opentime"]; SqlHelper.ExecuteNonQuery("update T_VisitTime set VisitTime=@opentime where TID='1'", new SqlParameter("@opentime", opentime)); context.Response.Redirect("OrderSet.ashx"); } } }
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 action = context.Request["Action"]; if (action == "Set_Add") { string year = context.Request["year"]; string month = context.Request["month"]; string day = context.Request["day"]; string time = context.Request["time"]; string incident = context.Request["incident"]; if (Convert.ToInt32(month) < 10) month = "0" + month; if (Convert.ToInt32(day) < 10) day = "0" + day; if (time == "s") time = "上午"; else time = "下午"; if (incident == "b") incident = "闭馆"; else incident = "团体参观"; TimeSet ts = new TimeSet(); ts.TimeOfDay = year + "年" + month + "月" + day + "日"; ts.TimeOfAP = time; ts.TimeOfSet = incident; TimeSet timeset = TimeSetDAL.List(ts.TimeOfDay, ts.TimeOfAP); if (timeset == null) { TimeSetDAL.Insert(ts); context.Response.Redirect("OrderSet.ashx"); } else { DataTable time2 = SqlHelper.ExecuteDataTable("select * from T_VisitTime where TID='1'"); TimeSet[] ts2 = TimeSetDAL.ListAll(); var data = new { Name = AdminName, TS = ts2, Time = time2.Rows[0], Msg = "error" }; string html = CommonHelper.RenderHtml("../html/OrderSet.htm", data); context.Response.Write(html); } } else if (action == "Set_Delete") { string date = context.Request["Date"]; string time = context.Request["Time"]; TimeSetDAL.Delete(date, time); context.Response.Redirect("OrderSet.ashx"); } else if (action == "Set_OpenTime") { string opentime = context.Request["opentime"]; SqlHelper.ExecuteNonQuery("update T_VisitTime set VisitTime=@opentime where TID='1'", new SqlParameter("@opentime", opentime)); context.Response.Redirect("OrderSet.ashx"); } else { DataTable time = SqlHelper.ExecuteDataTable("select * from T_VisitTime where TID='1'"); TimeSet[] ts = TimeSetDAL.ListAll(); var data = new { Name = AdminName, TS = ts, Time = time.Rows[0], Msg = "" }; string html = CommonHelper.RenderHtml("../html/OrderSet.htm", data); context.Response.Write(html); } } }