极光消息推送

yl

2022-10-27 5d70327428efc1d341617d0b26c059bc5217b951

 VueWebApi/DLL/DAL/LoginDAL.cs

@@ -305,11 +305,10 @@
        #endregion

        #region[App登录查询安灯呼叫信息]
        public static ToMessage LoginAppAnDonMessage(int userid, string usercode, string username, string usertype)
        public static ToMessage LoginAppAnDonMessage(string rid, string usercode, string username, string usertype)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            RedisHelper redis = new RedisHelper();
            try
            {
                sql = @"select B.eqp_code,E.name as eqp_name,B.wkshp_code,T.org_name as wkshp_name,
@@ -319,8 +318,10 @@
                        left  join TEqpInfo E on B.eqp_code=E.code
                        left  join TOrganization T on B.wkshp_code=T.org_code 
                        left  join TAnDonType D on A.type=d.code
                        where A.resp_user=@usercode and B.status='START' and T.description='W'";
                        left  join TUser U on A.resp_user=U.usercode
                        where A.resp_user=@usercode and B.status='START' and U.rid=@rid  and T.description='W'";
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@rid", rid);
                var data = DapperHelper.selectdata(sql, dynamicParams);

                mes.code = "200";
@@ -339,5 +340,6 @@
            return mes;
        }
        #endregion

    }
}