ExpenseAccountMapper.java 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. package com.goafanti.common.dao;
  2. import com.goafanti.common.model.ExpenseAccount;
  3. import com.goafanti.common.model.FinanceCount;
  4. import com.goafanti.expenseAccount.bo.InputExpenseAccount;
  5. import com.goafanti.expenseAccount.bo.MainExpenseAccount;
  6. import com.goafanti.expenseAccount.bo.OutExpenseAccount;
  7. import com.goafanti.expenseAccount.bo.OutMyEAStatistics;
  8. import org.apache.ibatis.annotations.Param;
  9. import java.util.List;
  10. public interface ExpenseAccountMapper {
  11. int deleteByPrimaryKey(Integer id);
  12. int insert(ExpenseAccount record);
  13. int insertSelective(ExpenseAccount record);
  14. ExpenseAccount selectByPrimaryKey(Integer id);
  15. int updateByPrimaryKeySelective(ExpenseAccount record);
  16. int updateByPrimaryKey(ExpenseAccount record);
  17. OutExpenseAccount selectByid(Integer id);
  18. OutExpenseAccount selectByaidAndPrid(InputExpenseAccount in);
  19. OutExpenseAccount selectByCheckNo(String checkNo);
  20. List<OutExpenseAccount> selectByaidAndType(@Param("aid") String aid,@Param("depId")String depId, @Param("type")Integer type,
  21. @Param("id")Integer id);
  22. List<OutMyEAStatistics> selectStatistics(@Param("name") String name, @Param("depId") String depId,
  23. @Param("startTime") String startTime, @Param("endTime") String endTime);
  24. List<ExpenseAccount> selectByDebitId(Integer debitId);
  25. List<ExpenseAccount> selectByCheckNoNot();
  26. List<FinanceCount> selectCountByFinance(String id);
  27. List<ExpenseAccount> selectByIds(List<String> split);
  28. void updateByIds(@Param("list") List<ExpenseAccount> list, @Param("status") Integer status);
  29. MainExpenseAccount selectByMainId(Integer id);
  30. void updateByMainId(@Param("id") Integer id, @Param("status") Integer status);
  31. List<ExpenseAccount> selectListByMainId(Integer id);
  32. int selectCountByIdsAndType(@Param("list") List<String> list, @Param("type") Integer type);
  33. }