private void ShowAllInfo()
{
DataBaseOperateClass2 objDataBaseOperateClass2 = new DataBaseOperateClass2();
string SqlString = "Select * From School";
dataGridView1.DataSource = objDataBaseOperateClass2.ShowTable(SqlString);
}
//返回结果：
public DataTable SearchCourse(CourseModel objCourseModel)
{
string SqlString = "Select * from Course where CourseNum='" + objCourseModel.CourseNum + "'";
DataBaseOperateClass2 objDataBaseOperateClass2=new DataBaseOperateClass2();
DataTable objDataTable;
return objDataTable = objDataTable = objDataBaseOperateClass2.ShowTable(SqlString);
}
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 DataTable ScoreStuSearch(LoginUserModel objLoginUserModel)
{
string SqlStringStu="Select SelCourse.StuNum AS 学号,StuName AS 姓名 ,CourseName As 课程,SelCourse.Score AS 成绩 From SelCourse Join Student on Student.StuNum=SelCourse.StuNum join Course on Course.CourseNum=SelCourse.CourseNum Where SelCourse.StuNum='"+objLoginUserModel.UserId+"'";
DataBaseOperateClass2 objDataBaseOperate2 = new DataBaseOperateClass2();
DataTable objDataTable;
return objDataTable = objDataBaseOperate2.ShowTable(SqlStringStu);
}
public DataTable ScoreSearch(ClassModel objClassModel)
{
SqlString += " Where 班级='"+ objClassModel.ClaName+"'Or 学号='"+objClassModel.StuNum+"'";
DataBaseOperateClass2 objDataBase = new DataBaseOperateClass2();
DataTable objDataTable;
return objDataTable = objDataBase.ShowTable(SqlString);
}
public DataTable CheckStuSelectCourseResult(SelCourseModel objSelCourseModel)
{
string SqlString = "select Student.StuNum AS 学号,Class.ClaName AS 班级,StuName AS 姓名,Course.CourseName AS 所选课程,SelCourse.CourseNum AS 课程编号,Credit AS 学分 from Student join Class on Student.ClaNum=Class.ClaNum join SelCourse on Student.StuNum=SelCourse.StuNum join Course on SelCourse.CourseNum=Course.CourseNum Where SelCourse.StuNum=@StuNum";
SqlParameter[] parms ={
new SqlParameter("@StuNum",objSelCourseModel.StuNum)
};
DataBaseOperateClass2 objDataBase = new DataBaseOperateClass2();
DataTable objDataTable;
return objDataTable = objDataBase.ShowTable(SqlString, parms);
}
private void btnPost_Click(object sender, EventArgs e)
{
#region 获取当前登录用户ID
LoginUIBLL objLoginUIBLL = new LoginUIBLL();
LoginUserModel objLoginUserModel = new LoginUserModel();
SqlDataReader SqlRead;
SqlRead = objLoginUIBLL.LoginUserRead();
if (SqlRead.Read() == true)
{
objLoginUserModel.UserId = SqlRead["UserId"].ToString();
}
#endregion
string SqlString="Insert into V_StuWebComment";
#region 类型选择
if (rdbSuggest.Checked == true)
{
SqlString += "(学号,建议) Values('" + objLoginUserModel.UserId + "','" + txtComment.Text + "')";
}
if (rdbCriticism.Checked == true)
{
SqlString += "(学号,批评) Values('" + objLoginUserModel.UserId + "','" + txtComment.Text + "')";
}
if (rdbconsult.Checked == true)
{
SqlString += "(学号,咨询) Values('" + objLoginUserModel.UserId + "','" + txtComment.Text + "')";
}
#endregion
DataBaseOperateClass2 objDataBaseOperateClass2 = new DataBaseOperateClass2();
#region 异常处理
try
{
if (objDataBaseOperateClass2.GetExecute(SqlString) == true)
MessageBox.Show("成功提交！谢谢参与！");
else
MessageBox.Show("抱歉！提交失败！请查看错误消息：");
}
catch (Exception e1)
{
MessageBox.Show("抱歉！提交失败！请查看错误消息：");
MessageBox.Show("错误消息：" + e1);
}
#endregion
}
public bool CheckSeledCourseStu(SelCourseModel objSelCourseModel)
{
string SqlString = "Select * From V_SelCourse Where 学号=@StuNum AND 所选课程=@CourseName";
SqlParameter[] parms ={
new SqlParameter("@StuNum",objSelCourseModel.StuNum),
new SqlParameter("@CourseName",objSelCourseModel.CourseName)
};
DataBaseOperateClass2 objDataBase = new DataBaseOperateClass2();
if (objDataBase.GetDataRow(SqlString,parms) != null)
return (true);
else
return (false);
}
//查找课程
public bool SearchCoursebool(CourseModel objCourseModel)
{
string SqlString = "Select * from Course where CourseNum='" + objCourseModel.CourseNum + "'";
DataBaseOperateClass2 objDataBaseOperateClass2 = new DataBaseOperateClass2();
if (objDataBaseOperateClass2.GetDataRow(SqlString) != null)
return (true);
else
return (false);
}
