IMEX.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 "getGoodsType":
                    {
                        //获取产品类别 全部
                        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);
                            string 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())
                        {
                            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 "getUserU":
                    {
                        //获取用户列表 工号以U开头
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                USERID,
	                                USERCODE,
	                                USERNAME 
                                FROM
	                                TP_MST_USER 
                                WHERE
                                    USERCODE LIKE 'U%'
                                    AND 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 "getUserStaff":
                    {
                        //获取用户列表 质检部 档案姓名
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                U.STAFFID AS USERID,
	                                U.STAFFCODE AS USERCODE,
	                                U.STAFFNAME AS USERNAME
                                FROM
	                                TP_HR_STAFF U 
                                WHERE
	                                U.ORGANIZATIONID IN (17, 33, 34 )
                                    AND ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '1' 
                                ORDER BY
	                                U.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 "getUserStaffLoop":
                    {
                        //获取用户列表 循环线 档案姓名
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT DISTINCT
	                                H.STAFFNAME AS STAFFNAME
                                FROM
	                                TP_PC_PROCEDUREUSER P
	                                INNER JOIN TP_MST_USERSTAFF S ON S.USERID = P.USERID
	                                INNER JOIN TP_HR_STAFF H ON H.STAFFID = S.STAFFID 
                                WHERE
	                                PROCEDUREID IN ( 16, 33 )
                            "
                                );

                            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())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                PROCEDUREID,
	                                PROCEDURECODE,
	                                PROCEDURENAME
                                FROM
	                                TP_PC_PROCEDURE
                                WHERE
                                    ACCOUNTID = @ACCOUNTID@ 
	                                AND VALUEFLAG = '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 "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 and PROCEDUREID!=55
                                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 "getProcedureCheckNew":
                    {
                         // 250529 
                        //获取生产工序 质量登记 AA
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT *
                                FROM (SELECT PROCEDUREID
                                      ,to_char(PROCEDURECODE) PROCEDURECODE
                                      ,to_char(PROCEDURENAME) PROCEDURENAME
                                  FROM tp_pc_procedure
                                 WHERE accountid =  @ACCOUNTID@
                                   AND valueflag = '1'
                                   AND modeltype = -1
                                   and PROCEDUREID!=55
                                UNION ALL
                                SELECT 888
                                      ,'888'
                                      ,'本烧AA'
                                  FROM dual
                                UNION ALL
                                SELECT 999
                                      ,'999'
                                      ,'重烧AA'
                                  FROM dual)
                            ",
                                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 "getHolidayYear":
                    {
                        //获取成型线楼号 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT 
                                    LEVEL + 2000 as HOLIDAYYEAR
                                FROM 
                                    DUAL
                                CONNECT BY 
                                    LEVEL <= 100;
                            " );

                           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 = 'TPC002' 
                                ORDER BY
	                                DISPLAYNO
                            ",
                                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 "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 "getJobs":
                    {
                        //获取产品型号 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT
	                                DISTINCT 
	                                j.JOBSID,
	                                j.JOBSCODE,
	                                j.JOBSNAME
                                FROM
	                                TP_MST_USER u
	                                LEFT JOIN TP_MST_USERJOBS uj ON uj.USERID = u.USERID
	                                LEFT JOIN TP_MST_JOBS j ON j.JOBSID = uj.JOBSID
                                WHERE
	                                u.USERCODE LIKE 'U%'
                            ",
                                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 "getDefectGroupName":
                    {
                        //获取每窑  全部 
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT dg.defectgrouptype AS tno
                                      ,dg.defectgroupid AS dno
                                      ,to_char(dg.defectgroupname) || '_' || to_char(d.defectname) AS DEFECTGROUPNAME
                                  FROM tp_mst_defectgroup dg
                                  LEFT JOIN tp_mst_defect d
                                    ON dg.defectid = d.defectid
                                 WHERE dg.defectgrouptype LIKE '每窑%' and  dg.valueflag = '1' AND dg.defectgrouptype != '每窑4' AND dg.accountid = @ACCOUNTID@
                                UNION

                                SELECT dg.defectgrouptype AS tno
                                      ,9999 AS dno
                                      ,to_char(dg.defectgroupname) || '_合计' AS DEFECTGROUPNAME
                                  FROM (SELECT *
                                          FROM tp_mst_defectgroup
                                         WHERE defectgrouptype LIKE '每窑%'  and  valueflag = '1' AND  defectgrouptype != '每窑4' AND  accountid = @ACCOUNTID@) dg
                                 GROUP BY dg.defectgrouptype
                                         ,dg.defectgroupname
                                 ORDER BY tno
                                         ,dno

                            ",
                                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 "getgoodsleve":
                    {
                        //获取产品型号 全部
                        using (IDataAccess conn = DataAccess.Create())
                        {
                            DataTable dt = conn.ExecuteDatatable(@"
                                SELECT GOODSLEVELID,GOODSLEVELNAME FROM TP_MST_GOODSLEVEL WHERE isfinishedex=1 and valueflag=1 AND accountid = @ACCOUNTID@
                            "  , new CDAParameter("ACCOUNTID", accountId) );

                            if (context.Request["select"] is object)
                                context.Response.Write(dt.ToJson());
                            else
                                context.Response.Write(new JsonResult(dt).ToJson());
                        }
                        break;
                    }
                default:
                    {
                        break;
                    }
            }
        }
        //else
        //{
        //    context.Response.Write(new JsonResult(JsonStatus.loginError).ToJson());
        //}
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}