//插入 public bool InsertCourseInfo(CourseInfoData data) { string sql = "insert into courseinfo(kcid,kcname," + "periodexpriment,periodteaching,credit,coursetype) values('" + data.Kcid + "','" + data.Kcname + "','" + data.Periodexpriment + "','" + data.Periodteaching + "','" + data.Credit + "','" + data.Coursetype + "')"; DataAccess da = new DataAccess(); return(da.ExecuteSQL(sql)); }
//修改 public bool UpdateCourse(CourseInfoData data) { string sql = "update courseinfo set kcid='" + data.Kcid + "',kcname='" + data.Kcname + "',periodexpriment='" + data.Periodexpriment + "',periodteaching='" + data.Periodteaching + "',credit='" + data.Credit + "',coursetype='" + data.Coursetype + "'" + " where kcid='" + data.Kcid + "'"; DataAccess da = new DataAccess(); return(da.ExecuteSQL(sql)); }
//查询 public System.Data.DataSet GetCourseInfo(CourseInfoData data) { string sql = "select * from courseinfo where 1=1"; string s = ""; if (data.Kcid != "" && data.Kcid != null) { s += " and kcid ='" + data.Kcid + "'"; } if (data.Kcname != "" && data.Kcname != null) { s += " and kcname='" + data.Kcname + "'"; } sql += s; DataAccess da = new DataAccess(); return(da.GetDataSet(sql, "stugradeinfo")); }