public ResponseJson GroupRequest(string token, ReportFilter filter) { if (AuthData.GetRole(token) == Role.NoLogin) { return ResponseJson.GetResponseJson(string.Empty, false); } if (filter == null) filter = new ReportFilter(); var data = DataProcess.GetGroupScheduleRequestLogs(filter); var total = DataProcess.GetCountGroupScheduleRequestLogs(filter); var resultObject = new ScheduleReport() { ScheduleLogs = data, Total = total, NumberOfPages = (total + filter.GetCorrectSize() - 1) / filter.GetCorrectSize() }; return ResponseJson.GetResponseJson(resultObject); }
public static List<ScheduleRequestLog> GetGroupScheduleRequestLogs(ReportFilter filter) { return SQLiteProcess.GetGroupScheduleRequestLogs(filter, false); }
public static List<ScheduleRequestLog> GetGroupScheduleRequestLogs(ReportFilter filter, bool isFailRequest = false) { if (filter == null) filter = new ReportFilter(); List<ScheduleRequestLog> schedules = new List<ScheduleRequestLog>(); using (var sql_con = new SQLiteConnection(ReportConnectString)) { sql_con.Open(); using (var sql_cmd = sql_con.CreateCommand()) { sql_cmd.CommandText = filter.GenSelectCommand(isFailRequest); var myParameters = sql_cmd.Parameters; using (var reader = sql_cmd.ExecuteReader()) { while (reader.Read()) { var scheduleRequestLog = new ScheduleRequestLog(); if (!filter.NoChannelKey || (filter.IsAllFalse)) scheduleRequestLog.ChannelKey = (reader["ChannelKey"] ?? "").ToString(); if (!filter.NoCurrentDate || (filter.IsAllFalse)) scheduleRequestLog.CurrentDate = (reader["CurrentDate"] ?? "").ToString(); if (!filter.NoDateOn || (filter.IsAllFalse)) scheduleRequestLog.DateOn = (reader["DateOn"] ?? "").ToString(); if (!filter.NoDeviceId || (filter.IsAllFalse)) scheduleRequestLog.DeviceId = (reader["DeviceId"] ?? "").ToString(); if (!filter.NoOpenKey || (filter.IsAllFalse)) scheduleRequestLog.OpenKey = (reader["OpenKey"] ?? "").ToString(); if (!filter.NoAppVersion || (filter.IsAllFalse)) scheduleRequestLog.AppVersion = (reader["AppVersion"] ?? "").ToString(); scheduleRequestLog.NumberOfRequests = Int32.Parse((reader["NumberOfRequests"] ?? "").ToString()); schedules.Add(scheduleRequestLog); } } } sql_con.Close(); } return schedules; }
public static int GetCountGroupScheduleFailedRequestLogs(ReportFilter filter) { return SQLiteProcess.GetCountGroupScheduleRequestLogs(filter, true); }
public static int GetCountGroupScheduleRequestLogs(ReportFilter filter, bool isFailRequest = false) { if (filter == null) filter = new ReportFilter(); int count = 0; using (var sql_con = new SQLiteConnection(ReportConnectString)) { sql_con.Open(); using (var sql_cmd = sql_con.CreateCommand()) { sql_cmd.CommandText = filter.GenCountCommand(isFailRequest); var myParameters = sql_cmd.Parameters; using (var reader = sql_cmd.ExecuteReader()) { while (reader.Read()) { count = reader.GetInt32(0); break; } } } sql_con.Close(); } return count; }