public HttpResponseMessage GetReportTptShipment([FromBody] GetReportTableDTO req)
{
ReportTvModels olap = _mapper.Map <ReportTvModels>(req);
string restring = string.Empty;
if (string.IsNullOrWhiteSpace(olap.name))
{ //当条件为空 返回-2
restring = Remess.GetResultMessage("[]", olap, "条件Name不能为空！", -2, 0);
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
try
{
restring = JsonConvert.SerializeObject(dbGet.GetTptShipment(olap, _settings), new DataTableConverter());
count = Convert.ToInt32(dbGet.GetTptShipmentCount(olap, _settings).Rows[0][0].ToString());
restring = restring.Replace("\"[{\\", "[{").Replace("\\\"", "\"").Replace("}]\"", "}]").Replace(":\"[[", ":[[").Replace("]]\"}", "]]}");
}
catch (Exception ex)
{
//当查询语句报错 返回-3
restring = Remess.GetResultMessage("[]", olap, "defeated", -3, count);
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
//查询语句正确
if (restring.Length > 2)
{
//参数正确有回传结果 1
restring = Remess.GetResultMessage(restring, olap, "success", 1, count);
}
else
{
//参数正确 回传结果为空 -1
restring = Remess.GetResultMessage(restring, olap, "defeated", -1, count);
}
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
public HttpResponseMessage GetReportTable([FromBody] GetReportTableDTO req)
{
ReportTvModels olap = _mapper.Map <ReportTvModels>(req);
string restring = string.Empty;
if (string.IsNullOrWhiteSpace(olap.name))
{ //当条件为空 返回-2
restring = Remess.GetResultMessage("[]", olap, "条件Name不能为空！", -2, 0);
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
try
{
restring = JsonConvert.SerializeObject(dbGet.getresultTable(olap, _settings), new DataTableConverter());
}
catch (Exception)
{
//当查询语句报错 返回-3
restring = Remess.GetResultMessage("[]", olap, "defeated", -3, 0);
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
//查询语句正确
if (restring.Length > 2)
{
//参数正确有回传结果 1
restring = Remess.GetResultMessage(restring, olap, "success", 1, 0);
}
else
{
//参数正确 回传结果为空 -1
restring = Remess.GetResultMessage(restring, olap, "defeated", -1, 0);
}
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
