From cdc594d12e46b7dd2e37c7a2071c133f8404f9be Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期二, 12 九月 2023 18:25:55 +0800
Subject: [PATCH] 测试代码，部分代码进行优化
---
CanadaMes-ui/src/views/home/index.vue | 62 ++--
springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java | 70 +++++
springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java | 29 +
CanadaMes-ui/src/api/home.js | 4
springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java | 6
springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java | 530 +++++++++++++++++++++-------------------
springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java | 39 +-
springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java | 12
springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java | 16
9 files changed, 444 insertions(+), 324 deletions(-)
diff --git a/CanadaMes-ui/src/api/home.js b/CanadaMes-ui/src/api/home.js
index 224c6c9..fa70d72 100644
--- a/CanadaMes-ui/src/api/home.js
+++ b/CanadaMes-ui/src/api/home.js
@@ -43,9 +43,9 @@
})
}
-export function UpdateTask(types,shelfrack) {
+export function UpdateTask(types,glassid,shelfrack) {
return request({
- url: '/home/UpdateTask?types=' + types + '&shelfrack='+shelfrack,
+ url: '/home/UpdateTask?types=' + types + '&glassid='+glassid+'&shelfrack='+shelfrack,
method: 'get',
data :""
})
diff --git a/CanadaMes-ui/src/views/home/index.vue b/CanadaMes-ui/src/views/home/index.vue
index 4fcd763..f76e51d 100644
--- a/CanadaMes-ui/src/views/home/index.vue
+++ b/CanadaMes-ui/src/views/home/index.vue
@@ -164,8 +164,11 @@
<el-table-column prop="lengthWidth" label="Length and width"></el-table-column>
<el-table-column prop="coating" label="coating"></el-table-column>
<el-table-column label="Operate">
- <el-button type="primary" style="padding: 4px 10px;font-size: 12px;" @click="endtask(0)">end
- task</el-button>
+ <template slot-scope='scope'>
+ <el-button type="primary" style="padding: 4px 10px;font-size: 12px;"
+ @click="endtask(0, scope.row.glassId, scope.row.cell)">end
+ task</el-button>
+ </template>
</el-table-column>
</el-table>
<el-table :data="this.tasklist2" border style="width: 100%">
@@ -175,8 +178,11 @@
<el-table-column prop="lengthWidth" label="Length and width"></el-table-column>
<el-table-column prop="coating" label="coating"></el-table-column>
<el-table-column label="Operate">
- <el-button type="primary" style="padding: 4px 10px;font-size: 12px;" @click="endtask(1)">end
- task</el-button>
+ <template slot-scope='scope'>
+ <el-button type="primary" style="padding: 4px 10px;font-size: 12px;"
+ @click="endtask(1, scope.row.glassId, scope.row.cell)">end
+ task</el-button>
+ </template>
</el-table-column>
</el-table>
</div>
@@ -262,7 +268,7 @@
<el-table-column prop="endTime" label="endTime"></el-table-column>
</el-table>
</el-dialog>
- <el-dialog :visible.sync="dialogFormVisible3" title="Ordering Information">
+ <el-dialog :visible.sync="dialogFormVisible3" title="Cage Details">
<el-table :data="this.cageinfo" border style="width: 100%;height: 700px;overflow: auto;">
<el-table-column :width="150" prop="cage" label="the grille number"></el-table-column>
<el-table-column prop="cell" label="cell"></el-table-column>
@@ -276,7 +282,7 @@
<el-button type="primary" style="padding: 4px 10px;font-size: 12px;"
@click="deleteglass(scope.row.glassId, scope.row.state)">delete</el-button>
<el-button type="primary" style="padding: 4px 10px;font-size: 12px;"
- @click="outglass(scope.row.glassId,scope.row.state)">out</el-button>
+ @click="outglass(scope.row.glassId, scope.row.state)">out</el-button>
</template>
</el-table-column>
</el-table>
@@ -324,8 +330,6 @@
url: "../../img/bigcar01.png",
car1: 150,
car2: 242,
- incell: "",
- outcell: "",
cageinfo: [],
cage: 0
};
@@ -362,7 +366,6 @@
this.car1 = 150 + 24.6 * obj.params[0][0];
this.car2 = 242 + 24.6 * obj.params[0][1];
}
-
this.tableData = obj.tableData[0];
this.cagelist1 = obj.cagelist1[0];
this.cagelist2 = obj.cagelist2[0];
@@ -370,12 +373,6 @@
this.cagelist4 = obj.cagelist4[0];
this.tasklist1 = obj.tasklist1[0];
this.tasklist2 = obj.tasklist2[0];
- if (this.tasklist1.length > 0) {
- this.incell = this.tasklist1[0]['cell'];
- }
- if (this.tasklist1.length > 0) {
- this.outcell = this.tasklist2[0]['cell'];
- }
this.alarm = obj.alarmmg[0];
SelectCageInfo(this.cage).then(res => {
@@ -461,8 +458,14 @@
if (res.data.message2 == 200) {
this.$message.success("Operation successful");
this.cancal();
- } else {
+ } else if(res.data.message2 == 500) {
this.$message.success("There are currently tasks");
+ }
+ else if(res.data.message2 == 300) {
+ this.$message.success("There is no such grid");
+ }
+ else if(res.data.message2 == 400) {
+ this.$message.success("There is no such grid");
}
});
}
@@ -499,21 +502,12 @@
this.dialogFormVisible1 = false;
this.form1 = {};
},
- endtask(type) {
- if (type == 0) {
- UpdateTask(type, this.incell).then(res => {
- if (res.data.message3 == 200) {
- this.$message.success("Operation successful");
- }
- });
- } else {
- UpdateTask(type, this.outcell).then(res => {
- if (res.data.message3 == 200) {
- this.$message.success("Operation successful");
- }
- });
- }
-
+ endtask(type, glassid, cell) {
+ UpdateTask(type, glassid, cell).then(res => {
+ if (res.data.message3 == 200) {
+ this.$message.success("Operation successful");
+ }
+ });
},
showcageinfo(cage) {
this.cage = cage;
@@ -524,7 +518,7 @@
},
deleteglass(glassid, state) {
if (state == 1) {
- DeleteByGlassID(glassid).then(res=>{
+ DeleteByGlassID(glassid).then(res => {
if (res.data.message3 == 200) {
this.$message.success("Operation successful");
}
@@ -533,9 +527,9 @@
this.$message.success("No out allowed");
}
},
- outglass(glassid,state){
+ outglass(glassid, state) {
if (state == 1) {
- OutByGlassID(glassid).then(res=>{
+ OutByGlassID(glassid).then(res => {
if (res.data.message3 == 200) {
this.$message.success("Operation successful");
}
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java b/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java
index 68fc478..65b6d28 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java
@@ -1,15 +1,24 @@
package com.example.springboot.component;
+import java.sql.SQLException;
import java.util.List;
-import com.example.springboot.service.SpianService;
-import com.example.springboot.mapper.AlarmMapper;
+import org.springframework.beans.factory.annotation.Autowired;
+
+import com.example.springboot.service.JdbcConnections;
+import com.example.springboot.service.SpianService;
+import com.example.springboot.entity.Glass;
+import com.example.springboot.mapper.AlarmMapper;
public class PlcHold extends Thread {
private AlarmMapper alarmMapper;
+ @Autowired
+ private JdbcConnections jdbcConnections;
+
private SpianService spianService;
+
@Override
public void run() {
@@ -19,12 +28,20 @@
Thread.sleep(500);
} catch (InterruptedException e) {
- // TODO Auto-generated catch block
+ //\\ TODO Auto-generated catch block
e.printStackTrace();
}
spianService = WebSocketServer.applicationContext.getBean(SpianService.class);
- //spianService.selectout("112");
-
+
+ jdbcConnections = WebSocketServer.applicationContext.getBean(JdbcConnections.class);
+ try {
+ Glass glass=jdbcConnections.selectGlass(112);
+ //System.out.println(glass.getOrderId());
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+
//鍒ゆ柇杩涚墖璇锋眰
List<Short> datas1List=S7control.getinstance().ReadWord("DB106.24", 1);
List<Short> datas1ListState=S7control.getinstance().ReadWord("DB106.8", 1);
@@ -41,6 +58,7 @@
List<Short> datas1ListID=S7control.getinstance().ReadWord("DB106.26", 13);
//鑾峰彇鐜荤拑id
for(Short list1:datas1ListID){
+
spianService.selectAll((short)list1);
}
}
@@ -60,4 +78,5 @@
}
}
+
}
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java b/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
index 258556f..953fd91 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
@@ -5,7 +5,6 @@
import java.util.ArrayList;
import java.util.List;
-
import com.example.springboot.entity.StorageCage;
import com.example.springboot.entity.alarmmg;
import com.example.springboot.mapper.HomeMapper;
@@ -18,19 +17,18 @@
public void run() {
while (this != null) {
try {
- Thread.sleep(5000);
+ Thread.sleep(10000);
} catch (InterruptedException e) {
e.printStackTrace();
}
-
JSONObject jsonObject = new JSONObject();
-
- //娉ㄥ叆mapper
+
+ // 娉ㄥ叆mapper
homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class);
// 绗煎瓙浣跨敤鎯呭喌
List<StorageCage> tableData = homeMapper.selectAll();
jsonObject.append("tableData", tableData);
- //鏍肩悊鐗囩鏍煎瓙鐘舵��
+ // 鏍肩悊鐗囩鏍煎瓙鐘舵��
List<StorageCage> cagelist1 = homeMapper.selectRack1();
List<StorageCage> cagelist2 = homeMapper.selectRack2();
List<StorageCage> cagelist3 = homeMapper.selectRack3();
@@ -39,23 +37,30 @@
jsonObject.append("cagelist2", cagelist2);
jsonObject.append("cagelist3", cagelist3);
jsonObject.append("cagelist4", cagelist4);
- //杩涘嚭鐗囦换鍔�
- List<StorageCage> tasklist1=homeMapper.selectinout(2);
- List<StorageCage> tasklist2=homeMapper.selectinout(3);
+ // 杩涘嚭鐗囦换鍔�
+ List<StorageCage> tasklist1 = homeMapper.selectinout(2);
+ List<StorageCage> tasklist2 = homeMapper.selectinout(3);
jsonObject.append("tasklist1", tasklist1);
jsonObject.append("tasklist2", tasklist2);
- //鏌ヨ鎶ヨ淇℃伅
- List<alarmmg> alarmmg=homeMapper.SelectAlarmmgInfo();
+ // 鏌ヨ鎶ヨ淇℃伅
+ List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo();
jsonObject.append("alarmmg", alarmmg);
- //璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒
+ // 璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒
List<String> addressList = new ArrayList<String>();
- addressList.add("DB105.DBW0");
- addressList.add("DB105.DBW12");
+ addressList.add("DB106.0");
+ addressList.add("DB106.12");
List<Short> paramlist = S7control.getinstance().ReadWord(addressList);
- //灏嗛泦鍚堣浆涓烘暟缁�
+
+ // List<Short> paramlists = new ArrayList<Short>();
+ // short para1 = 1;
+ // short para2 = 2;
+ // paramlists.add(para1);
+ // paramlists.add(para2);
+ // System.out.println(paramlists);
+
if(paramlist!=null){
- Short[] paramlists = paramlist.toArray(new Short[0]);
- jsonObject.append("params", paramlists);
+ // Short[] paramlists = paramlist.toArray(new Short[0]);
+ jsonObject.append("params", paramlist);
}
// jsonObject.append("params", new short[] { 30, 40, });
WebSocketServer sendwServer = WebSocketServer.sessionMap.get("Home");
diff --git a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java
index 5970b54..01b46fd 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java
@@ -78,21 +78,27 @@
if (taskno > 0) {
map.put("message2", "500");
} else {
- map.put("message2", "200");
// 璋冪敤浼嶄笂鐗囧嚱鏁�
- spianService.selectAll(glassid);
+ short results= spianService.selectAll(glassid);
+ if(results==200){
+ map.put("message2", "200");
+ }else if(results==300){
+ map.put("message2", "300");
+ }else if(results==400){
+ map.put("message2", "400");
+ }
}
return Result.success(map);
}
@GetMapping("/UpdateTask")
- public Result UpdateTask(Integer types, Integer shelfrack) {
+ public Result UpdateTask(Integer types, Integer shelfrack, Integer glassid) {
Map<String, Object> map = new HashMap<>();
homeMapper.UpdateTask(types, shelfrack);
if (types == 0) {
- homeMapper.UpdateCageTask1(shelfrack);
+ homeMapper.UpdateCageTask1(shelfrack,glassid);
} else {
- homeMapper.UpdateCageTask2(shelfrack);
+ homeMapper.UpdateCageTask2(shelfrack,glassid);
}
map.put("message3", "200");
return Result.success(map);
diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
index 384b18c..3e22d2c 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
@@ -34,11 +34,11 @@
List<StorageCage> selectinout(@Param("task_type") Integer task_type);
// 鏌ヨ鏄惁瀛樺湪姝よ鍗�
- @Select("select count(*) from storage_cage where order_id=#{orderid} and state=0")
+ @Select("select count(*) from storage_cage where order_id=#{orderid} and state=1")
short SelectOrder(@Param("orderid") String orderid);
// @Insert("insert into order_out(orderid) values('#{orderid}')")
- @Insert("INSERT INTO `canadames`.`order_out`( `orderid`,`mod_time`) VALUES ( #{orderid},now())")
+ @Insert("INSERT INTO `canadames`.`order_out`( `order_id`,`state`) VALUES ( #{orderid},0)")
void InsertOrder(String orderid);
// 鍋滄鎸夊綋鍓嶈鍗曞嚭鐗�
@@ -54,12 +54,12 @@
void UpdateTask(@Param("task_type") Integer task_type, @Param("shelf_rack") Integer shelf_rack);
// 鎵嬪姩瀹屾垚杩涚墖浠诲姟淇敼绗煎瓙鏁版嵁
- @Update("update storage_cage set state=1 where cell=#{cell} and state=2")
- void UpdateCageTask1(@Param("cell") Integer cell);
+ @Update("update storage_cage set state=1 where cell=#{cell} and glass_id=#{glassid} and state=2")
+ void UpdateCageTask1(@Param("cell") Integer cell,@Param("glassid") Integer glassid);
// 鎵嬪姩瀹屾垚鍑虹墖浠诲姟淇敼绗煎瓙鏁版嵁
- @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null,coating=null where cell=#{cell} and state=2")
- void UpdateCageTask2(@Param("cell") Integer cell);
+ @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null,coating=null where cell=#{cell} and glass_id=#{glassid} and state=3")
+ void UpdateCageTask2(@Param("cell") Integer cell,@Param("glassid") Integer glassid);
//鑾峰彇鎶ヨ淇℃伅
@Select("select id,content,timeon as timeons,endTime from alarmmg where endTime is null")
diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java
index 76b6d90..95daba0 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java
@@ -18,8 +18,8 @@
//@Select("(select*from storage_cage as a where a.state=0 and cage%2=0 ORDER BY id LIMIT 1)union (select a.* from storage_cage a inner join (select cage,if(shu2=1,shu3,shu5) as gezi from ( select cage, count(case when state1=1 and state2=0 then cell else null end)as shu1, count(case when state1=0 then cell else null end) as shu2, min(case when state1=1 and state2=0 then cell else null end) as shu3, min(case when state1=0 then cell else null end) as shu4, min(case when state1=0 or state2=0 then cell else null end) as shu5 from (select *,max(state) as state1,min(state) as state2 from storage_cage group by cage,cell) as a where cage%2!=0 GROUP BY cage HAVING shu2>1 or (shu2=1 and shu1>0) ) as sss limit 1)as b on a.cage=b.cage and a.cell=b.gezi and a.state=0 order by tier limit 1) ORDER BY id LIMIT 1;")
//鑾峰彇璁㈠崟鍙锋帓搴忕殑绌鸿鍗曠瀛�
- @Select("select cage,COUNT(if(order_id=#{glassid},order_id,null))as orderid from storage_cage where (order_id=#{glassid} or ''='') GROUP BY cage ORDER BY orderid desc; ")
- List<StorageCage> selectAll(Short glassid);
+ @Select("select cage,COUNT(if(order_id=#{orderids},order_id,null))as orderid from storage_cage where (order_id=#{orderids} or ''='') GROUP BY cage ORDER BY orderid desc; ")
+ List<StorageCage> selectAll(Short orderids);
//鍒ゆ柇璇ョ瀛愭槸鍚︽湁鍚堥�傚搴︾┖鏍�
@Select("select cage,cell,tier,id,ROUND(id/2)as prcId from storage_cage where cage=#{cage1} and state=0 and width>=#{width} ORDER BY cell,tier LIMIT 1")
@@ -42,7 +42,7 @@
@Select("select cage,cell,tier,glasswidth,ROUND(id/2)as prcId,id from storage_cage as a where a.order_id=#{orderId} and state=1 order by cage desc,tier desc,cell desc LIMIT 1")
StorageCage selectOut(String orderId);
//鎸夌幓鐠僆D鍑虹墖浠诲姟鏌ヨ
- @Select("select cage,cell,tier,glasswidth,ROUND(id/2)as prcId,id from storage_cage as a where a.order_id=#{orderId} and state=1 order by cage desc,tier desc,cell desc LIMIT 1")
+ @Select("select cage,cell,tier,glasswidth,ROUND(id/2)as prcId,id from storage_cage as a where a.glass_id=#{glassid} and state=1 order by cage desc,tier desc,cell desc LIMIT 1")
StorageCage selectOut2(String glassid);
//鍒ゆ柇鍑虹墖涓�1鏃讹紝鏄惁鍙洿鎺ュ嚭鐗�
diff --git a/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java b/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java
new file mode 100644
index 0000000..0ca1741
--- /dev/null
+++ b/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java
@@ -0,0 +1,70 @@
+package com.example.springboot.service;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+
+import org.springframework.stereotype.Component;
+
+import com.example.springboot.entity.Glass;
+@Component
+public class JdbcConnections {
+ /**
+ * 鏁版嵁搴撹繛鎺ュ弬鏁�
+ * driver,url,username,password
+ */
+ private static final String DRIVER = "com.mysql.jdbc.Driver";
+ private static final String URL = "jdbc:mysql://localhost:3306/canadames";
+ private static final String USERNAME = "root";
+ private static final String PASSWORD = "beibo.123/";
+
+ private static Connection conn = null;
+ private static PreparedStatement ps = null;
+ private static ResultSet rs = null;
+
+ public Glass selectGlass(int glassid) throws SQLException {
+ conn = getConn();
+ Glass glass=new Glass();
+ String sql = "select orderid from glass where glassid=?";
+ ps = conn.prepareStatement(sql);
+ ps.setInt(1, glassid);
+ rs= ps.executeQuery();
+ while (rs.next()) {
+ glass.setOrderId(rs.getShort("orderid"));
+ }
+
+ return glass;
+ }
+ /**
+ * 1. 鍔犺浇椹卞姩
+ * 2. 鑾峰彇杩炴帴 conn
+ * 3. 鍒涘缓璇彞 ps
+ * 4. 鎵ц璇彞 rs
+ * 5. 澶勭悊缁撴灉
+ * 6. 鍥炴敹璧勬簮
+ *
+ * 瀹炵幇CRUD
+ * 鏇存柊锛�
+ * 1澧炲姞
+ * 2鍒犻櫎
+ * 3淇敼
+ * 鏌ヨ锛�
+ * 1. 鏌ヤ竴涓紝涓�涓璞�
+ * 2. 鏌ヤ竴缁勶紝鍋氭垚涓�涓璞″垪琛紝鏌ュ叏閮�
+ */
+ public static Connection getConn() throws SQLException {
+ Connection conn = null;
+ conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/canadames?serverTimezone=GMT%2B8&characterEncoding=utf-8", "root", "beibo.123/");
+ return conn;
+ }
+
+ static {
+ try {
+ Class.forName(DRIVER);
+ } catch (ClassNotFoundException e) {
+ e.printStackTrace();
+ }
+ }
+}
diff --git a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
index 951216b..2d8f2f3 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
@@ -5,7 +5,6 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
-import org.springframework.web.bind.annotation.GetMapping;
import com.example.springboot.common.Result;
import com.example.springboot.component.S7control;
@@ -17,114 +16,120 @@
public class SpianService {
@Autowired
private SpianMapper spianMapper;
- @GetMapping("/all2")
- public Result selectout(String orderid){
- //瀹氫箟PRC鏁版嵁浼犻�佹暟缁�
- List<String> adddresslist=new ArrayList<>();
- adddresslist.add("DB105.6");//鍑虹墖杞﹁捣濮嬩綅缃�
- adddresslist.add("DB105.8");//鍑虹墖杞︾洰鏍囦綅缃�
- adddresslist.add("DB105.10");//鍑虹墖绗肩幓鐠冩暟
- adddresslist.add("DB105.14");//鍑虹墖杞﹀惎鍔� 1涓哄惎鍔�
- List<Short> datas=new ArrayList<>();
- //鑾峰彇浼樺厛鍑虹墖鐨勪綅缃�
- StorageCage cageout=spianMapper.selectOut(orderid);
- int cage =cageout.getCage(); //鍌ㄥ瓨鍑虹墖浣嶇疆锛岀瀛愭牸瀛愬嚑鍙风幓鐠�
- int cell =cageout.getCell();//鍑虹墖鏍煎彿
- int tier =cageout.getTier();//鍑虹墖鍐呭鐗�
- int prcid=cageout.getPrcId();//prcid
- int prcid2;
- int ids;
- double glasswidth=cageout.getGlassWidth();
- //鍒ゆ柇鐜荤拑鍐呭鐗�
- if(tier==2){
- //鍒ゆ柇鐜荤拑鍙洿鎺ュ嚭鐗囨椂
- //淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
- spianMapper.UpdataGlassCage("","",glasswidth, cage, cell, tier, 0);
-
- datas.add((short)prcid);
- datas.add((short)1000);
- datas.add((short)1);
- datas.add((short)1);
- S7control.getinstance().WriteWord(adddresslist, datas);
- return Result.success(datas);
- }
- else{
- //鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲�
- int state= spianMapper.selectGlassState(cage,cell);
- //鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷�
- if(state==0){
- return Result.success("鐘舵�佷负0,鐩存帴鍑虹墖");
- }else{
- //鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙
- if(cage<6){
- StorageCage cagecell= spianMapper.selectGlassCage(cage,glasswidth,0,6);
- if(cagecell==null){
- return Result.success(cagecell);
- }
- //鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
- prcid2=cagecell.getPrcId();//璋冩嫧鐩爣浣峆RCID
- ids=cagecell.getId();//璋冩嫧鐩爣浣岻D
- //鏇存崲鐜荤拑鐨勭瀛�
- spianMapper.UpdateDBCage(ids, cage, cell);//灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
- spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);//娓呴櫎鍘熸牸瀛愭暟鎹�
- //濉叆璋冩嫧鏁版嵁
- datas.add((short)prcid);//璋冩嫧澶栫墖璧峰浣嶇疆
- datas.add((short)prcid2);
- datas.add((short)2);
- datas.add((short)1);
- //浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
- S7control.getinstance().WriteWord(adddresslist, datas);
- datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
- //鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�,濉叆鍑虹墖鏁版嵁
- datas.add((short)prcid);
- datas.add((short)1000);
- datas.add((short)1);
- datas.add((short)1);
- S7control.getinstance().WriteWord(adddresslist, datas);
- //淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
-
- return Result.success(cagecell); //璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
-
- }else{//绗煎瓙鍙峰ぇ浜�5鏃�
- StorageCage cagecell= spianMapper.selectGlassCage(cage,glasswidth,5,11);
- if(cagecell==null){
- return Result.success(cagecell);
- }
- //鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
- prcid2=cagecell.getPrcId();//璋冩嫧鐩爣浣峱rcID
- ids=cagecell.getId();//璋冩嫧鐩爣浣岻D
- //濉叆璋冩嫧鏁版嵁
- datas.add((short)prcid);
- datas.add((short)prcid2);
- datas.add((short)2);
- datas.add((short)1);
- //杞Щ鍘熻皟鎷ㄦ牸瀛愭暟鎹�
- spianMapper.UpdateDBCage(ids, cage, cell);//灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
- spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);//娓呴櫎鍘熸牸瀛愭暟鎹�
- //浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
- S7control.getinstance().WriteWord(adddresslist, datas);
- datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
- //鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�
- //濉叆鍑虹墖鏁版嵁
- datas.add((short)prcid);
- datas.add((short)1000);
- datas.add((short)1);
- datas.add((short)1);
- S7control.getinstance().WriteWord(adddresslist, datas);
- return Result.success(cagecell); //璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
-
- }
-
- }
- }
-
-}
- @GetMapping("/all")
- //杩涚墖浠诲姟,浼犺鍗昳d
- //鎸夎鍗曚紭鍏堣繘鐗�
- public Result selectAll(Short glassid){
- //return spianMapper.selectAll();
+ // @GetMapping("/all2")
+ public Result selectout(String orderid) {
+ // 瀹氫箟PRC鏁版嵁浼犻�佹暟缁�
+ List<String> adddresslist = new ArrayList<>();
+ adddresslist.add("DB105.6");// 鍑虹墖杞﹁捣濮嬩綅缃�
+ adddresslist.add("DB105.8");// 鍑虹墖杞︾洰鏍囦綅缃�
+ adddresslist.add("DB105.10");// 鍑虹墖绗肩幓鐠冩暟
+ adddresslist.add("DB105.14");// 鍑虹墖杞﹀惎鍔� 1涓哄惎鍔�
+ List<Short> datas = new ArrayList<>();
+ // 鑾峰彇浼樺厛鍑虹墖鐨勪綅缃�
+ StorageCage cageout = spianMapper.selectOut(orderid);
+ int cage = cageout.getCage(); // 鍌ㄥ瓨鍑虹墖浣嶇疆锛岀瀛愭牸瀛愬嚑鍙风幓鐠�
+ int cell = cageout.getCell();// 鍑虹墖鏍煎彿
+ int tier = cageout.getTier();// 鍑虹墖鍐呭鐗�
+ int prcid = cageout.getPrcId();// prcid
+ int prcid2;
+ int ids;
+ double glasswidth = cageout.getGlassWidth();
+ // 鍒ゆ柇鐜荤拑鍐呭鐗�
+ if (tier == 2) {
+ // 鍒ゆ柇鐜荤拑鍙洿鎺ュ嚭鐗囨椂
+ // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+ spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);
+
+ datas.add((short) prcid);
+ datas.add((short) 1000);
+ datas.add((short) 1);
+ datas.add((short) 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ return Result.success(datas);
+ } else {
+ // 鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲�
+ int state = spianMapper.selectGlassState(cage, cell);
+ // 鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷�
+ if (state == 0) {
+ spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);
+ datas.add((short) prcid);
+ datas.add((short) 1000);
+ datas.add((short) 1);
+ datas.add((short) 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ return Result.success("鐘舵�佷负0,鐩存帴鍑虹墖");
+ } else {
+ // 鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙
+ if (cage < 6) {
+ StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6);
+ if (cagecell == null) {
+ return Result.success(cagecell);
+ }
+ // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+ prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峆RCID
+ ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+ // 鏇存崲鐜荤拑鐨勭瀛�
+ spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+ spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+ // 濉叆璋冩嫧鏁版嵁
+ datas.add((short) prcid);// 璋冩嫧澶栫墖璧峰浣嶇疆
+ datas.add((short) prcid2);
+ datas.add((short) 2);
+ datas.add((short) 1);
+ // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+ // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�,濉叆鍑虹墖鏁版嵁
+ datas.add((short) prcid);
+ datas.add((short) 1000);
+ datas.add((short) 1);
+ datas.add((short) 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+
+ return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
+ } else {// 绗煎瓙鍙峰ぇ浜�5鏃�
+ StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11);
+ if (cagecell == null) {
+ return Result.success(cagecell);
+ }
+ // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+ prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峱rcID
+ ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+ // 濉叆璋冩嫧鏁版嵁
+ datas.add((short) prcid);
+ datas.add((short) prcid2);
+ datas.add((short) 2);
+ datas.add((short) 1);
+ // 杞Щ鍘熻皟鎷ㄦ牸瀛愭暟鎹�
+ spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+ spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+ // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+ // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�
+ // 濉叆鍑虹墖鏁版嵁
+ datas.add((short) prcid);
+ datas.add((short) 1000);
+ datas.add((short) 1);
+ datas.add((short) 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
+ }
+
+ }
+ }
+
+ }
+
+ // @GetMapping("/all")
+ // 杩涚墖浠诲姟,浼犺鍗昳d
+ // 鎸夎鍗曚紭鍏堣繘鐗�
+ public Short selectAll(Short glassid) {
+
int cage1;
int cells;
int ids;
@@ -132,156 +137,177 @@
int tiers;
int prctier;
- Glass glasslist=spianMapper.selectGlass(glassid);
- double widths=glasslist.getWidth();
- Short orderids=glasslist.getOrderId();
+ Glass glasslist = spianMapper.selectGlass(glassid);
+ if (glasslist == null) {
+ return (300);
+ }
+ double widths = glasslist.getWidth();
+ Short orderids = glasslist.getOrderId();
- List<String> adddresslist=new ArrayList<>();
- adddresslist.add("DB105.0");//杩涚墖杞﹁捣濮嬩綅缃�
- adddresslist.add("DB105.2");//杩涚墖杞︾洰鏍囦綅缃�
- adddresslist.add("DB105.4");//杩涚墖绗肩幓鐠冩暟
- adddresslist.add("DB105.12");//杩涚墖杞﹀惎鍔� 1涓哄惎鍔�
- List<Short> datas=new ArrayList<>();
+ List<String> adddresslist = new ArrayList<>();
+ adddresslist.add("DB105.0");// 杩涚墖杞﹁捣濮嬩綅缃�
+ adddresslist.add("DB105.2");// 杩涚墖杞︾洰鏍囦綅缃�
+ adddresslist.add("DB105.4");// 杩涚墖绗肩幓鐠冩暟
+ adddresslist.add("DB105.12");// 杩涚墖杞﹀惎鍔� 1涓哄惎鍔�
+ List<Short> datas = new ArrayList<>();
- //String orderid="A001";
- //鑾峰彇璁㈠崟鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭
- List<StorageCage> storageCage=spianMapper.selectAll(glassid);
- if(storageCage==null){
- return Result.success(storageCage);
- }
+ // String orderid="A001";
+ // 鑾峰彇璁㈠崟鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭
+ List<StorageCage> storageCage = spianMapper.selectAll(orderids);
+ if (storageCage == null) {
+ return (400);
+ }
for (StorageCage storageCage2 : storageCage) {
- //淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙�
- cage1=storageCage2.getCage();
- //鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁�
- int cages=spianMapper.selectCage(cage1);
- //鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍�
- StorageCage cages1=spianMapper.selectCage1(cage1,widths);
- ids=cages1.getId();//鏁版嵁搴揑D
- tiers=cages1.getTier();//鍐呭鐗�
- cells=cages1.getCell();//鏍煎瓙鍙�
- prcid=cages1.getPrcId();//浼犵粰prc鐨勭洰鏍囧湴id
- prctier=spianMapper.selectsum(cage1, cells);//浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁�
- //鏈夊悎閫傜┖鏍兼椂杩涚墖
- if(cages>1 &&cages1.getTier()!=null){
- //鎵ц杩涚墖
- datas.add((short)1000);
- datas.add((short)prcid);
- datas.add((short)prctier);
- datas.add((short)1);
- S7control.getinstance().WriteWord(adddresslist, datas);
- //鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉＄幓鐠�
-
- spianMapper.UpdataAddCage(orderids, glassid, widths, cage1, cells, ids, 1);
- return Result.success(cages1);
+ // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙�
+ cage1 = storageCage2.getCage();
+ // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁�
+ int cages = spianMapper.selectCage(cage1);
+ // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍�
+ StorageCage cages1 = spianMapper.selectCage1(cage1, widths);
+ if (cages1 != null) {
+ ids = cages1.getId();// 鏁版嵁搴揑D
+ tiers = cages1.getTier();// 鍐呭鐗�
+ cells = cages1.getCell();// 鏍煎瓙鍙�
+ prcid = cages1.getPrcId();// 浼犵粰prc鐨勭洰鏍囧湴id
+ prctier = spianMapper.selectsum(cage1, cells);// 浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁�
+ // 鏈夊悎閫傜┖鏍兼椂杩涚墖
+ if (cages > 1 && cages1.getTier() != null) {
+ // 鎵ц杩涚墖
+ datas.add((short) 1000);
+ datas.add((short) prcid);
+ datas.add((short) prctier);
+ datas.add((short) 1);
+ // 鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉＄幓鐠�
+ spianMapper.UpdataAddCage(orderids, glassid, widths, cage1, cells, ids, 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+
+ return (200);
+ }
}
-
-
- }
- return Result.success("涓嶅彲杩涚墖");
-
+
+ }
+ return (300);
+
}
- @GetMapping("/all2")
- public Result selectout2(String glassid){
- //瀹氫箟PRC鏁版嵁浼犻�佹暟缁�
- List<String> adddresslist=new ArrayList<>();
- adddresslist.add("DB105.6");//鍑虹墖杞﹁捣濮嬩綅缃�
- adddresslist.add("DB105.8");//鍑虹墖杞︾洰鏍囦綅缃�
- adddresslist.add("DB105.10");//鍑虹墖绗肩幓鐠冩暟
- adddresslist.add("DB105.14");//鍑虹墖杞﹀惎鍔� 1涓哄惎鍔�
- List<Short> datas=new ArrayList<>();
- //鑾峰彇浼樺厛鍑虹墖鐨勪綅缃�
- StorageCage cageout=spianMapper.selectOut2(glassid);
- int cage =cageout.getCage(); //鍌ㄥ瓨鍑虹墖浣嶇疆锛岀瀛愭牸瀛愬嚑鍙风幓鐠�
- int cell =cageout.getCell();//鍑虹墖鏍煎彿
- int tier =cageout.getTier();//鍑虹墖鍐呭鐗�
- int prcid=cageout.getPrcId();//prcid
- int prcid2;
- int ids;
- double glasswidth=cageout.getGlassWidth();
- //鍒ゆ柇鐜荤拑鍐呭鐗�
- if(tier==2){
- //鍒ゆ柇鐜荤拑鍙洿鎺ュ嚭鐗囨椂
- //淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
- spianMapper.UpdataGlassCage("","",glasswidth, cage, cell, tier, 0);
-
- datas.add((short)prcid);
- datas.add((short)1000);
- datas.add((short)1);
- datas.add((short)1);
- S7control.getinstance().WriteWord(adddresslist, datas);
- return Result.success(datas);
- }
- else{
- //鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲�
- int state= spianMapper.selectGlassState(cage,cell);
- //鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷�
- if(state==0){
- return Result.success("鐘舵�佷负0,鐩存帴鍑虹墖");
- }else{
- //鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙
- if(cage<6){
- StorageCage cagecell= spianMapper.selectGlassCage(cage,glasswidth,0,6);
- if(cagecell==null){
- return Result.success(cagecell);
+ // @GetMapping("/all2")
+ public Result selectout2(String glassid) {
+ // 瀹氫箟PRC鏁版嵁浼犻�佹暟缁�
+ List<String> adddresslist = new ArrayList<>();
+ adddresslist.add("DB105.6");// 鍑虹墖杞﹁捣濮嬩綅缃�
+ adddresslist.add("DB105.8");// 鍑虹墖杞︾洰鏍囦綅缃�
+ adddresslist.add("DB105.10");// 鍑虹墖绗肩幓鐠冩暟
+ adddresslist.add("DB105.14");// 鍑虹墖杞﹀惎鍔� 1涓哄惎鍔�
+ List<Short> datas = new ArrayList<>();
+ // 鑾峰彇浼樺厛鍑虹墖鐨勪綅缃�
+ StorageCage cageout = spianMapper.selectOut2(glassid);
+ int cage = cageout.getCage(); // 鍌ㄥ瓨鍑虹墖浣嶇疆锛岀瀛愭牸瀛愬嚑鍙风幓鐠�
+ int cell = cageout.getCell();// 鍑虹墖鏍煎彿
+ int tier = cageout.getTier();// 鍑虹墖鍐呭鐗�
+ int prcid = cageout.getPrcId();// prcid
+ int prcid2;
+ int ids;
+ double glasswidth = cageout.getGlassWidth();
+ // 鍒ゆ柇鐜荤拑鍐呭鐗�
+ if (tier == 2) {
+ // 鍒ゆ柇鐜荤拑鍙洿鎺ュ嚭鐗囨椂
+ // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+ spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);
+
+ datas.add((short) prcid);
+ datas.add((short) 1000);
+ datas.add((short) 1);
+ datas.add((short) 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ return Result.success(datas);
+ } else {
+ // 鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲�
+ int state = spianMapper.selectGlassState(cage, cell);
+ // 鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷�
+ if (state == 0) {
+ return Result.success("鐘舵�佷负0,鐩存帴鍑虹墖");
+ } else {
+ // 鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙
+ if (cage < 6) {
+ StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6);
+ if (cagecell == null) {
+ return Result.success(cagecell);
+ }
+ // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+ prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峆RCID
+ ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+ // 鏇存崲鐜荤拑鐨勭瀛�
+ spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+ spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+ // 濉叆璋冩嫧鏁版嵁
+ datas.add((short) prcid);// 璋冩嫧澶栫墖璧峰浣嶇疆
+ datas.add((short) prcid2);
+ datas.add((short) 2);
+ datas.add((short) 1);
+ // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+ // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�,濉叆鍑虹墖鏁版嵁
+ datas.add((short) prcid);
+ datas.add((short) 1000);
+ datas.add((short) 1);
+ datas.add((short) 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+
+ return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
+ } else {// 绗煎瓙鍙峰ぇ浜�5鏃�
+ StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11);
+ if (cagecell == null) {
+ return Result.success(cagecell);
+ }
+ // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+ prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峱rcID
+ ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+ // 濉叆璋冩嫧鏁版嵁
+ datas.add((short) prcid);
+ datas.add((short) prcid2);
+ datas.add((short) 2);
+ datas.add((short) 1);
+ // 杞Щ鍘熻皟鎷ㄦ牸瀛愭暟鎹�
+ spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+ spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+ // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+ // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�
+ // 濉叆鍑虹墖鏁版嵁
+ datas.add((short) prcid);
+ datas.add((short) 1000);
+ datas.add((short) 1);
+ datas.add((short) 1);
+ S7control.getinstance().WriteWord(adddresslist, datas);
+ return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
}
- //鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
- prcid2=cagecell.getPrcId();//璋冩嫧鐩爣浣峆RCID
- ids=cagecell.getId();//璋冩嫧鐩爣浣岻D
- //鏇存崲鐜荤拑鐨勭瀛�
- spianMapper.UpdateDBCage(ids, cage, cell);//灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
- spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);//娓呴櫎鍘熸牸瀛愭暟鎹�
- //濉叆璋冩嫧鏁版嵁
- datas.add((short)prcid);//璋冩嫧澶栫墖璧峰浣嶇疆
- datas.add((short)prcid2);
- datas.add((short)2);
- datas.add((short)1);
- //浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
- S7control.getinstance().WriteWord(adddresslist, datas);
- datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
- //鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�,濉叆鍑虹墖鏁版嵁
- datas.add((short)prcid);
- datas.add((short)1000);
- datas.add((short)1);
- datas.add((short)1);
- S7control.getinstance().WriteWord(adddresslist, datas);
- //淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
-
- return Result.success(cagecell); //璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
-
- }else{//绗煎瓙鍙峰ぇ浜�5鏃�
- StorageCage cagecell= spianMapper.selectGlassCage(cage,glasswidth,5,11);
- if(cagecell==null){
- return Result.success(cagecell);
- }
- //鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
- prcid2=cagecell.getPrcId();//璋冩嫧鐩爣浣峱rcID
- ids=cagecell.getId();//璋冩嫧鐩爣浣岻D
- //濉叆璋冩嫧鏁版嵁
- datas.add((short)prcid);
- datas.add((short)prcid2);
- datas.add((short)2);
- datas.add((short)1);
- //杞Щ鍘熻皟鎷ㄦ牸瀛愭暟鎹�
- spianMapper.UpdateDBCage(ids, cage, cell);//灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
- spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);//娓呴櫎鍘熸牸瀛愭暟鎹�
- //浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
- S7control.getinstance().WriteWord(adddresslist, datas);
- datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
- //鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�
- //濉叆鍑虹墖鏁版嵁
- datas.add((short)prcid);
- datas.add((short)1000);
- datas.add((short)1);
- datas.add((short)1);
- S7control.getinstance().WriteWord(adddresslist, datas);
- return Result.success(cagecell); //璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
-
- }
-
- }
+
+ }
}
-
-}
-
+
+ }
+
+ /*** 淇敼鐢ㄦ埛* @throws SQLException */
+ // public static int updateUser(Glass user) throws SQLException {conn =
+ // getConn();
+ // String sql = "update t_user set name=?,gender=?,age=?,score=?"+ " where
+ // id=?";ps = conn.prepareStatement(sql);
+ // ps.setString(1, user.getName());ps.setString(2, user.getGender());
+ // ps.setInt(3, user.getAge());ps.setDouble(4, user.getScore());ps.setInt(5,
+ // user.getId());return ps.executeUpdate();}
+ // /*** 澧炲姞鐢ㄦ埛* @throws SQLException */
+ // public static int insertUser(User user) throws SQLException {
+ // conn = getConn();
+ // String sql = "insert into t_user(name,gender,age,score)"+ " values(?,?,?,?)";
+ // ps = conn.prepareStatement(sql);ps.setString(1,
+ // user.getName());ps.setString(2, user.getGender());
+ // ps.setInt(3, user.getAge());ps.setDouble(4, user.getScore());return
+ // ps.executeUpdate();
+ // }
+
}
--
Gitblit v1.8.0