2024/11/1 13:41: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/11/1 13:41:18 模具保养计划预警: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/11/1 13:41:18 模具保养计划预警接收人: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/11/1 13:41:20 钉钉发送信息成功!
|
|
2024/11/1 13:41:20 钉钉发送信息成功!
|
|
2024/11/1 13:42:20 查询模具保养计划: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/11/1 13:43:20 查询模具保养计划: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/11/1 13:44:20 查询模具保养计划: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/11/1 13:44:20 模具保养计划预警: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/11/1 13:44:20 模具保养计划预警接收人: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/11/1 13:44:21 钉钉发送信息成功!
|
|
2024/11/1 13:44:21 钉钉发送信息成功!
|
