/// <summary> /// 删除项目 /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int Delete(CIReview review) { const string sql = "DELETE FROM CIReview WHERE ID=@ID "; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, new { ID = review.ID })); } }
/// <summary> /// 添加项目 /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int Insert(CIReview review) { var sql = @"INSERT INTO CIReview (ID,ProjectCode,Purpose,Method,Attachment,Result,Scale,IfReview,PrepareTime,Member,Status,BeginDate,EndDate,AddTime,UpdateTime) VALUES (@ID,@ProjectCode,@Purpose,@Method,@Attachment,@Result,@Scale,@IfReview,@PrepareTime,@Member,@Status,@BeginDate,@EndDate,@AddTime,@UpdateTime)"; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, review)); } }
public ProjectModel() { Project = new CIProject(); PageList = new ProjectPageList(); ProjectList = new List <CIProject>(); User = new CIUser(); CIReview = new CIReview(); reviewlist = new List <CIReview>(); Release = new CIRelease(); ReleaseList = new List <CIRelease>(); StatusSelectItem = new List <SelectListItem>(); }
public ReviewModel() { ReviewList = new List <CIReview>(); Review = new CIReview(); PageList = new ReviewPageList(); StatusSelectItem = new List <SelectListItem>(); MethodSelectItem = new List <SelectListItem>(); User = new CIUser(); UserList = new List <CIUser>(); IfReviewSelectItem = new List <SelectListItem>(); ReviewPro = new CIReviewProblem(); DemandList = new List <CIDemand>(); IfSolveSelectItem = new List <SelectListItem>(); DemandSelectItem = new List <SelectListItem>(); Demand = new CIDemand(); DemandList = new List <CIDemand>(); }
public ActionResult ReviewAdd(CIReview review) { try { review.ID = PressRequest.GetFormString("hidID"); review.Member = PressRequest.GetFormString("hidUsername"); var beginTime = PressRequest.GetFormString("BeginTime").Replace("/", "-"); var endTime = PressRequest.GetFormString("EndTime").Replace("/", "-"); review.BeginDate = string.IsNullOrEmpty(beginTime) ? DateTime.Now : TypeConverter.ObjectToTime(beginTime); review.EndDate = string.IsNullOrEmpty(endTime) ? DateTime.Now : TypeConverter.ObjectToTime(endTime); if (PressRequest.GetFormString("hidIfAdd") == "1") { review.UpdateTime = DateTime.Now; _reviewService.UpdatePro(review); } else { review.AddTime = DateTime.Now; review.UpdateTime = DateTime.Now; _reviewService.InsertPro(review); } } catch (Exception ex) { Logger.Error(ex); ErrorNotification("保存出错:" + ex.Message); return(View()); } if (PressRequest.GetFormString("hidIfPro") == "1") { return(Redirect(Url.Action("projectinfo", "project", new { id = PressRequest.GetFormString("hidProID") }))); } else { return(Redirect(Url.Action("ReviewList", "Review"))); } }
/// <summary> /// 编辑项目 /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int Update(CIReview review) { const string sql = @"UPDATE CIReview SET ProjectCode = @ProjectCode, Purpose = @Purpose, Method = @Method, Attachment = @Attachment, Result = @Result, Scale = @Scale, IfReview = @IfReview, PrepareTime = @PrepareTime, Member = @Member, Status = @Status, BeginDate = @BeginDate, EndDate = @EndDate, UpdateTime = @UpdateTime WHERE ID=@ID " ; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, review)); } }
/// <summary> /// 编辑项目 /// </summary> /// <param name="project"></param> /// <returns></returns> public int UpdatePro(CIReview review) { return(_reviewrepository.Update(review)); }
/// <summary> /// 添加评审 /// </summary> /// <param name="project"></param> /// <returns></returns> public int InsertPro(CIReview review) { return(_reviewrepository.Insert(review)); }