using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using VueWebApi.DDKanBanModel;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.DLL.DAL
{
    public class KanBanManagerentDAL
    {
        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 ProductionStockedInLeftTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_ProductionNotReceived";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[北鸣仓库看板左下,产品代发货]
        public static ToMessage ProductConsignmentLeftBottom()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_ProductionNotDeliver";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[北鸣仓库看板右上,近一周生产待入库产品排行TOP5]
        public static ToMessage ProductionStockedInRightTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_ProductionNotReceivedSumTop";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[北鸣仓库看板右下,近一周销售待发货产品排行TOP5]
        public static ToMessage ProductionStockedInRightBottom()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_ProductionNotDeliverSumTop";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion



        #region[北鸣采购委外看板左上,采购待入库]
        public static ToMessage ProcureOutsourcLeftTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_ProcureNotReceived";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[北鸣采购委外看板左下,委外待入库]
        public static ToMessage ProcureOutsourcLeftBottom()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_OutSourcingNotReceived";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[北鸣采购委外看板右上,近一周采购待入库物料排行TOP5]
        public static ToMessage ProcureOutsourcRightTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_ProcureNotReceivedSumTop";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[北鸣采购委外看板右下,近一周委外待入库产品排行TOP5]
        public static ToMessage ProcureOutsourcRightBottom()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_BMKanBan_OutSourcingNotReceivedSumTop";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }
}