/// <summary> /// 自评更新(事务) 核准更新 /// </summary> /// <returns></returns> public bool Update(string BillID) { bool result = false; int index = 0; try { FrameReviewEntity1.GenerateObjectFromRequest(""); List <EntityBase> listUpdate = new List <EntityBase>(); listUpdate.Add(FrameReviewEntity1); FrameReviewSaveEntity FrameReviewScoreEntity1 = null; foreach (var key in HttpContext.Current.Request.Form.AllKeys) { if (key.StartsWith("atxt") && key.EndsWith("rowNo")) { index = int.Parse(key.Replace("atxt", "").Replace("rowNo", "")); FrameReviewScoreEntity1 = new FrameReviewSaveEntity(); FrameReviewScoreEntity1.GenerateObjectFromRequest("self" + index); FrameReviewScoreEntity1.FrameReviewID = BillID; FrameReviewScoreEntity1.CreateDate = DateTime.Now; FrameReviewScoreEntity1.IsSelf = 1; FrameReviewScoreEntity1.ReviewerID = FrameReviewEntity1.CreateMan; if (FrameReviewScoreEntity1.ReviewResult != 0) { FrameReviewScoreEntity1.ReviewResult = 1; } else { } if (FrameReviewScoreEntity1.ID > 0) { FrameReviewScoreEntity1.IsGenerateObject = true;//这是更新,指定主键存在的意义之二,根据主键来更新与保存数据()唯一确定一条记录 } else { FrameReviewScoreEntity1.IsGenerateObject = false;//这是插入 } listUpdate.Add(FrameReviewScoreEntity1); } } result = FrameReviewEntity1.db.CommitTran(listUpdate.ToArray()); } catch (Exception e) { result = false; } return(result); }
/// <summary> /// 他评更新(事务) /// </summary> /// <returns></returns> public bool UpdateReview(string Reviewer) { bool result = false; int index = 0; decimal?i = 0; FrameReviewScoreEntity = new V_FrameReviewScoreShowEntity(); FrameReviewScoreEntity.PageSize = 0;//设置返回数据,即集合变量的大小,为0则放回全部数据 FrameReviewScoreEntity.ResetForSearch(); FrameReviewScoreEntity.FrameReviewID = FrameReviewEntity1.FrameReviewID; FrameReviewScoreList = FrameReviewScoreEntity.ToList <V_FrameReviewScoreShowEntity>(); foreach (var s in FrameReviewScoreList) { if (string.IsNullOrEmpty(s.Reviewer)) { Isexist = 0; break; } else if (s.Reviewer == Reviewer) { Isexist = 1; break; } else { Isexist = 2;//这里要改 } } try { List <EntityBase> listUpdate = new List <EntityBase>(); //分数明细表更新 FrameReviewSaveEntity FrameReviewScoreEntity1 = null; foreach (var key in HttpContext.Current.Request.Form.AllKeys) { if (key.StartsWith("atxt") && key.EndsWith("rowNo")) { index = int.Parse(key.Replace("atxt", "").Replace("rowNo", "")); FrameReviewScoreEntity1 = new FrameReviewSaveEntity(); FrameReviewScoreEntity1.ResetForSearch(); FrameReviewScoreEntity1.GenerateObjectFromRequest("other" + index); FrameReviewScoreEntity1.FrameReviewID = FrameReviewEntity1.FrameReviewID; FrameReviewScoreEntity1.CreateDate = DateTime.Now; FrameReviewScoreEntity1.IsSelf = 0; FrameReviewScoreEntity1.ReviewerID = Reviewer; if (FrameReviewScoreEntity1.ReviewResult != 0) { FrameReviewScoreEntity1.ReviewResult = 1; } i = i + Convert.ToInt16(FrameReviewScoreEntity1.ReviewResult); //统计出了总分数 if (Isexist == 1) { FrameReviewScoreEntity1.IsGenerateObject = true; //更新 } else { FrameReviewScoreEntity1.ID = null;//标识列不为空导致更新失败,还不报错 FrameReviewScoreEntity1.IsGenerateObject = false; } listUpdate.Add(FrameReviewScoreEntity1); } } decimal?passrate = i / listUpdate.Count; //主表更新 FrameReviewEntity1.GenerateObjectFromRequest(""); listUpdate.Add(FrameReviewEntity1); //计算通过率,更新评分人评分表 FrameReviewerShowEntity = new FrameReviewerEntity(); FrameReviewerShowEntity.ResetForSearch(); FrameReviewerShowEntity.GenerateObjectFromRequest("Review"); FrameReviewerShowEntity.FrameReviewID = FrameReviewEntity1.FrameReviewID; FrameReviewerShowEntity.PassingRate = passrate; FrameReviewerShowEntity.Reviewer = Reviewer; FrameReviewerShowEntity.ReviewDate = DateTime.Now; if (Isexist == 1) { FrameReviewerShowEntity.IsGenerateObject = true; } else { FrameReviewerShowEntity.IsGenerateObject = false; } listUpdate.Add(FrameReviewerShowEntity); result = FrameReviewEntity1.db.CommitTran(listUpdate.ToArray()); } catch (Exception e) { result = false; } return(result); }