安灯报表开发

yl

2022-10-25 dd651f9ce0156fc7db869da04e0c2004a1811c52

 VueWebApi/DLL/DAL/LoginDAL.cs

@@ -313,14 +313,14 @@
            try
            {
                sql = @"select B.eqp_code,E.name as eqp_name,B.wkshp_code,T.org_name as wkshp_name,
                        A.tpye as typecode,D.name as typename,B.start_user,B.start_date   
                        A.type as typecode,D.name as typename,B.start_user,B.start_date   
                        from TAnDnMessagePush A
                        inner join TAnDon_Task_Info B on A.m_id=B.id
                        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.tpye=d.code
                        where A.resp_user=@username and B.status='START' and T.description='W'";
                dynamicParams.Add("@username", username);
                        left  join TAnDonType D on A.type=d.code
                        where A.resp_user=@usercode and B.status='START' and T.description='W'";
                dynamicParams.Add("@usercode", usercode);
                var data = DapperHelper.selectdata(sql, dynamicParams);

                mes.code = "200";