form1.cs

C#编写的

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Win32;
using System.Data.OleDb;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;

namespace 成绩管理系统_new
{
    public partial class From1 : Form
    {
        public From1()
        {
            InitializeComponent();
        }
        ////////////////////////////
        TextBox[] textBoxLeft;                  //左侧的所有TextBox
        Label[] labelLeftAll;                   //左侧的所有label
        ////////////////////////////

        string selectCmd;
        string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=成绩管理系统.mdb";
        bool isChange = false;
        bool isNew = false;
        DataSet myDataSet = new DataSet();
        DataTable myDataTable;
        int i = 0;//show which row
        public string findStr = "";
        string filePath = "";
        //int left = 0;
        //int top = 0;//页边矩
        RegistryKey metrics = Registry.CurrentUser.OpenSubKey(@"Software\成绩管理系统", true);
        RegistryKey softwareM = Registry.CurrentUser.OpenSubKey(@"Software", true);
        Bitmap memoryImage;

        private void changeForm()
        {
            this.FormBorderStyle = FormBorderStyle.None;
            cazao.Visible = dayin.Visible = dayinyulan.Visible = sanyiye.Visible = xiayiye.Visible = baocun.Visible = sancu.Visible = xinjianye.Visible = ziti.Visible = false;
            this.BackColor = Color.White;
            textBox2.Visible =   label15.Visible = label16.Visible = false;
            zoubianju.Visible = sanbianju.Visible = false;

            
        }

        private void returnForm()
        {
            this.FormBorderStyle = FormBorderStyle.Sizable;
            cazao.Visible = dayin.Visible = dayinyulan.Visible = sanyiye.Visible = xiayiye.Visible = baocun.Visible = sancu.Visible = xinjianye.Visible = ziti.Visible = true;
            this.BackColor = SystemColors.Control;
            textBox2.Visible =  label15.Visible = label16.Visible = true;
            zoubianju.Visible = sanbianju.Visible = true;
           
         }

        private void CaptureScreen()
        {
            changeForm();

            //MessageBox.Show("点击确定生产图形");
            this.Refresh();
      
            Graphics myGraphics = this.CreateGraphics();
            Size s = this.Size;
            memoryImage = new Bitmap(s.Width, s.Height, myGraphics);
            Graphics memoryGraphics = Graphics.FromImage(memoryImage);
            memoryGraphics.CopyFromScreen(this.Location.X, this.Location.Y, 0, 0, s);
                                                
            returnForm();
           
        }


        public void find()
        {
            isNew = false;
            isChange = false;
            i = 0;
            myDataSet.Clear();
            try
            {
                selectCmd = "select * from 成绩管理系统 where 学号 like '%" + findStr + "%'";
                //OleDbCommand cmd;
                OleDbConnection conn;
                OleDbDataAdapter myAdapter;

                conn = new OleDbConnection(connStr);
                myAdapter = new OleDbDataAdapter(selectCmd, conn);
                myAdapter.Fill(myDataSet, "成绩管理系统");
                myDataTable = myDataSet.Tables["成绩管理系统"];
                this.label16.Text = this.myDataTable.Rows.Count.ToString();
                try
                {
                    this.danhao.Text = myDataTable.Rows[i][0].ToString();
                    this.sencansulian.Text = myDataTable.Rows[i][1].ToString();
                    this.wancensijian.Text = myDataTable.Rows[i][2].ToString();
                    this.sougongjia.Text = myDataTable.Rows[i][3].ToString();
                    this.dianhanjia1.Text = myDataTable.Rows[i][4].ToString();
                    this.dianhanjia2.Text = myDataTable.Rows[i][5].ToString();
                    this.xialiaojia.Text = myDataTable.Rows[i][6].ToString();
                    this.duandajia.Text = myDataTable.Rows[i][7].ToString();
                    this.cicun.Text = myDataTable.Rows[i][8].ToString();
                    this.pictureBox1.Image = null;
                    if (myDataTable.Rows[i][9].ToString() == "")
                    {
                        this.pictureBox1.Image = null;
                    }
                    else
                    {
                        this.pictureBox1.Image = new Bitmap(myDataTable.Rows[i][9].ToString());
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }

                //				OleDbDataReader myReader;
                //				conn = new OleDbConnection(connStr);
                //				conn.Open();
                //				cmd = new OleDbCommand(selectCmd,conn);
                //				myReader = cmd.ExecuteReader();
                //				if(myReader.Read())
                //				{
                //					this.textBox1.Text = myReader["学号"].ToString();
                //					this.textBox2.Text = myReader["姓名"].ToString();
                //					this.textBox3.Text = myReader["年级"].ToString();
                //					this.textBox4.Text = myReader["班级"].ToString();
                //					this.textBox5.Text = myReader["性别"].ToString();
                //					this.textBox6.Text = myReader["出身年月"].ToString();
                //					this.textBox7.Text = myReader["籍贯"].ToString();
                //					this.textBox8.Text = myReader["职位"].ToString();
                //					this.richTextBox1.Text = myReader["成绩"].ToString();
                //				}
                //				else
                //				{
                //					MessageBox.Show("找不到数据");
                //				}
                //				myReader.Close();
                //				conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }


        private void cazao_Click(object sender, EventArgs e)
        {
            isChange = isNew = false;
            Form form2 = new form_Find(this);
            form2.Show();
        }

        private void sanyiye_Click(object sender, EventArgs e)
        {
            if (isChange)
            {
                if (MessageBox.Show("资料已被修改是否保存?", "是否保存", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    try
                    {
                        selectCmd = " insert into 成绩管理系统 (学号,姓名,年级,班级,性别,出身年月,籍贯,职位,成绩,图片路径) values ('" + this.danhao.Text + "','" + this.sencansulian.Text + "','" + this.wancensijian.Text + "','" + this.sougongjia.Text + "','" + this.dianhanjia1.Text + "','" + this.dianhanjia2.Text + "','" + this.xialiaojia.Text + "','" + this.duandajia.Text + "','" + this.cicun.Text + "','" + filePath + "')";
                        OleDbConnection conn = new OleDbConnection(connStr);
                        conn.Open();
                        OleDbCommand cmd = new OleDbCommand(selectCmd, conn);
                        cmd.ExecuteNonQuery();
                        conn.Close();
                        MessageBox.Show("保存成功");
                        this.isChange = false;
                        this.isNew = false;
                    }
                    catch
                    {
                        try
                        {
                            int no = 0;
                            selectCmd = "update 成绩管理系统 set 姓名 = '" + this.sencansulian.Text + "',年级 = '" + this.wancensijian.Text + "',班级 = '" + this.sougongjia.Text + "',性别 = '" + this.dianhanjia1.Text + "',出身年月 = '" + this.dianhanjia2.Text + "',籍贯 = '" + this.xialiaojia.Text + "',职位 = '" + this.duandajia.Text + "',成绩 = '" + this.cicun.Text + "',图片路径 = '" + this.filePath + "' where 学号 = '" + this.danhao.Text + "'";
                            OleDbConnection conn = new OleDbConnection(connStr);
                            conn.Open();
                            OleDbCommand cmd = new OleDbCommand(selectCmd, conn);
                            no = cmd.ExecuteNonQuery();
                            conn.Close();
                            if (no == 1)
                                MessageBox.Show("修改成功");
                            else
                                MessageBox.Show("当前页不存在");
                            isNew = false;
                            isChange = false;
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }
                this.danhao.Text = wancensijian.Text = this.sencansulian.Text = this.sougongjia.Text = dianhanjia1.Text = dianhanjia2.Text = xialiaojia.Text = duandajia.Text = cicun.Text = "";
            }
            else
            {
                this.danhao.Text = wancensijian.Text = this.sencansulian.Text = this.sougongjia.Text = dianhanjia1.Text = dianhanjia2.Text = xialiaojia.Text = duandajia.Text = cicun.Text = "";
            }



            isChange = isNew = false;
            if (i != 0)
                i--;
            try
            {
                this.danhao.Text = myDataTable.Rows[i][0].ToString();
                this.sencansulian.Text = myDataTable.Rows[i][1].ToString();
                this.wancensijian.Text = myDataTable.Rows[i][2].ToString();
                this.sougongjia.Text = myDataTable.Rows[i][3].ToString();
                this.dianhanjia1.Text = myDataTable.Rows[i][4].ToString();
                this.dianhanjia2.Text = myDataTable.Rows[i][5].ToString();
                this.xialiaojia.Text = myDataTable.Rows[i][6].ToString();
                this.duandajia.Text = myDataTable.Rows[i][7].ToString();
                this.cicun.Text = myDataTable.Rows[i][8].ToString();
                this.pictureBox1.Image = null;
                if (myDataTable.Rows[i][9].ToString() == "")
                {
                    this.pictureBox1.Image = null;
                }
                else
                {
                    this.pictureBox1.Image = new Bitmap(myDataTable.Rows[i][9].ToString());
                }

                findWitchPage();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            
            

            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //			try
            //			{
            if (isChange)
            {
                if (MessageBox.Show("资料已被修改是否保存?", "是否保存", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    try
                    {
                        selectCmd = " insert into 成绩管理系统 (学号,姓名,年级,班级,性别,出身年月,籍贯,职位,成绩,图片路径) values ('" + this.danhao.Text + "','" + this.sencansulian.Text + "','" + this.wancensijian.Text + "','" + this.sougongjia.Text + "','" + this.dianhanjia1.Text + "','" + this.dianhanjia2.Text + "','" + this.xialiaojia.Text + "','" + this.duandajia.Text + "','" + this.cicun.Text + "','" + filePath + "')";
                        OleDbConnection conn = new OleDbConnection(connStr);
                        conn.Open();
                        OleDbCommand cmd = new OleDbCommand(selectCmd, conn);
                        cmd.ExecuteNonQuery();
                        conn.Close();
                        MessageBox.Show("保存成功");
                        this.isChange = false;
                        this.isNew = false;
                    }
                    catch
                    {
                        try
                        {
                            int no = 0;
                            selectCmd = "update 成绩管理系统 set 姓名 = '" + this.sencansulian.Text + "',年级 = '" + this.wancensijian.Text + "',班级 = '" + this.sougongjia.Text + "',性别 = '" + this.dianhanjia1.Text + "',出身年月 = '" + this.dianhanjia2.Text + "',籍贯 = '" + this.xialiaojia.Text + "',职位 = '" + this.duandajia.Text + "',成绩 = '" + this.cicun.Text + "',图片路径 = '" + this.filePath + "' where 学号 = '" + this.danhao.Text + "'";
                            OleDbConnection conn = new OleDbConnection(connStr);
                            conn.Open();
                            OleDbCommand cmd = new OleDbCommand(selectCmd, conn);
                            no = cmd.ExecuteNonQuery();
                            conn.Close();
                            if (no == 1)
                                MessageBox.Show("修改成功");
                            else
                                MessageBox.Show("当前页不存在");
                            isNew = false;
                            isChange = false;
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }
                this.danhao.Text = wancensijian.Text = this.sencansulian.Text = this.sougongjia.Text = dianhanjia1.Text = dianhanjia2.Text = xialiaojia.Text = duandajia.Text = cicun.Text = "";
            }
            else
            {
                this.danhao.Text = wancensijian.Text = this.sencansulian.Text = this.sougongjia.Text = dianhanjia1.Text = dianhanjia2.Text = xialiaojia.Text = duandajia.Text = cicun.Text = "";
            }


            isChange = isNew = false;
            try
            {
            if ((i + 1) < myDataTable.Rows.Count)
                i++;
          
                this.danhao.Text = myDataTable.Rows[i][0].ToString();
                this.sencansulian.Text = myDataTable.Rows[i][1].ToString();
                this.wancensijian.Text = myDataTable.Rows[i][2].ToString();
                this.sougongjia.Text = myDataTable.Rows[i][3].ToString();
                this.dianhanjia1.Text = myDataTable.Rows[i][4].ToString();
                this.dianhanjia2.Text = myDataTable.Rows[i][5].ToString();
                this.xialiaojia.Text = myDataTable.Rows[i][6].ToString();
                this.duandajia.Text = myDataTable.Rows[i][7].ToString();
                this.cicun.Text = myDataTable.Rows[i][8].ToString();
                this.pictureBox1.Image = null;
                if (myDataTable.Rows[i][9].ToString() == "")
                {
                    this.pictureBox1.Image = null;
                }
                else
                {
                    this.pictureBox1.Image = new Bitmap(myDataTable.Rows[i][9].ToString());
                }

                findWitchPage();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            //			}
            //			catch
            //			{
            //				MessageBox.Show("没有相关数据");
            //			}