PDMesApi.git - Gitblit

			@@ -1362,7 +1362,7 @@
			inner join TEqpchk_Eqp B on A.code=B.eqp_code
			where A.wksp_code=@wkspcode and B.eqpchkmain_code=@checkstand_code and A.is_delete<>'1'
			) as BB on AA.code=BB.code
			) as CC where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1";
			) as CC ";//where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1
			dynamicParams.Add("@checkstand_code", checkstand_code);
			dynamicParams.Add("@wkspcode", data.Rows[i]["WKSP_CODE"].ToString());
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			@@ -1800,7 +1800,7 @@
			inner join TEqpmai_Eqp B on A.code=B.eqp_code
			where A.wksp_code=@wkspcode and B.eapmai_code=@repairstand_code and A.is_delete<>'1'
			) as BB on AA.code=BB.code
			) as CC where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1";
			) as CC ";//where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1
			dynamicParams.Add("@repairstand_code", repairstand_code);
			dynamicParams.Add("@wkspcode", data.Rows[i]["WKSP_CODE"].ToString());
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			@@ -2438,7 +2438,7 @@
			//获取设备维修数据
			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();
			@@ -2449,7 +2449,7 @@
			//获取设备维修图片数据
			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;