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 HomeIndexDAL
    {
        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[首页顶部四个(生产订单数、生产工单数、在制品数、不良品数)]
        public static ToMessage HomeIndexTopSearch(string paydatestartdate, string paydateenddate, User us)
        {
            var dynamicParams = new DynamicParameters();
            string sql = "";
            try
            {
                sql = @"h_p_HomeIndexTopGetSum";
                dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
                dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
                var dt = DapperHelper.selectProcedure(sql, dynamicParams);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.count = dt.Rows.Count;
                mes.data = dt;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[首页中间工序完成进度,不良品排行]
        public static ToMessage HomeIndexCenterLeftSearch(string paydatestartdate, string paydateenddate, User us)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                //工序完成进度
                sql = @"h_p_HomeIndexCenterLeftGetSum";
                dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
                dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
                var dt = DapperHelper.selectProcedure(sql, dynamicParams);
                dir.Add("CenterLeft", dt);

                //不良排名
                sql = @"h_p_HomeIndexCenterRightGetSum";
                dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
                dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
                var dt1 = DapperHelper.selectProcedure(sql, dynamicParams);
                dir.Add("CenterRight", dt1);


                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dir;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[不良品排行明细]
        public static ToMessage HomeIndexCenterRightSearch(string paydatestartdate, string paydateenddate, string defect_code, User us)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                //不良排名明细
                sql = @"h_p_HomeIndexCenterRightGetSubSum";
                dynamicParams.Add("@Defect_code", defect_code);
                dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
                dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
                dt = DapperHelper.selectProcedure(sql, dynamicParams);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dt;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[首页中间工序完成进度物料明细]
        public static ToMessage HomeIndexCenterLeftSubSearch(string stepcode, string type, string paydatestartdate, string paydateenddate, User us)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            DataTable dt = new DataTable();
            try
            {
                sql = @"h_p_HomeIndexCenterLeftLeftSubSum";
                dynamicParams.Add("@Stepcode", stepcode);
                dynamicParams.Add("@Stype", type);
                dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
                dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
                dt = DapperHelper.selectProcedure(sql, dynamicParams);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dt;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
         
        #region[首页中下销售信息]
        public static ToMessage HomeIndexCenterSaOrderSearch(string type, string paydatestartdate, string paydateenddate, User us)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            DataTable dt = new DataTable();
            try
            {
                sql = @"h_p_HomeIndexCenterSaOrderSum";
                dynamicParams.Add("@Stype", type);
                dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
                dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
                dt = DapperHelper.selectProcedure(sql, dynamicParams);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dt;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[首页底部库存信息]
        public static ToMessage HomeIndexBottomSearch(User us)
        {
            var dynamicParams = new DynamicParameters();
            Dictionary<object, object> dir = new Dictionary<object, object>();
            string sql = "";
            try
            {
                //毛坯库存
                sql = @"h_p_HomeIndexBottomOneGetSum";
                DataTable dt = DapperHelper.IsProcedureNoData(sql);
                dir.Add("BottomOne", dt);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.count = dir.Count;
                mes.data = dir;

                //产成品库存
                sql = @"h_p_HomeIndexBottomTwoGetSum";
                DataTable dt1 = DapperHelper.IsProcedureNoData(sql);
                dir.Add("BottomTwo", dt1);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.count = dir.Count;
                mes.data = dir;



            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }
}