개정판 753a1c26
issue #0000 save클릭시 markus 설정 저장하도록 수정
Change-Id: I72cbcda4096057cd18e7c021f0c90f60aff5aae5
| .gitignore | ||
|---|---|---|
| 269 | 269 |
/DTI_PID/DTI_PID/AppWebService.py |
| 270 | 270 |
/DTI_PID/WebServer |
| 271 | 271 |
/DTI_PID/DTI_PID/WebServer |
| 272 |
/ID2.Manager/ID2.Manager/Properties/licenses.licx |
|
| ID2.Manager/ExcelAddin/ID2ManagerImport/ID2ManagerImport.csproj | ||
|---|---|---|
| 33 | 33 |
<PublishUrl>게시\</PublishUrl> |
| 34 | 34 |
<InstallUrl /> |
| 35 | 35 |
<TargetCulture>ko</TargetCulture> |
| 36 |
<ApplicationVersion>1.6.0.1</ApplicationVersion>
|
|
| 36 |
<ApplicationVersion>1.7.0.1</ApplicationVersion>
|
|
| 37 | 37 |
<AutoIncrementApplicationRevision>true</AutoIncrementApplicationRevision> |
| 38 | 38 |
<UpdateEnabled>false</UpdateEnabled> |
| 39 | 39 |
<UpdateInterval>0</UpdateInterval> |
| ... | ... | |
| 221 | 221 |
<DependentUpon>ThisAddIn.Designer.xml</DependentUpon> |
| 222 | 222 |
</Compile> |
| 223 | 223 |
<AppDesigner Include="Properties\" /> |
| 224 |
<None Include="www.doftech.co.kr.pfx" /> |
|
| 224 | 225 |
</ItemGroup> |
| 225 | 226 |
<ItemGroup> |
| 226 | 227 |
<PackageReference Include="MsSQLDialog"> |
| ... | ... | |
| 235 | 236 |
<SignManifests>true</SignManifests> |
| 236 | 237 |
</PropertyGroup> |
| 237 | 238 |
<PropertyGroup> |
| 238 |
<ManifestKeyFile>ID2ManagerImport_TemporaryKey.pfx</ManifestKeyFile>
|
|
| 239 |
<ManifestKeyFile>www.doftech.co.kr.pfx</ManifestKeyFile>
|
|
| 239 | 240 |
</PropertyGroup> |
| 240 | 241 |
<PropertyGroup> |
| 241 |
<ManifestCertificateThumbprint>EF3F3E89EB1A23160BB3D1B0635AF73C25DFB484</ManifestCertificateThumbprint>
|
|
| 242 |
<ManifestCertificateThumbprint>D711C6148F2B1BBF5D285ABCE362BCEE04A004C4</ManifestCertificateThumbprint>
|
|
| 242 | 243 |
</PropertyGroup> |
| 243 | 244 |
<!-- Include the build rules for a C# project. --> |
| 244 | 245 |
<Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> |
| ID2.Manager/ExcelAddin/ID2ManagerImport/Properties/AssemblyInfo.cs | ||
|---|---|---|
| 33 | 33 |
// 모든 값을 지정하거나 아래와 같이 '*'를 사용하여 빌드 번호 및 수정 번호가 자동으로 |
| 34 | 34 |
// 지정되도록 할 수 있습니다. |
| 35 | 35 |
// [assembly: AssemblyVersion("1.0.*")]
|
| 36 |
[assembly: AssemblyVersion("1.6.0.0")]
|
|
| 37 |
[assembly: AssemblyFileVersion("1.6.0.0")]
|
|
| 36 |
[assembly: AssemblyVersion("1.7.0.0")]
|
|
| 37 |
[assembly: AssemblyFileVersion("1.7.0.0")]
|
|
| 38 | 38 |
|
| ID2.Manager/ID2.Manager.Controller/Controllers/MarkusInfoController.cs | ||
|---|---|---|
| 23 | 23 |
// return result; |
| 24 | 24 |
//} |
| 25 | 25 |
|
| 26 |
public bool SetProperties(IEnumerable<string> ProjectNoList) |
|
| 27 |
{
|
|
| 28 |
bool result = false; |
|
| 29 |
|
|
| 30 |
try |
|
| 31 |
{
|
|
| 32 |
using (MarkusRepository rep = new MarkusRepository(this._MARKUSCONNSTR)) |
|
| 33 |
{
|
|
| 34 |
foreach (var ProjectNo in ProjectNoList) |
|
| 35 |
{
|
|
| 36 |
rep.InsertProperties(ProjectNo); |
|
| 37 |
} |
|
| 38 |
result = true; |
|
| 39 |
} |
|
| 40 |
|
|
| 41 |
} |
|
| 42 |
catch (Exception) |
|
| 43 |
{
|
|
| 44 |
throw; |
|
| 45 |
} |
|
| 46 |
|
|
| 47 |
return result; |
|
| 48 |
} |
|
| 49 |
|
|
| 26 | 50 |
public bool SetMarkusInfo(List<Documents> docList) |
| 27 | 51 |
{
|
| 28 | 52 |
bool result = false; |
| ID2.Manager/ID2.Manager.Dapper/Repository/MarkusRepository.cs | ||
|---|---|---|
| 135 | 135 |
return result; |
| 136 | 136 |
} |
| 137 | 137 |
|
| 138 |
public bool InsertProperties(string ProjectNo) |
|
| 139 |
{
|
|
| 140 |
bool result = false; |
|
| 141 |
|
|
| 142 |
try |
|
| 143 |
{
|
|
| 144 |
var properties = new[] { "TileSorceStorage", "TileSorcePath" };
|
|
| 145 |
|
|
| 146 |
foreach (var property in properties) |
|
| 147 |
{
|
|
| 148 |
var tran = BeginTransaction(); |
|
| 149 |
|
|
| 150 |
string SQL = "INSERT INTO [dbo].[PROPERTIES] ([TYPE], [PROPERTY], [VALUE])" + |
|
| 151 |
" SELECT @TYPE,@ProjectNo, [VALUE]" + |
|
| 152 |
" FROM [dbo].[PROPERTIES]" + |
|
| 153 |
" WHERE [TYPE] = @TYPE AND [PROPERTY] = 'APAO'" + |
|
| 154 |
" AND NOT EXISTS (" +
|
|
| 155 |
" SELECT 1" + |
|
| 156 |
" FROM [dbo].[PROPERTIES]" + |
|
| 157 |
" WHERE [TYPE] = @TYPE AND [PROPERTY] = @ProjectNo)"; |
|
| 158 |
|
|
| 159 |
var parameters = new DynamicParameters(); |
|
| 160 |
parameters.Add("@TYPE", property);
|
|
| 161 |
parameters.Add("@ProjectNo", ProjectNo);
|
|
| 162 |
|
|
| 163 |
var rowsAffected = base.Execute(SQL, parameters, tran); |
|
| 164 |
|
|
| 165 |
tran.Commit(); |
|
| 166 |
} |
|
| 167 |
} |
|
| 168 |
catch (Exception ex) |
|
| 169 |
{
|
|
| 170 |
throw new Exception($"InsertProperties : {ProjectNo}", ex);
|
|
| 171 |
} |
|
| 172 |
|
|
| 173 |
return result; |
|
| 174 |
} |
|
| 175 |
|
|
| 138 | 176 |
public IEnumerable<MEMBER> GetMEMBER(string id) |
| 139 | 177 |
{
|
| 140 | 178 |
string SQL = "SELECT * FROM MEMBER WHERE ID = @ID"; |
| ID2.Manager/ID2.Manager/Main.cs | ||
|---|---|---|
| 1929 | 1929 |
result = (bool)e.Result; |
| 1930 | 1930 |
if (result) |
| 1931 | 1931 |
{
|
| 1932 |
markusResult = new MarkusInfoController().SetProperties(Program.informations.ProjectList.Where(x => x.Level == 2).Select(x=>x.Name)); |
|
| 1932 | 1933 |
markusResult = new MarkusInfoController().SetMarkusInfo(this.documents); |
| 1933 | 1934 |
markusMembersResult = new MarkusInfoController().SetMembers(informations.UserList); |
| 1934 | 1935 |
} |
내보내기 Unified diff
