標(biāo)題:
c#學(xué)生信息管理系統(tǒng)源程序(設(shè)置窗體皮膚)連接數(shù)據(jù)庫SQL
[打印本頁]
作者:
canyua
時(shí)間:
2019-5-7 23:36
標(biāo)題:
c#學(xué)生信息管理系統(tǒng)源程序(設(shè)置窗體皮膚)連接數(shù)據(jù)庫SQL
基于C# 和SQL數(shù)據(jù)的做的學(xué)生信息管理系統(tǒng),能夠?qū)崿F(xiàn):
專業(yè)設(shè)置
班級(jí)設(shè)置
學(xué)生信息增刪改查
有用戶登錄權(quán)限
0.png
(3.72 KB, 下載次數(shù): 89)
下載附件
2019-5-8 01:43 上傳
單片機(jī)源程序如下:
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 = "當(dāng)前系統(tǒng)時(shí)間:"+DateTime.Now.ToString("yyyy年MM月dd日hh:mm:ss");
this.toolStripStatusLabel2.Text = " 版權(quán)所有 盜版必究";
BindXueYuan();
//獲取用戶登錄后的級(jí)別。用于顯示不同的權(quán)限按鈕
string okroles = SM_Login.myroles;
if (okroles == "1")
{
學(xué)生管理SToolStripMenuItem.Enabled = false;
系統(tǒng)信息管理XToolStripMenuItem.Enabled = false;
班級(jí)信息管理BToolStripMenuItem.Enabled = false;
contextMenuStrip1.Enabled = false;
}
if (okroles == "2")
{
系統(tǒng)信息管理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 = "當(dāng)前系統(tǒng)時(shí)間:" + DateTime.Now.ToString("yyyy年MM月dd日hh:mm:ss");
}
public static string str = "";
private void 學(xué)院設(shè)置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "學(xué)院設(shè)置";
SM_SystemAdmin sm = new SM_SystemAdmin();
//將第一窗體的權(quán)限賦予第二窗體
sm.Owner = this;
sm.ShowDialog();
}
private void 專業(yè)設(shè)置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "專業(yè)設(shè)置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 班級(jí)設(shè)置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "班級(jí)設(shè)置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 學(xué)科設(shè)置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "學(xué)科設(shè)置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 獎(jiǎng)懲設(shè)置ToolStripMenuItem_Click(object sender, EventArgs e)
{
str = "獎(jiǎng)懲設(shè)置";
SM_SystemAdmin sm = new SM_SystemAdmin();
sm.ShowDialog();
}
private void 新建學(xué)生檔案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)
{
新建學(xué)生檔案ToolStripMenuItem_Click(sender, e);
}
public static string XueHao = "";
private void 查看學(xué)生信息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("請選擇您要查看的學(xué)生");
}
}
private void 刪除學(xué)生信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
XueHao = listView1.SelectedItems[0].SubItems[1].Text;
DialogResult jieguo= MessageBox.Show("您確定要?jiǎng)h除嗎?", "提示信息", 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 添加學(xué)生信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
新建學(xué)生檔案ToolStripMenuItem_Click(sender, e);
}
private void toolStripButton2_Click(object sender, EventArgs e)
……………………
…………限于本文篇幅 余下代碼請從51黑下載附件…………
復(fù)制代碼
所有資料51hei提供下載:
16_學(xué)生管理系統(tǒng)(設(shè)置窗體皮膚).rar
(3.26 MB, 下載次數(shù): 52)
2019-5-7 23:35 上傳
點(diǎn)擊文件名下載附件
下載積分: 黑幣 -5
歡迎光臨 (http://www.torrancerestoration.com/bbs/)
Powered by Discuz! X3.1