📄 exsheetserv.java
字号:
adv.append(adapter2.getSheetPriceType());
}
sqlCond = adv.toString();
sqlCond = sqlCond
+ ToolKit.dateBound(loginInfo.getJndiName(), "a",
adapter2, loginInfo.getSysUserCode());
break;
case EventCode.EX_SHEET:
adapter2.setCreateDate1(DateUtilities.getCurDate("yyyy-MM")
+ "-01");
adapter2.setCreateDate3(DateUtilities.getCurDate("yyyy-MM-dd"));
sqlCond = " and a.createDate between '"
+ adapter2.getCreateDate1() + "' and '"
+ adapter2.getCreateDate3() + "'";
sqlCond = sqlCond
+ ToolKit.dateBound(loginInfo.getJndiName(), "a",
adapter2, loginInfo.getSysUserCode());
sqlCond = sqlCond
+ Perm.sqlCondSQL("a", "warehouseCode",
loginInfo.params.getWarehousePerm());
sqlCond = sqlCond
+ Perm.sqlCondSQL("a", "custID", loginInfo.params
.getCustomerPerm());
break;
case EventCode.EX_SHEET_REPORT:
adapter2.setCreateDate1(DateUtilities.getCurDate("yyyy-MM")
+ "-01");
adapter2.setCreateDate3(DateUtilities.getCurDate("yyyy-MM-dd"));
sqlCond = " and a.createDate between '"
+ adapter2.getCreateDate1() + "' and '"
+ adapter2.getCreateDate3() + "'";
sqlCond = sqlCond
+ ToolKit.dateBound(loginInfo.getJndiName(), "a",
adapter2, loginInfo.getSysUserCode());
if (adapter2.getStat() != 4) {
sqlCond = sqlCond
+ Perm.sqlCondSQL("c", "brandID", loginInfo.params
.getBrandPerm());
}
sqlCond = sqlCond
+ Perm.sqlCondSQL("b", "warehouseCode",
loginInfo.params.getWarehousePerm());
sqlCond = sqlCond
+ Perm.sqlCondSQL("a", "custID", loginInfo.params
.getCustomerPerm());
break;
}
// 保存返回的对象
// 补齐4行
int count = 4 - exItemsBeans.size();
for (int i = 0; i < count; i++) {
CExItemsAdapter item = new CExItemsAdapter(loginInfo
.getJndiName());
item.setWarehouseCode(exSheetAdapter.getWarehouseCode());
exItemsBeans.add(item);
exItemsStates.add("A");
}
// 如果光标在最后一行，则自动加一行
int index = 0;
try {
index = Integer.parseInt(itemIndex);
if (index == exItemsBeans.size() - 1) {
CExItemsAdapter item = new CExItemsAdapter(loginInfo
.getJndiName());
item.setWarehouseCode(exSheetAdapter.getWarehouseCode());
exItemsBeans.add(item);
exItemsStates.add("A");
}
} catch (Exception ex) {
}
req.setAttribute("exItemsActionBean", exItemsActionBean);
req.setAttribute("exItemsBeans", exItemsBeans);
req.setAttribute("exItemsStates", exItemsStates);
ListAdapter listAdapter = new ConcreteListAdapter(loginInfo
.getJndiName());
listAdapter.setOrder(req.getParameter("order"));
listAdapter.setSort(req.getParameter("sort"));
listAdapter.setPage(req.getParameter("page"));
listAdapter.setPageSize(req.getParameter("pageSize"));
listAdapter.setSqlCond(sqlCond);
req.setAttribute("ExSheetAdapter", exSheetAdapter);
req.setAttribute("ExSheetAdapter2", adapter2);
req.setAttribute("ListAdapter", listAdapter);
req.setAttribute("StatusBean", statusBean);
logins.put(loginInfo.getJndiName(), new Boolean(false));
switch (eventCode) {
case EventCode.ORDER_TO_SALE:
case EventCode.EX_ITEMS_NEW:
case EventCode.EX_SHEET_CUSTOMER_SELECT:
case EventCode.EX_SHEET_GOODS_SELECT:
case EventCode.EX_SHEET_NEW:
case EventCode.EX_SHEET_WAREHOUSE_SELECT:
case EventCode.EX_SELECT_PRICE:
direct("/sale/ex/new.jsp?custVRecMsg=" + custVRecMsg, req, resp);
break;
case EventCode.EX_SHEET_MODIFY:
direct("/sale/ex/new.jsp", req, resp);
break;
case EventCode.EX_SHEET_CONTENT:
direct("/sale/ex/new.jsp", req, resp);
break;
case EventCode.EX_SHEET_QUERY:
direct("/sale/ex/query.jsp", req, resp);
break;
case EventCode.EX_SHEET_PREVIEW:
break;
case EventCode.EX_SHEET_REPORT_QUERY_S:
case EventCode.EX_SHEET_REPORT_LIST:
case EventCode.EX_SHEET_REPORT:
direct("/sale/ex/report.jsp", req, resp);
break;
case EventCode.EX_SHEET_REPORT_PREVIEW:
break;
case EventCode.EX_SHEET_CANCEL:
case EventCode.EX_SHEET_BACK:
case EventCode.EX_SHEET_NEW_V:
case EventCode.EX_SHEET_NEW_V_REC:
case EventCode.EX_SHEET_MODIFY_S:
case EventCode.EX_SHEET_NEW_S:
case EventCode.EX_SHEET_IN_BALANCE_V:
case EventCode.EX_SHEET_IN_BALANCE_B:
case EventCode.EX_SHEET_OUT_BALANCE_V:
case EventCode.EX_SHEET_OUT_BALANCE_B:
case EventCode.EX_SHEET_FORM_OTHERS:
direct("/sale/accesscontrolservice?eventCode="
+ EventCode.EX_SHEET_MODIFY + "&exSheetCode="
+ exSheetAdapter.getExSheetCode(), req, resp);
break;
case EventCode.EX_SHEET_BACK2:
case EventCode.EX_SHEET_NEW_V2:
case EventCode.EX_SHEET_IN_BALANCE_V2:
case EventCode.EX_SHEET_IN_BALANCE_B2:
case EventCode.EX_SHEET_OUT_BALANCE_V2:
case EventCode.EX_SHEET_OUT_BALANCE_B2:
direct(req.getParameter("requestUrl"), req, resp);
break;
default:
direct("/sale/ex/list.jsp", req, resp);
break;
}
} catch (Exception ex) {
ex.printStackTrace();
logins.put(((LoginInfo) req.getSession().getAttribute("LoginInfo"))
.getJndiName(), new Boolean(false));
ex.printStackTrace();
return;
}
}
private void error(int type, String msg, HttpServletRequest req,
HttpServletResponse resp) throws ServletException, IOException {
logins.put(((LoginInfo) req.getSession().getAttribute("LoginInfo"))
.getJndiName(), new Boolean(false));
MsgBean msgBean = new MsgBean();
msgBean.setType(type);
msgBean.setMsg(msg);
req.setAttribute("MsgBean", msgBean);
getServletContext().getRequestDispatcher("/common/prompt.jsp").forward(
req, resp);
}
private ExSheetAdapter createExSheetAdapter(ExSheetAdapter ism) {
ism.setIsAcc(true);
ism.setIsVou(true);
ism.setIsEnd(false);
ism.setIsExt(false);
ism.setIsExtAcc(false);
ism.setCurrency("RBM");
ism.setIsBack(false);
ism.setIsRegLed(true);
return ism;
}
private ExItemsAdapter impart(ExItemsAdapter adapter, int index,
StatusBean statusBean, ExSheetAdapter exSheetAdapter,
String brandPerm) {
GoodsAdapter goodsAdapter = new CGoodsAdapter(adapter.getJndiName());
goodsAdapter.setGdsNo(adapter.getGdsNo());
CBalanceAdapter balance = new CBalanceAdapter(adapter.getJndiName());
boolean isPass = false;
if (!goodsAdapter.contentByGdsNo(brandPerm)) {
// 设置状态
if (!"".equals(goodsAdapter.getGdsNo())) {
int i = goodsAdapter.query(goodsAdapter.getGdsNo(), brandPerm);
if (i == 1) {
goodsAdapter = goodsAdapter.getEntity(adapter.getGdsNo(),
brandPerm);
isPass = true;
} else {
statusBean.setQueryCond(goodsAdapter.getGdsNo());
statusBean.setIndex(index);
statusBean.setStatus(2);
statusBean.setEventCode(EventCode.EX_ITEMS_NEW);
}
}
if (!isPass) {
ToolKit.clearObject(adapter, new String[] { "ID", "discount" });
return adapter;
}
}
adapter.setExSheetCode(exSheetAdapter.getExSheetCode());
adapter.setGoodsID(goodsAdapter.getGoodsID());
adapter.setGdsName(goodsAdapter.getGdsName());
adapter.setGdsStandard(goodsAdapter.getGdsStandard());
adapter.setGdsNo(goodsAdapter.getGdsNo());
adapter.setPrice(goodsAdapter.getSalePrice());
adapter.setAmo(0);
adapter.setProductNo(goodsAdapter.getCode());
adapter.setUnit(goodsAdapter.getUnit());
adapter.setCostPrice(goodsAdapter.getInPrice());
adapter.setCostAmo(0);
adapter.setWarehouseCode(exSheetAdapter.getWarehouseCode());
if (exSheetAdapter.getWarehouseCode() == 0) {
adapter.setWarehouseCode(balance.getGoodsWarehouseCode(adapter
.getGoodsID()));
}
spec(adapter, exSheetAdapter);
return initialProductNo(adapter, exSheetAdapter);
}
private void direct(String path, HttpServletRequest req,
HttpServletResponse resp) throws ServletException, IOException {
getServletContext().getRequestDispatcher(path).forward(req, resp);
}
private ExItemsAdapter spec(ExItemsAdapter adapter,
ExSheetAdapter exSheetAdapter) {
double pricecon[] = ToolKit.getPrice(adapter.getJndiName(), 1,
exSheetAdapter.getSheetPriceType(), exSheetAdapter.getCustID(),
adapter.getGoodsID());
adapter.setPrice(pricecon[0]);
adapter.setDiscount(pricecon[1]);
GoodsBean goods = new GoodsBean(adapter.getJndiName());
goods.setGoodsID(adapter.getGoodsID());
goods.content();
adapter.setSheetSalePrice(goods.getSalePrice());
MarketSpecItemsAdapter spec = new CMarketSpecItemsAdapter(adapter
.getJndiName());
if (spec.getSpecPriceByGoodsIDCustID(adapter.getGoodsID(),
exSheetAdapter.getCustID())) {
adapter.setPrice(spec.getSpecPrice());
adapter.setDiscount(1);
adapter.setIsCom(true);
adapter.setRemark("特价");
}
return costPrice(adapter, exSheetAdapter);
}
private void initialProductNo(List l, ExSheetAdapter exSheetAdapter) {
CustBar custBar = new CustBar(exSheetAdapter.getJndiName());
CustGoodsAdapter cga = new CCustGoodsAdapter(exSheetAdapter
.getJndiName());
for (Iterator iter = l.iterator(); iter.hasNext();) {
ExItemsAdapter order = (ExItemsAdapter) iter.next();
if (custBar.isExistsByCode(exSheetAdapter.getCustID(), order
.getGoodsID())) {
order.setProductNo(custBar.getProductNo());
} else {
order.setProductNo("");
}
cga.setCustID(exSheetAdapter.getCustID());
cga.setGoodsID(order.getGoodsID());
if (!cga.contentByCustIDAndGoodsID()) {
if (order.getGoodsID() > 0) {
order.setRemark("新");
}
} else {
order.setRemark("");
}
}
}
private ExItemsAdapter initialProductNo(ExItemsAdapter exItemsAdapter,
ExSheetAdapter exSheetAdapter) {
CustBar custBar = new CustBar(exSheetAdapter.getJndiName());
CustGoodsAdapter cga = new CCustGoodsAdapter(exSheetAdapter
.getJndiName());
if (custBar.isExistsByCode(exSheetAdapter.getCustID(), exItemsAdapter
.getGoodsID())) {
exItemsAdapter.setProductNo(custBar.getProductNo());
} else {
exItemsAdapter.setProductNo("");
}
cga.setCustID(exSheetAdapter.getCustID());
cga.setGoodsID(exItemsAdapter.getGoodsID());
if (!cga.contentByCustIDAndGoodsID()) {
if (exItemsAdapter.getGoodsID() > 0) {
exItemsAdapter.setRemark("新");
}
} else {
exItemsAdapter.setRemark("");
}
return exItemsAdapter;
}
private ExItemsAdapter costPrice(ExItemsAdapter adapter,
ExSheetAdapter exSheetAdapter) {
double price = 0;
net.intuitsoft.xeon.table.warehouse.balance.BalanceAdapter balanceAdapter = new net.intuitsoft.xeon.table.warehouse.balance.CBalanceAdapter(
exSheetAdapter.getJndiName());
if (adapter.getWarehouseCode() == 0) {
adapter.setWarehouseCode(exSheetAdapter.getWarehouseCode());
}
if (adapter.getWarehouseCode() == 0) {
adapter.setWarehouseCode(balanceAdapter
.getGoodsWarehouseCode(adapter.getGoodsID()));
}
GoodsModel gm = new GoodsBean(exSheetAdapter.getJndiName());
gm.setGoodsID(adapter.getGoodsID());
gm.content();
if (ToolKit.getIsUseGoodsWarehouseCode(exSheetAdapter.getJndiName())
&& gm.getWarehouseCode() > 0) {
adapter.setWarehouseCode(gm.getWarehouseCode());
}
price = balanceAdapter.getBalPrice(adapter.getGoodsID(), adapter
.getWarehouseCode());
if (price > 0) {
adapter.setCostPrice(price);
} else {
adapter.setCostPrice(gm.getInPrice());
}
adapter.setCostAmo(adapter.getCostPrice() * adapter.getQua());
return adapter;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -