public ActionResult ImportSignInfo(HttpPostedFileBase file, string SignID, SignListViewModel signListViewModel) { DataTable dataTable = new DataTable(); var fileName = file.FileName; var filePath = Server.MapPath(string.Format("~/{0}", "Files")); string path = Path.Combine(filePath, fileName); file.SaveAs(path); dataTable = ImportExcel.GetExcelDataTable(path); if (dataTable.Rows.Count > 0) { GameClubEntities gameClubEntities = new GameClubEntities(); CovertListHelper toList = new CovertListHelper(); List <SignInfo> signInfos = toList.convertToList <SignInfo>(dataTable); IEnumerable <SignInfo> signInfosResult = gameClubEntities.SignInfo.Where(s => s.SignID == SignID); foreach (var item in signInfos) { SignInfo signInfo = signInfosResult.Where(s => s.GameID == item.GameID).FirstOrDefault(); if (signInfo != null) { if (!string.IsNullOrEmpty(item.VoiceCondition)) { signInfo.VoiceCondition = item.VoiceCondition; } else { signInfo.VoiceCondition = "未语音"; } } } gameClubEntities.SaveChanges(); } signListViewModel = UpdateSignListViewModel(signListViewModel); return(PartialView("_SignList", signListViewModel)); }
public SignListViewModel SortSignListViewModel(SignListViewModel signListViewModel) { if (!(string.IsNullOrEmpty(signListViewModel.SortBy))) { if (signListViewModel.IsOrderBy) { signListViewModel.signListsPageList = SortSignLists(signListViewModel.pageID, signListViewModel.pageSize, signListViewModel.keyword, signListViewModel.SortBy, signListViewModel.CurrentSort); if (signListViewModel.SortBy.Equals(signListViewModel.CurrentSort)) { signListViewModel.CurrentSort = null; } else { signListViewModel.CurrentSort = signListViewModel.SortBy; } } else { signListViewModel.signListsPageList = SortSignLists(signListViewModel.pageID, signListViewModel.pageSize, signListViewModel.keyword, signListViewModel.SortBy, (string.IsNullOrEmpty(signListViewModel.CurrentSort))?signListViewModel.SortBy:null); } } else { signListViewModel.signListsPageList = EFSignInfo.searchSignLists(signListViewModel.keyword).OrderByDescending(s => s.SignID).ToPagedList(signListViewModel.pageID, signListViewModel.pageSize); } return(signListViewModel); }
/// <summary> /// 批量处理签到表 /// </summary> /// <param name="ListID"></param> /// <param name="formsubmit"></param> /// <param name="signListViewModel"></param> /// <returns></returns> public ActionResult DealSignList(List <string> ListID, string formsubmit, SignListViewModel signListViewModel) { if (ListID != null) { if (formsubmit == "删除") { if (EFSignInfo.DelSignList(ListID) == false) { return(View(false)); } } else if (formsubmit == "启用") { if (EFSignInfo.ActiveAbleList(ListID) == false) { return(View(false)); } } else if (formsubmit == "禁用") { if (EFSignInfo.ActiveDisableList(ListID) == false) { return(View(false)); } } } signListViewModel = UpdateSignListViewModel(signListViewModel); return(PartialView("_SignList", signListViewModel)); }
/// <summary> /// 更新签到表视图模型数据 /// </summary> /// <param name="signListViewModel"></param> /// <returns></returns> public SignListViewModel UpdateSignListViewModel(SignListViewModel signListViewModel) { TempData["PageSize"] = signListViewModel.pageSize; signListViewModel.signLists = EFSignInfo.signLists; signListViewModel = SortSignListViewModel(signListViewModel); return(signListViewModel); }
/// <summary> /// 修改更新签到表 /// </summary> /// <param name="signList"></param> /// <param name="signListViewModel"></param> /// <returns></returns> public ActionResult UpdateSignList(SignList signList, SignListViewModel signListViewModel) { if (ModelState.IsValid) { if (signList.EndDateTime < signList.StartDateTime) { ViewBag.Fault = "结束时间不能小于开始时间!"; return(View(false)); } if (signList.Active == true) { if (signList.StartDateTime < DateTime.Now && signList.EndDateTime < DateTime.Now) { ViewBag.Fault = "选定的时间起止范围请不要小于当前时间,除非把该表设为禁用状态 !"; return(View(false)); } } if (EFSignInfo.UpdateSignList(signList)) { signListViewModel = UpdateSignListViewModel(signListViewModel); return(PartialView("_SignList", signListViewModel)); } else { return(View(false)); } } else { return(View(false)); } }
/// <summary> /// 签到表管理 /// </summary> /// <param name="pageID"></param> /// <param name="pageSize"></param> /// <param name="keyword"></param> /// <returns></returns> public ActionResult SignListManage(int pageID = 1, int pageSize = 20, string keyword = null, string sortBy = null, string currentSort = null, bool isOrderBy = false) { DealViewBag("SignList"); signListViewModel = GetSignListViewModel(pageID, pageSize, keyword, sortBy, currentSort, isOrderBy); if (Request.IsAjaxRequest()) { return(PartialView("_SignList", signListViewModel)); } return(View(signListViewModel)); }
/// <summary> /// 获取设置签到表视图模型数据 /// </summary> /// <param name="pageID"></param> /// <param name="pageSize"></param> /// <param name="keyword"></param> /// <returns></returns> public SignListViewModel GetSignListViewModel(int pageID, int pageSize, string keyword, string sortBy, string currentSort, bool isOrderBy) { TempData["PageSize"] = pageSize; signListViewModel = new SignListViewModel { signLists = EFSignInfo.signLists, signListsPageList = EFSignInfo.searchSignLists(keyword).OrderByDescending(s => s.SignID).ToPagedList(pageID, pageSize), pageID = pageID, pageSize = pageSize, keyword = keyword, CurrentSort = currentSort, SortBy = sortBy, IsOrderBy = isOrderBy }; signListViewModel = SortSignListViewModel(signListViewModel); return(signListViewModel); }
/// <summary> /// 获取某个签到表信息 /// </summary> /// <param name="SignID"></param> /// <returns></returns> public ActionResult GetSignList(string SignID, SignListViewModel signListViewModel) { SignList signList = EFSignInfo.signList(SignID); signListViewModel.signList = signList; signListViewModel.ContributionLists = EFContribution.ContributionLists.Where(c => c.SignID == null).OrderByDescending(c => c.ContributionID).Take(10).ToList(); signListViewModel.MemberGroupLists = EFMemberGroup.MemberGroupLists.Where(m => m.SignID == null).OrderByDescending(m => m.MemberGroupID).Take(10).ToList(); signListViewModel = UpdateSignListViewModel(signListViewModel); if (signList != null) { return(PartialView("_SignListEdit", signListViewModel)); } else { return(View(false)); } }
/// <summary> /// 删除签到表 /// </summary> /// <param name="signList"></param> /// <param name="signListViewModel"></param> /// <returns></returns> public ActionResult DelSignList(SignList signList, SignListViewModel signListViewModel) { if (ModelState.IsValid) { if (EFSignInfo.DelSignList(signList)) { ViewBag.Message = "删除签到表成功!"; signListViewModel = UpdateSignListViewModel(signListViewModel); return(PartialView("_SignList", signListViewModel)); } else { return(PartialView("_SignList", false)); } } else { return(PartialView("_SignList", false)); } }
/// <summary> /// 添加签到表 /// </summary> /// <param name="signList"></param> /// <param name="signListViewModel"></param> /// <returns></returns> public ActionResult AddSignList(SignList signList, SignListViewModel signListViewModel, bool CreateContribution = false, bool CreateMemberGroup = false) { DealViewBag("SignList"); bool f = true; if (ModelState.IsValid) { if (signList.EndDateTime < signList.StartDateTime) { ViewBag.Fault = "结束时间不能小于开始时间!"; f = false; } if (f && signList.Active == true) { if (signList.StartDateTime < DateTime.Now && signList.EndDateTime < DateTime.Now) { ViewBag.Fault = "选定的时间起止范围请不要小于当前时间,除非把该表设为禁用状态 !"; f = false; } } if (f && !string.IsNullOrEmpty(signList.ContributionID)) { if (CreateContribution) { ViewBag.Fault = "不要同时选择和创建贡献表!"; f = false; } } else { if (CreateContribution) { signList.ContributionID = signList.SignID; } } if (f && !string.IsNullOrEmpty(signList.MemberGroupID)) { if (CreateMemberGroup) { ViewBag.Fault = "不要同时选择和创建分组表!"; f = false; } } else { if (CreateMemberGroup) { signList.MemberGroupID = signList.SignID; } } if (f) { signList.CreateTime = DateTime.Now; if (!string.IsNullOrEmpty(signList.ContributionID)) { ContributionList contributionList = new ContributionList { ContributionID = signList.ContributionID, Type = signList.Type, CreateDateTime = signList.CreateTime, }; EFContribution.AddContributionList(contributionList); } if (!string.IsNullOrEmpty(signList.MemberGroupID)) { MemberGroupList memberGroupList = new MemberGroupList { MemberGroupID = signList.MemberGroupID, Type = signList.Type, CreateDateTime = signList.CreateTime, }; EFMemberGroup.AddMemberGroupList(memberGroupList); } if (EFSignInfo.AddSignList(signList)) { if (signList.ContributionID != null) { ContributionList contributionListResult = EFContribution.ContributionList(signList.ContributionID); ContributionList contributionList = new ContributionList { ContributionID = contributionListResult.ContributionID, Type = contributionListResult.Type, CreateDateTime = contributionListResult.CreateDateTime, SignID = signList.SignID, MemberGroupID = signList.MemberGroupID }; EFContribution.UpdateContributionList(contributionList); } if (signList.MemberGroupID != null) { MemberGroupList memberGroupListResult = EFMemberGroup.MemberGroupList(signList.MemberGroupID); MemberGroupList memberGroupList = new MemberGroupList { MemberGroupID = memberGroupListResult.MemberGroupID, Type = memberGroupListResult.Type, CreateDateTime = memberGroupListResult.CreateDateTime, SignID = signList.SignID, ContributionID = signList.ContributionID, }; EFMemberGroup.UpdateMemberGroupList(memberGroupList); } signListViewModel = UpdateSignListViewModel(signListViewModel); ViewBag.Success = "添加签到表成功!"; } else { ViewBag.Fault = "添加签到表失败!"; f = false; } } } else { ViewBag.Fault = "输入数据有误!"; } if (!f) { signListViewModel = UpdateSignListViewModel(signListViewModel); } return(PartialView("_SignList", signListViewModel)); }
public ActionResult GetAddSignList(SignListViewModel signListViewModel) { signListViewModel.ContributionLists = EFContribution.ContributionLists.Where(c => c.SignID == null).OrderByDescending(c => c.ContributionID).Take(10).ToList(); signListViewModel.MemberGroupLists = EFMemberGroup.MemberGroupLists.Where(m => m.SignID == null).OrderByDescending(m => m.MemberGroupID).Take(10).ToList(); return(PartialView("_SignListAdd", signListViewModel)); }
/// <summary> /// 签到表搜索结果 /// </summary> /// <param name="pageID"></param> /// <param name="pageSize"></param> /// <param name="keyword"></param> /// <returns></returns> public ActionResult SearchSignList(int pageID = 1, int pageSize = 20, string keyword = null, string sortBy = null, string currentSort = null, bool isOrderBy = false) { DealViewBag("SignList"); signListViewModel = GetSignListViewModel(pageID, pageSize, keyword, sortBy, currentSort, isOrderBy); return(PartialView("_SignList", signListViewModel)); }