您需要将矩形的fill
颜色设置为与None
颜色相同。通过将其设置为self.r = self.btn.create_rectangle(...,fill=color,outline=color)
,实际上是在告诉tkinter您想要默认颜色,即黑色。
DECLARE @SUPID nvarchar(40);
DECLARE @MY_CURSOR CURSOR; --LOCAL STATIC READ_ONLY FORWARD_ONLY
Begin
set @MY_CURSOR = CURSOR FOR Select oid [AllSUPID] from JHgrDesignSupport
open @MY_CURSOR
FETCH NEXT FROM @MY_CURSOR INTO @SUPID
DECLARE @Output TABLE (
[PipeRun] nvarchar(50),SUP nvarchar(50));
WHILE @@FETCH_STATUS = 0
Begin
select n1.ItemName [PipeRun],@SUPID [SUP]
from ((SELECT OID from JRange JRX Where OID in (Select OID from JRtePipeStraightPathFeat)
and not ((JRX.xmin>
(select sr.xmax from
(select js.oid,jr.xmax,jr.xmin,jr.ymax,jr.ymin,jr.zmax,jr.zmin from JHgrDesignSupport js
join JRange jr on jr.oid = js.oid) as sr where sr.oid = @SUPID)
or xmax <(select sr.xmin from
(select js.oid,jr.zmin from JHgrDesignSupport js
join JRange jr on jr.oid = js.oid) as sr where sr.oid = @SUPID))
or
(JRX.ymin>
(select sr.ymax from
(select js.oid,jr.zmin from JHgrDesignSupport js
join JRange jr on jr.oid = js.oid) as sr where sr.oid = @SUPID)
or ymax <(select sr.ymin from
(select js.oid,jr.zmin from JHgrDesignSupport js
join JRange jr on jr.oid = js.oid) as sr where sr.oid = @SUPID))
or
(JRX.zmin>
(select (sr.zmax) from
(select js.oid,jr.zmin from JHgrDesignSupport js
join JRange jr on jr.oid = js.oid) as sr where sr.oid = @SUPID)
or zmax <(select sr.zmin from
(select js.oid,jr.zmin from JHgrDesignSupport js
join JRange jr on jr.oid = js.oid) as sr where sr.oid = @SUPID)))
) as t1
join XPathSpecification x1 on x1.oidDestination = t1.oid
join JNamedItem n1 on n1.oid = x1.oidOrigin)
FETCH NEXT FROM @MY_CURSOR INTO @SUPID
END;
CLOSE @MY_CURSOR;
END;
本文链接:https://www.f2er.com/2897404.html