Delphi学生学籍管理系统 第8页
frm_evaluationU奖惩信息界面public
procedure FillData;override;
end;
procedure Tfrm_evaluation.FillData;
begin
self.DataSource_info.DataSet:=Control_evaluationU.GetEvaluationArray;
self.DBGrid_info.Columns[0].Visible :=false;
end;
procedure Tfrm_evaluation.btn_addClick(Sender: TObject);
var
Evaluation:TEvaluation;
Student:TStudent;
begin
inherited;
if((edt_stdNo.Text='')) then
begin
MessageBox(Handle, '内容填写不正确！', '信息', MB_ICONEXCLAMATION);
exit;
end;
Student:=TStudent.Create;
Student:=Control_StudentU.GetStudentByStudentNo(self.edt_stdNo.Text);
if Student=nil then
begin
MessageBox(Handle, '学号填写不正确！', '信息', MB_ICONEXCLAMATION);
edt_stdNo.SetFocus;
exit;
end;
Evaluation:=TEvaluation.Create;
Evaluation.id:=edt_stdNo.Tag;
Evaluation.stdNo:=trim(self.edt_stdNo.Text);
Evaluation.Edate:=DateToStr(now);
Evaluation.Etype:=self.cbx_type.Text;
Evaluation.remark:=self.Memo_remark.Text;
if(Control_EvaluationU.AddEvaluation(Evaluation)) then
begin
MessageBox(Handle, '添加成功！', '信息', MB_ICONASTERISK);
//刷新内容
FillData;
if self.DBGrid_info.Fields[0].IsNull then
begin
self.edt_stdNo.Tag:=0;//保存id
self.edt_stdNo.Text:='';
self.edt_edate.Text :='';
self.cbx_type.ItemIndex:=0;
self.Memo_remark.Text:='';
end
else
begin
self.edt_stdNo.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
self.edt_stdNo.Text:=self.DBGrid_info.Fields[1].Value;
self.edt_edate.Text :=self.DBGrid_info.Fields[2].Value;
self.cbx_type.Text:=self.DBGrid_info.Fields[3].Value;
self.Memo_remark.Text:=self.DBGrid_info.Fields[4].Value;
end;
end
else
begin
MessageBox(Handle, '添加失败！', '信息', MB_ICONEXCLAMATION);
exit;
end;
end;
procedure Tfrm_evaluation.btn_delClick(Sender: TObject);
begin
inherited;
if MessageBox(Handle, '您确定要删除该信息', '信息',
MB_ICONQUESTION or MB_OKCANCEL) = IDOK then
begin
Control_evaluationU.Delevaluation(self.edt_stdNo.Tag);
FillData;
if self.DBGrid_info.Fields[0].IsNull then
begin
self.edt_stdNo.Tag:=0;//保存id
self.edt_stdNo.Text:='';
self.edt_edate.Text :='';
self.cbx_type.ItemIndex:=0;
self.Memo_remark.Text:='';
end
else
begin
self.edt_stdNo.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
self.edt_stdNo.Text:=self.DBGrid_info.Fields[1].Value;
self.edt_edate.Text :=self.DBGrid_info.Fields[2].Value;
self.cbx_type.Text:=self.DBGrid_info.Fields[3].Value;
self.Memo_remark.Text:=self.DBGrid_info.Fields[4].Value;
end;
end;
end;
procedure Tfrm_evaluation.btn_editClick(Sender: TObject);
var
Evaluation:TEvaluation;
Student:TStudent;
begin
inherited;
if edt_stdNo.Text ='' then
begin
MessageBox(Handle, '没有可以修改的数据！', '信息', MB_ICONEXCLAMATION);
exit;
end
else
begin
if((edt_stdNo.Text='')) then
begin
MessageBox(Handle, '内容填写不正确！', '信息', MB_ICONEXCLAMATION);
exit;
end;
Student:=TStudent.Create;
Student:=Control_StudentU.GetStudentByStudentNo(self.edt_stdNo.Text);
if Student=nil then
begin
MessageBox(Handle, '学号填写不正确！', '信息', MB_ICONEXCLAMATION);
edt_stdNo.SetFocus;
exit;
end;
Evaluation:=TEvaluation.Create;
Evaluation.id:=edt_stdNo.Tag;
Evaluation.stdNo:=trim(self.edt_stdNo.Text);
Evaluation.Edate:=trim(self.edt_edate.Text);
Evaluation.Etype:=self.cbx_type.Text;
Evaluation.remark:=self.Memo_remark.Text;
if(Control_evaluationU.Editevaluation(evaluation)) then
begin
MessageBox(Handle, '修改成功！', '信息', MB_ICONASTERISK);
//刷新内容
FillData;
end
else
begin
MessageBox(Handle, '修改失败！', '信息', MB_ICONEXCLAMATION);
exit;
end;
self.edt_stdNo.SetFocus;
end;
end;
procedure Tfrm_evaluation.DBGrid_infoCellClick(Column: TColumn);
begin
inherited;
if self.DBGrid_info.Fields[0].IsNull then
begin
self.edt_stdNo.Tag:=0;//保存id
self.edt_stdNo.Text:='';
self.edt_edate.Text :='';
self.cbx_type.ItemIndex:=0;
self.Memo_remark.Text:='';
end
else
begin
self.edt_stdNo.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
self.edt_stdNo.Text:=self.DBGrid_info.Fields[1].Value;
self.edt_edate.Text :=self.DBGrid_info.Fields[2].Value;
self.cbx_type.Text:=self.DBGrid_info.Fields[3].Value;
self.Memo_remark.Text:=self.DBGrid_info.Fields[4].Value;
end;
end;
procedure Tfrm_evaluation.btn_search_stdNoClick(Sender: TObject);
begin
inherited;
self.DataSource_info.DataSet:=
Control_evaluationU.GetEvaluationByStdNO(self.edt_stdNo_s.Text);
self.DBGrid_info.Columns[0].Visible :=false;
end;frm_experienceU教育经历界面
public
procedure FillData;override;
end;
procedure Tfrm_experience.FillData;
begin
self.DataSource_info.DataSet:=Control_experienceU.GetExperienceArray;
self.DBGrid_info.Columns[0].Visible :=false;
end;
procedure Tfrm_experience.btn_addClick(Sender: TObject);
var
Experience:TExperience;
Student:TStudent;
begin
inherited;
if((edt_stdNo.Text='') or (edt_school.Text='')
or (DTP_beginDate.Date>DTP_endDate.Date)) then
begin
MessageBox(Handle, '内容填写不正确！', '信息', MB_ICONEXCLAMATION);
exit;
end;
Student:=TStudent.Create;
Student:=Control_StudentU.GetStudentByStudentNo(self.edt_stdNo.Text);
if Student=nil then
begin
MessageBox(Handle, '学号填写不正确！', '信息', MB_ICONEXCLAMATION);
edt_stdNo.SetFocus;
exit;
end;
Experience:=TExperience.Create;
Experience.id:=edt_stdNo.Tag;
Experience.stdNo:=trim(self.edt_stdNo.Text);
Experience.beginDate:=DateToStr(self.DTP_beginDate.Date);
Experience.endDate:=DateToStr(self.DTP_endDate.Date);
Experience.school:=self.edt_school.Text;
Experience.duty:=self.edt_duty.Text;
if(Control_ExperienceU.AddExperience(Experience)) then
begin
MessageBox(Handle, '添加成功！', '信息', MB_ICONASTERISK);
//刷新内容
FillData;
if self.DBGrid_info.Fields[0].IsNull then
begin
self.edt_stdNo.Tag:=0;//保存id
self.edt_stdNo.Text:='';
self.DTP_beginDate.Date :=now;
self.DTP_endDate.Date:=now;
self.edt_school.Text:='';
self.edt_duty.Text:='';
end
else
begin
self.edt_stdNo.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
self.edt_stdNo.Text:=self.DBGrid_info.Fields[1].Value;
self.DTP_beginDate.Date :=self.DBGrid_info.Fields[2].Value;
self.DTP_endDate.Date:=self.DBGrid_info.Fields[3].Value;
self.edt_school.Text:=self.DBGrid_info.Fields[4].Value;
self.edt_duty.Text:=self.DBGrid_info.Fields[5].Value;
end;
end
else
begin
MessageBox(Handle, '添加失败！', '信息', MB_ICONEXCLAMATION);
exit;
end;
end;
procedure Tfrm_experience.btn_delClick(Sender: TObject);
begin
inherited;
if MessageBox(Handle, '您确定要删除该信息', '信息',
MB_ICONQUESTION or MB_OKCANCEL) = IDOK then
begin
Control_ExperienceU.DelExperience(self.edt_stdNo.Tag);
FillData;
if self.DBGrid_info.Fields[0].IsNull then
begin
self.edt_stdNo.Tag:=0;//
self.edt_stdNo.Text:='';
self.DTP_beginDate.Date :=now;
self.DTP_endDate.Date:=now;
self.edt_school.Text:='';
self.edt_duty.Text:='';
end
else
begin
self.edt_stdNo.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
self.edt_stdNo.Text:=self.DBGrid_info.Fields[1].Value;
self.DTP_beginDate.Date :=self.DBGrid_info.Fields[2].Value;
self.DTP_endDate.Date:=self.DBGrid_info.Fields[3].Value;
self.edt_school.Text:=self.DBGrid_info.Fields[4].Value;
self.edt_duty.Text:=self.DBGrid_info.Fields[5].Value;
end;
end;
end;
procedure Tfrm_experience.btn_editClick(Sender: TObject);
var
Experience:TExperience;
Student:TStudent;
begin
inherited;
if edt_stdNo.Text ='' then
begin
MessageBox(Handle, '没有可以修改的数据！', '信息', MB_ICONEXCLAMATION);
exit;
end
else
begin
if((edt_stdNo.Text='') or (edt_school.Text='')
or (DTP_beginDate.Date>DTP_endDate.Date)) then
begin
MessageBox(Handle, '内容填写不正确！', '信息', MB_ICONEXCLAMATION);
exit;
end;
Student:=TStudent.Create;
Student:=Control_StudentU.GetStudentByStudentNo(self.edt_stdNo.Text);
if Student=nil then
begin
MessageBox(Handle, '学号填写不正确！', '信息', MB_ICONEXCLAMATION);
edt_stdNo.SetFocus;
exit;
end;
Experience:=TExperience.Create;
Experience.id:=edt_stdNo.Tag;
Experience.stdNo:=trim(self.edt_stdNo.Text);
Experience.beginDate:=DateToStr(self.DTP_beginDate.Date);
Experience.endDate:=DateToStr(self.DTP_endDate.Date);
Experience.school:=self.edt_school.Text;
Experience.duty:=self.edt_duty.Text;
if(Control_ExperienceU.EditExperience(Experience)) then
begin
MessageBox(Handle, '修改成功！', '信息', MB_ICONASTERISK);
//刷新内容
FillData;
end
else
begin
MessageBox(Handle, '修改失败！', '信息', MB_ICONEXCLAMATION);
exit;
end;
self.edt_stdNo.SetFocus;
end;
end;
procedure Tfrm_experience.DBGrid_infoCellClick(Column: TColumn);
begin
inherited;
if self.DBGrid_info.Fields[0].IsNull then
begin
self.edt_stdNo.Tag:=0;//
self.edt_stdNo.Text:='';
self.DTP_beginDate.Date :=now;
self.DTP_endDate.Date:=now;
self.edt_school.Text:='';
self.edt_duty.Text:='';
end
else
begin
self.edt_stdNo.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
self.edt_stdNo.Text:=self.DBGrid_info.Fields[1].Value;
self.DTP_beginDate.Date :=self.DBGrid_info.Fields[2].Value;
self.DTP_endDate.Date:=self.DBGrid_info.Fields[3].Value;
self.edt_school.Text:=self.DBGrid_info.Fields[4].Value;
self.edt_duty.Text:=self.DBGrid_info.Fields[5].Value;
end;
end;
procedure Tfrm_experience.btn_search_stdNoClick(Sender: TObject);
begin
inherited;
self.DataSource_info.DataSet:=
Control_experienceU.GetExperienceByStdNO(self.edt_stdNo_s.Text);
self.DBGrid_info.Columns[0].Visible :=false;
end;frm_infoU各管理窗体模板
procedure Tfrm_info.btn_exitClick(Sender: TObject);
begin
close;
end;
procedure Tfrm_info.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;
procedure Tfrm_info.FormShow(Sender: TObject);
begin
FillData;
end;
procedure Tfrm_info.DBGrid_infoCellClick(Column: TColumn);
begin
if self.DBGrid_info.Fields[0].IsNull then
exit;
end;