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