新增登录后我的消息接口

yl

2022-10-18 5219bb472eb039374c00486b2acc22d8b2bae07f

 VueWebApi/DLL/DAL/BasicSettingDAL.cs

@@ -1699,9 +1699,8 @@


        #region[安灯系统/自定义安灯呼叫类型查询]
        public static ToMessage AnDengTypeSearch(int startNum, int endNum, string prop, string order)
        public static ToMessage AnDengTypeSearch()
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                // --------------查询指定数据--------------
@@ -1709,11 +1708,11 @@
                var sql = @"select id, code,name 
                            from TAnDonType 
                            where  is_delete<>'1' ";
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
                mes.data = data;
            }
            catch (Exception e)
            {
@@ -1844,20 +1843,12 @@
                dynamicParams.Add("@wkshopcode", wkshopcode);
                dynamicParams.Add("@calltypecode", calltypecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "查询成功!";
                    mes.data = data;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "暂无响应人员!";
                    mes.data = null;
                }

                mes.code = "200";
                mes.count = 0;
                mes.Message = "查询成功!";
                mes.data = data;

            }
            catch (Exception e)
            {
@@ -1877,13 +1868,14 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select B.user_code as code,U.username as name,(case when C.usercode is null then 'N' else 'Y' end) flag from TUserRoleRelation B 
                            left join(
                            select B.usercode from TAnDon_Roul_ConFig A
                            inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
                            where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode
                            )  C  on B.user_code=C.usercode
                            left  join TUser U on B.user_code=U.usercode";
                sql = @"select A.usercode,A.username,(case when B.usercode<>'' then 'Y' else 'N' end) as flag   
                        from TUser A
                        left join (
                        select B.usercode   from  TAnDon_Roul_ConFig A
                        inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
                        where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode and A.enable='Y'
                        ) B  on A.usercode=B.usercode
                        where A.userclassid='0'";
                dynamicParams.Add("@wkshopcode", wkshopcode);
                dynamicParams.Add("@calltypecode", calltypecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
@@ -2016,8 +2008,8 @@
                    parm = new
                    {
                        wkshp_code = wkshopcode,
                        andengtypecode=calltypecode,
                        lm_user=usercode,
                        andengtypecode = calltypecode,
                        lm_user = usercode,
                        lm_date = DateTime.Now.ToString(),
                        enable = enable
                    }
@@ -2050,7 +2042,7 @@
        #endregion

        #region[安灯系统/响应人员删除]
        public static ToMessage AnDengResponUserDeleteSeave(string id,string ando_cogfigid)
        public static ToMessage AnDengResponUserDeleteSeave(string id, string ando_cogfigid)
        {
            var sql = "";
            List<object> list = new List<object>();
@@ -2068,7 +2060,7 @@
                    sql = @"delete TAnDon_Roul_ConFigUser   where id=@id";
                    list.Add(new { str = sql, parm = new { id = id } });
                }
                else 
                else
                {
                    //根据子表id删除对应子表人员
                    sql = @"delete TAnDon_Roul_ConFigUser   where id=@id";