📄 ondutyinfo.java
字号:
package com.saas.biz.ondutyMgr;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import com.saas.biz.commen.commMethodMgr;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;
import com.saas.biz.dao.ondutyDAO.*;
public class OndutyInfo{
Dbtable tradeQuery;
Logger log;
Buffers inBuffer;
Buffers outBuffer;
ArrayList queryResult = new ArrayList();
public OndutyInfo() {
log = new Logger(this);
tradeQuery = new Dbtable();
}
public void setTradeQuery(Dbtable tradeQuery) {
this.tradeQuery = tradeQuery;
}
public Dbtable getTradeQuery() {
return this.tradeQuery;
}
public void setOutBuffer(Buffers outBuffer) {
this.outBuffer = outBuffer;
}
public Buffers getOutBuffer() {
return this.outBuffer;
}
public ArrayList getQueryResult() {
return this.queryResult;
}
public void setQueryResult(ArrayList queryResult) {
this.queryResult = queryResult;
}
public void addOndutyInfo(Buffers inbuffer) {
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
log.LOG_INFO("进入addOndutyInfo方法...");
String zt = inbuffer.getString("ZT");
String reason = inbuffer.getString("REASON");
String user_id = inbuffer.getString("SESSION_USER_ID");
String depart_code = inbuffer.getString("DEPART_CODE");
int iResult = -1;
try {
iResult = addOndutyInfo(zt, reason, user_id, depart_code);
}
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("退出addOndutyInfo方法...");
}
public int addOndutyInfo(String zt, String reason, String user_id, String depart_code) throws SaasApplicationException {
OndutyExt ondutyExt = new OndutyExt();
commMethodMgr comm = new commMethodMgr();
String trade_id = comm.GenTradeId();
ondutyExt.setParam(":VID", trade_id);
ondutyExt.setParam(":VZT", zt);
ondutyExt.setParam(":VREASON", reason);
ondutyExt.setParam(":VUSER", user_id);
ondutyExt.setParam(":VPART", depart_code);
ondutyExt.setParam(":VCHECKED", "1");
tradeQuery.executeBy(ondutyExt.insBy("INS_BY_ALL"));
return 0;
}
public ArrayList getOndutyList(int iStart, String strUserid, String start_date, String end_date) throws SaasApplicationException {
ArrayList itemsList = new ArrayList();
OndutyExt ondutyExt = new OndutyExt();
// log.LOG_INFO("start_date=="+start_date+"end_date=="+end_date);
try {
iStart=iStart*20;
ondutyExt.setParam(":VUSER", strUserid);
ondutyExt.setParam(":VSTART_DATE", start_date);
ondutyExt.setParam(":VEND_DATE", end_date);
itemsList = ondutyExt.selByList("SEL_BY_USER", iStart, 20);
}
catch (RuntimeException e) {
log.LOG_INFO(e.getMessage());
}
return itemsList;
}
// 分页统计
public int getDateQueryCount(String strUserid, String start_date, String end_date) throws SaasApplicationException {
ArrayList itemsList = new ArrayList();
OndutyExt ondutyExt = new OndutyExt();
int size = 0;
try {
ondutyExt.setParam(":VUSER", strUserid);
ondutyExt.setParam(":VSTART_DATE", start_date);
ondutyExt.setParam(":VEND_DATE", end_date);
itemsList = ondutyExt.selByList("SEL_BY_USER_CT");
if (itemsList != null && itemsList.size() > 0) {
HashMap map = (HashMap) itemsList.get(0);
if (map.get("ct") != null) {
size = Integer.parseInt(map.get("ct").toString());
}
}
}
catch (RuntimeException e) {
log.LOG_INFO(e.getMessage());
}
return size;
}
public ArrayList getDepOndutyList(int iStart, String part, String start_date, String end_date) throws SaasApplicationException {
ArrayList itemsList = new ArrayList();
OndutyExt ondutyExt = new OndutyExt();
// log.LOG_INFO("start_date=="+start_date+"end_date=="+end_date);
try {
if (iStart == 0) {
iStart = 0;
}
else {
iStart = (iStart - 1) * 20;
}
ondutyExt.setParam(":VPART", part);
ondutyExt.setParam(":VSTART_DATE", start_date);
ondutyExt.setParam(":VEND_DATE", end_date);
itemsList = ondutyExt.selByList("SEL_BY_DEP", iStart, 20);
}
catch (RuntimeException e) {
log.LOG_INFO(e.getMessage());
}
return itemsList;
}
// 分页统计
public int getDepOndutyCount(String part, String start_date, String end_date) throws SaasApplicationException {
ArrayList itemsList = new ArrayList();
OndutyExt ondutyExt = new OndutyExt();
log.LOG_INFO("start_date=="+start_date+"end_date=="+end_date);
int size = 0;
try {
ondutyExt.setParam(":VPART", part);
ondutyExt.setParam(":VSTART_DATE", start_date);
ondutyExt.setParam(":VEND_DATE", end_date);
itemsList = ondutyExt.selByList("SEL_BY_DEP_CT");
if (itemsList != null && itemsList.size() > 0) {
HashMap map = (HashMap) itemsList.get(0);
if (map.get("ct") != null) {
size = Integer.parseInt(map.get("ct").toString());
}
}
}
catch (RuntimeException e) {
log.LOG_INFO(e.getMessage());
}
return size;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -