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 }