1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
| 2024/10/24 15:48:17 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:48:33 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:49:34 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:50:34 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:51:34 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:51:50 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:52:04 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:54:39 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:54:54 模具保养计划预警:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 更新子表语句:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
|
| 2024/10/24 15:54:54 模具保养计划预警接收人:select a.HDingDingUserID 钉钉id,a.Czymc 接收人 from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserIdleft join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '模具保养计划预警接收人'
|
| 2024/10/24 15:54:57 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:55:26 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:56:44 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:57:47 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:58:52 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 15:59:05 模具保养计划预警:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 更新子表语句:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
|
| 2024/10/24 15:59:45 模具保养计划预警接收人:select a.HDingDingUserID 钉钉id,a.Czymc 接收人 from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserIdleft join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '模具保养计划预警接收人'
|
| 2024/10/24 16:01:01 查询模具保养计划:SELECT a.HInterID,b.HEntryID,c.HMouldNo 模具编码, c.HName 模具名称,B.HErrBeginQty,HSendFlag,d.HName 模具部门 FROM Sc_MouldMaintainPlanBillMain a INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
|
| 2024/10/24 16:01:09 模具保养计划预警:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 更新子表语句:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
|
| 2024/10/24 16:01:11 模具保养计划预警接收人:select a.HDingDingUserID 钉钉id,a.Czymc 接收人 from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserId left join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '模具保养计划预警接收人'
|
| 2024/10/24 16:01:24 钉钉发送信息成功!
|
| 2024/10/24 16:01:42 钉钉发送信息成功!
|
|
