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