378 source/background/RiskMgr/Bin/SqlMapping/Activity.xml
View file
@@ -0,0 +1,378 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Activity" type="DreamWorkflow.Engine.Model.Activity" />
<typeAlias alias="ActivityQueryForm" type="DreamWorkflow.Engine.Form.ActivityQueryForm" />
<typeAlias alias="ActivityUpdateForm" type="DreamWorkflow.Engine.Form.ActivityUpdateForm" />
</alias>
<statements>
<select id="QueryActivity" resultClass="Activity" parameterClass="ActivityQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `Activity`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Page">
`Page`=#Page#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="Status">
`Status`=#Status#
</isNotNull>
<isNotNull prepend="AND" property="ReadTime_Start">
`ReadTime`&gt;=#ReadTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ReadTime_End">
`ReadTime`&lt;=#ReadTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ProcessTime_Start">
`ProcessTime`&gt;=#ProcessTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ProcessTime_End">
`ProcessTime`&lt;=#ProcessTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Title">
`Title`=#Title#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
ORDER BY LastUpdateTime DESC
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddActivity" parameterClass="Activity">
INSERT INTO `Activity`
(
`ID`,
`ActivityDefinitionID`,
`Name`,
`Page`,
`Creator`,
`CreateTime`,
`Type`,
`WorkflowID`,
`Status`,
`ReadTime`,
`ProcessTime`,
`LastUpdateTime`,
`LastUpdator`,
`Title`
)
VALUES
(
#ID#,
#ActivityDefinitionID#,
#Name#,
#Page#,
#Creator#,
#CreateTime#,
#Type#,
#WorkflowID#,
#Status#,
#ReadTime#,
#ProcessTime#,
#LastUpdateTime#,
#LastUpdator#,
#Title#
)
</insert>
<update id="UpdateActivity" parameterClass="ActivityUpdateForm">
UPDATE `Activity`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.ActivityDefinitionID">
`ActivityDefinitionID`=#Entity.ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="," property="Entity.Name">
`Name`=#Entity.Name#
</isNotNull>
<isNotNull prepend="," property="Entity.Page">
`Page`=#Entity.Page#
</isNotNull>
<isNotNull prepend="," property="Entity.Creator">
`Creator`=#Entity.Creator#
</isNotNull>
<isNotNull prepend="," property="Entity.CreateTime">
`CreateTime`=#Entity.CreateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.Type">
`Type`=#Entity.Type#
</isNotNull>
<isNotNull prepend="," property="Entity.WorkflowID">
`WorkflowID`=#Entity.WorkflowID#
</isNotNull>
<isNotNull prepend="," property="Entity.Status">
`Status`=#Entity.Status#
</isNotNull>
<isNotNull prepend="," property="Entity.ReadTime">
`ReadTime`=#Entity.ReadTime#
</isNotNull>
<isNotNull prepend="," property="Entity.ProcessTime">
`ProcessTime`=#Entity.ProcessTime#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdateTime">
`LastUpdateTime`=#Entity.LastUpdateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdator">
`LastUpdator`=#Entity.LastUpdator#
</isNotNull>
<isNotNull prepend="," property="Entity.Title">
`Title`=#Entity.Title#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ActivityQueryForm.ID">
`ID`=#ActivityQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityQueryForm.ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.Name">
`Name`=#ActivityQueryForm.Name#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.Page">
`Page`=#ActivityQueryForm.Page#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.Creator">
`Creator`=#ActivityQueryForm.Creator#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.CreateTime_Start">
`CreateTime`&gt;=#ActivityQueryForm.CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.CreateTime_End">
`CreateTime`&lt;=#ActivityQueryForm.CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.Type">
`Type`=#ActivityQueryForm.Type#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.WorkflowID">
`WorkflowID`=#ActivityQueryForm.WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.Status">
`Status`=#ActivityQueryForm.Status#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.ReadTime_Start">
`ReadTime`&gt;=#ActivityQueryForm.ReadTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.ReadTime_End">
`ReadTime`&lt;=#ActivityQueryForm.ReadTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.ProcessTime_Start">
`ProcessTime`&gt;=#ActivityQueryForm.ProcessTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.ProcessTime_End">
`ProcessTime`&lt;=#ActivityQueryForm.ProcessTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.LastUpdateTime_Start">
`LastUpdateTime`&gt;=#ActivityQueryForm.LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.LastUpdateTime_End">
`LastUpdateTime`&lt;=#ActivityQueryForm.LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.LastUpdator">
`LastUpdator`=#ActivityQueryForm.LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="ActivityQueryForm.Title">
`Title`=#ActivityQueryForm.Title#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteActivity" parameterClass="ActivityQueryForm">
DELETE FROM `Activity` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Page">
`Page`=#Page#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="Status">
`Status`=#Status#
</isNotNull>
<isNotNull prepend="AND" property="ReadTime_Start">
`ReadTime`&gt;=#ReadTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ReadTime_End">
`ReadTime`&lt;=#ReadTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ProcessTime_Start">
`ProcessTime`&gt;=#ProcessTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ProcessTime_End">
`ProcessTime`&lt;=#ProcessTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Title">
`Title`=#Title#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</delete>
<select id="QueryActivityLastUpdateTime" resultClass="DateTime">
SELECT MAX(LastUpdateTime) AS LastUpdateTime FROM `Activity`
</select>
<select id="QueryActivityRecordCount" resultClass="int" parameterClass="ActivityQueryForm">
SELECT COUNT(*) FROM `Activity`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Page">
`Page`=#Page#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="Status">
`Status`=#Status#
</isNotNull>
<isNotNull prepend="AND" property="ReadTime_Start">
`ReadTime`&gt;=#ReadTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ReadTime_End">
`ReadTime`&lt;=#ReadTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ProcessTime_Start">
`ProcessTime`&gt;=#ProcessTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ProcessTime_End">
`ProcessTime`&lt;=#ProcessTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Title">
`Title`=#Title#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
303 source/background/RiskMgr/Bin/SqlMapping/ActivityAuth.xml
View file
@@ -0,0 +1,303 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="ActivityAuth" type="DreamWorkflow.Engine.Model.ActivityAuth" />
<typeAlias alias="ActivityAuthQueryForm" type="DreamWorkflow.Engine.Form.ActivityAuthQueryForm" />
<typeAlias alias="ActivityAuthUpdateForm" type="DreamWorkflow.Engine.Form.ActivityAuthUpdateForm" />
</alias>
<statements>
<select id="QueryActivityAuth" resultClass="ActivityAuth" parameterClass="ActivityAuthQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `ActivityAuth`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionID">
`ActivityAuthDefinitionID`=#ActivityAuthDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Value">
`Value`=#Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityID">
`ActivityID`=#ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
ORDER BY LastUpdateTime DESC
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddActivityAuth" parameterClass="ActivityAuth">
INSERT INTO `ActivityAuth`
(
`ID`,
`Name`,
`Creator`,
`CreateTime`,
`ActivityAuthDefinitionID`,
`Type`,
`Value`,
`ActivityID`,
`WorkflowID`,
`LastUpdateTime`,
`LastUpdator`
)
VALUES
(
#ID#,
#Name#,
#Creator#,
#CreateTime#,
#ActivityAuthDefinitionID#,
#Type#,
#Value#,
#ActivityID#,
#WorkflowID#,
#LastUpdateTime#,
#LastUpdator#
)
</insert>
<update id="UpdateActivityAuth" parameterClass="ActivityAuthUpdateForm">
UPDATE `ActivityAuth`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.Name">
`Name`=#Entity.Name#
</isNotNull>
<isNotNull prepend="," property="Entity.Creator">
`Creator`=#Entity.Creator#
</isNotNull>
<isNotNull prepend="," property="Entity.CreateTime">
`CreateTime`=#Entity.CreateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.ActivityAuthDefinitionID">
`ActivityAuthDefinitionID`=#Entity.ActivityAuthDefinitionID#
</isNotNull>
<isNotNull prepend="," property="Entity.Type">
`Type`=#Entity.Type#
</isNotNull>
<isNotNull prepend="," property="Entity.Value">
`Value`=#Entity.Value#
</isNotNull>
<isNotNull prepend="," property="Entity.ActivityID">
`ActivityID`=#Entity.ActivityID#
</isNotNull>
<isNotNull prepend="," property="Entity.WorkflowID">
`WorkflowID`=#Entity.WorkflowID#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdateTime">
`LastUpdateTime`=#Entity.LastUpdateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdator">
`LastUpdator`=#Entity.LastUpdator#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ActivityAuthQueryForm.ID">
`ID`=#ActivityAuthQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.Name">
`Name`=#ActivityAuthQueryForm.Name#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.Creator">
`Creator`=#ActivityAuthQueryForm.Creator#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.CreateTime_Start">
`CreateTime`&gt;=#ActivityAuthQueryForm.CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.CreateTime_End">
`CreateTime`&lt;=#ActivityAuthQueryForm.CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.ActivityAuthDefinitionID">
`ActivityAuthDefinitionID`=#ActivityAuthQueryForm.ActivityAuthDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.Type">
`Type`=#ActivityAuthQueryForm.Type#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.Value">
`Value`=#ActivityAuthQueryForm.Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.ActivityID">
`ActivityID`=#ActivityAuthQueryForm.ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.WorkflowID">
`WorkflowID`=#ActivityAuthQueryForm.WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.LastUpdateTime_Start">
`LastUpdateTime`&gt;=#ActivityAuthQueryForm.LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.LastUpdateTime_End">
`LastUpdateTime`&lt;=#ActivityAuthQueryForm.LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthQueryForm.LastUpdator">
`LastUpdator`=#ActivityAuthQueryForm.LastUpdator#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteActivityAuth" parameterClass="ActivityAuthQueryForm">
DELETE FROM `ActivityAuth` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionID">
`ActivityAuthDefinitionID`=#ActivityAuthDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Value">
`Value`=#Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityID">
`ActivityID`=#ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</delete>
<select id="QueryActivityAuthLastUpdateTime" resultClass="DateTime">
SELECT MAX(LastUpdateTime) AS LastUpdateTime FROM `ActivityAuth`
</select>
<select id="QueryActivityAuthRecordCount" resultClass="int" parameterClass="ActivityAuthQueryForm">
SELECT COUNT(*) FROM `ActivityAuth`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionID">
`ActivityAuthDefinitionID`=#ActivityAuthDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Value">
`Value`=#Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityID">
`ActivityID`=#ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
288 source/background/RiskMgr/Bin/SqlMapping/ActivityAuthDefinition.xml
View file
@@ -0,0 +1,288 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="ActivityAuthDefinition" type="DreamWorkflow.Engine.Model.ActivityAuthDefinition" />
<typeAlias alias="ActivityAuthDefinitionQueryForm" type="DreamWorkflow.Engine.Form.ActivityAuthDefinitionQueryForm" />
<typeAlias alias="ActivityAuthDefinitionUpdateForm" type="DreamWorkflow.Engine.Form.ActivityAuthDefinitionUpdateForm" />
</alias>
<statements>
<select id="QueryActivityAuthDefinition" resultClass="ActivityAuthDefinition" parameterClass="ActivityAuthDefinitionQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `ActivityAuthDefinition`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Value">
`Value`=#Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowDefinitionID">
`WorkflowDefinitionID`=#WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="IsDeleted">
`IsDeleted`=#IsDeleted#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
ORDER BY LastUpdateTime DESC
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddActivityAuthDefinition" parameterClass="ActivityAuthDefinition">
INSERT INTO `ActivityAuthDefinition`
(
`ID`,
`Name`,
`Creator`,
`CreateTime`,
`Type`,
`Value`,
`ActivityDefinitionID`,
`WorkflowDefinitionID`,
`LastUpdateTime`,
`LastUpdator`,
`IsDeleted`
)
VALUES
(
#ID#,
#Name#,
#Creator#,
#CreateTime#,
#Type#,
#Value#,
#ActivityDefinitionID#,
#WorkflowDefinitionID#,
#LastUpdateTime#,
#LastUpdator#,
#IsDeleted#
)
</insert>
<update id="UpdateActivityAuthDefinition" parameterClass="ActivityAuthDefinitionUpdateForm">
UPDATE `ActivityAuthDefinition`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.Name">
`Name`=#Entity.Name#
</isNotNull>
<isNotNull prepend="," property="Entity.Creator">
`Creator`=#Entity.Creator#
</isNotNull>
<isNotNull prepend="," property="Entity.CreateTime">
`CreateTime`=#Entity.CreateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.Type">
`Type`=#Entity.Type#
</isNotNull>
<isNotNull prepend="," property="Entity.Value">
`Value`=#Entity.Value#
</isNotNull>
<isNotNull prepend="," property="Entity.ActivityDefinitionID">
`ActivityDefinitionID`=#Entity.ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="," property="Entity.WorkflowDefinitionID">
`WorkflowDefinitionID`=#Entity.WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdateTime">
`LastUpdateTime`=#Entity.LastUpdateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdator">
`LastUpdator`=#Entity.LastUpdator#
</isNotNull>
<isNotNull prepend="," property="Entity.IsDeleted">
`IsDeleted`=#Entity.IsDeleted#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.ID">
`ID`=#ActivityAuthDefinitionQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.Name">
`Name`=#ActivityAuthDefinitionQueryForm.Name#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.Creator">
`Creator`=#ActivityAuthDefinitionQueryForm.Creator#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.CreateTime_Start">
`CreateTime`&gt;=#ActivityAuthDefinitionQueryForm.CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.CreateTime_End">
`CreateTime`&lt;=#ActivityAuthDefinitionQueryForm.CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.Type">
`Type`=#ActivityAuthDefinitionQueryForm.Type#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.Value">
`Value`=#ActivityAuthDefinitionQueryForm.Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityAuthDefinitionQueryForm.ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.WorkflowDefinitionID">
`WorkflowDefinitionID`=#ActivityAuthDefinitionQueryForm.WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.LastUpdateTime_Start">
`LastUpdateTime`&gt;=#ActivityAuthDefinitionQueryForm.LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.LastUpdateTime_End">
`LastUpdateTime`&lt;=#ActivityAuthDefinitionQueryForm.LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.LastUpdator">
`LastUpdator`=#ActivityAuthDefinitionQueryForm.LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="ActivityAuthDefinitionQueryForm.IsDeleted">
`IsDeleted`=#ActivityAuthDefinitionQueryForm.IsDeleted#
</isNotNull>
</dynamic>
</update>
<update id="DeleteActivityAuthDefinition" parameterClass="ActivityAuthDefinitionQueryForm">
UPDATE `ActivityAuthDefinition` SET IsDelete=1 WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Value">
`Value`=#Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowDefinitionID">
`WorkflowDefinitionID`=#WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="IsDeleted">
`IsDeleted`=#IsDeleted#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</update>
<select id="QueryActivityAuthDefinitionLastUpdateTime" resultClass="DateTime">
SELECT MAX(LastUpdateTime) AS LastUpdateTime FROM `ActivityAuthDefinition`
</select>
<select id="QueryActivityAuthDefinitionRecordCount" resultClass="int" parameterClass="ActivityAuthDefinitionQueryForm">
SELECT COUNT(*) FROM `ActivityAuthDefinition`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Value">
`Value`=#Value#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionID">
`ActivityDefinitionID`=#ActivityDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowDefinitionID">
`WorkflowDefinitionID`=#WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="IsDeleted">
`IsDeleted`=#IsDeleted#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
322 source/background/RiskMgr/Bin/SqlMapping/ActivityDefinition.xml
View file
@@ -0,0 +1,322 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="ActivityDefinition" type="DreamWorkflow.Engine.Model.ActivityDefinition" />
<typeAlias alias="ActivityDefinitionQueryForm" type="DreamWorkflow.Engine.Form.ActivityDefinitionQueryForm" />
<typeAlias alias="ActivityDefinitionUpdateForm" type="DreamWorkflow.Engine.Form.ActivityDefinitionUpdateForm" />
</alias>
<statements>
<select id="QueryActivityDefinition" resultClass="ActivityDefinition" parameterClass="ActivityDefinitionQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `ActivityDefinition`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowDefinitionID">
`WorkflowDefinitionID`=#WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Page">
`Page`=#Page#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Enabled">
`Enabled`=#Enabled#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Remark">
`Remark` LIKE '%$Remark$%'
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Title">
`Title`=#Title#
</isNotNull>
<isNotNull prepend="AND" property="IsDeleted">
`IsDeleted`=#IsDeleted#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
ORDER BY LastUpdateTime DESC
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddActivityDefinition" parameterClass="ActivityDefinition">
INSERT INTO `ActivityDefinition`
(
`ID`,
`WorkflowDefinitionID`,
`Page`,
`Name`,
`Enabled`,
`Type`,
`Creator`,
`CreateTime`,
`Remark`,
`LastUpdateTime`,
`LastUpdator`,
`Title`,
`IsDeleted`
)
VALUES
(
#ID#,
#WorkflowDefinitionID#,
#Page#,
#Name#,
#Enabled#,
#Type#,
#Creator#,
#CreateTime#,
#Remark#,
#LastUpdateTime#,
#LastUpdator#,
#Title#,
#IsDeleted#
)
</insert>
<update id="UpdateActivityDefinition" parameterClass="ActivityDefinitionUpdateForm">
UPDATE `ActivityDefinition`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.WorkflowDefinitionID">
`WorkflowDefinitionID`=#Entity.WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="," property="Entity.Page">
`Page`=#Entity.Page#
</isNotNull>
<isNotNull prepend="," property="Entity.Name">
`Name`=#Entity.Name#
</isNotNull>
<isNotNull prepend="," property="Entity.Enabled">
`Enabled`=#Entity.Enabled#
</isNotNull>
<isNotNull prepend="," property="Entity.Type">
`Type`=#Entity.Type#
</isNotNull>
<isNotNull prepend="," property="Entity.Creator">
`Creator`=#Entity.Creator#
</isNotNull>
<isNotNull prepend="," property="Entity.CreateTime">
`CreateTime`=#Entity.CreateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.Remark">
`Remark`=#Entity.Remark#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdateTime">
`LastUpdateTime`=#Entity.LastUpdateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdator">
`LastUpdator`=#Entity.LastUpdator#
</isNotNull>
<isNotNull prepend="," property="Entity.Title">
`Title`=#Entity.Title#
</isNotNull>
<isNotNull prepend="," property="Entity.IsDeleted">
`IsDeleted`=#Entity.IsDeleted#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.ID">
`ID`=#ActivityDefinitionQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.WorkflowDefinitionID">
`WorkflowDefinitionID`=#ActivityDefinitionQueryForm.WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.Page">
`Page`=#ActivityDefinitionQueryForm.Page#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.Name">
`Name`=#ActivityDefinitionQueryForm.Name#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.Enabled">
`Enabled`=#ActivityDefinitionQueryForm.Enabled#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.Type">
`Type`=#ActivityDefinitionQueryForm.Type#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.Creator">
`Creator`=#ActivityDefinitionQueryForm.Creator#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.CreateTime_Start">
`CreateTime`&gt;=#ActivityDefinitionQueryForm.CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.CreateTime_End">
`CreateTime`&lt;=#ActivityDefinitionQueryForm.CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.Remark">
`Remark` LIKE '%$ActivityDefinitionQueryForm.Remark$%'
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.LastUpdateTime_Start">
`LastUpdateTime`&gt;=#ActivityDefinitionQueryForm.LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.LastUpdateTime_End">
`LastUpdateTime`&lt;=#ActivityDefinitionQueryForm.LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.LastUpdator">
`LastUpdator`=#ActivityDefinitionQueryForm.LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.Title">
`Title`=#ActivityDefinitionQueryForm.Title#
</isNotNull>
<isNotNull prepend="AND" property="ActivityDefinitionQueryForm.IsDeleted">
`IsDeleted`=#ActivityDefinitionQueryForm.IsDeleted#
</isNotNull>
</dynamic>
</update>
<update id="DeleteActivityDefinition" parameterClass="ActivityDefinitionQueryForm">
UPDATE `ActivityDefinition` SET IsDelete=1 WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowDefinitionID">
`WorkflowDefinitionID`=#WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Page">
`Page`=#Page#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Enabled">
`Enabled`=#Enabled#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Remark">
`Remark`=#Remark#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Title">
`Title`=#Title#
</isNotNull>
<isNotNull prepend="AND" property="IsDeleted">
`IsDeleted`=#IsDeleted#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</update>
<select id="QueryActivityDefinitionLastUpdateTime" resultClass="DateTime">
SELECT MAX(LastUpdateTime) AS LastUpdateTime FROM `ActivityDefinition`
</select>
<select id="QueryActivityDefinitionRecordCount" resultClass="int" parameterClass="ActivityDefinitionQueryForm">
SELECT COUNT(*) FROM `ActivityDefinition`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowDefinitionID">
`WorkflowDefinitionID`=#WorkflowDefinitionID#
</isNotNull>
<isNotNull prepend="AND" property="Page">
`Page`=#Page#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="Enabled">
`Enabled`=#Enabled#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Remark">
`Remark` LIKE '%$Remark$%'
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Title">
`Title`=#Title#
</isNotNull>
<isNotNull prepend="AND" property="IsDeleted">
`IsDeleted`=#IsDeleted#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
286 source/background/RiskMgr/Bin/SqlMapping/Approval.xml
View file
@@ -0,0 +1,286 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Approval" type="DreamWorkflow.Engine.Model.Approval" />
<typeAlias alias="ApprovalQueryForm" type="DreamWorkflow.Engine.Form.ApprovalQueryForm" />
<typeAlias alias="ApprovalUpdateForm" type="DreamWorkflow.Engine.Form.ApprovalUpdateForm" />
</alias>
<statements>
<select id="QueryApproval" resultClass="Approval" parameterClass="ApprovalQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `Approval`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityID">
`ActivityID`=#ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="Status">
`Status`=#Status#
</isNotNull>
<isNotNull prepend="AND" property="Remark">
`Remark` LIKE '%$Remark$%'
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
ORDER BY LastUpdateTime DESC
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddApproval" parameterClass="Approval">
INSERT INTO `Approval`
(
`ID`,
`ActivityID`,
`Status`,
`Remark`,
`Creator`,
`CreateTime`,
`WorkflowID`,
`Type`,
`LastUpdateTime`,
`LastUpdator`
)
VALUES
(
#ID#,
#ActivityID#,
#Status#,
#Remark#,
#Creator#,
#CreateTime#,
#WorkflowID#,
#Type#,
#LastUpdateTime#,
#LastUpdator#
)
</insert>
<update id="UpdateApproval" parameterClass="ApprovalUpdateForm">
UPDATE `Approval`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.ActivityID">
`ActivityID`=#Entity.ActivityID#
</isNotNull>
<isNotNull prepend="," property="Entity.Status">
`Status`=#Entity.Status#
</isNotNull>
<isNotNull prepend="," property="Entity.Remark">
`Remark`=#Entity.Remark#
</isNotNull>
<isNotNull prepend="," property="Entity.Creator">
`Creator`=#Entity.Creator#
</isNotNull>
<isNotNull prepend="," property="Entity.CreateTime">
`CreateTime`=#Entity.CreateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.WorkflowID">
`WorkflowID`=#Entity.WorkflowID#
</isNotNull>
<isNotNull prepend="," property="Entity.Type">
`Type`=#Entity.Type#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdateTime">
`LastUpdateTime`=#Entity.LastUpdateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdator">
`LastUpdator`=#Entity.LastUpdator#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ApprovalQueryForm.ID">
`ID`=#ApprovalQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.ActivityID">
`ActivityID`=#ApprovalQueryForm.ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.Status">
`Status`=#ApprovalQueryForm.Status#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.Remark">
`Remark` LIKE '%$ApprovalQueryForm.Remark$%'
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.Creator">
`Creator`=#ApprovalQueryForm.Creator#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.CreateTime_Start">
`CreateTime`&gt;=#ApprovalQueryForm.CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.CreateTime_End">
`CreateTime`&lt;=#ApprovalQueryForm.CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.WorkflowID">
`WorkflowID`=#ApprovalQueryForm.WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.Type">
`Type`=#ApprovalQueryForm.Type#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.LastUpdateTime_Start">
`LastUpdateTime`&gt;=#ApprovalQueryForm.LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.LastUpdateTime_End">
`LastUpdateTime`&lt;=#ApprovalQueryForm.LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="ApprovalQueryForm.LastUpdator">
`LastUpdator`=#ApprovalQueryForm.LastUpdator#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteApproval" parameterClass="ApprovalQueryForm">
DELETE FROM `Approval` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityID">
`ActivityID`=#ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="Status">
`Status`=#Status#
</isNotNull>
<isNotNull prepend="AND" property="Remark">
`Remark`=#Remark#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</delete>
<select id="QueryApprovalLastUpdateTime" resultClass="DateTime">
SELECT MAX(LastUpdateTime) AS LastUpdateTime FROM `Approval`
</select>
<select id="QueryApprovalRecordCount" resultClass="int" parameterClass="ApprovalQueryForm">
SELECT COUNT(*) FROM `Approval`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="ActivityID">
`ActivityID`=#ActivityID#
</isNotNull>
<isNotNull prepend="AND" property="Status">
`Status`=#Status#
</isNotNull>
<isNotNull prepend="AND" property="Remark">
`Remark` LIKE '%$Remark$%'
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdator">
`LastUpdator`=#LastUpdator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
142 source/background/RiskMgr/Bin/SqlMapping/Asset_Project.xml
View file
@@ -0,0 +1,142 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Asset_Project" type="RiskMgr.Model.Asset_Project" />
<typeAlias alias="Asset_ProjectQueryForm" type="RiskMgr.Form.Asset_ProjectQueryForm" />
<typeAlias alias="Asset_ProjectUpdateForm" type="RiskMgr.Form.Asset_ProjectUpdateForm" />
</alias>
<statements>
<select id="QueryAsset_Project" resultClass="Asset_Project" parameterClass="Asset_ProjectQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `Asset_Project`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>

<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="AssetID">
`AssetID`=#AssetID#
</isNotNull>

<isNotNull prepend="AND" property="AssetIDs">
<iterate property="AssetIDs" open="(" close=")" conjunction="OR">
`AssetID`=#AssetIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>

<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
</dynamic>
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddAsset_Project" parameterClass="Asset_Project">
INSERT INTO `Asset_Project`
(
`ID`,
`AssetID`,
`ProjectID`
)
VALUES
(
#ID#,
#AssetID#,
#ProjectID#
)
</insert>
<update id="UpdateAsset_Project" parameterClass="Asset_ProjectUpdateForm">
UPDATE `Asset_Project`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.AssetID">
`AssetID`=#Entity.AssetID#
</isNotNull>
<isNotNull prepend="," property="Entity.ProjectID">
`ProjectID`=#Entity.ProjectID#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="Asset_ProjectQueryForm.ID">
`ID`=#Asset_ProjectQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="Asset_ProjectQueryForm.AssetID">
`AssetID`=#Asset_ProjectQueryForm.AssetID#
</isNotNull>
<isNotNull prepend="AND" property="Asset_ProjectQueryForm.ProjectID">
`ProjectID`=#Asset_ProjectQueryForm.ProjectID#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteAsset_Project" parameterClass="Asset_ProjectQueryForm">
DELETE FROM `Asset_Project` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="AssetID">
`AssetID`=#AssetID#
</isNotNull>
<isNotNull prepend="AND" property="AssetIDs">
<iterate property="AssetIDs" open="(" close=")" conjunction="OR">
`AssetID`=#AssetIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>
<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
</delete>
<select id="QueryAsset_ProjectRecordCount" resultClass="int" parameterClass="Asset_ProjectQueryForm">
SELECT COUNT(*) FROM `Asset_Project`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="AssetID">
`AssetID`=#AssetID#
</isNotNull>
<isNotNull prepend="AND" property="AssetIDs">
<iterate property="AssetIDs" open="(" close=")" conjunction="OR">
`AssetID`=#AssetIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>
<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
263 source/background/RiskMgr/Bin/SqlMapping/BankAccount.xml
View file
@@ -0,0 +1,263 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="BankAccount" type="RiskMgr.Model.BankAccount" />
<typeAlias alias="BankAccountQueryForm" type="RiskMgr.Form.BankAccountQueryForm" />
<typeAlias alias="BankAccountUpdateForm" type="RiskMgr.Form.BankAccountUpdateForm" />
</alias>
<statements>
<select id="QueryBankAccount" resultClass="BankAccount" parameterClass="BankAccountQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `BankAccount`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>

<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="BankType">
`BankType`=#BankType#
</isNotNull>

<isNotNull prepend="AND" property="BankName">
`BankName`=#BankName#
</isNotNull>

<isNotNull prepend="AND" property="BankAccountCode">
`BankAccountCode`=#BankAccountCode#
</isNotNull>

<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>

<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>

<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>

<isNotNull prepend="AND" property="LastUpdater">
`LastUpdater`=#LastUpdater#
</isNotNull>

<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>

</dynamic>
ORDER BY LastUpdateTime DESC
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddBankAccount" parameterClass="BankAccount">
INSERT INTO `BankAccount`
(
`ID`,
`BankType`,
`BankName`,
`BankAccountCode`,
`Creator`,
`CreateTime`,
`Name`,
`LastUpdater`,
`LastUpdateTime`
)
VALUES
(
#ID#,
#BankType#,
#BankName#,
#BankAccountCode#,
#Creator#,
#CreateTime#,
#Name#,
#LastUpdater#,
#LastUpdateTime#
)
</insert>
<update id="UpdateBankAccount" parameterClass="BankAccountUpdateForm">
UPDATE `BankAccount`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.BankType">
`BankType`=#Entity.BankType#
</isNotNull>
<isNotNull prepend="," property="Entity.BankName">
`BankName`=#Entity.BankName#
</isNotNull>
<isNotNull prepend="," property="Entity.BankAccountCode">
`BankAccountCode`=#Entity.BankAccountCode#
</isNotNull>
<isNotNull prepend="," property="Entity.Creator">
`Creator`=#Entity.Creator#
</isNotNull>
<isNotNull prepend="," property="Entity.CreateTime">
`CreateTime`=#Entity.CreateTime#
</isNotNull>
<isNotNull prepend="," property="Entity.Name">
`Name`=#Entity.Name#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdater">
`LastUpdater`=#Entity.LastUpdater#
</isNotNull>
<isNotNull prepend="," property="Entity.LastUpdateTime">
`LastUpdateTime`=#Entity.LastUpdateTime#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="BankAccountQueryForm.ID">
`ID`=#BankAccountQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.BankType">
`BankType`=#BankAccountQueryForm.BankType#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.BankName">
`BankName`=#BankAccountQueryForm.BankName#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.BankAccountCode">
`BankAccountCode`=#BankAccountQueryForm.BankAccountCode#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.Creator">
`Creator`=#BankAccountQueryForm.Creator#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.CreateTime_Start">
`CreateTime`&gt;=#BankAccountQueryForm.CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.CreateTime_End">
`CreateTime`&lt;=#BankAccountQueryForm.CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.Name">
`Name`=#BankAccountQueryForm.Name#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.LastUpdater">
`LastUpdater`=#BankAccountQueryForm.LastUpdater#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.LastUpdateTime_Start">
`LastUpdateTime`&gt;=#BankAccountQueryForm.LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountQueryForm.LastUpdateTime_End">
`LastUpdateTime`&lt;=#BankAccountQueryForm.LastUpdateTime_End#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteBankAccount" parameterClass="BankAccountQueryForm">
DELETE FROM `BankAccount` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="BankType">
`BankType`=#BankType#
</isNotNull>
<isNotNull prepend="AND" property="BankName">
`BankName`=#BankName#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountCode">
`BankAccountCode`=#BankAccountCode#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdater">
`LastUpdater`=#LastUpdater#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
</delete>
<select id="QueryBankAccountLastUpdateTime" resultClass="DateTime">
SELECT MAX(LastUpdateTime) AS LastUpdateTime FROM `BankAccount`
</select>
<select id="QueryBankAccountRecordCount" resultClass="int" parameterClass="BankAccountQueryForm">
SELECT COUNT(*) FROM `BankAccount`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="BankType">
`BankType`=#BankType#
</isNotNull>
<isNotNull prepend="AND" property="BankName">
`BankName`=#BankName#
</isNotNull>
<isNotNull prepend="AND" property="BankAccountCode">
`BankAccountCode`=#BankAccountCode#
</isNotNull>
<isNotNull prepend="AND" property="Creator">
`Creator`=#Creator#
</isNotNull>
<isNotNull prepend="AND" property="Creators">
<iterate property="Creators" open="(" close=")" conjunction="OR">
`Creator`=#Creators[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_Start">
`CreateTime`&gt;=#CreateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="CreateTime_End">
`CreateTime`&lt;=#CreateTime_End#
</isNotNull>
<isNotNull prepend="AND" property="Name">
`Name`=#Name#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdater">
`LastUpdater`=#LastUpdater#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_Start">
`LastUpdateTime`&gt;=#LastUpdateTime_Start#
</isNotNull>
<isNotNull prepend="AND" property="LastUpdateTime_End">
`LastUpdateTime`&lt;=#LastUpdateTime_End#
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
107 source/background/RiskMgr/Bin/SqlMapping/Context.xml
View file
@@ -0,0 +1,107 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Context" type="DreamWorkflow.Engine.Model.Context" />
<typeAlias alias="ContextQueryForm" type="DreamWorkflow.Engine.Form.ContextQueryForm" />
<typeAlias alias="ContextUpdateForm" type="DreamWorkflow.Engine.Form.ContextUpdateForm" />
</alias>
<statements>
<select id="QueryContext" resultClass="Context" parameterClass="ContextQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `Context`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddContext" parameterClass="Context">
INSERT INTO `Context`
(
`ID`,
`WorkflowID`
)
VALUES
(
#ID#,
#WorkflowID#
)
</insert>
<update id="UpdateContext" parameterClass="ContextUpdateForm">
UPDATE `Context`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.WorkflowID">
`WorkflowID`=#Entity.WorkflowID#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ContextQueryForm.ID">
`ID`=#ContextQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="ContextQueryForm.WorkflowID">
`WorkflowID`=#ContextQueryForm.WorkflowID#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteContext" parameterClass="ContextQueryForm">
DELETE FROM `Context` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</delete>
<select id="QueryContextRecordCount" resultClass="int" parameterClass="ContextQueryForm">
SELECT COUNT(*) FROM `Context`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowID">
`WorkflowID`=#WorkflowID#
</isNotNull>
<isNotNull prepend="AND" property="WorkflowIDs">
<iterate property="WorkflowIDs" open="(" close=")" conjunction="OR">
`WorkflowID`=#WorkflowIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
193 source/background/RiskMgr/Bin/SqlMapping/Customer_Asset.xml
View file
@@ -0,0 +1,193 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Customer_Asset" type="RiskMgr.Model.Customer_Asset" />
<typeAlias alias="Customer_AssetQueryForm" type="RiskMgr.Form.Customer_AssetQueryForm" />
<typeAlias alias="Customer_AssetUpdateForm" type="RiskMgr.Form.Customer_AssetUpdateForm" />
</alias>
<statements>
<select id="QueryCustomer_Asset" resultClass="Customer_Asset" parameterClass="Customer_AssetQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `Customer_Asset`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>

<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CustomerID">
`CustomerID`=#CustomerID#
</isNotNull>

<isNotNull prepend="AND" property="CustomerIDs">
<iterate property="CustomerIDs" open="(" close=")" conjunction="OR">
`CustomerID`=#CustomerIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="AssetID">
`AssetID`=#AssetID#
</isNotNull>

<isNotNull prepend="AND" property="AssetIDs">
<iterate property="AssetIDs" open="(" close=")" conjunction="OR">
`AssetID`=#AssetIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>

<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>

<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
</dynamic>
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddCustomer_Asset" parameterClass="Customer_Asset">
INSERT INTO `Customer_Asset`
(
`ID`,
`CustomerID`,
`AssetID`,
`Type`,
`ProjectID`
)
VALUES
(
#ID#,
#CustomerID#,
#AssetID#,
#Type#,
#ProjectID#
)
</insert>
<update id="UpdateCustomer_Asset" parameterClass="Customer_AssetUpdateForm">
UPDATE `Customer_Asset`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.CustomerID">
`CustomerID`=#Entity.CustomerID#
</isNotNull>
<isNotNull prepend="," property="Entity.AssetID">
`AssetID`=#Entity.AssetID#
</isNotNull>
<isNotNull prepend="," property="Entity.Type">
`Type`=#Entity.Type#
</isNotNull>
<isNotNull prepend="," property="Entity.ProjectID">
`ProjectID`=#Entity.ProjectID#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="Customer_AssetQueryForm.ID">
`ID`=#Customer_AssetQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="Customer_AssetQueryForm.CustomerID">
`CustomerID`=#Customer_AssetQueryForm.CustomerID#
</isNotNull>
<isNotNull prepend="AND" property="Customer_AssetQueryForm.AssetID">
`AssetID`=#Customer_AssetQueryForm.AssetID#
</isNotNull>
<isNotNull prepend="AND" property="Customer_AssetQueryForm.Type">
`Type`=#Customer_AssetQueryForm.Type#
</isNotNull>
<isNotNull prepend="AND" property="Customer_AssetQueryForm.ProjectID">
`ProjectID`=#Customer_AssetQueryForm.ProjectID#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteCustomer_Asset" parameterClass="Customer_AssetQueryForm">
DELETE FROM `Customer_Asset` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CustomerID">
`CustomerID`=#CustomerID#
</isNotNull>
<isNotNull prepend="AND" property="CustomerIDs">
<iterate property="CustomerIDs" open="(" close=")" conjunction="OR">
`CustomerID`=#CustomerIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="AssetID">
`AssetID`=#AssetID#
</isNotNull>
<isNotNull prepend="AND" property="AssetIDs">
<iterate property="AssetIDs" open="(" close=")" conjunction="OR">
`AssetID`=#AssetIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>
<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
</delete>
<select id="QueryCustomer_AssetRecordCount" resultClass="int" parameterClass="Customer_AssetQueryForm">
SELECT COUNT(*) FROM `Customer_Asset`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CustomerID">
`CustomerID`=#CustomerID#
</isNotNull>
<isNotNull prepend="AND" property="CustomerIDs">
<iterate property="CustomerIDs" open="(" close=")" conjunction="OR">
`CustomerID`=#CustomerIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="AssetID">
`AssetID`=#AssetID#
</isNotNull>
<isNotNull prepend="AND" property="AssetIDs">
<iterate property="AssetIDs" open="(" close=")" conjunction="OR">
`AssetID`=#AssetIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>
<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
160 source/background/RiskMgr/Bin/SqlMapping/Customer_Project.xml
View file
@@ -0,0 +1,160 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Customer_Project" type="RiskMgr.Model.Customer_Project" />
<typeAlias alias="Customer_ProjectQueryForm" type="RiskMgr.Form.Customer_ProjectQueryForm" />
<typeAlias alias="Customer_ProjectUpdateForm" type="RiskMgr.Form.Customer_ProjectUpdateForm" />
</alias>
<statements>
<select id="QueryCustomer_Project" resultClass="Customer_Project" parameterClass="Customer_ProjectQueryForm">
<isGreaterThan compareProperty="PageSize" compareValue="0">

</isGreaterThan>
SELECT * FROM `Customer_Project`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>

<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CustomerID">
`CustomerID`=#CustomerID#
</isNotNull>

<isNotNull prepend="AND" property="CustomerIDs">
<iterate property="CustomerIDs" open="(" close=")" conjunction="OR">
`CustomerID`=#CustomerIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>

<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>

</dynamic>
<isNotNull property="PageSize">
<isGreaterThan property="PageSize" compareValue="0">
LIMIT #StartIndex#, #PageSize#
</isGreaterThan>
</isNotNull>
</select>
<insert id="AddCustomer_Project" parameterClass="Customer_Project">
INSERT INTO `Customer_Project`
(
`ID`,
`CustomerID`,
`ProjectID`,
`Type`
)
VALUES
(
#ID#,
#CustomerID#,
#ProjectID#,
#Type#
)
</insert>
<update id="UpdateCustomer_Project" parameterClass="Customer_ProjectUpdateForm">
UPDATE `Customer_Project`
<dynamic prepend="SET">
<isNotNull prepend="," property="Entity.CustomerID">
`CustomerID`=#Entity.CustomerID#
</isNotNull>
<isNotNull prepend="," property="Entity.ProjectID">
`ProjectID`=#Entity.ProjectID#
</isNotNull>
<isNotNull prepend="," property="Entity.Type">
`Type`=#Entity.Type#
</isNotNull>
</dynamic>
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="Customer_ProjectQueryForm.ID">
`ID`=#Customer_ProjectQueryForm.ID#
</isNotNull>
<isNotNull prepend="AND" property="Customer_ProjectQueryForm.CustomerID">
`CustomerID`=#Customer_ProjectQueryForm.CustomerID#
</isNotNull>
<isNotNull prepend="AND" property="Customer_ProjectQueryForm.ProjectID">
`ProjectID`=#Customer_ProjectQueryForm.ProjectID#
</isNotNull>
<isNotNull prepend="AND" property="Customer_ProjectQueryForm.Type">
`Type`=#Customer_ProjectQueryForm.Type#
</isNotNull>
</dynamic>
</update>
<delete id="DeleteCustomer_Project" parameterClass="Customer_ProjectQueryForm">
DELETE FROM `Customer_Project` WHERE 1=1
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CustomerID">
`CustomerID`=#CustomerID#
</isNotNull>
<isNotNull prepend="AND" property="CustomerIDs">
<iterate property="CustomerIDs" open="(" close=")" conjunction="OR">
`CustomerID`=#CustomerIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>
<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
</delete>
<select id="QueryCustomer_ProjectRecordCount" resultClass="int" parameterClass="Customer_ProjectQueryForm">
SELECT COUNT(*) FROM `Customer_Project`
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
`ID`=#ID#
</isNotNull>
<isNotNull prepend="AND" property="IDs">
<iterate property="IDs" open="(" close=")" conjunction="OR">
`ID`=#IDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="CustomerID">
`CustomerID`=#CustomerID#
</isNotNull>
<isNotNull prepend="AND" property="CustomerIDs">
<iterate property="CustomerIDs" open="(" close=")" conjunction="OR">
`CustomerID`=#CustomerIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="ProjectID">
`ProjectID`=#ProjectID#
</isNotNull>
<isNotNull prepend="AND" property="ProjectIDs">
<iterate property="ProjectIDs" open="(" close=")" conjunction="OR">
`ProjectID`=#ProjectIDs[]#
</iterate>
</isNotNull>
<isNotNull prepend="AND" property="Type">
`Type`=#Type#
</isNotNull>
</dynamic>
</select>
</statements>
</sqlMap>
15 source/background/RiskMgr/Bin/SqlMapping/Customer_ex.xml
View file
@@ -0,0 +1,15 @@
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="post" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="FullTask" type="RiskMgr.Model.FullTask" />
</alias>
<statements>
<select id="CheckIdentityCodeExists" resultClass="FullTask" parameterClass="CustomerQueryForm">
SELECT * FROM Customer WHERE IdentityCode=#IdentityCode# AND Enabled=1

<isNotNull prepend="AND" property="ID">
ID!=#ID#
</isNotNull>
</select>
</statements>
</sqlMap>