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 钉钉发送信息成功!