IMEX.mes.web/wwwroot/mes/sys/jzsetting/jzsetting.ashx

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

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>
/// JZ_SETTING
/// xuwei create 2021-07-13
/// </summary>
public class jzsetting : 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 = false;
                b.btnCopy = true;
                b.btnUpdate = true;
                b.btnDelete = true;
                b.btnCancel = false;
                b.btnSearch = false;
                b.btnDetail = true;
                b.btnCheckbox = true;
                b.btnExport = false;
                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"] is object)
                            context.Response.Write(detail());
                        else
                        {
                            List<xRecord> list = new List<xRecord>();
                            xRecord r = new xRecord();
                            list.Add(r);
                            context.Response.Write(new JsonResult(list).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>
    /// JZ_SETTING 查询
    /// </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.GUID,
                    m.RPTNAME,
                    m.EXECUTETYPE,
                    m.SQLCODE,
                    m.APIURL,
                    m.EXECUTECYC,
                    m.EXECUTEDATE,
                    m.BEGINDATE,
                    m.ENDDATE,
                    m.GUID AS SID
                FROM
                    JZ_SETTING m
                WHERE 
                    1 = 1
            ";
            List<CDAParameter> sqlPara = new List<CDAParameter>();

            if(!string.IsNullOrEmpty(form["GUID"]))
            {
                sqlStr += " AND m.GUID = @GUID@ ";
                sqlPara.Add(new CDAParameter("GUID", form["GUID"]));
            }
            if(!string.IsNullOrEmpty(form["RPTNAME"]))
            {
                sqlStr += " AND INSTR( m.RPTNAME, @RPTNAME@ ) > 0 ";
                sqlPara.Add(new CDAParameter("RPTNAME", form["RPTNAME"]));
            }
            if(!string.IsNullOrEmpty(form["EXECUTETYPE"]))
            {
                sqlStr += " AND INSTR( m.EXECUTETYPE, @EXECUTETYPE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("EXECUTETYPE", form["EXECUTETYPE"]));
            }
            if(!string.IsNullOrEmpty(form["SQLCODE"]))
            {
                sqlStr += " AND INSTR( m.SQLCODE, @SQLCODE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("SQLCODE", form["SQLCODE"]));
            }
            if(!string.IsNullOrEmpty(form["APIURL"]))
            {
                sqlStr += " AND INSTR( m.APIURL, @APIURL@ ) > 0 ";
                sqlPara.Add(new CDAParameter("APIURL", form["APIURL"]));
            }
            if(!string.IsNullOrEmpty(form["EXECUTECYC"]))
            {
                sqlStr += " AND INSTR( m.EXECUTECYC, @EXECUTECYC@ ) > 0 ";
                sqlPara.Add(new CDAParameter("EXECUTECYC", form["EXECUTECYC"]));
            }
            if(!string.IsNullOrEmpty(form["EXECUTEDATE"]))
            {
                sqlStr += " AND INSTR( m.EXECUTEDATE, @EXECUTEDATE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("EXECUTEDATE", form["EXECUTEDATE"]));
            }
            if(!string.IsNullOrEmpty(form["BEGINDATE"]))
            {
                sqlStr += " AND INSTR( m.BEGINDATE, @BEGINDATE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("BEGINDATE", form["BEGINDATE"]));
            }
            if(!string.IsNullOrEmpty(form["ENDDATE"]))
            {
                sqlStr += " AND INSTR( m.ENDDATE, @ENDDATE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("ENDDATE", form["ENDDATE"]));
            }
            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>
    /// 详细 JZ_SETTING
    /// </summary>
    /// <returns>json</returns>
    private string detail()
    {
        using(IDataAccess conn= DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT 
                    m.RPTNAME,
                    m.EXECUTETYPE,
                    m.SQLCODE,
                    m.APIURL,
                    m.EXECUTECYC,
                    m.EXECUTEDATE,
                    m.BEGINDATE,
                    m.ENDDATE,
                    m.GUID
                FROM
                    JZ_SETTING m
                WHERE 
                    m.GUID = @GUID@
                ",
                new CDAParameter("GUID",HttpContext.Current.Request["id"])
            );
            return new JsonResult(dt).ToJson();
        }
    }

    /// <summary>
    /// 插入 JZ_SETTING
    /// </summary>
    /// <returns>json</returns>
    private string insert(NameValueCollection form)
    {
        using(IDataAccess conn= DataAccess.Create())
        {
            //string primaryKey = conn.GetSequenceNextval("SEQ_JZ_SETTING_ID").ToString();
            int result = conn.ExecuteNonQuery(@"
                INSERT INTO JZ_SETTING (
                    RPTNAME,
                    EXECUTETYPE,
                    SQLCODE,
                    APIURL,
                    EXECUTECYC,
                    EXECUTEDATE,
                    BEGINDATE,
                    ENDDATE
                ) VALUES (
                    @RPTNAME@,
                    @EXECUTETYPE@,
                    @SQLCODE@,
                    @APIURL@,
                    @EXECUTECYC@,
                    @EXECUTEDATE@,
                    @BEGINDATE@,
                    @ENDDATE@
                )
                ",
                new CDAParameter("RPTNAME",form["RPTNAME"]),
                new CDAParameter("EXECUTETYPE",form["EXECUTETYPE"]),
                new CDAParameter("SQLCODE",form["SQLCODE"]),
                new CDAParameter("APIURL",form["APIURL"]),
                new CDAParameter("EXECUTECYC",form["EXECUTECYC"]),
                new CDAParameter("EXECUTEDATE",form["EXECUTEDATE"],DataType.DateTime),
                new CDAParameter("BEGINDATE",form["BEGINDATE"],DataType.DateTime),
                new CDAParameter("ENDDATE",form["ENDDATE"],DataType.DateTime)
            );
            return new JsonResult(JsonStatus.success).ToJson();
        }
    }

    /// <summary>
    /// 更新 JZ_SETTING
    /// </summary>
    /// <returns>json</returns>
    private string update(NameValueCollection form)
    {
        using(IDataAccess conn=DataAccess.Create())
        {
            int result = conn.ExecuteNonQuery(@"
                UPDATE JZ_SETTING 
                SET
                    RPTNAME = @RPTNAME@,
                    EXECUTETYPE = @EXECUTETYPE@,
                    SQLCODE = @SQLCODE@,
                    APIURL = @APIURL@,
                    EXECUTECYC = @EXECUTECYC@,
                    EXECUTEDATE = @EXECUTEDATE@,
                    BEGINDATE = @BEGINDATE@,
                    ENDDATE = @ENDDATE@
                WHERE 
                    GUID = @GUID@
                ",
                new CDAParameter("RPTNAME",form["RPTNAME"]),
                new CDAParameter("EXECUTETYPE",form["EXECUTETYPE"]),
                new CDAParameter("SQLCODE",form["SQLCODE"]),
                new CDAParameter("APIURL",form["APIURL"]),
                new CDAParameter("EXECUTECYC",form["EXECUTECYC"]),
                new CDAParameter("EXECUTEDATE",form["EXECUTEDATE"],DataType.DateTime),
                new CDAParameter("BEGINDATE",form["BEGINDATE"],DataType.DateTime),
                new CDAParameter("ENDDATE",form["ENDDATE"],DataType.DateTime),
                new CDAParameter("GUID",HttpContext.Current.Request["id"])
            );
            return new JsonResult(JsonStatus.success).ToJson();
        }
    }

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

    /// <summary>
    /// 导出 JZ_SETTING
    /// </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 RPTNAME { get; set; }
        public string EXECUTETYPE { get; set; }
        public string SQLCODE { get; set; }
        public string APIURL { get; set; }
        public string EXECUTECYC { get; set; }
        public string EXECUTEDATE { get; set; }
        public string BEGINDATE { get; set; }
        public string ENDDATE { get; set; }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}