| | |
|---|
| | | //获取设备维修数据 |
|---|
| | | sql = @"select A.failure_descript,A.is_shutdown,A.repair_content,A.repair_part from TEqp_Repair A |
|---|
| | | left join TEqp_RepairRequest B on A.source_wo=B.docu_code |
|---|
| | | where A.repair_code='SBWX221010016'"; |
|---|
| | | where A.repair_code=@repair_code"; |
|---|
| | | dynamicParams.Add("@repair_code", repair_code); |
|---|
| | | var data1 = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | DeviceRepair repair = new DeviceRepair(); |
|---|
| | |
|---|
| | | //获取设备维修图片数据 |
|---|
| | | sql = @"select M.img1url,M.img2url from TEqp_Repair A |
|---|
| | | left join TEqp_RepairImage M on A.repair_code=M.source_wo |
|---|
| | | where A.repair_code='SBWX221010016' and M.wo_type='COMP'"; |
|---|
| | | where A.repair_code=@repair_code and M.wo_type='COMP'"; |
|---|
| | | dynamicParams.Add("@repair_code", repair_code); |
|---|
| | | var data3 = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | repair.repairimage = data3; |
|---|
