Day1-T4

原题目

  Describe:注意是“两次及以上”而不是“两种及以上”!!

  code

#include<bits/stdc++.h>
using namespace std;
int k,m,n,ans;
int f[1005][1005],cnt[20],a[1005][1005];
inline int read(){
    int 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 int lowbit(int x){
    return (-x)&x;
}
inline void write(int x){
    if(x<0){putchar('-');write(-x);return;}
    if(x/10)write(x/10);
    putchar(x%10+'0');
}
inline int search(int x,int y){
    if(x==n&&y==m+1)return 1;                                     //Finish the search
    if(y==m+1)y=1,x++;                                            //下一行 
    int Sum=f[x-1][y]|f[x][y-1],pr=-1,sum=0,ans=0;                //Sum=当前方格上面及左边共被使用多少个颜色 
    for(int i=Sum;i>0;i-=lowbit(i))sum++;                         //统计当前状态下有多少个颜色已被使用 
    if(n+m-x-y-1>k-sum)return 0;                                  //剪枝,若剩余方格少于剩余颜色 
    for(int i=1;i<=k;i++){                                        //枚举状态 
        if((1<<(i-1))&Sum)continue;                               //已被使用 
        if(!a[x][y]||a[x][y]==i){                                 //未被涂色或已涂颜色未被使用 
            f[x][y]=Sum|(1<<(i-1));                               //涂成当前颜色,加入状态 
            if(!cnt[i]){                                          //------------DFS模板--------------- 
                cnt[i]++;
                if(pr==-1)pr=search(x,y+1);
                ans+=pr;
            }
            else cnt[i]++,ans+=search(x,y+1);
            ans%=1000000007;cnt[i]--;
        }
    }
    return ans;
}
int main(){
    freopen("paths.in","r",stdin);
    freopen("paths.out","w",stdout);
    n=read(),m=read(),k=read();
    for(int i=1;i<=n;i++)for(int j=1;j<=m;j++)a[i][j]=read(),cnt[a[i][j]]++;
    ans=search(1,1);write(ans);
}

 

  

 

转载于:https://www.cnblogs.com/sroht/p/9873118.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、付费专栏及课程。

余额充值