| | |
| | | string search = ""; |
| | | try |
| | | { |
| | | sql = @"select usercode,username from TUser where status='Y'"; |
| | | sql = @"select usercode,username,payrate from TUser where status='Y'"; |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | mes.code = "200"; |
| | | mes.message = "查询成功!"; |
| | |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | sql = @"select usercode,username from TUser where storg_code=@torgcode"; |
| | | sql = @"select usercode,username,payrate from TUser where storg_code=@torgcode"; |
| | | dynamicParams.Add("@torgcode", torgcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | mes.code = "200"; |