HEGII.gt.mes.dashboard/wwwroot/main/Procedure/test10/Onecheck.ashx

<%@ WebHandler Language="C#" Class="Get_HG5010_CHECK_DEFECT" %>

using System;
using System.Web;
using System.Web.SessionState;
using System.Configuration;
using Newtonsoft.Json.Linq;
using System.Data;
using Curtain.DataAccess;
using Curtain.Log;
using DK.XuWei.WebMes;
using System.Collections.Generic;

public class Get_HG5010_CHECK_DEFECT : IHttpHandler, IRequiresSessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {

		   if (context.Request["m"].ToString() == "fwq")
            {
                string time = DateTime.Now.ToString("yyyy年MM月dd日 HH:mm ");
                Dictionary<string, string> d = new Dictionary<string, string>();
                JObject json = new JObject(
                          new JProperty("success", true),
                          new JProperty("sj", time)
                        );
                context.Response.Write(json.ToString());
            }
			if (context.Request["m"].ToString() == "SUM")
			{
				string sqlStr = @"
						SELECT
								COUNT(1) 成检交接数量
							FROM
								TP_PM_PRODUCTIONDATA PD
							WHERE
								PD.VALUEFLAG = '1' 
								AND PD.CREATETIME  >= trunc(sysdate) 
								AND PD.PROCEDUREID IN (55)  ";
				object SUMALL = conn.ExecuteScalar(sqlStr, null);
				JObject json = new JObject(
					  new JProperty("success", true),
					  new JProperty("sumall", Convert.ToInt32(SUMALL))
					);
				context.Response.Write(json.ToString());
			}
          #region 交坯质量 sql

	if (context.Request["m"].ToString() == "firstTable") {
                string sqlStr = @"
					WITH	检验数 AS (
							SELECT
								COUNT( * ) 成检交接数量,
								PDA.USERCODE
							FROM
								TP_PM_PRODUCTIONDATA PD
								LEFT JOIN TP_MST_GOODS GD ON PD.GOODSID = GD.GOODSID
								LEFT JOIN TP_MST_GOODSTYPE GDT ON GD.GOODSTYPEID = GDT.GOODSTYPEID 
								INNER JOIN TP_PM_PRODUCTIONDATA PDA ON PDA.BARCODE=PD.BARCODE
								AND PDA.USERCODE  IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
							WHERE
								PD.VALUEFLAG = '1' 
						 		AND  PD.CREATETIME >= trunc(sysdate) 
								AND PD.PROCEDUREID IN ( 48,9 )  
							GROUP BY
							PDA.USERCODE
						),
						工序缺陷数量 AS (
						SELECT
								PD.USERCODE,
							SUM(CASE WHEN DEFECT.DEFECTCODE IN ('1','3', '6','10','20','22','24','25','32','33','35','36','54','56') THEN 1 ELSE 0 END) 一检数量
						FROM
							TP_PM_DEFECT DEFECT
							LEFT JOIN TP_PM_PRODUCTIONDATA PD ON DEFECT.BARCODE = PD.BARCODE
						WHERE
							DEFECT.CREATETIME >= trunc(sysdate) 
							AND PD.VALUEFLAG = '1' --有效
							AND DEFECT.VALUEFLAG = '1' --有效
							AND PD.USERCODE IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
						GROUP BY
							PD.USERCODE
						),
						前三部位 AS (
					SELECT
					 users.USERCODE,
					(SELECT
						LISTAGG ( 前三部位 ) WITHIN GROUP ( ORDER BY 数量 DESC )  
					FROM
						( SELECT T.位置 || '(' || T.数量 || ')' 前三部位, T.数量 
						FROM ( SELECT TMDPI.DEFECTPOSITIONNAME 位置, COUNT( 1 ) 数量 
							FROM
								TP_PM_DEFECT TMDP
								LEFT JOIN TP_MST_DEFECTPOSITION TMDPI ON TMDP.DEFECTPOSITIONID = TMDPI.DEFECTPOSITIONID
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON TMDP.BARCODE = PD.BARCODE 
							WHERE
								TMDP.CREATETIME >= trunc( SYSDATE ) 
								AND PD.USERCODE =  users.USERCODE
								AND TMDP.DEFECTCODE IN ( '1' ) 
								AND PD.VALUEFLAG = '1' --有效
								AND TMDP.VALUEFLAG = '1' --有效
							GROUP BY
								TMDPI.DEFECTPOSITIONID, TMDPI.DEFECTPOSITIONNAME 
							ORDER BY COUNT( 1 ) DESC  ) T 	WHERE ROWNUM <= 3   )  ) 裂,
							
							(SELECT
						LISTAGG ( 前三部位 ) WITHIN GROUP ( ORDER BY 数量 DESC )  
					FROM
						( SELECT T.位置 || '(' || T.数量 || ')' 前三部位, T.数量 
						FROM ( SELECT TMDPI.DEFECTPOSITIONNAME 位置, COUNT( 1 ) 数量 
							FROM
								TP_PM_DEFECT TMDP
								LEFT JOIN TP_MST_DEFECTPOSITION TMDPI ON TMDP.DEFECTPOSITIONID = TMDPI.DEFECTPOSITIONID
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON TMDP.BARCODE = PD.BARCODE 
							WHERE
								 TMDP.CREATETIME >= trunc( SYSDATE ) 
								AND PD.USERCODE =  users.USERCODE
								AND TMDP.DEFECTCODE IN ( '3' ) 
								AND PD.VALUEFLAG = '1' --有效
								AND TMDP.VALUEFLAG = '1' --有效
							GROUP BY
								TMDPI.DEFECTPOSITIONID, TMDPI.DEFECTPOSITIONNAME 
							ORDER BY COUNT( 1 ) DESC  ) T 	WHERE ROWNUM <= 3   )  ) 不平,
							
								(SELECT
						LISTAGG ( 前三部位 ) WITHIN GROUP ( ORDER BY 数量 DESC )  
					FROM
						( SELECT T.位置 || '(' || T.数量 || ')' 前三部位, T.数量 
						FROM ( SELECT TMDPI.DEFECTPOSITIONNAME 位置, COUNT( 1 ) 数量 
							FROM
								TP_PM_DEFECT TMDP
								LEFT JOIN TP_MST_DEFECTPOSITION TMDPI ON TMDP.DEFECTPOSITIONID = TMDPI.DEFECTPOSITIONID
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON TMDP.BARCODE = PD.BARCODE 
							WHERE
								TMDP.CREATETIME >= trunc( SYSDATE ) 
								AND PD.USERCODE =  users.USERCODE
								AND  TMDP.DEFECTCODE IN  ( '6','10','20','22','24','25','32','33','35','36','54','56')
								AND PD.VALUEFLAG = '1' --有效
								AND TMDP.VALUEFLAG = '1' --有效
							GROUP BY
								TMDPI.DEFECTPOSITIONID, TMDPI.DEFECTPOSITIONNAME 
							ORDER BY COUNT( 1 ) DESC  ) T 	WHERE ROWNUM <= 3   )  ) 其他
					FROM TP_MST_USER  users
					WHERE USERCODE IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
					),
					数量 AS(
						SELECT
								PD.USERCODE,
								SUM( CASE WHEN DEFECT.DEFECTCODE IN ( '1' ) THEN 1 ELSE 0 END ) 裂,
								SUM( CASE WHEN DEFECT.DEFECTCODE IN ( '3' ) THEN 1 ELSE 0 END ) 不平,
								SUM( CASE WHEN DEFECT.DEFECTCODE IN ( '6','10','20','22','24','25','32','33','35','36','54','56') THEN 1 ELSE 0 END ) 其他
							FROM
								TP_PM_DEFECT DEFECT
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON DEFECT.BARCODE = PD.BARCODE
							WHERE
						 		DEFECT.CREATETIME >= trunc(sysdate) 
								AND PD.USERCODE IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
								AND PD.VALUEFLAG = '1' --有效
								AND DEFECT.VALUEFLAG = '1' --有效
							GROUP BY
									PD.USERCODE 
					),
					产量 AS(
							SELECT
								PD.USERCODE,
								COUNT(1) AS 产量
							FROM
								TP_PM_PRODUCTIONDATA PD
							WHERE
						 		 PD.CREATETIME >= trunc(sysdate) 
								
								AND PD.USERCODE IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
								AND PD.VALUEFLAG = '1' --有效
								AND PD.PROCEDUREID=55
							GROUP BY
									PD.USERCODE 
					
					)
					SELECT
					*
					FROM(
					SELECT
					前三部位.USERCODE,
					NVL(数量.裂, 0) AS 数量裂,
					NVL(数量.不平, 0) AS 数量不平,
				  NVL(数量.其他, 0)AS 数量其他,
					NVL(前三部位.裂, '--')裂,
					NVL(前三部位.不平,'--')不平,
					NVL(前三部位.其他, '--')其他,
					NVL(产量.产量, 0) AS 产量,
					DECODE( NVL( 工序缺陷数量.一检数量, 0 ), 0, '100%', TO_CHAR( ( ( NVL( 检验数.成检交接数量, 1 )- NVL( 工序缺陷数量.一检数量, 0 )) / DECODE( NVL( 检验数.成检交接数量, 1 ), 0, 1, NVL( 检验数.成检交接数量, 1 ) ) ) * 100, 'fm99990.00' ) || '%' ) 合格率
					FROM 前三部位 
					LEFT JOIN 检验数 ON 检验数.USERCODE = 前三部位.USERCODE
					LEFT JOIN 工序缺陷数量 ON 工序缺陷数量.USERCODE=前三部位.USERCODE
					LEFT JOIN 数量 on 数量.USERCODE=前三部位.USERCODE  
					LEFT JOIN 产量 ON 产量.USERCODE=前三部位.USERCODE
					order by 前三部位.USERCODE
					)
";
                int page = 1;
                if (Convert.ToInt32(context.Request["page"].ToString()) != 1)
                {
                    page = Convert.ToInt32(context.Request["page"].ToString());
                }
                int rows = HttpContext.Current.Request["rows"] is object ? Convert.ToInt32(HttpContext.Current.Request["rows"]) : 8;
                //获取分页数据
                int total = 0;
                DataTable dt = conn.SelectPages(page, rows, out total, sqlStr);
                context.Response.Write( new JsonResult(dt) { total = total }.ToJson());
            }
			

			if (context.Request["m"].ToString() == "count") {
                string sqlStr = @"
					WITH	检验数 AS (
							SELECT
								COUNT( * ) 成检交接数量,
								PDA.USERCODE
							FROM
								TP_PM_PRODUCTIONDATA PD
								LEFT JOIN TP_MST_GOODS GD ON PD.GOODSID = GD.GOODSID
								LEFT JOIN TP_MST_GOODSTYPE GDT ON GD.GOODSTYPEID = GDT.GOODSTYPEID 
								INNER JOIN TP_PM_PRODUCTIONDATA PDA ON PDA.BARCODE=PD.BARCODE
								AND PDA.USERCODE  IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
							WHERE
								PD.VALUEFLAG = '1' 
						 		AND PD.CREATETIME >= trunc(sysdate) 
								AND PD.PROCEDUREID IN ( 48,9 )  
							GROUP BY
							PDA.USERCODE
						),
						工序缺陷数量 AS (
						SELECT
								PD.USERCODE,
							SUM(CASE WHEN DEFECT.DEFECTCODE IN ('1','3', '6','10','20','22','24','25','32','33','35','36','54','56') THEN 1 ELSE 0 END) 一检数量
						FROM
							TP_PM_DEFECT DEFECT
							LEFT JOIN TP_PM_PRODUCTIONDATA PD ON DEFECT.BARCODE = PD.BARCODE
						WHERE
							DEFECT.CREATETIME >= trunc(sysdate) 
							AND PD.VALUEFLAG = '1' --有效
							AND DEFECT.VALUEFLAG = '1' --有效
							AND PD.USERCODE IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
						GROUP BY
							PD.USERCODE
						),
						前三部位 AS (
					SELECT
					 users.USERCODE,
					(SELECT
						LISTAGG ( 前三部位 ) WITHIN GROUP ( ORDER BY 数量 DESC )  
					FROM
						( SELECT T.位置 || '(' || T.数量 || ')' 前三部位, T.数量 
						FROM ( SELECT TMDPI.DEFECTPOSITIONNAME 位置, COUNT( 1 ) 数量 
							FROM
								TP_PM_DEFECT TMDP
								LEFT JOIN TP_MST_DEFECTPOSITION TMDPI ON TMDP.DEFECTPOSITIONID = TMDPI.DEFECTPOSITIONID
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON TMDP.BARCODE = PD.BARCODE 
							WHERE
								TMDP.CREATETIME >= trunc( SYSDATE ) 
								AND PD.USERCODE =  users.USERCODE
								AND TMDP.DEFECTCODE IN ( '1' ) 
								AND PD.VALUEFLAG = '1' --有效
								AND TMDP.VALUEFLAG = '1' --有效
							GROUP BY
								TMDPI.DEFECTPOSITIONID, TMDPI.DEFECTPOSITIONNAME 
							ORDER BY COUNT( 1 ) DESC  ) T 	WHERE ROWNUM <= 3   )  ) 裂,
							
							(SELECT
						LISTAGG ( 前三部位 ) WITHIN GROUP ( ORDER BY 数量 DESC )  
					FROM
						( SELECT T.位置 || '(' || T.数量 || ')' 前三部位, T.数量 
						FROM ( SELECT TMDPI.DEFECTPOSITIONNAME 位置, COUNT( 1 ) 数量 
							FROM
								TP_PM_DEFECT TMDP
								LEFT JOIN TP_MST_DEFECTPOSITION TMDPI ON TMDP.DEFECTPOSITIONID = TMDPI.DEFECTPOSITIONID
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON TMDP.BARCODE = PD.BARCODE 
							WHERE
								TMDP.CREATETIME >= trunc( SYSDATE ) 
								AND PD.USERCODE =  users.USERCODE
								AND TMDP.DEFECTCODE IN ( '3' ) 
								AND PD.VALUEFLAG = '1' --有效
								AND TMDP.VALUEFLAG = '1' --有效
							GROUP BY
								TMDPI.DEFECTPOSITIONID, TMDPI.DEFECTPOSITIONNAME 
							ORDER BY COUNT( 1 ) DESC  ) T 	WHERE ROWNUM <= 3   )  ) 不平,
							
								(SELECT
						LISTAGG ( 前三部位 ) WITHIN GROUP ( ORDER BY 数量 DESC )  
					FROM
						( SELECT T.位置 || '(' || T.数量 || ')' 前三部位, T.数量 
						FROM ( SELECT TMDPI.DEFECTPOSITIONNAME 位置, COUNT( 1 ) 数量 
							FROM
								TP_PM_DEFECT TMDP
								LEFT JOIN TP_MST_DEFECTPOSITION TMDPI ON TMDP.DEFECTPOSITIONID = TMDPI.DEFECTPOSITIONID
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON TMDP.BARCODE = PD.BARCODE 
							WHERE
								TMDP.CREATETIME >= trunc( SYSDATE ) 
								AND PD.USERCODE =  users.USERCODE
								AND  TMDP.DEFECTCODE IN  ( '6','10','20','22','24','25','32','33','35','36','54','56')
								AND PD.VALUEFLAG = '1' --有效
								AND TMDP.VALUEFLAG = '1' --有效
							GROUP BY
								TMDPI.DEFECTPOSITIONID, TMDPI.DEFECTPOSITIONNAME 
							ORDER BY COUNT( 1 ) DESC  ) T 	WHERE ROWNUM <= 3   )  ) 其他
					FROM TP_MST_USER  users
					WHERE USERCODE IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
					),
					数量 AS(
						SELECT
								PD.USERCODE,
								SUM( CASE WHEN DEFECT.DEFECTCODE IN ( '1' ) THEN 1 ELSE 0 END ) 裂,
								SUM( CASE WHEN DEFECT.DEFECTCODE IN ( '3' ) THEN 1 ELSE 0 END ) 不平,
								SUM( CASE WHEN DEFECT.DEFECTCODE IN ( '6','10','20','22','24','25','32','33','35','36','54','56') THEN 1 ELSE 0 END ) 其他
							FROM
								TP_PM_DEFECT DEFECT
								LEFT JOIN TP_PM_PRODUCTIONDATA PD ON DEFECT.BARCODE = PD.BARCODE
							WHERE
						 		 DEFECT.CREATETIME >= trunc(sysdate) 
								AND PD.USERCODE IN ('T03','T04','T05','T06','T07','T08','T09','T12','T13','T14','T15','T16','T17','T18','T19','T25','T26')
								AND PD.VALUEFLAG = '1' --有效
								AND DEFECT.VALUEFLAG = '1' --有效
							GROUP BY
									PD.USERCODE 
					)
					SELECT
					COUNT(*)
					FROM(
					SELECT
					前三部位.USERCODE,
					NVL(数量.裂, 0) AS 数量裂,
					NVL(数量.不平, 0) AS 数量不平,
				  NVL(数量.其他, 0)AS 数量其他,
					NVL(前三部位.裂, '--')裂,
					NVL(前三部位.不平,'--')不平,
					NVL(前三部位.其他, '--')其他,
					DECODE( NVL( 工序缺陷数量.一检数量, 0 ), 0, '100%', TO_CHAR( ( ( NVL( 检验数.成检交接数量, 1 )- NVL( 工序缺陷数量.一检数量, 0 )) / DECODE( NVL( 检验数.成检交接数量, 1 ), 0, 1, NVL( 检验数.成检交接数量, 1 ) ) ) * 100, 'fm99990.00' ) || '%' ) 合格率
					FROM 前三部位 
					LEFT JOIN 检验数 ON 检验数.USERCODE = 前三部位.USERCODE
					LEFT JOIN 工序缺陷数量 ON 工序缺陷数量.USERCODE=前三部位.USERCODE
					LEFT JOIN 数量 on 数量.USERCODE=前三部位.USERCODE  
					order by 前三部位.USERCODE
					)
					WHERE 合格率!='0%'";
                object count = conn.ExecuteScalar(sqlStr,null);
                JObject json = new JObject(
                      new JProperty("success",true),
                      new JProperty("counts", Convert.ToInt32(count))
                    );
                context.Response.Write(json.ToString());
            }

            #endregion


			     #region 重点关注成型样式 sql

	if (context.Request["m"].ToString() == "second") {
                string sqlStr = @"SELECT
ROWNUM AS 序号,
GROUTINGLINECODE,
GOODSCODE,
USERCODE,
message,
ConcernMessage
FROM(
									SELECT
									GROUTINGLINECODE AS GROUTINGLINECODE ,
									GOODSCODE AS GOODSCODE,
									GROUTINGUSERCODE AS USERCODE,
									message,
									ConcernMessage
									FROM(SELECT
									GROUTINGLINECODE,
									GOODSCODE,
									GROUTINGUSERCODE,
									message,
									SUM(ConcernMessage) as ConcernMessage
									FROM
									(
									SELECT
									GROUTINGLINECODE,
									GOODSCODE,
									GROUTINGUSERCODE,
									nums,
									CASE WHEN NEWMOLDFLAG='1' THEN '新模'
	  										WHEN CONVERTPRODUCEFLAG='1' THEN '转产'
												WHEN CONVERTLINEGLAG='1' THEN '变线'
												WHEN  countday >=15 THEN '距离注浆时间'||countday||'天'
												WHEN countday<15 THEN '第'|| GROUTINGCOUNT ||'次注浆' end message,
												NUMS as ConcernMessage
									FROM(
									SELECT
									GROUTINGLINECODE,
									GROUTINGUSERCODE,
									GOODSCODE,
									NEWMOLDFLAG,
									CONVERTPRODUCEFLAG,
									CONVERTLINEGLAG,
									GROUTINGCOUNT,
									COUNT(GROUTINGDAILYDETAILID) NUMS,
									countday
									FROM(
									SELECT
									bak.GROUTINGDAILYDETAILID,bak.GROUTINGLINECODE,
									bak.PROCEDURETIME,bak.PROCEDUREID,bak.GROUTINGUSERCODE,bak.GOODSCODE,
									(TRUNC(SYSDATE)-TRUNC(bak.GROUTINGDATE))countday,
									gd.GROUTINGCOUNT as GROUTINGCOUNT,
									TGS.NEWMOLDFLAG,
									TGS.CONVERTPRODUCEFLAG,
									TGS.CONVERTLINEGLAG
									FROM  TP_PM_INPRODUCTION_BAK7OCLOCK bak
									INNER JOIN TP_PM_GROUTINGDAILYDETAIL gd on gd.GROUTINGDAILYDETAILID=bak.GROUTINGDAILYDETAILID
									LEFT JOIN TP_PM_GROUTINGSPECIAL TGS ON TGS.GROUTINGLINEID = bak.GROUTINGLINEID
									LEFT JOIN TP_MST_GOODS G ON G.GOODSID = GD.GOODSID
									WHERE(bak.PROCEDUREID = 50  or bak.PROCEDUREID=29)
									AND G.GOODS_LINE_TYPE = 0
									AND bak.BACKUPTIME >= TRUNC( SYSDATE) ORDER BY bak.PROCEDUREID desc,bak.PROCEDURETIME ASC 
									)
									WHERE  ROWNUM<=2100
									 GROUP BY GROUTINGLINECODE,
									GROUTINGUSERCODE,
									GOODSCODE,
									NEWMOLDFLAG,
									CONVERTPRODUCEFLAG,
									GROUTINGCOUNT,
									countday,
									CONVERTLINEGLAG
									)WHERE ( ( (GROUTINGCOUNT  BETWEEN 1 AND 5 OR GROUTINGCOUNT >90)  OR countday>=15)   OR( NEWMOLDFLAG='1' OR CONVERTPRODUCEFLAG='1' OR CONVERTLINEGLAG='1' ))
									)
									GROUP BY 
									GROUTINGLINECODE,
									GROUTINGUSERCODE,
									GOODSCODE,
									message
									) ORDER BY  GROUTINGLINECODE ,GROUTINGUSERCODE,message
									)";
                int page = 1;
                if (Convert.ToInt32(context.Request["secondpages"].ToString()) != 1)
                {
                    page = Convert.ToInt32(context.Request["secondpages"].ToString());
                }

                int rows = HttpContext.Current.Request["rows"] is object ? Convert.ToInt32(HttpContext.Current.Request["rows"]) : 11;
                //获取分页数据
                int total = 0;
                DataTable dt = conn.SelectPages(page, rows, out total, sqlStr);
                context.Response.Write( new JsonResult(dt) { total = total }.ToJson());

            }
			

			if (context.Request["m"].ToString() == "secondcount") {
                string sqlStr = @"SELECT
	COUNT(*) 
FROM
	(
	
									SELECT
									ROWNUM as 序号 ,
									GROUTINGLINECODE AS GROUTINGLINECODE ,
									GOODSCODE AS GOODSCODE,
									GROUTINGUSERCODE AS USERCODE,
									message,
									ConcernMessage
									FROM(SELECT
									GROUTINGLINECODE,
									GOODSCODE,
									GROUTINGUSERCODE,
									message,
									SUM(ConcernMessage) as ConcernMessage
									FROM
									(
									SELECT
									GROUTINGLINECODE,
									GOODSCODE,
									GROUTINGUSERCODE,
									CASE WHEN NEWMOLDFLAG='1' THEN '新模'
	  										WHEN CONVERTPRODUCEFLAG='1' THEN '转产'
												WHEN CONVERTLINEGLAG='1' THEN '变线'
												WHEN  countday >=15 THEN '距离注浆时间'||countday||'天'
												WHEN countday<15 THEN '第'|| GROUTINGCOUNT ||'次注浆' end message,
												NUMS as ConcernMessage
									FROM(
									SELECT
									GROUTINGLINECODE,
									GROUTINGUSERCODE,
									GOODSCODE,
									NEWMOLDFLAG,
									CONVERTPRODUCEFLAG,
									CONVERTLINEGLAG,
									GROUTINGCOUNT,
									COUNT(GROUTINGDAILYDETAILID) NUMS,
									countday
									FROM(
									SELECT
									bak.GROUTINGDAILYDETAILID,bak.GROUTINGLINECODE,
									bak.PROCEDURETIME,bak.PROCEDUREID,bak.GROUTINGUSERCODE,bak.GOODSCODE,
									(TRUNC(SYSDATE)-TRUNC(bak.GROUTINGDATE))countday,
									gd.GROUTINGCOUNT as GROUTINGCOUNT,
									TGS.NEWMOLDFLAG,
									TGS.CONVERTPRODUCEFLAG,
									TGS.CONVERTLINEGLAG
									FROM  TP_PM_INPRODUCTION_BAK7OCLOCK bak
									INNER JOIN TP_PM_GROUTINGDAILYDETAIL gd on gd.GROUTINGDAILYDETAILID=bak.GROUTINGDAILYDETAILID
									LEFT JOIN TP_PM_GROUTINGSPECIAL TGS ON TGS.GROUTINGLINEID = bak.GROUTINGLINEID
									LEFT JOIN TP_MST_GOODS G ON G.GOODSID = gd.GOODSID
									WHERE(bak.PROCEDUREID = 50  or bak.PROCEDUREID=29)
									AND G.GOODS_LINE_TYPE = 0
									AND bak.BACKUPTIME >= TRUNC( SYSDATE) ORDER BY bak.PROCEDUREID desc,bak.PROCEDURETIME ASC 
									)
									WHERE  ROWNUM<=2100
									 GROUP BY GROUTINGLINECODE,
									GROUTINGUSERCODE,
									GOODSCODE,
									NEWMOLDFLAG,
									CONVERTPRODUCEFLAG,
									GROUTINGCOUNT,
									countday,
									CONVERTLINEGLAG
									)WHERE ( ( (GROUTINGCOUNT  BETWEEN 1 AND 5 OR GROUTINGCOUNT >90)  OR countday>=15)   OR( NEWMOLDFLAG='1' OR CONVERTPRODUCEFLAG='1' OR CONVERTLINEGLAG='1' ))
									)
									GROUP BY 
									GROUTINGLINECODE,
									GOODSCODE,
									message,
									GROUTINGUSERCODE )) ";
                object count = conn.ExecuteScalar(sqlStr,null);
                JObject json = new JObject(
                      new JProperty("success",true),
                      new JProperty("counts", Convert.ToInt32(count))
                    );
                context.Response.Write(json.ToString());
            }

            #endregion
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }
}