using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.Models;
using VueWebCoreApi.Tools;

namespace VueWebCoreApi.DLL.DAL
{
    public class AppAnalyticsDAL
    {
        public static DataTable dt;    //定义全局变量dt
        public static bool res;       //定义全局变量dt

        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
        public static string strProcName = ""; //定义全局sql变量
        public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
        public static SqlParameter[] parameters; //定义全局SqlParameter参数数组


        #region[App生产看板]
        public static ToMessage ProductionKanban(User us, string startopendate, string endclosedate, string defecttype)
        {
            Dictionary<object, object> dList = new Dictionary<object, object>();
            var dynamicParams = new DynamicParameters();
            string search = "", torg_codelist = "", sql = "";
            try
            {
                //获取当前用户所属组织及所有子节点组织
                mes = TOrganizationRecursion.TOrgCodeSeach("SCB");
                if (mes.code == "300")
                {
                    return mes;
                }
                else
                {
                    torg_codelist = mes.data.ToString(); //获取组织集合
                }
                // --------------生产总览--------------
                string[] torglist = Array.ConvertAll<string, string>(torg_codelist.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] 
                //存储过程名
                // --------------查询工单任务数、报工数、计算工资收入--------------
                sql = @"h_p_JLApp_ProductAnalysisTop";
                dynamicParams.Add("@torglist", mes.data.ToString());
                dynamicParams.Add("@startopendate", startopendate + " 00:00:00");
                dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59");
                var data0 = DapperHelper.selectProcedure(sql, dynamicParams);
                dList.Add("dt0", data0);
                // --------------生产工单--------------
                sql = @"h_p_JLApp_ProductAnalysisCenter";
                dynamicParams.Add("@torglist", mes.data.ToString());
                dynamicParams.Add("@startopendate", startopendate + " 00:00:00");
                dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59");
                var data1 = DapperHelper.selectProcedure(sql, dynamicParams);
                dList.Add("dt1", data1);
                // --------------缺陷统计--------------
                sql = @"h_p_JLApp_ProductAnalysisBottom";
                dynamicParams.Add("@compute", defecttype);
                dynamicParams.Add("@torglist", mes.data.ToString());
                dynamicParams.Add("@startopendate", startopendate + " 00:00:00");
                dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59");
                var data2 = DapperHelper.selectProcedure(sql, dynamicParams);
                dList.Add("dt2", data2);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dList;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }
}