package crm.filiale;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import sys.dao.ConnectManager;
import sys.dao.bean.Company;
import sys.dao.bean.Personnel;
public class FCompany extends HttpServlet
{
private static final long serialVersionUID = 1L;
// 部门经理查询员工客户
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
// 参数初始化
boolean p = false;
ConnectManager cm = ConnectManager.newInstance();
RequestDispatcher rd = null;
String dept = request.getParameter("deptid").replace(" ", "");
if (dept.equals(""))
{
request.getSession().setAttribute("dept", "");
}
else
{
request.getSession().setAttribute("dept", dept);
}
String personnelid = request.getParameter("personnelid").replace(" ", "");
if (personnelid.equals(""))
{
request.getSession().setAttribute("personnelid", "");
}
else
{
request.getSession().setAttribute("personnelid", personnelid);
}
Integer stype = Integer.valueOf(request.getParameter("stype").replace(" ", ""));
if (stype.equals(""))
{
request.getSession().setAttribute("stype", "");
}
else
{
request.getSession().setAttribute("stype", stype);
}
String content = request.getParameter("content").replace(" ", "");
if (content.equals(""))
{
request.getSession().setAttribute("content", "");
}
else
{
request.getSession().setAttribute("content", content);
}
String industry = request.getParameter("industry").replace(" ", "");
if (industry.equals(""))
{
request.getSession().setAttribute("industry", "");
}
else
{
request.getSession().setAttribute("industry", industry);
}
String state = request.getParameter("state").replace(" ", "");
if (state.equals(""))
{
request.getSession().setAttribute("state", "");
}
else
{
request.getSession().setAttribute("state", state);
}
String type = request.getParameter("type").replace(" ", "");
if (type.equals(""))
{
request.getSession().setAttribute("type", "");
}
else
{
request.getSession().setAttribute("type", stype);
}
String gotime = request.getParameter("gotime").replace(" ", "");
if (gotime.equals(""))
{
request.getSession().setAttribute("gotime", "");
}
else
{
request.getSession().setAttribute("gotime", gotime);
}
String endtime = request.getParameter("endtime").replace(" ", "");
if (endtime.equals(""))
{
request.getSession().setAttribute("endtime", "");
}
else
{
request.getSession().setAttribute("endtime", endtime);
}
List<Company> companies = null;
ResultSet rs = null;
String sql = "";
List<String> list = new ArrayList<String>();
String str = "";
String temp = "";
String sqltemp = "";
try
{
// 打开数据库
if (cm.getConnection())
{
try
{
// 开始拼装SQL
if (!"".equals(personnelid))
{
request.getSession().setAttribute("perid", personnelid);
// 这一段SQL是统计与查询通用的
str = str + " personnelid in (" + personnelid + ")";
if (!("".equals(gotime) && "".equals(endtime)))
{
temp = temp + " and indate in (select indate from company where indate >= '" + gotime + "' and indate <= '" + endtime + "')";
}
// 开始进行统计
// 统计查询结果的总条数
sql = "select count(*) from company where " + str + temp;
rs = cm.executeQuery(sql);
rs.next();
int i = rs.getInt(1);
// 查询是哪个业务员的记录
sql = "select * from personnel where" + str;
rs = cm.executeQuery(sql);
if (rs.next())
{
list.add(rs.getString("realname") + "已查询到的客户数是:" + i);
String string = "";
string = string + "A库数量:" + rs.getInt(1);
// 统计在查询结是中的B库数据
sql = "select count(*) from company where " + str + temp + "and companystate = 'B'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " B库数量:" + rs.getInt(1);
// 统计在查询结是中的A类客户数据
sql = "select count(*) from company where " + str + temp + "and type = 'A'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " A类客户数量:" + rs.getInt(1);
// 统计在查询结是中的B类客户数据
sql = "select count(*) from company where " + str + temp + "and type = 'B'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " B类客户数量:" + rs.getInt(1);
// 统计在查询结是中的C类客户数据
sql = "select count(*) from company where " + str + temp + "and type = 'C'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " C类客户数量:" + rs.getInt(1);
// 统计在查询结是中的D类客户数据
sql = "select count(*) from company where " + str + temp + "and type = 'D'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " D类客户数量:" + rs.getInt(1);
// 统计在查询结是中的E类客户数据
sql = "select count(*) from company where " + str + temp + "and type = 'E'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " E类客户数量:" + rs.getInt(1);
list.add(string);
request.setAttribute("list", list);
}
}
else
{
// 开始拼装SQL
if (!"".equals(dept))
{
request.getSession().removeAttribute("perid");
// 这一段SQL是统计与查询通用的
str = str + " personnelid in (select personnelid from personnel where outdate is null and deptid = " + dept + ")";
if (!("".equals(gotime) && "".equals(endtime)))
{
temp = temp + " and indate in (select indate from company where indate >= '" + gotime + "' and indate <= '" + endtime + "')";
}
// 开始进行统计
// 统计查询结果的总条数
sql = "select count(*) from company where " + str + temp;
rs = cm.executeQuery(sql);
rs.next();
int i = rs.getInt(1);
// 查询是哪个部门的记录
sql = "select * from dept where deptid = " + dept;
rs = cm.executeQuery(sql);
if (rs.next())
{
list.add(rs.getString("deptname") + "已查询到的客户数是:" + i);
// 统计在查询结是中的A库数据
sql = "select count(*) from company where " + str + temp + "and companystate = 'A'";
rs = cm.executeQuery(sql);
rs.next();
String string = "";
string = string + "A库数量:" + rs.getInt(1);
// 统计在查询结是中的B库数据
sql = "select count(*) from company where " + str + temp + "and companystate = 'B'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " B库数量:" + rs.getInt(1);
// 统计在查询结是中的A类客户数据
sql = "select count(*) from company where " + str + temp + "and type = 'A'";
rs = cm.executeQuery(sql);
rs.next();
string = string + " A类客户数量:" + rs.getInt(1);
// 统计在查询结是中的B类客户数据
sql = "select coun
Java实战项目——基于javaweb实现的ERP管理系统(前后端源码+论文+数据库+说明文档).zip （1044个子文件） 
changedate.js.bak 24KB changedate.js.bak 24KB FCompany.class 22KB FCompany.class 22KB Company.class 17KB Company.class 17KB Export.class 17KB Export.class 17KB Personnel.class 14KB Personnel.class 14KB Statistic.class 12KB Statistic.class 12KB MCompany.class 11KB MCompany.class 11KB VisitList.class 11KB VisitList.class 11KB Export.class 10KB Export.class 10KB Bill.class 10KB Bill.class 10KB SearchC.class 8KB SearchC.class 8KB SearchC.class 8KB SearchC.class 8KB DestineNote.class 8KB DestineNote.class 8KB Visit.class 8KB Visit.class 8KB Search.class 8KB Search.class 8KB Login.class 7KB Login.class 7KB Industry.class 7KB Industry.class 7KB Linkman.class 7KB Linkman.class 7KB SelectPersonnel.class 7KB SelectPersonnel.class 7KB Dept.class 7KB Dept.class 7KB CtoA.class 6KB CtoA.class 6KB VisitList.class 6KB VisitList.class 6KB SelectA.class 6KB SelectA.class 6KB Select.class 6KB Select.class 6KB AddCompany.class 5KB AddCompany.class 5KB AddSort.class 5KB AddSort.class 5KB SelectC.class 5KB SelectC.class 5KB District.class 5KB District.class 5KB DStatistic.class 5KB DStatistic.class 5KB SelectC.class 5KB SelectC.class 5KB PersonnelInfo.class 5KB PersonnelInfo.class 5KB Bills.class 5KB Bills.class 5KB DeleteCompany.class 5KB DeleteCompany.class 5KB DeleteCompany.class 5KB DeleteCompany.class 5KB CompanyList.class 5KB CompanyList.class 5KB LoginParameter.class 5KB LoginParameter.class 5KB Info.class 5KB Info.class 5KB Info.class 4KB Info.class 4KB LoginChickUserName.class 4KB LoginChickUserName.class 4KB Sort.class 4KB Attorning.class 4KB Sort.class 4KB Attorning.class 4KB Keyword.class 4KB Keyword.class 4KB Incepting.class 4KB Incepting.class 4KB SwitchDate.class 4KB SwitchDate.class 4KB Addlandv.class 4KB Turn.class 4KB Addlandv.class 4KB Addlandv.class 4KB Turn.class 4KB Addlandv.class 4KB Info.class 4KB Info.class 4KB Info.class 4KB Info.class 4KB Attorn.class 4KB Attorn.class 4KB共 1044 条
- 1
- 2
- 3
- 4
- 5
- 6
- 11
资源评论
风禹兴2024-09-14感谢资源主的分享，很值得参考学习，资源价值较高，支持！
