package com.bealead.server.mvc.dao.impl;
import java.math.BigDecimal;
import java.text.ParseException;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.bealead.server.mvc.dao.Inner_WeixinDao;
import com.bealead.server.mvc.dataobject.BusinessInfoList;
import com.bealead.server.mvc.dataobject.DailyRecordInfoList;
import com.bealead.server.mvc.dataobject.ErrorInfoList;
import com.bealead.server.mvc.dataobject.GetKQDateList;
import com.bealead.server.mvc.dataobject.HolidayInfoList;
import com.bealead.server.mvc.dataobject.HolidayTypeList;
import com.bealead.server.mvc.dataobject.KQ_GetKQBusinessInfoList;
import com.bealead.server.mvc.dataobject.KqdTempList;
import com.bealead.server.mvc.dataobject.KqhTempList;
import com.bealead.server.mvc.dataobject.ManagerInfoList;
import com.bealead.server.mvc.dataobject.NameList;
import com.bealead.server.mvc.dataobject.OpenIdList;
import com.bealead.server.mvc.dataobject.ParentBusinessInfoList;
import com.bealead.server.mvc.dataobject.ParentBusinessSumList;
import com.bealead.server.mvc.dataobject.PersonnelInfo;
import com.bealead.server.mvc.dataobject.PidList;
import com.bealead.server.mvc.dataobject.RzInfoList;
import com.bealead.server.mvc.dataobject.StepInfoList_1List;
import com.bealead.server.mvc.dataobject.StructureBusinessInfoList;
import com.bealead.server.mvc.dataobject.StructureList;
import com.bealead.server.mvc.funref.ref_GetHolidayList;
import com.bealead.server.mvc.funref.ref_GetStepInfoListList;
import com.bealead.server.mvc.funref.ref_KQ_SaveDailyRecord;
import com.bealead.server.mvc.funref.ref_Save_KQHD_Business;
import com.bealead.server.mvc.funref.ref_StructureBusinessInfoList;
import com.bealead.server.mvc.utils.Tools;
@SuppressWarnings("unchecked")
@Repository
public class Inner_WeixinDaoImpl implements Inner_WeixinDao {
@Autowired
private SqlSessionTemplate sqlSessionTemplate;
/**
* 根据openid获取pid
*/
@Override
public int Get_PId_ByOpenId(String OpenId) throws Exception {
Map<String, Object> map = new HashMap<String, Object>();
map.put("OpenId", OpenId);
List<PidList> list = (List<PidList>) sqlSessionTemplate.selectList(
Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".Get_KQ_GetPersonnelId", map);
int pid = -1;
if (list.size() != 0) {
pid = list.get(0).getPersonnelId();
}
return pid;
}
/**
* ͨ获取人员信息,模糊查询
*/
@Override
public List<PersonnelInfo> Search_User(String keytxt) throws Exception {
Map<String, Object> map = new HashMap<String, Object>();
map.put("KeyText", keytxt);
List<PersonnelInfo> list = (List<PersonnelInfo>) sqlSessionTemplate
.selectList(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".search_User", map);
return list;
}
/**
* 删除步骤表
*
* @param OpenId
*/
@Override
public void KQ_DeleteStep(String OpenId) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("OpenId", OpenId);
// sqlSessionTemplate.delete(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
// + ".KQ_DeleteStep", map);
sqlSessionTemplate.selectList(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_DeleteStep", map);
}
/**
* 删除kqd或者kqh对应临时表
*
* @param DataType.1是kqd,,2是kqh
* @param OpenId
*/
@Override
public void KQ_DeleteKQ(int DataType, String OpenId) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("DataType", DataType);
map.put("OpenId", OpenId);
sqlSessionTemplate.delete(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_DeleteKQ", map);
}
/**
* 定时删除用...清空kqd临时表,kqh临时表,和step表,对应DataType分别是1,2,3
*
* @param CurrentDate当前日期
* @param DataType操作类型
*/
@Override
public void KQ_ClearKQInstruc(String CurrentDate, int DataType) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("CurrentDate", CurrentDate);
map.put("DataType", DataType);
sqlSessionTemplate.delete(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_ClearKQInstruc", map);
}
/**
* 用户信息绑定,把bind数据写入bind业务表...获取SQL返回ID
*
* @param OpenId
* @param IDCardNo
* @return
*/
@Override
public int KQ_SavePersonelRelation(String OpenId, String IDCardNo) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("OpenId", OpenId);
map.put("IDCard", IDCardNo);
map.put("ErrorId", 0);
sqlSessionTemplate.selectList(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_SavePersonelRelation", map);
return Integer.parseInt(map.get("ErrorId").toString());// 返回SQL处理的结果
}
/**
* 初始化或者更新步骤表
*
* @param OpenId
* @param CmdNo
* @param EndStep
* @param EndTime
* @param tmpstr
* @throws ParseException
*/
@Override
public void KQ_SaveStep(String OpenId, String CmdNo, int EndStep,
Date EndTime, String tmpstr) throws ParseException {
Map<String, Object> map = new HashMap<String, Object>();
map.put("StepId", 0);
map.put("OpenId", OpenId);
map.put("CmdNo", CmdNo);
map.put("EndStep", EndStep);
map.put("EndTime", EndTime);
map.put("Xmlstr", tmpstr);
sqlSessionTemplate.selectList(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_SaveStep", map);
}
/**
* 根据pid获取上级pid,如果取不到则返回-1
*
* @param MyPId
* @return
*/
@Override
public int Get_HighPId(int MyPId) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("PersonnelId", MyPId);
map.put("ParentId", 0);
sqlSessionTemplate.selectList(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_GetParentId", map);
return Integer.parseInt(map.get("ParentId").toString());
}
/**
* 根据PId获取OpenId
*
* @param MyPId
* @return
*/
@Override
public String Get_OpenId_ByPId(int MyPId) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("PersonnelId", MyPId);
map.put("DataType", 2);
List<OpenIdList> list = (List<OpenIdList>) sqlSessionTemplate
.selectList(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_PidTOOpenId", map);
if (list.size() == 0) {
return "";
}
return list.get(0).getOpenId();
}
/**
* 根据PId获取姓名
*
* @param MyPId
* @return
*/
@Override
public String PID_to_Name(int MyPId) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("PersonnelId", MyPId);
map.put("DataType", 1);
List<NameList> list = (List<NameList>) sqlSessionTemplate.selectList(
Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE + ".KQ_PidToName", map);
if (list.size() == 0) {
return "";
}
return list.get(0).getPersonnelName();
}
/**
* 保存日志信息到数据库
*
* @param DataType..1=微信录入，2=网页录入
* @param RecordDate
* @param Content
* @param PersonnelId
* @param State
* @return
*/
@Override
public ref_KQ_SaveDailyRecord KQ_SaveDailyRecord(int DataType,
int RecordDate, String Content, int PersonnelId, int State) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("DataType", DataType);
map.put("RecordDate", RecordDate);
map.put("Content", Content);
map.put("PersonnelId", PersonnelId);
map.put("State", State);
map.put("return_value", 0);// 返回值
List<RzInfoList> list = (List<RzInfoList>) sqlSessionTemplate
.selectList(Inner_WeixinDao.SYSTEMFRAME_NAME_SPACE
+ ".KQ_SaveDailyRecord", map);
ref_KQ_SaveDailyRecord ref = new ref_KQ_SaveDailyRecord();
ref.setList(list);
ref.setReturn_value(Integer
.parseInt(map.get("return_value").toString()));
return ref;
}
/*
spring MVC网页开发框架 （182个子文件） 
Inner_WeixinDaoImpl.class 19KB Tools.class 5KB Inner_WeixinDao.class 4KB ConfigurationFile.class 4KB WeatherUtil.class 3KB BusinessInfoList.class 3KB StudentController.class 3KB KqhTempList.class 2KB StructureList.class 2KB KQ_GetKQBusinessInfoList.class 2KB KqdTempList.class 2KB HolidayInfoList.class 2KB BidInfoList.class 2KB ErrorInfoList.class 2KB StructureBusinessInfoList.class 1KB ManagerInfoList.class 1KB Student.class 1KB DailyRecordInfoList.class 1KB RzInfoList.class 1KB ExtendStrutsFilter.class 1KB StepInfoList_1List.class 1KB Inner_WeixinServiceImpl.class 1KB ParentBusinessInfoList.class 1KB GetKQDateList.class 1KB PersonnelInfo.class 1KB DataSourceContextHolder.class 1002B PropertiesHelper.class 989B BaseFunRef.class 932B HolidayTypeList.class 825B ref_Save_KQHD_Business.class 782B DynamicDataSource.class 782B ParentBusinessSumList.class 767B ref_StructureBusinessInfoList.class 667B NameList.class 610B ref_GetHolidayList.class 597B OpenIdList.class 588B PidList.class 534B ref_GetStepInfoListList.class 378B ref_KQ_SaveDailyRecord.class 375B test.class 293B .classpath 6KB testOpenidConfig.ini 77B testOpenidConfig.ini 77B
ojdbc14.jar 1.47MB freemarker-2.3.16.jar 860KB mysql-connector-java-5.1.17-bin.jar 769KB struts2-core-2.2.3.jar 756KB spring-context-3.0.6.RELEASE.jar 655KB mybatis-3.0.6.jar 630KB xwork-core-2.2.3.jar 604KB javassist-3.11.0.GA.jar 600KB c3p0-0.9.1.2.jar 596KB commons-collections-3.2.1.jar 562KB spring-beans-3.0.6.RELEASE.jar 544KB sqljdbc4.jar 455KB cxf-rt-frontend-jaxrs-2.2.9.jar 449KB wss4j-1.6.15.jar 435KB xstream-1.3.1.jar 421KB logback-core-1.1.2.jar 418KB spring-webmvc-3.0.6.RELEASE.jar 410KB cxf-rt-core-2.2.9.jar 406KB jstl-1.2.jar 405KB spring-web-3.0.6.RELEASE.jar 389KB standard-1.1.2.jar 384KB spring-jdbc-3.0.6.RELEASE.jar 377KB spring-core-3.0.6.RELEASE.jar 373KB cglib-nodep-2.2.jar 315KB spring-aop-3.0.6.RELEASE.jar 314KB dom4j-1.6.1.jar 307KB cxf-api-2.2.9.jar 303KB cxf-rt-frontend-jaxws-2.2.9.jar 301KB commons-httpclient-3.1.jar 298KB cxf-common-utilities-2.2.9.jar 297KB commons-lang-2.5.jar 273KB logback-classic-1.1.2.jar 264KB junit-4.7.jar 227KB spring-tx-3.0.6.RELEASE.jar 226KB commons-beanutils-1.8.0.jar 226KB ognl-3.0.1.jar 224KB spring-test-3.0.7.RELEASE.jar 201KB cxf-rt-transports-http-2.2.9.jar 192KB commons-io-2.2.jar 170KB spring-expression-3.0.6.RELEASE.jar 166KB json-lib-2.4-jdk15.jar 155KB cxf-tools-common-2.2.9.jar 155KB commons-dbcp-1.3.jar 145KB wsdl4j-1.6.2.jar 145KB XmlSchema-1.4.5.jar 143KB javax.persistence.jar 131KB cxf-rt-bindings-soap-2.2.9.jar 114KB spring-context-support-3.0.6.RELEASE.jar 99KB commons-pool-1.5.4.jar 94KB logback-access-1.1.2.jar 91KB cxf-rt-databinding-jaxb-2.2.9.jar 90KB jaxb-api-2.1.jar 88KB servlet-api.jar 86KB ezmorph-1.0.6.jar 84KB cxf-rt-frontend-simple-2.2.9.jar 76KB cxf-rt-ws-addr-2.2.9.jar 69KB cxf-rt-transports-http-jetty-2.2.9.jar 67KB共 182 条
- 1
- 2
资源评论
