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