| | |
| | | try |
| | | { |
| | | //获取设备保养标准信息 |
| | | sql = @"select code,name,description |
| | | sql = @"select code,name,description,main_cycle |
| | | from TEqpmai_Main |
| | | where code=@repairstand_code and is_delete<>'1'"; |
| | | dynamicParams.Add("@repairstand_code", repairstand_code); |
| | |
| | | return mes; |
| | | } |
| | | //根据设备保养标准编码获取关联的保养项目信息 |
| | | sql = @"select B.code,B.name,A.chkdesc,A.isscan,A.cycle from TEqpmai_Deta A |
| | | sql = @"select B.code,B.name,A.chk_desc,A.isscan,A.cycle from TEqpmai_Deta A |
| | | left join TEqpmai_Item B on A.code=B.code |
| | | where A.eapmai_code=@repairstand_code order by A.seq asc"; |
| | | dynamicParams.Add("@repairstand_code", rout.code); |