개정판 f074a104
issue #0000
Main Grid
- 이미지 삭제 시 이미지 count 업데이트 되도록 수정
- 이미지 추가 시 이미지 count 업데이트 되도록 수정
- checkbox 클릭 후 combo 데이터 변경 시 해당 checkbox에 해당하는 값이 변경되면 체크박스 전체 데이터 변경 되도록 수정
Excel Import
- Excel Import 시 기존에 바인딩 되어있는 Team, Document No 가 존재하면 해당 데이터 업데이트
- Excel Import 시 기존에 바인딩 되어있는 Team, Document No 가 존재하지 않으면 append 되도록 수정
Save
- Save 로직 수정
Documents Model
- 불필요한 컬럼 삭제
- Team, Document No 비교 class 추가
- Document 값을 복사 및 파일 append를 위한 함수추가
Change-Id: Iedc21f63e38e0140e3ccfec0c12fc492544ee342
| ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
|---|---|---|
| 334 | 334 |
return existCount; |
| 335 | 335 |
} |
| 336 | 336 |
|
| 337 |
public bool SetDocumentData(string projectGroupID, List<Documents> docList, List<Documents> delDocList, string userId)
|
|
| 337 |
public bool SetDocumentData(string projectGroupID, List<Documents> docList, List<string> delDocList, string userId)
|
|
| 338 | 338 |
{
|
| 339 | 339 |
bool isSuccess = false; |
| 340 | 340 |
|
| 341 | 341 |
try |
| 342 | 342 |
{
|
| 343 |
|
|
| 344 |
#region merge 주석처리 |
|
| 345 |
/* |
|
| 346 |
{
|
|
| 347 |
docList.ForEach(x => |
|
| 348 |
{
|
|
| 349 |
x.RegisteredUser = userId; |
|
| 350 |
x.ModifiedUser = userId; |
|
| 351 |
}); |
|
| 352 |
string query = $@" |
|
| 353 |
merge into dbo.Documents as tg |
|
| 354 |
using |
|
| 355 |
( |
|
| 356 |
values |
|
| 357 |
( |
|
| 358 |
@DocumentNo |
|
| 359 |
,@RevisonNo |
|
| 360 |
,@System |
|
| 361 |
,@SubSystemCode |
|
| 362 |
,@RefProjectCode |
|
| 363 |
,@JobLevel |
|
| 364 |
,@PersonInCharge |
|
| 365 |
,@RegisteredUser |
|
| 366 |
,@ModifiedUser |
|
| 367 |
,@ToIsDiscussion |
|
| 368 |
,@ToRemarks |
|
| 369 |
,@ToCreator |
|
| 370 |
,@FrReviewStatus |
|
| 371 |
,@FrRemarks |
|
| 372 |
,@FrCreator |
|
| 373 |
,@ID2StartDate |
|
| 374 |
,@ID2EndDate |
|
| 375 |
,@ID2Status |
|
| 376 |
,@ID2Issues |
|
| 377 |
,@ReplyModifications |
|
| 378 |
,@ReplyRequester |
|
| 379 |
,@IsConvert |
|
| 380 |
,@AVEVAPersonInCharge |
|
| 381 |
,@AVEVAWorker |
|
| 382 |
,@AVEVAConvertDate |
|
| 383 |
,@AVEVAReviewDate |
|
| 384 |
,@AVEVAWorkDate |
|
| 385 |
,@AVEVAStatus |
|
| 386 |
,@AVEVAIssues |
|
| 387 |
,@ProdReviewer |
|
| 388 |
,@ProdIsResult |
|
| 389 |
,@ProdRemarks |
|
| 390 |
,@ClientReviewer |
|
| 391 |
,@ClientIsResult |
|
| 392 |
,@ClientRemarks |
|
| 393 |
,@DTIsGateWay |
|
| 394 |
,@DTIsImport |
|
| 395 |
,@DTIsRegSystem |
|
| 396 |
,@DTRemarks |
|
| 397 |
) |
|
| 398 |
) as sc |
|
| 399 |
( |
|
| 400 |
DocumentNo |
|
| 401 |
,RevisonNo |
|
| 402 |
,[System] |
|
| 403 |
,SubSystemCode |
|
| 404 |
,RefProjectCode |
|
| 405 |
,JobLevel |
|
| 406 |
,PersonInCharge |
|
| 407 |
,RegisteredUser |
|
| 408 |
,ModifiedUser |
|
| 409 |
,ToIsDiscussion |
|
| 410 |
,ToRemarks |
|
| 411 |
,ToCreator |
|
| 412 |
,FrReviewStatus |
|
| 413 |
,FrRemarks |
|
| 414 |
,FrCreator |
|
| 415 |
,ID2StartDate |
|
| 416 |
,ID2EndDate |
|
| 417 |
,ID2Status |
|
| 418 |
,ID2Issues |
|
| 419 |
,ReplyModifications |
|
| 420 |
,ReplyRequester |
|
| 421 |
,IsConvert |
|
| 422 |
,AVEVAPersonInCharge |
|
| 423 |
,AVEVAWorker |
|
| 424 |
,AVEVAConvertDate |
|
| 425 |
,AVEVAReviewDate |
|
| 426 |
,AVEVAWorkDate |
|
| 427 |
,AVEVAStatus |
|
| 428 |
,AVEVAIssues |
|
| 429 |
,ProdReviewer |
|
| 430 |
,ProdIsResult |
|
| 431 |
,ProdRemarks |
|
| 432 |
,ClientReviewer |
|
| 433 |
,ClientIsResult |
|
| 434 |
,ClientRemarks |
|
| 435 |
,DTIsGateWay |
|
| 436 |
,DTIsImport |
|
| 437 |
,DTIsRegSystem |
|
| 438 |
,DTRemarks |
|
| 439 |
) |
|
| 440 |
ON sc.DocumentNo=tg.DocumentNo |
|
| 441 |
when matched and tg.IsDeleted=0 then |
|
| 442 |
|
|
| 443 |
update |
|
| 444 |
set tg.DocumentNo=sc.DocumentNo |
|
| 445 |
,tg.RevisonNo=sc.RevisonNo |
|
| 446 |
,tg.[System]=sc.[System] |
|
| 447 |
,tg.SubSystemCode=sc.SubSystemCode |
|
| 448 |
,tg.RefProjectCode=sc.RefProjectCode |
|
| 449 |
,tg.JobLevel=sc.JobLevel |
|
| 450 |
,tg.PersonInCharge=sc.PersonInCharge |
|
| 451 |
,tg.ModifiedDate=getdate() |
|
| 452 |
,tg.ModifiedUser=sc.ModifiedUser |
|
| 453 |
,tg.ToIsDiscussion=sc.ToIsDiscussion |
|
| 454 |
,tg.ToRemarks=sc.ToRemarks |
|
| 455 |
,tg.ToCreator=sc.ToCreator |
|
| 456 |
,tg.FrReviewStatus=sc.FrReviewStatus |
|
| 457 |
,tg.FrRemarks=sc.FrRemarks |
|
| 458 |
,tg.FrCreator=sc.FrCreator |
|
| 459 |
,tg.ID2StartDate=sc.ID2StartDate |
|
| 460 |
,tg.ID2EndDate=sc.ID2EndDate |
|
| 461 |
,tg.ID2Status=sc.ID2Status |
|
| 462 |
,tg.ID2Issues=sc.ID2Issues |
|
| 463 |
,tg.ReplyModifications=sc.ReplyModifications |
|
| 464 |
,tg.ReplyRequester=sc.ReplyRequester |
|
| 465 |
,tg.IsConvert=sc.IsConvert |
|
| 466 |
,tg.AVEVAPersonInCharge=sc.AVEVAPersonInCharge |
|
| 467 |
,tg.AVEVAWorker=sc.AVEVAWorker |
|
| 468 |
,tg.AVEVAConvertDate=sc.AVEVAConvertDate |
|
| 469 |
,tg.AVEVAReviewDate=sc.AVEVAReviewDate |
|
| 470 |
,tg.AVEVAWorkDate=sc.AVEVAWorkDate |
|
| 471 |
,tg.AVEVAStatus=sc.AVEVAStatus |
|
| 472 |
,tg.AVEVAIssues=sc.AVEVAIssues |
|
| 473 |
,tg.ProdReviewer=sc.ProdReviewer |
|
| 474 |
,tg.ProdIsResult=sc.ProdIsResult |
|
| 475 |
,tg.ProdRemarks=sc.ProdRemarks |
|
| 476 |
,tg.ClientReviewer=sc.ClientReviewer |
|
| 477 |
,tg.ClientIsResult=sc.ClientIsResult |
|
| 478 |
,tg.ClientRemarks=sc.ClientRemarks |
|
| 479 |
,tg.DTIsGateWay=sc.DTIsGateWay |
|
| 480 |
,tg.DTIsImport=sc.DTIsImport |
|
| 481 |
,tg.DTIsRegSystem=sc.DTIsRegSystem |
|
| 482 |
,tg.DTRemarks=sc.DTRemarks |
|
| 483 |
when not matched then |
|
| 484 |
|
|
| 485 |
|
|
| 486 |
insert |
|
| 487 |
( |
|
| 488 |
DocID |
|
| 489 |
,DocumentNo |
|
| 490 |
,RevisonNo |
|
| 491 |
,[System] |
|
| 492 |
,SubSystemCode |
|
| 493 |
,RefProjectCode |
|
| 494 |
,JobLevel |
|
| 495 |
,PersonInCharge |
|
| 496 |
,RegisteredDate |
|
| 497 |
,RegisteredUser |
|
| 498 |
,ToIsDiscussion |
|
| 499 |
,ToRemarks |
|
| 500 |
,ToCreator |
|
| 501 |
,FrReviewStatus |
|
| 502 |
,FrRemarks |
|
| 503 |
,FrCreator |
|
| 504 |
,ID2StartDate |
|
| 505 |
,ID2EndDate |
|
| 506 |
,ID2Status |
|
| 507 |
,ID2Issues |
|
| 508 |
,ReplyModifications |
|
| 509 |
,ReplyRequester |
|
| 510 |
,IsConvert |
|
| 511 |
,AVEVAPersonInCharge |
|
| 512 |
,AVEVAWorker |
|
| 513 |
,AVEVAConvertDate |
|
| 514 |
,AVEVAReviewDate |
|
| 515 |
,AVEVAWorkDate |
|
| 516 |
,AVEVAStatus |
|
| 517 |
,AVEVAIssues |
|
| 518 |
,ProdReviewer |
|
| 519 |
,ProdIsResult |
|
| 520 |
,ProdRemarks |
|
| 521 |
,ClientReviewer |
|
| 522 |
,ClientIsResult |
|
| 523 |
,ClientRemarks |
|
| 524 |
,DTIsGateWay |
|
| 525 |
,DTIsImport |
|
| 526 |
,DTIsRegSystem |
|
| 527 |
,DTRemarks |
|
| 528 |
) |
|
| 529 |
values |
|
| 530 |
( |
|
| 531 |
lower(newid()) |
|
| 532 |
,sc.DocumentNo |
|
| 533 |
,case when isnull(sc.RevisonNo,'')='' then '0' else sc.RevisonNo end |
|
| 534 |
,sc.System |
|
| 535 |
,sc.SubSystemCode |
|
| 536 |
,sc.RefProjectCode |
|
| 537 |
,sc.JobLevel |
|
| 538 |
,sc.PersonInCharge |
|
| 539 |
,getdate() |
|
| 540 |
,sc.RegisteredUser |
|
| 541 |
,sc.ToIsDiscussion |
|
| 542 |
,sc.ToRemarks |
|
| 543 |
,sc.ToCreator |
|
| 544 |
,sc.FrReviewStatus |
|
| 545 |
,sc.FrRemarks |
|
| 546 |
,sc.FrCreator |
|
| 547 |
,sc.ID2StartDate |
|
| 548 |
,sc.ID2EndDate |
|
| 549 |
,sc.ID2Status |
|
| 550 |
,sc.ID2Issues |
|
| 551 |
,sc.ReplyModifications |
|
| 552 |
,sc.ReplyRequester |
|
| 553 |
,sc.IsConvert |
|
| 554 |
,sc.AVEVAPersonInCharge |
|
| 555 |
,sc.AVEVAWorker |
|
| 556 |
,sc.AVEVAConvertDate |
|
| 557 |
,sc.AVEVAReviewDate |
|
| 558 |
,sc.AVEVAWorkDate |
|
| 559 |
,sc.AVEVAStatus |
|
| 560 |
,sc.AVEVAIssues |
|
| 561 |
,sc.ProdReviewer |
|
| 562 |
,sc.ProdIsResult |
|
| 563 |
,sc.ProdRemarks |
|
| 564 |
,sc.ClientReviewer |
|
| 565 |
,sc.ClientIsResult |
|
| 566 |
,sc.ClientRemarks |
|
| 567 |
,sc.DTIsGateWay |
|
| 568 |
,sc.DTIsImport |
|
| 569 |
,sc.DTIsRegSystem |
|
| 570 |
,sc.DTRemarks |
|
| 571 |
) |
|
| 572 |
output $action;"; |
|
| 573 |
//base.Query QueryFirstOrDefault<string>(query, docList, transaction); |
|
| 574 |
//var test = base.Query<string>(query, docList); |
|
| 575 |
var test = base.QueryFirstOrDefault<string>(query, docList); |
|
| 576 |
} |
|
| 577 |
*/ |
|
| 578 |
#endregion |
|
| 579 |
|
|
| 580 | 343 |
using (var transaction = base.BeginTransaction()) |
| 581 | 344 |
{
|
| 582 | 345 |
string query = string.Empty; |
| ... | ... | |
| 594 | 357 |
|
| 595 | 358 |
parameters.Add("DeletedUser", userId);
|
| 596 | 359 |
|
| 597 |
var limitDwgNos = delDocList.Skip(paramMaxCount * i).Take(paramMaxCount).Select(x => x.DocID).ToList();
|
|
| 360 |
var limitDwgNos = delDocList.Skip(paramMaxCount * i).Take(paramMaxCount).ToList(); |
|
| 598 | 361 |
sbWhere.Append($@" and DocID in @limitDwgNos "); |
| 599 | 362 |
parameters.Add("limitDwgNos", limitDwgNos);
|
| 600 | 363 |
|
| ... | ... | |
| 774 | 537 |
select '' |
| 775 | 538 |
end |
| 776 | 539 |
end"; |
| 777 |
#region 기존 입력 쿼리 주석 |
|
| 778 |
/* |
|
| 779 |
query = $@" |
|
| 780 |
declare @tbdoc table(docid varchar(36)) |
|
| 781 |
insert into dbo.Documents |
|
| 782 |
( |
|
| 783 |
DocID |
|
| 784 |
,DocumentNo |
|
| 785 |
,RevisonNo |
|
| 786 |
,System |
|
| 787 |
,SubSystemCode |
|
| 788 |
,RefProjectCode |
|
| 789 |
,JobLevel |
|
| 790 |
,PersonInCharge |
|
| 791 |
,RegisteredDate |
|
| 792 |
,RegisteredUser |
|
| 793 |
,ToIsDiscussion |
|
| 794 |
,ToRemarks |
|
| 795 |
,ToCreator |
|
| 796 |
,FrReviewStatus |
|
| 797 |
,FrRemarks |
|
| 798 |
,FrCreator |
|
| 799 |
,ID2StartDate |
|
| 800 |
,ID2EndDate |
|
| 801 |
,ID2Status |
|
| 802 |
,ID2Issues |
|
| 803 |
,ReplyModifications |
|
| 804 |
,ReplyRequester |
|
| 805 |
,IsConvert |
|
| 806 |
,AVEVAPersonInCharge |
|
| 807 |
,AVEVAWorker |
|
| 808 |
,AVEVAConvertDate |
|
| 809 |
,AVEVAReviewDate |
|
| 810 |
,AVEVAWorkDate |
|
| 811 |
,AVEVAStatus |
|
| 812 |
,AVEVAIssues |
|
| 813 |
,ProdReviewer |
|
| 814 |
,ProdIsResult |
|
| 815 |
,ProdRemarks |
|
| 816 |
,ClientReviewer |
|
| 817 |
,ClientIsResult |
|
| 818 |
,ClientRemarks |
|
| 819 |
,DTIsGateWay |
|
| 820 |
,DTIsImport |
|
| 821 |
,DTIsRegSystem |
|
| 822 |
,DTRemarks |
|
| 823 |
) |
|
| 824 |
output inserted.DocID into @tbdoc |
|
| 825 |
values |
|
| 826 |
( |
|
| 827 |
lower(newid()) |
|
| 828 |
,@DocumentNo |
|
| 829 |
,case when isnull(@RevisonNo,'')='' then '0' else @RevisonNo end |
|
| 830 |
,@System |
|
| 831 |
,@SubSystemCode |
|
| 832 |
,@RefProjectCode |
|
| 833 |
,@JobLevel |
|
| 834 |
,@PersonInCharge |
|
| 835 |
,getdate() |
|
| 836 |
,@RegisteredUser |
|
| 837 |
,@ToIsDiscussion |
|
| 838 |
,@ToRemarks |
|
| 839 |
,@ToCreator |
|
| 840 |
,@FrReviewStatus |
|
| 841 |
,@FrRemarks |
|
| 842 |
,@FrCreator |
|
| 843 |
,@ID2StartDate |
|
| 844 |
,@ID2EndDate |
|
| 845 |
,@ID2Status |
|
| 846 |
,@ID2Issues |
|
| 847 |
,@ReplyModifications |
|
| 848 |
,@ReplyRequester |
|
| 849 |
,@IsConvert |
|
| 850 |
,@AVEVAPersonInCharge |
|
| 851 |
,@AVEVAWorker |
|
| 852 |
,@AVEVAConvertDate |
|
| 853 |
,@AVEVAReviewDate |
|
| 854 |
,@AVEVAWorkDate |
|
| 855 |
,@AVEVAStatus |
|
| 856 |
,@AVEVAIssues |
|
| 857 |
,@ProdReviewer |
|
| 858 |
,@ProdIsResult |
|
| 859 |
,@ProdRemarks |
|
| 860 |
,@ClientReviewer |
|
| 861 |
,@ClientIsResult |
|
| 862 |
,@ClientRemarks |
|
| 863 |
,@DTIsGateWay |
|
| 864 |
,@DTIsImport |
|
| 865 |
,@DTIsRegSystem |
|
| 866 |
,@DTRemarks |
|
| 867 |
) |
|
| 868 |
|
|
| 869 |
if @@rowcount > 0 |
|
| 870 |
begin |
|
| 871 |
select docid from @tbdoc |
|
| 872 |
end |
|
| 873 |
else |
|
| 874 |
begin |
|
| 875 |
select '' |
|
| 876 |
end;"; |
|
| 877 |
*/ |
|
| 878 |
#endregion |
|
| 879 | 540 |
} |
| 880 | 541 |
else |
| 881 | 542 |
{
|
내보내기 Unified diff
