public void query(HttpServletRequest req, HttpServletResponse resp, String name)
throws ServletException, IOException {
int page = Integer.parseInt(req.getParameter("page"));
int rows = Integer.parseInt(req.getParameter("rows"));
int count = wlcs.getWTMD_Count(name);
JSONObject jsonObj = new JSONObject();
JSONArray jsonArray = new JSONArray();
JSONObject json_Obj = null;
List<SYJK_CCS_QGCLWTMDXX_TEMP> list_w = wlcs.getWTMD_W(page, rows, name);
for (int i = 0; i < list_w.size(); i++) {
json_Obj = new JSONObject();
SYJK_CCS_QGCLWTMDXX_TEMP wtmd = list_w.get(i);
wtmd = WhiteList_Tool.Hanization(wtmd);
json_Obj.put("R", i + 1);
json_Obj.put("ID", wtmd.getID());
json_Obj.put("CLSBDM", wtmd.getCLSBDM());
json_Obj.put("SKSSSQ", DateUtil.getStringDate(wtmd.getSKSSSQ(), null));
json_Obj.put("SKSSZQ", DateUtil.getStringDate(wtmd.getSKSSZQ(), null));
json_Obj.put("DQYNSE", wtmd.getDQYNSE());
json_Obj.put("REVENUECODE", wtmd.getREVENUECODE());
json_Obj.put("WS", wtmd.getWSPZ());
json_Obj.put("YCYYDM", wtmd.getYCYYDM());
jsonArray.add(json_Obj);
}
jsonObj.put("total", count);
jsonObj.put("rows", jsonArray);
ResponseUtil.write(resp, jsonObj);
System.out.println(jsonArray);
}
/** 封装问题名单临时表数据 */
public SYJK_CCS_QGCLWTMDXX_TEMP getWDMI(Map<String, String> map) {
SYJK_CCS_QGCLWTMDXX_TEMP wtmd = new SYJK_CCS_QGCLWTMDXX_TEMP();
// String name = req.getParameter("img");
// System.out.println(name);
wtmd.setCLSBDM(map.get("CLSBDM"));
String ycyy = map.get("ycyy") == null ? "W" : map.get("ycyy");
String jc1 = map.get("jc1") == null ? "" : map.get("jc1");
String jc2 = map.get("jc2") == null ? "" : map.get("jc2");
String cphm = map.get("cphm") == null ? "" : map.get("cphm");
String hphm = "";
if (jc1 != null
&& !"".equals(jc1)
&& jc2 != null
&& !"".equals(jc2)
&& cphm != null
&& !"".equals(cphm)) {
hphm = jc1 + jc2 + cphm;
}
wtmd.setYCYYDM(ycyy);
wtmd.setHPHM(hphm);
wtmd.setHPZL(map.get("HPZL").trim());
wtmd.setCLZL(map.get("CLZL").trim());
wtmd.setFDJH(map.get("FDJH").trim());
wtmd.setZCCMC(map.get("ZCCMC").trim());
String syxz = map.get("SYXZ") == null ? "" : map.get("SYXZ");
wtmd.setSYXZ(syxz);
wtmd.setCLXH(map.get("CLXH").trim());
// String CLCSDJRQ = req.getParameter("CLCSDJRQ").trim();
Date CLCSDJRQ = null;
if (map.get("CLCSDJRQ") != null && !"".equals(map.get("CLCSDJRQ"))) {
CLCSDJRQ = DateUtil.getStringDate(WhiteList_Tool.Date_format(map.get("CLCSDJRQ")), null);
}
wtmd.setCLCSDJRQ(CLCSDJRQ);
wtmd.setJGCLLX(map.get("JGCLLX").trim());
String HDZKS = map.get("HDZKS").trim();
if ("".equals(HDZKS)) {
wtmd.setHDZKS(null);
} else {
wtmd.setHDZKS(Double.valueOf(HDZKS));
}
String HDZZL = map.get("HDZZL").trim();
if ("".equals(HDZZL)) {
wtmd.setHDZZL(null);
} else {
wtmd.setHDZZL(Double.valueOf(HDZZL));
}
String ZBZL = map.get("ZBZL").trim();
if ("".equals(ZBZL)) {
wtmd.setZBZL(null);
} else {
wtmd.setZBZL(Double.valueOf(ZBZL));
}
String PL = map.get("PL").trim();
if ("".equals(PL)) {
wtmd.setPL(null);
} else {
wtmd.setPL(Double.valueOf(PL));
}
String GL = map.get("GL").trim();
if ("".equals(GL)) {
wtmd.setGL(null);
} else {
wtmd.setGL(Double.valueOf(GL));
}
Date SKSSSQ = null;
Date SKSSZQ = null;
String DQYNSE = null;
if (!ycyy.equals("W")) { // 非白名单的处理
SKSSSQ = DateUtil.getStringDate(WhiteList_Tool.Date_format(map.get("SKSSSQ_W")), null);
SKSSZQ =
DateUtil.getStringDate(
WhiteList_Tool.Date_format(map.get("SKSSSQ_W")).substring(0, 4) + "-12-31", null);
DQYNSE = map.get("DQYNSE_W");
if (DQYNSE != null && !"".equals(DQYNSE)) {
wtmd.setDQYNSE(Double.valueOf(DQYNSE));
wtmd.setDWJSJE(Double.valueOf(DQYNSE));
wtmd.setDQNDWSE(Double.valueOf(DQYNSE));
wtmd.setHEJE(Double.valueOf(DQYNSE));
} else {
wtmd.setDQYNSE(0.0);
}
} else { // 白名单的处理
if (map.get("SKSSSQ") != null && !"".equals((map.get("SKSSSQ")))) {
SKSSSQ = DateUtil.getStringDate(WhiteList_Tool.Date_format(map.get("SKSSSQ")), null);
}
if (map.get("SKSSZQ") != null && !"".equals((map.get("SKSSZQ")))) {
SKSSZQ = DateUtil.getStringDate(WhiteList_Tool.Date_format(map.get("SKSSZQ")), null);
}
DQYNSE = map.get("DQYNSE");
if (DQYNSE != null && !"".equals(DQYNSE)) {
wtmd.setDQYNSE(Double.valueOf(DQYNSE));
} else {
wtmd.setDQYNSE(0.0);
}
}
wtmd.setSKSSSQ(SKSSSQ);
wtmd.setSKSSZQ(SKSSZQ);
wtmd.setREVENUECODE(map.get("REVENUECODE"));
wtmd.setWSPZ(map.get("WSPZ"));
String WSPZNO = map.get("WSPZNO") == null ? "" : map.get("WSPZNO");
wtmd.setWSPZNO(WSPZNO);
return wtmd;
}
// 看有没有欠税信息
public List<AnnualTax_Type> getQS(String taxConfirmNo) {
PreparedStatement pre = null;
ResultSet rs = null;
Connection conn = null;
List<AnnualTax_Type> list = new ArrayList<AnnualTax_Type>();
AnnualTax_Type delinquentTaxDue = null;
try {
conn = DBConnPool.getConnection();
String sql = SqlText.C_08_rkmx_qs_001;
pre = conn.prepareStatement(sql);
pre.setString(1, taxConfirmNo);
rs = pre.executeQuery();
while (rs.next()) {
delinquentTaxDue = new AnnualTax_Type();
delinquentTaxDue.setAnnualTaxAmount(rs.getDouble("ANNUALTAXAMOUNT")); // 当期年单位税额
delinquentTaxDue.setTaxLocationCode(rs.getString("TAXLOCATIONCODE")); // 纳税地区代码
delinquentTaxDue.setTaxStartDate(
DateUtil.getStringDate(rs.getDate("TAXSTARTDATE"), "yyyy-MM-dd")); // 税款所属始期
delinquentTaxDue.setTaxEndDate(
DateUtil.getStringDate(rs.getDate("TAXENDDATE"), "yyyy-MM-dd")); // 税款所属止期
delinquentTaxDue.setTaxUnitTypeCode(rs.getString("TAXUNITTYPECODE")); // 计税单位代码
delinquentTaxDue.setUnitRate(rs.getDouble("UNITRATE")); // 单位计税金额
delinquentTaxDue.setTaxDue(rs.getDouble("TAXDUE")); // 当期应纳税额
delinquentTaxDue.setExceedDate(
DateUtil.getStringDate(rs.getDate("EXCEEDDATE"), "yyyy-MM-dd")); // 逾期时间
delinquentTaxDue.setExceedDaysCount(rs.getInt("EXCEEDDAYSCOUNT")); // 逾期天数
delinquentTaxDue.setOverDue(rs.getDouble("OVERDUE")); // 滞纳金
delinquentTaxDue.setTotalAmount(rs.getDouble("TOTALAMOUNT")); // 合计金额
Derate_Type derate = new Derate_Type();
; // 适用减免税对象
derate.setDeduction(rs.getDouble("DEDUCTION")); // 减免金额
derate.setDeductionDueProportion(rs.getDouble("DEDUCTIONDUEPROPORTION")); // 减免比例
derate.setDeductionDocumentNumber(rs.getString("DEDUCTIONDOCUMENTNUMBER")); // 减免税凭证号
if ("C".equals(rs.getString("TAXCONDITIONCODE"))
|| "E".equals(rs.getString("TAXCONDITIONCODE"))) {
derate.setDeduction(rs.getDouble("DEDUCTION")); // 减免金额
derate.setDeductionDueProportion(rs.getDouble("DEDUCTIONDUEPROPORTION")); // 减免比例
derate.setDeductionDocumentNumber(rs.getString("DEDUCTIONDOCUMENTNUMBER")); // 减免税凭证号
derate.setDeductionDueCode(rs.getString("DEDUCTIONDUECODE")); // 减免税原因代码,Y
derate.setDeductionDueType(rs.getString("DEDUCTIONDUETYPE")); // 减免税方案代码,Y
derate.setTaxDepartmentCode(
rs.getString("DEDUCTIONDEPARTMENTCODE")); // 开具减免（完）税凭证的税务机关代码,Y
derate.setTaxDepartment(rs.getString("DEDUCTIONDEPARTMENT")); // 开具减免（完）税凭证的税务机关名称,Y
}
list.add(delinquentTaxDue);
}
} catch (SQLException e) {
e.printStackTrace();
} catch (NoFreeConnectionException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (pre != null) {
pre.close();
}
ConnectDBBean.closeConnection(
ReadWriteDBPool.readPool, conn); // 因关闭方式有问题 需要原来的关闭方式进行连接的关闭 mili 2015-3-20 16:34:57
// if (conn != null) {
// conn.close();
// }
} catch (SQLException e) {
e.printStackTrace();
} catch (NoFreeConnectionException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}