1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| using MES.Service.DB;
|
| namespace MES.Service.util;
|
| public class UserUtil : RepositoryNoEntity
| {
| public static (string factory, string company) GetFactory(string user)
| {
| string sql =
| "select t.Ffactory factory, t.Fcompany company from sys_user t where t.fcode = upper(trim('" +
| user + "'))";
|
| var sqlQuerySingle = Db.Ado.SqlQuerySingle<dynamic>(sql);
|
| return (sqlQuerySingle.FACTORY, sqlQuerySingle.COMPANY);
| }
| }
|
|
