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