개정판 be38bb2e
issue #0000
유사도2 추가
- 조회,수정,삭제,model,excel(import,export),ui
Change-Id: Iae5e69b4f602310b23dea9b3cdd56a90bbac2f5d
| ID2.Manager/ID2.Manager.Common/Helpers/ID2Excel.cs | ||
|---|---|---|
| 493 | 493 |
{
|
| 494 | 494 |
try |
| 495 | 495 |
{
|
| 496 |
result.documents.Add(new Documents() |
|
| 497 |
{
|
|
| 496 |
int colIndex = 9; |
|
| 497 |
var docInfo = new Documents(); |
|
| 498 |
docInfo.RefProjectCode = ws.Rows[p.Index].Cells[colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 499 |
docInfo.System = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 500 |
docInfo.SubSystemCode = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 501 |
docInfo.DocumentNo = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 502 |
docInfo.PersonInCharge = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 503 |
docInfo.Worker = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 504 |
docInfo.AVEVAPersonInCharge = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 505 |
docInfo.AVEVAWorker = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 506 |
docInfo.Simularity = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 507 |
docInfo.Simularity2 = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 508 |
docInfo.JobLevel = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 509 |
docInfo.RevisonNo = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 510 |
docInfo.ToIsDiscussion = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 511 |
docInfo.ToRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 512 |
docInfo.ToCreator = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 513 |
++colIndex;//toreview-24 |
|
| 514 |
docInfo.FrReviewStatus = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 515 |
docInfo.FrRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 516 |
docInfo.FrCreator = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 517 |
++colIndex;//frreview-28 |
|
| 518 |
docInfo.ID2StartDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value?.ToString()); |
|
| 519 |
docInfo.ID2EndDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value?.ToString()); |
|
| 520 |
docInfo.ID2Status = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 521 |
docInfo.ID2Issues = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 522 |
++colIndex;//id2work-33 |
|
| 523 |
docInfo.ReplyModifications = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 524 |
docInfo.ReplyRequester = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 525 |
docInfo.IsConvert = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 526 |
docInfo.AVEVAConvertDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value.ToString()); |
|
| 527 |
docInfo.AVEVAWorkDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value.ToString()); |
|
| 528 |
docInfo.AVEVAStatus = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 529 |
docInfo.AVEVAIssues = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 530 |
docInfo.AVEVAReviewDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value.ToString()); |
|
| 531 |
docInfo.ProdReviewer = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 532 |
docInfo.ProdIsResult = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 533 |
docInfo.ProdRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 534 |
docInfo.ClientReviewer = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID; |
|
| 535 |
docInfo.ClientIsResult = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 536 |
docInfo.ClientRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 537 |
docInfo.DTIsGateWay = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 538 |
docInfo.DTIsImport = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 539 |
docInfo.DTIsRegSystem = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 540 |
docInfo.DTRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString(); |
|
| 541 |
result.documents.Add(docInfo); |
|
| 542 |
|
|
| 543 |
//result.documents.Add(new Documents() |
|
| 544 |
//{
|
|
| 545 |
/* |
|
| 498 | 546 |
RefProjectCode = ws.Rows[p.Index].Cells[9].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[9].Value.ToString(), |
| 499 | 547 |
System = ws.Rows[p.Index].Cells[10].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[10].Value.ToString(), |
| 500 | 548 |
SubSystemCode = ws.Rows[p.Index].Cells[11].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[11].Value.ToString(), |
| ... | ... | |
| 537 | 585 |
DTIsImport = ws.Rows[p.Index].Cells[48].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[48].Value.ToString(), |
| 538 | 586 |
DTIsRegSystem = ws.Rows[p.Index].Cells[49].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[49].Value.ToString(), |
| 539 | 587 |
DTRemarks = ws.Rows[p.Index].Cells[50].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[50].Value.ToString() |
| 588 |
*/ |
|
| 540 | 589 |
|
| 541 | 590 |
/* |
| 542 | 591 |
//UID = string.Empty, |
| ... | ... | |
| 586 | 635 |
DTIsRegSystem = ws.Rows[p.Index].Cells[43].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[43].Value.ToString(), |
| 587 | 636 |
DTRemarks = ws.Rows[p.Index].Cells[44].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[44].Value.ToString() |
| 588 | 637 |
*/ |
| 589 |
}); |
|
| 638 |
//});
|
|
| 590 | 639 |
} |
| 591 | 640 |
catch (Exception ex) |
| 592 | 641 |
{
|
| ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
|---|---|---|
| 406 | 406 |
,SubSystemCode=@SubSystemCode |
| 407 | 407 |
,JobLevel=@JobLevel |
| 408 | 408 |
,Simularity=@Simularity |
| 409 |
,Simularity2=@Simularity2 |
|
| 409 | 410 |
,PersonInCharge=@PersonInCharge |
| 410 | 411 |
,Worker=@Worker |
| 411 | 412 |
,ModifiedDate=getdate() |
| ... | ... | |
| 465 | 466 |
,RefProjectCode |
| 466 | 467 |
,JobLevel |
| 467 | 468 |
,Simularity |
| 469 |
,Simularity2 |
|
| 468 | 470 |
,PersonInCharge |
| 469 | 471 |
,Worker |
| 470 | 472 |
,RegisteredDate |
| ... | ... | |
| 511 | 513 |
,@RefProjectCode |
| 512 | 514 |
,@JobLevel |
| 513 | 515 |
,@Simularity |
| 516 |
,@Simularity2 |
|
| 514 | 517 |
,@PersonInCharge |
| 515 | 518 |
,@Worker |
| 516 | 519 |
,getdate() |
| ... | ... | |
| 568 | 571 |
,RefProjectCode=@RefProjectCode |
| 569 | 572 |
,JobLevel=@JobLevel |
| 570 | 573 |
,Simularity=@Simularity |
| 574 |
,Simularity2=@Simularity2 |
|
| 571 | 575 |
,PersonInCharge=@PersonInCharge |
| 572 | 576 |
,Worker=@Worker |
| 573 | 577 |
,ModifiedDate=getdate() |
| ID2.Manager/ID2.Manager.Data/Models/Documents.cs | ||
|---|---|---|
| 36 | 36 |
set => SetProperty(ref this._Simularity, value); |
| 37 | 37 |
} |
| 38 | 38 |
|
| 39 |
private string _Simularity2 = null; |
|
| 40 |
public string Simularity2 |
|
| 41 |
{
|
|
| 42 |
get => this._Simularity2; |
|
| 43 |
set => SetProperty(ref this._Simularity2, value); |
|
| 44 |
} |
|
| 45 |
|
|
| 39 | 46 |
private string _RefProjectCode = string.Empty; |
| 40 | 47 |
//[DataMember] |
| 41 | 48 |
public string RefProjectCode |
| ... | ... | |
| 281 | 288 |
if (this.RefProjectCode != other.RefProjectCode) return false; |
| 282 | 289 |
if (this.JobLevel != other.JobLevel) return false; |
| 283 | 290 |
if (this.Simularity != other.Simularity) return false; |
| 291 |
if (this.Simularity2 != other.Simularity2) return false; |
|
| 284 | 292 |
if (this.PersonInCharge != other.PersonInCharge) return false; |
| 285 | 293 |
if (this.Worker != other.Worker) return false; |
| 286 | 294 |
if (this.ToIsDiscussion != other.ToIsDiscussion) return false; |
| ... | ... | |
| 351 | 359 |
public override int GetHashCode() |
| 352 | 360 |
{
|
| 353 | 361 |
return this.DocumentNo.GetNullableHash() + this.RevisonNo.GetNullableHash() + this.System.GetNullableHash() + this.SubSystemCode.GetNullableHash() |
| 354 |
+ this.RefProjectCode.GetNullableHash() + this.JobLevel.GetNullableHash() + this.Simularity.GetNullableHash() |
|
| 362 |
+ this.RefProjectCode.GetNullableHash() + this.JobLevel.GetNullableHash() + this.Simularity.GetNullableHash() + this.Simularity2.GetNullableHash()
|
|
| 355 | 363 |
+ this.PersonInCharge.GetNullableHash() + this.Worker.GetNullableHash() + this.ToIsDiscussion.GetNullableHash() + this.ToRemarks.GetNullableHash() |
| 356 | 364 |
+ this.ToCreator.GetNullableHash() |
| 357 | 365 |
+ this.FrReviewStatus.GetNullableHash() + this.FrRemarks.GetNullableHash() + this.FrCreator.GetNullableHash() |
| ... | ... | |
| 413 | 421 |
this.RefProjectCode = docData.RefProjectCode; |
| 414 | 422 |
this.JobLevel = docData.JobLevel; |
| 415 | 423 |
//this.Simularity = docData.Simularity; |
| 424 |
//this.Simularity2 = docData.Simularity2; |
|
| 416 | 425 |
this.PersonInCharge = docData.PersonInCharge; |
| 417 | 426 |
this.Worker = docData.Worker; |
| 418 | 427 |
this.ToIsDiscussion = docData.ToIsDiscussion; |
| ID2.Manager/ID2.Manager/Main.cs | ||
|---|---|---|
| 3013 | 3013 |
foreach (var row in this.radGridViewDocuments.MasterTemplate.DataView) |
| 3014 | 3014 |
{
|
| 3015 | 3015 |
var doc = row.DataBoundItem as Documents; |
| 3016 |
|
|
| 3017 |
templateWorksheet.Cells[rowIndex, 0].Value = rowNo++; |
|
| 3018 |
|
|
| 3019 |
templateWorksheet.Cells[rowIndex, 7].Value = doc.Team; |
|
| 3020 |
templateWorksheet.Cells[rowIndex, 8].Value = doc.RefProjectCode; |
|
| 3021 |
templateWorksheet.Cells[rowIndex, 9].Value = doc.System; |
|
| 3022 |
templateWorksheet.Cells[rowIndex, 10].Value = doc.SubSystemCode; |
|
| 3023 |
templateWorksheet.Cells[rowIndex, 11].Value = doc.DocumentNo; |
|
| 3024 |
templateWorksheet.Cells[rowIndex, 12].Value = this.GetUser(doc.PersonInCharge).Name; |
|
| 3025 |
templateWorksheet.Cells[rowIndex, 13].Value = this.GetUser(doc.Worker).Name; |
|
| 3026 |
templateWorksheet.Cells[rowIndex, 14].Value = this.GetUser(doc.AVEVAPersonInCharge).Name; |
|
| 3027 |
templateWorksheet.Cells[rowIndex, 15].Value = this.GetUser(doc.AVEVAWorker).Name; |
|
| 3028 |
templateWorksheet.Cells[rowIndex, 16].Value = doc.Simularity; |
|
| 3029 |
templateWorksheet.Cells[rowIndex, 17].Value = doc.JobLevel; |
|
| 3030 |
templateWorksheet.Cells[rowIndex, 18].Value = doc.RevisonNo; |
|
| 3031 |
templateWorksheet.Cells[rowIndex, 19].Value = doc.ToIsDiscussion; |
|
| 3032 |
templateWorksheet.Cells[rowIndex, 20].Value = doc.ToRemarks; |
|
| 3033 |
templateWorksheet.Cells[rowIndex, 21].Value = this.GetUser(doc.ToCreator).Name; |
|
| 3034 |
//toreview-22 |
|
| 3035 |
templateWorksheet.Cells[rowIndex, 23].Value = doc.FrReviewStatus; |
|
| 3036 |
templateWorksheet.Cells[rowIndex, 24].Value = doc.FrRemarks; |
|
| 3037 |
templateWorksheet.Cells[rowIndex, 25].Value = this.GetUser(doc.FrCreator).Name; |
|
| 3038 |
//frreview-26 |
|
| 3039 |
templateWorksheet.Cells[rowIndex, 27].Value = $"{doc.ID2StartDate:yyyy/MM/dd HH:mm:ss}";
|
|
| 3040 |
templateWorksheet.Cells[rowIndex, 28].Value = $"{doc.ID2EndDate:yyyy/MM/dd HH:mm:ss}";
|
|
| 3041 |
templateWorksheet.Cells[rowIndex, 29].Value = doc.ID2Status; |
|
| 3042 |
templateWorksheet.Cells[rowIndex, 30].Value = doc.ID2Issues; |
|
| 3043 |
//id2work-31 |
|
| 3044 |
templateWorksheet.Cells[rowIndex, 32].Value = doc.ReplyModifications; |
|
| 3045 |
templateWorksheet.Cells[rowIndex, 33].Value = this.GetUser(doc.ReplyRequester).Name; |
|
| 3046 |
templateWorksheet.Cells[rowIndex, 34].Value = doc.IsConvert; |
|
| 3047 |
templateWorksheet.Cells[rowIndex, 35].Value = $"{doc.AVEVAConvertDate:yyyy/MM/dd}";
|
|
| 3048 |
templateWorksheet.Cells[rowIndex, 36].Value = $"{doc.AVEVAWorkDate:yyyy/MM/dd}";
|
|
| 3049 |
templateWorksheet.Cells[rowIndex, 37].Value = doc.AVEVAStatus; |
|
| 3050 |
templateWorksheet.Cells[rowIndex, 38].Value = doc.AVEVAIssues; |
|
| 3051 |
templateWorksheet.Cells[rowIndex, 39].Value = $"{doc.AVEVAReviewDate:yyyy/MM/dd}";
|
|
| 3052 |
templateWorksheet.Cells[rowIndex, 40].Value = this.GetUser(doc.ProdReviewer).Name; |
|
| 3053 |
templateWorksheet.Cells[rowIndex, 41].Value = doc.ProdIsResult; |
|
| 3054 |
templateWorksheet.Cells[rowIndex, 42].Value = doc.ProdRemarks; |
|
| 3055 |
templateWorksheet.Cells[rowIndex, 43].Value = this.GetUser(doc.ClientReviewer).Name; |
|
| 3056 |
templateWorksheet.Cells[rowIndex, 44].Value = doc.ClientIsResult; |
|
| 3057 |
templateWorksheet.Cells[rowIndex, 45].Value = doc.ClientRemarks; |
|
| 3058 |
templateWorksheet.Cells[rowIndex, 46].Value = doc.DTIsGateWay; |
|
| 3059 |
templateWorksheet.Cells[rowIndex, 47].Value = doc.DTIsImport; |
|
| 3060 |
templateWorksheet.Cells[rowIndex, 48].Value = doc.DTIsRegSystem; |
|
| 3061 |
templateWorksheet.Cells[rowIndex, 49].Value = doc.DTRemarks; |
|
| 3016 |
int colIndex = 0; |
|
| 3017 |
templateWorksheet.Cells[rowIndex, colIndex].Value = rowNo++; |
|
| 3018 |
colIndex = 6;//1~6연동필드 |
|
| 3019 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.Team; |
|
| 3020 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.RefProjectCode; |
|
| 3021 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.System; |
|
| 3022 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.SubSystemCode; |
|
| 3023 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.DocumentNo; |
|
| 3024 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.PersonInCharge).Name; |
|
| 3025 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.Worker).Name; |
|
| 3026 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.AVEVAPersonInCharge).Name; |
|
| 3027 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.AVEVAWorker).Name; |
|
| 3028 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.Simularity; |
|
| 3029 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.Simularity2; |
|
| 3030 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.JobLevel; |
|
| 3031 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.RevisonNo; |
|
| 3032 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ToIsDiscussion; |
|
| 3033 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ToRemarks; |
|
| 3034 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.ToCreator).Name; |
|
| 3035 |
++colIndex;//toreview-23 |
|
| 3036 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.FrReviewStatus; |
|
| 3037 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.FrRemarks; |
|
| 3038 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.FrCreator).Name; |
|
| 3039 |
++colIndex;//frreview-27 |
|
| 3040 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = $"{doc.ID2StartDate:yyyy/MM/dd HH:mm:ss}";
|
|
| 3041 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = $"{doc.ID2EndDate:yyyy/MM/dd HH:mm:ss}";
|
|
| 3042 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ID2Status; |
|
| 3043 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ID2Issues; |
|
| 3044 |
++colIndex;//id2work-32 |
|
| 3045 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ReplyModifications; |
|
| 3046 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.ReplyRequester).Name; |
|
| 3047 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.IsConvert; |
|
| 3048 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = $"{doc.AVEVAConvertDate:yyyy/MM/dd}";
|
|
| 3049 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = $"{doc.AVEVAWorkDate:yyyy/MM/dd}";
|
|
| 3050 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.AVEVAStatus; |
|
| 3051 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.AVEVAIssues; |
|
| 3052 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = $"{doc.AVEVAReviewDate:yyyy/MM/dd}";
|
|
| 3053 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.ProdReviewer).Name; |
|
| 3054 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ProdIsResult; |
|
| 3055 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ProdRemarks; |
|
| 3056 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = this.GetUser(doc.ClientReviewer).Name; |
|
| 3057 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ClientIsResult; |
|
| 3058 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.ClientRemarks; |
|
| 3059 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.DTIsGateWay; |
|
| 3060 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.DTIsImport; |
|
| 3061 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.DTIsRegSystem; |
|
| 3062 |
templateWorksheet.Cells[rowIndex, ++colIndex].Value = doc.DTRemarks; |
|
| 3062 | 3063 |
|
| 3063 | 3064 |
/* |
| 3064 | 3065 |
templateWorksheet.Cells[rowIndex, 0].Value = doc.Seq; |
| ... | ... | |
| 3206 | 3207 |
|
| 3207 | 3208 |
List<string> docLinkColNames = new List<string>() { "AutoCADLink", "ID2Connection", "PDFLink", "MarkupLink", "AVEVALink" };
|
| 3208 | 3209 |
List<string> docInfoColNames = new List<string>() { "Team", "RefProjectCode", "System", "DocumentNo", "PersonInCharge", "Worker" };
|
| 3209 |
List<string> docOtherInfoColNames = new List<string>() { "SubSystemCode", "AVEVAPersonInCharge", "AVEVAWorker", "JobLevel", "Simularity", "RevisonNo" };
|
|
| 3210 |
List<string> docOtherInfoColNames = new List<string>() { "SubSystemCode", "AVEVAPersonInCharge", "AVEVAWorker", "JobLevel", "Simularity", "Simularity2", "RevisonNo" };
|
|
| 3210 | 3211 |
List<string> rvToColNames = new List<string>() { "ToIsDiscussion", "ToRemarks", "ToCreator", "ToCapture" };
|
| 3211 | 3212 |
List<string> rvFrColNames = new List<string>() { "FrReviewStatus", "FrRemarks", "FrCreator", "FrCapture" };
|
| 3212 | 3213 |
List<string> wkID2ColNames = new List<string>() { "ID2StartDate", "ID2EndDate", "ID2Status", "ID2Issues", "ID2Capture", "ReplyModifications", "ReplyRequester" };
|
내보내기 Unified diff
