/// <summary> /// 跟据截止时间获得TZ数据 /// </summary> /// <param name="request"></param> /// <returns></returns> public TZResponse GetTZ(TZRequest request) { Query query = new Query("TZ"); if (request.ReportType == "1") { string startTime = request.StartTime.Split('-')[0]; string endTime = request.EndTime.Split('-')[0]; query.AddCriterion("ReportID", "ReportID",int.Parse(request.ReportName), CriteriaOperator.Equal); query.AddCriterion("Date", "startDate", startTime, CriteriaOperator.MoreThanOrEqual); query.AddCriterion("Date", "endDate", endTime, CriteriaOperator.LessThanOrEqual); query.AddCriterion("Date", "____", CriteriaOperator.Like); if (request.ModifiedFlag != "0") { bool modifiedFlag = bool.Parse(request.ModifiedFlag); query.AddCriterion("ModifiedFlag","modifiedflag", modifiedFlag, CriteriaOperator.Equal); } } else if (request.ReportType == "2") { string startTime = request.StartTime.Split('-')[0] + "-" + request.StartTime.Split('-')[1]; string endTime = request.EndTime.Split('-')[0] + "-" + request.EndTime.Split('-')[1]; query.AddCriterion("ReportID", "ReportID", int.Parse(request.ReportName), CriteriaOperator.Equal); query.AddCriterion("Date", "startDate", startTime, CriteriaOperator.MoreThanOrEqual); query.AddCriterion("Date", "endDate", endTime, CriteriaOperator.LessThanOrEqual); query.AddCriterion("Date", "____-__", CriteriaOperator.Like); if (request.ModifiedFlag != "0") { bool modifiedFlag = bool.Parse(request.ModifiedFlag); query.AddCriterion("ModifiedFlag", "modifiedflag", modifiedFlag, CriteriaOperator.Equal); } } else if (request.ReportType == "3") { string startTime = request.StartTime.Split('-')[0] + request.StartTime.Split('-')[1] + request.StartTime.Split('-')[2]; string endTime = request.EndTime.Split('-')[0] + request.EndTime.Split('-')[1] + request.EndTime.Split('-')[2]; query.AddCriterion("ReportID", "ReportID", int.Parse(request.ReportName), CriteriaOperator.Equal); query.AddCriterion("Date", "startDate", startTime, CriteriaOperator.MoreThanOrEqual); query.AddCriterion("Date", "endDate", endTime, CriteriaOperator.LessThanOrEqual); query.AddCriterion("Date", "____-__-__", CriteriaOperator.Like); if (request.ModifiedFlag != "0") { bool modifiedFlag = bool.Parse(request.ModifiedFlag); query.AddCriterion("ModifiedFlag","modifiedflag", modifiedFlag, CriteriaOperator.Equal); } } else { throw new Exception("没有匹配的报表类型"); } IEnumerable<TZ> tz = tzRepository.FindBy(query); return new TZResponse { TZViews = tz.ConvertToViews(), Success = true }; }
public static string GetTZInformation(string reportType, string reportName, string modifiedFlag, string startTime, string endTime) { TZRequest request = new TZRequest { EndTime = endTime, ReportName = reportName, ReportType = reportType, StartTime = startTime, ModifiedFlag = modifiedFlag }; ReportService service = new ReportService(); TZResponse response = service.GetTZ(request); EasyUIJsonTemplate<TZView> jsonclass =new EasyUIJsonTemplate<TZView> { total = response.TZViews.Count(), rows = response.TZViews }; string result = JsonHelper.ObjectToJson(jsonclass); return result; }
public string GetTZInformations(Guid id) { TZRequest request = new TZRequest { KeyID = id }; IReportService service = new ReportService(); TZResponse response = service.GetTZInformationByKeyID(request); string result = JsonHelper.ObjectToJson(response.TZView); return result; }
public TZResponse GetTZInformationByKeyID(TZRequest request) { TZ tz = tzRepository.FindBy(request.KeyID); TZResponse response = new TZResponse { TZView = tz.ConvertToView() }; return response; }