/// <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>
/// <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>
/// <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="signList"></param>
/// <returns>true增加成功，false已存在该签到表</returns>
public bool AddSignList(SignList signList)
{
SignList signListResult = gameClubEntities.SignList.Where(s => s.SignID == signList.SignID).FirstOrDefault();
if (signListResult == null)
{
gameClubEntities.SaveChanges();
gameClubEntities.SignList.Add(signList);
gameClubEntities.SaveChanges();
foreach (var item in gameClubEntities.GameMember.Where(g => g.IsDel != true))
{
SignInfo signInfo = new SignInfo
{
SignID = signList.SignID,
GameID = item.GameID,
SignCondition = "未签到",
VoiceCondition = "未语音",
IsLeave = false,
};
gameClubEntities.SignInfo.Add(signInfo);
}
gameClubEntities.SaveChanges();
EFUserRecord.AddUserOperateRecord("添加签到表ID为" + signList.SignID + "的签到表信息");
return(true);
}
else
{
return(false);
}
}
// 接收到新的数据包时处理
private void device_OnPacketArrival(object sender, CaptureEventArgs e)
{
MacAddress MacProc = new MacAddress();
var time = e.Packet.Timeval.Date;
var len = e.Packet.Data.Length;
string macaddr = MacProc.GetWlanSa(e); // 获取设备的 MAC 地址，如果是 AP 则返回 Null
if (macaddr != null && SignList.InvokeRequired)
{
SignList.Invoke(new MethodInvoker(delegate
{
ListViewItem item = SignList.FindItemWithText(macaddr);
string now = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString();
// 从 SQL 查询保存的名字
string name = DataBase.QueryOnce(Config.DbFile, $"SELECT name FROM Users WHERE macaddr='{macaddr}'", 0);
if (name == string.Empty)
{
if (HideNonameDevice.Checked == true)
{
return; // 如果隐藏未登记设备勾选则直接跳过
}
name = Config.NoName;
}
if (item == null) // 设备是否曾经存在，否创建
{
ListViewItem SignCol = new ListViewItem();
SignCol.Text = name;
SignCol.SubItems.Add(macaddr);
SignCol.SubItems.Add(now);
SignCol.SubItems.Add("当前在线");
SignCol.SubItems.Add(now);
SignList.Items.Add(SignCol);
if (NotifyWhenLogon.Checked)
{
new View.NotifyBox($"{name} 签到", $"{macaddr}", 3000, PlaySoundOnNotify.Checked).Show(); // 首次签到发送通知
}
}
else // 是，更新最后出现时间
{
if (item.SubItems[3].Text != "当前在线")
{
item.SubItems[3].Text = "当前在线";
if (NotifyWhenLogon.Checked)
{
new View.NotifyBox($"{name} 回来了", $"{macaddr}", 3000, PlaySoundOnNotify.Checked).Show(); // 只有之前离线再恢复才提醒
}
}
item.Text = name;
item.SubItems[4].Text = now;
}
}));
}
}
/// <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);
}
}
public ActionResult GetAddGameMember(SignList signList, SignInfoViewModel signInfoViewModel)
{
List <GameMember> gameMembers = new List <GameMember>();
IEnumerable <SignInfo> signInfos = EFSignInfo.signInfos.Where(s => s.SignID == signList.SignID);
foreach (var item in EFGameMember.gameMembers.Where(g => g.IsDel != true).ToList())
{
if (signInfos.Where(s => s.GameID == item.GameID).FirstOrDefault() == null)
{
gameMembers.Add(item);
}
}
signInfoViewModel.GameMembers = gameMembers;
return(PartialView("_GameMember", signInfoViewModel));
}
/// <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));
}
}
private void button2_Click(object sender, EventArgs e)
{
ListViewItem item = SignList.FindItemWithText(textBox1.Text);
if (item == null)
{
MessageBox.Show("无匹配记录", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
item.Selected = true;
item.Focused = true;
SignList.Select();
SignList.TopItem = item;
System.Media.SystemSounds.Asterisk.Play();
}
}
/// <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));
}
/// <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));
}
}
public bool ActiveDisableList(List <string> ListID)
{
bool f = true;
foreach (var item in ListID)
{
SignList signList = gameClubEntities.SignList.Where(s => s.SignID == item).FirstOrDefault();
if (signList != null)
{
signList.Active = false;
gameClubEntities.SaveChanges();
}
else
{
f = false;
}
EFUserRecord.AddUserOperateRecord("禁用签到表ID为" + signList.SignID + "的签到表");
}
return(f);
}
public bool DelSignList(List <string> ListID)
{
bool f = true;
foreach (var item in ListID)
{
SignList signList = gameClubEntities.SignList.Where(s => s.SignID == item).FirstOrDefault();
if (signList != null)
{
if (DelSignList(signList) == false)
{
f = false;
}
}
else
{
f = false;
}
}
return(f);
}
/**
* <h1>获取签名API</h1>
*
* <p>
* 参数名 类型 是否必须 描述 示例
* </p>
* <p>
* apikey String 是 用户唯一标识 9b11127a9701975c734b8aee81ee3526
* </p>
* <p>
* id Long 否 签名id，暂未开放，如果传入此参数将会指定获取某个签名 9527
* </p>
* <p>
* sign String 否 签名内容 云片网
* </p>
* <p>
* page_num Integer 否 页码，1开始，不带或者格式错误返回全部 1
* </p>
* <p>
* page_size Integer 否 返回条数，必须大于0，不带或者格式错误返回全部 20
* </p>
*
* @param param
* sign notify page_num page_size
* @return
*/
public Result <SignList> Get(Dictionary <string, string> param)
{
var r = new Result <SignList>();
r = CheckParam(ref param, r, Const.Apikey);
if (!r.IsSucc())
{
return(r);
}
var data = UrlEncode(ref param);
var h = new MapResultHandler <SignList>(Version, rsp =>
{
var list = new SignList();
switch (Version)
{
case Const.VersionV2:
{
list.Total = rsp[Const.Total].ToObject <int>();
list.Sign = rsp[Const.Sign].ToObject <List <Sign> >();
return(list);
}
default: return(null);
}
});
try
{
Path = "get.json";
return(Post(ref data, h, r));
}
catch (Exception e)
{
return(h.CatchExceptoin(e, r));
}
}
/// <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));
}
