frmremind.cs

酒店管理系统,您酒店物业管理的好帮手

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

namespace Hotel.UI
{
    public partial class frmRemind : Form
    {
        RemindAccess objRemindAccess = null;

        public frmRemind()
        {
            InitializeComponent();
        }

        private void frmRemind_Load(object sender, EventArgs e)
        {
            show();
                
        }
        public void show()
        {
            
            cboState.SelectedIndex = 0;
            //显示默认的时间
            txtTime.Text = DateTime.Now.ToString();
            objRemindAccess = new RemindAccess();
            DataSet ds = new DataSet();
            ds=objRemindAccess.GetAllRemind();
            //建表头
            ColumnHeader ch = null;
            lsvShow.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lsvShow.Columns.Add(ch);
                ch.Width = 60;
                if (i == 1)
                    ch.Width = 130;
            }

            lsvShow.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());
                }
                lsvShow.Items.Add(lsvItem);
            }  
        }
        private void dtpRe_ValueChanged(object sender, EventArgs e)
        {
            txtTime.Text = dtpRe.Value.ToString();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        //添加提醒
        private void btnAdd_Click(object sender, EventArgs e)
        {
            
            string dt=txtTime.Text.Trim();
            string st=cboState.Text.Trim();
            string re=txtRemind.Text.Trim();
            objRemindAccess = new RemindAccess();
            int k=objRemindAccess.AddRemind(dt, st, re);
            if (k == 0)
            {
                MessageBox.Show("添加失败！", "提示");
            }
            else
            {
                 MessageBox.Show("添加成功！", "提示");
                 show();
            }
        }
        //删除 
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (lsvShow.SelectedItems.Count == 0)
            {
                MessageBox.Show("未选中!","提示");
                return;
            }
            int k = 0;
            objRemindAccess = new RemindAccess();
            k=objRemindAccess.DeleteRemind(int.Parse(lsvShow.SelectedItems[0].SubItems[0].Text.ToString()));
            if (k == 0)
            {
                MessageBox.Show("删除失败!", "提示");
            }
            else
            {
                MessageBox.Show("删除成功!","提示");
                show();
            }
        }

        private void btnModifi_Click(object sender, EventArgs e)
        {
            if (lsvShow.SelectedItems.Count == 0)
            {
                MessageBox.Show("未选中!", "提示");
                return;
            }
            int k=0;
            objRemindAccess = new RemindAccess();
            int num=0;
            try
            {
                num = int.Parse(lsvShow.SelectedItems[0].SubItems[0].Text.ToString());
            }
            catch
            { 
            }
            k = objRemindAccess.ModifiRemind(num,txtTime.Text.Trim(),cboState.Text.Trim(),txtRemind.Text.Trim());
            if (k == 0)
            {
                MessageBox.Show("修改失败!", "提示");
            }
            else
            {
                MessageBox.Show("修改成功!", "提示");
                show();
            }
        }

        private void lsvShow_SelectedIndexChanged(object sender, EventArgs e)
        {
            //当选中时显示相应值
            try
            {
                txtTime.Text = lsvShow.SelectedItems[0].SubItems[1].Text.ToString();
                int i = 0;
                if (lsvShow.SelectedItems[0].SubItems[2].Text.ToString().Equals("启用"))
                    i = 0;
                else
                    i = 1;
                cboState.SelectedIndex = i;
                txtRemind.Text = lsvShow.SelectedItems[0].SubItems[3].Text.ToString();
            }
            catch
            {
 
            }
        }

    }
}