개정판 90369b9c
issue #0000
ID2 Project DB 누락컬럼 수정
- ProjectID, ProjectNo, NPSUnit, AreaName, PlantName 삭제
Change-Id: I6d318f8d174cca4b0b8fe53e5d2ea4925826f11d
| ID2.Manager/ID2.Manager.Dapper/Repository/ID2Repository.cs | ||
|---|---|---|
| 21 | 21 |
try |
| 22 | 22 |
{
|
| 23 | 23 |
string query = $@" |
| 24 |
select pj.Id, pj.ProjectID, pj.ProjectNo, pj.Name, pj.Desc, pj.Unit, pj.NPSUnit, pj.Path, pj.AreaName, pj.PlantName, pj.CreatedDate, pj.UpdatedDate
|
|
| 24 |
select pj.Id, pj.Name, pj.Desc, pj.Unit, pj.Path, pj.CreatedDate, pj.UpdatedDate
|
|
| 25 | 25 |
,ty.UID as DBTypeID ,ty.Name as DBTypeName |
| 26 | 26 |
,db.Host, db.User, db.Password, db.FilePath as DBPath |
| 27 | 27 |
from ( |
| ID2.Manager/ID2.Manager.Data/Models/ProjectInfo.cs | ||
|---|---|---|
| 38 | 38 |
[DataMember] |
| 39 | 39 |
public int Id { get; set; }
|
| 40 | 40 |
[DataMember] |
| 41 |
public string ProjectID { get; set; }
|
|
| 42 |
[DataMember] |
|
| 43 |
public string ProjectNo { get; set; }
|
|
| 44 |
[DataMember] |
|
| 45 | 41 |
public string Name { get; set; }
|
| 46 | 42 |
[DataMember] |
| 47 | 43 |
public string Desc { get; set; }
|
| 48 | 44 |
[DataMember] |
| 49 | 45 |
public string Unit { get; set; }
|
| 50 | 46 |
[DataMember] |
| 51 |
public string NPSUnit { get; set; }
|
|
| 52 |
[DataMember] |
|
| 53 | 47 |
public string Path { get; set; }
|
| 54 | 48 |
[DataMember] |
| 55 |
public string AreaName { get; set; }
|
|
| 56 |
[DataMember] |
|
| 57 |
public string PlantName { get; set; }
|
|
| 58 |
[DataMember] |
|
| 59 | 49 |
public string CreatedDate { get; set; }
|
| 60 | 50 |
[DataMember] |
| 61 | 51 |
public string UpdatedDate { get; set; }
|
내보내기 Unified diff
