j代码

import java.io.IOException; import java.io.PrintWriter; import java.util.List; import java.util.Map; import java.util.Vector;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;

import com.spsoft.adtmgr.dao.IAnalyseDao;

import com.spsoft.adtmgr.service.ProcessService;

import com.spsoft.adtmgr.service.deedTax.IDeedTaxService; import com.spsoft.adtmgr.service.impl.AnalyseServiceImpl; import com.spsoft.adtmgr.util.ExStringUtil;

import com.spsoft.ptx.util.session.SessionRegister; import com.spsoft.ptx.util.string.StringUtil; /**

* Title:

* Description:

* Company: 海闻软件技术有限公司 * @author 曾阳波 * @version 1.01 * date: 2012-11-9 */

@Controller

@RequestMapping(\"/deedTaxAction.do\") public class DeedTaxAction { @Autowired(required = false) @Qualifier(\"processServiceImpl\") private ProcessService processService; @Autowired(required = false) @Qualifier(\"deedTaxServiceImpl\")

private IDeedTaxService deedTaxService; @Autowired(required = false) @Qualifier(\"analyseDao\") private IAnalyseDao analyseDao; @Autowired(required = false) @Qualifier(\"analyseService\") private AnalyseServiceImpl analyseServiceImpl; /**

* @Title: loadTabPage * @param request * @param response * @param model * @return

* @return String 返回类型 * @throws */ @SuppressWarnings(\"unchecked\") @RequestMapping(params = { \"ExeMethod=loadTabPage\" }) public String loadTabPage(HttpServletRequest request, HttpServletResponse response, Model model) { String billId = StringUtil.decodeToUtf(request.getParameter(\"billId\")); String actCode = StringUtil .decodeToUtf(request.getParameter(\"actcode\")); String exeFlag = StringUtil .decodeToUtf(request.getParameter(\"exeFlag\")); String tzbh = StringUtil.decodeToUtf(request.getParameter(\"tzbh\"));// T-10-0001 String riskFlag = StringUtil.decodeToUtf(request .getParameter(\"riskFlag\")); Map matterMap = processService.shMatterInfo(billId); Map actDefMap = processService.shActDefInfo(matterMap, actCode); String apId = processService.dealAccAdjust(billId, tzbh); String qydjid = StringUtil.toString(matterMap.get(\"QYDJID\")); if (ExStringUtil.isEmptyOrNull(qydjid)) { Vector v_AgentInfo = null; Object obj = SessionRegister.getUserProperty( SessionRegister.USERTYPE_OPERATOR, SessionRegister .getUserId(request, null), \"AgentInfo\"); if (obj != null) { v_AgentInfo = (Vector) obj; qydjid = (String) v_AgentInfo.elementAt(9);

} } model.addAttribute(\"actCode\ model.addAttribute(\"qydjid\ model.addAttribute(\"billId\ model.addAttribute(\"tzbh\ model.addAttribute(\"apId\ model.addAttribute(\"riskFlag\ model.addAttribute(\"exeFlag\ model.addAttribute(\"matterMap\ model.addAttribute(\"actDefMap\ String urlPath = \"deedTax/tab\"; return urlPath; } /**

* @Title: loadIndexPage * @param request * @param response * @param model * @return

* @return String 返回类型 * @throws */ @SuppressWarnings(\"unchecked\") @RequestMapping(params = { \"ExeMethod=loadIndexPage\" }) public String loadIndexPage(HttpServletRequest request, HttpServletResponse response, Model model) { String billId = StringUtil.decodeToUtf(request.getParameter(\"billId\")); String actCode = StringUtil .decodeToUtf(request.getParameter(\"actcode\")); String exeFlag = StringUtil .decodeToUtf(request.getParameter(\"exeFlag\")); String tzbh = StringUtil.decodeToUtf(request.getParameter(\"tzbh\"));// T-10-0001 Map matterMap = processService.shMatterInfo(billId); Map actDefMap = processService.shActDefInfo(matterMap, actCode); String apId = processService.dealAccAdjust(billId, tzbh); String sbdwid = matterMap.get(\"SBDWID\").toString(); String ttCode = matterMap.get(\"TTCODE\").toString(); String ssqj = matterMap.get(\"SSQJ\").toString(); String strDepartment = processService.getSourceDepartment(ttCode, ssqj, sbdwid);// 查询数据关联机构

}

String qydjid = StringUtil.toString(matterMap.get(\"QYDJID\")); if (ExStringUtil.isEmptyOrNull(qydjid)) { Vector v_AgentInfo = null; Object obj = SessionRegister.getUserProperty( SessionRegister.USERTYPE_OPERATOR, SessionRegister .getUserId(request, null), \"AgentInfo\"); if (obj != null) { v_AgentInfo = (Vector) obj; qydjid = (String) v_AgentInfo.elementAt(9); } }

String taxCode = matterMap.get(\"TAXCODE\").toString();

double TZJE = 0; double TZHJE = 0; double CWJE = 0;

List list = deedTaxService.getData(apId, billId); if (list.size() > 0) { Map map = (Map) list.get(0); CWJE = StringUtil.toDouble(map.get(\"JE1\")); TZJE = StringUtil.toDouble(map.get(\"JE2\")); TZHJE = StringUtil.toDouble(map.get(\"JE3\")); }

if (!\"\".equals(actCode) && !\"filing\".equals(actCode)) {// 待归档之前 String lastPeriod = this.getCurYearPreSq(ssqj); List drList = analyseDao.shDataItem(qydjid, ssqj, taxCode, ttCode, \"1\");// \"应交税金-应交契税\"贷方发生额 String fetchSql = analyseServiceImpl.getFetchSql(strDepartment, ssqj, drList, lastPeriod); CWJE = StringUtil.toDouble(analyseDao.getJe(fetchSql)); }

model.addAttribute(\"CWJE\model.addAttribute(\"TZJE\model.addAttribute(\"TZHJE\model.addAttribute(\"actCode\model.addAttribute(\"billId\model.addAttribute(\"ssqj\model.addAttribute(\"apId\

model.addAttribute(\"exeFlag\

model.addAttribute(\"matterMap\model.addAttribute(\"actDefMap\String urlPath = \"deedTax/index\"; return urlPath;

/**

* @Title: saveDeedTaxData,保存契税信息 * @param request * @param response * @return * @throws */ @RequestMapping(params = \"ExeMethod=saveDeedTaxData\") public void saveDeedTaxData(Model model, HttpServletRequest request, HttpServletResponse response) { String apId = StringUtil.decodeToUtf(request.getParameter(\"apId\")); String QSJE = StringUtil.decodeToUtf(request.getParameter(\"QSJE\")); String TZJE = StringUtil.decodeToUtf(request.getParameter(\"TZJE\"), \"\"); String TZHJE = StringUtil.decodeToUtf(request.getParameter(\"TZHJE\")); String billId = StringUtil.decodeToUtf(request.getParameter(\"billId\")); int flag = 0; flag = deedTaxService.saveDeedTaxData(apId, billId, QSJE, TZJE, TZHJE); try { response.setCharacterEncoding(\"UTF8\"); PrintWriter pw = response.getWriter(); pw.write(String.valueOf(flag)); pw.close(); } catch (IOException e) { e.printStackTrace(); } } /** * @Title: getResultValue,查询计算结果 * @param request * @param response * @return * @throws */ @SuppressWarnings(\"unchecked\") @RequestMapping(params = \"ExeMethod=getResultValue\") public void getResultValue(Model model, HttpServletRequest request, HttpServletResponse response) { String apId = StringUtil.decodeToUtf(request.getParameter(\"apId\")); String billId = StringUtil.decodeToUtf(request.getParameter(\"billId\")); double TZHJE = 0; List list = deedTaxService.getData(apId, billId); if (list.size() > 0) { Map map = (Map) list.get(0); TZHJE = StringUtil.toDouble(map.get(\"JE3\"));

}

} try { response.setCharacterEncoding(\"UTF8\"); PrintWriter pw = response.getWriter(); pw.write(String.valueOf(TZHJE)); pw.close();

} catch (IOException e) { e.printStackTrace(); }

//获得上一属期

private String getCurYearPreSq(String ssqj) { ssqj = ssqj.toUpperCase();

if (ssqj.length() == 4) {// 年报 return \"0\"; }

String year = ssqj.substring(0, 4); String qm = ssqj.substring(4, 6); if (\"Q1\".equals(qm)) {// 季报Q1 return \"0\"; }

if (qm.startsWith(\"Q\")) {// 季报Q2、Q3、Q4 String q = ssqj.substring(5, 6); return String.format(\"%4s%s%d\}

if (\"01\".equals(qm)) {// 月报01 return \"0\"; } // 月报02-12 return String.format(\"%06d\ } }

--------------------------------------------------------------

package com.spsoft.adtmgr.service.deedTax;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import com.spsoft.ptx.util.export.ExportException; public interface IDeedTaxService { public int saveDeedTaxData(String apId,String billId,String QSJE,String TZJE,String TZHJE); @SuppressWarnings(\"unchecked\") public List getData(String apId,String billId); public String exportReport(HttpServletRequest request) throws ExportException; }

----------------------------------------------------------------

package com.spsoft.adtmgr.service.deedTax.impl;

import java.util.HashMap; import java.util.List; import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Service;

import com.spsoft.adtmgr.dao.deedTax.IDeedTaxDao;

import com.spsoft.adtmgr.service.deedTax.IDeedTaxService; import com.spsoft.ptx.util.export.ExportException; import com.spsoft.ptx.util.export.excel.ExportExcel; import com.spsoft.ptx.util.string.StringUtil;

@Service(\"deedTaxServiceImpl\")

public class DeedTaxServiceImpl implements IDeedTaxService{ @Autowired(required = false) @Qualifier(\"deedTaxDaoImpl\") private IDeedTaxDao deedTaxDao; public int saveDeedTaxData(String apId, String billId, String QSJE, String TZJE, String TZHJE) { return deedTaxDao.saveDeedTaxData(apId,billId,QSJE,TZJE,TZHJE); }

Exception,

@SuppressWarnings(\"unchecked\")

public List getData(String apId, String billId) { return deedTaxDao.getData(apId,billId); }

@SuppressWarnings(\"unchecked\")

public String exportReport(HttpServletRequest request) throws Exception,ExportException { String apId = StringUtil.decodeToUtf(request.getParameter(\"apId\")); String billId = StringUtil.decodeToUtf(request.getParameter(\"billId\")); int psign = StringUtil.toInt(request.getParameter(\"sign\")); List list = deedTaxDao.getData(apId, billId);

Map fqData = new HashMap();//各分区数据 fqData.put(\"0-1\索引-分区号,分区数据 return new ExportExcel(\"ADT001801V101H\\"\\"10\0, psign).outExcelFromSqlAndList(fqData); } }

-------------------------------------------------------------

package com.spsoft.adtmgr.dao.deedTax;

import java.util.List;

public interface IDeedTaxDao { public int saveDeedTaxData(String apId,String billId,String QSJE,String TZJE,String TZHJE); @SuppressWarnings(\"unchecked\") public List getData(String apId,String billId); public void deleteDeedTaxInfo(String apId); }

------------------------------------------------------------

package com.spsoft.adtmgr.dao.deedTax.impl;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.spsoft.adtmgr.dao.JdbcTemplateSupport; import com.spsoft.adtmgr.dao.deedTax.IDeedTaxDao; @Repository(\"deedTaxDaoImpl\")

public class DeedTaxDaoImpl extends JdbcTemplateSupport implements IDeedTaxDao{ @SuppressWarnings(\"unchecked\") public int saveDeedTaxData(String apId, String billId, String QSJE, String TZJE, String TZHJE) { String sql=\"SELECT * FROM BI_DEEDTAXCHECKINFO WHERE APID=\"+apId; List list = this.query(sql); String sql1=\"\"; if(list.size()>0){ sql1 = \"UPDATE BI_DEEDTAXCHECKINFO SET JE1 =\"+QSJE+\ }else{ sql1 = \"INSERT INTO BI_DEEDTAXCHECKINFO values(\"+billId+\ } this.update(sql1); return 1; } @SuppressWarnings(\"unchecked\") public List getData(String apId, String billId) { String sql = \"SELECT *from BI_DEEDTAXCHECKINFO WHERE APID = '\"+apId+\"' AND BILLID='\"+billId+\"'\"; return this.query(sql); } public void deleteDeedTaxInfo(String apId) { String sql = \"DELETE from BI_DEEDTAXCHECKINFO WHERE APID = '\"+apId+\"'\"; this.update(sql); } }