dyDeliver/conf/sqlroot/com/dderp/business/dao/PaperDao.dql

-- [selectPaperBrand]
select * from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- isNotBlank keyWord
    brandName LIKE #{Like:keyWord}
  -- end
  -- isNotBlank voidFlag
     and voidFlag = #{voidFlag}
  -- end
-- end
;

-- [existPaperBrand]
select count(id) from $table$ where brandName = #{brandname} and voidFlag = 0;

-- [addPaperBrand]
insert into $table$ (id, brandName, companyName, voidFlag,
                     createBy, createTime, createTimeLong,
                     updateBy, updateTime, updateTimeLong ) values ( #{id}, #{brandname}, #{companyname}, #{voidflag},
                                                                     #{createby}, #{createtime}, #{createtimelong},
                                                                     #{updateby}, #{updatetime}, #{updatetimelong} );

-- [updatePaperBrand]
update $table$ set brandName = #{brandname},companyName = #{companyname},updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

-- [voidPaperBrand]
update $table$ set voidFlag = #{voidflag},updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};


-- [selectPaperInfoType]
select id, paperTypeName, voidFlag, paperCount,
paperTypeCode, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong from $table$;

-- [addPaperInfoType]
insert into $table$ (id, paperTypeName, voidFlag, paperCount,
paperTypeCode, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{papertypename}, #{voidflag}, #{papercount},
#{papertypecode}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updatePaperInfoType]
update $table$ set
paperTypeName = #{papertypename},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

-- [voidPaperInfoType]
update $table$ set voidFlag = #{voidflag},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};


-- [selectPaperBaseInfo]
select id, mtSuttle, idPaperType, paperTypeName,
paperInfoCode, paperName, priceType,sortNum,
paperPrice, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong from $table$;

-- [addPaperBaseInfo]
 insert into $table$ (id, mtSuttle, idPaperType, paperTypeName,
 paperInfoCode, paperName, priceType,
 paperPrice, voidFlag, createBy,code,sortNum,
 createTime, createTimeLong, updateBy,
 updateTime, updateTimeLong ) values ( #{id}, #{mtsuttle}, #{idpapertype}, #{papertypename},
 #{paperinfocode}, #{papername}, #{pricetype},
 #{paperprice}, #{voidflag}, #{createby},#{code},#{sortnum},
 #{createtime}, #{createtimelong}, #{updateby},
 #{updatetime}, #{updatetimelong} );

 -- [updatePaperBaseInfo]
 update $table$ set mtSuttle = #{mtsuttle},idPaperType = #{idpapertype},paperTypeName = #{papertypename},paperInfoCode = #{paperinfocode},
 paperName = #{papername},priceType = #{pricetype},paperPrice = #{paperprice},voidFlag = #{voidflag},sortNum = #{sortnum},
 updateBy = #{updateby},
 updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

 -- [voidPaperBaseInfo]
update $table$ set voidFlag = #{voidflag},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};

-- [savePaperBaseInfoPrice]
update $table$ set paperPrice = #{paperprice},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};

-- [selectPaperInfo]
select id, idPaperBaseInfo, mtRule, mtSuttle,
idPaperType, paperTypeName, mtModel,
paperName, byUnit, mtUnit,
seUnit, newestPrice, paperCode,
convertUnitByToMt, convertUnitMtToSe, voidFlag,
remark, barCode, paperPrice,
stockPrecision, priceType, createBy, updateBy from $table$;

-- [addPaperInfo]
insert into $table$ (id, mtRule, mtSuttle, idPaperType,idPaperBaseInfo,
paperTypeName, mtModel, paperName,
byUnit, mtUnit, seUnit,
newestPrice, paperCode, convertUnitByToMt,
convertUnitMtToSe, voidFlag, remark,stockPrecision,code,
barCode, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong,
priceType)
values (
#{id}, #{mtrule}, #{mtsuttle}, #{idpapertype},#{idpaperbaseinfo},
#{papertypename}, #{mtmodel}, #{papername},
#{byunit}, #{mtunit}, #{seunit},
#{newestprice}, #{papercode}, #{convertunitbytomt},
#{convertunitmttose}, #{voidflag}, #{remark},#{stockprecision},#{code},
#{barcode}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong},
#{pricetype});

-- [updatePaperInfo]
update $table$ set
--mtRule = #{mtrule},
--mtSuttle = #{mtsuttle},
--idPaperType = #{idpapertype},
--paperTypeName = #{papertypename},
--idPaperBaseInfo=#{idpaperbaseinfo},
--mtModel = #{mtmodel},
--paperName = #{papername},
--byUnit = #{byunit},
--mtUnit = #{mtunit},
--seUnit = #{seunit},
--newestPrice = #{newestprice},
--convertUnitByToMt = #{convertunitbytomt},
--convertUnitMtToSe = #{convertunitmttose},
remark = #{remark},
--barCode = #{barcode},
--stockPrecision = #{stockprecision},
--updateBy = #{updateby},
--updateTime = #{updatetime},
--updateTimeLong = #{updatetimelong},
priceType = #{pricetype}
where id = #{id};

-- [voidPaperInfo]
update $table$ set voidFlag = #{voidflag},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};

-- [savePaperInfoPrice]
update $table$ set paperPrice = #{paperprice},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};


-- [queryPaperCutInfo]
select * from $table$
order by cutCount;

-- [addPaperCutInfo]
       insert into $table$ (id, cutName, cutCount,
       createBy, createTime,
       updateBy, updateTime ) values ( #{id}, #{cutname}, #{cutcount},
#{createby}, #{createtime},
#{updateby}, #{updatetime} );

-- [updatePaperCutInfo]
       update $table$ set cutName = #{cutname},cutCount = #{cutcount},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};


-- [deletePaperCutInfo]
delete from $table$
where id = #{idCutInfo};

-- [queryPaperCutSizeInfo]
select * from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
 -- isNotEmpty idCutInfo
       idCutInfo = #{idCutInfo}
 -- end
-- end
;


-- [addPaperCutSizeInfo]
       insert into $table$ (id, idCutInfo, wholePaperSize, cutPaperSize,
        createBy, createTime,
        updateBy, updateTime ) values ( #{id}, #{idcutinfo}, #{wholepapersize}, #{cutpapersize},
 #{createby}, #{createtime},
 #{updateby}, #{updatetime});


-- [deletePaperCutSizeInfo]
delete from $table$
where id = #{id};


-- [deletePaperCutSizeInfoList]
delete from $table$
where idCutInfo = #{id};

-- [selectPaperQuoteInfo]
select * from $table$;

-- [addPaperQuoteInfo]
insert into $table$ (id, idPaperBaseInfo, paperBaseName, idPaperBrand,
                     paperBrandName, paperQuoteName, priceType,
                     paperPrice, voidFlag, createBy,
                     createTime, createTimeLong, updateBy,
                     updateTime, updateTimeLong ) values ( #{id}, #{idpaperbaseinfo}, #{paperbasename}, #{idpaperbrand},
                                                           #{paperbrandname}, #{paperquotename}, #{pricetype},
                                                           #{paperprice}, #{voidflag}, #{createby},
                                                           #{createtime}, #{createtimelong}, #{updateby},
                                                           #{updatetime}, #{updatetimelong} );

-- [updatePaperQuoteInfo]
update $table$ set paperQuoteName = #{paperquotename}, priceType = #{pricetype},paperPrice = #{paperprice},updateBy = #{updateby},
updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

-- [voidPaperQuoteInfo]
update $table$ set voidFlag = #{voidflag},updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};