?? driversinfo.java
字號:
package com.saas.biz.driverMgr;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.driverDao.DriverDao;
import com.saas.biz.dao.driverDao.DriverExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;
public class DriversInfo{
Logger log;
Buffers inBuffer;
Buffers outBuffer;
Dbtable tradeQuery;
commMethodMgr commen;
ArrayList queryResult = new ArrayList();
public DriversInfo() {
log = new Logger(this);
tradeQuery = new Dbtable();
commen = new commMethodMgr();
}
public void setOutBuffer(Buffers outBuffer) {
this.outBuffer = outBuffer;
}
public Buffers getOutBuffer() {
return this.outBuffer;
}
public void setTradeQuery(Dbtable tradeQuery) {
this.tradeQuery = tradeQuery;
}
public Dbtable getTradeQuery() {
return this.tradeQuery;
}
public ArrayList getQueryResult() {
return this.queryResult;
}
public void setQueryResult(ArrayList queryResult) {
this.queryResult = queryResult;
}
/*
* 添加駕駛員資料
*/
public void addDriverInfo(Buffers inbuffer) {
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
log.LOG_INFO("進入addDriverInfo方法...");
int iResult = -1;
try {
DriverDao driverDao = new DriverDao();
driverDao.setCust_id(inbuffer.getString("SESSION_CUST_ID"));
driverDao.setDriver_id(inbuffer.getString("DRIVER_ID"));
driverDao.setDriver_name(inbuffer.getString("DRIVER_NAME"));
driverDao.setAuto_id(inbuffer.getString("AUTO_ID"));
driverDao.setDriver_no(inbuffer.getString("DRIVER_NO"));
driverDao.setIn_date(inbuffer.getString("IN_DATE"));
driverDao.setDriver_year(inbuffer.getString("DRIVER_YEAR"));
driverDao.setBirthday(inbuffer.getString("BIRTHDAY"));
driverDao.setFrom_addr(inbuffer.getString("FROM_ADDR"));
driverDao.setContact_addr(inbuffer.getString("CONTACT_ADDR"));
driverDao.setContact_phone(inbuffer.getString("CONTACT_PHONE"));
driverDao.setEdu_pre(inbuffer.getString("EDU_PRE"));
driverDao.setUser_tag(inbuffer.getString("USER_TAG"));
driverDao.setUser_id(inbuffer.getString("USER_ID"));
driverDao.setCheck_date(inbuffer.getString("CHECK_DATE"));
driverDao.setState_code(inbuffer.getString("STATE_CODE"));
driverDao.setState_code_date(inbuffer.getString("STATE_CODE_DATE"));
driverDao.setOper_date(inbuffer.getString("OPER_DATE"));
driverDao.setOper_user_id(inbuffer.getString("OPER_USER_ID"));
driverDao.setRemark(inbuffer.getString("REMARK"));
iResult = addDriverInfo(driverDao);
}
catch (SaasApplicationException e) {
log.LOG_INFO(e.getMessage());
}
if (iResult != 0) {
this.outBuffer.setInt("RESULT_CODE", -1);
this.outBuffer.setString("RESULT_INFO", "新增駕駛員資料業務處理失敗！");
}
else {
this.outBuffer.setInt("RESULT_CODE", 0);
this.outBuffer.setString("RESULT_INFO", "新增駕駛員資料業務處理成功！");
}
log.LOG_INFO("退出addDriverInfo方法...");
}
public int addDriverInfo(DriverDao driverDao) throws SaasApplicationException {
DriverExt driverExt = new DriverExt();
driverExt.setParam(":VCUST_ID",driverDao.getCust_id());
driverExt.setParam(":VDRIVER_ID",driverDao.getDriver_id());
driverExt.setParam(":VDRIVER_NAME",driverDao.getDriver_name());
driverExt.setParam(":VAUTO_ID",driverDao.getAuto_id());
driverExt.setParam(":VDRIVER_NO",driverDao.getDriver_no());
driverExt.setParam(":VIN_DATE",driverDao.getIn_date());
driverExt.setParam(":VDRIVER_YEAR",driverDao.getDriver_year());
driverExt.setParam(":VBIRTHDAY",driverDao.getBirthday());
driverExt.setParam(":VFROM_ADDR",driverDao.getFrom_addr());
driverExt.setParam(":VCONTACT_ADDR",driverDao.getContact_addr());
driverExt.setParam(":VCONTACT_PHONE", driverDao.getContact_phone());
driverExt.setParam(":VEDU_PRE", driverDao.getEdu_pre());
driverExt.setParam(":VUSER_TAG", driverDao.getUser_tag());
driverExt.setParam(":VUSER_ID", driverDao.getUser_id());
driverExt.setParam(":VCHECK_DATE", driverDao.getCheck_date());
driverExt.setParam(":VSTATE_CODE", driverDao.getState_code());
driverExt.setParam(":VSTATE_CODE_DATE", driverDao.getState_code_date());
driverExt.setParam(":VOPER_DATE", driverDao.getOper_date());
driverExt.setParam(":VOPER_USER_ID", driverDao.getOper_user_id());
driverExt.setParam(":VREMARK", driverDao.getRemark());
tradeQuery.executeBy(driverExt.insBy("INS_BY_ALL"));
log.LOG_INFO(" addUserInfo successful !");
return 0;
}
/*
* 修改駕駛員資料
*/
public void updateDriverInfo(Buffers inbuffer) {
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
log.LOG_INFO("進入updateDriverInfo方法...");
int iResult = -1;
try
{
DriverDao driverDao = new DriverDao();
driverDao.setCust_id(inbuffer.getString("SESSION_CUST_ID"));
driverDao.setDriver_id(inbuffer.getString("DRIVER_ID"));
driverDao.setDriver_name(inbuffer.getString("DRIVER_NAME"));
driverDao.setAuto_id(inbuffer.getString("AUTO_ID"));
driverDao.setDriver_no(inbuffer.getString("DRIVER_NO"));
driverDao.setIn_date(inbuffer.getString("IN_DATE"));
driverDao.setDriver_year(inbuffer.getString("DRIVER_YEAR"));
driverDao.setBirthday(inbuffer.getString("BIRTHDAY"));
driverDao.setFrom_addr(inbuffer.getString("FROM_ADDR"));
driverDao.setContact_addr(inbuffer.getString("CONTACT_ADDR"));
driverDao.setContact_phone(inbuffer.getString("CONTACT_PHONE"));
driverDao.setEdu_pre(inbuffer.getString("EDU_PRE"));
driverDao.setUser_tag(inbuffer.getString("USER_TAG"));
driverDao.setUser_id(inbuffer.getString("USER_ID"));
driverDao.setCheck_date(inbuffer.getString("CHECK_DATE"));
driverDao.setState_code(inbuffer.getString("STATE_CODE"));
driverDao.setState_code_date(inbuffer.getString("STATE_CODE_DATE"));
driverDao.setOper_date(inbuffer.getString("OPER_DATE"));
driverDao.setOper_user_id(inbuffer.getString("OPER_USER_ID"));
driverDao.setRemark(inbuffer.getString("REMARK"));
iResult = updateDriverInfo( driverDao );
}
catch (SaasApplicationException e) {
log.LOG_INFO(e.getMessage());
}
if (iResult != 0) {
this.outBuffer.setInt("RESULT_CODE", -1);
this.outBuffer.setString("RESULT_INFO", "新增駕駛員資料業務處理失敗！");
}
else {
this.outBuffer.setInt("RESULT_CODE", 0);
this.outBuffer.setString("RESULT_INFO", "新增駕駛員資料業務處理成功！");
}
log.LOG_INFO("退出updateDriverInfo方法...");
}
public int updateDriverInfo( DriverDao driverDao ) throws SaasApplicationException {
DriverExt driverExt = new DriverExt();
driverExt.setParam(":VCUST_ID",driverDao.getCust_id());
driverExt.setParam(":VDRIVER_ID",driverDao.getDriver_id());
driverExt.setParam(":VDRIVER_NAME",driverDao.getDriver_name());
driverExt.setParam(":VAUTO_ID",driverDao.getAuto_id());
driverExt.setParam(":VDRIVER_NO",driverDao.getDriver_no());
driverExt.setParam(":VIN_DATE",driverDao.getIn_date());
driverExt.setParam(":VDRIVER_YEAR",driverDao.getDriver_year());
driverExt.setParam(":VBIRTHDAY",driverDao.getBirthday());
driverExt.setParam(":VFROM_ADDR",driverDao.getFrom_addr());
driverExt.setParam(":VCONTACT_ADDR",driverDao.getContact_addr());
driverExt.setParam(":VCONTACT_PHONE", driverDao.getContact_phone());
driverExt.setParam(":VEDU_PRE", driverDao.getEdu_pre());
driverExt.setParam(":VUSER_TAG", driverDao.getUser_tag());
driverExt.setParam(":VUSER_ID", driverDao.getUser_id());
driverExt.setParam(":VCHECK_DATE", driverDao.getCheck_date());
driverExt.setParam(":VSTATE_CODE", driverDao.getState_code());
driverExt.setParam(":VSTATE_CODE_DATE", driverDao.getState_code_date());
driverExt.setParam(":VOPER_DATE", "");
driverExt.setParam(":VOPER_USER_ID", driverDao.getOper_user_id());
driverExt.setParam(":VREMARK", driverDao.getRemark());
tradeQuery.executeBy(driverExt.insBy("UPDATE_BY_ALL"));
log.LOG_INFO(" addUserInfo successful !");
return 0;
}
public ArrayList getDriverByCust(int iStart, String cust_id) throws SaasApplicationException {
iStart = iStart * 20;
DriverExt driverExt = new DriverExt();
driverExt.setParam(":VCUST_ID", cust_id);
ArrayList list = driverExt.selByList("SEL_BY_CUST", iStart, 20);
return list;
}
public int getriverCountByCust(String cust_id) throws SaasApplicationException {
int size = 0;
DriverExt driverExt = new DriverExt();
driverExt.setParam(":VCUST_ID", cust_id);
ArrayList list = driverExt.selByList("SEL_COUNT_BY_CUST");
if (list != null && list.size() > 0) {
HashMap map = (HashMap) list.get(0);
size = Integer.parseInt(map.get("ct").toString());
}
return size;
}
public void delDriverInfo(Buffers inbuffer) {
log.LOG_INFO("進入delDriverInfo方法...");
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
int iResult = -1;
String cust_id = inbuffer.getString("SESSION_CUST_ID");
String driver_id = inbuffer.getString("DRIVER_ID");
try {
DriverDao driverDao = new DriverDao();
driverDao.setCust_id( cust_id );
driverDao.setDriver_id( driver_id );
iResult = delDriverInfo( driverDao );
}
catch (Exception e) {
log.LOG_INFO(e.getMessage());
}
if (iResult != 0) {
this.outBuffer.setInt("RESULT_CODE", -1);
this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
}
else {
this.outBuffer.setInt("RESULT_CODE", 0);
this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
}
log.LOG_INFO("退出delDriverInfo方法...");
}
public int delDriverInfo(DriverDao driverDao) throws SaasApplicationException {
DriverExt driverExt = new DriverExt();
driverExt.setParam(":VCUST_ID", driverDao.getCust_id());
driverExt.setParam(":VDRIVER_ID", driverDao.getDriver_id());
tradeQuery.executeBy(driverExt.insBy("DEL_BY_ID"));
return 0;
}
public HashMap getDriverById(String driver_id) throws SaasApplicationException {
HashMap map = new HashMap();
DriverExt driverExt = new DriverExt();
driverExt.setParam(":VDRIVER_ID", driver_id);
ArrayList list = driverExt.selByList("SEL_BY_ID");
if (list != null && list.size() > 0) {
map = (HashMap) list.get(0);
}
return map;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -