From 47fc68b2894ee24d6b98675f98829e648b42ace8 Mon Sep 17 00:00:00 2001
From: TangCheng <tangchengmail@163.com>
Date: 星期四, 24 四月 2025 18:25:15 +0800
Subject: [PATCH] 开发中
---
JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java | 126 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 126 insertions(+), 0 deletions(-)
diff --git a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java
index 927fa73..1261234 100644
--- a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java
+++ b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java
@@ -412,6 +412,132 @@
return tranReq.returnJsonState(true, null, null);
}
+ public ModelAndView updateOrder(SMTAIServerRequest tranReq) throws Exception {
+ String title = tranReq.convParamToString("title", true);
+ String orderId = tranReq.convParamToString("orderId", true);
+ String wstypeid = tranReq.convParamToString("wstypeid", false);
+ String wstypename = tranReq.convParamToString("wstypename", false);
+ String urgencylevel = tranReq.convParamToString("urgencylevel", false);
+ String shape = tranReq.convParamToString("shape", false);
+ String deadline = tranReq.convParamToString("deadline", false);
+ String stepstatus = tranReq.convParamToString("stepstatus", false);
+ String originatetypetext = tranReq.convParamToString("originatetypetext", false);
+ String content = tranReq.convParamToString("content", false);
+ String address = tranReq.convParamToString("address", false);
+ String stepid = tranReq.convParamToString("stepid", false);
+ String org = tranReq.convParamToString("org", false);
+ String deptname = tranReq.convParamToString("deptname", false);
+ String dealtime = tranReq.convParamToString("dealtime", false);
+ String username = tranReq.convParamToString("username", false);
+ String contactname = tranReq.convParamToString("contactname", false);
+ String contactphone = tranReq.convParamToString("contactphone", false);
+ String acceptuserid = tranReq.convParamToString("acceptuserid", false);
+ String acceptusername = tranReq.convParamToString("acceptusername", false);
+ String acceptuseraccount = tranReq.convParamToString("acceptuseraccount", false);
+ String dealuserid = tranReq.convParamToString("dealuserid", false);
+ String dealusername = tranReq.convParamToString("dealusername", false);
+ String dealuseraccount = tranReq.convParamToString("dealuseraccount", false);
+ String flowstatus = tranReq.convParamToString("flowstatus", false);
+ String attachment = tranReq.convParamToString("attachment", false);
+ String creator = tranReq.convParamToString("creator", false);
+ String isplan = tranReq.convParamToString("isplan", false);
+ String originateid = tranReq.convParamToString("originateid", false);
+ String appointstarttime = tranReq.convParamToString("appointstarttime", false);
+ String appointendtime = tranReq.convParamToString("appointendtime", false);
+ String parentid = tranReq.convParamToString("parentid", false);
+ String relateids = tranReq.convParamToString("relateids", false);
+ String oname = tranReq.convParamToString("oname", false);
+ String otype = tranReq.convParamToString("otype", false);
+ SMTDatabase db = SMTAIServerApp.getApp().allocDatabase();
+ try {
+
+ db.executeSQL(
+ "UPDATE work_order_list SET "
+ + "title = ?, "
+ + "wstypeid = ?, "
+ + "wstypename = ?, "
+ + "urgencylevel = ?, "
+ + "shape = ?, "
+ + "deadline = ?, "
+ + "stepstatus = ?, "
+ + "originatetypetext = ?, "
+ + "content = ?, "
+ + "address = ?, "
+ + "step_id = ?, "
+ + "org = ?, "
+ + "deptname = ?, "
+ + "dealtime = ?, "
+ + "username = ?, "
+ + "contactname = ?, "
+ + "contactphone = ?, "
+ + "acceptuserid = ?, "
+ + "acceptusername = ?, "
+ + "acceptuseraccount = ?, "
+ + "dealuserid = ?, "
+ + "dealusername = ?, "
+ + "dealuseraccount = ?, "
+ + "flowstatus = ?, "
+ + "attachment = ?, "
+ + "creator = ?, "
+ + "createtime = ?, "
+ + "isplan = ?, "
+ + "originateid = ?, "
+ + "appointstarttime = ?, "
+ + "appointendtime = ?, "
+ + "parentid = ?, "
+ + "relateids = ?, "
+ + "is_notify = ?, "
+ + "oname = ?, "
+ + "otype = ? "
+ + "WHERE order_id = ?",
+ new Object[]{
+ title,
+ wstypeid,
+ wstypename,
+ urgencylevel,
+ shape,
+ deadline,
+ stepstatus,
+ originatetypetext,
+ content,
+ address,
+ stepid,
+ org,
+ deptname,
+ dealtime,
+ username,
+ contactname,
+ contactphone,
+ acceptuserid,
+ acceptusername,
+ acceptuseraccount,
+ dealuserid,
+ dealusername,
+ dealuseraccount,
+ flowstatus,
+ attachment,
+ creator,
+ new Date(),
+ isplan,
+ originateid,
+ appointstarttime,
+ appointendtime,
+ parentid,
+ relateids,
+ "N",
+ oname,
+ otype,
+ orderId
+ });
+
+
+ } finally {
+ db.close();
+ }
+
+ return tranReq.returnJsonState(true, null, null);
+ }
+
public ModelAndView getOrderList(SMTAIServerRequest tranReq) throws Exception {
SMTJsonWriter jsonWr = tranReq.newReturnJsonWriter(true, null, null);
SMTDatabase db = SMTAIServerApp.getApp().allocDatabase();
--
Gitblit v1.9.3