/// <summary>
/// 添加处罚记录
/// </summary>
/// <param name="punishment"></param>
public void InsertPunishRecord(Punishment punishment)
{
string strSQL = " insert into StudentPunishmentRecords(ID,EXEDATETIME,EXEUNIT,PUNISHMENT,REASON) values(";
strSQL += "'" + punishment.nID + "',#" + punishment.ExeDateTime + "#,'" + punishment.AuthorizeUnit.ToString() + "','" + punishment.Punishement.ToString() + "','" + punishment.Reason + "')";
db.ExecuteNonQuery(strSQL, oleConn);
}
/// <summary>
/// 插入个人信息
/// </summary>
/// <param name="personInfo"></param>
public void InsertPersonRecord(PersonInfo personInfo)
{
string str1 = personInfo.IsPartyMember == true ? "true" : "false";
string str2 = personInfo.IsCadre == true ? "true" : "false";
string strSQL = "insert into StudentBasicInfo(ID,GRADE,NAME,CLASS,TEAM,IsPartyMember,IsCadre,GENDER,ADDRESS,BIRTHDAY,CONTACT,MARK) values('" + personInfo.nID + "','" + personInfo.nGrade + "','" + personInfo.strName + "','" + personInfo.nClass + "','" + personInfo.nTeam + "'," + str1 + "," + str2 + ",'" + personInfo.strGender + "','" + personInfo.strAddress + "',#" + personInfo.tBirthday.ToString() + "#,'" + personInfo.strContact + "','" + personInfo.strMark + "')";
db.ExecuteNonQuery(strSQL, oleConn);
}
/// <summary>
/// 插入请假信息
/// </summary>
/// <param name="leaveInfo"></param>
public void InsertLeaveRecord(LeaveInfo leaveInfo)
{
string str = "select ID from StudentLeaveRecords where StudentLeaveRecords.ID= '" + leaveInfo.nID + "' and StudentLeaveRecords.ISBACK=false";
DataTable dt = db.ExecuteDataTable(str, oleConn);
if (dt.Rows.Count == 0)
{
string str1 = "false";
string strSQL = "insert into StudentLeaveRecords(ID,LEAVEDATE,DUEDATE,ISBACK,REASON) values('" + leaveInfo.nID + "',#" + leaveInfo.tLEAVEDATE + "#,#" + leaveInfo.tDUEDATE + "#," + str1 + ",'" + leaveInfo.strReason + "')";
db.ExecuteNonQuery(strSQL, oleConn);
}
else
{
MessageBox.Show("该学员未销假");
}
}
