/// <summary>
/// 根据查询条件删除违规记录
/// </summary>
/// <param name="begDate">开始日期</param>
/// <param name="endDate">结束日期</param>
/// <param name="roomNo">阅览室编号</param>
/// <returns></returns>
public static int DelBySearch(string begDate, string endDate, string roomNo)
{
IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService();
List <ViolationRecordsLogInfo> vlists = seatService.GetViolationRecordsLogs(null, roomNo, begDate + " 0:00:00", endDate + " 23:59:59", SeatManage.EnumType.LogStatus.Valid, SeatManage.EnumType.LogStatus.None);
bool error = false;
List <int> lst = new List <int>();
try
{
if (vlists.Count > 0)
{
foreach (ViolationRecordsLogInfo vlist in vlists)
{
vlist.Flag = SeatManage.EnumType.LogStatus.Fail;
seatService.UpdateViolationRecordsLog(vlist);
SeatManage.ClassModel.ReaderNoticeInfo rni = new SeatManage.ClassModel.ReaderNoticeInfo();
rni.CardNo = vlist.CardNo;
rni.Note = string.Format("{0}记录的违规，{1}，被管理员手动移除", vlist.EnterOutTime, vlist.Remark);
SeatManage.Bll.T_SM_ReaderNotice.AddReaderNotice(rni);
}
}
return(vlists.Count);
}
catch (Exception ex)
{
error = true;
SeatManageComm.WriteLog.Write("修改违规记录失败：" + ex.Message);
return(-1);
}
finally
{
ICommunicationObject ICommObjectService = seatService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["LoginId"] == null)
{
Response.Redirect("../Login.aspx");
}
if (!IsPostBack)
{
BindReadingRoomList(Session[CookiesManager.LoginID].ToString());
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
cmd = Request.Form["subCmd"];
if (cmd != null)
{
#region 座位相关操作
switch (cmd)
{
case "search": //查询座位
try
{
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
catch
{
}
break;
case "ShortLeave": //设置暂离
try
{
string seatStr = hidSeatNo.Value;
string[] noArr = seatStr.Split(',');
string seatNo = "";
for (int i = 0; i < noArr.Length; i++)
{
seatNo = noArr[i].Trim();
SeatManage.ClassModel.EnterOutLogInfo enterOutLog = SeatManage.Bll.T_SM_EnterOutLog.GetUsingEnterOutLogBySeatNo(seatNo);
if (enterOutLog != null && enterOutLog.EnterOutState != SeatManage.EnumType.EnterOutLogType.ShortLeave)
{
SeatManage.ClassModel.ReadingRoomInfo roomInfo = SeatManage.Bll.T_SM_ReadingRoom.GetSingleRoomInfo(enterOutLog.ReadingRoomNo);
enterOutLog.EnterOutState = SeatManage.EnumType.EnterOutLogType.ShortLeave;
enterOutLog.Flag = SeatManage.EnumType.Operation.Admin;
enterOutLog.Remark = string.Format("在{0}，{1}号座位，被管理员{2}，通过手持设备设置为暂离", roomInfo.Name, enterOutLog.ShortSeatNo, Session["LoginID"].ToString());
int newId = -1;
SeatManage.EnumType.HandleResult result = SeatManage.Bll.EnterOutOperate.AddEnterOutLog(enterOutLog, ref newId);
if (result == SeatManage.EnumType.HandleResult.Successed)
{
Page.RegisterStartupScript("", "<script>alert('设置读者暂离成功');</script>");
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
else
{
Page.RegisterStartupScript("", "<script>alert('设置读者暂离失败');</script>");
}
}
}
}
catch
{
}
break;
case "ReleaseShortLeave": //取消暂离
try
{
string seatStr = hidSeatNo.Value;
string[] noArr = seatStr.Split(',');
string seatNo = "";
for (int i = 0; i < noArr.Length; i++)
{
seatNo = noArr[i].Trim();
SeatManage.ClassModel.EnterOutLogInfo enterOutLog = SeatManage.Bll.T_SM_EnterOutLog.GetUsingEnterOutLogBySeatNo(seatNo);
if (enterOutLog != null && enterOutLog.EnterOutState == SeatManage.EnumType.EnterOutLogType.ShortLeave)
{
SeatManage.ClassModel.ReadingRoomInfo roomInfo = SeatManage.Bll.T_SM_ReadingRoom.GetSingleRoomInfo(enterOutLog.ReadingRoomNo);
enterOutLog.EnterOutState = SeatManage.EnumType.EnterOutLogType.ComeBack;
enterOutLog.Flag = SeatManage.EnumType.Operation.Admin;
enterOutLog.Remark = string.Format("在{0}，{1}号座位，被管理员{2}，通过手持设备取消暂离，恢复为在座", roomInfo.Name, enterOutLog.ShortSeatNo, Session["LoginID"].ToString());
int newId = -1;
SeatManage.EnumType.HandleResult result = SeatManage.Bll.EnterOutOperate.AddEnterOutLog(enterOutLog, ref newId);
if (result == SeatManage.EnumType.HandleResult.Successed)
{
List <SeatManage.ClassModel.WaitSeatLogInfo> waitSeatLogs = SeatManage.Bll.T_SM_SeatWaiting.GetWaitSeatList("", enterOutLog.EnterOutLogID, null, null, null);
SeatManage.ClassModel.WaitSeatLogInfo waitSeatLog = null;
if (waitSeatLogs.Count > 0)
{
waitSeatLog = waitSeatLogs[0];
waitSeatLog.NowState = SeatManage.EnumType.LogStatus.Fail;
waitSeatLog.OperateType = SeatManage.EnumType.Operation.OtherReader;
waitSeatLog.WaitingState = SeatManage.EnumType.EnterOutLogType.WaitingCancel;
if (SeatManage.Bll.T_SM_SeatWaiting.UpdateWaitLog(waitSeatLog))
{
Page.RegisterStartupScript("", "<script>alert('取消读者暂离成功');</script>");
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
else
{
Page.RegisterStartupScript("", "<script>alert('取消读者暂离成功，取消读者等待失败');</script>");
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
}
else
{
Page.RegisterStartupScript("", "<script>alert('取消读者暂离成功');</script>");
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
}
else
{
Page.RegisterStartupScript("", "<script>alert('取消读者暂离失败');</script>");
}
}
}
}
catch
{
}
break;
case "Release": //释放座位
try
{
string seatStr = hidSeatNo.Value;
string[] noArr = seatStr.Split(',');
string seatNo = "";
for (int i = 0; i < noArr.Length; i++)
{
seatNo = noArr[i].Trim();
SeatManage.ClassModel.EnterOutLogInfo enterOutLog = SeatManage.Bll.T_SM_EnterOutLog.GetUsingEnterOutLogBySeatNo(seatNo);
if (enterOutLog != null && enterOutLog.EnterOutState != SeatManage.EnumType.EnterOutLogType.Leave)
{
SeatManage.ClassModel.ReadingRoomInfo roomInfo = SeatManage.Bll.T_SM_ReadingRoom.GetSingleRoomInfo(enterOutLog.ReadingRoomNo);
enterOutLog.EnterOutState = SeatManage.EnumType.EnterOutLogType.Leave;
enterOutLog.Flag = SeatManage.EnumType.Operation.Admin;
enterOutLog.Remark = string.Format("在{0}，{1}号座位，被管理员{2}，通过手持设备设置离开", roomInfo.Name, enterOutLog.ShortSeatNo, Session["LoginID"].ToString());
int newId = -1;
SeatManage.EnumType.HandleResult result = SeatManage.Bll.EnterOutOperate.AddEnterOutLog(enterOutLog, ref newId);
if (result == SeatManage.EnumType.HandleResult.Successed)
{
SeatManage.ClassModel.RegulationRulesSetting rulesSet = SeatManage.Bll.T_SM_SystemSet.GetRegulationRulesSetting();
if (roomInfo.Setting.IsRecordViolate)
{
if (roomInfo.Setting.BlackListSetting.Used)
{
if (roomInfo.Setting.BlackListSetting.ViolateRoule[SeatManage.EnumType.ViolationRecordsType.LeaveByAdmin])
{
SeatManage.ClassModel.ViolationRecordsLogInfo violationRecords = new SeatManage.ClassModel.ViolationRecordsLogInfo();
violationRecords.CardNo = enterOutLog.CardNo;
violationRecords.SeatID = enterOutLog.SeatNo.Substring(enterOutLog.SeatNo.Length - roomInfo.Setting.SeatNumAmount, roomInfo.Setting.SeatNumAmount);
violationRecords.ReadingRoomID = enterOutLog.ReadingRoomNo;
violationRecords.EnterOutTime = SeatManage.Bll.ServiceDateTime.Now.ToString();
violationRecords.EnterFlag = SeatManage.EnumType.ViolationRecordsType.LeaveByAdmin;
violationRecords.Remark = string.Format("在{0}，{1}号座位，被管理员{2}，通过手持设备设置离开", roomInfo.Name, enterOutLog.ShortSeatNo, Session["LoginID"].ToString());
violationRecords.BlacklistID = "-1";
SeatManage.Bll.T_SM_ViolateDiscipline.AddViolationRecords(violationRecords);
}
}
else if (rulesSet.BlacklistSet.Used && rulesSet.BlacklistSet.ViolateRoule[SeatManage.EnumType.ViolationRecordsType.LeaveByAdmin])
{
SeatManage.ClassModel.ViolationRecordsLogInfo violationRecords = new SeatManage.ClassModel.ViolationRecordsLogInfo();
violationRecords.CardNo = enterOutLog.CardNo;
violationRecords.SeatID = enterOutLog.SeatNo.Substring(enterOutLog.SeatNo.Length - roomInfo.Setting.SeatNumAmount, roomInfo.Setting.SeatNumAmount);
violationRecords.ReadingRoomID = enterOutLog.ReadingRoomNo;
violationRecords.EnterOutTime = SeatManage.Bll.ServiceDateTime.Now.ToString();
violationRecords.EnterFlag = SeatManage.EnumType.ViolationRecordsType.LeaveByAdmin;
violationRecords.Remark = string.Format("在{0}，{1}号座位，被管理员{2}，通过手持设备设置离开", roomInfo.Name, enterOutLog.ShortSeatNo, Session["LoginID"].ToString());
violationRecords.BlacklistID = "-1";
SeatManage.Bll.T_SM_ViolateDiscipline.AddViolationRecords(violationRecords);
}
}
Page.RegisterStartupScript("", "<script>alert('设置读者离开成功');</script>");
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
else
{
Page.RegisterStartupScript("", "<script>alert('设置读者离开失败');</script>");
}
}
}
}
catch
{
}
break;
case "onTime": //计时
try
{
string seatStr = hidSeatNo.Value;
string[] noArr = seatStr.Split(',');
string seatNo = "";
for (int i = 0; i < noArr.Length; i++)
{
seatNo = noArr[i].Trim();
SeatManage.ClassModel.EnterOutLogInfo enterOutLog = SeatManage.Bll.T_SM_EnterOutLog.GetUsingEnterOutLogBySeatNo(seatNo);
if (enterOutLog != null && enterOutLog.EnterOutState != SeatManage.EnumType.EnterOutLogType.ShortLeave)
{
DateTime markTime = SeatManage.Bll.ServiceDateTime.Now;
SeatManage.Bll.EnterOutOperate.UpdateMarkTime(enterOutLog.EnterOutLogID, markTime);
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
}
}
catch
{
}
break;
case "offTime": //取消计时
try
{
string seatStr = hidSeatNo.Value;
string[] noArr = seatStr.Split(',');
string seatNo = "";
for (int i = 0; i < noArr.Length; i++)
{
seatNo = noArr[i].Trim();
SeatManage.ClassModel.EnterOutLogInfo enterOutLog = SeatManage.Bll.T_SM_EnterOutLog.GetUsingEnterOutLogBySeatNo(seatNo);
if (enterOutLog != null && !string.IsNullOrEmpty(enterOutLog.MarkTime.ToString()) && enterOutLog.MarkTime.CompareTo(DateTime.Parse("1900/1/1")) != 0)
{
DateTime markTime = DateTime.Parse("1900-1-1");
SeatManage.Bll.EnterOutOperate.UpdateMarkTime(enterOutLog.EnterOutLogID, markTime);
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
}
}
catch
{
}
break;
case "AddBlacklist":
try
{
string seatStr = hidSeatNo.Value;
string[] noArr = seatStr.Split(',');
string seatNo = "";
int newId = -1;
SeatManage.ClassModel.RegulationRulesSetting rulesSet = SeatManage.Bll.T_SM_SystemSet.GetRegulationRulesSetting();
for (int i = 0; i < noArr.Length; i++)
{
newId = -1;
seatNo = noArr[i].Trim();
SeatManage.ClassModel.EnterOutLogInfo enterOutLog = SeatManage.Bll.T_SM_EnterOutLog.GetUsingEnterOutLogBySeatNo(seatNo);
if (enterOutLog != null && enterOutLog.EnterOutState != SeatManage.EnumType.EnterOutLogType.Leave)
{
SeatManage.ClassModel.ReadingRoomInfo roomInfo = SeatManage.Bll.T_SM_ReadingRoom.GetSingleRoomInfo(enterOutLog.ReadingRoomNo);
if (roomInfo != null && roomInfo.Setting.BlackListSetting.Used)
{
SeatManage.ClassModel.BlackListInfo blacklistModel = new SeatManage.ClassModel.BlackListInfo();
blacklistModel.AddTime = SeatManage.Bll.ServiceDateTime.Now;
blacklistModel.ReadingRoomID = roomInfo.No;
blacklistModel.BlacklistState = SeatManage.EnumType.LogStatus.Valid;
blacklistModel.CardNo = enterOutLog.CardNo;
blacklistModel.OutBlacklistMode = roomInfo.Setting.BlackListSetting.LeaveBlacklist;
if (blacklistModel.OutBlacklistMode == SeatManage.EnumType.LeaveBlacklistMode.AutomaticMode)
{
blacklistModel.ReMark = string.Format("管理员{0}通过手持设备{0}把读者加入黑名单，记录黑名单{1}天", Session["LoginID"].ToString(), roomInfo.Setting.BlackListSetting.LimitDays);
blacklistModel.OutTime = blacklistModel.AddTime.AddDays(roomInfo.Setting.BlackListSetting.LimitDays);
}
else
{
blacklistModel.ReMark = string.Format("管理员{0}通过手持设备把读者加入黑名单，手动离开黑名单", Session["LoginID"].ToString());
}
blacklistModel.ReadingRoomID = roomInfo.No;
newId = SeatManage.Bll.T_SM_Blacklist.AddBlackList(blacklistModel);
SeatManage.ClassModel.ReaderNoticeInfo blackRni = new SeatManage.ClassModel.ReaderNoticeInfo();
blackRni.IsRead = SeatManage.EnumType.LogStatus.Valid;
blackRni.CardNo = enterOutLog.CardNo;
blackRni.Note = string.Format("{0}", blacklistModel.ReMark);
SeatManage.Bll.T_SM_ReaderNotice.AddReaderNotice(blackRni);
}
else if (rulesSet.BlacklistSet.Used)
{
SeatManage.ClassModel.BlackListInfo blacklistModel = new SeatManage.ClassModel.BlackListInfo();
blacklistModel.AddTime = SeatManage.Bll.ServiceDateTime.Now;
blacklistModel.OutTime = blacklistModel.AddTime.AddDays(rulesSet.BlacklistSet.LimitDays);
blacklistModel.BlacklistState = SeatManage.EnumType.LogStatus.Valid;
blacklistModel.CardNo = enterOutLog.CardNo;
blacklistModel.OutBlacklistMode = rulesSet.BlacklistSet.LeaveBlacklist;
if (blacklistModel.OutBlacklistMode == SeatManage.EnumType.LeaveBlacklistMode.AutomaticMode)
{
blacklistModel.ReMark = string.Format("管理员{0}通过手持设备把读者加入黑名单，记录黑名单{1}天", Session["LoginID"].ToString(), rulesSet.BlacklistSet.LimitDays);
blacklistModel.OutTime = blacklistModel.AddTime.AddDays(rulesSet.BlacklistSet.LimitDays);
}
else
{
blacklistModel.ReMark = string.Format("管理员{0}通过手持设备把读者加入黑名单，手动离开黑名单", Session["LoginID"].ToString());
}
blacklistModel.ReadingRoomID = roomInfo.No;
newId = SeatManage.Bll.T_SM_Blacklist.AddBlackList(blacklistModel);
SeatManage.ClassModel.ReaderNoticeInfo blackRni = new SeatManage.ClassModel.ReaderNoticeInfo();
blackRni.IsRead = SeatManage.EnumType.LogStatus.Valid;
blackRni.CardNo = enterOutLog.CardNo;
blackRni.Note = string.Format("{0}", blacklistModel.ReMark);
SeatManage.Bll.T_SM_ReaderNotice.AddReaderNotice(blackRni);
}
else
{
Page.RegisterStartupScript("", "<script>alert('对不起，此阅览室以及图书馆没有启用黑名单功能');</script>");
return;
}
if (newId > 0)
{
enterOutLog.EnterOutState = SeatManage.EnumType.EnterOutLogType.Leave;
enterOutLog.Flag = SeatManage.EnumType.Operation.Admin;
enterOutLog.Remark = string.Format("在{0}，{1}号座位，被管理员{2}，通过手持设备设置离开", roomInfo.Name, enterOutLog.ShortSeatNo, Session["LoginID"].ToString());
SeatManage.EnumType.HandleResult result = SeatManage.Bll.EnterOutOperate.AddEnterOutLog(enterOutLog, ref newId);
if (result == SeatManage.EnumType.HandleResult.Successed)
{
Page.RegisterStartupScript("", "<script>alert('设置读者黑名单成功');</script>");
GetSeatList(selectReadingRomm.Items[selectReadingRomm.SelectedIndex].Value, selectSeatState.Items[selectSeatState.SelectedIndex].Value);
}
else
{
Page.RegisterStartupScript("", "<script>alert('设置读者黑名单失败');</script>");
}
}
else
{
}
}
}
}
catch
{
}
break;
case "LoginOut":
HttpCookie aCookie;
string cookieName;
int limit = Request.Cookies.Count;
for (int i = 0; i < limit; i++)
{
cookieName = Request.Cookies[i].Name;
aCookie = new HttpCookie(cookieName);
aCookie.Expires = DateTime.Now.AddDays(-1);
Response.Cookies.Add(aCookie);
}
Response.Redirect("../Login.aspx");
break;
}
#endregion
}
}