public bool insertProject(ProjectSubmitBean projectSubmit) { sqlString = "insert into tbl_ProjectSubmit(Project_ID,Project_Name,Project_PersonLiable,Institute_ID,Project_Nature,Project_Status,Project_Source,Project_StartTime,Project_PlanTime,Project_ResultForm,Project_SecretGrade,Project_PlanMoney,Project_class,Project_Course,Project_level,Project_Team,Project_Content,Project_History,Project_Innovate,Project_MgDpart) values('" + projectSubmit.PrjID + "','" + projectSubmit.PrjName + "','" + projectSubmit.PrjPerson + "','" + projectSubmit.PrjInstitute + "','" + projectSubmit.PrjNature + "','" + projectSubmit.PrjStatus + "','" + projectSubmit.PrjSource + "','" + projectSubmit.PrjStartTime + "','" + projectSubmit.PrjPlanTime + "','" + projectSubmit.PrjResultForm + "','" + projectSubmit.PrjSecretGrade + "','" + projectSubmit.PrjPlanMoney + "','" + projectSubmit.PrjClass + "','" + projectSubmit.PrjCourse + "','" + projectSubmit.PrjLevel + "','" + projectSubmit.PrjTeam + "','" + projectSubmit.PrjContent + "','" + projectSubmit.PrjHistory + "','" + projectSubmit.PrjInnovate + "','" + projectSubmit.PrjMgDpart + "')"; if (db.ExecuteSQL(sqlString) != -1) { return(true); } return(false); }
public bool updateProject(ProjectSubmitBean projectSubmit) { sqlString = "update tbl_ProjectSubmit set Project_Name='" + projectSubmit.PrjName + "',Project_PersonLiable='" + projectSubmit.PrjPerson + "',Institute_ID='" + projectSubmit.PrjInstitute + "',Project_Nature='" + projectSubmit.PrjNature + "',Project_Source='" + projectSubmit.PrjSource + "',Project_StartTime='" + projectSubmit.PrjStartTime + "',Project_PlanTime='" + projectSubmit.PrjPlanTime + "',Project_ResultForm='" + projectSubmit.PrjResultForm + "',Project_SecretGrade='" + projectSubmit.PrjSecretGrade + "',Project_PlanMoney=" + projectSubmit.PrjPlanMoney + ",Project_class='" + projectSubmit.PrjClass + "',Project_Course='" + projectSubmit.PrjCourse + "',Project_level='" + projectSubmit.PrjLevel + "',Project_Team='" + projectSubmit.PrjTeam + "',Project_Content='" + projectSubmit.PrjContent + "',Project_History='" + projectSubmit.PrjHistory + "',Project_Innovate='" + projectSubmit.PrjInnovate + "',Project_MgDpart='" + projectSubmit.PrjMgDpart + "' where Project_ID='" + projectSubmit.PrjID + "'"; if (db.ExecuteSQL(sqlString) != -1) { return(true); } return(false); }