代码.docx
- 文档编号:29372058
- 上传时间:2023-07-22
- 格式:DOCX
- 页数:24
- 大小:90.02KB
代码.docx
《代码.docx》由会员分享,可在线阅读,更多相关《代码.docx(24页珍藏版)》请在冰豆网上搜索。
代码
学生寝室管理系统后台代码
一、VS部分
(1)登录页面代码
publicpartialclassLoginForm:
Form
{
publicLoginForm()
{
InitializeComponent();
}
privatevoidbtnLogin_Click(objectsender,EventArgse)
{
stringsql="select*fromuserInfowhereLoginId='"+txtLoginId.Text+"'";
DataTabledt=DBHelper.GetDataTable(sql);
if(dt.Rows.Count==0)
{
MessageBox.Show("账号错误!
");
return;
}
if(dt.Rows[0]["LoginPwd"].ToString()!
=txtLoginPwd.Text)
{
MessageBox.Show("密码错误");
return;
}
MainFormmf=newMainForm();
mf.Show();
this.Hide();
}
privatevoidbtnCancel_Click(objectsender,EventArgse)
{
this.Close();
}
privatevoidLoginForm_Load(objectsender,EventArgse)
{
}
}
}
(2)学生信息管理页面代码
目的实现学生的增、删、改、查等功能。
publicpartialclassStudentForm:
Form
{
publicStudentForm()
{
InitializeComponent();
}
privatevoidStudentForm_Load(objectsender,EventArgse)
{
EnableCtrl(false);
RoomNoBind();
dgvStudent.AutoGenerateColumns=false;
StudentBind();
}
privatevoidEnableCtrl(boolisEnable)
{
txtStudentNo.Enabled=isEnable;
txtName.Enabled=isEnable;
txtClass.Enabled=isEnable;
cbRoomNo.Enabled=isEnable;
txtTel.Enabled=isEnable;
}
privatevoidRoomNoBind()
{
stringsql="select*fromroom";
cbRoomNo.DataSource=DBHelper.GetDataTable(sql);
cbRoomNo.DisplayMember="roomNo";
cbRoomNo.ValueMember="roomNo";
}
privatevoidStudentBind()
{
stringsql="select*fromstudent";
dgvStudent.DataSource=DBHelper.GetDataTable(sql);
}
privatevoidtsbAdd_Click(objectsender,EventArgse)
{
EnableCtrl(true);
tsbModify.Enabled=false;
tsbDel.Enabled=false;
tsbSave.Enabled=true;
tsbCancel.Enabled=true;
txtStudentNo.Clear();
txtName.Clear();
txtClass.Clear();
txtTel.Clear();
}
privatevoidtsbModify_Click(objectsender,EventArgse)
{
if(dgvStudent.CurrentRow==null)
{
MessageBox.Show("没有数据!
");
return;
}
EnableCtrl(true);
tsbAdd.Enabled=false;
tsbDel.Enabled=false;
tsbSave.Enabled=true;
tsbCancel.Enabled=true;
stringstudentId=dgvStudent.CurrentRow.Cells["studentId"].Value.ToString();
stringsql="select*fromstudentwherestudentId="+studentId;
DataTabledt=DBHelper.GetDataTable(sql);
txtName.Text=dt.Rows[0]["studentname"].ToString();
txtClass.Text=dt.Rows[0]["className"].ToString();
txtTel.Text=dt.Rows[0]["Tel"].ToString();
cbRoomNo.SelectedValue=dt.Rows[0]["roomNo"];
}
privatevoidtsbDel_Click(objectsender,EventArgse)
{
DialogResultresult=MessageBox.Show("确认删除?
","警告?
",
MessageBoxButtons.YesNo,MessageBoxIcon.Warning);
if(result!
=DialogResult.Yes)
{
return;
}
if(dgvStudent.CurrentRow==null)
{
MessageBox.Show("没有数据!
");
return;
}
stringStudentId=dgvStudent.CurrentRow.Cells["studentId"].Value.ToString();
stringsql="deletefromstudentwherestudentId="+StudentId;
DBHelper.ExecuteSql(sql);
StudentBind();
}
privatevoidtsbSave_Click(objectsender,EventArgse)
{
if(txtStudentNo.Text=="")
{
MessageBox.Show("学号不能为空?
!
");
return;
}
if(txtClass.Text=="")
{
MessageBox.Show("姓名不能为空?
!
");
return;
}
if(txtName.Text=="")
{
MessageBox.Show("班级不能为空?
!
");
return;
}
stringsql;
SqlParameter[]paras;
if(tsbAdd.Enabled)
{
sql="insertstudent(studentNo,studentName,className,roomNo,tel)values(@studentNo,@studentName,@className,@roomNo,@tel)";
paras=newSqlParameter[]{
newSqlParameter("@studentNo",txtStudentNo.Text),
newSqlParameter("@studentName",txtName.Text),
newSqlParameter("@className",txtClass.Text),
newSqlParameter("@roomNo",cbRoomNo.SelectedValue),
newSqlParameter("@tel",txtTel.Text)
};
}
else
{
sql="updatestudentsetstudentNo=@studentNo,studentName=@studentName,className=@className,roomNo=@roomNo,tel=@telwherestudentId=@studentId";
paras=newSqlParameter[]{
newSqlParameter("@studentNo",txtStudentNo.Text),
newSqlParameter("@studentName",txtName.Text),
newSqlParameter("@className",txtClass.Text),
newSqlParameter("@roomNo",cbRoomNo.SelectedValue),
newSqlParameter("@tel",txtTel.Text),
newSqlParameter("@studentId",dgvStudent.CurrentRow.Cells["studentId"].Value)
};
}
try
{
DBHelper.ExecuteSql(sql,paras);
StudentBind();
}
catch(Exceptionex)
{
MessageBox.Show("学号重复!
"+ex.Message);
DBHelper.con.Close();
return;
}
EnableCtrl(false);
tsbAdd.Enabled=true;
tsbModify.Enabled=true;
tsbDel.Enabled=true;
tsbSave.Enabled=false;
tsbCancel.Enabled=false;
}
privatevoidtsbCancel_Click(objectsender,EventArgse)
{
EnableCtrl(false);
tsbAdd.Enabled=true;
tsbModify.Enabled=true;
tsbDel.Enabled=true;
tsbSave.Enabled=false;
tsbCancel.Enabled=false;
}
privatevoidtsbClose_Click(objectsender,EventArgse)
{
this.Close();
}
}
}
(3)房间类型管理页面代码
publicpartialclassRoomTypeForm:
Form
{
publicRoomTypeForm()
{
InitializeComponent();
}
privatevoidRoomTypeForm_Load(objectsender,EventArgse)
{
EnableCtrl(false);
dgvRoomType.AutoGenerateColumns=false;
RoomBind();
}
privatevoidEnableCtrl(boolisEnable)
{
txtRoomType.Enabled=isEnable;
txtStudentNum.Enabled=isEnable;
}
privatevoidRoomBind()
{
stringsql="select*fromroomType";
dgvRoomType.DataSource=DBHelper.GetDataTable(sql);
}
privatevoidtsbAdd_Click(objectsender,EventArgse)
{
EnableCtrl(true);
tsbModify.Enabled=false;
tsbDel.Enabled=false;
tsbSave.Enabled=true;
tsbCancel.Enabled=true;
txtRoomType.Clear();
txtStudentNum.Clear();
}
privatevoidtsbModify_Click(objectsender,EventArgse)
{
if(dgvRoomType.CurrentRow==null)
{
MessageBox.Show("没有数据!
");
return;
}
EnableCtrl(true);
tsbAdd.Enabled=false;
tsbDel.Enabled=false;
tsbSave.Enabled=true;
tsbCancel.Enabled=true;
stringroomTypeId=dgvRoomType.CurrentRow.Cells["roomTypeId"].Value.ToString();
stringsql="select*fromroomTypewhereroomTypeId="+roomTypeId;
DataTabledt=DBHelper.GetDataTable(sql);
txtRoomType.Text=dt.Rows[0]["roomTypeName"].ToString();
txtStudentNum.Text=dt.Rows[0]["StudentNum"].ToString();
}
privatevoidtsbDel_Click(objectsender,EventArgse)
{
DialogResultresult=MessageBox.Show("确认删除y?
","警告?
",
MessageBoxButtons.YesNo,MessageBoxIcon.Warning);
if(result!
=DialogResult.Yes)
{
return;
}
if(dgvRoomType.CurrentRow==null)
{
MessageBox.Show("没有数据!
");
return;
}
stringroomTypeId=dgvRoomType.CurrentRow.Cells["roomTypeId"].Value.ToString();
stringsql="deletefromroomTypewhereroomTypeId="+roomTypeId;
try
{
DBHelper.ExecuteSql(sql);
RoomBind();
}
catch
{
MessageBox.Show("该房间有学生居住,不能删除!
");
DBHelper.con.Close();
}
}
privatevoidtsbSave_Click(objectsender,EventArgse)
{
if(txtRoomType.Text=="")
{
MessageBox.Show("房间号不能为空!
");
return;
}
stringsql;
SqlParameter[]paras;
if(tsbAdd.Enabled)
{
sql="insertroomType(roomTypeName,StudentNum)values(@roomTypeName,@StudentNum)";
paras=newSqlParameter[]{
newSqlParameter("@roomTypeName",txtRoomType.Text),
newSqlParameter("@StudentNum",txtStudentNum.Text)
};
}
else
{
sql="updateroomTypesetStudentNum=@StudentNum,roomTypeName=@roomTypeNamewhereroomTypeId=@roomTypeId";
paras=newSqlParameter[]{
newSqlParameter("@roomTypeName",txtRoomType.Text),
newSqlParameter("@StudentNum",txtStudentNum.Text),
newSqlParameter("@roomTypeId",dgvRoomType.CurrentRow.Cells["roomTypeId"].Value)
};
}
try
{
DBHelper.ExecuteSql(sql,paras);
RoomBind();
}
catch(Exceptionex)
{
MessageBox.Show(ex.Message);
DBHelper.con.Close();
return;
}
EnableCtrl(false);
tsbAdd.Enabled=true;
tsbModify.Enabled=true;
tsbDel.Enabled=true;
tsbSave.Enabled=false;
tsbCancel.Enabled=false;
}
privatevoidtsbCancel_Click(objectsender,EventArgse)
{
EnableCtrl(false);
tsbAdd.Enabled=true;
tsbModify.Enabled=true;
tsbDel.Enabled=true;
tsbSave.Enabled=false;
tsbCancel.Enabled=false;
}
privatevoidtsbClose_Click(objectsender,EventArgse)
{
this.Close();
}
}
}
(4)房间管理页面代码
publicpartialclassRoomForm:
Form
{
publicRoomForm()
{
InitializeComponent();
}
privatevoidRoomForm_Load(objectsender,EventArgse)
{
EnableCtrl(false);
RoomTypeBind();
dgvRoom.AutoGenerateColumns=false;
RoomBind();
}
privatevoidEnableCtrl(boolisEnable)
{
txtRoomNo.Enabled=isEnable;
cbRoomType.Enabled=isEnable;
}
privatevoidRoomTypeBind()
{
stringsql="select*fromroomType";
cbRoomType.DataSource=DBHelper.GetDataTable(sql);
cbRoomType.DisplayMember="roomTypeName";
cbRoomType.ValueMember="roomTypeId";
}
privatevoidRoomBind()
{
stringsql="selectroom.*,roomType.roomTypeNamefromroom,roomTypewhereroom.roomTypeId=roomType.roomTypeId";
dgvRoom.DataSource=DBHelper.GetDataTable(sql);
}
privatevoidtsbAdd_Click(objectsender,EventArgse)
{
EnableCtrl(true);
tsbModify.Enabled=false;
tsbDel.Enabled=false;
tsbSave.Enabled=true;
tsbCancel.Enabled=true;
txtRoomNo.Clear();
}
privatevoidtsbModify_Click(objectsender,EventArgse)
{
if(dgvRoom.CurrentRow==null)
{
MessageBox.Show("没有数据!
");
return;
}
EnableCtrl(true);
tsbAdd.Enabled=false;
tsbDel.Enabled=false;
tsbSave.Enabled=true;
tsbCancel.Enabled=true;
stringroomId=dgvRoom.CurrentRow.Cells["roomId"].Value.ToString();
stringsql="select*fromroomwhereroomId="+roomId;
DataTabledt=DBHelper.GetDataTable(sql);
txtRoomNo.Text=dt.Rows[0]["roomNo"].ToString();
cbRoomType.SelectedValue=dt.Rows[0]["roomTypeId"];
}
privatevoidtsbDel_Click(objectsender,EventArgse)
{
DialogResultresult=MessageBox.Show
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 代码