?? stockqueryinfo.java
字號:
package com.saas.biz.stockQueryMgr;
import java.util.ArrayList;
import java.util.HashMap;
import com.saas.biz.dao.stockQueryDAO.StockQueryExt;
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 StockQueryInfo {
Dbtable tradeQuery;
Logger log;
Buffers inBuffer;
Buffers outBuffer;
ArrayList queryResult = new ArrayList();
public StockQueryInfo() {
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 addStockQueryInfo(Buffers inbuffer) {
log.LOG_INFO("進入addStockQueryInfo方法...");
this.outBuffer = inbuffer;
String cust_id = inbuffer.getString("SESSION_CUST_ID");
String form_id = inbuffer.getString("FORM_ID");
String query_id = inbuffer.getString("QUERY_ID");
String title = inbuffer.getString("TITLE");
String content = inbuffer.getString("CONTENT");
String q_user_id = inbuffer.getString("SALE_USER_ID");
String q_date = inbuffer.getString("Q_DATE");
String q_type = inbuffer.getString("Q_TYPE");
String q_cust_id = inbuffer.getString("OBJ_CUST_ID");
String q_cust_con = inbuffer.getString("CONTACT_ID");
String q_cust_phone = inbuffer.getString("Q_CUST_PHONE");
String pre_price = inbuffer.getString("PRE_PRICE");
String oper_user_id = inbuffer.getString("SESSION_USER_ID");
String in_date = inbuffer.getString("IN_DATE");
String remark = inbuffer.getString("REMARK");
String cust_name = inbuffer.getString("OBJ_CUST_NAME");
String contact_name = inbuffer.getString("CONTACT_MAN");
String user_name = inbuffer.getString("SALE_USER_NAME");
int iResult = -1;
try {
iResult = addStockQueryInfo(cust_id, form_id, query_id, title,
content, q_user_id, q_date, q_type, q_cust_id, q_cust_con,
q_cust_phone, pre_price, oper_user_id, in_date, remark,
cust_name, contact_name, user_name);
} 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("退出addStockQueryInfo方法...");
}
public int addStockQueryInfo(String cust_id, String form_id,
String query_id, String title, String content, String q_user_id,
String q_date, String q_type, String q_cust_id, String q_cust_con,
String q_cust_phone, String pre_price, String oper_user_id,
String in_date, String remark, String cust_name,
String contact_name, String user_name)
throws SaasApplicationException {
StockQueryExt stockQueryExt = new StockQueryExt();
stockQueryExt.setParam(":VCUST_ID", cust_id);
stockQueryExt.setParam(":VFORM_ID", form_id);
stockQueryExt.setParam(":VQUERY_ID", query_id);
stockQueryExt.setParam(":VTITLE", title);
stockQueryExt.setParam(":VCONTENT", content);
stockQueryExt.setParam(":VQ_USER_ID", q_user_id);
stockQueryExt.setParam(":VQ_DATE", q_date);
stockQueryExt.setParam(":VQ_TYPE", q_type);
stockQueryExt.setParam(":VQ_CUST_ID", q_cust_id);
stockQueryExt.setParam(":VQ_CUST_CON", q_cust_con);
stockQueryExt.setParam(":VQ_CUST_PHONE", q_cust_phone);
stockQueryExt.setParam(":VPRE_PRICE", pre_price);
stockQueryExt.setParam(":VOPER_USER_ID", oper_user_id);
stockQueryExt.setParam(":VIN_DATE", in_date);
stockQueryExt.setParam(":VREMARK", remark);
stockQueryExt.setParam(":VCUST_NAME", cust_name);
stockQueryExt.setParam(":VCONTACT_NAME", contact_name);
stockQueryExt.setParam(":VUSER_NAME", user_name);
tradeQuery.executeBy(stockQueryExt.insBy("INS_STOCK_QUERY_ALL"));
return 0;
}
public void updateStockQueryInfo(Buffers inbuffer) {
log.LOG_INFO("進入updateStockQueryInfo方法...");
this.outBuffer = inbuffer;
String cust_id = inbuffer.getString("SESSION_CUST_ID");
String form_id = inbuffer.getString("FORM_ID");
String query_id = inbuffer.getString("QUERY_ID");
String title = inbuffer.getString("TITLE");
String content = inbuffer.getString("CONTENT");
String q_user_id = inbuffer.getString("SALE_USER_ID");
String q_date = inbuffer.getString("Q_DATE");
String q_type = inbuffer.getString("Q_TYPE");
String q_cust_id = inbuffer.getString("OBJ_CUST_ID");
String q_cust_con = inbuffer.getString("CONTACT_ID");
String q_cust_phone = inbuffer.getString("Q_CUST_PHONE");
String pre_price = inbuffer.getString("PRE_PRICE");
String oper_user_id = inbuffer.getString("SESSION_USER_ID");
String in_date = inbuffer.getString("IN_DATE");
String remark = inbuffer.getString("REMARK");
String cust_name = inbuffer.getString("OBJ_CUST_NAME");
String contact_name = inbuffer.getString("CONTACT_MAN");
String user_name = inbuffer.getString("SALE_USER_NAME");
int iResult = -1;
try {
iResult = updateStockQueryInfo(cust_id, form_id, query_id, title,
content, q_user_id, q_date, q_type, q_cust_id, q_cust_con,
q_cust_phone, pre_price, oper_user_id, in_date, remark,
cust_name, contact_name, user_name);
} 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("退出updateStockQueryInfo方法...");
}
public int updateStockQueryInfo(String cust_id, String form_id,
String query_id, String title, String content, String q_user_id,
String q_date, String q_type, String q_cust_id, String q_cust_con,
String q_cust_phone, String pre_price, String oper_user_id,
String in_date, String remark, String cust_name,
String contact_name, String user_name)
throws SaasApplicationException {
StockQueryExt stockQueryExt = new StockQueryExt();
stockQueryExt.setParam(":VCUST_ID", cust_id);
stockQueryExt.setParam(":VFORM_ID", form_id);
stockQueryExt.setParam(":VQUERY_ID", query_id);
stockQueryExt.setParam(":VTITLE", title);
stockQueryExt.setParam(":VCONTENT", content);
stockQueryExt.setParam(":VQ_USER_ID", q_user_id);
stockQueryExt.setParam(":VQ_DATE", q_date);
stockQueryExt.setParam(":VQ_TYPE", q_type);
stockQueryExt.setParam(":VQ_CUST_ID", q_cust_id);
stockQueryExt.setParam(":VQ_CUST_CON", q_cust_con);
stockQueryExt.setParam(":VQ_CUST_PHONE", q_cust_phone);
stockQueryExt.setParam(":VPRE_PRICE", pre_price);
stockQueryExt.setParam(":VOPER_USER_ID", oper_user_id);
stockQueryExt.setParam(":VIN_DATE", in_date);
stockQueryExt.setParam(":VREMARK", remark);
stockQueryExt.setParam(":VCUST_NAME", cust_name);
stockQueryExt.setParam(":VCONTACT_NAME", contact_name);
stockQueryExt.setParam(":VUSER_NAME", user_name);
tradeQuery.executeBy(stockQueryExt.insBy("UPDATE_STOCK_QUERY_ALL"));
// log.LOG_INFO("開始執行SQL：========"+ stockQueryExt.insBy("UPDATE_STOCK_QUERY_ALL"));
return 0;
}
public void delStockQuery(Buffers inbuffer) {
log.LOG_INFO("進入delStockQuery方法...");
this.outBuffer = inbuffer;
String cust_id = inbuffer.getString("SESSION_CUST_ID");
String query_id = inbuffer.getString("QUERY_ID");
String form_id = inbuffer.getString("FORM_ID");
int iResult = -1;
try {
iResult = delStockQuery(cust_id, query_id, form_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("退出delStockQuery方法...");
}
public int delStockQuery(String cust_id, String query_id, String form_id)
throws SaasApplicationException {
StockQueryExt stockQueryExt = new StockQueryExt();
stockQueryExt.setParam(":VCUST_ID", cust_id);
stockQueryExt.setParam(":VQUERY_ID", query_id);
stockQueryExt.setParam(":VFORM_ID", form_id);
tradeQuery.executeBy(stockQueryExt.insBy("DEL_ONE_STOCKQUERY"));
return 0;
}
public ArrayList getOneStockQuery(String cust_id, String query_id)
throws SaasApplicationException {
HashMap map = new HashMap();
ArrayList list = new ArrayList();
StockQueryExt stockQueryExt = new StockQueryExt();
stockQueryExt.setParam(":VCUST_ID", cust_id);
stockQueryExt.setParam(":VQUERY_ID", query_id);
list = stockQueryExt.selByList("SEL_ONE_BY_QUO_ID");
return list;
}
public ArrayList getStockQueryList(int iStart, String cust_id)
throws SaasApplicationException {
// log.LOG_INFO("==========="+cust_id+"=========="+iStart+"==================");
StockQueryExt stockQueryExt = new StockQueryExt();
ArrayList list = new ArrayList();
try {
iStart=iStart*20;
stockQueryExt.setParam(":VCUST_ID", cust_id);
list = stockQueryExt.selByList("SEL_ALL_STOCKQUERY", iStart, 20);
// log.LOG_INFO("開始執行SQK：==============="+stockQueryExt.selByList("SEL_ALL_STOCKQUERY",
// iStart, 20));
} catch (RuntimeException e) {
log.LOG_INFO(e.getMessage());
}
return list;
}
// 取出所有的采購單
public int getStockQueryList(String cust_id)
throws SaasApplicationException {
StockQueryExt stockQueryExt = new StockQueryExt();
ArrayList list = new ArrayList();
int count = 0;
try {
stockQueryExt.setParam(":VCUST_ID", cust_id);
list = stockQueryExt.selByList("SEL_ALL_STOCKQUERY");
} catch (RuntimeException e) {
log.LOG_INFO(e.getMessage());
}
if (list != null && list.size() > 0) {
count = list.size();
}
return count;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -