private void GetList() { V1_Components_Schedule_ScheduleList c = (V1_Components_Schedule_ScheduleList)Page.LoadControl("~/V1/Components/Schedule/ScheduleList.ascx"); DO_Schedule.UO_Schedule uoSeach = new DO_Schedule.UO_Schedule(); DefaultSort = DO_Schedule.Columns.CreateOn.ToString(); DefaultIsAsc = false; c.Sort = Sort; c.IsAsc = IsAsc; if (string.IsNullOrEmpty(Request["size"])) c.PageSize = 10; else c.PageSize = PageSize; c.PageIndex = PageIndex; uoSeach.BigDateCode = CurrentSession.Profile.BigDate.BigDateCode; CommonLibrary.WebObject.WebHelper.SetValues<DO_Schedule.UO_Schedule>(uoSeach, "ScheduleSch"); DataAccess.Data.PagingResult<DO_Schedule.UO_Schedule, DO_Schedule.UOList_Schedule> data = BO_Schedule.GetPagingList(uoSeach, c.PageIndex, c.PageSize, c.Sort, c.IsAsc); if (data.Total > 0) { c.SetData<DO_Schedule.UO_Schedule, DO_Schedule.UOList_Schedule>(data); c.IsAsc = IsAsc; this.Page.Controls.Add(c); } else { Response.Write("目前您的賓客列表是空的"); } }
public void ProcessRequest(HttpContext context) { try { WeddingLibrary.SessionObject currentSession = WeddingLibrary.SessionHelper.GetCurrentSession(); if (currentSession == null) { currentSession = SessionHelper.GetTestSession(); } if (currentSession != null) { string operaType = context.Request["operation"]; bool done = false; if (operaType == "add") { DO_Schedule.UO_Schedule addSchedule = new DO_Schedule.UO_Schedule(); CommonLibrary.WebObject.WebHelper.SetValues<DO_Schedule.UO_Schedule>(addSchedule, "Schedule_"); addSchedule.BigDateCode = currentSession.Profile.BigDate.BigDateCode; addSchedule.CreateBy = currentSession.Profile.LoginUser.LoginEmail; int scheduleCount = WeddingLibrary.Database.Imp.Schedule.GetRecordCountByBigDateCode(currentSession.Profile.BigDate.BigDateCode) + 1; addSchedule.ScheduleCode = scheduleCount.ToString("00000"); if (addSchedule.Insert() > 0) { context.Response.Write(AppResult<string>.GetResult("")); } else { context.Response.Write(AppResult<string>.GetResult("增加失敗")); } done = true; } else if (operaType == "edit" && !string.IsNullOrEmpty(context.Request["scheduleCode"])) { DO_Schedule.UO_Schedule editSchedule = WeddingLibrary.Database.Imp.Schedule.GetObjectByBigDateCodeAndScheduleCode(currentSession.Profile.BigDate.BigDateCode, context.Request["scheduleCode"]); if (editSchedule != null) { CommonLibrary.WebObject.WebHelper.SetValues<DO_Schedule.UO_Schedule>(editSchedule, "Schedule_"); editSchedule.BigDateCode = currentSession.Profile.BigDate.BigDateCode; editSchedule.UpdateBy = currentSession.Profile.LoginUser.LoginEmail; editSchedule.UpdateOn = DataAccess.DateTimeValues.DbTime; if (WeddingLibrary.Database.BusinessObject.BO_Schedule.UpdateObject(editSchedule, currentSession.Profile.BigDate.BigDateCode, editSchedule.ScheduleCode)) { WeddingLibrary.Web.JsonHelper.JsonSuccess(); } else { context.Response.Write(AppResult<string>.GetResult("更新失敗")); } } else { context.Response.Write(AppResult<string>.GetResult("找不到該客人信息")); } done = true; } else if (operaType == "get") { DO_Schedule.UO_Schedule uoSeach = new DO_Schedule.UO_Schedule(); string Sort = context.Request["SortBy"]; if (string.IsNullOrEmpty(Sort)) Sort = DO_Schedule.Columns.ScheduleName.ToString(); bool IsAsc = CommonLibrary.Utility.NumberHelper.ToInt(context.Request["IsAsc"], 0) == 1; int pageSize = CommonLibrary.Utility.NumberHelper.ToInt(context.Request["pageSize"], 0); if (pageSize == 0) pageSize = 10; int pageIndex = CommonLibrary.Utility.NumberHelper.ToInt(context.Request["PageIndex"], 1); uoSeach.BigDateCode = currentSession.Profile.BigDate.BigDateCode; CommonLibrary.WebObject.WebHelper.SetValues<DO_Schedule.UO_Schedule>(uoSeach, "GuestSch"); DataAccess.Data.PagingResult<DO_Schedule.UO_Schedule, DO_Schedule.UOList_Schedule> data = BO_Schedule.GetPagingList(uoSeach, pageIndex, pageSize, Sort, IsAsc); if (data.Total > 0) { foreach (Database.DataObject.DO_Schedule.UO_Schedule s in data.Result) { s.ConnInfo = null; } context.Response.Write(new AppResult<DataAccess.Data.PagingResult<DO_Schedule.UO_Schedule, DO_Schedule.UOList_Schedule>>(data, "").ToString()); } else { context.Response.Write(AppResult<string>.GetResult("目前您的日程表是空的")); } done = true; } if (!done) { context.Response.Write(AppResult<string>.GetResult("參數錯誤")); } } else { context.Response.Write(AppResult<string>.GetResult("Timeout")); } } catch (Exception ex) { WeddingLibrary.Logging.Files.Log.Error(ex); context.Response.Write(AppResult<string>.GetResult(ex.ToString())); } }