新增登录后我的消息接口

yl

2022-10-18 bc91272547462e667f12efb62fe1f058da227c61

 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,10 @@
                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;
                }
            }
            catch (Exception e)
            {
@@ -1877,13 +1866,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 
                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
                            )  C  on B.user_code=C.usercode
                            left  join TUser U on B.user_code=U.usercode";
                        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);