c#學生信息管理系統源程序（設置窗體皮膚）連接數據庫SQL

ID:155141 · 發表于 2019-5-7 23:36

基于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黑下載附件…………

復制代碼

所有資料51hei提供下載:

16_學生管理系統（設置窗體皮膚）.rar (3.26 MB, 下載次數: 52)

帳號		自動登錄	找回密碼
密碼			立即注冊

久久久久久久999_99精品久久精品一区二区爱城_成人欧美一区二区三区在线播放_国产精品日本一区二区不卡视频_国产午夜视频_欧美精品在线观看免费

c#學生信息管理系統源程序（設置窗體皮膚）連接數據庫SQL

評分