| | |
|---|
| | | // --------------查询报工数、良品扣除、计算工资收入-------------- |
|---|
| | | sql = @"h_p_JLApp_PieceRateWageSummary"; |
|---|
| | | dynamicParams.Add("@compute", compute); |
|---|
| | | dynamicParams.Add("@usercode", "998"); |
|---|
| | | 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); |
|---|
| | |
|---|
| | | // --------------查询报工明细(按照工单、产品、工序分组)-------------- |
|---|
| | | sql = @"h_p_JLApp_PieceRateWageDetailed"; |
|---|
| | | dynamicParams.Add("@compute", compute); |
|---|
| | | dynamicParams.Add("@usercode", "998"); |
|---|
| | | 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); |
|---|
