public bool insertProjectEnd(ProjectEndBean ProjectEnd)
{
sqlString = "insert into tbl_ProjectEnd(Project_ID,Project_Name,Project_Fruit,Project_Content,Project_PlanImplement,Project_innovation,Project_NextProblem) values('" + ProjectEnd.PrjID + "','" + ProjectEnd.PrjName + "','" + ProjectEnd.PrjFruit + "','" + ProjectEnd.PrjContent + "','" + ProjectEnd.PrjPlanImplement + "','" + ProjectEnd.PrjInnovation + "','" + ProjectEnd.PrjNextProblem + "','" + "')";
if (db.ExecuteSQL(sqlString) != -1)
{
return(true);
}
return(false);
}
public bool updateProjectEnd(ProjectEndBean ProjectEnd)
{
sqlString = "update tbl_InterimReport set Project_Fruit='" + ProjectEnd.PrjFruit + "',Project_Content='" + ProjectEnd.PrjContent + "',Project_PlanImplement='" + ProjectEnd.PrjPlanImplement + "',Project_innovation='" + ProjectEnd.PrjInnovation + "',Project_innovation='" + ProjectEnd.PrjNextProblem + "' where Project_ID='" + ProjectEnd.PrjID + "'";
if (db.ExecuteSQL(sqlString) != -1)
{
return(true);
}
return(false);
}