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));
}
