| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //班组获取人员列表 |
|---|
| | | sql = @"select usercode,username from TUser where stu_torgcode=@stu_torgcode and usergroup_code=@usergroupcode and is_delete<>'1'"; |
|---|
| | | sql = @"select usercode,username,payrate from TUser where stu_torgcode=@stu_torgcode and usergroup_code=@usergroupcode and is_delete<>'1'"; |
|---|
| | | dynamicParams.Add("@stu_torgcode", stu_torgcode); |
|---|
| | | dynamicParams.Add("@usergroupcode", usergroupcode); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | |
|---|
| | | dynamicParams.Add("@usercode", usercode); |
|---|
| | | } |
|---|
| | | //班组获取人员列表 |
|---|
| | | sql = @"select usercode,username from TUser where is_delete<>'1' and usercode<>'9999'" + search; |
|---|
| | | sql = @"select usercode,username,payrate from TUser where is_delete<>'1' and usercode<>'9999'" + search; |
|---|
| | | dynamicParams.Add("@usercode", usercode); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | mes.code = "200"; |
|---|
