public void Delete(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
Table table = dataDom.getTable("YXDBJYMST");
Row row = table.getRow(0L);
if (row == null) {
serviceRequest.getMessage().addInfo("没有需要删除的数据");
return;
}
String pkValue = table.getPkValue();
if ((pkValue == null) || ("".equals(pkValue.trim()))) {
serviceRequest.getMessage().addInfo("没有需要删除的数据");
return;
}
Database db = null;
try {
db = Tools.getDatabase(false);
deleteChildTable(dataDom, sessionInfo, serviceRequest, db);
super.Delete(dataDom, sessionInfo, serviceRequest, db);
db.commit();
dataDom.refresh(sessionInfo);
serviceRequest.getMessage().addInfo("删除数据成功");
} catch (Exception e) {
if (db != null) {
db.rollback();
}
Log.error(e);
serviceRequest.getMessage().addInfo("发生异常，请联系管理员");
} finally {
if (db != null) {
db.cleanup();
}
dataDom.refresh(sessionInfo);
}
init(dataDom, sessionInfo, serviceRequest);
}
public String getuser(String usrid, HttpServletRequest request) {
String resu = "";
Database db = null;
Rowset rs = null;
try {
db = Tools.getDatabase(true);
String str_ALLUSRID = usrid;
String[] ARR_USR = str_ALLUSRID.split("\\|");
String str_rtn = "";
for (int i = 0; i < ARR_USR.length; i++) {
String str_USRID = ARR_USR[i];
if ((str_USRID != null) && (!str_USRID.equals(""))) {
String str_SQL = "select USR_NAM from UTUSRMST where USR_ID = '" + str_USRID + "'";
rs = db.getRS(str_SQL);
if (rs.next()) {
String userpos = getUserInfo.getAttribute(str_USRID);
if ((userpos == null) || (userpos.equals(""))) {
userpos = " ";
}
if (str_rtn.equals("")) {
str_rtn = str_USRID + "|" + rs.getString("USR_NAM") + "|" + userpos;
} else {
str_rtn = str_rtn + "||" + str_USRID + "|" + rs.getString("USR_NAM") + "|" + userpos;
}
}
}
}
resu = str_rtn;
} catch (Exception e) {
Log.error(e);
} finally {
db.cleanup();
}
return resu;
}
public static void Wf_createFstNode(String params, HttpServletRequest request) throws Exception {
String[] p = params.split("\\;");
String userid = p[0];
String progid = p[1];
String dicttblid = p[2];
String seq = p[3];
String mdltypno = p[4];
String org_no = p[5];
Database db = null;
Rowset rs = null;
String sql = null;
try {
sql = "select WFAPP_ID from WFMDLTYPMST where MDLTYP_NO = " + mdltypno;
rs = WorkFlowExecSql.wf_getRs(sql);
String appid = "";
if (rs.next()) {
appid = rs.getString(1);
}
WorkflowUtil.creatFstNode(
dicttblid, progid, appid, seq, mdltypno, userid, "0", "2", null, "", org_no);
} catch (Exception se) {
se.printStackTrace();
} finally {
if (db != null) {
db.cleanup();
}
}
}
public void Delete(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
Table table = dataDom.getTable("YXPBPFMST");
Row row = table.getRow(0L);
if (row == null) {
/* */ serviceRequest.getMessage().addInfo("没有需要删除的数据！");
return;
}
String pkValue = table.getPkValue();
if ((pkValue == null) || ("".equals(pkValue.trim()))) {
serviceRequest.getMessage().addInfo("没有需要删除的数据！");
return;
}
Database db = null;
try {
db = Tools.getDatabase(false);
deleteChildTable(dataDom, sessionInfo, serviceRequest, db);
super.Delete(dataDom, sessionInfo, serviceRequest, db);
db.commit();
serviceRequest.getMessage().addInfo("删除成功！");
} catch (Exception e) {
if (db != null) {
db.rollback();
}
Log.error(e);
serviceRequest.getMessage().addInfo("删除失败,请重试或联系系统管理员！");
} finally {
if (db != null) db.cleanup();
}
}
public void clearDLFL_AMT(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest)
throws Exception {
Table table = dataDom.getTable("YXPRJMST");
Database db = null;
String pk = "";
try {
db = Tools.getDatabase(false);
save(dataDom, sessionInfo, serviceRequest);
serviceRequest.getMessage().clear();
pk = table.getPkValue();
db.execSqlUpdate("update YXPRJLIN set DLFL_AMT='' where PRJ_NO = " + pk);
db.commit();
pk = table.getPkValue();
WhereLimit wr = new WhereLimit();
wr.addColumn(new Column("PRJ_NO", pk));
dataDom.getTable("YXPRJLIN").setWhereLimit(wr);
dataDom.getTable("YXPRJLIN").refresh("B1YXM00030", sessionInfo);
} catch (Exception ex) {
db.rollback();
Log.error(ex);
} finally {
if (db != null) {
db.cleanup();
}
}
}
public void DeleteAllSubTable_FB(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws Exception {
Table table = dataDom.getTable("YXPRJMST");
Database db = null;
String pk = "";
try {
db = Tools.getDatabase(false);
save(dataDom, sessionInfo, serviceRequest);
serviceRequest.getMessage().clear();
pk = table.getPkValue();
if ((pk != null) && (!"".equals(pk))) {
db.execSqlUpdate("delete from YXPRJLIN where IS_FB='Y' and PRJ_NO = " + pk);
}
db.commit();
WhereLimit wr = new WhereLimit();
wr.addColumn(new Column("PRJ_NO", pk));
dataDom.getTable("YXPRJLIN").setWhereLimit(wr);
dataDom.getTable("YXPRJLIN").refresh("B1YXM00030", sessionInfo);
} catch (Exception ex) {
if (db != null) {
db.rollback();
}
Log.error(ex);
} finally {
if (db != null) {
db.cleanup();
}
}
}
public void CST_NO_onblur(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
Database db = null;
Rowset rs = null;
String sql = "";
String cstNo = "";
String cstId = "";
String cstNam = "";
try {
db = Tools.getDatabase(true);
cstId = Charset.nullToEmpty(serviceRequest.getParameter("value"));
if (!cstId.equals("")) {
sql = "select cst_no,cst_nam from ogcstmst where cst_id='" + cstId + "'";
rs = db.getRS(sql);
if (rs.getRowCount() <= 0) {
serviceRequest.addServiceReturnParameter("CSTFLG", "FALSE");
return;
} else {
if (rs.next()) {
cstNo = Charset.nullToEmpty(rs.getString("cst_no"));
cstNam = Charset.nullToEmpty(rs.getString("cst_nam"));
}
}
}
serviceRequest.addServiceReturnParameter("CSTFLG", "TRUE");
serviceRequest.addServiceReturnParameter("CST_NO", cstNo);
serviceRequest.addServiceReturnParameter("CST_NAM", cstNam);
} catch (Exception e) {
Log.error(e);
} finally {
if (db != null) db.cleanup();
}
}
public static void Wf_createFstNodeS(String params, HttpServletRequest request) throws Exception {
String[] p = params.split("\\;");
String userid = p[0];
String progid = p[1];
String dicttblid = p[2];
String seq = p[3];
String mdltypno = p[4];
String org_no = p[5];
Database db = null;
Rowset rs = null;
Rowset rsin = null;
Rowset obrs = null;
Rowset currrs = null;
String sql = null;
String startobj = null;
StringBuffer rtn = new StringBuffer();
sql = "SELECT user_id FROM WFSTRIGMST WHERE MDLTYP_NO='" + mdltypno + "' and USER_FLG='1'";
try {
rs = WorkFlowExecSql.wf_getRs(sql);
int i = 0;
while (rs.next()) {
if (i < rs.getRowCount()) {
rtn.append(rs.getString(1) + ";");
} else {
rtn.append(rs.getString(1));
}
i++;
}
String version = WorkFlowUtilExt.getWorkFlowCurrVerison(mdltypno);
sql =
"select object_no from wfobjmst t where t.model_no='"
+ version
+ "' and t.object_typ='01'";
obrs = WorkFlowExecSql.wf_getRs(sql);
if (obrs.next()) {
startobj = obrs.getString(1);
}
sql = "select object_no from vw_wfobjrelmst where head='" + startobj + "'";
currrs = WorkFlowExecSql.wf_getRs(sql);
if (currrs.next()) {
rtn = new StringBuffer(currrs.getString(1) + "|").append(rtn);
}
sql = "select WFAPP_ID from WFMDLTYPMST where MDLTYP_NO = " + mdltypno;
rsin = WorkFlowExecSql.wf_getRs(sql);
String appid = "";
if (rs.next()) {
appid = rsin.getString(1);
}
WorkflowUtil.creatFstNode(
dicttblid, progid, appid, seq, mdltypno, userid, "0", "1", rtn.toString(), "", org_no);
} catch (Exception se) {
se.printStackTrace();
} finally {
if (db != null) {
db.cleanup();
}
}
}
public static String deletedata(String params, HttpServletRequest request) throws Exception {
Database db = null;
try {
db = Tools.getDatabase(true);
String sql = "delete from WFTESTMST where CLIENTIP = '" + request.getRemoteAddr() + "'";
db.execSqlUpdate(sql);
} catch (SQLException se) {
Log.error(se.getMessage());
return "删除失败";
} finally {
if (db != null) {
db.cleanup();
}
}
return "删除成功";
}
public static void initWhereLimit(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
String userId = sessionInfo.getUserId();
if (!"SYS".equals(userId)) {
String issql = " select count(1) num ";
issql = issql + " from dkworkgrpmst a ";
issql = issql + " left join dkworkgrpposlnk c on a.workgrp_id=c.workgrp_id ";
issql = issql + " left join cmpositionmst d on c.pos_no=d.position_no ";
issql = issql + " left join cmempposmst e on d.position_no=e.position_no ";
issql = issql + " left join cmempmst f on e.emp_no=f.emp_no ";
issql = issql + " where f.emp_id='" + userId + "' and a.workgrp_id='XMXICK' ";
String num = Database.getValue(issql);
if (!num.equals("1")) {
String pkField = dataDom.getRootTable().getPkFieldName();
String tableName = dataDom.getRootTable().getName();
String wfSql = JHSMMST.getUsrWfSql(tableName, userId); // 当前用户有关的工作流记录数据
String lmt =
"1=1 AND ( PRJ_FMNG='"
+ userId
+ "' or PRJ_SMNG='"
+ userId
+ "' or FSTUSR_ID='"
+ userId
+ "' or "
+ pkField
+ " in ("
+ wfSql
+ "))";
dataDom.getRootTable().getWhereLimit().addColumn("new_sql_wherelimit", lmt);
}
}
}
public boolean deleteChildTable(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest, Database db)
throws LiemsException {
try {
if ((dataDom.getRootTable().getPkValue() != null)
&& (!"".equals(dataDom.getRootTable().getPkValue()))) {
String sql = "delete from YXPRJLIN where PRL_NO=" + dataDom.getRootTable().getPkValue();
String sql2 = "delete from YXDOCMST where PRJ_NO=" + dataDom.getRootTable().getPkValue();
db.execSqlUpdate(sql);
db.execSqlUpdate(sql2);
}
} catch (Exception e) {
e.printStackTrace();
}
return true;
}
public void Delete(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
Table table = dataDom.getTable("YXPRJMST");
Row row = table.getRow(0L);
if (row == null) {
serviceRequest.getMessage().addInfo("没有需要删除的数据！");
return;
}
String pkValue = table.getPkValue();
if ((pkValue == null) || ("".equals(pkValue.trim()))) {
serviceRequest.getMessage().addInfo("没有需要删除的数据！");
return;
}
Database db = null;
try {
db = Tools.getDatabase(false);
deleteChildTable(dataDom, sessionInfo, serviceRequest, db);
super.Delete(dataDom, sessionInfo, serviceRequest, db);
db.commit();
String pk = table.getPkValue();
table.refreshG(pk);
pk = table.getPkValue();
WhereLimit wl = new WhereLimit();
wl.addColumn("new_sql_wherelimit", "PRJ_NO =" + pk);
Log.info("PRJ_NO:" + pk);
dataDom.getTable("YXPRJLIN").setWhereLimit(wl);
dataDom.getTable("YXPRJLIN").refresh2("B1YXM00030", sessionInfo);
} catch (Exception e) {
if (db != null) {
db.rollback();
}
Log.error(e);
serviceRequest.getMessage().addInfo("删除失败,请重试或联系系统管理员！");
table.refresh("B1YXM00030", sessionInfo);
;
} finally {
if (db != null) {
db.cleanup();
}
}
}
public void setReadOnly(DataDom dataDom) {
String prjNo = dataDom.getRootTable().getSafeRowColumnValue("PRJ_NO");
if ((prjNo != null) && (!(prjNo.equals("")))) {
String stag = Database.getValue("select PRJ_STAG from yxprjmst where PRJ_NO=" + prjNo);
if (!("05".equals(stag))) {
dataDom.getChildTable().getField("TBR_NO").setReadonly(true);
dataDom.getChildTable().getField("SWPF_SCT").setReadonly(true);
dataDom.getChildTable().getField("SWPF_NOT").setReadonly(true);
}
}
}
public void isSplitChange(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
try {
String pkValue = dataDom.getRootTable().getPkValue();
if ((pkValue != null) && (!"".equals(pkValue))) {
Database.execString("delete from yxprjlin where prj_no=" + pkValue);
}
} catch (Exception e) {
Log.error(e);
}
}
private Object _$15996(String pk) {
String id = "";
try {
Rowset rs = Database.getRowset("select PRJL_ID from YXPRJLIN where PRJL_NO =" + pk);
if (rs.next()) {
id = rs.getString("PRJL_ID");
}
} catch (Exception e) {
e.printStackTrace();
}
return id;
}
private void initTBRTable(DataDom dataDom, String prjNo, Database db) throws Exception {
String sql1 = "select PRJL_NO from YXPRJLIN where PRJ_NO = " + prjNo;
String unit = getMonUnit(prjNo);
Rowset rs = db.getRS(sql1);
CommSequence seq = CommSequence.getInstance("YXDBJYLIN_SEQ");
while (rs.next()) {
String prjlNo = Charset.nullToEmpty(rs.getString("PRJL_NO"));
String sql =
"insert into YXDBJYLIN(DBJYL_NO,PRJL_NO,PRJ_NO,IS_NTC,IS_RCV,MON_UNIT)values("
+ seq.getNextValue()
+ ","
+ prjlNo
+ ","
+ Charset.nullToEmpty(prjNo)
+ ","
+ "'N', 'N',"
+ unit
+ ")";
db.execSqlUpdate(sql);
}
}
/**
* ??????????????л?????λ
*
* @param prj_no
* @return
* @addTime 2014-2-25 ????10:47:13
* @author Libo
*/
private String getMonUnit(String prj_no) {
String unit = "";
try {
Rowset rs =
Database.getRowset("SELECT MON_UNIT FROM YXKBRMST WHERE PRJ_NO = '" + prj_no + "'");
if (rs.next()) {
unit = Charset.nullToEmpty(rs.getString(1));
}
} catch (Exception e) {
Log.error(e);
}
return unit;
}
public void DeleteAllSubTable(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws Exception {
Table table = dataDom.getTable("YXPRJMST");
Database db = null;
String pk = "";
try {
db = Tools.getDatabase(false);
save(dataDom, sessionInfo, serviceRequest);
serviceRequest.getMessage().clear();
pk = table.getPkValue();
db.execSqlUpdate("delete from YXPRJLIN where PRJ_NO = " + pk);
db.commit();
} catch (Exception ex) {
db.rollback();
Log.error(ex);
} finally {
if (db != null) {
db.cleanup();
}
}
setFirstRowSubTable(dataDom, sessionInfo, serviceRequest);
}
public void setFirstRowSubTable(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws Exception {
String ZB_ID = serviceRequest.getParameter("ZB_ID");
String PRJ_NAM = serviceRequest.getParameter("PRJ_NAM");
Table table = dataDom.getTable("YXPRJMST");
Database db = null;
String pk = "";
try {
db = Tools.getDatabase(false);
pk = table.getPkValue();
String nextPkValue = CommSequence.getInstance("YXPRJLIN_SEQ").getNextValue();
db.execSqlUpdate(
"insert into YXPRJLIN(PRJL_NO,PRJ_NO,PRJL_ID,PRJL_NAM,IS_FB) values( "
+ nextPkValue
+ ","
+ pk
+ ",'"
+ ZB_ID
+ "','"
+ PRJ_NAM
+ "','Y') ");
db.commit();
pk = table.getPkValue();
WhereLimit wr = new WhereLimit();
wr.addColumn(new Column("PRJ_NO", pk));
dataDom.getTable("YXPRJLIN").setWhereLimit(wr);
dataDom.getTable("YXPRJLIN").refresh("B1YXM00030", sessionInfo);
} catch (Exception ex) {
db.rollback();
Log.error(ex);
} finally {
if (db != null) {
db.cleanup();
}
}
}
public static String getFWList(String params, HttpServletRequest request) throws Exception {
String reStr = "";
String sql =
"select t.MDLTYP_NO from OADOCTMPLMST t where t.WORKFLOW_TYP='02' and t.ORG_NO=" + params;
Rowset rs = Database.getRowset(sql);
int i = 1;
while (rs.next()) {
reStr = reStr + rs.getString("MDLTYP_NO");
if (rs.getRowCount() > i) {
reStr = reStr + ";";
}
i++;
}
return reStr;
}
private boolean saveBefore(
DataDom dataDom, ServiceRequest serviceRequest, SessionInfo sessionInfo) {
Table ctb = dataDom.getChildTable();
String pkValue = dataDom.getRootTable().getPkValue();
ArrayList<String> prjlIds = new ArrayList<String>();
try {
Rowset rs = Database.getRowset("select PRJL_ID from YXPRJLIN where PRJ_NO =" + pkValue);
while (rs.next()) {
String lid = rs.getString("PRJL_ID");
prjlIds.add(lid);
}
Iterator<?> it = ctb.getRows().keySet().iterator();
String zbId = dataDom.getRootTable().getSafeRowColumnValue("PRJ_ID");
while (it.hasNext()) {
String rowNo = (String) it.next();
Row row = (Row) ctb.getRows().get(rowNo);
String rPk = row.getColumnValue("PRJL_NO");
if ((rPk != null) && (Integer.parseInt(rPk) > 0)) {
prjlIds.remove(_$15996(rPk));
}
}
Iterator<?> it2 = ctb.getRows().keySet().iterator();
while (it2.hasNext()) {
String rowNo = (String) it2.next();
Row row = (Row) ctb.getRows().get(rowNo);
String prjId = row.getColumnValue("PRJL_ID");
if (prjlIds.contains(prjId)) {
serviceRequest
.getMessage()
.addError("第" + (Integer.parseInt(rowNo) + 1) + "行的分包编号之前已经使用过，请重新输入！");
return false;
}
if ((!prjId.startsWith(zbId + "-")) && (!prjId.equals(zbId))) {
serviceRequest
.getMessage()
.addError("第" + (Integer.parseInt(rowNo) + 1) + "行的分包编号格式错误，未包含招标编号，请重新输入！");
return false;
}
prjlIds.add(prjId);
}
} catch (Exception e) {
e.printStackTrace();
Log.error(e);
return false;
}
return true;
}
public static String getLinCount(String params, HttpServletRequest request) {
String flag = "0";
String pkValue = params;
try {
if ((pkValue != null) && (!"".equals(pkValue))) {
Rowset rs =
Database.getRowset("select count(1) num from YXPRJLIN where PRJ_NO = " + pkValue);
if (rs.next()) {
return rs.getString("num");
}
}
} catch (Exception ex) {
Log.error(ex.getMessage());
ex.printStackTrace();
}
return flag;
}
public boolean deleteChildTable(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest, Database db)
throws LiemsException {
try {
String sql =
"delete from "
+ dataDom.getChildTable().getName()
+ " where "
+ dataDom.getRootTable().getPkFieldName()
+ "="
+ dataDom.getRootTable().getPkValue();
db.execSqlUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
}
return true;
}
/** 扩展字段 创建下拉列表 Select aa = dataDom.getExtend().getSelect("字段"); */
public void creatSel(Select select, String strSQL, boolean canNull) {
try {
Rowset rs = Database.getRowset(strSQL);
if (select != null) {
for (int i = 0; i < select.getOptions().size(); i++) {
select.removeOption(i);
}
}
if (canNull) {
select.addOption(new Option("", ""));
}
if (rs != null)
while (rs.next()) select.addOption(new Option(rs.getString(1), rs.getString(2)));
} catch (Exception e) {
Log.error(e);
}
}
public String setVenLxr(String org_no, HttpServletRequest request) {
String venNo = Charset.nullToEmpty(request.getParameter("venNo"));
String returnValue = "";
String sql = "SELECT LXR_NAM FROM HLVDVENLIN WHERE VEN_NO=" + venNo;
try {
Rowset rs = Database.getRowset(sql);
while (rs.next()) {
String lixNam = Charset.nullToEmpty(rs.getString("LXR_NAM"));
returnValue = returnValue + ",['" + lixNam + "','" + lixNam + "']";
}
if ((returnValue.length() > 0) && (returnValue.charAt(0) == ',')) {
returnValue = returnValue.substring(1);
returnValue = "array=[" + returnValue + "]";
}
} catch (Exception e) {
e.printStackTrace();
}
return returnValue;
}
public void initEvalSelector(DataDom dataDom, String prjlNo, String prjNo) {
String sql = "";
String PW_TYP = Database.getValue("select PW_TYP from YXHSPWMST where PRJ_NO=" + prjNo);
if ("B".equals(PW_TYP)) {
// 独立评委 独立评分
sql =
"select EVAL_PERS_NAM,EVAL_PERS_NO from YXPJEVALPERSMST where EVAL_PERS_NO in(select EVAL_PERS_NO from YXHSPWLIN where PRJ_NO='"
+ prjNo
+ "' and PRJL_NO='"
+ prjlNo
+ "' and EVAL_TYP='T')";
} else if ("A".equals(PW_TYP)) {
// 统一评委 独立评分
sql =
"select EVAL_PERS_NAM,EVAL_PERS_NO from YXPJEVALPERSMST where EVAL_PERS_NO in(select EVAL_PERS_NO from YXHSPWLIN where PRJ_NO='"
+ prjNo
+ "' and PRJL_NO is null and EVAL_TYP='T')";
}
creatSel(dataDom.getExtend().getSelect("evalSelector"), sql, false, false);
}
public void reStartPrj(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
String pkValue = dataDom.getRootTable().getPkValue();
if ((pkValue != null) && (!"".equals(pkValue))) {
CommSequence cs = CommSequence.getInstance("YXPRJMST_SEQ");
CommCodeNumber KLTYPID =
new CommCodeNumber("PRJ", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId());
String newPk = cs.getNextValue();
String prjNam = dataDom.getRootTable().getSafeRowColumnValue("PRJ_NAM");
String rSql =
"declare v_wkpl YXPRJMST%rowtype; zbTime yxprjmst.ZB_TIMES%type; begin select * into v_wkpl from YXPRJMST where PRJ_NO ="
+ pkValue
+ ";"
+ " v_wkpl.OLD_PRJ := v_wkpl.PRJ_NO;"
+ " v_wkpl.PRJ_NO := "
+ newPk
+ ";"
+ " select nvl(max(ZB_TIMES),v_wkpl.ZB_TIMES) into zbTime from YXPRJMST where PRJ_NAM ='"
+ prjNam
+ "';"
+ " v_wkpl.ZB_TIMES := zbTime+1;"
+ " v_wkpl.VALID_STA := 'A';"
+ " v_wkpl.VEN_NO := null;"
+ " v_wkpl.ZB_ID := null;"
+ " v_wkpl.PRJ_STA := '00';"
+ " v_wkpl.PRJ_STAG := '01';"
+ " v_wkpl.PRJ_ID := '"
+ KLTYPID.getNextValue()
+ "';"
+ " v_wkpl.FSTUSR_DTM := sysdate;"
+ " v_wkpl.FSTUSR_ID := '"
+ sessionInfo.getUserId()
+ "';"
+ " insert into YXPRJMST values v_wkpl;"
+ "end;";
Database.execString(rSql);
setForwardURL(Tools.getProgramURL(dataDom, "B1YXM00030", "jsp?pkValue=" + newPk));
} else {
serviceRequest.getMessage().addError("请先维护主表！");
}
}
private void initNoSplitTbrTab(DataDom dataDom, String prjNo, Database db) throws Exception {
String sql =
"select t.TBR_NAM,t.TBR_NO,d.PRJL_NO from YXTBRMST t join YXBJDFLIN d on t.TBR_NO=d.TBR_NO where d.PRJ_NO = "
+ prjNo;
Rowset rs = db.getRS(sql);
Table ct1 = dataDom.getTable("YXDBJYLIN");
Row row = new Row(false, 0, 0, "new");
row.addColumn("PRJ_NO", Charset.nullToEmpty(prjNo));
String unit = getMonUnit(prjNo);
row.addColumn("IS_NTC", "N");
row.addColumn("IS_RCV", "N");
row.addColumn("MON_UNIT", unit);
if (rs.next()) {
row.addColumn("PRJL_NO", Charset.nullToEmpty(rs.getString("PRJL_NO")));
row.addColumn("TBR_NO", rs.getString("TBR_NO"));
ct1.getRows().put("0", row);
creatSel(ct1.getField("TBR_NO"), sql, false, false);
} else {
ct1.clearRow();
}
}
/**
* 招标代理费生成
*
* @param dataDom
* @param sessionInfo
* @param serviceRequest
* @throws LiemsException
*/
public void creatDLFEE(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest)
throws LiemsException {
Database db = null;
Table table = dataDom.getTable("YXDBJYMST");
Row currRow = table.getRow(0L);
try {
db = Tools.getDatabase(true);
String DBJY_NO = currRow.getColumnValue("DBJY_NO");
String PRJ_NO = currRow.getColumnValue("PRJ_NO");
String ORG_NO = currRow.getColumnValue("ORG_NO");
Vector<String> vc = new Vector<String>();
String sel1 =
"select distinct TBR_NO from YXDBJYLIN where DBJY_NO=" + DBJY_NO + " and IS_ZB='01'";
Rowset rs = db.getRS(sel1);
while (rs.next()) {
// 查询投标单位 生成主表
String TBR_NO = rs.getString("TBR_NO");
CommSequence cs = CommSequence.getInstance("YXDLFMST_SEQ");
String TBDJ_NO = cs.getNextValue();
CommCodeNumber seq =
new CommCodeNumber(
"DLF", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId(), db);
String TBDJ_ID = seq.getNextValue();
String insertSQL =
" insert into YXDLFMST(DLF_NO,ORG_NO,DLF_STA,DLF_ID,PRJ_NO,TBR_NO,FSTUSR_ID,FSTUSR_DTM) "
+ " values("
+ TBDJ_NO
+ ","
+ ORG_NO
+ ",'00','"
+ TBDJ_ID
+ "',"
+ PRJ_NO
+ ",'"
+ TBR_NO
+ "','"
+ sessionInfo.getUserId()
+ "',sysdate) ";
vc.add(insertSQL);
// 查询标包 生成子表明细数据
String sel2 =
"select YXDBJYLIN.PRJL_NO,YXPRJLIN.DLFL_AMT from YXDBJYLIN,YXPRJLIN "
+ " where YXDBJYLIN.PRJL_NO=YXPRJLIN.PRJL_NO and YXDBJYLIN.TBR_NO = "
+ TBR_NO
+ " and YXDBJYLIN.DBJY_NO="
+ DBJY_NO
+ " and YXDBJYLIN.IS_ZB='01'";
Rowset rs2 = db.getRS(sel2);
while (rs2.next()) {
String PRJL_NO = rs2.getString("PRJL_NO");
CommSequence cs2 = CommSequence.getInstance("YXDBJYLIN_SEQ");
String TBDJL_NO = cs2.getNextValue();
String DLFL_AMT = rs2.getString("DLFL_AMT");
insertSQL =
" insert into YXDBJYLIN(DLFL_NO,DLF_NO,TBR_NO,PRJ_NO,PRJL_NO,DLFL_AMT,IS_JF) "
+ " values("
+ TBDJL_NO
+ ","
+ TBDJ_NO
+ ","
+ TBR_NO
+ ","
+ PRJ_NO
+ ","
+ PRJL_NO
+ ","
+ DLFL_AMT
+ ", 'N')";
vc.add(insertSQL);
}
}
db.execSqlUpdateBatch(vc);
db.commit();
serviceRequest.addServiceReturnParameter("relString", "true");
} catch (Exception e) {
e.printStackTrace();
serviceRequest.addServiceReturnParameter("relString", e.toString());
} finally {
if (db != null) {
db.cleanup();
}
}
}
public void save(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest)
throws LiemsException {
if (!saveBefore(dataDom, serviceRequest, sessionInfo)) {
return;
}
Table table = dataDom.getTable("YXPRJMST");
Database db = null;
Row currRow = table.getRow(0L);
if (currRow == null) {
table.addRow(new Row(false, 0, 0, "new"));
currRow = table.getRow(0L);
}
currRow.setFirstLastUserInfo(sessionInfo.getUserId());
try {
db = Tools.getDatabase(false);
String isSplit = dataDom.getRootTable().getSafeRowColumnValue("IS_SPLIT");
if (currRow.getDataStatus().equals("new")) {
currRow.addColumn("ORG_NO", sessionInfo.getDefaultOrg());
if ((currRow.getColumn("PRJ_ID") == null)
|| (currRow.getColumn("PRJ_ID").getValue() == null)
|| (currRow.getColumn("PRJ_ID").getValue().equals(""))) {
String idTyp = currRow.getColumnValue("PRJ_EXT02");
if ("A".equals(idTyp)) {
CommCodeNumber KLTYPID =
new CommCodeNumber(
"PRJ", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId());
currRow.addColumn(new Column("PRJ_ID", KLTYPID.getNextValue()));
}
CommCodeNumber ZB_ID =
new CommCodeNumber("ZBBH", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId());
currRow.addColumn(new Column("ZB_ID", ZB_ID.getNextValue()));
currRow.addColumn("VALID_STA", "A");
currRow.addColumn(new Column("ZB_TIMES", "1"));
}
if ("N".equals(isSplit)) {
Row row = new Row(false, 0, 0, "new");
row.addColumn("PRJL_NAM", currRow.getColumnValue("PRJ_NAM"));
row.addColumn("PRJL_ID", currRow.getColumnValue("PRJ_ID"));
row.addColumn("BZ_AMT", "0.00");
row.addColumn("IS_FB", "Y");
dataDom.getChildTable().getRows().put("0", row);
}
}
String dlfTyp = dataDom.getRootTable().getSafeRowColumnValue("DLF_TYP");
super.save(dataDom, sessionInfo, serviceRequest, db);
db.commit();
String pkValue = currRow.getPkValue("PRJ_NO");
if (isSplit.equals("Y")) {
String sql = "";
if (dlfTyp.equals("B")) {
sql =
"update YXPRJMST set ZBS_AMT = (select sum(ZBS_AMT) from YXPRJLIN where PRJ_NO="
+ pkValue
+ "),"
+ "BZ_AMT = (select sum(BZ_AMT) from YXPRJLIN where PRJ_NO="
+ pkValue
+ "),"
+ "DL_AMT=(select sum(DLFL_AMT) from YXPRJLIN where PRJ_NO="
+ pkValue
+ ")"
+ " where PRJ_NO = "
+ pkValue;
dataDom.getChildTable().getField("DLFL_AMT").setReadonly(false);
} else {
sql =
"update YXPRJMST set ZBS_AMT = (select sum(ZBS_AMT) from YXPRJLIN where PRJ_NO="
+ pkValue
+ "),"
+ "BZ_AMT = (select sum(BZ_AMT) from YXPRJLIN where PRJ_NO="
+ pkValue
+ ")"
+ " where PRJ_NO = "
+ pkValue;
dataDom.getChildTable().getField("DLFL_AMT").setReadonly(true);
}
Database.execString(sql);
}
serviceRequest.getMessage().addInfo("保存成功");
initSel(dataDom);
dataDom.getChildTable().getWhereLimit().addColumn("PRJ_NO", pkValue);
dataDom.refresh(sessionInfo);
} catch (Exception e) {
if (db != null) {
db.rollback();
}
Log.error(e);
serviceRequest.getMessage().addInfo("保存失败，请重试或联系系统管理员！");
} finally {
if (db != null) {
db.cleanup();
}
}
}
