/// <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));
}
