crbrowseform.cs

来自「一个超市管理系统,没有错误,非常好,里面什么都有!很使用,很有用」· CS 代码 · 共 133 行

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using DaFanRongMIS.Model.Common;
using DaFanRongMIS.Model.CashRegister;

namespace DaFanRongMIS.ViewController.CashRegister
{
    public partial class CRBrowseForm : Form
    {
        public CRBrowseForm()
        {
            InitializeComponent();
        }
        CashRegisterDAO crDAO;
        CashRegisterEntity crEntity;


        private void FillLV()
        {
            this.lvCR.Items.Clear();
            crDAO = new CashRegisterDAOImpl();
            SqlDataReader dr=crDAO.SelectAll();
            while (dr.Read())
            {
                ListViewItem item = new ListViewItem();
                item.Text = dr.GetString(0);
                item.SubItems.Add(dr.GetString(1));
                item.SubItems.Add(dr.GetString(2));
                item.SubItems.Add(dr.GetString(3));
                item.SubItems.Add(dr.GetString(4));
                item.SubItems.Add(dr.GetString(5));
                item.SubItems.Add(dr.GetString(6));
                item.SubItems.Add(dr.GetString(7));
                this.lvCR.Items.Add(item);

            }
            dr.Close();
            ConnectionDataBase.getConClose();

        }

        private void btnCheck_Click(object sender, EventArgs e)
        {
            lvCR.Items.Clear();
            crDAO = new CashRegisterDAOImpl();
            crEntity = new CashRegisterEntity();
            crEntity.Name=this.txtCRName.Text;
            crEntity.Hostname = this.txtHostName.Text;
            SqlDataReader dr = crDAO.CRCheck(crEntity);
            while (dr.Read())
            {
                ListViewItem item = new ListViewItem();
                item.Text = dr.GetString(0);
                item.SubItems.Add(dr.GetString(1));
                item.SubItems.Add(dr.GetString(2));
                item.SubItems.Add(dr.GetString(3));
                item.SubItems.Add(dr.GetString(4));
                item.SubItems.Add(dr.GetString(5));
                item.SubItems.Add(dr.GetString(6));
                item.SubItems.Add(dr.GetString(7));
                lvCR.Items.Add(item);
            }
            dr.Close();
            ConnectionDataBase.getConClose();

        }

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

        private void tbAdd_Click(object sender, EventArgs e)
        {
            new CRManageForm("Add", lvCR).ShowDialog();
        }

        private void tbUpdate_Click(object sender, EventArgs e)
        {
            if (this.lvCR.SelectedItems.Count > 0)
            {
                new CRManageForm("Update", lvCR).ShowDialog();
            }
            else
            {
                MessageBox.Show("请选择要修改的记录！");
            }
        }

        private void CRBrowseForm_Load(object sender, EventArgs e)
        {
            this.lvCR.View = View.Details;
            this.lvCR.AllowColumnReorder = true;
            this.lvCR.FullRowSelect = true;
            this.lvCR.GridLines = true;
            this.lvCR.Columns.Add("店名", 100, HorizontalAlignment.Left);
            this.lvCR.Columns.Add("编号", 50, HorizontalAlignment.Left);
            this.lvCR.Columns.Add("收银机名称", 90, HorizontalAlignment.Left);
            this.lvCR.Columns.Add("IP地址", 80, HorizontalAlignment.Left);
            this.lvCR.Columns.Add("主机名称", 100, HorizontalAlignment.Left);
            this.lvCR.Columns.Add("网卡地址", 120, HorizontalAlignment.Left);
            this.lvCR.Columns.Add("硬盘号", 120, HorizontalAlignment.Left);
            this.lvCR.Columns.Add("备注", 100, HorizontalAlignment.Left);
        }

        private void tbDelete_Click(object sender, EventArgs e)
        {
            if (this.lvCR.SelectedItems.Count > 0)
            {
                if (DialogResult.Yes == MessageBox.Show("确定要删除记录吗？", "提示", MessageBoxButtons.YesNo))
                {
                    string name = this.lvCR.SelectedItems[0].SubItems[0].Text;
                    crDAO = new CashRegisterDAOImpl();
                    crEntity = new CashRegisterEntity();
                    crEntity.Shopid = crDAO.getID(name);
                    crEntity.Id = this.lvCR.SelectedItems[0].SubItems[1].Text;
                    crDAO.CrDelete(crEntity);
                }
                this.FillLV();
            }
            else
            {
                MessageBox.Show("请选择记录");
            }
        }
    }
}