| | |
|---|
| | | string search = ""; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | if (usercode != "" && usercode != null) |
|---|
| | | { |
|---|
| | | search += "and B.report_person=@usercode "; |
|---|
| | | dynamicParams.Add("@usercode", usercode); |
|---|
| | | } |
|---|
| | | if (startopendate != "" && startopendate != null) |
|---|
| | | { |
|---|
| | | search += "and B.report_date between @startopendate and @endclosedate "; |
|---|
| | | dynamicParams.Add("@startopendate", startopendate + " 00:00:00"); |
|---|
| | | dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59"); |
|---|
| | | } |
|---|
| | | if (search == "") |
|---|
| | | { |
|---|
| | | search = "and 1=1 "; |
|---|
| | | } |
|---|
| | | search = search.Substring(3);//截取索引2后面的字符 |
|---|
| | | dynamicParams.Add("@usercode", usercode); |
|---|
| | | dynamicParams.Add("@startopendate", startopendate + " 00:00:00"); |
|---|
| | | dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59"); |
|---|
| | | |
|---|
| | | // --------------查询报工数、良品扣除、计算工资收入-------------- |
|---|
| | | var sql = @"select isnull(sum(BB.report_qty),0) as report_qty,(isnull(sum(BB.userngmoney),0)+isnull(sum(BB.userbadmoney),0)) as userngbadmoney, |
|---|
| | | isnull(sum(BB.usermoney),0)-(isnull(sum(BB.userngmoney),0)+isnull(sum(BB.userbadmoney),0)) as usermoney |
|---|
| | |
|---|
| | | left join TMateriel_Info M on A.materiel_code=M.partcode |
|---|
| | | left join TStep T on A.step_code=T.stepcode |
|---|
| | | left join TUser U on B.report_person=U.usercode |
|---|
| | | where "+search+") as AA) as BB "; |
|---|
| | | where B.report_person=@usercode and B.report_date between @startopendate and @endclosedate) as AA) as BB "; |
|---|
| | | var data0 = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | dList.Add("dt0", data0); |
|---|
| | | // --------------查询报工明细(按照工单、产品、工序分组)-------------- |
|---|
| | |
|---|
| | | left join TMateriel_Info M on A.materiel_code=M.partcode |
|---|
| | | left join TStep T on A.step_code=T.stepcode |
|---|
| | | left join TUser U on B.report_person=U.usercode |
|---|
| | | where "+search+") as AA group by AA.wo_code,AA.partcode,AA.partname,AA.stepcode,AA.stepname,AA.task_qty,AA.group_code,AA.group_name,AA.unprice,AA.report_person,AA.username,colum"; |
|---|
| | | where B.report_person=@usercode and B.report_date between @startopendate and @endclosedate) as AA group by AA.wo_code,AA.partcode,AA.partname,AA.stepcode,AA.stepname,AA.task_qty,AA.group_code,AA.group_name,AA.unprice,AA.report_person,AA.username,colum"; |
|---|
| | | var data1 = DapperHelper.selectdata(sql1, dynamicParams); |
|---|
| | | dList.Add("dt1", data1); |
|---|
| | | mes.code = "200"; |
|---|
