📄 exsheetserv.java
字号:
+ ":EX_SHEET_NEW_V", true, loginInfo
.getSysUserCode());
} else {
trans.rollback();
new WriteLog(loginInfo.getJndiName(), 3,
EventCode.EX_SHEET_NEW_V, loginInfo.getName(),
req.getRemoteAddr(), "记账：销售单："
+ exSheetAdapter.getExSheetCode()
+ " ：N", getClass().getName()
+ ":EX_SHEET_NEW_V", true, loginInfo
.getSysUserCode());
System.out.println("Transaction rolled back already.");
error(0, MsgConstant.DAO_ERROR, req, resp);
return;
}
} catch (Exception ex) {
ex.printStackTrace();
}
break;
case EventCode.EX_SHEET_BACK2:
case EventCode.EX_SHEET_BACK:
if (exSheetAdapter.content()) {
String canBack = Operation.canBack(exSheetAdapter,
loginInfo.getSysUserCode(), perms);
if (canBack != null) {
this.error(0, canBack, req, resp);
return;
}
} else {
this.error(0, MsgConstant.NO_CONTENT, req, resp);
return;
}
b = true;
try {
trans.begin();
} catch (Exception ex) {
ex.printStackTrace();
System.out.print("Cannot create transaction");
}
b = b && Operation.back(exSheetAdapter, loginInfo);
sys = new ConcreteSysUserAdapter(loginInfo.getJndiName());
new SheetLog(loginInfo.getJndiName(), exSheetAdapter
.getExSheetCode(), "反记账", sys.getCreateBy(loginInfo
.getSysUserCode())[0], Integer.parseInt(sys
.getCreateBy(loginInfo.getSysUserCode())[2]), "");
msgInfoSetup = new MsgInfoSetup(loginInfo.getJndiName());
msgInfoSetup.doMsg(SheetTypes.ExSheet, exSheetAdapter
.getExSheetCode(), EventCode.EX_SHEET_OUT_BALANCE_V,
MsgInfoSetup.Insert, "销售出库单["
+ exSheetAdapter.getExSheetCode()
+ "]已出库,请及时记账.", loginInfo);
try {
if (b) {
trans.commit();
new WriteLog(loginInfo.getJndiName(), 2,
EventCode.EX_SHEET_BACK, loginInfo.getName(),
req.getRemoteAddr(), "反记账：销售单："
+ exSheetAdapter.getExSheetCode()
+ " ：Y", getClass().getName()
+ ":EX_SHEET_BACK", true, loginInfo
.getSysUserCode());
} else {
trans.rollback();
new WriteLog(loginInfo.getJndiName(), 3,
EventCode.EX_SHEET_BACK, loginInfo.getName(),
req.getRemoteAddr(), "反记账：销售单："
+ exSheetAdapter.getExSheetCode()
+ " ：N", getClass().getName()
+ ":EX_SHEET_BACK", true, loginInfo
.getSysUserCode());
error(0, MsgConstant.DAO_ERROR, req, resp);
return;
}
} catch (Exception ex) {
ex.printStackTrace();
}
break;
case EventCode.EX_SHEET_DELETE:
if (exSheetAdapter.content()) {
String canDel = Operation.canDel(exSheetAdapter, loginInfo
.getSysUserCode(), perms);
if (canDel != null) {
this.error(0, canDel, req, resp);
return;
}
} else {
error(0, MsgConstant.NO_CONTENT, req, resp);
return;
}
b = true;
try {
trans.begin();
} catch (Exception ex) {
ex.printStackTrace();
System.out.print("Cannot create transaction");
}
// 新增2007-10-12
ItemsTemp itemsTemp = new ItemsTemp(loginInfo.getJndiName());
b = b
&& itemsTemp.deleteBySheetCode(exSheetAdapter
.getExSheetCode());
//
ExItemsAdapter adapter = new CExItemsAdapter(loginInfo
.getJndiName());
b = b
&& adapter.deleteByExSheetCode(exSheetAdapter
.getExSheetCode());
b = b && exSheetAdapter.delete();
sys = new ConcreteSysUserAdapter(loginInfo.getJndiName());
new SheetLog(loginInfo.getJndiName(), exSheetAdapter
.getExSheetCode(), "删除", sys.getCreateBy(loginInfo
.getSysUserCode())[0], Integer.parseInt(sys
.getCreateBy(loginInfo.getSysUserCode())[2]), "");
try {
if (b) {
trans.commit();
new WriteLog(loginInfo.getJndiName(), 2,
EventCode.EX_SHEET_DELETE, loginInfo.getName(),
req.getRemoteAddr(), "删除：销售单："
+ exSheetAdapter.getExSheetCode()
+ " ：Y", getClass().getName()
+ ":EX_SHEET_DELETE", true, loginInfo
.getSysUserCode());
}
else {
trans.rollback();
new WriteLog(loginInfo.getJndiName(), 3,
EventCode.EX_SHEET_DELETE, loginInfo.getName(),
req.getRemoteAddr(), "删除：销售单："
+ exSheetAdapter.getExSheetCode()
+ " ：N", getClass().getName()
+ ":EX_SHEET_DELETE", true, loginInfo
.getSysUserCode());
error(0, MsgConstant.DAO_ERROR, req, resp);
return;
}
} catch (Exception ex) {
ex.printStackTrace();
}
break;
case EventCode.EX_SHEET_QUERY_S:
case EventCode.EX_SHEET_REPORT_QUERY_S:
StringBuffer adv = new StringBuffer(100);
if (!"".equals(adapter2.getRegionID())
&& adapter2.getRegionID() != null) {
adv
.append(" and a.custID in (select custID from customer where regionID like '");
adv.append(adapter2.getRegionID());
adv.append("%')");
}
if (adapter2.getDiscount1() != 0) {
adv.append(" and b.discount>=");
adv.append(adapter2.getDiscount1());
}
if (adapter2.getDiscount3() != 0) {
adv.append(" and b.discount<=");
adv.append(adapter2.getDiscount3());
}
if (!"".equals(adapter2.getExSheetCode())
&& adapter2.getExSheetCode() != null) {
adv.append(" and a.exSheetCode ='");
adv.append(adapter2.getExSheetCode());
adv.append("'");
}
if (adapter2.getCustID() != 0) {
adv.append(" and a.custID =");
adv.append(adapter2.getCustID());
} else {
adv.append(Perm.sqlCondSQL("a", "custID", loginInfo.params
.getCustomerPerm()));
}
if ((eventCode == EventCode.EX_SHEET_REPORT_QUERY_S)
&& (adapter2.getStat() == 0)) {
if (adapter2.getWarehouseCode() != 0) {
adv.append(" and b.warehouseCode ='");
adv.append(adapter2.getWarehouseCode());
adv.append("'");
} else {
adv.append(Perm.sqlCondSQL("b", "warehouseCode",
loginInfo.params.getWarehousePerm()));
}
} else {
if (adapter2.getWarehouseCode() != 0) {
adv.append(" and a.warehouseCode ='");
adv.append(adapter2.getWarehouseCode());
adv.append("'");
} else {
adv.append(Perm.sqlCondSQL("a", "warehouseCode",
loginInfo.params.getWarehousePerm()));
}
}
if (adapter2.getEmplID() != 0) {
adv.append(" and a.emplID =");
adv.append(adapter2.getEmplID());
}
if (!"".equals(adapter2.getRemark())
&& adapter2.getRemark() != null) {
adv.append(" and a.remark like '%");
adv.append(adapter2.getRemark());
adv.append("%'");
}
if (!"".equals(adapter2.getCreateDate1())
&& !"".equals(adapter2.getCreateDate3())) {
adv.append(" and a.createDate between '");
adv.append(adapter2.getCreateDate1());
adv.append("' and '");
adv.append(adapter2.getCreateDate3());
adv.append("'");
}
if (!"".equals(adapter2.getCreateDate1())
&& "".equals(adapter2.getCreateDate3())) {
adv.append(" and a.createDate >= '");
adv.append(adapter2.getCreateDate1());
adv.append("'");
}
if ("".equals(adapter2.getCreateDate1())
&& !"".equals(adapter2.getCreateDate3())) {
adv.append(" and a.createDate <= '");
adv.append(adapter2.getCreateDate3());
adv.append("'");
}
if (adapter2.getIsAcc()) {
adv.append(" and a.isAcc=1");
}
if (adapter2.getIsExtAcc()) {
adv.append(" and a.isExtAcc=1");
}
if (adapter2.getIsRegLed()) {
adv
.append(" and (a.isAcc=0 and a.isRegLed=0 and a.isVou=1) ");
}
if (adapter2.getIsReg()) {
adv
.append(" and (a.isAcc=0 and a.isReg=0 and a.isRegLed=1) ");
}
if (adapter2.getIsFin()) {
adv.append(" and (a.isAcc=0 and a.isRegLed=1) ");
}
if (adapter2.getIsEnd()) {
adv.append(" and a.isEnd=0");
}
if (adapter2.getCode() != null
&& !"".equals(adapter2.getCode())) {
int pos = adapter2.getCode().indexOf(",");
if (pos == -1) {
adv
.append(" and isnull(c.gdsNo,'') +isnull(c.gdsName,'')+ isnull(c.code,'') like '%");
adv.append(adapter2.getCode());
adv.append("%'");
} else {
StringBuffer sb = new StringBuffer(100);
sb.append(" and (");
StringTokenizer token = new StringTokenizer(adapter2
.getCode(), ",");
int ccc = 0;
int sizeccc = token.countTokens();
while (token.hasMoreElements()) {
ccc++;
String label = token.nextElement().toString();
sb.append(" c.gdsNo='");
sb.append(label);
sb.append("'");
if (ccc < sizeccc) {
sb.append(" or ");
}
}
sb.append(") ");
adv.append(sb.toString());
}
}
if (!"".equals(adapter2.getClassID())) {
adv.append(" and c.classID like '");
adv.append(adapter2.getClassID());
adv.append("%'");
}
if (adapter2.getOperator() > 0) {
adv.append(" and a.operator =");
adv.append(adapter2.getOperator());
}
if (eventCode == EventCode.EX_SHEET_QUERY_S) {
} else {
if (adapter2.getBrandID() != 0) {
adv.append(" and c.brandID =");
adv.append(adapter2.getBrandID());
} else {
if (adapter2.getStat() != 4) {
adv.append(Perm.sqlCondSQL("c", "brandID",
loginInfo.params.getBrandPerm()));
}
}
}
if (!"".equals(adapter2.getCheckRemark())) {
adv.append(" and a.checkRemark like '");
adv.append(adapter2.getCheckRemark());
adv.append("%'");
}
if (!"".equals(adapter2.getBackRemark())) {
adv.append(" and a.backRemark like '");
adv.append(adapter2.getBackRemark());
adv.append("%'");
}
if (!"".equals(adapter2.getOrderMySheetCode())) {
adv.append(" and a.orderMySheetCode like '");
adv.append(adapter2.getOrderMySheetCode());
adv.append("%'");
}
if (!"".equals(adapter2.getNotifySheetCode())) {
adv.append(" and a.notifySheetCode like '");
adv.append(adapter2.getNotifySheetCode());
adv.append("%'");
}
if (!"".equals(adapter2.getNoteSheetCode())) {
adv.append(" and a.noteSheetCode like '");
adv.append(adapter2.getNoteSheetCode());
adv.append("%'");
}
if (!"".equals(adapter2.getSheetOrderType())) {
adv.append(" and a.sheetOrderType = '");
adv.append(adapter2.getSheetOrderType());
adv.append("'");
}
if (adapter2.getSheetPriceType() != 0) {
adv.append(" and a.sheetPriceType = ");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -