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

-- [addMaterialType]
insert into $table$ (id, materialTypeName, materialTypeCode, materialNextType,
materialNextTypeCode, materialCount, voidFlag,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{materialtypename}, #{materialtypecode}, #{materialnexttype},
#{materialnexttypecode}, #{materialcount}, #{voidflag},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

 -- [updateMaterialInfoType]
 update $table$ set
 materialTypeName = #{materialtypename},
 updateBy = #{updateby},
 updateTime = #{updatetime},
 updateTimeLong = #{updatetimelong}
 where id = #{id};

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

-- [addMaterialInfo]
 insert into $table$ (id, idMaterialType, materialTypeName, materialName,
 mtModel, mtRule, mtUnit,
 byUnit, seUnit, convertUnitByToMt,
 convertUnitMtToSe, newestPrice, voidFlag,stockPrecision,code,
 remark, materialCode, barCode,
 createBy, createTime, createTimeLong,
 updateBy, updateTime, updateTimeLong,
  priceType, machineRequestFlag)
 values (
 #{id}, #{idmaterialtype}, #{materialtypename}, #{materialname},
 #{mtmodel}, #{mtrule}, #{mtunit},
 #{byunit}, #{seunit}, #{convertunitbytomt},
 #{convertunitmttose}, #{newestprice}, #{voidflag},#{stockprecision},#{code},
 #{remark}, #{materialcode}, #{barcode},
 #{createby}, #{createtime}, #{createtimelong},
 #{updateby}, #{updatetime}, #{updatetimelong},
  #{pricetype}, #{machinerequestflag});

 -- [updateMaterialInfo]
 update $table$ set
  idMaterialType = #{idmaterialtype},
 mtModel = #{mtmodel},
 mtRule = #{mtrule},
 mtUnit = #{mtunit},
 byUnit = #{byunit},
 seUnit = #{seunit},
 convertUnitByToMt = #{convertunitbytomt},
 convertUnitMtToSe = #{convertunitmttose},
 newestPrice = #{newestprice},
 remark = #{remark},
 barCode = #{barcode},
 updateBy = #{updateby},
 updateTime = #{updatetime},
 updateTimeLong = #{updatetimelong},
 priceType = #{pricetype},
 machineRequestFlag = #{machinerequestflag}
 where id = #{id};

 -- [updateMaterialStockPrecision]
 update $table$ set
 stockPrecision = #{stockprecision}
 where id = #{id};

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