userframe.cs

不错的一个做的医院管理系统源码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;


using Youzi.Model;
using Youzi.BLL;

namespace Youzi.View
{
    public partial class UserFrame : Form
    {
        public UserFrame()
        {
            InitializeComponent();
        }


        
        private void UserFrame_Load(object sender, EventArgs e)
        {
            ShuaXin();
            

        }

        private void ShuaXin()
        {
            try
            {
                UsersBLL bll = new UsersBLL();
                DataSet ds = bll.SelectAll();
                dataGridView1.DataSource = ds.Tables[0];
                dataGridView1.ReadOnly = true;    //只读

                comboBox1.Items.Clear();
                comboBox1.Items.Add("挂号员");
                comboBox1.Items.Add("管理员");
                comboBox1.SelectedIndex = 0;
                butUpdate.Enabled = false;
                butDelete.Enabled = false;
                butSave.Enabled = false;

                OperateDate.Text = DateTime.Now.ToString();
                Operator.Text = Users.userName;
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
                
            }
            
        }

        private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            int index = dataGridView1.CurrentRow.Index;
            UserName.Text = dataGridView1[1, index].Value.ToString();
            UserPass.Text = dataGridView1[2, index].Value.ToString();
            comboBox1.SelectedItem = dataGridView1[3, index].Value.ToString();
            OperateDate.Text = dataGridView1[4, index].Value.ToString();
            Operator.Text = dataGridView1[5, index].Value.ToString();

            butAdd.Enabled = true;
            butDelete.Enabled = true;
            butUpdate.Enabled = true;
            butSave.Enabled = false;
            butCacel.Enabled = true;
            UserName.Enabled = true;
            UserPass.Enabled = true;

        }




        private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            dataGridView1_RowHeaderMouseClick(null, null);
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void butAdd_Click(object sender, EventArgs e)
        {
            UserName.Enabled = true;
            UserPass.Enabled = true;
            butAdd.Enabled = false;
            butDelete.Enabled = false;
            butSave.Enabled = true;
            butCacel.Enabled = true;
            OperateDate.Text = DateTime.Now.ToString();
            Operator.Text = Users.userName;
            UserName.Text = "";
            UserPass.Text = "";
           
            
        }

        private void butClose_Click(object sender, EventArgs e)
        {
            this.Hide();
        }

        private void butCacel_Click(object sender, EventArgs e)
        {
            ClearField();

            butAdd.Enabled = true;
            butUpdate.Enabled = false;
            butDelete.Enabled = false;
            butSave.Enabled = false;
            UserName.Enabled = false;
            UserPass.Enabled = false;
            OperateDate.Enabled = false;
            Operator.Enabled = false;

        }

        private void ClearField()
        {

            UserName.Text = "";
            UserPass.Text = "";
            OperateDate.Text = "";
            Operator.Text = "";
        }



        private void butDelete_Click(object sender, EventArgs e)
        {
            try
            {
                int index = dataGridView1.CurrentRow.Index;
                int id = int.Parse(dataGridView1[0, index].Value.ToString());   //拿到ID列
                UsersBLL bll = new UsersBLL();
                DialogResult result = MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.No)
                {
                    
                    return;
                }

                int ii = bll.Delete(id);
                if (ii > 0)
                {
                    ShuaXin();
                    MessageBox.Show("删除成功");
                    ClearField();
                    OperateDate.Text = "";
                    Operator.Text = "";
                }
                
                
                UserName.Enabled = false;
                UserPass.Enabled = false;
                OperateDate.Enabled = false;
                Operator.Enabled = false;
            }
            catch (SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }
           
            
        }

        private void butSave_Click(object sender, EventArgs e)
        {
            try
            {
                UsersInfo entity = new UsersInfo();
                entity.UserName = UserName.Text;
                entity.UserPass = UserPass.Text;
                entity.UserPurview = comboBox1.SelectedItem.ToString();
                DateTime d = DateTime.Now;
                entity.OperateDate = d.ToString();

                if (UserName.Text == string.Empty)
                {
                    MessageBox.Show("用户名不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }

                if (UserPass.Text == string.Empty)
                {
                    MessageBox.Show("密码不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                UsersBLL bll = new UsersBLL();
                int ii = bll.Insert(entity);

                if (ii > 0)
                {
                    ShuaXin();
                    MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    UserName.Enabled = false;
                    UserPass.Enabled = false;
                    OperateDate.Enabled = false;
                    Operator.Enabled = false;

                }
                ClearField();
                butAdd.Enabled = true;
                butSave.Enabled = false;
            }
            catch (SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }
           
        }

        private void butUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                UsersBLL bll = new UsersBLL();
                UsersInfo entity = new UsersInfo();
                int index = dataGridView1.CurrentRow.Index;      //index 获得当前所选中行的下标(下标从0开始)
                entity.UserID = int.Parse(dataGridView1[0, index].Value.ToString());
                entity.UserName = UserName.Text;
                entity.UserPass = UserPass.Text;
                entity.UserPurview = comboBox1.SelectedItem.ToString();
                entity.OperateDate = OperateDate.Text;
                entity.Operator = Operator.Text;
                int ii = bll.Update(entity);
                if (ii > 0)
                {
                    ShuaXin();
                    MessageBox.Show("修改成功");
                    ClearField();
                }
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message); 
                
            }
           
        }

    }
}