| | |
| | | } |
| | | //根据模具保养标准编码获取关联的检验项目信息 |
| | | sql = @"select B.code,B.name,A.chkdesc from TMouldmai_Deta A |
| | | left join TMouldchk_Item B on A.code=B.code |
| | | left join TMouldmai_Item B on A.code=B.code |
| | | where A.mouldmai_main_code=@repairstand_code order by A.seq asc"; |
| | | dynamicParams.Add("@repairstand_code", rout.code); |
| | | var data0 = DapperHelper.selectdata(sql, dynamicParams); |
| | |
| | | { |
| | | //获取对应模具保养标准 |
| | | sql = @"select M.code,M.name from TMouldmai_Mould E |
| | | inner join TMouldchk_Main M on E.mouldmaimain_code=M.code |
| | | inner join TMouldmai_Main M on E.mouldmaimain_code=M.code |
| | | where E.mould_code=@mouldcode order by M.lm_date desc"; |
| | | dynamicParams.Add("@mouldcode", mouldcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |