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