| | |
|---|
| | | } |
|---|
| | | if (partcode != "" && partcode != null) |
|---|
| | | { |
|---|
| | | search += "and A.partcode like '%'+@stanedname+'%' "; |
|---|
| | | search += "and A.partcode like '%'+@partcode+'%' "; |
|---|
| | | dynamicParams.Add("@partcode", partcode); |
|---|
| | | } |
|---|
| | | if (partname != "" && partname != null) |
|---|
| | |
|---|
| | | left join TMateriel_Info B on A.partcode=B.partcode |
|---|
| | | left join TStep S on A.step_code=S.stepcode |
|---|
| | | left join TStepCheckStandard T on A.checkstaned_code=T.code |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | | left join TUser U on A.check_user=U.usercode |
|---|
| | | where " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
