개정판 473ee829
issue #0000
Project 정보 수정
ID2 Project DB의 정보를 ID2 Manager와 매핑
Change-Id: Idcc82a34b8027032529cbc43a62757ea6d48f586
| ID2.Manager/ID2.Manager.Dapper/Repository/ProjectRepository.cs | ||
|---|---|---|
| 21 | 21 |
,Code |
| 22 | 22 |
,[Name] |
| 23 | 23 |
,isnull(Description,'') Description |
| 24 |
,isnull(ID2Path,'') ID2Path |
|
| 25 | 24 |
,isnull(ParentID,'') GroupID |
| 26 | 25 |
,convert(varchar(255),'') GroupName |
| 27 | 26 |
,1 [Level] |
| ... | ... | |
| 34 | 33 |
,p.Code |
| 35 | 34 |
,p.[Name] |
| 36 | 35 |
,p.Description |
| 37 |
,p.ID2Path |
|
| 38 | 36 |
,p.ParentID GroupID |
| 39 | 37 |
,pp.[Name] GroupName |
| 40 | 38 |
,pp.[Level]+1 [Level] |
| ... | ... | |
| 57 | 55 |
,Code |
| 58 | 56 |
,[Name] |
| 59 | 57 |
,isnull(Description,'') Description |
| 60 |
,isnull(ID2Path,'') ID2Path |
|
| 61 | 58 |
,isnull(ParentID,'') GroupID |
| 62 | 59 |
,convert(varchar(255),'') GroupName |
| 63 | 60 |
,1 [Level] |
| ... | ... | |
| 70 | 67 |
,p.Code |
| 71 | 68 |
,p.[Name] |
| 72 | 69 |
,p.Description |
| 73 |
,p.ID2Path |
|
| 74 | 70 |
,p.ParentID GroupID |
| 75 | 71 |
,pp.[Name] GroupName |
| 76 | 72 |
,pp.[Level]+1 [Level] |
| ... | ... | |
| 147 | 143 |
{
|
| 148 | 144 |
{ "ParentID", projectInfo.ProjectID },
|
| 149 | 145 |
{ "Name", prj.Name },
|
| 150 |
{ "Desc", prj.Desc },
|
|
| 151 |
{ "Path", prj.Path }
|
|
| 146 |
{ "Desc", prj.Desc }
|
|
| 152 | 147 |
}; |
| 153 | 148 |
|
| 154 | 149 |
query = $@" |
| ... | ... | |
| 156 | 151 |
begin |
| 157 | 152 |
update dbo.Projects |
| 158 | 153 |
set [Description]=@Desc |
| 159 |
,ID2Path=@Path |
|
| 160 | 154 |
where ParentID=@ParentID and Code=@Name |
| 161 | 155 |
end |
| 162 | 156 |
else |
| ... | ... | |
| 168 | 162 |
,Code |
| 169 | 163 |
,[Name] |
| 170 | 164 |
,[Description] |
| 171 |
,ID2Path |
|
| 172 | 165 |
) |
| 173 | 166 |
values |
| 174 | 167 |
( |
| ... | ... | |
| 177 | 170 |
,@Name |
| 178 | 171 |
,@Name |
| 179 | 172 |
,@Desc |
| 180 |
,@Path |
|
| 181 | 173 |
) |
| 182 | 174 |
end;"; |
| 183 | 175 |
base.Execute(query, parameters, transaction); |
내보내기 Unified diff
