using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
namespace SamsPoint.Forms
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class fmSAMS_Default : System.Windows.Forms.Form
{
fmXX_JBXX fmxx=null;
fmXX_NJ_BJ fmnj=null;
fmStudentData fms=null;
Classes.XX_JBXXClass xx=new SamsPoint.Classes.XX_JBXXClass();
Classes.DB db=new SamsPoint.Classes.DB();
DataSet ds=new DataSet();
DataSet dsmsg=new DataSet();
public static string xxdm;
public static string xdm;
public static string fsjgstr;
private System.Windows.Forms.Panel paneltop;
private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem miXX_JBXX;
private System.Windows.Forms.MenuItem miXS_JBXX;
private System.Windows.Forms.MenuItem miXJ_GL;
private System.Windows.Forms.MenuItem miQuery;
private System.Windows.Forms.MenuItem miStat_Report;
private System.Windows.Forms.MenuItem miSys_Manager;
private System.Windows.Forms.MenuItem miHelp;
private System.Windows.Forms.MenuItem miExit;
private System.Windows.Forms.Panel panelbottom;
private System.Windows.Forms.Panel panel1;
public System.Windows.Forms.TabControl tabControl1;
private System.Windows.Forms.TabPage tabPage1;
private System.Windows.Forms.Splitter splitter1;
private System.Windows.Forms.TreeView tvFunction;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Panel panel2;
public System.Windows.Forms.Panel panelfill;
private System.Windows.Forms.MenuItem miXX_JBXX_SZ;
private System.Windows.Forms.LinkLabel linkLabelmsg;
private System.Windows.Forms.ImageList imageList1;
public System.Windows.Forms.TabPage tabPage2;
public System.Windows.Forms.TreeView treeView1;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.LinkLabel linkLabel1;
private System.ComponentModel.IContainer components;
private delegate void TreeAfterSelect(object tn);
private event TreeAfterSelect eTreeAflterSelect;
public fmSAMS_Default()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(fmSAMS_Default));
this.paneltop = new System.Windows.Forms.Panel();
this.button1 = new System.Windows.Forms.Button();
this.linkLabelmsg = new System.Windows.Forms.LinkLabel();
this.mainMenu1 = new System.Windows.Forms.MainMenu();
this.miXX_JBXX = new System.Windows.Forms.MenuItem();
this.miXX_JBXX_SZ = new System.Windows.Forms.MenuItem();
this.miXS_JBXX = new System.Windows.Forms.MenuItem();
this.miXJ_GL = new System.Windows.Forms.MenuItem();
this.miQuery = new System.Windows.Forms.MenuItem();
this.miStat_Report = new System.Windows.Forms.MenuItem();
this.miSys_Manager = new System.Windows.Forms.MenuItem();
this.miHelp = new System.Windows.Forms.MenuItem();
this.miExit = new System.Windows.Forms.MenuItem();
this.panelbottom = new System.Windows.Forms.Panel();
this.panel4 = new System.Windows.Forms.Panel();
this.panelfill = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.splitter1 = new System.Windows.Forms.Splitter();
this.panel1 = new System.Windows.Forms.Panel();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.tvFunction = new System.Windows.Forms.TreeView();
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
this.tabPage2 = new System.Windows.Forms.TabPage();
this.treeView1 = new System.Windows.Forms.TreeView();
this.panel3 = new System.Windows.Forms.Panel();
this.linkLabel1 = new System.Windows.Forms.LinkLabel();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.paneltop.SuspendLayout();
this.panelbottom.SuspendLayout();
this.panel4.SuspendLayout();
this.panel1.SuspendLayout();
this.tabControl1.SuspendLayout();
this.tabPage1.SuspendLayout();
this.tabPage2.SuspendLayout();
this.panel3.SuspendLayout();
this.SuspendLayout();
//
// paneltop
//
this.paneltop.AllowDrop = true;
this.paneltop.Controls.Add(this.button1);
this.paneltop.Controls.Add(this.linkLabelmsg);
this.paneltop.Dock = System.Windows.Forms.DockStyle.Top;
this.paneltop.Location = new System.Drawing.Point(0, 0);
this.paneltop.Name = "paneltop";
this.paneltop.Size = new System.Drawing.Size(792, 24);
this.paneltop.TabIndex = 0;
this.paneltop.TabStop = true;
//
// button1
//
this.button1.Location = new System.Drawing.Point(280, 0);
this.button1.Name = "button1";
this.button1.TabIndex = 1;
this.button1.Text = "button1";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// linkLabelmsg
//
this.linkLabelmsg.Location = new System.Drawing.Point(592, 0);
this.linkLabelmsg.Name = "linkLabelmsg";
this.linkLabelmsg.Size = new System.Drawing.Size(208, 40);
this.linkLabelmsg.TabIndex = 0;
this.linkLabelmsg.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.linkLabelmsg_LinkClicked);
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.miXX_JBXX,
this.miXS_JBXX,
this.miXJ_GL,
this.miQuery,
this.miStat_Report,
this.miSys_Manager,
this.miHelp,
this.miExit});
//
// miXX_JBXX
//
this.miXX_JBXX.Index = 0;
this.miXX_JBXX.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.miXX_JBXX_SZ});
this.miXX_JBXX.Text = "学校信息管理";
//
// miXX_JBXX_SZ
//
this.miXX_JBXX_SZ.Index = 0;
this.miXX_JBXX_SZ.Text = "学校基本信息设置";
this.miXX_JBXX_SZ.Click += new System.EventHandler(this.miXX_JBXX_SZ_Click);
//
// miXS_JBXX
//
this.miXS_JBXX.Index = 1;
this.miXS_JBXX.Text = "学生信息管理";
//
// miXJ_GL
//
this.miXJ_GL.Index = 2;
this.miXJ_GL.Text = "学籍变更管理";
//
// miQuery
//
this.miQuery.Index = 3;
this.miQuery.Text = "信息查询";
//
// miStat_Report
//
this.miStat_Report.Index = 4;
this.miStat_Report.Text = "统计报表";
//
// miSys_Manager
//
this.miSys_Manager.Index = 5;
this.miSys_Manager.Text = "系统管理";
//
// miHelp
//
this.miHelp.Index = 6;
this.miHelp.Text = "帮助";
//
// miExit
//
this.miExit.Index = 7;
this.miExit.Text = "退出";
this.miExit.Click += new System.EventHandler(this.miExit_Click);
//
// panelbottom
//
this.panelbottom.Controls.Add(this.panel4);
this.panelbottom.Controls.Add(this.splitter1);
this.panelbottom.Controls.Add(this.panel1);
this.panelbottom.Dock = System.Windows.Forms.DockStyle.Fill;
this.panelbottom.Location = new System.Drawing.Point(0, 24);
this.panelbottom.Name = "panelbottom";
this.panelbottom.Size = new System.Drawing.Size(792, 529);
this.panelbottom.TabIndex = 1;
//
// panel4
//
this.panel4.Controls.Add(this.panelfill);
this.panel4.Controls.Add(this.panel2);
this.panel4.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel4.Location = new System.Drawing.Point(163, 0);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(629, 529);
this.panel4.TabIndex = 2;
//
// panelfill
//
this.panelfill.Dock = System.Windows.Forms.DockStyle.Fill;
this.panelfill.Location = new System.Drawing.Point(0, 8);
this.panelfill.Name = "panelfill";
this.panelfill.Size = new System.Drawing.Size(629, 521);
this.panelfill.TabIndex = 1;
//
// panel2
//
this.panel2.Dock = System.Windows.Forms.DockStyle.Top;
this.panel2.Location = new System.Drawing.Point(0, 0);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(629, 8);
this.panel2.TabIndex = 0;
//
// splitter1
//
this.splitter1.Location = new System.Drawing.Point(160, 0);
this.splitter1.Name = "splitter1";
this.splitter1.Size = new System.Drawing.Size(3, 529);
this.splitter1.TabIndex = 1;
this.splitter1.TabStop = false;
//
// panel1
//
this.panel1.Controls.Add(this.tabControl1);
this.panel1.Dock = System.Windows.Forms.DockStyle.Left;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(160, 529);
this.panel1.TabIndex = 0;
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.tabControl1.Location = new System.Drawing.Point(0, 0);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(160, 529);
this.tabControl1.TabIndex = 0;
//
// tabPage1
//
this.tabPage1.Controls.Add(this.tvFunction);
this.tabPage1.Location = new System.Drawing.Point(4, 21);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Size = new System.Drawing.Size(152, 504);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "功能";
//
// tvFunction
//
this.tvFunction.Dock = System.Windows.Forms.DockStyle.Fill;
this.tvFunction.ImageList = this.imageList1;
this.tvFunction.Location = new System.Drawing.Point(0, 0);
this.tvFunction.Name = "tvFunction";
this.tvFunction.Nodes.AddRange(new System.Windows.Forms.TreeNode[] {
new System.Windows.Forms.TreeNode("学校信息管理", 0, 1, new System.Windows.Forms.TreeNode[] {
new System.Windows.Forms.TreeNode("学校基本信息设置", 2, 3),
new System.Windows.Forms.TreeNode("年级班级设置", 2, 3)}),
new System.Windows.Forms.TreeNode("学生学籍管理", new System.Windows.Forms.TreeNode[] {
new System.Windows.Forms.TreeNode("学生基本信息", 2, 3),
new System.Windows.Forms.TreeNode("学生简历和家庭信息", 2, 3),
new System.Windows.Forms.TreeNode("经济贫困生与资助登记", 2, 3),
new System.Windows.Forms.TreeNode("新生分班", 2, 3)}),
new System.Windows.Forms.TreeNode("学籍变更管理", new System.Windows.Forms.TreeNode[] {
new System.Windows.Forms.TreeNode("学籍变更", 2, 3),
new System.Windows.Forms.TreeNode("毕业信息登记", 2, 3),
new System.Windows.Forms.TreeNode("学籍档案移交", 2, 3)}),
new System.Windows.Forms.TreeNode("信息查询", new System.Windows.Forms.TreeNode[] {
new System.Windows.Forms.TreeNode("学生基本信息查询", 2, 3),
new System.Windows.Forms.TreeNode("学籍变更信息查询", 2, 3),
new System.Windows.Forms.TreeNode("奖励与处分", 2, 3),
new System.Windows.Forms.TreeNode("考试成绩和综合素质评价", 2, 3),
new System.Windows.Forms.TreeNode("自定义查询统计", 2, 3)}),
new System.Windows.Forms.TreeNode("统计报表"),
new System.Windows.Forms.TreeNode("系统管理", new System.Windows.Forms.TreeNode[] {
new System.Windows.Forms.TreeNode("用户管理", 2, 3),
new System.Windows.Forms.TreeNode("系统维护", 2, 3)}),
new System.Windows.Forms.TreeNode("消息")});
this.tvFunction.SelectedImageIndex = 1;
this.tvFunction.Size = new System.Drawing.Size(152, 504);
this.tvFunction.TabIndex = 2;
this.tvFunction.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.tvFunction_AfterSelect);
//
// imageList1
//
this.imageList1.ImageSize = new System.Drawing.Size(16, 16);
this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
//
// tabPage2
//
this.tabPage2.Controls.Add(this.treeView1);
this.tabPage2.Controls.Add(this.panel3);
this.tabPage2.Location = new System.Drawing.Point(4, 21);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Size = new System.Drawing.Size(152, 504);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "索引";
//
// treeView1
//
this.treeView1.Dock = System.Windows.Forms.DockStyle.Fill;
this.treeView1.ImageList = this.imageList1;
this.treeView1.Location = new System.Drawing.Point(0, 24);
this.treeView1.Name = "treeView1";
this.treeView1.Size = new System.Drawing.Size(152, 480);
this.treeView1.TabIndex = 0;
this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterSelect);
//
// panel3
//
this.panel3.Controls.Add(this.linkLabel1);
this.panel3.Dock = System.Windows.Forms.DockStyle.Top;
this.panel3.Location = new System.Drawing.Point(0, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(152, 24);
this.panel3.TabIndex = 2;
//
// linkLabel1
//
this.linkLabel1.AutoSize = true;
this.linkLabel1.Location = new System.Drawing.Point(48, 8);
this.linkLabel1.Name = "linkLabel1";
this.linkLabel1.Size = new System.Drawing.Size(54, 17);
this.linkLabel1.TabIndex = 0;
this.linkLabel1.TabStop = true;
this.linkLabel1.Text = "关闭索引";
this.linkLabel1.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.linkLabel1_LinkClicked);
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=TLB;packet size=4096;user id=sa;data source=/"192.168.0.14/";persist" +
" security info=False";
//
// fmSAMS_Default
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(792, 553);
this.Controls.Add(this.panelbottom);
this.Controls.Add(this.paneltop);
this.Menu = this.mainMenu1;
this.Name = "fmSAMS_Default";
this.Text = "三恩电子学籍管理系统";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.fmSAMS_Default_Load);
this.paneltop.ResumeLayout(false);
this.panelbottom.ResumeLayout(false);
this.panel4.ResumeLayout(false);
this.panel1.ResumeLayout(false);
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.tabPage2.ResumeLayout(false);
this.panel3.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
private void miExit_Click(object sender, System.EventArgs e)
{
this.Dispose();
Application.Exit();
}
private void tvFunction_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
//LoadData();
string selectnode=this.tvFunction.SelectedNode.Text.Trim();
this.tabControl1.Controls.Remove(this.tabPage2);
foreach(Control ctrl in this.panelfill.Controls)
{
ctrl.Dispose();
}
if(selectnode.Equals("学校基本信息设置"))
{
fmxx=new fmXX_JBXX();
this.panelfill.Visible=true;
fmxx.TopLevel=false;
this.panelfill.Contains(fmxx);
fmxx.Location = new Point(0,0);
fmxx.TopLevel = false;
fmxx.TopMost = false;
fmxx.ControlBox = false;
fmxx.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
fmxx.Size = this.panelfill.ClientSize;
fmxx.Parent=this.panelfill;
fmxx.Dock=DockStyle.Fill;
fmxx.Show();
}
else if(selectnode.Equals("年级班级设置"))
{
fmnj=new fmXX_NJ_BJ();
this.panelfill.Visible=true;
fmnj.TopLevel=false;
this.panelfill.Contains(fmnj);
fmnj.Location=new Point(0,0);
fmnj.TopLevel=false;
fmnj.TopMost=false;
fmnj.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmnj.Size=this.panelfill.ClientSize;
fmnj.Parent=this.panelfill;
fmnj.Dock=DockStyle.Fill;
fmnj.Show();
}
else if(selectnode.Equals("学生基本信息"))
{
this.AddTree();
//this.treeView1.ExpandAll();
fms=new fmStudentData(this);
this.eTreeAflterSelect+=new TreeAfterSelect(fms.RefreshUI);
this.tabControl1.Controls.Add(this.tabPage2);
fms.TopLevel=false;
this.panelfill.Contains(fms);
fms.Location=new Point(0,0);
fms.TopLevel=false;
fms.TopMost=false;
fms.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fms.Size=this.panelfill.ClientSize;
fms.Parent=this.panelfill;
fms.Dock=DockStyle.Fill;
fms.Show();
this.tabControl1.SelectedIndex=1;
}
else if(this.tvFunction.SelectedNode.Text.Equals("学生简历和家庭信息"))
{
fmXS_JL_JTXX fmjl=new fmXS_JL_JTXX();
AddTreeJL_JT();
this.eTreeAflterSelect+=new TreeAfterSelect(fmjl.RefreshUI);
this.tabControl1.Controls.Add(this.tabPage2);
fmjl.TopLevel=false;
this.panelfill.Contains(fmjl);
fmjl.Location=new Point(0,0);
fmjl.TopLevel=false;
fmjl.TopMost=false;
fmjl.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmjl.Size=this.panelfill.ClientSize;
fmjl.Parent=this.panelfill;
fmjl.Show();
this.tabControl1.SelectedIndex=1;
}
else if(selectnode.Equals("经济贫困生与资助登记"))
{
fmXS_PKZZ fmpk=new fmXS_PKZZ();
AddTreeJL_JT();
this.eTreeAflterSelect+=new TreeAfterSelect(fmpk.RefreshUI);
this.tabControl1.Controls.Add(this.tabPage2);
fmpk.TopLevel=false;
this.panelfill.Contains(fmpk);
fmpk.Location=new Point(0,0);
fmpk.TopLevel=false;
fmpk.TopMost=false;
fmpk.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmpk.Size=this.panelfill.ClientSize;
fmpk.Parent=this.panelfill;
fmpk.Show();
this.tabControl1.SelectedIndex=1;
}
else if(selectnode.Equals("新生分班"))
{
fmStudentTeam fmteam=new fmStudentTeam(this);
fmteam.TopLevel=false;
this.panelfill.Contains(fmteam);
fmteam.Location=new Point(0,0);
fmteam.TopLevel=false;
fmteam.TopMost=false;
fmteam.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmteam.Size=this.panelfill.ClientSize;
fmteam.Parent=this.panelfill;
fmteam.Show();
}
else if(selectnode.Equals("学籍变更"))
{
fmXS_XJYD fmxjyd=new fmXS_XJYD(this);
AddTreeJL_JT();
this.eTreeAflterSelect+=new TreeAfterSelect(fmxjyd.RefreshUI);
this.tabControl1.Controls.Add(this.tabPage2);
fmxjyd.TopLevel=false;
this.panelfill.Contains(fmxjyd);
fmxjyd.Location=new Point(0,0);
fmxjyd.TopLevel=false;
fmxjyd.TopMost=false;
fmxjyd.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmxjyd.Size=this.panelfill.ClientSize;
fmxjyd.Parent=this.panelfill;
fmxjyd.Show();
//fms.ShowDialog();
this.tabControl1.SelectedIndex=1;
}
else if(selectnode.Equals("毕业信息登记"))
{
fmXS_JSXY f=new fmXS_JSXY(this);
this.eTreeAflterSelect+=new TreeAfterSelect(f.RefreachUI);
this.tabControl1.Controls.Remove(this.tabPage2);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.SelectedIndex=1;
this.AddTreeJL_JT();
f.TopLevel=false;
this.panelfill.Visible=true;
this.panelfill.Contains(f);
f.Location=new Point(0,0);
f.TopMost=false;
f.Parent=this.panelfill;
f.Show();
}
else if(selectnode.Equals("学籍档案移交"))
{
fmXS_Transfer fmt=new fmXS_Transfer();
fmt.TopLevel=false;
this.panelfill.Contains(fmt);
fmt.Location=new Point(0,0);
fmt.TopLevel=false;
fmt.TopMost=false;
fmt.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmt.Size=this.panelfill.ClientSize;
fmt.Parent=this.panelfill;
fmt.Show();
}
else if(selectnode.Equals("学生基本信息查询"))
{
fmXSXX_Query fmquery=new fmXSXX_Query();
fmquery.TopLevel=false;
this.panelfill.Contains(fmquery);
fmquery.Location=new Point(0,0);
fmquery.TopLevel=false;
fmquery.TopMost=false;
fmquery.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmquery.Size=this.panelfill.ClientSize;
fmquery.Parent=this.panelfill;
fmquery.Show();
}
else if(selectnode.Equals("学籍变更信息查询"))
{
fmXJYD_Query fmxjyd=new fmXJYD_Query();
fmxjyd.TopLevel=false;
this.panelfill.Contains(fmxjyd);
fmxjyd.Location=new Point(0,0);
fmxjyd.TopMost=false;
//fmxjyd.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmxjyd.Size=this.panelfill.ClientSize;
fmxjyd.Parent=this.panelfill;
fmxjyd.Show();
}
else if(selectnode.Equals("奖励与处分"))
{
fmJL_CFXX_Query fmjl=new fmJL_CFXX_Query();
fmjl.TopLevel=false;
this.panelfill.Contains(fmjl);
fmjl.Location=new Point(0,0);
fmjl.TopMost=false;
fmjl.Size=this.panelfill.ClientSize;
fmjl.Parent=this.panelfill;
fmjl.Show();
}
else if(selectnode.Equals("考试成绩和综合素质评价"))
{
this.AddTree();
//this.treeView1.ExpandAll();
fmKSCJ_ZHPG fmkccj=new fmKSCJ_ZHPG(this);
this.eTreeAflterSelect+=new TreeAfterSelect(fmkccj.RefreshUI);
this.tabControl1.Controls.Add(this.tabPage2);
fmkccj.TopLevel=false;
this.panelfill.Contains(fmkccj);
fmkccj.Location=new Point(0,0);
fmkccj.TopMost=false;
fmkccj.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmkccj.Size=this.panelfill.ClientSize;
fmkccj.Parent=this.panelfill;
fmkccj.Dock=DockStyle.Fill;
fmkccj.Show();
this.tabControl1.SelectedIndex=1;
}
else if(selectnode.Equals("用户管理"))
{
fmTeacherData fmtc=new fmTeacherData();
fmtc.TopLevel=false;
this.panelfill.Contains(fmtc);
fmtc.Location=new Point(0,0);
fmtc.TopMost=false;
fmtc.Size=this.panelfill.ClientSize;
fmtc.Parent=this.panelfill;
fmtc.Show();
}
else if(selectnode.Equals("系统维护"))
{
fmTableManage fmtm=new fmTableManage();
fmtm.TopLevel=false;
this.panelfill.Contains(fmtm);
fmtm.Location=new Point(0,0);
fmtm.TopMost=false;
fmtm.Size=this.panelfill.ClientSize;
fmtm.Parent=this.panelfill;
fmtm.Show();
}
}
string [] msg;
//Classes.LocalClass lc=new SamsPoint.Classes.LocalClass();
DataSet dslb=new DataSet();
private void fmSAMS_Default_Load(object sender, System.EventArgs e)
{
ds=xx.QueryXX_JBXX();
dslb=xx.QueryDM_XXLB();
string strmsg="";
int count=0;
if(ds.Tables["XX_JBXX"].Rows.Count!=0)
{
strmsg=ds.Tables["XX_JBXX"].Rows[0]["MSG"].ToString().Trim();
xxdm=ds.Tables["XX_JBXX"].Rows[0]["XXDM"].ToString().Trim();
fsjgstr=ds.Tables["XX_JBXX"].Rows[0]["FSJG"].ToString().Trim();
string xxlb=ds.Tables["XX_JBXX"].Rows[0]["XXLBM"].ToString().Trim();
foreach(DataRow dr in dslb.Tables["dm_xxlb"].Select("XXLBM='"+xxlb+"'"))
{
xdm=dr["XDM"].ToString().Trim();
}
if(!strmsg.Equals(""))
{
msg=strmsg.Split(','); //ID
count=msg.Length;
this.linkLabelmsg.Text="你有"+count+"条新消息,请注意接收!";
}
else
{
this.linkLabelmsg.Text="你没有最新消息!";
}
}
else
{
this.linkLabelmsg.Text="你没有最新消息!";
}
this.LoadData();
this.tvFunction.ExpandAll();
}
private void miXX_JBXX_SZ_Click(object sender, System.EventArgs e)
{
fmxx=new fmXX_JBXX();
fmxx.TopLevel=false;
this.panelfill.Contains(fmxx);
fmxx.Location=new Point(0,0);
fmxx.TopLevel=false;
fmxx.TopMost=false;
fmxx.ControlBox=false;
fmxx.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fmxx.Size=this.panelfill.ClientSize;
fmxx.Parent=this.panelfill;
//fmxx.Dock=System.Windows.Forms.DockStyle.Fill;
fmxx.Show();
}
#region
private void linkLabelmsg_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
{
// dsmsg=xx.QueryData("select * from SYS_MSG","SYS_MSG");
// if(msg.Length>0)
// {
// DataTable dt=new DataTable("SYS_MSG");
// dt.Columns.Add("ID",typeof(int));
// dt.Columns.Add("DT",typeof(char));
// dt.Columns.Add("CONTENT",typeof(string));
// dt.Columns.Add("RD",typeof(char));
// DataRow row=dt.NewRow();
// for(int i=0;i<msg.Length;i++)
// {
// foreach(DataRow dr in dsmsg.Tables["SYS_MSG"].Select("ID="+msg[i]))
// {
// row["ID"]=int.Parse(dr["ID"].ToString());
// row["DT"]=dr["DT"].ToString();
// row["CONTENT"]=dr["CONTENT"].ToString();
// row["RD"]=dr["RD"].ToString();
// }
// }
// dvmsg=new DataView(dt,"","ID",DataViewRowState.CurrentRows);
// dvmsg.AllowNew=false;
// this.dgmsg.DataSource=dvmsg;
//
// DataGridTableStyle ts1 = new DataGridTableStyle();
// ts1.MappingName="SYS_MSG";
// DataGridTextBoxColumn TextCol = new DataGridTextBoxColumn();
// TextCol.MappingName="ID";
// TextCol.HeaderText="消息编号";
// TextCol.NullText="";
// ts1.GridColumnStyles.Add(TextCol);
//
// TextCol=new DataGridTextBoxColumn();
// TextCol.MappingName="DT";
// TextCol.HeaderText="日期";
// TextCol.NullText="";
// ts1.GridColumnStyles.Add(TextCol);
//
// TextCol=new DataGridTextBoxColumn();
// TextCol.MappingName="CONTENT";
// TextCol.HeaderText="消息内容";
// TextCol.NullText="";
// ts1.GridColumnStyles.Add(TextCol);
//
// TextCol=new DataGridTextBoxColumn();
// TextCol.MappingName="RD";
// TextCol.HeaderText="是否已读";
// TextCol.NullText="";
// ts1.GridColumnStyles.Add(TextCol);
//
// this.dgmsg.TableStyles.Add(ts1);
// //string str=msg[i];
// }
}
#endregion
DataSet dsnj=new DataSet();
DataSet dsbj=new DataSet();
DataSet dsxs=new DataSet();
DataSet dsxx=new DataSet();
//DataSet ds=new DataSet();
DataSet dsxbm=new DataSet();
string strSql="SELECT XS_JBXX.*, XX_NJ.NJMC as xnjmc, XX_BJ.BJMC as xbjmc, DM_XSLB.XSLBMC , DM_XBM.XBMC , DM_GATQ.MC as xsgatqmc, DM_JKZK.MC as xjkzkmc, DM_ZZMM.ZZMMMC,DM_HKXZ.MC as DM_HKXZMC FROM ((((((((XS_JBXX LEFT JOIN DM_XX ON XS_JBXX.XXM = DM_XX.XXM) LEFT JOIN DM_GATQ ON XS_JBXX.GATQM = DM_GATQ.DM) LEFT JOIN DM_ZZMM ON XS_JBXX.ZZMMM = DM_ZZMM.ZZMMM) LEFT JOIN DM_XSLB ON XS_JBXX.XSLBM = DM_XSLB.XSLBM) LEFT JOIN DM_JKZK ON XS_JBXX.HKSZD = DM_JKZK.DM) LEFT JOIN DM_HKXZ ON XS_JBXX.HKXZM = DM_HKXZ.DM) LEFT JOIN XX_NJ ON XS_JBXX.NJ = XX_NJ.NJ) LEFT JOIN XX_BJ ON XS_JBXX.BH = XX_BJ.BH) LEFT JOIN DM_XBM ON XS_JBXX.XBM = DM_XBM.XBM";
public void LoadData()
{
dsnj.Clear();
dsbj.Clear();
dsxs.Clear();
dsnj=xx.QueryXX_NJ(xdm);//年级表
dsbj=xx.QueryData("select * from xx_bj","tvTable");//班级表
dsxs=xx.QueryData(strSql,"xs_jbxx");//学生基本信息表
dsxx=xx.QueryData("select xxdm from xx_jbxx","xx_jbxx");
}
public void AddTree()
{
LoadData();
this.treeView1.Nodes.Clear();
TreeNode topNode=new TreeNode("所有班级");
topNode.Tag="all";
this.treeView1.Nodes.Add(topNode);
topNode.ImageIndex=0;
topNode.SelectedImageIndex=1;
foreach(DataRow Row in dsnj.Tables["XX_NJ"].Rows)
{
TreeNode rNode=new TreeNode();
rNode.Text=Row["NJMC"].ToString().Trim();
rNode.Tag=Row["NJ"].ToString().Trim();
rNode.ImageIndex=0;
rNode.SelectedImageIndex=1;
this.treeView1.Nodes[0].Nodes.Add(rNode);
AddChildeNode(rNode,Row["NJ"].ToString());
}
}
private void AddChildeNode(TreeNode pNode,string nj)
{
foreach(DataRow theRow in dsbj.Tables["tvTable"].Select("nj='"+nj+"'"))
{
TreeNode cNode=new TreeNode();
cNode.Text=theRow["BJMC"].ToString().Trim();
cNode.Tag=theRow["BH"].ToString().Trim();
cNode.ImageIndex=2;
cNode.SelectedImageIndex=3;
pNode.Nodes.Add(cNode);
}
this.treeView1.ExpandAll();
}
public void AddTreeJL_JT()
{
LoadData();
this.treeView1.Nodes.Clear();
foreach(DataRow row in dsnj.Tables["XX_NJ"].Rows)
{
TreeNode rNode=new TreeNode();
rNode.Text=row["NJMC"].ToString().Trim();
rNode.Tag=row["NJ"].ToString().Trim();
rNode.ImageIndex=0;
rNode.SelectedImageIndex=1;
this.treeView1.Nodes.Add(rNode);
AddChildeNodeJL_JT(rNode,row["NJ"].ToString().Trim());
}
}
private void AddChildeNodeJL_JT(TreeNode pNode,string nj)
{
foreach(DataRow theRow in dsbj.Tables["tvTable"].Select("nj='"+nj+"'"))
{
TreeNode cnode=new TreeNode();
cnode.Text=theRow["BJMC"].ToString().Trim();
cnode.Tag=theRow["BH"].ToString().Trim();
cnode.ImageIndex=2;
cnode.SelectedImageIndex=3;
pNode.Nodes.Add(cnode);
AddStudentNodeJL_JT(cnode,theRow["BH"].ToString().Trim());
//this.treeView1.ExpandAll();
}
}
private void AddStudentNodeJL_JT(TreeNode node,string bh)
{
foreach(DataRow cRow in dsxs.Tables["XS_JBXX"].Select("BH='"+bh+"'"))
{
TreeNode snode=new TreeNode();
snode.Text=cRow["XM"].ToString().Trim();
snode.Tag=cRow["sfzh"].ToString().Trim();
snode.ImageIndex=4;
snode.SelectedImageIndex=5;
node.Nodes.Add(snode);
}
}
private void treeView1_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
eTreeAflterSelect(e.Node);
}
public void LoadXS()
{
this.AddTree();
this.treeView1.ExpandAll();
fms=new fmStudentData(this);
this.eTreeAflterSelect+=new TreeAfterSelect(fms.RefreshUI);
this.tabControl1.Controls.Add(this.tabPage2);
fms.TopLevel=false;
this.panelfill.Contains(fms);
fms.Location=new Point(0,0);
fms.TopLevel=false;
fms.TopMost=false;
fms.StartPosition=System.Windows.Forms.FormStartPosition.Manual;
fms.Size=this.panelfill.ClientSize;
fms.Parent=this.panelfill;
fms.Dock=DockStyle.Fill;
fms.Show();
this.tabControl1.SelectedIndex=1;
}
public string tvState()
{
if(this.treeView1.SelectedNode==null || this.treeView1.SelectedNode==this.treeView1.TopNode)
{
return "topnode";
}
else if(LevelOfNode(this.treeView1.SelectedNode)==1)
{
return "1";
}
else if(LevelOfNode(this.treeView1.SelectedNode)==2)
{
return "2";
}
else
{
return "";
}
}
public int LevelOfNode(TreeNode tn)
{
int x=0;
if(tn.Parent!=null)
return LevelOfNode(tn.Parent)+1;
else
return x;
}
public void loadBJ(DataSet ds2,string str)
{
//AddTree();
foreach(DataRow dr in ds2.Tables["bj"].Select("年级代码='"+str+"'"))//遍历每个班级
{
for(int i=0;i<this.treeView1.Nodes[0].Nodes.Count;i++)
{
if(this.treeView1.Nodes[0].Nodes[i].Text.ToString().Trim()==(str+"年级"))
{
TreeNode cNode=new TreeNode();
cNode.Text=dr[0].ToString().Trim()+"班";
cNode.Tag=dr[0].ToString().Trim();
cNode.ImageIndex=2;
cNode.SelectedImageIndex=3;
this.treeView1.Nodes[0].Nodes[i].Nodes.Add(cNode);
string sql="insert into xx_bj(nj,bh,bjmc,xxdm) values('"+dr[1].ToString().Trim()+"','"+dr[0].ToString().Trim()+"','"+dr[0].ToString().Trim()+"班"+"','"+xxdm.Trim()+"')";
xx.ExecCommand(sql);
dsbj.Tables["tvTable"].AcceptChanges();
}
}
}
}
public void SelectStudent()
{
fmXS_JSXY f=new fmXS_JSXY(this);
this.eTreeAflterSelect+=new TreeAfterSelect(f.RefreachUI);
this.tabControl1.Controls.Remove(this.tabPage2);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.SelectedIndex=1;
this.AddTreeJL_JT();
f.TopLevel=false;
this.panelfill.Visible=true;
this.panelfill.Contains(f);
f.Location=new Point(0,0);
f.TopMost=false;
f.Parent=this.panelfill;
f.Show();
}
public void SelectHuanBanXS()
{
fmHuanBan fmhb=new fmHuanBan(this);
fmhb.TopLevel=false;
this.eTreeAflterSelect+=new TreeAfterSelect(fmhb.Bindate);
this.panelfill.Contains(fmhb);
fmhb.TopLevel=false;
fmhb.TopMost=false;
fmhb.Parent=this.panelfill;
fmhb.Dock=DockStyle.Fill;
fmhb.Show();
}
public void SelectXSYD()
{
fmXS_XJYD fm=new fmXS_XJYD(this);
fm.TopLevel=false;
this.eTreeAflterSelect+=new TreeAfterSelect(fm.RefreshUI);
this.panelfill.Contains(fm);
fm.TopLevel=false;
fm.TopMost=false;
fm.Parent=this.panelfill;
fm.Dock=DockStyle.Fill;
fm.Show();
}
private void button1_Click(object sender, System.EventArgs e)
{
fmDM_KC fm=new fmDM_KC();
fm.Show();
}
private void linkLabel1_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
{
this.tabControl1.Controls.Remove(this.tabPage2);
}
}
}