HEGII.ss.mes.web/wwwroot/mes/mst/user/user.ashx

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

using System;
using System.Web;
using System.Web.Security;
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_USER
/// xuwei create 2020-01-13
/// </summary>
public class user : 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.btnRight = 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
                        {
                            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_USER 查询
    /// </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"] + ",USERID" : "ORGANIZATIONCODE,POSTCODE,USERID";
            string order = HttpContext.Current.Request["order"] is object ? HttpContext.Current.Request["order"] : "";

            string sqlStr = @"
                SELECT 
                    m.USERID AS SID,
                    m.USERID,
                    m.USERCODE,
                    m.USERNAME,
                    m.PASSWORD,
                    m.ORGANIZATIONID,
                    o.ORGANIZATIONCODE,
                    o.ORGANIZATIONNAME,
                    o.ORGANIZATIONFULLNAME,
                    m.LIMITMAC,
                    m.CANSMARTLOGIN,
                    m.ISWORKER,
                    m.REMARKS,
                    m.ACCOUNTCODE,
                    m.LIMITSTARTTIME,
                    m.LIMITENDTIME,
                    m.CANPCLOGIN,
                    m.ISPUBLICBODY,
                    m.CANLOGINPRD,
                    m.CANLOGINMBC,
                    m.POST,
                    p.POSTCODE,
                    p.POSTNAME,
                    m.BARCODEPRINTERID,
                    m.ISGROUTINGWORKER,
                    m.PLCID,
                    m.VALUEFLAG,
                    m.ACCOUNTID,
                    m.CREATEUSERID,
                    m.CREATETIME,
                    m.UPDATEUSERID,
                    m.UPDATETIME,
                    m.AD_USER_CODE
                FROM
                    TP_MST_USER m
                    LEFT JOIN TP_MST_ORGANIZATION o ON o.ORGANIZATIONID = m.ORGANIZATIONID 
                    LEFT JOIN TP_MST_POST p ON p.POSTID = m.POST 
                WHERE 
                    m.VALUEFLAG = '1'
                    AND m.ACCOUNTID = @ACCOUNTID@
            ";
            List<CDAParameter> sqlPara = new List<CDAParameter>();
            sqlPara.Add(new CDAParameter("ACCOUNTID", HttpContext.Current.Session["accountId"].ToString()));

            if(!string.IsNullOrEmpty(form["USERID"]))
            {
                sqlStr += " AND m.USERID = @USERID@ ";
                sqlPara.Add(new CDAParameter("USERID", form["USERID"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["USERCODE"]))
            {
                sqlStr += " AND INSTR( m.USERCODE, @USERCODE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("USERCODE", form["USERCODE"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["USERNAME"]))
            {
                sqlStr += " AND INSTR( m.USERNAME, @USERNAME@ ) > 0 ";
                sqlPara.Add(new CDAParameter("USERNAME", form["USERNAME"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["PASSWORD"]))
            {
                sqlStr += " AND INSTR( m.PASSWORD, @PASSWORD@ ) > 0 ";
                sqlPara.Add(new CDAParameter("PASSWORD", form["PASSWORD"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["ORGANIZATIONID"]))
            {
                sqlStr += " AND INSTR( m.ORGANIZATIONID, @ORGANIZATIONID@ ) > 0 ";
                sqlPara.Add(new CDAParameter("ORGANIZATIONID", form["ORGANIZATIONID"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["LIMITMAC"]))
            {
                sqlStr += " AND INSTR( m.LIMITMAC, @LIMITMAC@ ) > 0 ";
                sqlPara.Add(new CDAParameter("LIMITMAC", form["LIMITMAC"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["CANSMARTLOGIN"]))
            {
                sqlStr += " AND INSTR( m.CANSMARTLOGIN, @CANSMARTLOGIN@ ) > 0 ";
                sqlPara.Add(new CDAParameter("CANSMARTLOGIN", form["CANSMARTLOGIN"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["ISWORKER"]))
            {
                sqlStr += " AND INSTR( m.ISWORKER, @ISWORKER@ ) > 0 ";
                sqlPara.Add(new CDAParameter("ISWORKER", form["ISWORKER"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["REMARKS"]))
            {
                sqlStr += " AND INSTR( m.REMARKS, @REMARKS@ ) > 0 ";
                sqlPara.Add(new CDAParameter("REMARKS", form["REMARKS"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["ACCOUNTCODE"]))
            {
                sqlStr += " AND INSTR( m.ACCOUNTCODE, @ACCOUNTCODE@ ) > 0 ";
                sqlPara.Add(new CDAParameter("ACCOUNTCODE", form["ACCOUNTCODE"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["LIMITSTARTTIME"]))
            {
                sqlStr += " AND INSTR( m.LIMITSTARTTIME, @LIMITSTARTTIME@ ) > 0 ";
                sqlPara.Add(new CDAParameter("LIMITSTARTTIME", form["LIMITSTARTTIME"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["LIMITENDTIME"]))
            {
                sqlStr += " AND INSTR( m.LIMITENDTIME, @LIMITENDTIME@ ) > 0 ";
                sqlPara.Add(new CDAParameter("LIMITENDTIME", form["LIMITENDTIME"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["CANPCLOGIN"]))
            {
                sqlStr += " AND INSTR( m.CANPCLOGIN, @CANPCLOGIN@ ) > 0 ";
                sqlPara.Add(new CDAParameter("CANPCLOGIN", form["CANPCLOGIN"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["ISPUBLICBODY"]))
            {
                sqlStr += " AND INSTR( m.ISPUBLICBODY, @ISPUBLICBODY@ ) > 0 ";
                sqlPara.Add(new CDAParameter("ISPUBLICBODY", form["ISPUBLICBODY"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["CANLOGINPRD"]))
            {
                sqlStr += " AND INSTR( m.CANLOGINPRD, @CANLOGINPRD@ ) > 0 ";
                sqlPara.Add(new CDAParameter("CANLOGINPRD", form["CANLOGINPRD"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["CANLOGINMBC"]))
            {
                sqlStr += " AND INSTR( m.CANLOGINMBC, @CANLOGINMBC@ ) > 0 ";
                sqlPara.Add(new CDAParameter("CANLOGINMBC", form["CANLOGINMBC"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["POST"]))
            {
                sqlStr += " AND INSTR( m.POST, @POST@ ) > 0 ";
                sqlPara.Add(new CDAParameter("POST", form["POST"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["BARCODEPRINTERID"]))
            {
                sqlStr += " AND INSTR( m.BARCODEPRINTERID, @BARCODEPRINTERID@ ) > 0 ";
                sqlPara.Add(new CDAParameter("BARCODEPRINTERID", form["BARCODEPRINTERID"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["ISGROUTINGWORKER"]))
            {
                sqlStr += " AND INSTR( m.ISGROUTINGWORKER, @ISGROUTINGWORKER@ ) > 0 ";
                sqlPara.Add(new CDAParameter("ISGROUTINGWORKER", form["ISGROUTINGWORKER"].ToString()));
            }
            if(!string.IsNullOrEmpty(form["PLCID"]))
            {
                sqlStr += " AND INSTR( m.PLCID, @PLCID@ ) > 0 ";
                sqlPara.Add(new CDAParameter("PLCID", form["PLCID"].ToString()));
            }
            if(sort != "")
            {
                sqlStr += " ORDER BY " + sort + " " + order;
            }
            int total = 0;
            //测试使用
            //string pageSql = conn.GetSelectPagesSql(page, rows, sqlStr);
            DataTable dt = conn.SelectPages(page, rows,out total, sqlStr, sqlPara.ToArray());
            return new JsonResult(dt) { total = total}.ToJson();
        }
    }

    /// <summary>
    /// 详细 TP_MST_USER
    /// </summary>
    /// <returns>json</returns>
    private string detail()
    {
        using(IDataAccess conn= DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT 
                    m.USERID,
                    m.USERCODE,
                    m.USERNAME,
                    m.PASSWORD,
                    m.ORGANIZATIONID,
                    m.LIMITMAC,
                    m.CANSMARTLOGIN,
                    m.ISWORKER,
                    m.REMARKS,
                    m.ACCOUNTCODE,
                    m.LIMITSTARTTIME,
                    m.LIMITENDTIME,
                    m.CANPCLOGIN,
                    m.ISPUBLICBODY,
                    m.CANLOGINPRD,
                    m.CANLOGINMBC,
                    m.POST,
                    m.BARCODEPRINTERID,
                    m.ISGROUTINGWORKER,
                    m.PLCID,
                    m.VALUEFLAG,
                    m.ACCOUNTID,
                    m.CREATEUSERID,
                    m.CREATETIME,
                    m.UPDATEUSERID,
                    m.UPDATETIME,
                    m.AD_USER_CODE
                FROM
                    TP_MST_USER m
                WHERE 
                    m.VALUEFLAG = '1'
                    AND m.ACCOUNTID = @ACCOUNTID@
                    AND m.USERID = @USERID@
                ",
                new CDAParameter("ACCOUNTID",HttpContext.Current.Session["accountId"].ToString()),
                new CDAParameter("USERID",HttpContext.Current.Request["id"].ToString())
            );
            return new JsonResult(dt).ToJson();
        }
    }

    /// <summary>
    /// 插入 TP_MST_USER
    /// </summary>
    /// <returns>json</returns>
    private string insert(NameValueCollection form)
    {
        using(IDataAccess conn= DataAccess.Create())
        {
            //string primaryKey = conn.GetSequenceNextval("SEQ_TP_MST_USER").ToString();

            //MD5加密密码
            string passWord = FormsAuthentication.HashPasswordForStoringInConfigFile(form["PASSWORD"], "MD5");

            //AD域
            string AD_USER_CODE = form["AD_USER_CODE"];
            if (!string.IsNullOrEmpty(AD_USER_CODE))
            {
                //校验AD域是否已存在
                string sqlStr = @"SELECT 1
                              FROM tp_mst_user
                             WHERE accountid = @accountid@
                               AND valueflag = 1
                               AND ad_user_code = @ad_user_code@";
                List<CDAParameter> sqlPara = new List<CDAParameter>();
                sqlPara.Add(new CDAParameter("accountid", HttpContext.Current.Session["accountId"]));
                sqlPara.Add(new CDAParameter("ad_user_code", AD_USER_CODE));
                DataTable dtcheck = conn.ExecuteDatatable(sqlStr, sqlPara.ToArray());
                if (dtcheck.Rows.Count > 0)
                {
                    return new JsonResult(JsonStatus.error) { message = "AD域已存在" }.ToJson();
                }
            }

            int result = conn.ExecuteNonQuery(@"
                INSERT INTO TP_MST_USER (
                    --USERID,
                    USERCODE,
                    USERNAME,
                    PASSWORD,
                    ORGANIZATIONID,
                    LIMITMAC,
                    CANSMARTLOGIN,
                    ISWORKER,
                    REMARKS,
                    ACCOUNTCODE,
                    LIMITSTARTTIME,
                    LIMITENDTIME,
                    CANPCLOGIN,
                    ISPUBLICBODY,
                    CANLOGINPRD,
                    CANLOGINMBC,
                    POST,
                    BARCODEPRINTERID,
                    ISGROUTINGWORKER,
                    PLCID,
                    ACCOUNTID,CREATEUSERID,UPDATEUSERID
                    ,AD_USER_CODE
                ) VALUES (
                    --@USERID@,
                    @USERCODE@,
                    @USERNAME@,
                    @PASSWORD@,
                    @ORGANIZATIONID@,
                    @LIMITMAC@,
                    @CANSMARTLOGIN@,
                    @ISWORKER@,
                    @REMARKS@,
                    @ACCOUNTCODE@,
                    @LIMITSTARTTIME@,
                    @LIMITENDTIME@,
                    @CANPCLOGIN@,
                    @ISPUBLICBODY@,
                    @CANLOGINPRD@,
                    @CANLOGINMBC@,
                    @POST@,
                    @BARCODEPRINTERID@,
                    @ISGROUTINGWORKER@,
                    @PLCID@,
                    @ACCOUNTID@,@CREATEUSERID@,@UPDATEUSERID@
                    ,@AD_USER_CODE@
                )
                ",
                //new CDAParameter("USERID",primaryKey),
                new CDAParameter("USERCODE",form["USERCODE"]),
                new CDAParameter("USERNAME",form["USERNAME"]),
                new CDAParameter("PASSWORD",passWord),
                new CDAParameter("ORGANIZATIONID",form["ORGANIZATIONID"]),
                new CDAParameter("LIMITMAC",form["LIMITMAC"]),
                new CDAParameter("CANSMARTLOGIN",form["CANSMARTLOGIN"]),
                new CDAParameter("ISWORKER",form["ISWORKER"]),
                new CDAParameter("REMARKS",form["REMARKS"]),
                new CDAParameter("LIMITSTARTTIME",form["LIMITSTARTTIME"]),
                new CDAParameter("LIMITENDTIME",form["LIMITENDTIME"]),
                new CDAParameter("CANPCLOGIN",form["CANPCLOGIN"]),
                new CDAParameter("ISPUBLICBODY",form["ISPUBLICBODY"]),
                new CDAParameter("CANLOGINPRD",form["CANLOGINPRD"]),
                new CDAParameter("CANLOGINMBC",form["CANLOGINMBC"]),
                new CDAParameter("POST",form["POST"]),
                new CDAParameter("BARCODEPRINTERID",form["BARCODEPRINTERID"]),
                new CDAParameter("ISGROUTINGWORKER",form["ISGROUTINGWORKER"]),
                new CDAParameter("PLCID",form["PLCID"]),
                new CDAParameter("ACCOUNTID",HttpContext.Current.Session["accountId"]),
                new CDAParameter("ACCOUNTCODE",HttpContext.Current.Session["accountCode"]),
                new CDAParameter("CREATEUSERID",HttpContext.Current.Session["userId"]),
                new CDAParameter("UPDATEUSERID",HttpContext.Current.Session["userId"]),
                new CDAParameter("AD_USER_CODE",AD_USER_CODE)
            );
            return new JsonResult(JsonStatus.success).ToJson();
        }
    }

    /// <summary>
    /// 更新 TP_MST_USER
    /// </summary>
    /// <returns>json</returns>
    private string update(NameValueCollection form)
    {
        //MD5加密密码
        string passWord = form["PASSWORD"];
        if (passWord.Length != 32) passWord = FormsAuthentication.HashPasswordForStoringInConfigFile(form["passWord"], "MD5");

        using(IDataAccess conn=DataAccess.Create())
        {
             //验证ad域是否已存在
            string AD_USER_CODE = form["AD_USER_CODE"];
            if (!string.IsNullOrEmpty(AD_USER_CODE))
            {
                //校验AD域是否已存在
                string sqlStr = @"SELECT 1
                              FROM tp_mst_user
                             WHERE accountid = @accountid@
                               AND valueflag = 1
                               AND USERID <> @USERID@
                               AND ad_user_code = @ad_user_code@";
                List<CDAParameter> sqlPara = new List<CDAParameter>();
                sqlPara.Add(new CDAParameter("accountid", HttpContext.Current.Session["accountId"]));
                sqlPara.Add(new CDAParameter("ad_user_code", AD_USER_CODE));
                sqlPara.Add(new CDAParameter("USERID", HttpContext.Current.Request["id"]));
                DataTable dtcheck = conn.ExecuteDatatable(sqlStr, sqlPara.ToArray());
                if (dtcheck.Rows.Count > 0)
                {
                    return new JsonResult(JsonStatus.error) { message = "AD域已存在" }.ToJson();
                }
            }

            int result = conn.ExecuteNonQuery(@"
                UPDATE TP_MST_USER 
                SET
                    USERCODE = @USERCODE@,
                    USERNAME = @USERNAME@,
                    PASSWORD = @PASSWORD@,
                    ORGANIZATIONID = @ORGANIZATIONID@,
                    LIMITMAC = @LIMITMAC@,
                    CANSMARTLOGIN = @CANSMARTLOGIN@,
                    ISWORKER = @ISWORKER@,
                    REMARKS = @REMARKS@,
                    LIMITSTARTTIME = @LIMITSTARTTIME@,
                    LIMITENDTIME = @LIMITENDTIME@,
                    CANPCLOGIN = @CANPCLOGIN@,
                    ISPUBLICBODY = @ISPUBLICBODY@,
                    CANLOGINPRD = @CANLOGINPRD@,
                    CANLOGINMBC = @CANLOGINMBC@,
                    POST = @POST@,
                    BARCODEPRINTERID = @BARCODEPRINTERID@,
                    ISGROUTINGWORKER = @ISGROUTINGWORKER@,
                    PLCID = @PLCID@,
                    UPDATEUSERID = @UPDATEUSERID@,
                    UPDATETIME = sysdate,
                    AD_USER_CODE = @AD_USER_CODE@
                WHERE 
                    USERID = @USERID@
                ",
                new CDAParameter("USERCODE",form["USERCODE"]),
                new CDAParameter("USERNAME",form["USERNAME"]),
                new CDAParameter("PASSWORD",passWord),
                new CDAParameter("ORGANIZATIONID",form["ORGANIZATIONID"]),
                new CDAParameter("LIMITMAC",form["LIMITMAC"]),
                new CDAParameter("CANSMARTLOGIN",form["CANSMARTLOGIN"]),
                new CDAParameter("ISWORKER",form["ISWORKER"]),
                new CDAParameter("REMARKS",form["REMARKS"]),
                new CDAParameter("LIMITSTARTTIME",form["LIMITSTARTTIME"]),
                new CDAParameter("LIMITENDTIME",form["LIMITENDTIME"]),
                new CDAParameter("CANPCLOGIN",form["CANPCLOGIN"]),
                new CDAParameter("ISPUBLICBODY",form["ISPUBLICBODY"]),
                new CDAParameter("CANLOGINPRD",form["CANLOGINPRD"]),
                new CDAParameter("CANLOGINMBC",form["CANLOGINMBC"]),
                new CDAParameter("POST",form["POST"]),
                new CDAParameter("BARCODEPRINTERID",form["BARCODEPRINTERID"]),
                new CDAParameter("ISGROUTINGWORKER",form["ISGROUTINGWORKER"]),
                new CDAParameter("PLCID",form["PLCID"]),
                new CDAParameter("UPDATEUSERID",HttpContext.Current.Session["userId"]),
                new CDAParameter("USERID",HttpContext.Current.Request["id"]),
                 new CDAParameter("AD_USER_CODE",AD_USER_CODE)
            );
            return new JsonResult(JsonStatus.success).ToJson();
        }
    }

    /// <summary>
    /// 删除 TP_MST_USER
    /// </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_USER 
                    WHERE 
                        INSTR(',' || @USERID@ || ',' , ',' || USERID || ',') > 0 
                    ",
                    new CDAParameter("USERID", HttpContext.Current.Request["id"].ToString())
                );
                return new JsonResult(JsonStatus.success).ToJson();
            }
            else
            {
                return new JsonResult(JsonStatus.otherError).ToJson();
            }
        }
    }

    /// <summary>
    /// 导出 TP_MST_USER
    /// </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 btnRight = false;
        public bool btnCheckbox = false;
        public bool btnExport = false;
        public bool btnReload = false;
    }

    private class xRecord
    {
        public string sid { get; set; }
        public string USERCODE { get; set; }
        public string USERNAME { get; set; }
        public string PASSWORD { get; set; }
        public string ORGANIZATIONID { get; set; }
        public string LIMITMAC { get; set; }
        public string CANSMARTLOGIN { get; set; }
        public string ISWORKER { get; set; }
        public string REMARKS { get; set; }
        public string LIMITSTARTTIME { get; set; }
        public string LIMITENDTIME { get; set; }
        public string CANPCLOGIN { get; set; }
        public string ISPUBLICBODY { get; set; }
        public string CANLOGINPRD { get; set; }
        public string CANLOGINMBC { get; set; }
        public string POST { get; set; }
        public string BARCODEPRINTERID { get; set; }
        public string ISGROUTINGWORKER { get; set; }
        public string PLCID { get; set; }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}