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); }