HEGII.ss.mes.web/wwwroot/mes/rpt/rpt.ashx

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

using System;
using System.Web;
using System.Web.SessionState;
using System.Collections.Generic;
using System.Data;
using Curtain.DataAccess;
using DK.XuWei.WebMes;

public class rpt : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        if (context.Request["m"] is object)
        {
            //不验证帐套 默认为1
            int accountId = (context.Session["accountId"] is object) ?
                    Convert.ToInt32(context.Session["accountId"]) : 1;

            switch (context.Request["m"].ToString())
            {
                case "getDefectPosition":
                    {
                        //获取不合格位置
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            //DataTable dt = conn.ExecuteDatatable(@"
                            //  SELECT t.defectpositionid
                            //          ,t.defectpositionname
                            //      FROM tp_mst_defectposition t
                            //     WHERE t.valueflag = '1'
                            //     ORDER BY t.displayno
                            //");
                            DataTable dt = conn.ExecuteDatatable(@"
select tt.defectpositionid, tt.defectpositionname from
(
select -t.defectpositionid defectpositionid, t.defectpositionname, 1 stype, t.displayno, t.defectpositionid as ssid
from tp_mst_scdefectposition t
where t.valueflag='1'
union all
select t.defectpositionid, t.defectpositionname, 2 stype, t.displayno, t.defectpositionid as ssid 
from tp_mst_defectposition t
where t.valueflag='1'
) tt
order by tt.stype, tt.displayno, tt.ssid
                            ");
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getDefectReason":
                    {
                        //获取不合格原因
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            //DataTable dt = conn.ExecuteDatatable(@"
                            //  SELECT t.defectid
                            //      ,t.defectname
                            //  FROM tp_mst_defect t
                            // WHERE t.valueflag = '1'
                            // ORDER BY t.displayno
                            //");
                            DataTable dt = conn.ExecuteDatatable(@"
select tt.defectid, tt.defectname from
(
select -d.defectid defectid, d.defectname, 1 stype, d.displayno, d.defectid as ssid
from tp_mst_semicheckdefect d 
where d.valueflag='1'
union all
select t.defectid, t.defectname, 2 stype, t.displayno, t.defectid as ssid
from tp_mst_defect t
where t.valueflag='1'
) tt
order by tt.stype, tt.displayno, tt.ssid
                            ");
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getCheckResult":
                    {
                        //获取检查结果
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                              SELECT t.goodsleveltypeid
                                  ,t.goodsleveltypename || CASE
                                       WHEN t.goodsleveltypeid IN (4, 5) THEN
                                        '[合格]'
                                       ELSE
                                        '[不合格]'
                                   END goodsleveltypename
                              FROM tp_sys_goodsleveltype t
                             WHERE t.goodsleveltypeid IN (4, 5, 6, 7, 16)
                             ORDER BY t.goodsleveltypeid
                            ");
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getProcedureByReason":
                    {
                        //获取工序节点（有质检原因的）
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            //DataTable dt = conn.ExecuteDatatable(@"
                            //  SELECT p.procedureid
                            //          ,p.procedurename
                            //      FROM tp_pc_procedure p
                            //     WHERE p.proceduremodel = '2'
                            //       AND p.valueflag = '1'
                            //       AND p.modeltype IN (-1, -4, -5)
                            //     ORDER BY p.displayno
                            //");
                            DataTable dt = conn.ExecuteDatatable(@"
                              SELECT p.procedureid
                                      ,p.procedurename
                                  FROM tp_pc_procedure p
                                 WHERE p.valueflag = '1'
                                   AND (p.modeltype in (-1, -4, -5) or p.p_is_check = 1)
                                 ORDER BY p.displayno
                            ");
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getMateriaPlan":
                    {
                        //获取领料设置
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                               SELECT t.autoid
                                  ,t.autoname
                                  ,t.time_start
                                  ,to_char(t.time_start ,' hh24:mi:ss') as stime
                                  ,time_working
                              FROM tp_pc_materiaplan_auto t
                             WHERE t.valueflag = '1'
                             ORDER BY t.displayno
                            ");
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getPLCName":
                    {
                        //获取设备名称
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                select PLC_NAME AS PLCNAME from T_XT_PLC GROUP BY PLC_NAME order by PLC_NAME
                            ");
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getGoodsType":
                    {
                        string child = context.Request["child"];
                        string jsonStr = "";
                        if (!string.IsNullOrEmpty(child) && child == "0")//没有子类
                        {
                            jsonStr = "[{\"id\":\"001\",\"text\":\"全部\"},{\"id\":\"001001\",\"text\":\"大件\"},{\"id\":\"001002\",\"text\":\"小件\"}]";
                        }
                        else
                        {
                            //获取产品类别 全部
                            using (IDataAccess conn = DataAccess.Create())
                            {
                                DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                --GOODSTYPEID AS ID,
	                                GOODSTYPECODE AS ID,
	                                GOODSTYPECODE AS CODE,
	                                GOODSTYPENAME AS TEXT,
	                                '' AS URL 
                                FROM
	                                TP_MST_GOODSTYPE 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@  
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                GOODSTYPECODE
                            ",
                                    new CDAParameter("ACCOUNTID", accountId)
                                );
                                string rootId = dt.Rows[0]["id"].ToString();
                                string rootCode = dt.Rows[0]["code"].ToString();
                                string rootText = dt.Rows[0]["text"].ToString();
                                string children = Easyui.TableToEasyUITree(dt, rootCode, 3);
                                jsonStr = "[{\"id\":\"" + rootId + "\",\"text\":\"" + rootText + "\"" + children + "}]";
                            }
                        }
                        context.Response.Write(jsonStr);
                        break;
                    }
                case "getGoods":
                    {
                        //获取产品列表 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                --t.GOODSTYPECODE,
	                                --t.GOODSTYPENAME,
	                                g.GOODSID,
	                                g.GOODSCODE,
	                                g.GOODSNAME,
                                    g.GOODSID AS VALUE,
                                    g.GOODSCODE || g.GOODSNAME AS TEXT
                                FROM
	                                TP_MST_GOODS g
	                                LEFT JOIN TP_MST_GOODSTYPE t ON g.GOODSTYPEID = t.GOODSTYPEID
                                WHERE
                                    g.ACCOUNTID = @ACCOUNTID@ 
	                                AND g.VALUEFLAG = '1'
                                ORDER BY
                                    t.GOODSTYPECODE,g.GOODSCODE
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getOrganization":
                    {
                        //获取部门 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            if (!string.IsNullOrEmpty(context.Request["sele"]) && context.Request["sele"] == "all")
                            {
                                DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                ORGANIZATIONID AS NUM,
	                                ORGANIZATIONCODE AS ID,
	                                ORGANIZATIONCODE AS CODE,
	                                ORGANIZATIONNAME AS TEXT,
	                                '' AS URL 
                                FROM
	                                TP_MST_ORGANIZATION 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                ORGANIZATIONCODE
                            ",
                               new CDAParameter("ACCOUNTID", accountId)
                           );
                                context.Response.Write(dt.ToJson());
                            }
                            else
                            {
                                DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                --ORGANIZATIONID AS ID,
	                                ORGANIZATIONCODE AS ID,
	                                ORGANIZATIONCODE AS CODE,
	                                ORGANIZATIONNAME AS TEXT,
	                                '' AS URL 
                                FROM
	                                TP_MST_ORGANIZATION 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                    AND LENGTH(ORGANIZATIONCODE) > 6
                                ORDER BY
	                                ORGANIZATIONCODE
                            ",
                                    new CDAParameter("ACCOUNTID", accountId)
                                );
                                string rootId = dt.Rows[0]["id"].ToString();
                                string rootCode = dt.Rows[0]["code"].ToString();
                                string rootText = dt.Rows[0]["text"].ToString();
                                string children = Easyui.TableToEasyUITree(dt, rootCode, 3);
                                string jsonStr = "[{\"id\":\"" + rootId + "\",\"text\":\"" + rootText + "\"" + children + "}]";
                                context.Response.Write(jsonStr);
                            }
                        }
                        break;
                    }
                case "getUser":
                    {
                        //获取用户列表 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                USERID,
	                                USERCODE,
	                                USERNAME 
                                FROM
	                                TP_MST_USER 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                USERCODE
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getMonitor":
                    {
                        //获取班长 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DISTINCT
	                                u.USERCODE,
	                                u.USERNAME 
                                FROM
	                                TP_PC_GROUTINGLINE l
	                                INNER JOIN TP_MST_USER u ON u.USERID = l.MONITORID 
                                WHERE
	                                l.VALUEFLAG = '1' 
                                ORDER BY
	                                u.USERCODE
                            ");

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getStaff":
                    {
                        //获取产品列表 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                STAFFID,
	                                STAFFCODE,
	                                STAFFNAME 
                                FROM
	                                TP_HR_STAFF 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                STAFFCODE
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getLine":
                    {
                        //获取成型线 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                GROUTINGLINEID,
                                    GROUTINGLINENO,
	                                GROUTINGLINECODE,
	                                GROUTINGLINENAME 
                                FROM
	                                TP_PC_GROUTINGLINE 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                GROUTINGLINECODE
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProductionLine":
                    {
                        //获取生产线 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PRODUCTIONLINEID,
	                                PRODUCTIONLINECODE,
	                                PRODUCTIONLINENAME
                                FROM
	                                TP_PC_PRODUCTIONLINE 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                PRODUCTIONLINECODE
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedure":
                    {
                        //获取生产工序 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string filter = context.Request["filter"];
                            string add = "";
                            if (!string.IsNullOrEmpty(filter))
                            {
                                add = " AND ModelType in (" + filter + ") ";
                            }
                            string sql = @"SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' ";
                            sql += add;
                            sql += " ORDER BY PRODUCTIONLINEID,NODENO";
                            DataTable dt = conn.ExecuteDatatable(sql, new CDAParameter("ACCOUNTID", accountId));

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
           case "getProcedure3":
                    {
                        //获取生产工序 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string filter = context.Request["filter"];
                            string add = "";
                            if (!string.IsNullOrEmpty(filter))
                            {
                                add = " AND ModelType in (" + filter + ") ";
                            }
                            string sql = @"SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1'
                                    AND PROCEDURENAME LIKE '%3#%' ";
                            sql += add;
                            sql += " ORDER BY PRODUCTIONLINEID,NODENO";
                            DataTable dt = conn.ExecuteDatatable(sql, new CDAParameter("ACCOUNTID", accountId));

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedureRR":
                    {
                        //获取生产工序 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string sql = @"SELECT
	                                                    * 
                                                    FROM
	                                                    (
	                                                    SELECT
		                                                    PROCEDUREID,
		                                                    PROCEDURECODE,
		                                                    PROCEDURENAME,
		                                                    NODENO 
	                                                    FROM
		                                                    TP_PC_PROCEDURE 
	                                                    WHERE
		                                                    VALUEFLAG = '1' 
                                                         AND ACCOUNTID = @ACCOUNTID@ UNION ALL
	                                                    SELECT
		                                                    99998 AS PROCEDUREID,
		                                                    cast( '99998' AS nvarchar2 ( 20 ) ) AS PROCEDURECODE,
		                                                    cast( '注浆' AS nvarchar2 ( 50 ) ) AS PROCEDURENAME,
		                                                    99998 AS NODENO 
	                                                    FROM
		                                                    DUAL UNION ALL
	                                                    SELECT
		                                                    99999 AS PROCEDUREID,
		                                                    cast( '99999' AS nvarchar2 ( 20 ) ) AS PROCEDURECODE,
		                                                    cast( '注浆撤销' AS nvarchar2 ( 50 ) ) AS PROCEDURENAME,
		                                                    99999 AS NODENO 
	                                                    FROM
		                                                    DUAL UNION ALL
	                                                    SELECT
		                                                    100000 AS PROCEDUREID,
		                                                    cast( '100000' AS nvarchar2 ( 20 ) ) AS PROCEDURECODE,
		                                                    cast( '成坯数' AS nvarchar2 ( 50 ) ) AS PROCEDURENAME,
		                                                    100000 AS NODENO 
	                                                    FROM
		                                                    DUAL 
	                                                    ) T WHERE 1=1
                                                    ORDER BY T.PROCEDUREID,T.NODENO";
                            DataTable dt = conn.ExecuteDatatable(sql, new CDAParameter("ACCOUNTID", accountId));

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedureSemi":
                    {
                        //获取半检工序
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                    AND MODELTYPE = - 3
                                ORDER BY
	                                PRODUCTIONLINEID,NODENO
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedureOut":
                    {
                        //获取出入库工序
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT t.procedureid as PROCEDUREID
                                      --,t.p_type_name as PROCEDURENAME
                                      ,t.procedurename as PROCEDURENAME
                                  FROM tp_pc_procedure t
                                 WHERE t.p_type_2 IN (103, 104)
                                   AND t.valueflag = '1'
                                 ORDER BY t.p_type_1
                                         ,t.p_type_2
                                         ,t.procedurecode
                                         ,t.displayno
                            ");
                            if (context.Request["select"] is object)
                            {
                                //DataRow dr = dt.NewRow();
                                //dr["PROCEDUREID"] = -1;
                                //dr["PROCEDURENAME"] = "产成品交接";
                                //dt.Rows.Add(dr);
                                context.Response.Write(dt.ToJson());
                            }
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedureCheck":
                    {
                        //获取生产工序 质量登记
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                    AND MODELTYPE = - 1
                                ORDER BY
	                                PRODUCTIONLINEID,NODENO
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedureDeliver":
                    {
                        //获取生产工序 成型工序
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                    AND MODELTYPE = 5
                                ORDER BY
	                                PRODUCTIONLINEID,NODENO
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedureDeliverNo":
                    {
                        //获取生产工序 非成型工序 非检验工序 
                        //去掉 修干坯 工序
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                    AND MODELTYPE <> 5
                                    AND MODELTYPE <> -1
                                    AND PROCEDUREID <> 1
                                ORDER BY
	                                PRODUCTIONLINEID,NODENO
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getProcedureAir":
                    {
                        //获取生产工序 堵漏气工序 
                        //堵漏气37，研磨20，直接冷补22，研磨后冷补23
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                    AND MODELTYPE <> 5
                                    AND MODELTYPE <> -1
                                    AND PROCEDUREID IN(20,22,23,37)
                                ORDER BY
	                                PRODUCTIONLINEID,NODENO
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getKiln":
                    {
                        //获取窑炉 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                KILNID,
	                                KILNCODE,
	                                KILNNAME 
                                FROM
	                                TP_MST_KILN 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                KILNCODE
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getBuildingNo":
                    {
                        //获取成型线楼号 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DISTINCT
	                                BUILDINGNO 
                                FROM
	                                TP_PC_GROUTINGLINE 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                BUILDINGNO
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getLogo":
                    {
                        //获取商标 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                LOGOID,
	                                LOGOCODE,
	                                LOGONAME 
                                FROM
	                                TP_MST_LOGO 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                LOGOCODE
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getGlaze":
                    {
                        //获取釉料 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                DICTIONARYID AS GLAZEID,
	                                DICTIONARYVALUE AS GLAZENAME 
                                FROM
	                                TP_MST_DATADICTIONARY 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
	                                AND DICTIONARYTYPE = @dictionarytype@ 
                                ORDER BY
	                                DISPLAYNO
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("dictionarytype", context.Request["dictionarytype"])
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getGoodsmodel":
                    {
                        //获取产品型号 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DISTINCT
	                                GOODSMODEL 
                                FROM
	                                TP_MST_GOODS 
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                GOODSMODEL
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                                );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getRptProcedure":
                    {
                        // 获取报表数据来源
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                            SELECT rp.rptprocedurename
                                  ,rp.rptprocedureid || ',' || rsp.procedureid AS rptprocedureid
                                  ,rp.rptprocedureid AS rptprocedureids
                              FROM tp_mst_rptprocedure rp
                              LEFT JOIN tp_mst_rptsprocedure rsp
                                ON rsp.rptprocedureid = rp.rptprocedureid
                             WHERE rp.valueflag = '1'
                             ORDER BY rp.displayno
                            ");

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                case "getScrapType":
                    {
                        // 获取报表数据来源
                        string data = @"
                            [
                                { 'TYPEID': ' ', 'TYPENAME': '成型损坯' }, 
                                { 'TYPEID': '0', 'TYPENAME': '损坯' }, 
                                { 'TYPEID': '1', 'TYPENAME': '次品' }, 
                                { 'TYPEID': '2', 'TYPENAME': '半检不合格' }, 
                                { 'TYPEID': '3', 'TYPENAME': '复检不合格' }, 
                                { 'TYPEID': 'A', 'TYPENAME': '干补' }, 
                                { 'TYPEID': 'B', 'TYPENAME': '回收' }
                            ]
                        ".Replace("'", "\"");
                        context.Response.Write(data);
                        break;
                    }
                case "getKilnData":
                    {
                        //获取窑炉数据
                        string pValue = context.Request["pValue"].ToString();
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string sql1 = "";
                            List<CDAParameter> sqlPara = new List<CDAParameter>();
                            //根据帐套和标识查询数据
                            if (pValue == "1")
                            {
                                sql1 = "Select KilnID,KilnCode,KilnName,KilnType,Remarks,AccountID,ValueFlag,CreateTime,CreateUserID,UpdateTime,UpdateUserID,OPTimeStam from TP_MST_Kiln where AccountID = @AccountID@";
                            }
                            else if (pValue == "0")
                            {
                                sql1 = "Select KilnID,KilnCode,KilnName,KilnType,Remarks,AccountID,ValueFlag,CreateTime,CreateUserID,UpdateTime,UpdateUserID,OPTimeStamp from TP_MST_Kiln where valueflag = @valueflag@ and AccountID = @AccountID@";
                                sqlPara.Add(new CDAParameter("valueflag", "1", DataType.NVarChar));
                            }
                            sqlPara.Add(new CDAParameter("AccountID", accountId, DataType.Int32));
                            DataTable result = conn.ExecuteDatatable(sql1, sqlPara.ToArray());
                            context.Response.Write(result.ToJson());
                        }
                    }
                    break;
                case "getGMouldType"://成型线类型
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string sql2 = "SELECT GMOULDTYPEID, GMOULDTYPENAME FROM TP_MST_GMOULDTYPE WHERE VALUEFLAG = 1  AND ACCOUNTID = @AccountID@";
                        List<CDAParameter> sqlPara = new List<CDAParameter>();
                        sqlPara.Add(new CDAParameter("AccountID", accountId));
                        DataTable result = conn.ExecuteDatatable(sql2, sqlPara.ToArray());
                        context.Response.Write(result.ToJson());
                    }

                    break;
                case "gMouldStatus"://成型线状态
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string sql3 = "SELECT GMouldStatusID, GMouldStatusName, DisplayNo FROM TP_SYS_GMouldStatus GMS WHERE GMS.LineUsedFlag = '1' ORDER BY GMS.DisplayNo ";
                        DataTable result = conn.ExecuteDatatable(sql3);
                        DataRow dr = result.NewRow();
                        dr["GMouldStatusName"] = "";
                        dr["GMouldStatusID"] = -1;
                        result.Rows.InsertAt(dr, 0);
                        context.Response.Write(result.ToJson());
                    }
                    break;
                case "getThermometer"://温湿计编号
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string sql = @"Select 0 AS Sel, ThermometerID,BuildingNo,FloorNo,LocationCode,ThermometerCode,ManagerName,Remarks,AccountID,ValueFlag,CreateTime,
                               CreateUserID,UpdateTime,UpdateUserID,OPTimeStamp from TP_MST_Thermometer 
                               where (@ThermometerID@ is null or ThermometerID = @ThermometerID@) 
                               and (@AccountID@ is null or AccountID = @AccountID@) 
                               and (@ValueFlag@ is null or ValueFlag = @ValueFlag@ or 2 = @ValueFlag@) 
                               and (@BuildingNo@ is null or BuildingNo = @BuildingNo@) 
                               and (@FloorNo@ is null or FloorNo = @FloorNo@) 
                               and (@LocationCode@ is null or LocationCode = @LocationCode@) 
                               and (@ThermometerCode@ is null or ThermometerCode = @ThermometerCode@) 
                               and (@ManagerName@ is null or ManagerName = @ManagerName@) 
                               and (@Remarks@ is null or Remarks = @Remarks@ ) 
                               and (@SelectUserId@ is null 
                                        or exists (Select PurviewId from TP_MST_UserPurview
                                        where PurviewType=12 and (TP_MST_UserPurview.PurviewID = -1 or TP_MST_UserPurview.PurviewID = TP_MST_Thermometer.ThermometerID) and UserId=@SelectUserId@))
                               Order by ThermometerID desc";
                        List<CDAParameter> sqlPara = new List<CDAParameter>();
                        sqlPara.Add(new CDAParameter("AccountID", accountId, DataType.Int32));
                        sqlPara.Add(new CDAParameter("SelectUserId", int.Parse(context.Session["userid"].ToString()), DataType.Int32));
                        sqlPara.Add(new CDAParameter("ThermometerID", null, DataType.Int32));
                        sqlPara.Add(new CDAParameter("ValueFlag", null, DataType.Int32));
                        sqlPara.Add(new CDAParameter("BuildingNo", null, DataType.NVarChar));
                        sqlPara.Add(new CDAParameter("FloorNo", null, DataType.NVarChar));
                        sqlPara.Add(new CDAParameter("LocationCode", null, DataType.NVarChar));
                        sqlPara.Add(new CDAParameter("ThermometerCode", null, DataType.NVarChar));
                        sqlPara.Add(new CDAParameter("ManagerName", null, DataType.NVarChar));
                        sqlPara.Add(new CDAParameter("Remarks", null, DataType.NVarChar));
                        sqlPara.Add(new CDAParameter("SelectUserId", null, DataType.NVarChar));
                        DataTable result = conn.ExecuteDatatable(sql, sqlPara.ToArray());
                        context.Response.Write(result.ToJson());
                    }
                    break;
                case "getAllScdefectPosition"://缺陷位置
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string sqlString = @"Select DefectPositionID,DefectPositionCode,DefectPositionName,Remarks,AccountID,ValueFlag,CreateTime,CreateUserID,
                           UpdateTime,UpdateUserID,OPTimeStamp,displayno, concat(tp_mst_scdefectposition.DefectPositionCode||'->',tp_mst_scdefectposition.DefectPositionName) as DefectPositionFlagName from tp_mst_scdefectposition where AccountID =@accountID@
                                order by displayno";
                        List<CDAParameter> sqlPara = new List<CDAParameter>();
                        sqlPara.Add(new CDAParameter("accountID", accountId, DataType.Int32));
                        DataTable result = conn.ExecuteDatatable(sqlString, sqlPara.ToArray());
                        context.Response.Write(result.ToJson());
                    }
                    break;
                case "gMouldRecord"://模具状态
                    {
                        DataTable dtGMouldRecordType = new DataTable();
                        dtGMouldRecordType.Columns.Add("GMouldRecordTypeID");
                        dtGMouldRecordType.Columns.Add("GMouldRecordTypeName");

                        DataRow dr = dtGMouldRecordType.NewRow();
                        dr["GMouldRecordTypeID"] = -1;
                        dr["GMouldRecordTypeName"] = "";
                        dtGMouldRecordType.Rows.Add(dr);

                        dr = dtGMouldRecordType.NewRow();
                        dr["GMouldRecordTypeID"] = 0;
                        dr["GMouldRecordTypeName"] = "停用";
                        dtGMouldRecordType.Rows.Add(dr);

                        dr = dtGMouldRecordType.NewRow();
                        dr["GMouldRecordTypeID"] = 1;
                        dr["GMouldRecordTypeName"] = "维修";
                        dtGMouldRecordType.Rows.Add(dr);

                        dr = dtGMouldRecordType.NewRow();
                        dr["GMouldRecordTypeID"] = 3;
                        dr["GMouldRecordTypeName"] = "换模";
                        dtGMouldRecordType.Rows.Add(dr);

                        dr = dtGMouldRecordType.NewRow();
                        dr["GMouldRecordTypeID"] = 5;
                        dr["GMouldRecordTypeName"] = "变产";
                        dtGMouldRecordType.Rows.Add(dr);

                        dr = dtGMouldRecordType.NewRow();
                        dr["GMouldRecordTypeID"] = 6;
                        dr["GMouldRecordTypeName"] = "整线变产";
                        dtGMouldRecordType.Rows.Add(dr);
                        context.Response.Write(dtGMouldRecordType.ToJson());
                    }
                    break;
                case "getAllDefectFine"://缺陷扣罚
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string s1 = "Select DefectFineID,DefectFineCode,Remarks,DisplayNo,ValueFlag,0 as sel from TP_MST_DefectFine where AccountID = @AccountID@ order by displayno";
                        List<CDAParameter> sqlPara = new List<CDAParameter>();
                        sqlPara.Add(new CDAParameter("AccountID", accountId, DataType.Int32));
                        DataTable result = conn.ExecuteDatatable(s1, sqlPara.ToArray());
                        context.Response.Write(result.ToJson());
                    }
                    break;
                case "getDefectData"://杂质缺陷
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string s2 = "";
                        List<CDAParameter> sqlPara = new List<CDAParameter>();
                        if (!string.IsNullOrEmpty(context.Request["pValue"]))
                        {
                            if (context.Request["pValue"] == "1")
                            {
                                s2 = "Select 0 as Sel,TP_MST_Defect.DefectID,TP_MST_Defect.DefectCode,TP_MST_Defect.DefectName,TP_MST_Defect.Remarks,TP_MST_Defect.AccountID,TP_MST_Defect.ValueFlag,TP_MST_Defect.CreateTime,TP_MST_Defect.CreateUserID,TP_MST_Defect.UpdateTime,TP_MST_Defect.UpdateUserID,TP_MST_Defect.OPTimeStamp,TP_MST_Defect.DEFECTTYPEID,TP_MST_DEFECTTYPE.DEFECTTYPENAME from TP_MST_Defect left join TP_MST_DEFECTTYPE on TP_MST_Defect.DEFECTTYPEID=TP_MST_DEFECTTYPE.DEFECTTYPEID where TP_MST_Defect.AccountID = @AccountID@";
                                sqlPara.Add(new CDAParameter("AccountID", accountId, DataType.Int32));

                            }
                            else if (context.Request["pValue"] == "0")
                            {
                                s2 = "Select 0 as Sel,TP_MST_Defect.DefectID,TP_MST_Defect.DefectCode,TP_MST_Defect.DefectName,TP_MST_Defect.Remarks,TP_MST_Defect.AccountID,TP_MST_Defect.ValueFlag,TP_MST_Defect.CreateTime,TP_MST_Defect.CreateUserID,TP_MST_Defect.UpdateTime,TP_MST_Defect.UpdateUserID,TP_MST_Defect.OPTimeStamp,TP_MST_Defect.DEFECTTYPEID,TP_MST_DEFECTTYPE.DEFECTTYPENAME from TP_MST_Defect left join TP_MST_DEFECTTYPE on TP_MST_Defect.DEFECTTYPEID=TP_MST_DEFECTTYPE.DEFECTTYPEID where TP_MST_Defect.valueflag = @valueflag@ and TP_MST_Defect.AccountID = @AccountID@";
                                sqlPara.Add(new CDAParameter("valueflag", 1, DataType.Int32));
                                sqlPara.Add(new CDAParameter("AccountID", accountId, DataType.Int32));

                            }
                            DataTable result = conn.ExecuteDatatable(s2, sqlPara.ToArray());
                            context.Response.Write(result.ToJson());
                        }
                    }
                    break;
                case "getTransfer"://获取工序配置
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string s3 = "SELECT t.ptid AS PTID, t.name AS NAME FROM tp_mst_rpt_transfer t WHERE t.AccountID = @AccountID@ AND t.valueflag = '1' ORDER BY t.displayno desc";
                        List<CDAParameter> sqlPara = new List<CDAParameter>();
                        sqlPara.Add(new CDAParameter("AccountID", accountId, DataType.Int32));
                        DataTable result = conn.ExecuteDatatable(s3, sqlPara.ToArray());
                        context.Response.Write(result.ToJson());
                    }
                    break;
                case "getProcedureModelType"://获取工序类别
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string s3 = "SELECT PROCEDUREMODELTYPEID AS ID, PROCEDUREMODELTYPENAME AS NAME FROM TP_SYS_ProcedureModelType WHERE ProcedureModelTypeID IN ( 1, 2, 3, 4 )";
                        DataTable result = conn.ExecuteDatatable(s3);
                        context.Response.Write(result.ToJson());
                    }
                    break;
                case "getAllDefectType"://获取工序类别
                    using (IDataAccess conn = DataAccess.Create())
                    {
                        string filter = context.Request["valueflag"];
                        string str = "";
                        int i = 0;
                        List<CDAParameter> sqlPara = new List<CDAParameter>();
                        sqlPara.Add(new CDAParameter("AccountID", accountId, DataType.Int32));
                        if (!string.IsNullOrEmpty(filter) && int.TryParse(filter, out i))
                        {
                            str = " AND valueflag=@valueflag@";
                            sqlPara.Add(new CDAParameter("valueflag", filter, DataType.Int32));

                        }
                        string s3 = "Select DefectTypeID,DefectTypeName,Remarks,AccountID,ValueFlag,CreateTime,CreateUserID,UpdateTime,UpdateUserID,OPTimeStamp "
                                    + " ,displayno from TP_MST_DefectType where AccountID = @AccountID@" + str;
                        DataTable result = conn.ExecuteDatatable(s3, sqlPara.ToArray());
                        context.Response.Write(result.ToJson());
                    }
                    break;
                case "getWorkShop"://获取车间号
                    {
                        string jsonStr = "[{\"id\":\"1\",\"text\":\"生产一部\"},{\"id\":\"2\",\"text\":\"生产二部\"},{\"id\":\"3\",\"text\":\"生产三部\"}]";
                        context.Response.Write(jsonStr);
                    }
                    break;
                case "getFQCITEMS"://获取FQC检验项目
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string sql2 = "SELECT ITEMSID,INSPECTTYPE,INSPECTNAME FROM TP_PM_FQCITEMS  WHERE VALUEFLAG=1 and ACCOUNTID=@AccountID@";
                            List<CDAParameter> sqlPara = new List<CDAParameter>();
                            sqlPara.Add(new CDAParameter("AccountID", accountId));
                            DataTable result = conn.ExecuteDatatable(sql2, sqlPara.ToArray());
                            context.Response.Write(result.ToJson());
                        }
                    }
                    break;
                case "getLogoByGoods"://获取商标根据产品
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable result = new DataTable();
                                if (context.Request["goodsid"] is object)
                                {
                                    result = conn.ExecuteDatatable(@"
                                SELECT
                                DISTINCT
                                T.LOGOID ID,
                                T.LOGONAME TEXT
                                FROM(
                                SELECT
	                                G.LOGOID,
	                                TML.LOGONAME 
                                FROM
	                                TP_MST_GOODS G
	                                LEFT JOIN TP_MST_LOGO TML ON G.LOGOID = TML.LOGOID 
                                WHERE
	                                G.GOODSCODE = @GOODSID@ UNION ALL
                                SELECT
	                                GLS.LOGOID,
	                                L.LOGONAME 
                                FROM
	                                TP_MST_GOODSLOGOSAP GLS
	                                INNER JOIN TP_MST_LOGO L ON L.LOGOID = GLS.LOGOID 
                                WHERE
	                                GLS.GOODSCODE = @GOODSID@ 
	                                ) T
                                ",
                                        new CDAParameter("GOODSID", context.Request["goodsid"])
                                    );
                                }
                                else
                                {
                                    result = conn.ExecuteDatatable(@"
                                    SELECT
                                    DISTINCT
                                    T.LOGOID ID,
                                    T.LOGONAME TEXT
                                    FROM(
                                    SELECT
	                                    G.LOGOID,
	                                    TML.LOGONAME 
                                    FROM
	                                    TP_MST_GOODS G
	                                    LEFT JOIN TP_MST_LOGO TML ON G.LOGOID = TML.LOGOID 
                                      UNION ALL
                                    SELECT
	                                    GLS.LOGOID,
	                                    L.LOGONAME 
                                    FROM
	                                    TP_MST_GOODSLOGOSAP GLS
	                                    INNER JOIN TP_MST_LOGO L ON L.LOGOID = GLS.LOGOID  
	                                    ) T
                                    "
                                        );
                                }
                            context.Response.Write(result.ToJson());
                        }
                    }
                    break;
                default:
                    {
                        break;
                    }
            }
        }
        //else
        //{
        //    context.Response.Write(new JsonResult(JsonStatus.loginError).ToJson());
        //}
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}