Day4-T4

原题目

  Describe:建个图,连通后删边 [ 如果把 !dis[i][j] 全部定义为INF会更好理解 ] 。先特判,再贪心求总数

  code:

#pragma GCC optimize(2)
#include<bits/stdc++.h>
using namespace std;
int n,m,k,tot,nn,ans,t;
int father[5005],fa[5005];
bool b[5050];
struct bian{
	long long l,r,w;
}dis[100010];
bool cmp(bian x,bian y){return x.w<y.w;}


int getfather(int p){
	if(father[p]==p) return p;
	return father[p]=getfather(father[p]);
}
void uni(int x,int y){
	int fx=getfather(x);
	int fy=getfather(y);
	if(fx!=fy) father[fx]=fy;
}


int getfa(int p){
	if(fa[p]==p) return p;
	return fa[p]=getfa(fa[p]);
}
void Uni(int x,int y){
	int fx=getfa(x);
	int fy=getfa(y);
	if(fx!=fy) fa[fx]=fy;
}


inline long long read(){
	long long ret=0,f=1;char ch=getchar();
	while (ch<'0'||ch>'9') {if (ch=='-') f=-f;ch=getchar();}
	while (ch>='0'&&ch<='9') ret=ret*10+ch-'0',ch=getchar();
	return ret*f;
}
inline void write(int x){
	if(x<0){putchar('-');write(-x);return;}
    if(x/10) write(x/10);
    putchar(x%10+'0');
}
int main(){
	//freopen("pocket.in","r",stdin);
	//freopen("pocket.out","w",stdout);
	t=read();
	while(t--){
		memset(dis,0,sizeof(dis));
		memset(b,0,sizeof(b));
		n=0,m=0,k=0,tot=0,nn=0,ans=0;
		n=read(),m=read(),k=read();
		for(int i=1;i<=n;i++)father[i]=i,fa[i]=i;
		for(int i=1;i<=m;i++)dis[i].l=read(),dis[i].r=read(),dis[i].w=read(),Uni(dis[i].l,dis[i].r);
		
		for(int i=1;i<=n;i++){                                                                                 //此段代码判断是否可能满足条件 
			int ss=getfa(i);
			if(!b[ss])b[ss]++,tot++;
		}
		if(tot>k||n<k){cout<<"No Answer"<<endl;continue;}                                                      //云数小于棉花糖数或全合并后依旧比限制多 
		
	    sort(dis+1,dis+m+1,cmp);                                                                               //按边权排序 
	    for(int i=1;i<=m;i++){                                                                                 //Kruskal 
			int sum=0;
			if(getfather(dis[i].l)!=getfather(dis[i].r)){
				uni(dis[i].l,dis[i].r);
				ans+=dis[i].w;nn++;
			}
			if(nn==n-k)break;                                                                                  //只需要n-k条边 
		}
		write(ans);
		puts("");
	}
    return 0;
}

  

转载于:https://www.cnblogs.com/sroht/p/9892054.html

WITH – 1. 计算计划生产时间 ttt1 AS ( SELECT line AS 线别, part AS 生产线, DATEADD(DAY, CASE WHEN RIGHT(start_datetime_real, 8) < ‘04:00:00’ THEN -1 ELSE 0 END, CAST(start_datetime_real AS DATE)) AS 日期, CASE WHEN RIGHT(start_datetime_real, 8) BETWEEN ‘07:00:00’ AND ‘17:10:00’ THEN ‘早班’ ELSE ‘中班’ END AS 班次, SUM(DATEDIFF(MINUTE, start_datetime_plc, end_datetime_plc)) AS 计划生产时间 FROM dbo.ods_fault_info WHERE mc_no = ‘main1’ AND register_address = ‘EL1A70’ AND CAST(start_datetime_real AS DATE) >= CAST(GETDATE()-9 AS DATE) – 日期过滤提前 GROUP BY line, part, DATEADD(DAY, CASE WHEN RIGHT(start_datetime_real, 8) < ‘04:00:00’ THEN -1 ELSE 0 END, CAST(start_datetime_real AS DATE)), CASE WHEN RIGHT(start_datetime_real, 8) BETWEEN ‘07:00:00’ AND ‘17:10:00’ THEN ‘早班’ ELSE ‘中班’ END ), – 2. 计算设备停止时间 ttt2 AS ( SELECT t4.line AS 线别, t4.part AS 生产线, t4.mc_no AS 设备编号, DATEADD(DAY, CASE WHEN RIGHT(t4.start_datetime_real, 8) < ‘04:00:00’ THEN -1 ELSE 0 END, CAST(t4.start_datetime_real AS DATE)) AS 日期, CASE WHEN RIGHT(t4.start_datetime_real, 8) BETWEEN ‘07:00:00’ AND ‘17:10:00’ THEN ‘早班’ ELSE ‘中班’ END AS 班次, SUM(DATEDIFF(MINUTE, t4.start_datetime_real, t4.end_datetime_real)) AS 停止时间 FROM ( SELECT t2.* FROM dbo.ods_fault_info t1 – 主设备 JOIN dbo.ods_fault_info t2 – 关联设备 ON t1.line = t2.line AND t1.part = t2.part AND t2.start_datetime_real BETWEEN t1.start_datetime_real AND t1.end_datetime_real AND t2.mc_no <> ‘main1’ WHERE t1.mc_no = ‘main1’ AND t1.register_address = ‘EL1A70’ AND t2.register_address = ‘EL1A70’ ) t4 WHERE CAST(t4.start_datetime_real AS DATE) >= CAST(GETDATE()-9 AS DATE) – 日期过滤提前 GROUP BY t4.line, t4.part, t4.mc_no, DATEADD(DAY, CASE WHEN RIGHT(t4.start_datetime_real, 8) < ‘04:00:00’ THEN -1 ELSE 0 END, CAST(t4.start_datetime_real AS DATE)), CASE WHEN RIGHT(t4.start_datetime_real, 8) BETWEEN ‘07:00:00’ AND ‘17:10:00’ THEN ‘早班’ ELSE ‘中班’ END ), – 3. 计算可动率并排序 ranked_data AS ( SELECT t1.线别, t1.生产线, t1.日期, t1.班次, t2.设备编号, t1.计划生产时间, t2.停止时间, CASE WHEN (t1.计划生产时间 - t2.停止时间) <= 0 THEN 0 WHEN (t1.计划生产时间 - t2.停止时间) >= t1.计划生产时间 THEN 100 ELSE CAST((t1.计划生产时间 - t2.停止时间) * 100.0 / t1.计划生产时间 AS DECIMAL(5,2)) END AS 可动率, ROW_NUMBER() OVER (PARTITION BY t1.日期 ORDER BY CASE WHEN (t1.计划生产时间 - t2.停止时间) <= 0 THEN 0 WHEN (t1.计划生产时间 - t2.停止时间) >= t1.计划生产时间 THEN 100 ELSE CAST((t1.计划生产时间 - t2.停止时间) * 100.0 / t1.计划生产时间 AS DECIMAL(5,2)) END ASC) AS num FROM ttt1 t1 LEFT JOIN ttt2 t2 ON t1.线别 = t2.线别 AND t1.生产线 = t2.生产线 AND t1.日期 = t2.日期 AND t1.班次 = t2.班次 WHERE t1.计划生产时间 > 0 – 避免除零错误 ) – 4. 最终结果关联设备标签 SELECT * FROM ranked_data r LEFT JOIN dbo.V_jiadongshijian t_p ON r.日期 = t_p.RealDataReportDay LEFT JOIN (select 设备编号,工序号 from [dbo].[dwd_设备信息]) b ON b.设备编号 = r.设备编号 WHERE – r.num <= 5 – AND r.日期 >= CAST(GETDATE()-9 AS DATE) – 近9天数据 AND (t_p.RealDataReportDay IS NOT NULL OR r.日期 = CAST(GETDATE() AS DATE)) 班次中的早班和中班合并为一天统计数据
09-05
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值