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

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

-- [addMachineType]
insert into $table$ (
id, idProcess, typeName, machineSize, maxPaperSize,
minPaperSize, psSize, quoteScriptUrl,
voidFlag, createBy, createTime,
updateBy, updateTime )
values (
#{id}, #{idprocess}, #{typename}, #{machinesize}, #{maxpapersize},
#{minpapersize}, #{pssize}, #{quotescripturl},
#{voidflag}, #{createby}, #{createtime},
#{updateby}, #{updatetime} );

-- [updateMachineType]
update $table$ set
typeName = #{typename},
machineSize = #{machinesize},
maxPaperSize = #{maxpapersize},
minPaperSize = #{minpapersize},
psSize = #{pssize},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};

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

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

-- [addMachineInfo]
insert into $table$ (
id, idMachineType, idProcess, machineName, machineSize,
psSize, quoteScriptUrl, calcBurdenFlag, voidFlag, idCompany, companyName,
systemType,createBy, createTime,
updateBy, updateTime )
values (
#{id}, #{idmachinetype}, #{idprocess}, #{machinename}, #{machinesize},
#{pssize}, #{quotescripturl}, #{calcburdenflag}, #{voidflag}, #{idcompany}, #{companyname},
#{systemtype},#{createby}, #{createtime},
#{updateby}, #{updatetime});

-- [updateMachineInfo]
update $table$ set
idMachineType = #{idmachinetype},
idProcess = #{idprocess},
idCompany = #{idcompany},
companyName = #{companyname},
machineName = #{machinename},
machineSize = #{machinesize},
psSize = #{pssize},
calcBurdenFlag = #{calcburdenflag},
systemType = #{systemtype},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};

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