public DataTable SearchSchool(SchoolModel objSchoolMolel)
{
string SqlString = "Select SchNum AS 学校代码, SchName AS 校区 From School";
DataBaseOperateClass2 objDataBase = new DataBaseOperateClass2();
DataTable objDataTable;
return objDataTable = objDataBase.ShowTable(SqlString);
}
//添加
public bool AddSchool(SchoolModel objSchoolModel)
{
#region 使用实体类在各层之间传递数据
string SqlString = "insert into School values ('"+objSchoolModel.SchNum+"','"+ objSchoolModel.SchName+"')";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString))
return (true);
else
return (false);
#endregion
}
public bool DelSchool(SchoolModel objSchoolModel)
{
string SqlString = "delete from School where SchNum='" + objSchoolModel.SchNum + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
try
{
if (objDataBase.GetExecute(SqlString))
return (true);
else
return (false);
}
catch (Exception e1)
{
MessageBox.Show("该学校有数据！\n不能删除！\n删除前请先清空学校下属的所有内容！"+e1);
return (false);
}
}
//Update:
public bool UpdateSchool(SchoolModel objSchoolModel)
{
SchoolDAL objSchoolDAL = new SchoolDAL();
return objSchoolDAL.Update(objSchoolModel);
}
//Delete:
public bool delSchool(SchoolModel objSchoolModel)
{
SchoolDAL objSchoolDAL = new SchoolDAL();
return objSchoolDAL.DelSchool(objSchoolModel);
}
//add:
public bool AddSchool(SchoolModel objSchoolModel)
{
SchoolDAL objSchoolDAL = new SchoolDAL();
return objSchoolDAL.AddSchool(objSchoolModel);
}
//修改：
public bool Update(SchoolModel objSchoolModel)
{
#region 使用实体类在各层
string SqlString = "Update School Set SchNum='" +objSchoolModel.SchNum + "',SchName='" + objSchoolModel.SchName +"'where SchNum='"+objSchoolModel.SchNum+"'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString))
return (true);
else
return (false);
#endregion
}
