ConditionDoQuery

• Query lồng query
• Query GoTo

Cách dùng ConditionDoQuery

<ConditionDoQuery>biểu thức</ConditionDoQuery>
* Nếu biếu thức đúng thì mới thực hiện query

<Query>
<ID>Q1</ID>
<Src>12</Src>
<Type>Sql</Type>
<Cmd>Select Count(*) From tbBanHang_SV Where _SYS_KEY=@SYS_KEY</Cmd>
<SqlParameter>
SYS_KEY/-/<iif-D>Url:id</iif-D>
</SqlParameter>
<SqlConfig>
Call:ExecuteScalar
</SqlConfig>
<SetVar>
name:DonHangTonTai
value:{g:db/->0,0,@:g}
type:int
</SetVar>
</Query>


<Query>
<ID>Q_DH_Insert</ID>
<ConditionDoQuery>{g:has/->DonHangTonTai/->null:0:g}=0</ConditionDoQuery>
<Src>12</Src>
<Type>Sql</Type>
<Cmd>INSERT INTO tbBanHang_SV (_SYS_KEY, NgayTao,KyHieu,So,UserName) VALUES (@_SYS_KEY, GETDATE(),@KyHieu,@So,@UserName); </Cmd>
<SqlParameter>
_SYS_KEY/-/{g:has/->Key:g}
KyHieu/-/DH23
So/-/<getQuery>BanHang_iif/LaySoPhieuMoi/->/DH23/--/0000</getQuery>
UserName/-/{#SysUser-UserName}
</SqlParameter>
<SqlConfig>
 Call:ExecuteNonQuery
</SqlConfig>
</Query>