//查询 public System.Data.DataSet GetStudentInfo(StudentInfoData data) { string sql = "select * from studentinfo where 1=1"; string s = ""; if (data.Sno != "" && data.Sno != null) { s += " and sno='" + data.Sno + "'"; } if (data.Sname != "" && data.Sname != null) { s += " and sname='" + data.Sname + "'"; } if (data.Sex != "" && data.Sex != null) { s += " and sex='" + data.Sex + "'"; } if (data.Classid != "" && data.Classid != null) { s += " and classid='" + data.Classid + "'"; } sql += s; DataAccess da = new DataAccess(); return(da.GetDataSet(sql, "studentinfo")); }
public bool InsertStudentInfo(StudentInfoData data) { string sql = "insert into studentinfo(sno,sname," + "sex,birthday,classid,tel,address) values('" + data.Sno + "','" + data.Sname + "','" + data.Sex + "','" + data.Birthday + "','" + data.Classid + "','" + data.Tel + "','" + data.Address + "')"; DataAccess da = new DataAccess(); return(da.ExecuteSQL(sql)); }
//修改 public bool UpdateStudent(StudentInfoData data) { string sql = "update studentinfo set sno='" + data.Sno + "',sname='" + data.Sname + "',sex='" + data.Sex + "',birthday='" + data.Birthday + "',classid='" + data.Classid + "',tel='" + data.Tel + "',address='" + data.Address + "'" + " where sno='" + data.Sno + "'"; DataAccess da = new DataAccess(); return(da.ExecuteSQL(sql)); }
public IEnumerable <StudentJoinView> GetStudentRecord() { List <StudentInfo> studentData = StudentInfoData.GetData(); List <StudentTransactions> studentTransactions = StudentTransactionsData.GetData(); List <StudentJoinView> studentJoinViews = (from std_info in studentData join std_trans in studentTransactions on std_info.StudentID equals std_trans.StudentID select new StudentJoinView { StudentID = std_info.StudentID, StudentName = std_info.StudentName, StudentClass = std_info.StudentClass, StudentAge = std_info.StudentAge, StudentFees = std_trans.StudentFees, Date = std_trans.Date } ).ToList(); return(studentJoinViews); }