private void buttonQUERY_Click(object sender, EventArgs e)
{
try
{
if (textEditID.Text != "")
{
string strSQL = "select * from StudentBasicInfo where ID=" + textEditID.Text;
gridCtrl_StudentInfo.DataSource = db.ExecuteDataSet(strSQL, oleConn).Tables[0].DefaultView;
}
else if (textEditNAME.Text != "")
{
string strSQL = "select * from StudentBasicInfo where NAME='" + textEditNAME.Text + "'";
gridCtrl_StudentInfo.DataSource = db.ExecuteDataSet(strSQL, oleConn).Tables[0].DefaultView;
}
else if (comboBoxEditTEAM.Text != "")
{
int ntemp = comboBoxEditTEAM.SelectedIndex + 1;
string strSQL = "select * from StudentBasicInfo where TEAM=" + ntemp.ToString();
gridCtrl_StudentInfo.DataSource = db.ExecuteDataSet(strSQL, oleConn).Tables[0].DefaultView;
}
else if (comboBoxEditCLASS.Text != "")
{
string strSQL = "select * from StudentBasicInfo where CLASS=" + comboBoxEditCLASS.Text;
gridCtrl_StudentInfo.DataSource = db.ExecuteDataSet(strSQL, oleConn).Tables[0].DefaultView;
}
}
catch
{ MessageBox.Show("查询有误"); }
}
/// <summary>
/// 返回内连接数据表
/// </summary>
/// <returns></returns>
public DataSet GetDataSet()
{
string strSQL = "SELECT StudentBasicInfo.ID,StudentBasicInfo.NAME,StudentBasicInfo.GRADE,StudentBasicInfo.TEAM,StudentBasicInfo.IsPartyMember,StudentPunishmentRecords.PUNISHMENT,StudentPunishmentRecords.EXEDATETIME, StudentPunishmentRecords.EXEUNIT,StudentPunishmentRecords.REASON ";
strSQL += " FROM StudentBasicInfo INNER JOIN StudentPunishmentRecords ON StudentBasicInfo.ID = StudentPunishmentRecords.ID";
return(db.ExecuteDataSet(strSQL, oleConn));
}
/// <summary>
/// 获取学生请假表
/// </summary>
/// <returns></returns>
public DataTable GetPersonLeavesTable()
{
string strSQL = "SELECT StudentBasicInfo.ID,StudentBasicInfo.TEAM,StudentBasicInfo.CLASS,StudentBasicInfo.NAME,StudentLeaveRecords.LEAVEDATE,StudentLeaveRecords.DUEDATE,StudentLeaveRecords.RETURNDATE FROM StudentBasicInfo INNER JOIN StudentLeaveRecords ON StudentBasicInfo.ID = StudentLeaveRecords.ID";
return(db.ExecuteDataSet(strSQL, oleConn).Tables[0]);
}
/// <summary>
/// 获取已离开学生请假表
/// </summary>
/// <returns></returns>
public DataTable GetPersonLeavesTable()
{
string strSQL = "SELECT StudentBasicInfo.ID,StudentBasicInfo.TEAM,StudentBasicInfo.CLASS,StudentBasicInfo.NAME,StudentBasicInfo.IsPartyMember,StudentBasicInfo.IsCadre,StudentLeaveRecords.LEAVEDATE,StudentLeaveRecords.DUEDATE,StudentLeaveRecords.ISBACK,StudentLeaveRecords.RETURNDATE FROM StudentBasicInfo INNER JOIN StudentLeaveRecords ON StudentBasicInfo.ID = StudentLeaveRecords.ID where StudentLeaveRecords.ISBACK=false order by StudentLeaveRecords.LEAVEDATE";
return(db.ExecuteDataSet(strSQL, oleConn).Tables[0]);
}
/// <summary>
/// 获取在位人员
/// </summary>
/// <param name="Grade"></param>
/// <returns></returns>
public DataTable GetStayPersonInfoTable(string Grade)
{
string strSQL = "select * from StudentBasicInfo where GRADE='" + Grade + "' and ID not in(select ID from StudentLeaveRecords where ISBACK=false)";
DataSet ds = db.ExecuteDataSet(strSQL, oleConn);
DataTable dt = ds.Tables[0];
return(dt);
}