/// <summary> /// 用于更新评审人评分明细表与评审信息 /// </summary> /// <returns></returns> public bool UpdateReview() { bool result = true; int index = 0; decimal ReviewScore = 0; int flagNumber = 0; decimal?totalScore = 0; try { List <EntityBase> listUpdate = new List <EntityBase>(); TechnicalReviewPrimaryEntity.GenerateObjectFromRequest(""); TechnicalReviewPrimaryEntity.IsGenerateObject = true; listUpdate.Add(TechnicalReviewPrimaryEntity); foreach (var key in HttpContext.Current.Request.Form.AllKeys) { if (key.StartsWith("Review") && key.EndsWith("rowNo")) { index = Convert.ToInt16(key.Replace("Review", "").Replace("rowNo", "")); TechnicalReviewerScoreDetailsEntity TechnicalReviewerScoreDetailsEntity = new TechnicalReviewerScoreDetailsEntity(); TechnicalReviewerScoreDetailsEntity.GenerateObjectFromRequest("other" + index); TechnicalReviewerScoreDetailsEntity.TechnicalReviewID = TechnicalReviewPrimaryEntity.TechnicalReviewID; TechnicalReviewerScoreDetailsEntity.ReviewerCode = this.Reviewer; if (TechnicalReviewerScoreDetailsEntity.CheckQuantity == 0 || TechnicalReviewerScoreDetailsEntity.CheckQuantity == null || TechnicalReviewerScoreDetailsEntity.QualifiedQuantity == null) { TechnicalReviewerScoreDetailsEntity.ReviewerScore = 100; } else if (TechnicalReviewerScoreDetailsEntity.QualifiedQuantity == 0) { TechnicalReviewerScoreDetailsEntity.ReviewerScore = 0; } else if (TechnicalReviewerScoreDetailsEntity.QualifiedQuantity > TechnicalReviewerScoreDetailsEntity.CheckQuantity) { TechnicalReviewerScoreDetailsEntity.ReviewerScore = 100; } else { TechnicalReviewerScoreDetailsEntity.ReviewerScore = (Convert.ToDecimal(TechnicalReviewerScoreDetailsEntity.QualifiedQuantity) / Convert.ToDecimal(TechnicalReviewerScoreDetailsEntity.CheckQuantity)) * 100; } if (Isexist == 1) { TechnicalReviewerScoreDetailsEntity.IsGenerateObject = true;//更新 } else { TechnicalReviewerScoreDetailsEntity.RID = null; TechnicalReviewerScoreDetailsEntity.IsGenerateObject = false; } flagNumber++; ReviewScore += Convert.ToDecimal(TechnicalReviewerScoreDetailsEntity.ReviewerScore); listUpdate.Add(TechnicalReviewerScoreDetailsEntity); } } ReviewScore = ReviewScore / flagNumber; if (ReviewScore >= 70) { TechnicalReviewerScoreEntity.IsQualified = 1; } else { TechnicalReviewerScoreEntity.IsQualified = 0; } TechnicalReviewerScoreEntity.ReviewDate = DateTime.Now; TechnicalReviewerScoreEntity.Reviewer = this.Reviewer; TechnicalReviewerScoreEntity.TechnicalReviewID = TechnicalReviewPrimaryEntity.TechnicalReviewID; TechnicalReviewerScoreEntity.Score = ReviewScore; if (TechnicalReviewerScoreEntity.ID == null || TechnicalReviewerScoreEntity.ID < 0) { TechnicalReviewerScoreEntity.IsGenerateObject = false; } else { TechnicalReviewerScoreEntity.IsGenerateObject = true; } listUpdate.Add(TechnicalReviewerScoreEntity); result = TechnicalReviewPrimaryEntity.db.CommitTran(listUpdate.ToArray()); } catch { result = false; } return(result); }
/// <summary> /// 用于更新自评人评分明细表与主表与月度计划表 /// </summary> /// <returns></returns> public bool Update(string billID) { bool result = false; int index = 0; try { List <EntityBase> listUpdate = new List <EntityBase>(); TechnicalReviewPrimaryEntity.GenerateObjectFromRequest(""); TechnicalReviewPrimaryEntity.IsGenerateObject = true; listUpdate.Add(TechnicalReviewPrimaryEntity); foreach (var key in HttpContext.Current.Request.Form.AllKeys) { //更新月度计划表 if (key.StartsWith("atxt") && key.EndsWith("rowNo")) { index = int.Parse(key.Replace("atxt", "").Replace("rowNo", "")); TechnicalReviewProgressEntity TechnicalReviewProgressEntityUD = new TechnicalReviewProgressEntity(); TechnicalReviewProgressEntityUD.GenerateObjectFromRequest("atxt" + index); TechnicalReviewProgressEntityUD.TechnicalReviewID = billID; if (!string.IsNullOrEmpty(TechnicalReviewProgressEntityUD.RowState)) //添加时,RowState为空! { //编辑 if (TechnicalReviewProgressEntityUD.RowState == "delete") //删除 { TechnicalReviewProgressEntityUD.Delete(); } else { TechnicalReviewProgressEntityUD.IsGenerateObject = true; } } else { TechnicalReviewProgressEntityUD.IsGenerateObject = false; } if (TechnicalReviewProgressEntityUD.RowState != "delete") { listUpdate.Add(TechnicalReviewProgressEntityUD); } } //更新自评分数 if (key.StartsWith("Review") && key.EndsWith("rowNo")) { index = Convert.ToInt16(key.Replace("Review", "").Replace("rowNo", "")); TechnicalSelfScoreDetailsEntity TechnicalSelfScoreDetailsEntity = new TechnicalSelfScoreDetailsEntity(); TechnicalSelfScoreDetailsEntity.GenerateObjectFromRequest("self" + index); TechnicalSelfScoreDetailsEntity.TechnicalReviewID = billID; TechnicalSelfScoreDetailsEntity.SelfReviewMan = TechnicalReviewPrimaryEntity.CreateManCode; if (TechnicalSelfScoreDetailsEntity.SID != null && TechnicalSelfScoreDetailsEntity.SID > 0) { TechnicalSelfScoreDetailsEntity.IsGenerateObject = true; } else { TechnicalSelfScoreDetailsEntity.IsGenerateObject = false; } listUpdate.Add(TechnicalSelfScoreDetailsEntity); } //更新提案表 if (key.StartsWith("dtxt") && key.EndsWith("rowNo")) { index = int.Parse(key.Replace("dtxt", "").Replace("rowNo", "")); TReviewProposalEntity TReviewProposalEntityUD = new TReviewProposalEntity(); TReviewProposalEntityUD.GenerateObjectFromRequest("dtxt" + index); TReviewProposalEntityUD.TechnicalReviewID = billID; if (!string.IsNullOrEmpty(TReviewProposalEntityUD.RowState)) //添加时,RowState为空! { //编辑 if (TReviewProposalEntityUD.RowState == "delete") //删除 { TReviewProposalEntityUD.Delete(); } else { TReviewProposalEntityUD.IsGenerateObject = true; } } else { TReviewProposalEntityUD.IsGenerateObject = false; } if (TReviewProposalEntityUD.RowState != "delete") { listUpdate.Add(TReviewProposalEntityUD); } } } result = TechnicalReviewPrimaryEntity.db.CommitTran(listUpdate.ToArray()); } catch { result = false; } return(result); }