public Response <GetMessageHistoryQueryRequest> GetMessageHistoryInfoReport(GetMessageHistoryQueryRequest request) { Response <GetMessageHistoryQueryRequest> response = new Response <GetMessageHistoryQueryRequest>() { Result = new GetMessageHistoryQueryRequest() }; if (request == null) { ArgumentNullException ex = new ArgumentNullException("GetMessageHistoryInfo request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { TotalAccessor accessor = new TotalAccessor(); response.Result.MessageHistoryTable = accessor.GetMessageHistoryInfoReport(request.SqlWhere); response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Exception = ex; } return(response); }
public Response <GetMessageHistoryQueryRequest> GetMessageHistoryInfo(GetMessageHistoryQueryRequest request) { Response <GetMessageHistoryQueryRequest> response = new Response <GetMessageHistoryQueryRequest>() { Result = new GetMessageHistoryQueryRequest() }; if (request == null) { ArgumentNullException ex = new ArgumentNullException("GetMessageHistoryInfo request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { TotalAccessor accessor = new TotalAccessor(); int Rowcount; response.Result.MessageHistoryTable = accessor.GetMessageHistoryInfo(request.SqlWhere, request.PageIndex, request.PageSize, out Rowcount); response.Result.PageIndex = request.PageIndex; response.Result.PageCount = Rowcount % request.PageSize == 0 ? Rowcount / request.PageSize : Rowcount / request.PageSize + 1; response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Exception = ex; } return(response); }
public ActionResult MessageHistoryQuery(MessageHistoryQueryModel model, int?PageIndex) { if (model.IsExprot) { return(this.GetMessageHistoryInfoReport(model)); } else { GetMessageHistoryQueryRequest request = new GetMessageHistoryQueryRequest() { SqlWhere = GetSqlWhere(model), PageSize = UtilConstants.PAGESIZE, PageIndex = PageIndex ?? 0 }; Response <GetMessageHistoryQueryRequest> Response = new TotalService().GetMessageHistoryInfo(request); model.MessageHistoryTable = Response.Result.MessageHistoryTable; model.PageIndex = Response.Result.PageIndex; model.PageSize = Response.Result.PageSize; model.PageCount = Response.Result.PageCount; } return(View(model)); }
public ActionResult GetMessageHistoryInfoReport(MessageHistoryQueryModel view) { string SQL = this.GetSqlWhere(view); string ReportName = "Total短信信息" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"; GetMessageHistoryQueryRequest request = new GetMessageHistoryQueryRequest() { SqlWhere = GetSqlWhere(view) }; Response <GetMessageHistoryQueryRequest> Response = new TotalService().GetMessageHistoryInfoReport(request); DataTable Exprottable = Response.Result.MessageHistoryTable; ExcelHelper excelHelper = new ExcelHelper(); string targetPath = Path.Combine(Runbow.TWS.Common.Constants.UPLOAD_FOLDER_PATH, base.UserInfo.ProjectID.ToString(), "Temp"); string fileFullPath = Path.Combine(targetPath, ReportName); excelHelper.CreateExcelByDataTable(fileFullPath, Exprottable); excelHelper.Dispose(); string mimeType = "application/msexcel"; FileStream fs = MyFile.Open(fileFullPath, FileMode.Open); return(File(fs, mimeType, Url.Encode(ReportName))); }