개정판 2cd9327e
issue #0000
project 정보에 Port 항목 추가(id2연결관리)
- 기본값 2549
- 범위 0~65535
Change-Id: Ifd6935f52472966cf6f8a7b4580b6053c8ae07be
| ID2.Manager/ID2.Manager.Dapper/Repository/ProjectRepository.cs | ||
|---|---|---|
| 26 | 26 |
,isnull(ParentID,'') GroupID |
| 27 | 27 |
,convert(varchar(255),'') GroupName |
| 28 | 28 |
,isnull(Team,'') Team |
| 29 |
,Port |
|
| 29 | 30 |
,1 [Level] |
| 30 | 31 |
from dbo.Projects |
| 31 | 32 |
where ParentID is null |
| ... | ... | |
| 39 | 40 |
,p.ParentID GroupID |
| 40 | 41 |
,pp.[Name] GroupName |
| 41 | 42 |
,p.Team |
| 43 |
,p.Port |
|
| 42 | 44 |
,pp.[Level]+1 [Level] |
| 43 | 45 |
FROM dbo.Projects p |
| 44 | 46 |
inner join Prj pp ON p.ParentID=pp.ProjectID |
| ... | ... | |
| 69 | 71 |
,isnull(ParentID,'') GroupID |
| 70 | 72 |
,convert(varchar(255),'') GroupName |
| 71 | 73 |
,isnull(Team,'') Team |
| 74 |
,Port |
|
| 72 | 75 |
,1 [Level] |
| 73 | 76 |
from dbo.Projects |
| 74 | 77 |
where ParentID is null |
| ... | ... | |
| 82 | 85 |
,p.ParentID GroupID |
| 83 | 86 |
,pp.[Name] GroupName |
| 84 | 87 |
,p.Team |
| 88 |
,p.Port |
|
| 85 | 89 |
,pp.[Level]+1 [Level] |
| 86 | 90 |
FROM dbo.Projects p |
| 87 | 91 |
inner join Prj pp ON p.ParentID=pp.ProjectID |
| ... | ... | |
| 162 | 166 |
{ "ParentID", projectInfo.ProjectID },
|
| 163 | 167 |
{ "Name", prj.Name },
|
| 164 | 168 |
{ "Desc", prj.Desc },
|
| 165 |
{ "Team", prj.Team }
|
|
| 169 |
{ "Team", prj.Team },
|
|
| 170 |
{ "Port", prj.Port },
|
|
| 166 | 171 |
}; |
| 167 | 172 |
|
| 168 | 173 |
query = $@" |
| ... | ... | |
| 171 | 176 |
update dbo.Projects |
| 172 | 177 |
set [Description]=@Desc |
| 173 | 178 |
,Team=@Team |
| 179 |
,Port=@Port |
|
| 174 | 180 |
where ParentID=@ParentID and Code=@Name |
| 175 | 181 |
end |
| 176 | 182 |
else |
| ... | ... | |
| 183 | 189 |
,[Name] |
| 184 | 190 |
,[Description] |
| 185 | 191 |
,Team |
| 192 |
,Port |
|
| 186 | 193 |
) |
| 187 | 194 |
values |
| 188 | 195 |
( |
| ... | ... | |
| 192 | 199 |
,@Name |
| 193 | 200 |
,@Desc |
| 194 | 201 |
,@Team |
| 202 |
,@Port |
|
| 195 | 203 |
) |
| 196 | 204 |
end;"; |
| 197 | 205 |
base.Execute(query, parameters, transaction); |
내보내기 Unified diff
