private void EnterOutLogListBinding()
{
string roomNum = ddlReadingRoom.SelectedItem.Value;
DateTime startDate = dpStartDate.SelectedDate.Value;
if (startDate.Date < SeatManage.Bll.ServiceDateTime.Now.AddDays(-30).Date)
{
FineUI.Alert.Show("最多可以查询30天前的数据");
return;
}// DateTime.Parse(string.Format("{0} {1}", dpStartDate.Text, " 0:00:00"));
DateTime endDate = dpEndDate.SelectedDate.Value; //DateTime.Parse(string.Format("{0} {1}", dpEndDate.Text, " 23:59:59"));
EnumEnterOutLogQueryMethod method = EnumEnterOutLogQueryMethod.CardNo;
DataTable dt = null;
dt = LogQueryHelper.GetEnterOutLogDataSet(this.LoginId, roomNum, method, startDate, endDate.AddHours(23).AddMinutes(59));
if (dt != null)
{
string sortField = EnterOutGrid.Columns[EnterOutGrid.SortColumnIndex].SortField;
string sortDirection = EnterOutGrid.SortDirection;
DataView TableView = dt.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
EnterOutGrid.DataSource = TableView;
EnterOutGrid.DataBind();
}
else
{
FineUI.Alert.Show("没有查询到信息");
}
}
public string GetBespeakData()
{
string result = "";
StringBuilder sb = new StringBuilder();
string cardNo = Request["txtNum"].ToString().Trim();
string roomNum = Request.Params["selectRooms"] == null ? "" : Request.Params["selectRooms"]; //ddlReadingRoom.SelectedItem.Value;
BookingStatus status = Request.Params["selectBespeakState"] == null? BookingStatus.None : (BookingStatus)int.Parse(Request.Params["selectBespeakState"].ToString());
DateTime startDate = DateTime.Parse(Request.Params["beginDate"].ToString());
DateTime endDate = DateTime.Parse(Request.Params["endDate"].ToString());
List <BookingStatus> statusList = new List <BookingStatus>();
if (status == BookingStatus.None)
{
statusList.Add(BookingStatus.Cencaled);
statusList.Add(BookingStatus.Confinmed);
statusList.Add(BookingStatus.Waiting);
}
else
{
statusList.Add(status);
}
DataTable dt = new DataTable();
//if (chkSearchMH.Checked == false)
if (Request.Params["chkSearchMH"] == null)
{
dt = LogQueryHelper.BespeakLogQuery(cardNo, roomNum, statusList, startDate, endDate.AddHours(23).AddMinutes(59));
}
else
{
dt = LogQueryHelper.BespeakLogQuery_ByFuzzySearch(cardNo, roomNum, statusList, startDate, endDate.AddHours(23).AddMinutes(59));
}
if (dt != null)
{
sb.Append("{");
sb.Append("\"form.paginate.pageNo\": 1,");
sb.Append("\"form.paginate.totalRows\": 100,");
sb.Append(" \"rows\": [");
foreach (DataRow r in dt.Rows)
{
sb.Append("{\"BespeakID\": '" + r["BespeakID"] + "',\"CardNo\": '" + r["CardNo"] + "',\"ReaderName\": \"" + r["ReaderName"] + "\",\"ReadingRoomName\": \"" + r["ReadingRoomName"] + "\",\"SeatNum\": \"" + r["SeatNum"] + "\",\"BsepeakState\": \"" + r["BsepeakState"] + "\",\"SubmitTime\": \"" + r["SubmitTime"] + "\",\"BespeakTime\": \"" + r["BespeakTime"] + "\",\"CancelTime\": \"" + r["CancelTime"] + "\",\"Remark\": \"" + r["Remark"] + "\"}");
sb.Append(",");
}
if (dt.Rows.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
sb.Append("}");
result = sb.ToString();
}
else
{
result = "没有查询到信息";
}
return(result);
}
/// <summary>
///
/// </summary>
void BindingGrid()
{
DataTable dt = LogQueryHelper.GetMonitorGraphReadingRoomList(this.LoginId);
string sortField = gridRoomList.Columns[gridRoomList.SortColumnIndex].SortField;
string sortDirection = gridRoomList.SortDirection;
DataView TableView = dt.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
gridRoomList.DataSource = TableView;
gridRoomList.DataBind();
}
private void GridBinding()
{
DataTable dt = LogQueryHelper.UsingSeatReader(roomId);
string sortField = gridReaderList.Columns[gridReaderList.SortColumnIndex].SortField;
string sortDirection = gridReaderList.SortDirection;
DataView TableView = dt.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
gridReaderList.DataSource = TableView;
gridReaderList.DataBind();
}
void BindingGrid()
{
string libno = ddlLibrary.SelectedValue;
DataTable dt = LogQueryHelper.NowDayBespeakRoomInfo(libno);
string sortField = gridRoomList.Columns[gridRoomList.SortColumnIndex].SortField;
string sortDirection = gridRoomList.SortDirection;
DataView TableView = dt.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
gridRoomList.DataSource = TableView;
gridRoomList.DataBind();
}
public string GetGridString(string beginDateString, string endDateString, string statusString)
{
string cardNo = this.LoginId;
if (string.IsNullOrEmpty(cardNo))
{
cardNo = this.LoginId;
}
BookingStatus status = BookingStatus.None;
if (statusString != null)
{
status = (BookingStatus)int.Parse(statusString);
}
DateTime startDate = string.IsNullOrEmpty(beginDateString) ? DateTime.Now.Date : DateTime.Parse(beginDateString);
DateTime endDate = string.IsNullOrEmpty(endDateString) ? DateTime.Now.AddDays(7).Date : DateTime.Parse(endDateString);//dpEndDate.SelectedDate.Value;
List <BookingStatus> statusList = new List <BookingStatus>();
if (status == BookingStatus.None)
{
statusList.Add(BookingStatus.Cencaled);
statusList.Add(BookingStatus.Confinmed);
statusList.Add(BookingStatus.Waiting);
}
else
{
statusList.Add(status);
}
DataTable dt = LogQueryHelper.BespeakLogQuery(cardNo, null, statusList, startDate, endDate.AddHours(23).AddMinutes(59));
StringBuilder sb = new StringBuilder();
sb.Append("{");
sb.Append("\"form.paginate.pageNo\": 1,");
sb.Append("\"form.paginate.totalRows\": 100,");
sb.Append(" \"rows\": [");
foreach (DataRow r in dt.Rows)
{
sb.Append("{\"BespeakID\": '" + r["BespeakID"] + "',\"ReadingRoomName\": '" + r["ReadingRoomName"] + "',\"SeatNum\": \"" + r["SeatNum"] + "\",\"BsepeakState\": \"" + r["BsepeakState"] + "\",\"SubmitTime\": \"" + r["SubmitTime"] + "\",\"BespeakTime\": \"" + r["BespeakTime"] + "\",\"CancelTime\": \"" + r["CancelTime"] + "\",\"Remark\": \"" + r["Remark"] + "\"}");
sb.Append(",");
}
if (dt.Rows.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
sb.Append("}");
return(sb.ToString());
}
private void EnterOutLogListBinding()
{
string num = txtNum.Text;
string roomNum = ddlReadingRoom.SelectedItem.Value;
DateTime startDate = dpStartDate.SelectedDate.Value;
if (startDate.Date < SeatManage.Bll.ServiceDateTime.Now.AddDays(-30).Date)
{
FineUI.Alert.Show("最多可以查询30天前的数据");
return;
}// DateTime.Parse(string.Format("{0} {1}", dpStartDate.Text, " 0:00:00"));
DateTime endDate = dpEndDate.SelectedDate.Value; //DateTime.Parse(string.Format("{0} {1}", dpEndDate.Text, " 23:59:59"));
EnumEnterOutLogQueryMethod method = EnumEnterOutLogQueryMethod.None;
DataTable dt = null;
if (ddlQueryMethod.SelectedValue == "cardNo")
{
method = EnumEnterOutLogQueryMethod.CardNo;
}
else if (ddlQueryMethod.SelectedValue == "seatNum")
{
method = EnumEnterOutLogQueryMethod.SeatNum;
}
if (chkSearchMH.Checked == false)
{
dt = LogQueryHelper.GetEnterOutLogDataSet(num, roomNum, method, startDate, endDate.AddHours(23).AddMinutes(59));
}
else
{
dt = LogQueryHelper.GetEnterOutLogDataSet_ByFuzzySearch(num, roomNum, method, startDate, endDate.AddHours(23).AddMinutes(59));
}
if (dt != null)
{
string sortField = enterOutLogList.Columns[enterOutLogList.SortColumnIndex].SortField;
string sortDirection = enterOutLogList.SortDirection;
DataView TableView = dt.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
enterOutLogList.DataSource = TableView;
enterOutLogList.DataBind();
}
else
{
FineUI.Alert.Show("没有查询到信息");
}
}
private void GridBindDate()
{
string cardNo = txtCardNo.Text;
string roomNum = ddlReadingRoom.SelectedItem.Value;
BookingStatus status = (BookingStatus)int.Parse(ddlBespeakState.SelectedItem.Value);
DateTime startDate = dpStartDate.SelectedDate.Value;
DateTime endDate = dpEndDate.SelectedDate.Value;
List <BookingStatus> statusList = new List <BookingStatus>();
if (status == BookingStatus.None)
{
statusList.Add(BookingStatus.Cencaled);
statusList.Add(BookingStatus.Confinmed);
statusList.Add(BookingStatus.Waiting);
}
else
{
statusList.Add(status);
}
DataTable dt = new DataTable();
if (chkSearchMH.Checked == false)
{
dt = LogQueryHelper.BespeakLogQuery(cardNo, roomNum, statusList, startDate, endDate.AddHours(23).AddMinutes(59));
}
else
{
dt = LogQueryHelper.BespeakLogQuery_ByFuzzySearch(cardNo, roomNum, statusList, startDate, endDate.AddHours(23).AddMinutes(59));
}
string sortField = gridBespeakLog.Columns[gridBespeakLog.SortColumnIndex].SortField;
string sortDirection = gridBespeakLog.SortDirection;
DataView TableView = dt.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
gridBespeakLog.DataSource = TableView;
gridBespeakLog.DataBind();
}
private void GridBindDate()
{
string cardNo = this.LoginId;
if (string.IsNullOrEmpty(cardNo))
{
cardNo = this.LoginId;
}
BookingStatus status = BookingStatus.None;
if (ddlBespeakState.SelectedItem != null)
{
status = (BookingStatus)int.Parse(ddlBespeakState.SelectedItem.Value);
}
DateTime startDate = dpStartDate.SelectedDate.Value;
DateTime endDate = dpEndDate.SelectedDate.Value;
List <BookingStatus> statusList = new List <BookingStatus>();
if (status == BookingStatus.None)
{
statusList.Add(BookingStatus.Cencaled);
statusList.Add(BookingStatus.Confinmed);
statusList.Add(BookingStatus.Waiting);
}
else
{
statusList.Add(status);
}
DataTable dt = LogQueryHelper.BespeakLogQuery(cardNo, null, statusList, startDate, endDate.AddHours(23).AddMinutes(59));
string sortField = gridBespeakLog.Columns[gridBespeakLog.SortColumnIndex].SortField;
string sortDirection = gridBespeakLog.SortDirection;
DataView TableView = dt.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
gridBespeakLog.DataSource = TableView;
gridBespeakLog.DataBind();
}
public ActionResult SelectNoticeLog()
{
DataTable dt = LogQueryHelper.ReaderNoticeList(this.LoginId);
StringBuilder sb = new StringBuilder();
sb.Append("{");
sb.Append("\"form.paginate.pageNo\": 1,");
sb.Append("\"form.paginate.totalRows\": 100,");
sb.Append(" \"rows\": [");
foreach (DataRow r in dt.Rows)
{
sb.Append("{\"NoticeId\": '" + r["NoticeId"] + "',\"AddTime\": '" + r["AddTime"] + "',\"NoticeContent\": \"" + r["NoticeContent"] + "\"}");
sb.Append(",");
}
if (dt.Rows.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
sb.Append("}");
ViewBag.Data = sb.ToString();
return(View());
}
/// <summary>
/// 进出记录查询
/// </summary>
/// <param name="beginDateString"></param>
/// <param name="endDateString"></param>
/// <param name="roomNo"></param>
/// <returns></returns>
public string GetEnterOutGridString(string beginDateString, string endDateString, string roomNo)
{
DateTime serviceDate = SeatManage.Bll.ServiceDateTime.Now;
string cardNo = this.LoginId;
DateTime startDate = string.IsNullOrEmpty(beginDateString) ? DateTime.Now.AddDays(-7).Date : DateTime.Parse(beginDateString);
StringBuilder sb = new StringBuilder();
if (startDate.Date < SeatManage.Bll.ServiceDateTime.Now.AddDays(-30).Date)
{
return("-1");
}
else
{
DateTime endDate = string.IsNullOrEmpty(endDateString) ? DateTime.Now.Date : DateTime.Parse(endDateString); //DateTime.Parse(string.Format("{0} {1}", dpEndDate.Text, " 23:59:59"));
EnumEnterOutLogQueryMethod method = EnumEnterOutLogQueryMethod.CardNo;
DataTable dt = null;
dt = LogQueryHelper.GetEnterOutLogDataSet(this.LoginId, roomNo, method, startDate, endDate.AddHours(23).AddMinutes(59));
sb.Append("{");
sb.Append("\"form.paginate.pageNo\": 1,");
sb.Append("\"form.paginate.totalRows\": 100,");
sb.Append(" \"rows\": [");
foreach (DataRow r in dt.Rows)
{
sb.Append("{\"ReadingRoomName\": '" + r["ReadingRoomName"] + "',\"SeatShortNum\": '" + r["SeatShortNum"] + "',\"Status\": \"" + r["Status"] + "\",\"EnterOutTime\": \"" + r["EnterOutTime"] + "\",\"Remark\": \"" + r["Remark"] + "\"}");
sb.Append(",");
}
if (dt.Rows.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
sb.Append("}");
}
return(sb.ToString());
}
/// <summary>
/// 主页列表
/// </summary>
/// <returns></returns>
private string MonitorGraphModeDataBind()
{
string result = "";
DataTable dt = LogQueryHelper.GetMonitorGraphReadingRoomList(this.LoginId);
StringBuilder sb = new StringBuilder();
sb.Append("{");
sb.Append("\"form.paginate.pageNo\": 1,");
sb.Append("\"form.paginate.totalRows\": 100,");
sb.Append(" \"rows\": [");
foreach (DataRow item in dt.Rows)
{
sb.Append("{\"roomNum\": \"" + item["roomNum"].ToString() + "\",\"roomName\": \"" + item["roomName"] + "\",\"libraryName\": \"" + item["libraryName"] + "\",\"seatCountAll\": \"" + item["seatCountAll"] + "\",\"seatCountUsed\": \"" + item["seatCountUsed"] + "\",\"seatCountShortLeave\": \"" + item["seatCountShortLeave"] + "\"}");
sb.Append(",");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("]");
sb.Append("}");
string data = sb.ToString();
ViewBag.Data = data;
return(result);
}
/// <summary>
/// 在座读者列表
/// </summary>
/// <param name="roomId"></param>
/// <returns></returns>
public ViewResult MonitorListMode(string roomId)
{
DataTable dt = LogQueryHelper.UsingSeatReader(roomId);
StringBuilder sb = new StringBuilder();
sb.Append("{");
sb.Append("\"form.paginate.pageNo\": 1,");
sb.Append("\"form.paginate.totalRows\": 100,");
sb.Append(" \"rows\": [");
foreach (DataRow item in dt.Rows)
{
sb.Append("{\"CardNo\": \"" + item["CardNo"] + "\",\"ReaderName\": \"" + item["ReaderName"] + "\",\"ReadingRoomName\": \"" + item["ReadingRoomName"] + "\",\"SeatShortNum\": \"" + item["SeatShortNum"] + "\",\"Status\": \"" + item["Status"] + "\",\"EnterOutTime\": \"" + item["EnterOutTime"] + "\",\"Remark\": \"" + item["Remark"] + "\"}");
sb.Append(",");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("]");
sb.Append("}");
string data = sb.ToString();
ViewBag.roomId = roomId;
ViewBag.Data = data;
return(View());
}
public string GetEnterOutData()
{
string result = "";
string chkSearchMH = Request.Params["chkSearchMH"] == null ? string.Empty : Request.Params["chkSearchMH"];
string num = Request.Params["txtNum"].Trim();
string roomNum = Request.Params["selectRooms"].Trim();
DateTime startDate = DateTime.Parse(Request.Params["beginDate"].Trim());
StringBuilder sb = new StringBuilder();
if (startDate.Date < SeatManage.Bll.ServiceDateTime.Now.AddDays(-30).Date)
{
result = "最多可以查询30天前的数据";
}
else
{
DateTime endDate = DateTime.Parse(Request.Params["endDate"].Trim());
EnumEnterOutLogQueryMethod method = EnumEnterOutLogQueryMethod.None;
DataTable dt = null;
if (Request.Params["selectCardNoOrSeatNo"] == "cardNo")
{
method = EnumEnterOutLogQueryMethod.CardNo;
}
else if (Request.Params["selectCardNoOrSeatNo"] == "seatNum")
{
method = EnumEnterOutLogQueryMethod.SeatNum;
}
if (chkSearchMH == string.Empty)
{
dt = LogQueryHelper.GetEnterOutLogDataSet(num, roomNum, method, startDate, endDate.AddHours(23).AddMinutes(59));
}
else
{
dt = LogQueryHelper.GetEnterOutLogDataSet_ByFuzzySearch(num, roomNum, method, startDate, endDate.AddHours(23).AddMinutes(59));
}
if (dt != null)
{
sb.Append("{");
sb.Append("\"form.paginate.pageNo\": 1,");
sb.Append("\"form.paginate.totalRows\": 100,");
sb.Append(" \"rows\": [");
foreach (DataRow r in dt.Rows)
{
sb.Append("{\"CardNo\": '" + r["CardNo"] + "',\"ReaderName\": '" + r["ReaderName"] + "',\"ReadingRoomName\": \"" + r["ReadingRoomName"] + "\",\"SeatShortNum\": \"" + r["SeatShortNum"] + "\",\"Status\": \"" + r["Status"] + "\",\"EnterOutTime\": \"" + r["EnterOutTime"] + "\",\"Remark\": \"" + r["Remark"] + "\"}");
sb.Append(",");
}
if (dt.Rows.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
sb.Append("}");
result = sb.ToString();
}
else
{
result = "没有查询到信息";
}
}
return(result);
}
