IMEX.mes.web/wwwroot/mes/mst/defectgroup/defectgroup.ashx

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

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

/// <summary>
/// TP_MST_DEFECTGROUP
/// xuwei create 2020-04-28
/// </summary>
public class defectgroup : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";

        if (mes.LoginCheck() && context.Request["m"] is object)
        {
            Button b = new Button();
            if(mes.RightCheck("系统管理"))
            {
                b.btnIndex = true;
                b.btnInsert = true;
                b.btnInsertBatch = true;
                b.btnCopy = true;
                b.btnUpdate = true;
                b.btnDelete = true;
                b.btnCancel = true;
                b.btnSearch = true;
                b.btnDetail = true;
                b.btnCheckbox = true;
                b.btnExport = true;
                b.btnReload = true;
            };
            switch (context.Request["m"].ToString().ToLower())
            {
                case "b":
                    {
                        //按钮
                        context.Response.Write(new JsonResult(b).ToJson());
                        break;
                    }
                case "a":
                    {
                        //添加
                        if (b.btnDetail && context.Request["id"]  != null)
                            context.Response.Write(detail());
                        else
                        {
                            xRecord r = new xRecord();
                            context.Response.Write(new JsonResult(r).ToJson());
                        }
                        break;
                    }
                case "s":
                    {
                        //搜索
                        if (b.btnIndex)
                            context.Response.Write(search(context.Request.Form));
                        else
                            context.Response.Write(new JsonResult(JsonStatus.rightError).ToJson());
                        break;
                    }
                case "t":
                    {
                        //详细
                        if (b.btnDetail)
                            context.Response.Write(detail());
                        else
                            context.Response.Write(new JsonResult(JsonStatus.rightError).ToJson());
                        break;
                    }
                case "i":
                    {
                        //插入
                        if (b.btnInsert)
                            context.Response.Write(insert(context.Request.Form));
                        else
                            context.Response.Write(new JsonResult(JsonStatus.rightError).ToJson());
                        break;
                    }
                case "u":
                    {
                        //修改
                        if (b.btnUpdate)
                            context.Response.Write(update(context.Request.Form));
                        else
                            context.Response.Write(new JsonResult(JsonStatus.rightError).ToJson());
                        break;
                    }
                case "d":
                    {
                        //删除
                        if (b.btnDelete)
                            context.Response.Write(delete());
                        else
                            context.Response.Write(new JsonResult(JsonStatus.rightError).ToJson());
                        break;
                    }
                case "e":
                    {
                        //导出
                        if (b.btnExport)
                        {
                            context.Response.Write(export());
                        }
                        else
                        {
                            context.Response.Write(new JsonResult(JsonStatus.rightError).ToJson());
                        }
                        break;
                    }
                default:
                    {
                        break;
                    }
            }
        }
        else
        {
            context.Response.Write(new JsonResult(JsonStatus.loginError).ToJson());
        }
    }

    /// <summary>
    /// TP_MST_DEFECTGROUP 查询
    /// </summary>
    /// <returns>json</returns>
    private string search(NameValueCollection form)
    {
        using(IDataAccess conn=DataAccess.Create())
        {
            int page = HttpContext.Current.Request["page"] is object ? Convert.ToInt32(HttpContext.Current.Request["page"]) : 1;
            int rows = HttpContext.Current.Request["rows"] is object ? Convert.ToInt32(HttpContext.Current.Request["rows"]) : 10;
            string sort = HttpContext.Current.Request["sort"] is object ? HttpContext.Current.Request["sort"] : "";
            string order = HttpContext.Current.Request["order"] is object ? HttpContext.Current.Request["order"] : "";

            string sqlStr = @"
                SELECT 
                    m.DEFECTGROUPID AS SID,
                    m.DEFECTGROUPID,
                    m.DEFECTGROUPTYPE,
                    m.DEFECTGROUPNAME,
                    m.DEFECTID,
                    d.DEFECTNAME,
                    m.PROCEDUREID1,
                    p1.PROCEDURENAME AS PROCEDURENAME1,
                    m.PROCEDUREID2,
                    p2.PROCEDURENAME AS PROCEDURENAME2,
                    --m.PROCEDUREID3,
                    --p3.PROCEDURENAME AS PROCEDURENAME3,
                    --m.PROCEDUREID4,
                    --p4.PROCEDURENAME AS PROCEDURENAME4,
                    --m.PROCEDUREID5,
                    --p5.PROCEDURENAME AS PROCEDURENAME5,
                    --m.PROCEDUREID6,
                    --p6.PROCEDURENAME AS PROCEDURENAME6,
                    m.VALUEFLAG,
                    m.ACCOUNTID,
                    m.CREATEUSERID,
                    m.CREATETIME,
                    m.UPDATEUSERID,
                    m.UPDATETIME
                FROM
                    TP_MST_DEFECTGROUP m
                    LEFT JOIN TP_MST_DEFECT d ON m.DEFECTID = d.DEFECTID
                    LEFT JOIN TP_PC_PROCEDURE p1 ON p1.PROCEDUREID = m.PROCEDUREID1
                    LEFT JOIN TP_PC_PROCEDURE p2 ON p2.PROCEDUREID = m.PROCEDUREID2
                    --LEFT JOIN TP_PC_PROCEDURE p3 ON p3.PROCEDUREID = m.PROCEDUREID3
                    --LEFT JOIN TP_PC_PROCEDURE p4 ON p4.PROCEDUREID = m.PROCEDUREID4
                    --LEFT JOIN TP_PC_PROCEDURE p5 ON p5.PROCEDUREID = m.PROCEDUREID5
                    --LEFT JOIN TP_PC_PROCEDURE p6 ON p6.PROCEDUREID = m.PROCEDUREID6
                WHERE 
                    m.VALUEFLAG = '1'
                    AND m.ACCOUNTID = @ACCOUNTID@
            ";
            List<CDAParameter> sqlPara = new List<CDAParameter>();
            sqlPara.Add(new CDAParameter("ACCOUNTID", HttpContext.Current.Session["accountId"]));

            if(!string.IsNullOrEmpty(form["DEFECTGROUPID"]))
            {
                sqlStr += " AND m.DEFECTGROUPID = @DEFECTGROUPID@ ";
                sqlPara.Add(new CDAParameter("DEFECTGROUPID", form["DEFECTGROUPID"]));
            }
            if(!string.IsNullOrEmpty(form["DEFECTGROUPTYPE"]))
            {
                sqlStr += " AND INSTR( m.DEFECTGROUPTYPE, @DEFECTGROUPTYPE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("DEFECTGROUPTYPE", form["DEFECTGROUPTYPE"]));
            }
            if(!string.IsNullOrEmpty(form["DEFECTGROUPNAME"]))
            {
                sqlStr += " AND INSTR( m.DEFECTGROUPNAME, @DEFECTGROUPNAME@ ) > 0 ";
                sqlPara.Add(new CDAParameter("DEFECTGROUPNAME", form["DEFECTGROUPNAME"]));
            }
            if(!string.IsNullOrEmpty(form["DEFECTID"]))
            {
                sqlStr += " AND INSTR( m.DEFECTID, @DEFECTID@ ) > 0 ";
                sqlPara.Add(new CDAParameter("DEFECTID", form["DEFECTID"]));
            }
            if(!string.IsNullOrEmpty(form["PROCEDUREID1"]))
            {
                sqlStr += " AND INSTR( m.PROCEDUREID1, @PROCEDUREID1@ ) > 0 ";
                sqlPara.Add(new CDAParameter("PROCEDUREID1", form["PROCEDUREID1"]));
            }
            if(!string.IsNullOrEmpty(form["PROCEDUREID2"]))
            {
                sqlStr += " AND INSTR( m.PROCEDUREID2, @PROCEDUREID2@ ) > 0 ";
                sqlPara.Add(new CDAParameter("PROCEDUREID2", form["PROCEDUREID2"]));
            }
            if(!string.IsNullOrEmpty(form["PROCEDUREID3"]))
            {
                sqlStr += " AND INSTR( m.PROCEDUREID3, @PROCEDUREID3@ ) > 0 ";
                sqlPara.Add(new CDAParameter("PROCEDUREID3", form["PROCEDUREID3"]));
            }
            if(sort != "")
            {
                sqlStr += " ORDER BY " + sort + " " + order;
            }
            int total = 0;
            DataTable dt = conn.SelectPages(page, rows,out total, sqlStr, sqlPara.ToArray());
            return new JsonResult(dt) { total = total}.ToJson();
        }
    }

    /// <summary>
    /// 详细 TP_MST_DEFECTGROUP
    /// </summary>
    /// <returns>json</returns>
    private string detail()
    {
        using(IDataAccess conn= DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT 
                    m.DEFECTGROUPID,
                    m.DEFECTGROUPTYPE,
                    m.DEFECTGROUPNAME,
                    m.DEFECTID,
                    d.DEFECTNAME,
                    m.PROCEDUREID1,
                    p1.PROCEDURENAME AS PROCEDURENAME1,
                    m.PROCEDUREID2,
                    p2.PROCEDURENAME AS PROCEDURENAME2,
                    m.PROCEDUREID3,
                    --p3.PROCEDURENAME AS PROCEDURENAME3,
                    --m.PROCEDUREID4,
                    --p4.PROCEDURENAME AS PROCEDURENAME4,
                    --m.PROCEDUREID5,
                    --p5.PROCEDURENAME AS PROCEDURENAME5,
                    --m.PROCEDUREID6,
                    --p6.PROCEDURENAME AS PROCEDURENAME6,
                    m.VALUEFLAG,
                    m.ACCOUNTID,
                    m.CREATEUSERID,
                    m.CREATETIME,
                    m.UPDATEUSERID,
                    m.UPDATETIME
                FROM
                    TP_MST_DEFECTGROUP m
                    LEFT JOIN TP_MST_DEFECT d ON m.DEFECTID = d.DEFECTID
                    LEFT JOIN TP_PC_PROCEDURE p1 ON p1.PROCEDUREID = m.PROCEDUREID1
                    LEFT JOIN TP_PC_PROCEDURE p2 ON p2.PROCEDUREID = m.PROCEDUREID2
                    --LEFT JOIN TP_PC_PROCEDURE p3 ON p3.PROCEDUREID = m.PROCEDUREID3
                    --LEFT JOIN TP_PC_PROCEDURE p4 ON p4.PROCEDUREID = m.PROCEDUREID4
                    --LEFT JOIN TP_PC_PROCEDURE p5 ON p5.PROCEDUREID = m.PROCEDUREID5
                    --LEFT JOIN TP_PC_PROCEDURE p6 ON p6.PROCEDUREID = m.PROCEDUREID6
                WHERE 
                    m.VALUEFLAG = '1'
                    AND m.ACCOUNTID = @ACCOUNTID@
                    AND m.DEFECTGROUPID = @DEFECTGROUPID@
                ",
                new CDAParameter("ACCOUNTID",HttpContext.Current.Session["accountId"]),
                new CDAParameter("DEFECTGROUPID",HttpContext.Current.Request["id"])
            );
            return new JsonResult(dt).ToJson();
        }
    }

    /// <summary>
    /// 插入 TP_MST_DEFECTGROUP
    /// </summary>
    /// <returns>json</returns>
    private string insert(NameValueCollection form)
    {
        using(IDataAccess conn= DataAccess.Create())
        {
            //string primaryKey = conn.GetSequenceNextval("SEQ_TP_MST_DEFECTGROUP").ToString();
            int result = conn.ExecuteNonQuery(@"
                INSERT INTO TP_MST_DEFECTGROUP (
                    --DEFECTGROUPID,
                    DEFECTGROUPTYPE,
                    DEFECTGROUPNAME,
                    DEFECTID,
                    PROCEDUREID1,
                    PROCEDUREID2,
                    --PROCEDUREID3,
                    --PROCEDUREID4,
                    --PROCEDUREID5,
                    --PROCEDUREID6,
                    ACCOUNTID,CREATEUSERID,UPDATEUSERID
                ) VALUES (
                    --@DEFECTGROUPID@,
                    @DEFECTGROUPTYPE@,
                    @DEFECTGROUPNAME@,
                    @DEFECTID@,
                    @PROCEDUREID1@,
                    @PROCEDUREID2@,
                    --@PROCEDUREID3@,
                    --@PROCEDUREID4@,
                    --@PROCEDUREID5@,
                    --@PROCEDUREID6@,
                    @ACCOUNTID@,@CREATEUSERID@,@UPDATEUSERID@
                )
                ",
                //new CDAParameter("DEFECTGROUPID",primaryKey),
                new CDAParameter("DEFECTGROUPTYPE",form["DEFECTGROUPTYPE"]),
                new CDAParameter("DEFECTGROUPNAME",form["DEFECTGROUPNAME"]),
                new CDAParameter("DEFECTID",form["DEFECTID"]),
                new CDAParameter("PROCEDUREID1",form["PROCEDUREID1"]),
                new CDAParameter("PROCEDUREID2",form["PROCEDUREID2"]),
                //new CDAParameter("PROCEDUREID3",form["PROCEDUREID3"]),
                //new CDAParameter("PROCEDUREID4",form["PROCEDUREID3"]),
                //new CDAParameter("PROCEDUREID5",form["PROCEDUREID3"]),
                //new CDAParameter("PROCEDUREID6",form["PROCEDUREID3"]),
                new CDAParameter("ACCOUNTID",HttpContext.Current.Session["accountId"]),
                new CDAParameter("CREATEUSERID",HttpContext.Current.Session["userId"]),
                new CDAParameter("UPDATEUSERID",HttpContext.Current.Session["userId"])
            );
            return new JsonResult(JsonStatus.success).ToJson();
        }
    }

    /// <summary>
    /// 更新 TP_MST_DEFECTGROUP
    /// </summary>
    /// <returns>json</returns>
    private string update(NameValueCollection form)
    {
        using(IDataAccess conn=DataAccess.Create())
        {
            int result = conn.ExecuteNonQuery(@"
                UPDATE TP_MST_DEFECTGROUP 
                SET
                    DEFECTGROUPTYPE = @DEFECTGROUPTYPE@,
                    DEFECTGROUPNAME = @DEFECTGROUPNAME@,
                    DEFECTID = @DEFECTID@,
                    PROCEDUREID1 = @PROCEDUREID1@,
                    PROCEDUREID2 = @PROCEDUREID2@,
                    --PROCEDUREID3 = @PROCEDUREID3@,
                    --PROCEDUREID4 = @PROCEDUREID4@,
                    --PROCEDUREID5 = @PROCEDUREID5@,
                    --PROCEDUREID6 = @PROCEDUREID6@,
                    UPDATEUSERID = @UPDATEUSERID@,
                    UPDATETIME = sysdate
                WHERE 
                    DEFECTGROUPID = @DEFECTGROUPID@
                ",
                new CDAParameter("DEFECTGROUPTYPE",form["DEFECTGROUPTYPE"]),
                new CDAParameter("DEFECTGROUPNAME",form["DEFECTGROUPNAME"]),
                new CDAParameter("DEFECTID",form["DEFECTID"]),
                new CDAParameter("PROCEDUREID1",form["PROCEDUREID1"]),
                new CDAParameter("PROCEDUREID2",form["PROCEDUREID2"]),
                //new CDAParameter("PROCEDUREID3",form["PROCEDUREID3"]),
                //new CDAParameter("PROCEDUREID4",form["PROCEDUREID3"]),
                //new CDAParameter("PROCEDUREID5",form["PROCEDUREID3"]),
                //new CDAParameter("PROCEDUREID6",form["PROCEDUREID3"]),
                new CDAParameter("UPDATEUSERID",HttpContext.Current.Session["userId"]),
                new CDAParameter("DEFECTGROUPID",HttpContext.Current.Request["id"])
            );
            return new JsonResult(JsonStatus.success).ToJson();
        }
    }

    /// <summary>
    /// 删除 TP_MST_DEFECTGROUP
    /// </summary>
    /// <returns>json</returns>
    private string delete()
    {
        using(IDataAccess conn= DataAccess.Create())
        {
            if (HttpContext.Current.Request["id"] is object)
            {
                int result = conn.ExecuteNonQuery(@"
                    DELETE 
                        TP_MST_DEFECTGROUP 
                    WHERE 
                        INSTR(',' || @DEFECTGROUPID@ || ',' , ',' || DEFECTGROUPID || ',') > 0 
                    ",
                    new CDAParameter("DEFECTGROUPID", HttpContext.Current.Request["id"])
                );
                return new JsonResult(JsonStatus.success).ToJson();
            }
            else
            {
                return new JsonResult(JsonStatus.otherError).ToJson();
            }
        }
    }

    /// <summary>
    /// 导出 TP_MST_DEFECTGROUP
    /// </summary>
    /// <returns>json</returns>
    private string export()
    {
        return search(new NameValueCollection());
    }

    private class Button
    {
        public bool btnIndex = false;
        public bool btnInsert = false;
        public bool btnInsertBatch = false;
        public bool btnCopy = false;
        public bool btnUpdate = false;
        public bool btnDelete = false;
        public bool btnCancel = false;
        public bool btnSearch = false;
        public bool btnDetail = false;
        public bool btnCheckbox = false;
        public bool btnExport = false;
        public bool btnReload = false;
    }

    private class xRecord
    {
        public string sid { get; set; }
        public string DEFECTGROUPTYPE { get; set; }
        public string DEFECTGROUPNAME { get; set; }
        public string DEFECTID { get; set; }
        public string PROCEDUREID1 { get; set; }
        public string PROCEDUREID2 { get; set; }
        public string PROCEDUREID3 { get; set; }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}