unitform.cs

一个超市管理系统,没有错误,非常好,里面什么都有!很使用,很有用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DaFanRongMIS.Model.Unit;

namespace DaFanRongMIS.ViewController.Unit
{
    public partial class UnitForm : Form
    {
        public UnitForm()
        {
            InitializeComponent();
        }
        UnitEntity ue = new UnitEntity();
        UnitDAO ud = new UnitDAOImpl();

        #region 填充方法
        public void Fill()
        {
            LVUnit.Items.Clear();
            DataTable dt = ud.Select();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem item = new ListViewItem(dt.Rows[i][0].ToString());
                item.SubItems.Add(dt.Rows[i][1].ToString());
                LVUnit.Items.Add(item);
            }
        }
        #endregion

        private void UnitForm_Load(object sender, EventArgs e)
        {
            this.Fill();
            this.tbDelete.Enabled = false;
            this.tbUpdate.Enabled = false;
            //this.AutoCode();不太合理?
        }
        #region 增加
        private void tbAdd_Click(object sender, EventArgs e)
        {
            if (txtId.Text != "" && txtName.Text != "")
            {
                
                ue.Id = txtId.Text;
                ue.Name = txtName.Text;
                string str = ud.AddUnit(ue);

                if (str == "ok")
                {
                    MessageBox.Show("添中信息成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("添中信息失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                this.Fill();
            }
            else
            {
                MessageBox.Show("编号或名称不能为空！","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information );
            }

        }
        #endregion

        #region 删除
        private void tbDelete_Click(object sender, EventArgs e)
        {
            ue.Id = txtId.Text;
            if (MessageBox.Show("确定删除此记录吗?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string str = ud.DeleteUnit(ue.Id);
                if (str == "ok")
                {
                    MessageBox.Show("信息删除成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("信息删除失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                txtId.Text = "";
                txtName.Text = "";
                this.tbDelete.Enabled = false;
                this.tbUpdate.Enabled = false;
            }
            else
            {
                txtId.Text = "";
                txtName.Text = "";
            }
            this.Fill();
        }
        #endregion

        private void LVUnit_Click(object sender, EventArgs e)
        {
            txtId.Text = LVUnit.SelectedItems[0].SubItems[0].Text;
            txtName.Text = LVUnit.SelectedItems[0].SubItems[1].Text;
            this.tbDelete.Enabled = true ;
            this.tbUpdate.Enabled = true;
        }

        #region 查询
        private void tbSelect_Click(object sender, EventArgs e)
        {
            if(txtId .Text =="" && txtName.Text!="")
            {   
                ue.Name = txtName.Text;
                DataTable dt = ud.SelectLike(ue.Name );
                LVUnit.Items.Clear();
                for (int i = 0; i < dt.Rows.Count;i++ )
                {
                    ListViewItem item = new ListViewItem(dt.Rows[i][0].ToString ());
                    item.SubItems.Add(dt.Rows [i][1].ToString ());
                    LVUnit.Items.Add(item);
                }
            }
            else if (txtId.Text != "" && txtName.Text == "")
            {
                ue.Id  = txtId.Text;
                DataTable dt = ud.SelectLikeID(ue.Id);
                LVUnit.Items.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ListViewItem item = new ListViewItem(dt.Rows[i][0].ToString());
                    item.SubItems.Add(dt.Rows[i][1].ToString());
                    LVUnit.Items.Add(item);
                }
            }
            else if (txtId.Text != "" && txtName.Text != "")
            {
                ue.Id = txtId.Text;
                ue.Name = txtName.Text;
                DataTable dt = ud.SelectLikeIDName(ue.Id,ue.Name );
                LVUnit.Items.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ListViewItem item = new ListViewItem(dt.Rows[i][0].ToString());
                    item.SubItems.Add(dt.Rows[i][1].ToString());
                    LVUnit.Items.Add(item);
                }
            }
            else
            {
                DataTable dt = ud.Select();
                LVUnit.Items.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ListViewItem item = new ListViewItem(dt.Rows[i][0].ToString());
                    item.SubItems.Add(dt.Rows[i][1].ToString());
                    LVUnit.Items.Add(item);
                }
                txtName.Text ="";
                txtId.Text ="";
            }
        }
        #endregion

        #region 修改
        private void tbUpdate_Click(object sender, EventArgs e)
        {
            ue.Id = txtId.Text;
            ue.Name = txtName.Text;
            string str = ud.UpdataUnit(ue);
            str = "ok";
            try
            {
                MessageBox.Show("修改信息成功!","提示信息",MessageBoxButtons.OK ,MessageBoxIcon.Information );
            }
            catch 
            { 
                MessageBox.Show("修改信息失败!","提示信息",MessageBoxButtons.OK ,MessageBoxIcon.Information );
            }
            this.Fill();
            txtId.Text = "";
            txtName.Text = "";
            this.tbDelete.Enabled = false;
            this.tbUpdate.Enabled = false;
        }
        #endregion

        #region 自动生成编号??
        public void AutoCode()
        {
            DataTable dt = ud.Select();
            string strid = dt.Rows[dt.Rows.Count - 1][0].ToString();
            if (strid == "")
            {
                this.txtId.Text = "01";
            }
            else
            {
                if ((Convert.ToInt32(strid) + 1) < 10)
                {
                    this.txtId.Text ='0'+ Convert.ToString(Convert.ToInt32(strid) + 1);
                }
                else
                {
                    this.txtId.Text = Convert.ToString(Convert.ToInt32(strid) + 1);
                }
            }
        }
        #endregion
    }
}