Example #1
0
 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);
 }
Example #2
0
        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);
        }