| | |
|---|
| | | List<CapaPlan> list4 = ids1.Except(ids).ToList(); //表示ids1中哪些值是ids中所不存在的; |
|---|
| | | list4 = list3.Union(list4).ToList(); |
|---|
| | | //查找关键工序设备、工位群组的所有设备 |
|---|
| | | string sql3 = @"select * from( |
|---|
| | | select distinct A.code,A.name from TEqpInfo A |
|---|
| | | string sql3 = @"select distinct A.code,A.name from TEqpInfo A |
|---|
| | | left join TFlw_Rteqp B on A.code=B.eqp_code |
|---|
| | | left join TFlw_Rtdt D on B.step_code=D.step_code |
|---|
| | | where A.wksp_code=@wkshopcode and D.first_choke='Y' order by A.code)"; |
|---|
| | | where A.wksp_code=@wkshopcode and D.first_choke='Y' order by A.code"; |
|---|
| | | dynamicParams.Add("@wkshopcode", wkshopcode); |
|---|
| | | var dt3 = DapperHelper.selectdata(sql3, dynamicParams); |
|---|
| | | if (list4.Count > 0) //如果日期有变动 |
|---|
