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

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

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 list : 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 "inspecttype":
                    {
                        //FQC检验类型 xuwei add 2023-09-07
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string sqlStr = @"SELECT T.DICTIONARYID AS ID,T.DICTIONARYVALUE AS TEXT
                                              FROM TP_MST_DATADICTIONARY T
                                              WHERE T.VALUEFLAG = 1
                                                    AND T.DICTIONARYTYPE = 'TPC021'
                                              ORDER BY T.DISPLAYNO";
                            DataTable dt = conn.ExecuteDatatable(sqlStr);
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getStopReason":
                    {
                        //停工原因
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string sqlStr = @"SELECT t.dictionaryid
                                                     ,t.dictionaryvalue
                                                  FROM tp_mst_datadictionary t
                                                 WHERE t.valueflag = 1
                                                   AND t.dictionarytype = 'TPC110'
                                                   and t.accountid = @accountid@
                                                 ORDER BY t.displayno";
                            List<CDAParameter> sqlPara = new List<CDAParameter>();
                            sqlPara.Add(new CDAParameter("accountid", HttpContext.Current.Session["accountId"]));

                            DataTable dt = conn.ExecuteDatatable(sqlStr, sqlPara.ToArray());
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getgoods":
                    {
                        //产品型号
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            string sqlStr = @" SELECT mg.goodsid
                                       ,mg.goodscode
                                       ,mg.MATERIALCODE
                                       ,mg.standardgroutingnum
                                   FROM tp_mst_goods mg
                                  WHERE mg.valueflag = 1
                                    AND mg.accountid = @accountid@ ";
                            List<CDAParameter> sqlPara = new List<CDAParameter>();
                            sqlPara.Add(new CDAParameter("accountid", HttpContext.Current.Session["accountId"]));

                            DataTable dt = conn.ExecuteDatatable(sqlStr, sqlPara.ToArray());
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getMonthplan":
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                MONTHPLANID,
                                    MONTHPLANNAME,
                                    ACCOUNTMONTH,
                                    ACCOUNTMONTH||MONTHPLANNAME AS TEXT
                                FROM
	                                TP_PC_MONTHPLAN
                                    where @PROCEDUREID@ is null or PROCEDUREID = @PROCEDUREID@ 
                                order by CREATETIME DESC
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("PROCEDUREID", context.Request["procedureid"])
                            );
                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getWorkPost":
                    {
                        //获取工作岗位列表 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
                                    WORKPOSTID,
                                    WORKPOSTNAME
                                FROM
	                                TP_PC_WORKPOST
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1'
                                ORDER BY
                                    WORKPOSTID
                            ",
                                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 "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,
                                    g.MATERIALCODE
                                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,
                                    WORKSHOP,
                                    DAY_GROUTING_NUM
                                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 "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 "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)
                                );
                            context.Response.Write(dt.ToJson());

                            //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 "getMateriaPlan":  // 获取领料计划
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT MATERIAPLANID,
                                       MATERIAPLANNAME
                                  FROM TP_PC_MATERIAPLAN
                                 WHERE VALUEFLAG = '1'
                                   AND ACCOUNTID = @ACCOUNTID@
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getMateriaPlanByDate":  // 获取领料计划通过日期
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT MATERIAPLANID,
                                       MATERIAPLANNAME || '[' || DECODE(MATERIARECEIVEFLAG, '0', '未领料', '1', '部分领料', '2', '全部领料', '3','超额领料') || ']' AS MATERIAPLANNAME
                                  FROM TP_PC_MATERIAPLAN
                                 WHERE VALUEFLAG = '1'
                                   AND MATERIARECEIVEFLAG <> '2'
                                   AND ACCOUNTID = @ACCOUNTID@
                                   AND ACCOUNTDATE = @ACCOUNTDATE@
                                 ORDER BY CREATETIME DESC
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("ACCOUNTDATE", Convert.ToDateTime(context.Request["date"]))
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getMateriaReceive":  // 获取物料领料
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT MATERIARECEIVEID,
                                       MATERIARECEIVENAME
                                  FROM TP_PC_MATERIARECEIVE
                                 WHERE VALUEFLAG = '1'
                                   AND ACCOUNTID = @ACCOUNTID@
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getDailyPlan":  // 获取日计划
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DAILYPLANID,
                                       DAILYPLANNAME
                                  FROM TP_PC_DAILYPLAN
                                 WHERE VALUEFLAG = '1'
                                   AND ACCOUNTID = @ACCOUNTID@
                                 order by CREATETIME DESC
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("PROCEDUREID", context.Request["procedureid"])
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getDailyPlanByDate":  // 获取日计划通过日期
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DAILYPLANID,
                                       DAILYPLANNAME || '[' || DECODE(MATERIAPLANLFLAG, '0', '未引用', '已引用') || ']' AS DAILYPLANNAME
                                  FROM TP_PC_DAILYPLAN
                                 WHERE VALUEFLAG = '1'
                                   AND ACCOUNTID = @ACCOUNTID@
                                   AND ACCOUNTDATE = @ACCOUNTDATE@
                                 ORDER BY CREATETIME DESC
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("ACCOUNTDATE", Convert.ToDateTime(context.Request["date"]))
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getMonthPlanToDaily":  // 获取未分解月计划
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT 
                                    m.MONTHPLANID AS VALUE,
                                    m.ACCOUNTMONTH,
                                    m.MONTHPLANNAME,
                                    m.ACCOUNTMONTH || m.MONTHPLANNAME AS TEXT
                                FROM
                                    TP_PC_MONTHPLAN m
                                WHERE 
                                    m.VALUEFLAG = '1'
                                    AND m.ACCOUNTID = @ACCOUNTID@
                                    AND (@PROCEDUREID@ is null or m.PROCEDUREID = @PROCEDUREID@)
                                    AND m.TODAILYFLAG = 0
                                order by m.CREATETIME DESC
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("PROCEDUREID", context.Request["procedureid"])
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getMonthPlanDaily":  // 获取已分解月计划
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT 
                                    m.MONTHPLANID AS VALUE,
                                    m.ACCOUNTMONTH,
                                    m.MONTHPLANNAME,
                                    m.ACCOUNTMONTH || m.MONTHPLANNAME  AS TEXT
                                FROM
                                    TP_PC_MONTHPLAN m
                                WHERE 
                                    m.VALUEFLAG = '1'
                                    AND m.ACCOUNTID = @ACCOUNTID@
                                    AND (@PROCEDUREID@ is null or m.PROCEDUREID = @PROCEDUREID@)
                                    AND m.TODAILYFLAG = 1
                                order by m.CREATETIME DESC
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("PROCEDUREID", context.Request["procedureid"])
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getPlanProcedure":  // 获取月计划生产工序
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                    AND PROCEDUREID IN (107,104)
                            ",
                                new CDAParameter("ACCOUNTID", accountId)
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getSopType":  // 获取生产作业书类别
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                select 1 type ,'成检交接' typename from dual
                                union all
                                select 2 type ,'试水' typename from dual
                                union all
                                select 3 type ,'包装' typename from dual
                                union all
                                select 4 type ,'组装' typename from dual
                            "
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getSopGoodsType":  // 获取生产作业书产品类型
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                select 1 type ,'智能' typename from dual
                                union all
                                select 2 type ,'连体' typename from dual
                            "
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getDailyPlanNoMateriare":  // 获取未生成物料计划的日计划
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DAILYPLANID,
                                       DAILYPLANNAME
                                  FROM TP_PC_DAILYPLAN
                                 WHERE VALUEFLAG = '1'
                                   AND MATERIAPLANLFLAG = '0'
                                   AND ACCOUNTID = @ACCOUNTID@
                                   AND (@PROCEDUREID@ is null or PROCEDUREID = @PROCEDUREID@)
                                 order by CREATETIME DESC
                            ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("PROCEDUREID", context.Request["procedureid"])
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                case "getDataDictionary":  // 获取设备数据字典
                    {
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DICTIONARYID,
                                       DICTIONARYNAME
                                  FROM TP_EM_DATADICTIONARY
                                 WHERE VALUEFLAG = '1'
                                   AND ACCOUNTID = 1
                                   AND DICTIONARYTYPE = @DICTIONARYTYPE@
                                 ORDER BY DISPLAYNO ",
                                new CDAParameter("ACCOUNTID", accountId),
                                new CDAParameter("DICTIONARYTYPE", context.Request["dictionarytype"])
                            );

                            context.Response.Write(dt.ToJson());
                        }
                        break;
                    }
                default:
                    {
                        break;
                    }
            }
        }
        //else
        //{
        //    context.Response.Write(new JsonResult(JsonStatus.loginError).ToJson());
        //}
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}