?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.BLL;
using Youzi.Model;


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

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

        private void ShuaXin()
        {
            OfficeBLL bll = new OfficeBLL();
            DataSet ds = bll.SelectAll();
            dataGridView1.DataSource = ds.Tables[0];
            dataGridView1.ReadOnly = true;
            butDelete.Enabled = false;
            butUpdate.Enabled = false;
            butSave.Enabled = false;
            
        }



        private void ClearField()
        {
            txtName.Text = "";
            txtDirector.Text = "";
            txtCureCost.Text = "";
            txtOperateDate.Text = "";
            txtOperator.Text = "";
        }
        private void butAdd_Click(object sender, EventArgs e)
        {
            
            ClearField();
            butDelete.Enabled = false;
            butUpdate.Enabled = false;
            butSave.Enabled = true;
            butCacel.Enabled = true;
            txtName.Enabled = true;
            txtDirector.Enabled = true;
            txtCureCost.Enabled = true;
            txtOperateDate.Enabled = false;
            txtOperator.Enabled = false;
            txtOperateDate.Text = DateTime.Now.ToString();
            txtOperator.Text = Users.userName;
            butAdd.Enabled = !butAdd.Enabled;
        }

        private void butDelete_Click(object sender, EventArgs e)
        {
            try
            {
                DialogResult dr = MessageBox.Show("確認(rèn)刪除嗎", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dr == DialogResult.No)
                {
                    
                    return;
                }
                int index = dataGridView1.CurrentRow.Index;
                int id = int.Parse(dataGridView1[0, index].Value.ToString());
                OfficeBLL bll = new OfficeBLL();
                int ii = bll.Delete(id);
                if (ii > 0)
                {
                    ShuaXin();
                    MessageBox.Show("刪除成功");
                    ClearField();
                }
               
                
                txtName.Enabled = false;
                txtDirector.Enabled = false;
                txtCureCost.Enabled = false;
                txtOperateDate.Enabled = false;
                txtOperator.Enabled = false;
            }
            catch (SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }
           
        }

        private void butUpdate_Click(object sender, EventArgs e)
        {

            try
            {
                OfficeBLL bll = new OfficeBLL();
                OfficeInfo entity = new OfficeInfo();
                int index = dataGridView1.CurrentRow.Index;    //index 獲得當(dāng)前所選中行的下標(biāo)(下標(biāo)從0開始)
                entity.OfficeID = int.Parse(dataGridView1[0, index].Value.ToString());
                entity.OfficeName = txtName.Text;
                entity.Director = txtDirector.Text;
                entity.CureCost = txtCureCost.Text;
                entity.OperateDate = txtOperateDate.Text;
                entity.Operator = txtOperator.Text;
                int ii = bll.Update(entity);
                if (ii > 0)
                {
                    
                    MessageBox.Show("更新成功");
                    ClearField();
                }
                

            }
            catch (SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }
            
        }

        private void butSave_Click(object sender, EventArgs e)
        {
            try
            {
                OfficeBLL bll = new OfficeBLL();
                OfficeInfo entity = new OfficeInfo();
                entity.OfficeName = txtName.Text;
                entity.Director = txtDirector.Text;
                entity.CureCost = txtCureCost.Text;
                entity.OperateDate = txtOperateDate.Text;
                entity.Operator = txtOperator.Text;
                
                if (txtName.Text == string.Empty)
                {
                    MessageBox.Show("科室名稱不能為空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                if (txtDirector.Text == string.Empty)
                {
                    MessageBox.Show("主任不能為空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                if (txtCureCost.Text == string.Empty)
                {
                    MessageBox.Show("診療費(fèi)不能為空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                int ii = bll.Insert(entity);

                if (ii >=0)
                {
                    ShuaXin();
                    MessageBox.Show("保存成功");
                    ClearField();
                    butAdd.Enabled = true;
                    butCacel.Enabled = true;
                }

               
            }
            catch (SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }
            
        }

        private void butCacel_Click(object sender, EventArgs e)
        {
            ClearField();
            butDelete.Enabled = false;
            butSave.Enabled = false;
            butAdd.Enabled = true;
            butUpdate.Enabled = false;
            txtName.Enabled = false;
            txtDirector.Enabled = false;
            txtCureCost.Enabled = false;
        }

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

        private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            int index = dataGridView1.CurrentRow.Index;
            txtName.Text = dataGridView1[1, index].Value.ToString();
            txtDirector.Text = dataGridView1[2, index].Value.ToString();
            txtCureCost.Text = dataGridView1[3, index].Value.ToString();
            txtOperateDate.Text = dataGridView1[4, index].Value.ToString();
            txtOperator.Text = dataGridView1[5, index].Value.ToString();
            txtName.Enabled = true;
            txtDirector.Enabled = true;
            txtCureCost.Enabled = true;
            txtOperateDate.Enabled = false;
            txtOperator.Enabled = false;
            butDelete.Enabled = true;
            butUpdate.Enabled = true;
            butSave.Enabled = false;
        }

        private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            int index = dataGridView1.CurrentRow.Index;
            txtName.Text = dataGridView1[1, index].Value.ToString();
            txtDirector .Text= dataGridView1[2, index].Value.ToString();
            txtCureCost .Text= dataGridView1[3, index].Value.ToString();
            txtOperateDate .Text= dataGridView1[4, index].Value.ToString();
            txtOperator .Text= dataGridView1[5, index].Value.ToString();
            txtName.Enabled = true;
            txtDirector.Enabled = true;
            txtCureCost.Enabled = true;
            txtOperateDate.Enabled = false;
            txtOperator.Enabled = false;
            butDelete.Enabled = true;
            butUpdate.Enabled = true;
            butSave.Enabled = false;
        }
    }
}