c#学生信息管理系统源程序（设置窗体皮肤）连接数据库SQL -

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
namespace SR_StudentManage
{
public partial class SM_Main : Form
{
static string ConnStr = ConfigurationSettings.AppSettings["ConnStr"];
SqlConnection conn = new SqlConnection(ConnStr);
public SM_Main()
{
InitializeComponent();
}
private void SM_Main_Load(object sender, EventArgs e)
{
skinEngine1.SkinFile = System.Environment.CurrentDirectory + "\\skin\\GlassGreen.ssk";
this.toolStripStatusLabel1.Text = "当前系统时间："+DateTime.Now.ToString("yyyy年MM月dd日hh:mm:ss");
this.toolStripStatusLabel2.Text = " 版权所有盗版必究";
BindXueYuan();
//获取用户登录后的级别。用于显示不同的权限按钮
string okroles = SM_Login.myroles;
if (okroles == "1")
{
学生管理SToolStripMenuItem.Enabled = false;
系统信息管理XToolStripMenuItem.Enabled = false;
班级信息管理BToolStripMenuItem.Enabled = false;
contextMenuStrip1.Enabled = false;
}
if (okroles == "2")
{
系统信息管理XToolStripMenuItem.Enabled = false;
}
}
#region ***********************树形目录**************************
void BindXueYuan()
{
string sql = "select * from XueYuanInfo";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TreeNode xueyuan_tn = new TreeNode(ds.Tables[0].Rows[i]["XueYuanName"].ToString());
xueyuan_tn.Tag = ds.Tables[0].Rows[i]["XueYuanCode"].ToString();
xueyuan_tn.ImageIndex = 0;
treeView1.Nodes.Add(xueyuan_tn);
BindZhuanYe(xueyuan_tn);
}
}
}
void BindZhuanYe(TreeNode xueyuan_tn)
{
string sql = "select * from ZhuanYeInfo where XueYuanCode='" + xueyuan_tn .Tag+ "'";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TreeNode zhuanye_tn = new TreeNode(ds.Tables[0].Rows[i]["ZhuanYeName"].ToString());
zhuanye_tn.Tag = ds.Tables[0].Rows[i]["ZhuanYeCode"].ToString();
zhuanye_tn.ImageIndex = 1;
zhuanye_tn.SelectedImageIndex = 1;
xueyuan_tn.Nodes.Add(zhuanye_tn);
BindBanJi(zhuanye_tn);
}
}
}
void BindBanJi(TreeNode zhuanye_tn)
{
string sql = "select * from BanJiInfo where ZhuanYeCode='" + zhuanye_tn.Tag + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TreeNode banji_tn = new TreeNode(ds.Tables[0].Rows[i]["BanJiName"].ToString());
banji_tn.Tag = ds.Tables[0].Rows[i]["BanJiName"].ToString();
banji_tn.ImageIndex = 2;
banji_tn.SelectedImageIndex = 2;
zhuanye_tn.Nodes.Add(banji_tn);
}
}
}
#endregion
private void timer1_Tick(object sender, EventArgs e)
{
this.toolStripStatusLabel1.Text = "当前系统时间：" + DateTime.Now.ToString("yyyy年MM月dd日hh:mm:ss");
}
public static string str = "";
private void 学院设置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "学院设置";
SM_SystemAdmin sm = new SM_SystemAdmin();
//将第一窗体的权限赋予第二窗体
sm.Owner = this;
sm.ShowDialog();
}
private void 专业设置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "专业设置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 班级设置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "班级设置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 学科设置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "学科设置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 奖惩设置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "奖惩设置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 新建学生档案ToolStripMenuItem_Click(object sender, EventArgs e)
{
SM_AddStudent sma = new SM_AddStudent();
sma.ShowDialog();
}
private void treeView1_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
listView1.Items.Clear();
string banjiname = treeView1.SelectedNode.Tag.ToString();
string sql = "select * from XueShengInfo where BanJiName='" + banjiname + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListViewItem lvi = new ListViewItem(ds.Tables[0].Rows[i]["XueShengName"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengXueHao"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengSex"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengSID"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengTel"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengAddress"].ToString());
listView1.Items.Add(lvi);
}
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
新建学生档案ToolStripMenuItem_Click(sender, e);
}
public static string XueHao = "";
private void 查看学生信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
XueHao = listView1.SelectedItems[0].SubItems[1].Text;
SM_ShowStudent sms = new SM_ShowStudent();
sms.ShowDialog();
}
catch {
MessageBox.Show("请选择您要查看的学生");
}
}
private void 删除学生信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
XueHao = listView1.SelectedItems[0].SubItems[1].Text;
DialogResult jieguo= MessageBox.Show("您确定要删除吗？", "提示信息", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (DialogResult.OK == jieguo)
{
string sql = "delete from XueShengInfo where XueShengXueHao='" + XueHao + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
int i = cmd.ExecuteNonQuery();
conn.Close();
if (i > 0)
{
MessageBox.Show("删除成功");
List();
}
}
}
void List()
{
listView1.Items.Clear();
string banjiname = treeView1.SelectedNode.Tag.ToString();
string sql = "select * from XueShengInfo where BanJiName='" + banjiname + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListViewItem lvi = new ListViewItem(ds.Tables[0].Rows[i]["XueShengName"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengXueHao"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengSex"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengSID"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengTel"].ToString());
lvi.SubItems.Add(ds.Tables[0].Rows[i]["XueShengAddress"].ToString());
listView1.Items.Add(lvi);
}
}
}
private void 添加学生信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
新建学生档案ToolStripMenuItem_Click(sender, e);
}
private void toolStripButton2_Click(object sender, EventArgs e)
……………………
…………限于本文篇幅余下代码请从51黑下载附件…………

复制代码