【ssi】增删改查六操作小框架（十）

迷南。 2022-01-15 14:25 207阅读 0赞

## （六）BLPunishment.xml ##

< sql id ="queryById.selectSql" >  
select p.punishid, p.projectcode, p.dispatchunit,p.dispatchdate,p.penaltynumber,p.unitsprovided,p.creater,p.createdate,p.punishmenttype,p.externalpunishmenttype,p.punishmentsource,p.punishmentsubject,p.regulatorysource,p.regulatorybody,p.regulatoryoccurrencetime,p.supervisionnumber,p.updatedate,p.updater,p.remark,p.flag,p.companyseries,p.auditmain,p.koanumber,p.ishavafile from t\_atip\_punishment p WHERE p.punishmenttype=\#punishmentType\# and p.punishId = \#punishId\#  
</ sql >  
  
  
< select id ="innerPunish.queryById" parameterClass ="innerPunishment" resultClass ="innerPunishment" >  
< include refid ="queryById.selectSql" />  
</ select >  
  
  
< select id ="innerPunish.querySubByPunishID" parameterClass ="BLPunishment" resultClass ="BLPunishmentSub" >  
select sub.PUNISHID,sub.PUNISHMENTID,sub.PUNISHEDUNIT,sub.MAINPROBLEM,sub.INVOLVESAMOUNT,sub.FINEAMOUNT,sub.DISCIPLINE,sub.ORGANIZATIONPROCESSING,sub.ECONOMICSANCTIONS,sub.PUNISHMENTRESULTSNOTE,sub.ONETICKETVOTE,sub.ONETICKETVOTERESON,sub.RESPONSIBILITY,sub.PUNISHEDPEOPLE, sub.POSITION,sub.BEPUNISHEDPEOPLELEVEL from t\_atip\_punishment\_sub sub where sub.punishid = \#punishId\#  
</ select >  
  
  
< sql id ="innerPunish.queryPagedList.where" >  
< isNotEmpty property ="dispatchUnit" prepend ="and" >  
t.DISPATCHUNIT like '%$dispatchUnit$%'  
</ isNotEmpty >  
< isNotEmpty property ="dispatchDateStart" prepend ="and" >  
<!\[CDATA\[  
t.dispatchdate > date'$dispatchDateStart$'  
\]\]>  
</ isNotEmpty >  
< isNotEmpty property ="dispatchDateEnd" prepend ="and" >  
<!\[CDATA\[  
t.dispatchdate < date'$dispatchDateEnd$'  
\]\] >  
</ isNotEmpty >  
< isNotEmpty property ="penaltyNumber" prepend ="and" >  
t.penaltynumber like '%$penaltyNumber$%'  
</ isNotEmpty >  
< isNotEmpty property ="subParam" prepend ="and" >  
t.punishid in (select distinct ts.punishid from t\_atip\_punishment\_sub ts where 1=1  
< isNotEmpty property ="subParam.punishedUnit" prepend ="and" >  
ts.punishedunit like '%$subParam.punishedUnit$%'  
</ isNotEmpty >  
< isNotEmpty property ="subParam.punishedPeople" prepend ="and" >  
ts.punishedpeople like '%$subParam.punishedPeople$%'  
</ isNotEmpty >  
< isNotEmpty property ="subParam.discipline" prepend ="and" >  
ts.discipline =\#subParam.discipline\#  
</ isNotEmpty >  
< isNotEmpty property ="subParam.organizationProcessing"  
prepend ="and" >  
ts.organizationprocessing=\#subParam.organizationProcessing\#  
</ isNotEmpty >  
< isNotEmpty property ="subParam.economicSanctions" prepend ="and" >  
ts.economicsanctions =\#subParam.economicSanctions\#  
</ isNotEmpty >  
)  
</ isNotEmpty >  
</ sql >  
  
< sql id ="innerPunish.queryPagedList" >  
select t.punishid, t.dispatchUnit, t.dispatchdate,t.penaltynumber from t\_atip\_punishment t where t.punishmenttype ='01'  
< include refid ="innerPunish.queryPagedList.where" />  
</ sql >  
  
  
< select id ="innerPunish.queryTotalCount" parameterClass ="innerPunishment"  
resultClass ="java.lang.Integer" >  
select count(0) from t\_atip\_punishment t where t.punishmenttype ='01'  
< include refid ="innerPunish.queryPagedList.where" />  
</ select >

## （七）Struts\_admin.xml ##

< action name ="innerPunish\_\*" method ="\{1\}" class ="innerPunishmentAction" >  
< result name ="success" type ="json" />  
</ action >

转载于:https://blog.51cto.com/winters1224/1029937