using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using Business;
using Business.StructuredDB.Sqe;
using Volo.Abp.Application.Services;

namespace Business.VSM
{
    /// <summary>
    /// Sqe数据导入接口
    /// </summary>
    public interface ISqeExcelService : IApplicationService
    {
        ///// <summary>
        ///// 导入检测的excel文件到DataTable
        ///// </summary>
        ///// <param name="filePath"></param>
        ///// <param name="sheetName"></param>
        ///// <returns></returns>
        //public DataTable ImportExcelSheetToDataTable_test(string filePath, string sheetName);

        ///// <summary>
        ///// 导入过程的excel文件到DataTable
        ///// </summary>
        ///// <param name="filePath"></param>
        ///// <param name="sheetName"></param>
        ///// <returns></returns>
        //public DataTable ImportExcelSheetToDataTable_process(string filePath, string sheetName);


        ///// <summary>
        ///// 依据id，从sqe_file_upload和sqe_file_data，加载数据
        ///// </summary>
        ///// <param name="upload_id"></param>
        ///// <returns></returns>
        //public List<sqe_file_data> LoadData_file_data(int upload_id);

        /// <summary>
        /// 依据id，从sqe_file_upload和sqe_file_data，加载数据到因为数据表中
        /// </summary>
        /// <param name="upload_id"></param>
        /// <param name="create_by"></param>
        /// <param name="create_date"></param>
        /// <param name="create_org"></param>
        /// <returns></returns>
        public string Import_Test_From_Data(int upload_id, string create_by, DateTime create_date, string create_org);

        public string Import_Process_From_Data(int upload_id, string create_by, DateTime create_date, string create_org);


        public string Import_Oqc_From_Data(int upload_id, string create_by, DateTime create_date, string create_org);

        public string Import_Op_From_Data(int upload_id, string create_by, DateTime create_date, string create_org);

        public string Import_Fpy_From_Data(int upload_id, string create_by, DateTime create_date, string create_org);

        public string Import_Fct_From_Data(String data, string create_by, DateTime create_date, string create_org);


        public string Compute_Test(int upload_id, string create_by, DateTime create_date, string create_org);

        public string Compute_Test(string startDate, string endDate, string item_no, string item_batch, string org, string standard_no, int sample_count);

        public string Compute_op_query(string startDate, string endDate, string item_no, string item_batch, string org, string op, string bad_type);

        public string Compute_TestChartData(string startDate, string endDate, string item_no, string item_batch, string org, string standard_no, int sample_count);

        public string Compute_OpChartData(string startDate, string endDate, string item_no, string item_batch, string org, string op, string bad_type);

        public string Compute_OpChartData_Date(string startDate, string endDate, string item_no, string item_batch, string org, string op);

        public string Compute_FpyChartData(string startDate, string endDate, string item_no, string org, string op);

        public string Compute_FpyChartData_Date(string startDate, string endDate, string item_no, string org, string op);

        public string Compute_OqcChartData(string startDate, string endDate, string item_no, string org);
    }
}