?? voitsubjectinfo.java
字號:
package com.saas.biz.votesubjectMgr;
import java.util.ArrayList;
import com.saas.biz.dao.voteitemsDAO.VoteitemsExt;
import com.saas.biz.dao.newsDAO.NewsExt;
import com.saas.biz.dao.votesubjectDAO.VotesubjectDAO;
import com.saas.biz.dao.votesubjectDAO.VotesubjectExt;
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 VoitsubjectInfo {
Dbtable tradeQuery;
Logger log;
Buffers inBuffer;
Buffers outBuffer;
ArrayList queryResult = new ArrayList();
public VoitsubjectInfo()
{
log = new Logger(this);
}
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;
}
//add by sjp date:2007-6-07
public void addvotesubjectInfo(Buffers inbuffer)
{
log.LOG_INFO("進入addvoitsubjectInfo方法...");
this.outBuffer = inbuffer;
int iResult=-1 ;
try
{
VotesubjectDAO votesubjectDAO = new VotesubjectDAO();
votesubjectDAO.setVote_class(inbuffer.getString("VOTE_CLASS"));
votesubjectDAO.setVote_id(inbuffer.getString("VOTE_ID"));
votesubjectDAO.setSubject_name(inbuffer.getString("SUBJECT_NAME"));
votesubjectDAO.setStart_date(inbuffer.getString("START_DATE"));
votesubjectDAO.setEnd_date(inbuffer.getString("END_DATE"));
votesubjectDAO.setCust_id(inbuffer.getString("SESSION_CUST_ID"));
votesubjectDAO.setUser_id(inbuffer.getString("SESSION_USER_ID"));
votesubjectDAO.setChecked_tag(inbuffer.getString("CHECKED_TAG"));
votesubjectDAO.setVote_type(inbuffer.getString("VOTE_TYPE"));
votesubjectDAO.setVote_range(inbuffer.getString("VOTE_RANGE"));
votesubjectDAO.setOwn_range(inbuffer.getString("OWN_RANGE"));
//votesubjectDAO.setVote_range(inbuffer.getString("VOTE_RANGE"));
iResult=addvotesubjectInfo(votesubjectDAO);
}
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("退出addvoitsubjectInfo方法...");
}
public int addvotesubjectInfo(VotesubjectDAO votesubjectDAO) throws SaasApplicationException
{
VotesubjectExt votesubjectExt= new VotesubjectExt();
votesubjectExt.setParam(":VVOTE_CLASS", votesubjectDAO.getVote_class());
votesubjectExt.setParam(":VVOTE_ID", votesubjectDAO.getVote_id());
votesubjectExt.setParam(":VSUBJECT_NAME", votesubjectDAO.getSubject_name());
votesubjectExt.setParam(":VSTART_DATE", votesubjectDAO.getStart_date());
votesubjectExt.setParam(":VEND_DATE", votesubjectDAO.getEnd_date());
votesubjectExt.setParam(":VCUST_ID", votesubjectDAO.getCust_id());
votesubjectExt.setParam(":VUSER_ID", votesubjectDAO.getUser_id());
votesubjectExt.setParam(":VCHECKED_TAG", votesubjectDAO.getChecked_tag());
votesubjectExt.setParam(":VVOTE_TYPE", votesubjectDAO.getVote_type());
votesubjectExt.setParam(":VVOTE_RANGE", votesubjectDAO.getVote_range());
votesubjectExt.setParam(":VOWN_RANGE", votesubjectDAO.getOwn_range());
votesubjectExt.setParam(":VVOTE_COUNT", 0);
votesubjectExt.setParam(":VRSRV_STR1", "");
votesubjectExt.setParam(":VRSRV_STR2", "");
votesubjectExt.setParam(":VRSRV_STR3", "");
votesubjectExt.setParam(":VRSRV_NUM4", 0);
votesubjectExt.setParam(":VRSRV_NUM5",0);
votesubjectExt.setParam(":VRSRV_STR6", "");
votesubjectExt.setParam(":VRSRV_STR7", "");
votesubjectExt.setParam(":VRSRV_STR8", "");
votesubjectExt.setParam(":VRSRV_STR9", "");
votesubjectExt.setParam(":VRSRV_STR10", "");
votesubjectExt.setParam(":VREMARK", "");
tradeQuery.executeBy(votesubjectExt.insBy("INS_BY_ALL"));
return 0;
}
//add by sjp date:2007-06-07
public void genCustvote(Buffers inbuffer)
{
log.LOG_INFO("進入genCustvote方法...");
this.outBuffer = inbuffer;
String cust_id = inbuffer.getString("SESSION_CUST_ID");
String query_param = inbuffer.getString("QUERY_PARAM");
try
{
if(query_param.equals(""))
this.queryResult = genCustvote(cust_id);
else this.queryResult = searchVote(query_param);
}
catch (SaasApplicationException e)
{
log.LOG_INFO(e.getMessage());
}
log.LOG_INFO("退出genCustvote方法...");
}
public ArrayList genCustvote(String cust_id) throws SaasApplicationException
{
ArrayList itemsList = new ArrayList();
VotesubjectExt votesubjectExt= new VotesubjectExt();
votesubjectExt.setParam(":VCUST_ID",cust_id);
itemsList = votesubjectExt.selByList("SEL_BY_CUST");
return itemsList;
}
//add by sjp date:2007-06-08
public void genOnevote(Buffers inbuffer)
{
log.LOG_INFO("進入genOnevote方法...");
this.outBuffer = inbuffer;
String vote_id = inbuffer.getString("VOTE_ID");
try
{
this.queryResult = genOnevote(vote_id);
}
catch (SaasApplicationException e)
{
log.LOG_INFO(e.getMessage());
}
log.LOG_INFO("退出genOnevote方法...");
}
public ArrayList genOnevote(String vote_id) throws SaasApplicationException
{
ArrayList itemsList = new ArrayList();
VotesubjectExt votesubjectExt= new VotesubjectExt();
votesubjectExt.setParam(":VVOTE_ID",vote_id);
itemsList = votesubjectExt.selByList("SEL_BY_ONE");
return itemsList;
}
public ArrayList searchVote(String title) throws SaasApplicationException
{
ArrayList itemsList = new ArrayList();
VotesubjectExt votesubjectExt= new VotesubjectExt();
votesubjectExt.setParam(":VSUBJECT_NAME","%"+title+"%");
itemsList = votesubjectExt.selByList("SEL_BY_SEARCH");
return itemsList;
}
public void changvotesubjectInfo(Buffers inbuffer)
{
log.LOG_INFO("進入changvotesubjectInfo方法...");
this.outBuffer = inbuffer;
int iResult=-1 ;
try
{
VotesubjectDAO votesubjectDAO = new VotesubjectDAO();
votesubjectDAO.setVote_class(inbuffer.getString("VOTE_CLASS"));
votesubjectDAO.setVote_id(inbuffer.getString("VOTE_ID"));
votesubjectDAO.setSubject_name(inbuffer.getString("SUBJECT_NAME"));
votesubjectDAO.setStart_date(inbuffer.getString("START_DATE"));
votesubjectDAO.setEnd_date(inbuffer.getString("END_DATE"));
votesubjectDAO.setChecked_tag(inbuffer.getString("CHECKED_TAG"));
votesubjectDAO.setVote_type(inbuffer.getString("VOTE_TYPE"));
votesubjectDAO.setVote_range(inbuffer.getString("VOTE_RANGE"));
votesubjectDAO.setOwn_range(inbuffer.getString("OWN_RANGE"));
iResult=changvotesubjectInfo(votesubjectDAO);
}
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("退出changvotesubjectInfo方法...");
}
public int changvotesubjectInfo(VotesubjectDAO votesubjectDAO) throws SaasApplicationException
{
VotesubjectExt votesubjectExt= new VotesubjectExt();
votesubjectExt.setParam(":VVOTE_CLASS", votesubjectDAO.getVote_class());
votesubjectExt.setParam(":VVOTE_ID", votesubjectDAO.getVote_id());
votesubjectExt.setParam(":VSUBJECT_NAME", votesubjectDAO.getSubject_name());
votesubjectExt.setParam(":VSTART_DATE", votesubjectDAO.getStart_date());
votesubjectExt.setParam(":VEND_DATE", votesubjectDAO.getEnd_date());
votesubjectExt.setParam(":VCHECKED_TAG", votesubjectDAO.getChecked_tag());
votesubjectExt.setParam(":VVOTE_TYPE", votesubjectDAO.getVote_type());
votesubjectExt.setParam(":VVOTE_RANGE", votesubjectDAO.getVote_range());
votesubjectExt.setParam(":VOWN_RANGE", votesubjectDAO.getOwn_range());
tradeQuery.executeBy(votesubjectExt.insBy("UPDATE_BY_ID"));
return 0;
}
public void delvotesubjectInfo(Buffers inbuffer)
{
log.LOG_INFO("進入delvotesubjectInfo方法...");
this.outBuffer = inbuffer;
int iResult=-1 ;
try
{
String vote_id =inbuffer.getString("VOTE_ID");
iResult=delvotesubjectInfo(vote_id);
}
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("退出delvotesubjectInfo方法...");
}
public int delvotesubjectInfo(String vote_id) throws SaasApplicationException
{
VotesubjectExt votesubjectExt= new VotesubjectExt();
votesubjectExt.setParam(":VVOTE_ID", vote_id);
tradeQuery.executeBy(votesubjectExt.insBy("DEL_BY_ID"));
delitems(vote_id);
return 0;
}
public int delitems(String vote_id) throws SaasApplicationException
{
VoteitemsExt voteitemsExt = new VoteitemsExt();
voteitemsExt.setParam(":VVOTE_ID", vote_id);
tradeQuery.executeBy(voteitemsExt.insBy("DEL_BY_ID"));
return 0;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -