using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?DormitoryManage
{
????public?partial?class?ActPlanForm?:?Form
????{
????????public?ActPlanForm（）
????????{
????????????InitializeComponent（）;
????????}
????????//本月活動計劃窗口加載事件
????????private?void?ActPlanForm_Load（object?sender?EventArgs?e）
????????{
????????????//設置列表視圖的屬性
????????????lvActPlan.GridLines?=?true;
????????????lvActPlan.View?=?View.Details;
????????????lvActPlan.FullRowSelect?=?true;
????????????lvActPlan.ForeColor?=?Color.Green;

????????????lblInfor.Visible?=?false;???????????//設置提醒修改的標簽為不可見
????????????btmAddModify.Visible?=?false;???????//設置修改按鈕為不可見

????????????//調用填充列表視圖的方法
????????????ShowActPlan（）;
????????}

????????//在列表視圖中顯示數據的方法
????????private?void?ShowActPlan（）
????????{
????????????string?sql=string.Format（“select?IdDormIdNameActPlan?from?ActPlan?where?DormId={0}“GetDormId（））;
????????????SqlCommand?command?=?new?SqlCommand（sql?DBHelper.connection）;
????????????
????????????try
????????????{
????????????????DBHelper.connection.Open（）;
????????????????SqlDataReader?dataReader?=?command.ExecuteReader（）;
????????????????if?（dataReader.HasRows）
????????????????{
????????????????????while?（dataReader.Read（））
????????????????????{
????????????????????????ListViewItem?lviActPlan?=?new?ListViewItem（dataReader[“DormId“].ToString（））;
????????????????????????lviActPlan.Tag?=?（int）dataReader[“Id“];
????????????????????????lvActPlan.Items.Add（lviActPlan）;
????????????????????????lviActPlan.SubItems.AddRange（new?string[]?{?dataReader[“Name“].ToString（）?dataReader[“ActPlan“].ToString（）?}）;

????????????????????}
????????????????????dataReader.Close（）;

????????????????????int?width?=?lvActPlan.Width?/?6;

????????????????????ColumnHeader?header;

????????????????????header?=?new?ColumnHeader（）;
????????????????????header.Text?=?“宿舍編號“;
????????????????????header.Width?=?width;
????????????????????lvActPlan.Columns.Add（header）;

????????????????????header?=?new?ColumnHeader（）;
????????????????????header.Text?=?“活動名稱“;
????????????????????header.Width?=?width;
????????????????????lvActPlan.Columns.Add（header）;

????????????????????header?=?new?ColumnHeader（）;
????????????????????header.Text?=?“具體計劃“;
????????????????????header.Width?=?width?*?4;
????????????????????lvActPlan.Columns.Add（header）;
????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“本月暫無活動計劃！““操作提示“MessageBoxButtons.OKMessageBoxIcon.Information）;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message）;
????????????}
????????????finally
????????????{
????????????????DBHelper.connection.Close（）;
????????????}
????????}

????????///?

????????///?根據登錄號碼返回宿舍編號

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????3145728??2008-11-10?20:48??寢室管理系統\Data?Source\StuDormManage.mdf

?????文件????1048576??2008-11-10?20:48??寢室管理系統\Data?Source\StuDormManage_log.ldf

?????文件??????12186??2008-11-08?19:16??寢室管理系統\DormitoryManage\ActPlanForm.cs

?????文件??????12242??2008-10-08?09:37??寢室管理系統\DormitoryManage\ActPlanForm.Designer.cs

?????文件??????17843??2008-10-08?09:37??寢室管理系統\DormitoryManage\ActPlanForm.resx

?????文件??????11240??2008-11-08?20:17??寢室管理系統\DormitoryManage\AddAdminForm.cs

?????文件??????20767??2008-11-08?20:17??寢室管理系統\DormitoryManage\AddAdminForm.Designer.cs

?????文件???????5814??2008-11-08?20:17??寢室管理系統\DormitoryManage\AddAdminForm.resx

?????文件??????14333??2008-11-08?20:18??寢室管理系統\DormitoryManage\AddStudentForm.cs

?????文件??????25011??2008-11-08?20:18??寢室管理系統\DormitoryManage\AddStudentForm.Designer.cs

?????文件??????11792??2008-11-08?20:18??寢室管理系統\DormitoryManage\AddStudentForm.resx

?????文件??????11362??2008-11-08?20:19??寢室管理系統\DormitoryManage\AddTeacherForm.cs

?????文件??????20474??2008-11-08?20:19??寢室管理系統\DormitoryManage\AddTeacherForm.Designer.cs

?????文件???????5814??2008-11-08?20:19??寢室管理系統\DormitoryManage\AddTeacherForm.resx

?????文件???????5660??2008-11-08?20:20??寢室管理系統\DormitoryManage\AmendSPwdForm.cs

?????文件??????10145??2008-11-08?20:20??寢室管理系統\DormitoryManage\AmendSPwdForm.Designer.cs

?????文件???????5814??2008-11-08?20:20??寢室管理系統\DormitoryManage\AmendSPwdForm.resx

?????文件??????13621??2008-11-10?19:42??寢室管理系統\DormitoryManage\AmendStuForm.cs

?????文件??????21328??2008-11-08?20:21??寢室管理系統\DormitoryManage\AmendStuForm.Designer.cs

?????文件???????5814??2008-11-08?20:21??寢室管理系統\DormitoryManage\AmendStuForm.resx

?????文件?????946176??2009-05-10?19:21??寢室管理系統\DormitoryManage\bin\Debug\DormitoryManage.exe

?????文件?????267776??2009-05-10?19:21??寢室管理系統\DormitoryManage\bin\Debug\DormitoryManage.pdb

?????文件???????5632??2008-09-28?10:29??寢室管理系統\DormitoryManage\bin\Debug\DormitoryManage.vshost.exe

?????文件????????377??2008-11-08?13:59??寢室管理系統\DormitoryManage\DBHelper.cs

?????文件??????20426??2008-11-08?20:22??寢室管理系統\DormitoryManage\DormAdminForm.cs

?????文件??????25537??2008-11-08?20:22??寢室管理系統\DormitoryManage\DormAdminForm.Designer.cs

?????文件???????6203??2008-11-08?20:22??寢室管理系統\DormitoryManage\DormAdminForm.resx

?????文件??????11776??2008-11-08?20:47??寢室管理系統\DormitoryManage\DormitoryManage.csproj

?????文件????????168??2008-09-28?10:29??寢室管理系統\DormitoryManage\DormitoryManage.csproj.user

?????文件????????494??2008-11-08?14:14??寢室管理系統\DormitoryManage\HelpFormB.cs

............此處省略105個文件信息