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
|
}
|
}
|
