public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.Personal_Calendar calendar = new BLL.Personal_Calendar(); Model.Personal_Calendar model = new Model.Personal_Calendar(); if (request["Action"] == "get") { CalendarViewType viewType = (CalendarViewType)Enum.Parse(typeof(CalendarViewType), request["viewtype"]); string strshowday = request["showdate"]; int clientzone = Convert.ToInt32(request["timezone"]); int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; var format = new CalendarViewFormat(viewType, DateTime.Parse(strshowday), DayOfWeek.Monday); DataSet ds = calendar.GetList("emp_id=" + int.Parse(context.Request.Cookies["UserID"].Value) + " and StartTime>='" + format.StartDate + "' and EndTime<='" + format.EndDate + "'"); string dt = DataToJSON(ds); var data = new JsonCalendarViewData(calendar.DataTableToList(ds.Tables[0]), format.StartDate, format.EndDate); context.Response.Write("{\"start\":\"\\/Date(" + MilliTimeStamp(format.StartDate) + ")\\/\",\"end\":\"\\/Date(" + MilliTimeStamp(format.EndDate) + ")\\/\",\"error\":null,\"issort\":true,\"events\":[" + dt + "]}"); //context.Response.Write(dt); } if (request["Action"] == "quickadd") { int clientzone = Convert.ToInt32(request["timezone"]); int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; model.Subject = PageValidate.InputText(request["CalendarTitle"], 4000); model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff); model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff); model.IsAllDayEvent = PageValidate.InputText(request["IsAllDayEvent"], 255) == "1" ? true : false; model.CalendarType = 1; model.InstanceType = 0; model.UPAccount = context.Request.Cookies["UserID"].Value; model.UPTime = DateTime.Now; model.MasterId = clientzone; model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value); model.Category = PageValidate.InputText(context.Request.Cookies["UserID"].Value, 50); int n = calendar.Add(model); context.Response.Write("{\"IsSuccess\":true,\"Msg\":\"\u64cd\u4f5c\u6210\u529f!\",\"Data\":\"" + n + "\"}"); } if (request["Action"] == "quickupdate") { string Id = request["calendarId"]; int clientzone = Convert.ToInt32(request["timezone"]); int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff); model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff); model.UPAccount = context.Request.Cookies["UserID"].Value; model.UPTime = DateTime.Now; model.MasterId = clientzone; model.Id = int.Parse(Id); calendar.quickUpdate(model); context.Response.Write("{IsSuccess:true}"); } if (request["Action"] == "quickdel") { int id = Convert.ToInt32(request["calendarId"]); calendar.Delete(id); context.Response.Write("{IsSuccess:true}"); } if (request["Action"] == "form") { int id = Convert.ToInt32(request["calendarid"]); DataSet ds = calendar.GetList("Id=" + id); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } if (request["Action"] == "save") { string Id = request["calendarid"]; int clientzone = 8; int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; model.StartTime = DateTime.Parse(request["T_starttime"]).AddHours(zonediff); model.EndTime = DateTime.Parse(request["T_endtime"]).AddHours(zonediff); model.Subject = Common.PageValidate.InputText(request["T_content"], 4000); model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value); model.UPAccount = context.Request.Cookies["UserID"].Value; model.UPTime = DateTime.Now; model.MasterId = clientzone; model.CalendarType = 1; model.InstanceType = 0; model.IsAllDayEvent = PageValidate.InputText(request["allday"], 255) == "True" ? true : false; model.Id = int.Parse(Id); calendar.Update(model); context.Response.Write("{IsSuccess:true}"); } if (request["Action"] == "Today") { DateTime starttime = DateTime.Parse(DateTime.Now.ToShortDateString() + " 00:00:00"); DateTime endtime = DateTime.Parse(DateTime.Now.AddDays(1).ToShortDateString() + " 00:00:00"); DataSet ds = calendar.GetList(0, "datediff(day,[StartTime],getdate())=0 and datediff(day,[EndTime],getdate())=0 and emp_id=" + int.Parse(request.Cookies["UserID"].Value), "[StartTime] desc"); context.Response.Write(GetGridJSON.DataTableToJSON(ds.Tables[0])); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.Personal_Calendar calendar = new BLL.Personal_Calendar(); Model.Personal_Calendar model = new Model.Personal_Calendar(); if (request["Action"] == "get") { CalendarViewType viewType = (CalendarViewType)Enum.Parse(typeof(CalendarViewType), request["viewtype"]); string strshowday = request["showdate"]; int clientzone = Convert.ToInt32(request["timezone"]); int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; var format = new CalendarViewFormat(viewType, DateTime.Parse(strshowday), DayOfWeek.Monday); DataSet ds = calendar.GetList("emp_id=" + int.Parse(context.Request.Cookies["UserID"].Value) + " and StartTime>='" + format.StartDate.ToString("yyyy-MM-dd hh:mm:ss") + "' and EndTime<='" + format.EndDate.ToString("yyyy-MM-dd hh:mm:ss") + "'"); string dt = DataToJSON(ds); var data = new JsonCalendarViewData(calendar.DataTableToList(ds.Tables[0]), format.StartDate, format.EndDate); context.Response.Write("{\"start\":\"\\/Date(" + MilliTimeStamp(format.StartDate) + ")\\/\",\"end\":\"\\/Date(" + MilliTimeStamp(format.EndDate) + ")\\/\",\"error\":null,\"issort\":true,\"events\":[" + dt + "]}"); //context.Response.Write(dt); } if (request["Action"] == "quickadd") { int clientzone = Convert.ToInt32(request["timezone"]); int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; model.Subject = PageValidate.InputText(request["CalendarTitle"], 4000); model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff); model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff); model.IsAllDayEvent = PageValidate.InputText(request["IsAllDayEvent"], 255) == "1" ? true : false; model.CalendarType = 1; model.InstanceType = 0; model.UPAccount = context.Request.Cookies["UserID"].Value; model.UPTime = DateTime.Now; model.MasterId = clientzone; model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value); model.Category = PageValidate.InputText(context.Request.Cookies["UserID"].Value, 50); int n = calendar.Add(model); context.Response.Write("{\"IsSuccess\":true,\"Msg\":\"\u64cd\u4f5c\u6210\u529f!\",\"Data\":\"" + n + "\"}"); } if (request["Action"] == "quickupdate") { string Id = request["calendarId"]; int clientzone = Convert.ToInt32(request["timezone"]); int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff); model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff); model.UPAccount = context.Request.Cookies["UserID"].Value; model.UPTime = DateTime.Now; model.MasterId = clientzone; model.Id = int.Parse(Id); calendar.quickUpdate(model); context.Response.Write("{IsSuccess:true}"); } if (request["Action"] == "quickdel") { int id = Convert.ToInt32(request["calendarId"]); calendar.Delete(id); context.Response.Write("{IsSuccess:true}"); } if (request["Action"] == "form") { int id = Convert.ToInt32(request["calendarid"]); DataSet ds = calendar.GetList("Id=" + id); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } if (request["Action"] == "save") { string Id = request["calendarid"]; int clientzone = 8; int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; model.StartTime = DateTime.Parse(request["T_starttime"]).AddHours(zonediff); model.EndTime = DateTime.Parse(request["T_endtime"]).AddHours(zonediff); model.Subject = Common.PageValidate.InputText(request["T_content"], 4000); model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value); model.UPAccount = context.Request.Cookies["UserID"].Value; model.UPTime = DateTime.Now; model.MasterId = clientzone; model.CalendarType = 1; model.InstanceType = 0; model.IsAllDayEvent = PageValidate.InputText(request["allday"], 255) == "True" ? true : false; model.Id = int.Parse(Id); calendar.Update(model); context.Response.Write("{IsSuccess:true}"); } if (request["Action"] == "Today") { DateTime starttime = DateTime.Parse(DateTime.Now.ToShortDateString() + " 00:00:00"); DateTime endtime = DateTime.Parse(DateTime.Now.AddDays(1).ToShortDateString() + " 00:00:00"); //DataSet ds = calendar.GetList(0, "datediff(day,[StartTime],getdate())=0 and datediff(day,[EndTime],getdate())=0 and emp_id=" + int.Parse(request.Cookies["UserID"].Value), "[StartTime] desc"); DataSet ds = calendar.GetList(0, "'" + DateTime.Now.ToShortDateString() + "' between [StartTime] and [EndTime] and emp_id=" + int.Parse(request.Cookies["UserID"].Value), "[StartTime] desc"); context.Response.Write(GetGridJSON.DataTableToJSON(ds.Tables[0])); } }