개정판 993feace
issue #0000
document list 저장 로직 수정 진행중
Change-Id: I8fef1f1695bee0da0dc222b9e25093dda2eb908a
| ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
|---|---|---|
| 328 | 328 |
return existCount; |
| 329 | 329 |
} |
| 330 | 330 |
|
| 331 |
public bool SetDocumentData(List<Documents> docList, List<Documents> delDocList, string userId) |
|
| 331 |
public bool SetDocumentData(string projectGroupID, List<Documents> docList, List<Documents> delDocList, string userId)
|
|
| 332 | 332 |
{
|
| 333 | 333 |
bool isSuccess = false; |
| 334 | 334 |
|
| 335 | 335 |
try |
| 336 | 336 |
{
|
| 337 |
|
|
| 338 |
#region merge 주석처리 |
|
| 339 |
/* |
|
| 340 |
{
|
|
| 341 |
docList.ForEach(x => |
|
| 342 |
{
|
|
| 343 |
x.RegisteredUser = userId; |
|
| 344 |
x.ModifiedUser = userId; |
|
| 345 |
}); |
|
| 346 |
string query = $@" |
|
| 347 |
merge into dbo.Documents as tg |
|
| 348 |
using |
|
| 349 |
( |
|
| 350 |
values |
|
| 351 |
( |
|
| 352 |
@DocumentNo |
|
| 353 |
,@RevisonNo |
|
| 354 |
,@System |
|
| 355 |
,@SubSystemCode |
|
| 356 |
,@RefProjectCode |
|
| 357 |
,@JobLevel |
|
| 358 |
,@PersonInCharge |
|
| 359 |
,@RegisteredUser |
|
| 360 |
,@ModifiedUser |
|
| 361 |
,@ToIsDiscussion |
|
| 362 |
,@ToRemarks |
|
| 363 |
,@ToCreator |
|
| 364 |
,@FrReviewStatus |
|
| 365 |
,@FrRemarks |
|
| 366 |
,@FrCreator |
|
| 367 |
,@ID2StartDate |
|
| 368 |
,@ID2EndDate |
|
| 369 |
,@ID2Status |
|
| 370 |
,@ID2Issues |
|
| 371 |
,@ReplyModifications |
|
| 372 |
,@ReplyRequester |
|
| 373 |
,@IsConvert |
|
| 374 |
,@AVEVAPersonInCharge |
|
| 375 |
,@AVEVAWorker |
|
| 376 |
,@AVEVAConvertDate |
|
| 377 |
,@AVEVAReviewDate |
|
| 378 |
,@AVEVAWorkDate |
|
| 379 |
,@AVEVAStatus |
|
| 380 |
,@AVEVAIssues |
|
| 381 |
,@ProdReviewer |
|
| 382 |
,@ProdIsResult |
|
| 383 |
,@ProdRemarks |
|
| 384 |
,@ClientReviewer |
|
| 385 |
,@ClientIsResult |
|
| 386 |
,@ClientRemarks |
|
| 387 |
,@DTIsGateWay |
|
| 388 |
,@DTIsImport |
|
| 389 |
,@DTIsRegSystem |
|
| 390 |
,@DTRemarks |
|
| 391 |
) |
|
| 392 |
) as sc |
|
| 393 |
( |
|
| 394 |
DocumentNo |
|
| 395 |
,RevisonNo |
|
| 396 |
,[System] |
|
| 397 |
,SubSystemCode |
|
| 398 |
,RefProjectCode |
|
| 399 |
,JobLevel |
|
| 400 |
,PersonInCharge |
|
| 401 |
,RegisteredUser |
|
| 402 |
,ModifiedUser |
|
| 403 |
,ToIsDiscussion |
|
| 404 |
,ToRemarks |
|
| 405 |
,ToCreator |
|
| 406 |
,FrReviewStatus |
|
| 407 |
,FrRemarks |
|
| 408 |
,FrCreator |
|
| 409 |
,ID2StartDate |
|
| 410 |
,ID2EndDate |
|
| 411 |
,ID2Status |
|
| 412 |
,ID2Issues |
|
| 413 |
,ReplyModifications |
|
| 414 |
,ReplyRequester |
|
| 415 |
,IsConvert |
|
| 416 |
,AVEVAPersonInCharge |
|
| 417 |
,AVEVAWorker |
|
| 418 |
,AVEVAConvertDate |
|
| 419 |
,AVEVAReviewDate |
|
| 420 |
,AVEVAWorkDate |
|
| 421 |
,AVEVAStatus |
|
| 422 |
,AVEVAIssues |
|
| 423 |
,ProdReviewer |
|
| 424 |
,ProdIsResult |
|
| 425 |
,ProdRemarks |
|
| 426 |
,ClientReviewer |
|
| 427 |
,ClientIsResult |
|
| 428 |
,ClientRemarks |
|
| 429 |
,DTIsGateWay |
|
| 430 |
,DTIsImport |
|
| 431 |
,DTIsRegSystem |
|
| 432 |
,DTRemarks |
|
| 433 |
) |
|
| 434 |
ON sc.DocumentNo=tg.DocumentNo |
|
| 435 |
when matched and tg.IsDeleted=0 then |
|
| 436 |
|
|
| 437 |
update |
|
| 438 |
set tg.DocumentNo=sc.DocumentNo |
|
| 439 |
,tg.RevisonNo=sc.RevisonNo |
|
| 440 |
,tg.[System]=sc.[System] |
|
| 441 |
,tg.SubSystemCode=sc.SubSystemCode |
|
| 442 |
,tg.RefProjectCode=sc.RefProjectCode |
|
| 443 |
,tg.JobLevel=sc.JobLevel |
|
| 444 |
,tg.PersonInCharge=sc.PersonInCharge |
|
| 445 |
,tg.ModifiedDate=getdate() |
|
| 446 |
,tg.ModifiedUser=sc.ModifiedUser |
|
| 447 |
,tg.ToIsDiscussion=sc.ToIsDiscussion |
|
| 448 |
,tg.ToRemarks=sc.ToRemarks |
|
| 449 |
,tg.ToCreator=sc.ToCreator |
|
| 450 |
,tg.FrReviewStatus=sc.FrReviewStatus |
|
| 451 |
,tg.FrRemarks=sc.FrRemarks |
|
| 452 |
,tg.FrCreator=sc.FrCreator |
|
| 453 |
,tg.ID2StartDate=sc.ID2StartDate |
|
| 454 |
,tg.ID2EndDate=sc.ID2EndDate |
|
| 455 |
,tg.ID2Status=sc.ID2Status |
|
| 456 |
,tg.ID2Issues=sc.ID2Issues |
|
| 457 |
,tg.ReplyModifications=sc.ReplyModifications |
|
| 458 |
,tg.ReplyRequester=sc.ReplyRequester |
|
| 459 |
,tg.IsConvert=sc.IsConvert |
|
| 460 |
,tg.AVEVAPersonInCharge=sc.AVEVAPersonInCharge |
|
| 461 |
,tg.AVEVAWorker=sc.AVEVAWorker |
|
| 462 |
,tg.AVEVAConvertDate=sc.AVEVAConvertDate |
|
| 463 |
,tg.AVEVAReviewDate=sc.AVEVAReviewDate |
|
| 464 |
,tg.AVEVAWorkDate=sc.AVEVAWorkDate |
|
| 465 |
,tg.AVEVAStatus=sc.AVEVAStatus |
|
| 466 |
,tg.AVEVAIssues=sc.AVEVAIssues |
|
| 467 |
,tg.ProdReviewer=sc.ProdReviewer |
|
| 468 |
,tg.ProdIsResult=sc.ProdIsResult |
|
| 469 |
,tg.ProdRemarks=sc.ProdRemarks |
|
| 470 |
,tg.ClientReviewer=sc.ClientReviewer |
|
| 471 |
,tg.ClientIsResult=sc.ClientIsResult |
|
| 472 |
,tg.ClientRemarks=sc.ClientRemarks |
|
| 473 |
,tg.DTIsGateWay=sc.DTIsGateWay |
|
| 474 |
,tg.DTIsImport=sc.DTIsImport |
|
| 475 |
,tg.DTIsRegSystem=sc.DTIsRegSystem |
|
| 476 |
,tg.DTRemarks=sc.DTRemarks |
|
| 477 |
when not matched then |
|
| 478 |
|
|
| 479 |
|
|
| 480 |
insert |
|
| 481 |
( |
|
| 482 |
DocID |
|
| 483 |
,DocumentNo |
|
| 484 |
,RevisonNo |
|
| 485 |
,[System] |
|
| 486 |
,SubSystemCode |
|
| 487 |
,RefProjectCode |
|
| 488 |
,JobLevel |
|
| 489 |
,PersonInCharge |
|
| 490 |
,RegisteredDate |
|
| 491 |
,RegisteredUser |
|
| 492 |
,ToIsDiscussion |
|
| 493 |
,ToRemarks |
|
| 494 |
,ToCreator |
|
| 495 |
,FrReviewStatus |
|
| 496 |
,FrRemarks |
|
| 497 |
,FrCreator |
|
| 498 |
,ID2StartDate |
|
| 499 |
,ID2EndDate |
|
| 500 |
,ID2Status |
|
| 501 |
,ID2Issues |
|
| 502 |
,ReplyModifications |
|
| 503 |
,ReplyRequester |
|
| 504 |
,IsConvert |
|
| 505 |
,AVEVAPersonInCharge |
|
| 506 |
,AVEVAWorker |
|
| 507 |
,AVEVAConvertDate |
|
| 508 |
,AVEVAReviewDate |
|
| 509 |
,AVEVAWorkDate |
|
| 510 |
,AVEVAStatus |
|
| 511 |
,AVEVAIssues |
|
| 512 |
,ProdReviewer |
|
| 513 |
,ProdIsResult |
|
| 514 |
,ProdRemarks |
|
| 515 |
,ClientReviewer |
|
| 516 |
,ClientIsResult |
|
| 517 |
,ClientRemarks |
|
| 518 |
,DTIsGateWay |
|
| 519 |
,DTIsImport |
|
| 520 |
,DTIsRegSystem |
|
| 521 |
,DTRemarks |
|
| 522 |
) |
|
| 523 |
values |
|
| 524 |
( |
|
| 525 |
lower(newid()) |
|
| 526 |
,sc.DocumentNo |
|
| 527 |
,case when isnull(sc.RevisonNo,'')='' then '0' else sc.RevisonNo end |
|
| 528 |
,sc.System |
|
| 529 |
,sc.SubSystemCode |
|
| 530 |
,sc.RefProjectCode |
|
| 531 |
,sc.JobLevel |
|
| 532 |
,sc.PersonInCharge |
|
| 533 |
,getdate() |
|
| 534 |
,sc.RegisteredUser |
|
| 535 |
,sc.ToIsDiscussion |
|
| 536 |
,sc.ToRemarks |
|
| 537 |
,sc.ToCreator |
|
| 538 |
,sc.FrReviewStatus |
|
| 539 |
,sc.FrRemarks |
|
| 540 |
,sc.FrCreator |
|
| 541 |
,sc.ID2StartDate |
|
| 542 |
,sc.ID2EndDate |
|
| 543 |
,sc.ID2Status |
|
| 544 |
,sc.ID2Issues |
|
| 545 |
,sc.ReplyModifications |
|
| 546 |
,sc.ReplyRequester |
|
| 547 |
,sc.IsConvert |
|
| 548 |
,sc.AVEVAPersonInCharge |
|
| 549 |
,sc.AVEVAWorker |
|
| 550 |
,sc.AVEVAConvertDate |
|
| 551 |
,sc.AVEVAReviewDate |
|
| 552 |
,sc.AVEVAWorkDate |
|
| 553 |
,sc.AVEVAStatus |
|
| 554 |
,sc.AVEVAIssues |
|
| 555 |
,sc.ProdReviewer |
|
| 556 |
,sc.ProdIsResult |
|
| 557 |
,sc.ProdRemarks |
|
| 558 |
,sc.ClientReviewer |
|
| 559 |
,sc.ClientIsResult |
|
| 560 |
,sc.ClientRemarks |
|
| 561 |
,sc.DTIsGateWay |
|
| 562 |
,sc.DTIsImport |
|
| 563 |
,sc.DTIsRegSystem |
|
| 564 |
,sc.DTRemarks |
|
| 565 |
) |
|
| 566 |
output $action;"; |
|
| 567 |
//base.Query QueryFirstOrDefault<string>(query, docList, transaction); |
|
| 568 |
//var test = base.Query<string>(query, docList); |
|
| 569 |
var test = base.QueryFirstOrDefault<string>(query, docList); |
|
| 570 |
} |
|
| 571 |
*/ |
|
| 572 |
#endregion |
|
| 573 |
|
|
| 337 | 574 |
using (var transaction = base.BeginTransaction()) |
| 338 | 575 |
{
|
| 339 | 576 |
string query = string.Empty; |
| 340 | 577 |
|
| 341 | 578 |
if (delDocList.Count > 0) |
| 342 | 579 |
{
|
| 343 |
string docIDList = string.Join("','", delDocList.Where(x => !string.IsNullOrEmpty(x.DocID)).Select(x => x.DocID).ToList());
|
|
| 580 |
int paramMaxCount = 2000; |
|
| 581 |
int execCount = (delDocList.Count / paramMaxCount) + 1; |
|
| 344 | 582 |
|
| 345 |
if (docIDList.Length > 0)
|
|
| 583 |
for (int i = 0; i < execCount; i++)
|
|
| 346 | 584 |
{
|
| 585 |
var dynamicParameters = new DynamicParameters(); |
|
| 586 |
StringBuilder sbWhere = new StringBuilder(); |
|
| 587 |
var parameters = new Dictionary<string, object>(); |
|
| 588 |
|
|
| 589 |
parameters.Add("DeletedUser", userId);
|
|
| 590 |
|
|
| 591 |
var limitDwgNos = delDocList.Skip(paramMaxCount * i).Take(paramMaxCount).Select(x => x.DocID).ToList(); |
|
| 592 |
sbWhere.Append($@" DocID in @limitDwgNos "); |
|
| 593 |
parameters.Add("limitDwgNos", limitDwgNos);
|
|
| 594 |
|
|
| 347 | 595 |
query = $@" |
| 348 | 596 |
update dbo.Documents |
| 349 | 597 |
set IsDeleted=1 |
| 350 |
,DeletedDate=getdate(),
|
|
| 598 |
,DeletedDate=getdate() |
|
| 351 | 599 |
,DeletedUser=@DeletedUser |
| 352 |
where DocID in ('{docIDList}');";
|
|
| 353 |
base.Execute(query, new { DeletedUser = userId }, transaction);
|
|
| 600 |
where {sbWhere}";
|
|
| 601 |
if (parameters.Count > 0) |
|
| 602 |
{
|
|
| 603 |
dynamicParameters.AddDynamicParams(parameters); |
|
| 604 |
} |
|
| 605 |
|
|
| 606 |
base.Execute(query, dynamicParameters, transaction); |
|
| 354 | 607 |
} |
| 355 | 608 |
} |
| 356 | 609 |
|
| ... | ... | |
| 359 | 612 |
if (string.IsNullOrEmpty(doc.DocID)) |
| 360 | 613 |
{
|
| 361 | 614 |
doc.RegisteredUser = userId; |
| 615 |
doc.ModifiedUser = userId; |
|
| 616 |
|
|
| 617 |
query = $@" |
|
| 618 |
if exists(select * from dbo.Documents where RefProjectCode=@RefProjectCode and DocumentNo=@DocumentNo) |
|
| 619 |
begin |
|
| 620 |
--update |
|
| 621 |
update dbo.Documents |
|
| 622 |
set RevisonNo=case when isnull(@RevisonNo,'')='' then '0' else @RevisonNo end |
|
| 623 |
,System=@System |
|
| 624 |
,SubSystemCode=@SubSystemCode |
|
| 625 |
,JobLevel=@JobLevel |
|
| 626 |
,PersonInCharge=@PersonInCharge |
|
| 627 |
,ModifiedDate=getdate() |
|
| 628 |
,ModifiedUser=@ModifiedUser |
|
| 629 |
,ToIsDiscussion=@ToIsDiscussion |
|
| 630 |
,ToRemarks=@ToRemarks |
|
| 631 |
,ToCreator=@ToCreator |
|
| 632 |
,FrReviewStatus=@FrReviewStatus |
|
| 633 |
,FrRemarks=@FrRemarks |
|
| 634 |
,FrCreator=@FrCreator |
|
| 635 |
,ID2StartDate=@ID2StartDate |
|
| 636 |
,ID2EndDate=@ID2EndDate |
|
| 637 |
,ID2Status=@ID2Status |
|
| 638 |
,ID2Issues=@ID2Issues |
|
| 639 |
,ReplyModifications=@ReplyModifications |
|
| 640 |
,ReplyRequester=@ReplyRequester |
|
| 641 |
,IsConvert=@IsConvert |
|
| 642 |
,AVEVAPersonInCharge=@AVEVAPersonInCharge |
|
| 643 |
,AVEVAWorker=@AVEVAWorker |
|
| 644 |
,AVEVAConvertDate=@AVEVAConvertDate |
|
| 645 |
,AVEVAReviewDate=@AVEVAReviewDate |
|
| 646 |
,AVEVAWorkDate=@AVEVAWorkDate |
|
| 647 |
,AVEVAStatus=@AVEVAStatus |
|
| 648 |
,AVEVAIssues=@AVEVAIssues |
|
| 649 |
,ProdReviewer=@ProdReviewer |
|
| 650 |
,ProdIsResult=@ProdIsResult |
|
| 651 |
,ProdRemarks=@ProdRemarks |
|
| 652 |
,ClientReviewer=@ClientReviewer |
|
| 653 |
,ClientIsResult=@ClientIsResult |
|
| 654 |
,ClientRemarks=@ClientRemarks |
|
| 655 |
,DTIsGateWay=@DTIsGateWay |
|
| 656 |
,DTIsImport=@DTIsImport |
|
| 657 |
,DTIsRegSystem=@DTIsRegSystem |
|
| 658 |
,DTRemarks=@DTRemarks |
|
| 659 |
where RefProjectCode=@RefProjectCode and DocumentNo=@DocumentNo |
|
| 660 |
|
|
| 661 |
if @@rowcount > 0 |
|
| 662 |
begin |
|
| 663 |
select '' |
|
| 664 |
end |
|
| 665 |
else |
|
| 666 |
begin |
|
| 667 |
select '' |
|
| 668 |
end |
|
| 669 |
end |
|
| 670 |
else |
|
| 671 |
begin |
|
| 672 |
--insert |
|
| 673 |
declare @tbdoc table(docid varchar(36)) |
|
| 674 |
insert into dbo.Documents |
|
| 675 |
( |
|
| 676 |
DocID |
|
| 677 |
,DocumentNo |
|
| 678 |
,RevisonNo |
|
| 679 |
,System |
|
| 680 |
,SubSystemCode |
|
| 681 |
,RefProjectCode |
|
| 682 |
,JobLevel |
|
| 683 |
,PersonInCharge |
|
| 684 |
,RegisteredDate |
|
| 685 |
,RegisteredUser |
|
| 686 |
,ToIsDiscussion |
|
| 687 |
,ToRemarks |
|
| 688 |
,ToCreator |
|
| 689 |
,FrReviewStatus |
|
| 690 |
,FrRemarks |
|
| 691 |
,FrCreator |
|
| 692 |
,ID2StartDate |
|
| 693 |
,ID2EndDate |
|
| 694 |
,ID2Status |
|
| 695 |
,ID2Issues |
|
| 696 |
,ReplyModifications |
|
| 697 |
,ReplyRequester |
|
| 698 |
,IsConvert |
|
| 699 |
,AVEVAPersonInCharge |
|
| 700 |
,AVEVAWorker |
|
| 701 |
,AVEVAConvertDate |
|
| 702 |
,AVEVAReviewDate |
|
| 703 |
,AVEVAWorkDate |
|
| 704 |
,AVEVAStatus |
|
| 705 |
,AVEVAIssues |
|
| 706 |
,ProdReviewer |
|
| 707 |
,ProdIsResult |
|
| 708 |
,ProdRemarks |
|
| 709 |
,ClientReviewer |
|
| 710 |
,ClientIsResult |
|
| 711 |
,ClientRemarks |
|
| 712 |
,DTIsGateWay |
|
| 713 |
,DTIsImport |
|
| 714 |
,DTIsRegSystem |
|
| 715 |
,DTRemarks |
|
| 716 |
) |
|
| 717 |
output inserted.DocID into @tbdoc |
|
| 718 |
values |
|
| 719 |
( |
|
| 720 |
lower(newid()) |
|
| 721 |
,@DocumentNo |
|
| 722 |
,case when isnull(@RevisonNo,'')='' then '0' else @RevisonNo end |
|
| 723 |
,@System |
|
| 724 |
,@SubSystemCode |
|
| 725 |
,@RefProjectCode |
|
| 726 |
,@JobLevel |
|
| 727 |
,@PersonInCharge |
|
| 728 |
,getdate() |
|
| 729 |
,@RegisteredUser |
|
| 730 |
,@ToIsDiscussion |
|
| 731 |
,@ToRemarks |
|
| 732 |
,@ToCreator |
|
| 733 |
,@FrReviewStatus |
|
| 734 |
,@FrRemarks |
|
| 735 |
,@FrCreator |
|
| 736 |
,@ID2StartDate |
|
| 737 |
,@ID2EndDate |
|
| 738 |
,@ID2Status |
|
| 739 |
,@ID2Issues |
|
| 740 |
,@ReplyModifications |
|
| 741 |
,@ReplyRequester |
|
| 742 |
,@IsConvert |
|
| 743 |
,@AVEVAPersonInCharge |
|
| 744 |
,@AVEVAWorker |
|
| 745 |
,@AVEVAConvertDate |
|
| 746 |
,@AVEVAReviewDate |
|
| 747 |
,@AVEVAWorkDate |
|
| 748 |
,@AVEVAStatus |
|
| 749 |
,@AVEVAIssues |
|
| 750 |
,@ProdReviewer |
|
| 751 |
,@ProdIsResult |
|
| 752 |
,@ProdRemarks |
|
| 753 |
,@ClientReviewer |
|
| 754 |
,@ClientIsResult |
|
| 755 |
,@ClientRemarks |
|
| 756 |
,@DTIsGateWay |
|
| 757 |
,@DTIsImport |
|
| 758 |
,@DTIsRegSystem |
|
| 759 |
,@DTRemarks |
|
| 760 |
) |
|
| 761 |
|
|
| 762 |
if @@rowcount > 0 |
|
| 763 |
begin |
|
| 764 |
select docid from @tbdoc |
|
| 765 |
end |
|
| 766 |
else |
|
| 767 |
begin |
|
| 768 |
select '' |
|
| 769 |
end |
|
| 770 |
end"; |
|
| 771 |
#region 기존 입력 쿼리 주석 |
|
| 772 |
/* |
|
| 362 | 773 |
query = $@" |
| 363 | 774 |
declare @tbdoc table(docid varchar(36)) |
| 364 | 775 |
insert into dbo.Documents |
| ... | ... | |
| 457 | 868 |
begin |
| 458 | 869 |
select '' |
| 459 | 870 |
end;"; |
| 871 |
*/ |
|
| 872 |
#endregion |
|
| 460 | 873 |
} |
| 461 | 874 |
else |
| 462 | 875 |
{
|
| ... | ... | |
| 464 | 877 |
query = $@" |
| 465 | 878 |
update dbo.Documents |
| 466 | 879 |
set DocumentNo=@DocumentNo |
| 467 |
,RevisonNo=@RevisonNo
|
|
| 880 |
,RevisonNo=case when isnull(@RevisonNo,'')='' then '0' else @RevisonNo end
|
|
| 468 | 881 |
,System=@System |
| 469 | 882 |
,SubSystemCode=@SubSystemCode |
| 470 | 883 |
,RefProjectCode=@RefProjectCode |
내보내기 Unified diff
