//查询
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);
}
