App个人计件工资(不包含班组，只核算个人报工)

yl

2023-12-05 0f97c5a757e2f0ffd5a98f276508e90924c70200

App个人计件工资(不包含班组，只核算个人报工)

 VueWebCoreApi/ApiGroup/OpenApiGroup.cs

@@ -39,6 +39,8 @@
        [Description("单据打印")]
        å•æ®æ‰“印 = 15,
        [Description("看板管理")]
        çœ‹æ¿ç®¡ç†=16
        çœ‹æ¿ç®¡ç†=16,
        [Description("App个人中心")]
        App个人中心 = 20
    }
}

 VueWebCoreApi/Controllers/AppPersonalController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,46 @@
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.DLL.BLL;
using VueWebCoreApi.Models;
using VueWebCoreApi.Tools;

namespace VueWebCoreApi.Controllers
{
    [ApiExplorerSettings(GroupName = "App个人中心")]
    [ApiController]
    [Route("api/[controller]")]
    public class AppPersonalController : Controller
    {
        //定义全局信息返回变量
        ToMessage mes = new ToMessage();
        RedisHelper redis = new RedisHelper();

        #region[App个人计件工资]
        /// <summary>
        /// App个人计件工资
        /// </summary>
        /// <param name="compute">计算方式:末道计算、逐道计算</param>
        /// <param name="Ratetime">时间</param>
        /// <returns></returns>
        [Route(template: "PieceRateWage")]
        [HttpGet]
        public JsonResult PieceRateWage(string compute, string Ratetime)
        {
            var token = HttpContext.Request.Headers["Token"].ToString();
            User us = JwtTools.Denocode(token.ToString());
            string startopendate = "";  //开始时间
            string endclosedate = "";    //结束时间
            if (Ratetime != "" && Ratetime != null)
            {
                startopendate = Ratetime.Split('~')[0].ToString();
                endclosedate = Ratetime.Split('~')[1].ToString();
            }
            mes = AppPersonalBLL.PieceRateWage(compute, us, startopendate, endclosedate);
            return Json(mes);
        }
        #endregion
    }
}

 VueWebCoreApi/DLL/BLL/AppPersonalBLL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.DLL.DAL;
using VueWebCoreApi.Models;
using VueWebCoreApi.Tools;

namespace VueWebCoreApi.DLL.BLL
{
    public class AppPersonalBLL
    {
        #region[App个人计件工资]
        public static ToMessage PieceRateWage(string compute, User us, string startopendate, string endclosedate)
        {
            return AppPersonalDAL.PieceRateWage(compute, us, startopendate, endclosedate);
        }
        #endregion
    }
}

 VueWebCoreApi/DLL/DAL/AppPersonalDAL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,67 @@
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", "998");
                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", "998");
                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
    }
}