//查询
public System.Data.DataSet GetTeacherInfo(TeacherInfoData data)
{
string sql = "select * from teacherinfo where 1=1";
string s = "";
if (data.Teaid != "" && data.Teaid != null)
{
s += " and teaid ='" + data.Teaid + "'";
}
if (data.Teaname != "" && data.Teaname != null)
{
s += " and teaname='" + data.Teaname + "'";
}
if (data.Teasex != "" && data.Teasex != null)
{
s += " and teasex='" + data.Teasex + "'";
}
if (data.Teabirthday != "" && data.Teabirthday != null)
{
s += " and teabirthday='" + data.Teabirthday + "'";
}
sql += s;
DataAccess da = new DataAccess();
return(da.GetDataSet(sql, "teacherinfo"));
}
//插入
public bool InsertTeacherInfo(TeacherInfoData data)
{
string sql = "insert into teacherinfo(teaid,teaname,"
+ "teasex,teloffice,address,teabirthday) values('"
+ data.Teaid + "','" + data.Teaname + "','" + data.Teasex + "','"
+ data.Teloffice + "','" + data.Address + "','" + data.Teabirthday + "')";
DataAccess da = new DataAccess();
return(da.ExecuteSQL(sql));
}
//修改
public bool UpdateTeacher(TeacherInfoData data)
{
string sql = "update teacherinfo set teaid='"
+ data.Teaid + "',teaname='" + data.Teaname
+ "',teasex='" + data.Teasex
+ "',teloffice='" + data.Teloffice
+ "',address='" + data.Address
+ "',teabirthday='" + data.Teabirthday + "'"
+ " where Teaid='" + data.Teaid + "'";
DataAccess da = new DataAccess();
return(da.ExecuteSQL(sql));
}
