| | |
|---|
| | | } |
|---|
| | | //查询出要发信息的异常参数 |
|---|
| | | |
|---|
| | | string newSql = @"SELECT 车间, STUFF(( SELECT '; ' + 设备编码 + ' - ' + 工艺参数名称 + ' - 数采值: ' + CAST(数采值 AS VARCHAR(10)) + ' - 上限值: ' + CAST(上限值 AS VARCHAR(10)) + ' - 下限值: ' + CAST(下限值 AS VARCHAR(10)) |
|---|
| | | FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS InnerTable WHERE InnerTable.车间 = OuterTable.车间 AND 发现异常时间 >= DATEADD(minute, -1, GETDATE()) |
|---|
| | | FOR XML PATH('') ), 1, 2, '') AS 内容 FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS OuterTable GROUP BY 车间 "; |
|---|
| | | string newSql = @"SELECT 工序名称, STUFF(( SELECT '; ' + 设备编码 + ' - ' + 工艺参数名称 + ' - 数采值: ' + CAST(数采值 AS VARCHAR(10)) + ' - 上限值: ' + CAST(上限值 AS VARCHAR(10)) + ' - 下限值: ' + CAST(下限值 AS VARCHAR(10)) |
|---|
| | | FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS InnerTable WHERE InnerTable.工序名称 = OuterTable.工序名称 AND 发现异常时间 >= DATEADD(minute, -1, GETDATE()) |
|---|
| | | FOR XML PATH('') ), 1, 2, '') AS 内容 FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS OuterTable GROUP BY 工序名称 "; |
|---|
| | | DBHelper.CustomWriteLog("查询出要发信息的异常参数"+newSql, DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | dt1 = oCN.RunProcReturn(newSql, "h_v_Sb_EquipMentCollectionTechParam_ERRList"); |
|---|
| | | string HContext = ""; string HDeptName = ""; |
|---|
| | |
|---|
| | | { |
|---|
| | | DBHelper.CustomWriteLog("异常内容数量 "+ dt1.Tables[0].Rows.Count, DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | HContext = dt1.Tables[0].Rows[j]["内容"].ToString(); |
|---|
| | | HDeptName = dt1.Tables[0].Rows[j]["车间"].ToString(); |
|---|
| | | HDeptName = dt1.Tables[0].Rows[j]["工序名称"].ToString(); |
|---|
| | | DBHelper.CustomWriteLog("异常内容值 "+ HContext, DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | DBHelper.CustomWriteLog("异常车间值 " + HDeptName, DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | if (!string.IsNullOrEmpty(HContext) && HContext.ToLower() != "null") |
|---|
