DEMOMySql/MicroServices/Business/Business.HttpApi/Controllers/SqeController.cs

using Business.Sqe;
using Business.StructuredDB;
using Business.StructuredDB.Sqe;
using Business.VSM;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using NLog.Fluent;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;
using Volo.Abp;
using Volo.Abp.AspNetCore.Mvc;

namespace Business.Controllers
{
    /// <summary>
    /// 价值流接口
    /// </summary>
    [RemoteService]
    [Area("Sqe")]
    [Route("api/business/sqe")]
    public class SqeController : AbpController
    {

        public IJwtService _jwtService { set; get; }

        private IConfiguration _configuration;

        private readonly ISqeExcelService _SqeExcelService;

        public SqeController(ISqeExcelService SqeExcelService, IJwtService jwtService, IConfiguration configuration)
        {
            _SqeExcelService = SqeExcelService;
            _jwtService = jwtService;
            _configuration = configuration;
        }

        private String CheckToken(string token)
        {
            try
            {
                JwtOptions jwtOptions = new JwtOptions();
                jwtOptions.ExpireSeconds = Convert.ToInt32(_configuration["JWT:ExpireSeconds"]);
                jwtOptions.Issuer = _configuration["JWT:Issuer"];
                jwtOptions.Audience = _configuration["JWT:Audience"];
                jwtOptions.Key = _configuration["JWT:Key"];
                String data = _jwtService.ValidateToken(token, jwtOptions);
                if (!string.IsNullOrEmpty(data))
                {
                    return data;
                }
            }
            catch (Exception ex)
            {
            }
            return null;
        }



        [HttpGet]
        [Route("import_test")]
        public string Import_test(int file_id, string create_by, string create_org)
        {
            String s = _SqeExcelService.Import_Test_From_Data(file_id, create_by, DateTime.Now, create_org);
            return s;
        }

        [HttpGet]
        [Route("import_process")]
        public string Import_process(int file_id, string create_by, string create_org)
        {
            String s = _SqeExcelService.Import_Process_From_Data(file_id, create_by, DateTime.Now, create_org);
            return s;
        }

        [HttpGet]
        [Route("import_oqc")]
        public string Import_oqc(int file_id, string create_by, string create_org)
        {
            String s = _SqeExcelService.Import_Oqc_From_Data(file_id, create_by, DateTime.Now, create_org);
            return s;
        }

        [HttpGet]
        [Route("import_op")]
        public string Import_op(int file_id, string create_by, string create_org)
        {
            String s = _SqeExcelService.Import_Op_From_Data(file_id, create_by, DateTime.Now, create_org);
            return s;
        }

        [HttpGet]
        [Route("import_fpy")]
        public string Import_fpy(int file_id, string create_by, string create_org)
        {
            String s = _SqeExcelService.Import_Fpy_From_Data(file_id, create_by, DateTime.Now, create_org);
            return s;
        }

        [HttpGet]
        [Route("UploadProductionTestData")]
        public string Import_fct(String data, String token)
        {
            String userid = CheckToken(token);
            JObject json = new JObject();
            if (userid != null)
            {
                String s = _SqeExcelService.Import_Fct_From_Data(data, userid, DateTime.Now, userid);
                if (s == null || s.Length == 0)
                {
                    json["resultCode"] = "OK";
                    json["resultMessage"] = "成功";
                }
                else
                {
                    json["resultCode"] = "NG";
                    json["resultMessage"] = s;
                }
                return json.ToString();
            }
            else
            {
                json["resultCode"] = "NG";
                json["resultMessage"] = "传入配置未通过授权!";
                return json.ToString();
            }
        }


        [HttpGet]
        [Route("compute_test_id")]
        public string Compute_test_id(int file_id, string create_by, string create_org)
        {
            String s = _SqeExcelService.Compute_Test(file_id, create_by, DateTime.Now, create_org);
            return s;
        }

        [HttpGet]
        [Route("compute_test_query")]
        public string Compute_test_query(string startDate, string endDate, string item_no, string item_batch, string org, string standard_no, int sample_count)
        {
            String s = _SqeExcelService.Compute_Test(startDate, endDate, item_no, item_batch, org, standard_no, sample_count);
            return s;
        }

        [HttpGet]
        [Route("compute_test_query_chart")]
        public string compute_test_query_chart(string startDate, string endDate, string item_no, string item_batch, string org, string standard_no, int sample_count)
        {
            String s = _SqeExcelService.Compute_TestChartData(startDate, endDate, item_no, item_batch, org, standard_no, sample_count);
            return s;
        }




        //工序方法

        /// <summary>
        /// 依据查询条件，统计工序的不良情况
        /// </summary>
        /// <param name="startDate"></param>
        /// <param name="endDate"></param>
        /// <param name="item_no"></param>
        /// <param name="item_batch"></param>
        /// <param name="org"></param>
        /// <param name="op"></param>
        /// <param name="bad_type"></param>
        /// <returns></returns>
        [HttpGet]
        [Route("compute_op_query")]
        public string Compute_op_query(string startDate, string endDate, string item_no, string item_batch, string org, string op, string bad_type)
        {
            String s = _SqeExcelService.Compute_op_query(startDate, endDate, item_no, item_batch, org, op, bad_type);
            return s;
        }

        [HttpGet]
        [Route("compute_op_query_chart")]
        public string compute_op_query_chart(string startDate, string endDate, string item_no, string item_batch, string org, string op, string bad_type)
        {
            String s = _SqeExcelService.Compute_OpChartData(startDate, endDate, item_no, item_batch, org, op, bad_type);
            return s;
        }

        [HttpGet]
        [Route("compute_op_query_chart_date")]
        public string compute_op_query_chart_date(string startDate, string endDate, string item_no, string item_batch, string org, string op)
        {
            String s = _SqeExcelService.Compute_OpChartData_Date(startDate, endDate, item_no, item_batch, org, op);
            return s;
        }

        [HttpGet]
        [Route("compute_fpy_query_chart")]
        public string compute_fpy_query_chart(string startDate, string endDate, string item_no, string org, string op)
        {
            String s = _SqeExcelService.Compute_FpyChartData(startDate, endDate, item_no, org, op);
            return s;
        }

        [HttpGet]
        [Route("compute_fpy_query_chart_date")]
        public string compute_fpy_query_chart_date(string startDate, string endDate, string item_no, string org, string op)
        {
            String s = _SqeExcelService.Compute_FpyChartData_Date(startDate, endDate, item_no, org, op);
            return s;
        }

        [HttpGet]
        [Route("compute_oqc_query_chart_date")]
        public string compute_oqc_query_chart_date(string startDate, string endDate, string item_no, string org)
        {
            String s = _SqeExcelService.Compute_OqcChartData(startDate, endDate, item_no, org);
            return s;
        }
    }
}