//修改课程
public bool ChangeCourse(CourseModel objCourseModel)
{
#region //
//public bool ChangeCourse(string Course, string CourseNum, string CourseName, string Credit, string ProOrPub, string NeedOrOpt)
//{
// string SQLString;
// SQLString = "update Course set CourseNum='" + CourseNum + "',CourseName='" + CourseName + "'";
// SQLString += ",Credit='" + Credit + "',ProOrPub='" + ProOrPub + "'";
// SQLString += ",NeedOrOpt='" + NeedOrOpt + "'where CourseNum='" + Course + "'";
// DataBaseOperateClass objDataBase = new DataBaseOperateClass();
// if (objDataBase.GetExecute(SQLString))
// return (true);
// else
// return (false);
//}
#endregion
#region 使用实体类在各层之间传递数据
string SQLString;
SQLString = "update Course set CourseNum='" + objCourseModel.CourseNum + "',CourseName='" + objCourseModel.CourseName + "',Credit='" + objCourseModel.Credit + "',ProOrPub='" + objCourseModel.ProOrPub + "',NeedOrOpt='" + objCourseModel.NeedOrOpt + "',DeptNum='"+ objCourseModel.DeptNum+"' where CourseNum='" + objCourseModel.CourseNum + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SQLString))
return (true);
else
return (false);
#endregion
}
//删除教师员工
public bool DeleteTeacher(TeacherModel objTeacherModel)
{
string SqlString = "delete FROM Teacher WHERE TeaNum='" + objTeacherModel.TeaNum + "' ";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
return (objDataBase.GetExecute(SqlString));
}
public bool DelProfession(ProfessionModel objProfessionModel)
{
string SqlString = "delete from profession where ProNum='" + objProfessionModel.ProNum + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
//return (objDataBase.GetExecute(SqlString));
return (objDataBase.GetExecute(SqlString));
}
//获取教师员工
public DataTable ShowTeacher()
{
string SqlString = "Select TeaNum AS 工号,TeaName AS 姓名,TeaSex AS 性别, TeaAdress AS 联系地址,TeaPhone AS 联系电话,TeaTitle AS 职称,TeaProField AS 专业方向 From dbo.Teacher";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable ObjDataTable = objDataBase.GetDataSet(SqlString).Tables[0];
return (ObjDataTable);
}
//返回查找结果：
public DataTable SearchTea(TeacherModel objTeacherModel)
{
string SqlString = "Select TeaNum AS 工号,TeaName AS 姓名,TeaSex AS 性别, TeaAdress AS 联系地址,TeaPhone AS 联系电话,TeaTitle AS 职称,TeaProField AS 专业方向 From dbo.Teacher Where TeaNum='"+objTeacherModel.TeaNum+"'";
DataBaseOperaClass objDataBaseOperaClass=new DataBaseOperaClass();
DataTable objDataTable = objDataBaseOperaClass.GetDataSet(SqlString).Tables[0];
return (objDataTable);
}
public DataTable ShowStuInfo()
{
string SqlString = "Select * From V_Student_All_Info";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTable = objDataBase.ShowTable(SqlString);
return (objDataTable);
}
public DataTable ShowSchoolInfo()
{
string SqlString = "Select SchNum AS 学校代码, SchName AS 校区 From School";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTalbe = objDataBase.GetDataSet(SqlString).Tables[0];
return (objDataTalbe);
}
public DataTable ShowProfession()
{
string SqlString = "select ProNum AS 专业号,ProName AS 专业名,Profession.deptNum AS 系别号,Department.DeptName as 系部名称 from dbo.Profession join Department on Profession.deptNum=Department.DeptNum";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTable = objDataBase.ShowTable(SqlString);
return (objDataTable);
}
//查找教师员工
public bool SearchTeacher(TeacherModel objTeacherModel)
{
string SqlString = "SELECT *FROM Teacher where TeaName='" + objTeacherModel.TeaName + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetDataSet(SqlString ).Tables[0].Rows.Count >0)
return (true);
else
return (false);
}
//获取所有班级信息
public DataTable ShowTeaching()
{
string Sqlstring = "Select TeaName AS 教师姓名,Semester AS 学期,CourseName AS 授课名称 From Teacher,Teaching,Course Where Teacher.TeaNum=Teaching.TeaNum and Course.CourseNum=Teaching.CourseNum";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTable = objDataBase.ShowTable(Sqlstring);
return (objDataTable);
}
//删除班级信息
public bool DeleteClass(ClassModel objClassModel)
{
string Sqlstring = "delete from Class where ClaNum = '" + objClassModel.ClaNum + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(Sqlstring))
return (true);
else
return (false);
}
//添加班级信息
public bool AddTeachingTask(TeachingModel objTeachingModel)
{
string Sqlstring = "Insert into Teaching Values('T001','第一学期','c1000')";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(Sqlstring))
return (true);
else
return (false);
}
//查找班级信息
public bool SearchClass(ClassModel objClassModel)
{
string Sqlstring = "select * from Class where ClaNum ='" + objClassModel.ClaNum+ "'";
DataBaseOperaClass objDataBaseOperaClass = new DataBaseOperaClass();
if (objDataBaseOperaClass.GetDataSet(Sqlstring).Tables[0].Rows.Count > 0)
return (true);
else
return (false);
}
public bool AddProfessin(ProfessionModel objProfessionModel)
{
string SqlString = "INSERT INTO Profession(ProNum,ProName,deptNum)VALUES('" + objProfessionModel.ProNum + "','" + objProfessionModel.ProName + "','"+objProfessionModel.DepartNum + "')";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString))
return (true);
else
return (false);
}
//获取表格数据给下拉字段使用：
public string[] GetSchNum()
{
string SqlString = "Select SchNum AS 学校代码, SchName AS 校区 From School";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objTable = objDataBase.ShowTable(SqlString);
string[] SchNum = new string[objTable.Rows.Count];
for (int i = 0; i < objTable.Rows.Count; i++)
SchNum[i] = objTable.Rows[i][0].ToString();
return (SchNum);
}
//任务14
//获取所有班级信息
public DataTable ShowClass()
{
//string Sqlstring = "select ClaNum AS 班级号,ClaName AS 班级名,DeptNum AS 系别编号,ProNum AS 专业编号 from dbo.Class";
string SqlString = "Select * From V_ClassInfo";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTable = objDataBase.ShowTable(SqlString);
return (objDataTable);
}
public bool UpdateTea(TeacherModel objTeacherModel)
{
string SQLString;
SQLString = "UPDATE Teacher SET TeaName='" + objTeacherModel.TeaName + "',TeaSex='" + objTeacherModel.TeaSex + "'";
SQLString += ",TeaPhone='" + objTeacherModel.TeaPhone + "',TeaAdress='" + objTeacherModel.TeaAdress + "'";
SQLString += ",TeaTitle='" + objTeacherModel.TeaTitle + "',TeaNum='" + objTeacherModel.TeaNum + "' where TeaNum='" + objTeacherModel.TeaNum + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SQLString))
return (true);
else
return (false);
}
public bool CancelSel(SelCourseModel objSelCourseClass)
{
string SqlString = "delete from SelCourse where StuNum=@StuNum AND CourseNum=@CourseNum";
SqlParameter[] parms ={
new SqlParameter("@StuNum",objSelCourseClass.StuNum),
new SqlParameter("@CourseNum",objSelCourseClass.CourseNum)
};
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString,parms))
return (true);
else
return (false);
}
public bool UpdateProfession(ProfessionModel objProfessionModel)
{
string SqlString;
//专业编号不可以修改，因它这里它用作搜索条件 ProNum='"+objProfessionModel.ProNum +"',
SqlString = "update dbo.profession set ProName='"+objProfessionModel.ProName+"',deptNum='"+ objProfessionModel.DepartNum + "' where ProNum='" + objProfessionModel.ProNum + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString))
return (true);
else
return (false);
}
//修改班级信息
public bool ChangeClass(ClassModel objClassModel)
{
//string Sqlstring;
//Sqlstring = "update Class set ClaNum ='" + objClassModel.ClaNum + "',ClaName ='" + objClassModel.ClaName + "',DeptNum ='" + objClassModel.DeptNum + "',ProNum ='" + objClassModel.ProNum + "' where ClaNum ='"+objClassModel.ClaNum+"'";
string SqlString="Update V_ClassInfo set 班级编号='"+objClassModel.ClaNum+"',班级名称='"+objClassModel.ClaName+"',专业编号='"+objClassModel.ProNum+"',系部编号='"+objClassModel.DeptNum+"'where 班级编号='"+objClassModel.ClaNum+"'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString))
return (true);
else
return (false);
}
//添加
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 AddCourse( CourseModel objCourseModel)
{
#region 使用实体类在各层之间传递数据
string SqlString = "Insert into Course(CourseNum,CourseName,Credit,ProOrPub,NeedOrOpt,DeptNum) values('" + objCourseModel.CourseNum + "','" + objCourseModel.CourseName + "','" + objCourseModel.Credit + "','" + objCourseModel.ProOrPub + "','" + objCourseModel.DeptNum + "','"+objCourseModel.DeptNum+"')";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString))
return (true);
else
return (false);
#endregion
}
public bool InputScore(SelCourseModel objSelCourseModel)
{
string SqlString = "Update SelCourse Set Score=@Score where StuNum=@StuNum AND CourseNum=@CourseNum";
SqlParameter[] parms ={
new SqlParameter("@Score",objSelCourseModel.Score),
new SqlParameter("@StuNum",objSelCourseModel.StuNum),
new SqlParameter("@CourseNum",objSelCourseModel.CourseNum)
};
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString,parms))
return (true);
else
return (false);
}
public bool AddClass(ClassModel objClassModel)
{
string SqlString = "Insert into V_ClassInfo (班级编号,班级名称,专业编号,系部编号) Values(@ClaNum,@ClaName,@ProNum,@DeptNum)";
SqlParameter[] parms ={
new SqlParameter("@ClaNum",objClassModel.ClaNum),
new SqlParameter("@ClaName",objClassModel.ClaName),
new SqlParameter("@ProNum",objClassModel.ProNum),
new SqlParameter("@DeptNum",objClassModel.DeptNum)
};
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetExecute(SqlString,parms))
return (true);
else
return (false);
}
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);
}
}
public bool AddTeacher(TeacherModel objTeacherModel)
{
string Sqlstring = "INSERT INTO Teacher(TeaNum,TeaName,TeaSex,TeaAdress,TeaPhone,TeaTitle)VALUES ('" + objTeacherModel.TeaNum + "','" + objTeacherModel.TeaName
+ "','" + objTeacherModel.TeaSex + "','" + objTeacherModel.TeaAdress + "','" + objTeacherModel.TeaPhone + "','" + objTeacherModel.TeaTitle + "')";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
try
{
if (objDataBase.GetExecute(Sqlstring))
return (true);
else
return (false);
}
catch (Exception e1)
{
MessageBox.Show("教师工号不能重复\n请检查输入内容！" + e1);
return (false);
}
}
//获取所有课程：
public DataTable ShowCourse()
{
string SqlString = "select CourseNum as 课程号,CourseName as 课程名称,Credit AS 学分,ProOrPub as 范围,NeedOrOpt AS 类型 ,Course.DeptNum AS 系编号, Department.DeptName as 系别 from Course join Department on Course.DeptNum=Department.DeptNum order by CourseNum desc";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTable = objDataBase.GetDataSet(SqlString).Tables[0];
return (objDataTable);
}
//删除课程
public bool DeletCourse(CourseModel objCourseModel )
{
string SqlString = "DELETE FROM Course WHERE CourseNum='" + objCourseModel.CourseNum + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
return (objDataBase.GetExecute(SqlString));
}
private void btnSearch_Click(object sender, EventArgs e)
{
#region 使用实体类在三层中传递数据
ClassBLL objClass1BLL = new ClassBLL();
SchoolMolel objClassModel = new SchoolMolel();
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
objClassModel.SchNum = txtClaNum.Text;
dgvClass.DataSource = objClass1BLL.SearchClass(objClassModel);
#endregion
ShowClass();
}
public bool SelOk(SelCourseModel objSelCourseModel)
{
string SqlString = "Insert into SelCourse(StuNum,CourseNum) Values(@StuNum ,@CourseNum)";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
SqlParameter[] parms = {
new SqlParameter("@StuNum", objSelCourseModel.StuNum),
new SqlParameter("@CourseNum",objSelCourseModel.CourseNum),
//new SqlParameter("@Score",objSelCourseModel.Score)
};
if (objDataBase.GetExecute(SqlString, parms))
{
return (true);
}
else
{
return (false);
}
}
