~admin/ERP_override.git

New file
			@@ -0,0 +1,56 @@
			package com.example.erp.service.sd;

			import com.baomidou.dynamic.datasource.annotation.DS;
			import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
			import com.example.erp.entity.sd.BasicOtherMoney;
			import com.example.erp.mapper.sd.BasicOtherMoneyMapper;
			import org.springframework.stereotype.Service;

			import java.util.List;

			@Service
			@DS("sd")
			public class BasicOtherMoneyService {
			private final BasicOtherMoneyMapper basicOtherMoneyMapper;

			public BasicOtherMoneyService(BasicOtherMoneyMapper basicOtherMoneyMapper) {
			this.basicOtherMoneyMapper = basicOtherMoneyMapper;
			}

			public List<BasicOtherMoney> findAll() {
			return basicOtherMoneyMapper.selectList(null);

			}

			public int deleteById(Integer id) {
			return basicOtherMoneyMapper.deleteById(id);
			}

			public boolean save(String alias) {
			//判断是否已经存在
			QueryWrapper<BasicOtherMoney> queryWrapperByName = new QueryWrapper<>();
			queryWrapperByName.eq("alias", alias);
			int count = Math.toIntExact(basicOtherMoneyMapper.selectCount(queryWrapperByName));
			if(count>0){
			return false;
			}

			//查询最大的列名
			QueryWrapper<BasicOtherMoney> queryWrapper = new QueryWrapper<>();
			queryWrapper.orderByDesc("id");
			List<BasicOtherMoney> basicOtherMoneyList = basicOtherMoneyMapper.selectList(queryWrapper);
			//超过100条不执行
			if(basicOtherMoneyList.size()==100){
			return false;
			}

			BasicOtherMoney basicOtherMoney = basicOtherMoneyList.get(0);
			String getColumn = basicOtherMoney.getColumn()==null?"0":basicOtherMoney.getColumn().replace("M","");
			int columnNum = Integer.parseInt(getColumn)+1;
			BasicOtherMoney newBasicOtherMoney = new BasicOtherMoney();
			newBasicOtherMoney.setColumn("M"+String.format("%02d", columnNum));
			newBasicOtherMoney.setAlias(alias);
			basicOtherMoneyMapper.insert(newBasicOtherMoney);
			return true;
			}
			}