public bool insertInterimReport(InterimReportBean InterimReport) { sqlString = "insert into tbl_InterimReport(Project_ID,Project_Name,Interim_Plan,Interim_Fruit,Interim_Question) values('" + InterimReport.IrID + "','" + InterimReport.IrName + "','" + InterimReport.IrPlan + "','" + InterimReport.IrFruit + "','" + InterimReport.IrQuestion + "')"; if (db.ExecuteSQL(sqlString) != -1) { return(true); } return(false); }
public bool updateIR(InterimReportBean irb) { sqlString = "update tbl_InterimReport set Interim_Plan='" + irb.IrPlan + "',Interim_Fruit='" + irb.IrFruit + "',Interim_Question='" + irb.IrQuestion + "' where Project_ID='" + irb.IrID + "'"; if (db.ExecuteSQL(sqlString) != -1) { return(true); } return(false); }