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

-- [addOutSupplierInfo]
insert into $table$ (id,supplierName,supplierCode, supplierKind, supplierType,
supplierContent, factoryAddress, createMan,
settleKind, remark, shortPinyin,
principal, linkMan,
linkPhone, voidFlag, createBy,
createTime, updateBy,
updateTime) values ( #{id},#{suppliername}, #{suppliercode}, #{supplierkind}, #{suppliertype},
#{suppliercontent}, #{factoryaddress}, #{createman},
#{settlekind}, #{remark}, #{shortpinyin},
#{principal}, #{linkman},
#{linkphone}, #{voidflag}, #{createby},
#{createtime}, #{updateby},
#{updatetime});


-- [updateSupplierInfo]
update $table$ set supplierCode = #{suppliercode},
supplierName = #{suppliername}, supplierKind = #{supplierkind},
supplierType = #{suppliertype},supplierContent = #{suppliercontent},
factoryAddress = #{factoryaddress},createMan = #{createman},settleKind = #{settlekind},remark = #{remark},
shortPinyin = #{shortpinyin},principal = #{principal},linkMan = #{linkman},
linkPhone = #{linkphone},voidFlag = #{voidflag},createBy = #{createby},createTime = #{createtime},
updateBy = #{updateby},updateTime = #{updatetime}
 where id = #{id};


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

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