/// <summary> /// 删除项目 /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int Delete(CIDemand demand) { const string sql = "DELETE FROM CIDemand WHERE DemandNumber=@DemandNumber "; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, new { ID = demand.DemandNumber })); } }
/// <summary> /// 添加项目 /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int Insert(CIDemand demand) { var sql = @"INSERT INTO CIReview (ID,ProjectCode,Purpose,Method,Attachment,Result,Scale,IfReview,PrepareTime,Member,Status,BeginDate,EndDate) VALUES (@ID,@ProjectCode,@Purpose,@Method,@Attachment,@Result,@Scale,@IfReview,@PrepareTime,@Member,@Status,@BeginDate,@EndDate)"; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, demand)); } }
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>(); }
/// <summary> /// 编辑项目 /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int Update(CIDemand demand) { const string sql = @"UPDATE CIDemand 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 WHERE ID=@ID " ; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, demand)); } }