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

namespace VueWebCoreApi.DLL.DAL
{
    public class AppPersonalDAL
    {
        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 PieceRateWage(string compute, User us, string startopendate, string endclosedate)
        {
            Dictionary<object, object> dList = new Dictionary<object, object>();
            var dynamicParams = new DynamicParameters();
            string search = "";
            string sql = "";
            try
            {
                //存储过程名
                // --------------查询报工数、良品扣除、计算工资收入--------------
                sql = @"h_p_JLApp_PieceRateWageSummary";
                dynamicParams.Add("@compute", compute);
                dynamicParams.Add("@usercode", us.usercode);
                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_PieceRateWageDetailed";
                dynamicParams.Add("@compute", compute);
                dynamicParams.Add("@usercode", us.usercode);
                dynamicParams.Add("@startopendate", startopendate + " 00:00:00");
                dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59");
                var data1 = DapperHelper.selectProcedure(sql, dynamicParams);
                dList.Add("dt1", data1);
                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
    }
}