📄 salesorderforminfo.java
字号:
String own_user_id = inbuffer.getString("OWN_USER_ID");
String off_count = inbuffer.getString("OFF_COUNT");
String off_rate = inbuffer.getString("OFF_RATE");
String ship_fee = inbuffer.getString("SHIP_FEE");
String tax = inbuffer.getString("TAX");
String all_fee = inbuffer.getString("ALL_FEE");
String order_count = inbuffer.getString("ORDER_COUNT");
String part_delivery_tag = inbuffer.getString("PART_DELIVERY_TAG");
String delivery_num = inbuffer.getString("DELIVERY_NUM");
String oper_user_id = inbuffer.getString("SESSION_USER_ID");
String rsrv_str3 = inbuffer.getString("OBJ_CUST_NAME");
String rsrv_str4 = inbuffer.getString("SALE_OBJ_NAME");
String rsrv_str5 = inbuffer.getString("SALE_USER_NAME");
String rsrv_str6 = inbuffer.getString("OWN_USER_NAME");
String remark2 = inbuffer.getString("REMARK2");
try {
SalesOrderDao saleDao = new SalesOrderDao();
saleDao.setCust_id(cust_id);
saleDao.setForm_id(form_id);
saleDao.setQuo_name(quo_name);
saleDao.setQuo_id(quo_id);
saleDao.setObj_cust_id(obj_cust_id);
saleDao.setQuo_code(quo_code);
saleDao.setSale_obj_id(sale_obj_id);
saleDao.setContact_man(contact_man);
saleDao.setContact(contact);
saleDao.setGive_date(give_date);
saleDao.setGive_addr(give_addr);
saleDao.setShip_type(ship_type);
saleDao.setDoc_date(doc_date);
saleDao.setCurrency_code(currency_code);
saleDao.setSale_user_id(sale_user_id);
saleDao.setOwn_user_id(own_user_id);
saleDao.setOff_count(off_count);
saleDao.setOff_rate(off_rate);
saleDao.setShip_fee(ship_fee);
saleDao.setTax(tax);
saleDao.setAll_fee(all_fee);
saleDao.setOrder_count(order_count);
saleDao.setPart_delivery_tag(part_delivery_tag);
saleDao.setDelivery_num(delivery_num);
saleDao.setOper_user_id(oper_user_id);
saleDao.setRsrv_str3(rsrv_str3);
saleDao.setRsrv_str4(rsrv_str4);
saleDao.setRsrv_str5(rsrv_str5);
saleDao.setRsrv_str6(rsrv_str6);
saleDao.setRemark2(remark2);
iResult = editSaleOrderForm(saleDao);
} catch (Exception e) {
}
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("退出editSaleOrderForm方法...");
}
public int editSaleOrderForm(SalesOrderDao saleDao)
throws SaasApplicationException {
SalesOrderExt orderExt = new SalesOrderExt();
orderExt.setParam(":VCUST_ID", saleDao.getCust_id());
orderExt.setParam(":VFORM_ID", saleDao.getForm_id());
orderExt.setParam(":VQUO_NAME", saleDao.getQuo_name());
orderExt.setParam(":VQUO_ID", saleDao.getQuo_id());
orderExt.setParam(":VOBJ_CUST_ID", saleDao.getObj_cust_id());
orderExt.setParam(":VQUO_CODE", saleDao.getQuo_code());
orderExt.setParam(":VSALE_OBJ_ID", saleDao.getSale_obj_id());
orderExt.setParam(":VCONTACT_MAN", saleDao.getContact_man());
orderExt.setParam(":VCONTACT", saleDao.getContact());
orderExt.setParam(":VGIVE_DATE", saleDao.getGive_date());
orderExt.setParam(":VGIVE_ADDR", saleDao.getGive_addr());
orderExt.setParam(":VSHIP_TYPE", saleDao.getShip_type());
orderExt.setParam(":VDOC_DATE", saleDao.getDoc_date());
orderExt.setParam(":VCURRENCY_CODE", saleDao.getCurrency_code());
orderExt.setParam(":VSALE_USER_ID", saleDao.getSale_user_id());
orderExt.setParam(":VOWN_USER_ID", saleDao.getOwn_user_id());
orderExt.setParam(":VOFF_COUNT", saleDao.getOff_count());
orderExt.setParam(":VOFF_RATE", saleDao.getOff_rate());
orderExt.setParam(":VSHIP_FEE", saleDao.getShip_fee());
orderExt.setParam(":VTAX", saleDao.getTax());
orderExt.setParam(":VALL_FEE", saleDao.getAll_fee());
orderExt.setParam(":VORDER_COUNT", saleDao.getOrder_count());
orderExt
.setParam(":VPART_DELIVERY_TAG", saleDao.getPart_delivery_tag());
orderExt.setParam(":VDELIVERY_NUM", saleDao.getDelivery_num());
orderExt.setParam(":VOPER_USER_ID", saleDao.getOper_user_id());
orderExt.setParam(":VREMARK2", saleDao.getRemark2());
orderExt.setParam(":VRSRV_STR3", saleDao.getRsrv_str3());
orderExt.setParam(":VRSRV_STR4", saleDao.getRsrv_str4());
orderExt.setParam(":VRSRV_STR5", saleDao.getRsrv_str5());
orderExt.setParam(":VRSRV_STR6", saleDao.getRsrv_str6());
tradeQuery.executeBy(orderExt.insBy("UPDATE_BY_ALL"));
return 0;
}
// 删除销售订单
public void deleteSaleOrderForm(Buffers inbuffer) {
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
log.LOG_INFO("进入deleteSaleOrderForm方法...");
int iResult = -1;
String cust_id = inbuffer.getString("SESSION_CUST_ID");
String quo_id = inbuffer.getString("QUO_ID");
try {
iResult = deleteSaleOrderForm(cust_id, quo_id);
} catch (Exception e) {
}
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("退出deleteSaleOrderForm方法...");
}
public int deleteSaleOrderForm(String cust_id, String quo_id)
throws SaasApplicationException {
SalesOrderExt orderExt = new SalesOrderExt();
orderExt.setParam(":VCUST_ID", cust_id);
orderExt.setParam(":VQUO_ID", quo_id);
tradeQuery.executeBy(orderExt.insBy("DEL_BY_ID"));
return 0;
}
// 取出所有销售单
public ArrayList getSalseOrderByCust(int iStart, String cust_id)
throws SaasApplicationException {
ArrayList list = new ArrayList();
SalesOrderExt orderExt = new SalesOrderExt();
iStart=iStart*20;
orderExt.setParam(":VCUST_ID", cust_id);
list = orderExt.selByList("SEL_BY_CUST", iStart, 20);
return list;
}
// 通过客户Id取出销售单
public ArrayList getSalseOrderByCust(String cust_id)
throws SaasApplicationException {
ArrayList list = new ArrayList();
SalesOrderExt orderExt = new SalesOrderExt();
orderExt.setParam(":VCUST_ID", cust_id);
list = orderExt.selByList("SEL_BY_CUST");
return list;
}
// 统计客户销售单数量
public int getSalesOrderCount(String cust_id)
throws SaasApplicationException {
int size = 0;
ArrayList list = new ArrayList();
SalesOrderExt orderExt = new SalesOrderExt();
orderExt.setParam(":VCUST_ID", cust_id);
list = orderExt.selByList("SEL_SIZE_BY_CT");
if (list != null && list.size() > 0) {
HashMap map = (HashMap) list.get(0);
size = Integer.parseInt(map.get("ct").toString());
}
return size;
}
// 取出单个销售单
public HashMap getSaleOrderById(String cust_id, String quo_id)
throws SaasApplicationException {
HashMap map = new HashMap();
ArrayList list = new ArrayList();
SalesOrderExt orderExt = new SalesOrderExt();
orderExt.setParam(":VCUST_ID", cust_id);
orderExt.setParam(":VQUO_ID", quo_id);
list = orderExt.selByList("SEL_BY_ID");
if (list != null && list.size() > 0) {
map = (HashMap) list.get(0);
}
return map;
}
public ArrayList getConStateList(int iStart, String cust_id)
throws SaasApplicationException {
iStart = iStart*20;
SalesOrderExt coniExt = new SalesOrderExt();
coniExt.setParam(":VCUST_ID", cust_id);
ArrayList list = coniExt.selByList("SEL_BY_CON_STATE", iStart, 20);
return list;
}
public int getConStateList(String cust_id) throws SaasApplicationException {
int count = 0;
SalesOrderExt coniExt = new SalesOrderExt();
coniExt.setParam(":VCUST_ID", cust_id);
ArrayList list = coniExt.selByList("SEL_BY_CON_STATE");
if (list != null && list.size() > 0) {
count = list.size();
}
return count;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -