教师管理操作流程Word文档格式.docx
《教师管理操作流程Word文档格式.docx》由会员分享,可在线阅读,更多相关《教师管理操作流程Word文档格式.docx(9页珍藏版)》请在冰豆网上搜索。
{0}'
ANDLoginPwd='
{1}'
"
loginId,loginPwd);
try
SqlCommandcommand=newSqlCommand(sql,;
count=(int)();
if(count==1)
isValidUser=true;
}
else
index++;
if(index<
=3)
message="
用户名或密码不存在!
;
elseif(index>
();
isValidUser=false;
catch(Exceptionex)
message=;
;
查询修改信息
查询教师基本信息(代码区域:
TeacherBaseFormteacherBaseForm=newTeacherBaseForm();
TeacherBaseForm(教师基本信息窗体)
查询及修改学生信息(代码区域:
UpdateStudentFormupdateStudentForm=newUpdateStudentForm();
(查询及修改信息窗体)
AddScoreForm(学生成绩录入窗体)
录入按钮代码:
stringsql=("
selectStudentId,StudentNo,StudentNamefromStudentwhereStudentId='
;
SqlDataReaderreader=();
while())
id=(int)reader["
StudentId"
];
no=(string)reader["
StudentNo"
name=(string)reader["
StudentName"
finally
if(TianJia())
if==(id)&
&
==no&
==name)
stringstudentName=;
stringsdudentNo=;
stringsubject=;
stringscore=;
intclassId=GetClassId();
stringstudentId=;
stringsql1=("
insertintoScore(StudentNo,Subject,SScore,SName,ClassId,StudentId)values('
'
{2}'
{3}'
{4}'
{5})"
sdudentNo,subject,score,studentName,classId,studentId);
SqlCommandcommand=newSqlCommand(sql1,;
intresult=();
if(result!
=1)
("
添加失败"
"
输入提示"
,;
添加成功"
//("
操作数据库出错!
//;
您输入的学生在数据库中没有,请重新输入"
privatevoidAddScoreForm_Load(objectsender,EventArgse)
stringsql="
selectgradeNamefromGrade"
stringgradeName=(string)reader[0];
stringsql1="
selectSubjectNamefromSubject"
stringsubName=(string)reader[0];
privatevoidcboGrade_SelectedIndexChanged(objectsender,EventArgse)
if!
="
intgradeId=-1;
selectGradeIdfromGradewhereGradeName='
if())
gradeId=(int)reader[0];
操作数据库出错"
);
sql="
SELECTClassNameFROMClassWHEREGradeId="
+gradeId;
=sql;
stringclassName="
className=(string)reader["
ClassName"
privatevoidtxtId_TextChanged(objectsender,EventArgse)
UpdateScoreForm(更新成绩窗体)
保存按钮代码:
DialogResultresult=("
确实要将修改保存到数据库吗"
if(result==
SqlCommandBuilderbuilder=newSqlCommandBuilder(dataAdapter);
(dataSet,"
Score"
保存成功"
保存失败"