| commit | author | age | ||
| a18bfa | 1 | package com.changhong.epc.form.mapper.tenant; |
| Z | 2 | |
| 3 | import com.changhong.epc.bean.form.SectoralAssets; | |
| 4 | import org.apache.ibatis.annotations.Param; | |
| 5 | ||
| 6 | import java.util.List; | |
| 7 | ||
| 8 | /** | |
| 9 | * 部门折旧信息汇总 | |
| 10 | */ | |
| 11 | public interface SectoralAssetsMapper { | |
| 12 | /** | |
| 13 | *同过部门、时间(yyyy-MM)查询 | |
| 14 | * | |
| 15 | */ | |
| 16 | List<SectoralAssets> getSectoralAssets( | |
| 17 | @Param("companyOrgCode") String companyOrgCode | |
| 18 | , @Param("date") String date | |
| 19 | , @Param("formId") String formId | |
| 20 | , @Param("yesCode") String yesCode | |
| 21 | ); | |
| 22 | ||
| 23 | /** | |
| 24 | *新增数据 | |
| 25 | * | |
| 26 | */ | |
| 27 | int addSectoralAssets(SectoralAssets sectoralAssets); | |
| 28 | ||
| 29 | /** | |
| 30 | *更改 | |
| 31 | * | |
| 32 | */ | |
| 33 | int updateSectoralAssets(SectoralAssets sectoralAssets); | |
| 34 | ||
| 35 | ||
| 36 | /** | |
| 37 | * 判断一级部门是否计提 | |
| 38 | * | |
| 39 | */ | |
| 40 | int isAccrued(@Param("useDep")String useDep, | |
| 41 | @Param("date")String date); | |
| 42 | ||
| 43 | ||
| 44 | int isBooking(@Param("useDep")String useDep, | |
| 45 | @Param("date")String date); | |
| 46 | ||
| 47 | SectoralAssets findOrgAssert(@Param("date") String date | |
| 48 | ,@Param("orgCode") String orgCode); | |
| 49 | ||
| 50 | int updateBookKeepingState(@Param("state") String state,@Param("id") String id,@Param("date") String date,@Param("number") String number); | |
| 51 | ||
| 52 | int updateSectoralAssetsStatus(@Param("bookkeepingState")String state,@Param("id")String id,@Param("voucherCode") String voucherCode); | |
| 53 | ||
| 54 | String getLastDepreciationDate(@Param("useDep") String orgCode, @Param("account") Boolean account); | |
| 55 | } | |
