/// <summary>
/// 批量处理分组表
/// </summary>
/// <param name="ListID"></param>
/// <param name="DealAction"></param>
/// <returns></returns>
public bool DealListMemberGroupList(List <string> ListID, string DealAction)
{
bool f = true;
if ("删除".Equals(DealAction))
{
if (ListID != null)
{
f = true;
foreach (var item in ListID)
{
MemberGroupList memberGroupListResult = gameClubEntities.MemberGroupList.Where(m => m.MemberGroupID == item).FirstOrDefault();
if (memberGroupListResult != null)
{
if (DelMemberGroupList(memberGroupListResult) == false)
{
f = false;
}
}
else
{
f = false;
}
}
}
}
return(f);
}
/// <summary>
/// 添加分组表
/// </summary>
/// <param name="memberGroupList"></param>
/// <returns></returns>
public bool AddMemberGroupList(MemberGroupList memberGroupList)
{
MemberGroupList memberGroupListResult = gameClubEntities.MemberGroupList.Where(m => m.MemberGroupID == memberGroupList.MemberGroupID).FirstOrDefault();
if (memberGroupListResult == null)
{
memberGroupListResult = memberGroupList;
memberGroupListResult.CreateDateTime = DateTime.Now;
gameClubEntities.MemberGroupList.Add(memberGroupListResult);
gameClubEntities.SaveChanges();
foreach (var item in gameClubEntities.GameMember.Where(g => g.IsDel != true))
{
MemberGroup memberGroup = new MemberGroup
{
MemberGroupID = memberGroupList.MemberGroupID,
GameID = item.GameID,
};
gameClubEntities.MemberGroup.Add(memberGroup);
}
gameClubEntities.SaveChanges();
EFUserRecord.AddUserOperateRecord("添加了ID为" + memberGroupList.MemberGroupID + "的分组表信息");
return(true);
}
return(false);
}
/// <summary>
/// 删除分组表
/// </summary>
/// <param name="memberGroupList"></param>
/// <returns></returns>
public bool DelMemberGroupList(MemberGroupList memberGroupList)
{
MemberGroupList memberGroupListResult = gameClubEntities.MemberGroupList.Where(m => m.MemberGroupID == memberGroupList.MemberGroupID).FirstOrDefault();
if (memberGroupListResult != null)
{
SignList signList = gameClubEntities.SignList.Where(s => s.SignID == memberGroupList.SignID).FirstOrDefault();
ContributionList contributionList = gameClubEntities.ContributionList.Where(c => c.ContributionID == memberGroupList.ContributionID).FirstOrDefault();
IEnumerable <MemberGroup> memberGroups = gameClubEntities.MemberGroup.Where(m => m.MemberGroupID == memberGroupListResult.MemberGroupID);
if (signList != null)
{
signList.MemberGroupID = null;
}
if (contributionList != null)
{
contributionList.MemberGroupID = null;
}
foreach (var item in memberGroups)
{
gameClubEntities.MemberGroup.Remove(item);
}
gameClubEntities.MemberGroupList.Remove(memberGroupListResult);
gameClubEntities.SaveChanges();
EFUserRecord.AddUserOperateRecord("删除了ID为" + memberGroupList.MemberGroupID + "的分组表信息");
return(true);
}
return(false);
}
/// <summary>
/// 删除签到表
/// </summary>
/// <param name="signList"></param>
/// <returns>true表示删除成功，false表示删除失败，不存在该表</returns>
public bool DelSignList(SignList signList)
{
SignList signListResult = gameClubEntities.SignList.Where(s => s.SignID == signList.SignID).FirstOrDefault();
if (signListResult != null)
{
ContributionList contributionList = gameClubEntities.ContributionList.Where(c => c.ContributionID == signListResult.ContributionID).FirstOrDefault();
MemberGroupList memberGroupList = gameClubEntities.MemberGroupList.Where(m => m.MemberGroupID == signListResult.MemberGroupID).FirstOrDefault();
if (contributionList != null)
{
contributionList.SignID = null;
}
if (memberGroupList != null)
{
memberGroupList.SignID = null;
}
IEnumerable <SignInfo> signInfos = gameClubEntities.SignInfo.Where(s => s.SignID == signListResult.SignID);
foreach (var item in signInfos)
{
gameClubEntities.SignInfo.Remove(item);
}
gameClubEntities.SignList.Remove(signListResult);
gameClubEntities.SaveChanges();
EFUserRecord.AddUserOperateRecord("删除签到表ID为" + signList.SignID + "的签到表信息");
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除分组表
/// </summary>
/// <param name="memberGroupList"></param>
/// <param name="memberGroupListViewModel"></param>
/// <returns></returns>
public ActionResult DelMemberGroupList(MemberGroupList memberGroupList, MemberGroupListViewModel memberGroupListViewModel)
{
if (EFMemberGroup.DelMemberGroupList(memberGroupList))
{
memberGroupListViewModel = UpdateMemberGroupListViewModel(memberGroupListViewModel);
return(PartialView("_MemberGroupList", memberGroupListViewModel));
}
return(View(false));
}
/// <summary>
/// 更新签到表信息
/// </summary>
/// <param name="signList"></param>
/// <returns>true更新成功，false更新失败，不存在该签到表</returns>
public bool UpdateSignList(SignList signList)
{
if (signList == null)
{
return(false);
}
SignList signListResult = gameClubEntities.SignList.Where(s => s.SignID == signList.SignID).FirstOrDefault();
if (signListResult != null)
{
if (signListResult.ContributionID != signList.ContributionID)
{
if (signListResult.ContributionID != null)
{
ContributionList contributionList = gameClubEntities.ContributionList.Where(c => c.ContributionID == signListResult.ContributionID).FirstOrDefault();
contributionList.SignID = null;
}
if (!string.IsNullOrEmpty(signList.ContributionID))
{
ContributionList contributionList = gameClubEntities.ContributionList.Where(c => c.ContributionID == signList.ContributionID).FirstOrDefault();
contributionList.SignID = signList.SignID;
}
gameClubEntities.SaveChanges();
}
if (signListResult.MemberGroupID != signList.MemberGroupID)
{
if (signListResult.MemberGroupID != null)
{
MemberGroupList memberGroupList = gameClubEntities.MemberGroupList.Where(m => m.MemberGroupID == signListResult.MemberGroupID).FirstOrDefault();
memberGroupList.SignID = null;
}
if (!string.IsNullOrEmpty(signList.MemberGroupID))
{
MemberGroupList memberGroupList = gameClubEntities.MemberGroupList.Where(m => m.MemberGroupID == signList.MemberGroupID).FirstOrDefault();
memberGroupList.SignID = signList.SignID;
}
gameClubEntities.SaveChanges();
}
signListResult.Active = signList.Active;
signListResult.Type = signList.Type;
signListResult.StartDateTime = signList.StartDateTime;
signListResult.EndDateTime = signList.EndDateTime;
signListResult.ContributionID = signList.ContributionID;
signListResult.MemberGroupID = signList.MemberGroupID;
gameClubEntities.SaveChanges();
EFUserRecord.AddUserOperateRecord("更新签到表ID为" + signList.SignID + "的签到表信息");
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新分组表
/// </summary>
/// <param name="memberGroupList"></param>
/// <param name="memberGroupListViewModel"></param>
/// <returns></returns>
public ActionResult UpdateMemberGroupList(MemberGroupList memberGroupList, MemberGroupListViewModel memberGroupListViewModel)
{
if (ModelState.IsValid)
{
if (EFMemberGroup.UpdateMemberGroupList(memberGroupList))
{
memberGroupListViewModel = UpdateMemberGroupListViewModel(memberGroupListViewModel);
return(PartialView("_MemberGroupList", memberGroupListViewModel));
}
}
return(View(false));
}
/// <summary>
/// 获取某个分组表
/// </summary>
/// <param name="memberGroupList"></param>
/// <param name="memberGroupListViewModel"></param>
/// <returns></returns>
public ActionResult GetMemberGroupList(MemberGroupList memberGroupList, MemberGroupListViewModel memberGroupListViewModel)
{
MemberGroupList memberGroupListResult = EFMemberGroup.MemberGroupList(memberGroupList.MemberGroupID);
memberGroupListViewModel.SignLists = EFSignInfo.signLists.Where(s => s.MemberGroupID == null).OrderByDescending(s => s.SignID).Take(10).ToList();
memberGroupListViewModel.ContributionLists = EFContribution.ContributionLists.Where(c => c.MemberGroupID == null).OrderByDescending(c => c.MemberGroupID).Take(10).ToList();
if (memberGroupListResult != null)
{
memberGroupListViewModel = UpdateMemberGroupListViewModel(memberGroupListViewModel);
memberGroupListViewModel.MemberGroupList = memberGroupListResult;
return(PartialView("_EditMemberGroupList", memberGroupListViewModel));
}
return(View(false));
}
public ActionResult GetAddGameMember(MemberGroupList memberGroupList, MemberGroupViewModel memberGroupViewModel)
{
List <GameMember> gameMembers = new List <GameMember>();
IEnumerable <MemberGroup> memberGroups = EFMemberGroup.MemberGroups.Where(m => m.MemberGroupID == memberGroupList.MemberGroupID);
foreach (var item in EFGameMember.gameMembers.Where(g => g.IsDel != true).ToList())
{
if (memberGroups.Where(m => m.GameID == item.GameID).FirstOrDefault() == null)
{
gameMembers.Add(item);
}
}
memberGroupViewModel.GameMembers = gameMembers;
memberGroupViewModel.MemberGroupList = EFMemberGroup.MemberGroupLists.Where(m => m.MemberGroupID == memberGroupList.MemberGroupID).FirstOrDefault();
return(PartialView("_GameMember", memberGroupViewModel));
}
/// <summary>
/// 更新分组表
/// </summary>
/// <param name="memberGroupList"></param>
/// <returns></returns>
public bool UpdateMemberGroupList(MemberGroupList memberGroupList)
{
if (memberGroupList == null)
{
return(false);
}
MemberGroupList memberGroupListResult = gameClubEntities.MemberGroupList.Where(m => m.MemberGroupID == memberGroupList.MemberGroupID).FirstOrDefault();
SignList signList;
ContributionList contributionList;
if (memberGroupListResult != null)
{
if (!string.IsNullOrEmpty(memberGroupListResult.SignID))
{
signList = gameClubEntities.SignList.Where(s => s.SignID == memberGroupListResult.SignID).FirstOrDefault();
signList.MemberGroupID = null;
memberGroupListResult.SignID = null;
}
if (!string.IsNullOrEmpty(memberGroupListResult.ContributionID))
{
contributionList = gameClubEntities.ContributionList.Where(c => c.ContributionID == memberGroupListResult.ContributionID).FirstOrDefault();
contributionList.MemberGroupID = null;
memberGroupListResult.ContributionID = null;
}
if (!string.IsNullOrEmpty(memberGroupList.SignID))
{
signList = gameClubEntities.SignList.Where(s => s.SignID == memberGroupList.SignID).FirstOrDefault();
signList.MemberGroupID = memberGroupList.MemberGroupID;
}
if (!string.IsNullOrEmpty(memberGroupList.ContributionID))
{
contributionList = gameClubEntities.ContributionList.Where(c => c.ContributionID == memberGroupList.ContributionID).FirstOrDefault();
contributionList.MemberGroupID = memberGroupList.MemberGroupID;
}
memberGroupListResult.Type = memberGroupList.Type;
memberGroupListResult.ContributionID = memberGroupList.ContributionID;
memberGroupListResult.SignID = memberGroupList.SignID;
EFUserRecord.AddUserOperateRecord("更新了ID为" + memberGroupList.MemberGroupID + "的分组表信息");
gameClubEntities.SaveChanges();
return(true);
}
return(false);
}
/// <summary>
/// 添加贡献表
/// </summary>
/// <param name="contributionList"></param>
/// <param name="contributionListViewModel"></param>
/// <returns></returns>
public ActionResult AddContributionList(ContributionList contributionList, ContributionListViewModel contributionListViewModel)
{
if (ModelState.IsValid)
{
if (EFContribution.AddContributionList(contributionList))
{
SignList signList = EFSignInfo.signLists.Where(s => s.SignID == contributionList.SignID).FirstOrDefault();
MemberGroupList memberGroupList = EFMemberGroup.MemberGroupLists.Where(m => m.MemberGroupID == contributionList.MemberGroupID).FirstOrDefault();
if (signList != null && memberGroupList != null)
{
signList.ContributionID = contributionList.ContributionID;
signList.MemberGroupID = contributionList.MemberGroupID;
memberGroupList.ContributionID = contributionList.ContributionID;
memberGroupList.SignID = contributionList.SignID;
}
else if (memberGroupList != null)
{
memberGroupList.ContributionID = contributionList.ContributionID;
}
else if (signList != null)
{
signList.ContributionID = contributionList.ContributionID;
}
EFSignInfo.UpdateSignList(signList);
EFMemberGroup.UpdateMemberGroupList(memberGroupList);
ViewBag.Success = "贡献表添加成功！";
contributionListViewModel = UpdateContributionListViewModel(contributionListViewModel);
}
else
{
ViewBag.Fault = "已存在该表！";
}
}
else
{
ViewBag.Fault = "请检查信息！";
}
if (contributionListViewModel.ContributionListsPageLists == null)
{
contributionListViewModel = UpdateContributionListViewModel(contributionListViewModel);
}
return(PartialView("_ContributionList", contributionListViewModel));
}
public ActionResult Inherit(string MemberGroupID)
{
if (!string.IsNullOrEmpty(MemberGroupID))
{
MemberGroupList memberGroupList = EFMemberGroup.MemberGroupLists.Where(m => m.MemberGroupID == MemberGroupID).FirstOrDefault();
if (memberGroupList != null)
{
MemberGroupList memberGroupListResult = EFMemberGroup.MemberGroupLists.Where(m => m.CreateDateTime < memberGroupList.CreateDateTime && m.Type == memberGroupList.Type).OrderByDescending(m => m.CreateDateTime).FirstOrDefault();
if (memberGroupListResult != null)
{
GameClubEntities gameClubEntities = new GameClubEntities();
IEnumerable <MemberGroup> memberGroupsNew = gameClubEntities.MemberGroup.Where(m => m.MemberGroupID == memberGroupList.MemberGroupID);
IEnumerable <MemberGroup> memberGroupsOld = gameClubEntities.MemberGroup.Where(m => m.MemberGroupID == memberGroupListResult.MemberGroupID);
foreach (var item in memberGroupsNew)
{
MemberGroup memberGroup = memberGroupsOld.Where(m => m.GameID == item.GameID).FirstOrDefault();
if (memberGroup != null)
{
item.GroupName = memberGroup.GroupName;
}
}
gameClubEntities.SaveChanges();
}
MemberGroupViewModel = new MemberGroupViewModel
{
MemberGroupLists = EFMemberGroup.MemberGroupLists.OrderByDescending(m => m.MemberGroupID).Take(10).ToList(),
MemberGroupList = EFMemberGroup.MemberGroupLists.Where(m => m.MemberGroupID == MemberGroupID).FirstOrDefault(),
GameMembers = EFGameMember.gameMembers,
MemberGroups = EFMemberGroup.MemberGroups.Where(m => m.MemberGroupID == MemberGroupID).OrderBy(m => m.GameID).ToList(),
};
return(PartialView("_TabContent", MemberGroupViewModel));
}
}
return(View());
}
/// <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));
}
