frmbaseinfo.cs

.net固定资产管理

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

namespace EquipmentMS.BaseInfo
{
    public partial class frmBaseInfo : Form
    {
        BaseClass.Operation oper = new EquipmentMS.BaseClass.Operation();
        public frmBaseInfo()
        {
            InitializeComponent();
        }

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

        private void btnZCMC_Click(object sender, EventArgs e)
        {
            lbName.DataSource = oper.GetDataSetBaseZcmc().Tables[0].DefaultView;
            lbName.DisplayMember = "zcmc";
            lbName.ValueMember = "id";
            labTitle.Text = btnZCMC.Text;
            departVisible(false);
        }
        private void departVisible(bool con)
        {
            this.DepartComboBox.Visible = con;
            this.Departlabel.Visible = con;
            
        }
        private void btnZJFS_Click(object sender, EventArgs e)
        {
            lbName.DataSource = oper.GetDataSetBaseZjfs().Tables[0].DefaultView;
            lbName.DisplayMember = "zjfs";
            lbName.ValueMember = "id";
            labTitle.Text = btnZJFS.Text;
            departVisible(false);
        }

        private void btnSYBM_Click(object sender, EventArgs e)
        {
            lbName.DataSource = oper.GetDataSetBaseSybm().Tables[0].DefaultView;
            lbName.DisplayMember = "sybm";
            lbName.ValueMember = "id";
            labTitle.Text = btnSYBM.Text;
            departVisible(false);
        }

        private void btnSYQK_Click(object sender, EventArgs e)
        {
            lbName.DataSource = oper.GetDataSetBaseSyqk().Tables[0].DefaultView;
            lbName.DisplayMember = "syqk";
            lbName.ValueMember = "id";
            labTitle.Text = btnSYQK.Text;
            departVisible(false);
        }

        private void btnCFDD_Click(object sender, EventArgs e)
        {
            
            this.BindComboBox();
            lbName.DataSource = oper.GetDataSetBaseCfdd().Tables[0].DefaultView;
            lbName.DisplayMember = "cfdd";
            lbName.ValueMember = "id";
            labTitle.Text = btnCFDD.Text;
            departVisible(true);
        }

        private void btnBGRY_Click(object sender, EventArgs e)
        {
            departVisible(true);
            this.BindComboBox();
            lbName.DataSource = oper.GetDataSetBaseBgry().Tables[0].DefaultView;
            lbName.DisplayMember = "bgry";
            lbName.ValueMember = "id";
            labTitle.Text = btnBGRY.Text;
        }

        private void frmBaseInfo_Load(object sender, EventArgs e)
        {
            this.btnZCMC_Click(sender, e);
            btnAdd.Enabled = true;
            btnSave.Enabled = false;
        }
        private void BindComboBox()
        {
            DepartComboBox.DataSource = oper.GetDataSetBaseSybm().Tables[0].DefaultView;
            DepartComboBox.ValueMember = "sybm";

        }
        private void btnAdd_Click(object sender, EventArgs e)
        {
            txtName.Text = "";
            txtName.Focus();
            btnSave.Enabled = true;
            btnAdd.Enabled = false;
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            
            if (txtName.Text == "")
            {
                MessageBox.Show("添加新項不能為空！", "系統提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                txtName.Focus();
                return;
            }
            else
            {
                switch (labTitle.Text)
                {
                    case "資產名稱":
                        int u = oper.InsertBaseZcmc(txtName.Text);
                        this.btnZCMC_Click(sender, e);
                        break;
                    case "资产名称":
                        int cu = oper.InsertBaseZcmc(txtName.Text);
                        this.btnZCMC_Click(sender, e);
                        break;
                    case "增加方式":
                        int i = oper.InsertBaseZjfs(txtName.Text);
                        this.btnZJFS_Click(sender, e);
                        break;
                    case "使用部门":
                        int j = oper.InsertBaseSybm(txtName.Text);
                        this.btnSYBM_Click(sender, e);
                        break;
                    case "使用部門":
                        int cj = oper.InsertBaseSybm(txtName.Text);
                        this.btnSYBM_Click(sender, e);
                        break;
                    case "使用情況":
                        int k = oper.InsertBaseSyqk(txtName.Text);
                        this.btnSYQK_Click(sender, e);
                        break;
                    case "使用情况":
                        int ck = oper.InsertBaseSyqk(txtName.Text);
                        this.btnSYQK_Click(sender, e);
                        break;
                    case "存放地點":
                        if (this.DepartComboBox.SelectedItem.ToString() == "")
                        {
                            MessageBox.Show("請選擇所屬部門!", "系統提示");
                            this.DepartComboBox.Focus();
                            return;
                        }
                        int p = oper.InsertBaseCfdd(txtName.Text,this.DepartComboBox.SelectedValue.ToString());
                        this.btnCFDD_Click(sender, e);
                        break;
                    case "存放地点":
                        if (this.DepartComboBox.SelectedItem.ToString() == "")
                        {
                            MessageBox.Show("请选择所属部门!", "系统提示");
                            this.DepartComboBox.Focus();
                            return;
                        }
                        int cp = oper.InsertBaseCfdd(txtName.Text, this.DepartComboBox.SelectedValue.ToString());
                        this.btnCFDD_Click(sender, e);
                        break;
                    case "保管人員":
                        if (this.DepartComboBox.SelectedItem.ToString() == "")
                        {
                            MessageBox.Show("請選擇所屬部門!", "系統提示");
                            this.DepartComboBox.Focus();
                            return;
                        }
                        int o = oper.InsertBaseBgry(txtName.Text,this.DepartComboBox.SelectedValue.ToString());
                        this.btnBGRY_Click(sender, e);
                        break;
                    case "保管人员":
                        if (this.DepartComboBox.SelectedItem.ToString() == "")
                        {
                            MessageBox.Show("请选择所属部门!", "系统提示");
                            this.DepartComboBox.Focus();
                            return;
                        }
                        int co = oper.InsertBaseBgry(txtName.Text, this.DepartComboBox.SelectedValue.ToString());
                        this.btnBGRY_Click(sender, e);
                        break;
                    case "計量單位":
                        int m = oper.InsertBaseJldw(txtName.Text);
                        this.btnJLDW_Click(sender, e);
                        break;
                    case "计量单位":
                        int cm = oper.InsertBaseJldw(txtName.Text);
                        this.btnJLDW_Click(sender, e);
                        break;
                    //case "清理方式":
                    case "品牌管理":
                        int l = oper.InsertBaseBrand(txtName.Text);
                        this.btnQLFS_Click(sender, e);
                        break;
                   
                }
                btnAdd.Enabled = true;
                btnSave.Enabled = false;
            }
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            btnAdd.Enabled = true;
            btnSave.Enabled = false;
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            switch (labTitle.Text)
                {
                    case "資產名稱":
                        int u = oper.DeleteBaseZcmc(lbName.SelectedValue.ToString());
                        this.btnZCMC_Click(sender, e);
                        break;
                    case "资产名称":
                        int cu = oper.DeleteBaseZcmc(lbName.SelectedValue.ToString());
                        this.btnZCMC_Click(sender, e);
                        break;
                    case "增加方式":
                        int i = oper.DeleteBaseZjfs(lbName.SelectedValue.ToString());
                        this.btnZJFS_Click(sender, e);
                        break;
                    case "使用部門":
                        int j = oper.DeleteBaseSybm(lbName.SelectedValue.ToString());
                        this.btnSYBM_Click(sender, e);
                        break;
                    case "使用部门":
                        int cj = oper.DeleteBaseSybm(lbName.SelectedValue.ToString());
                        this.btnSYBM_Click(sender, e);
                        break;
                    case "使用情況":
                        int k = oper.DeleteBaseSyqk(lbName.SelectedValue.ToString());
                        this.btnSYQK_Click(sender, e);
                        break;
                    case "使用情况":
                        int ck = oper.DeleteBaseSyqk(lbName.SelectedValue.ToString());
                        this.btnSYQK_Click(sender, e);
                        break;
                    case "存放地點":
                        int cp = oper.DeleteBaseCfdd(lbName.SelectedValue.ToString());
                        this.btnCFDD_Click(sender, e);
                        break;
                    case "存放地点":
                        int p = oper.DeleteBaseCfdd(lbName.SelectedValue.ToString());
                        this.btnCFDD_Click(sender, e);
                        break;
                    case "保管人員":
                        int o = oper.DeleteBaseBgry(lbName.SelectedValue.ToString());
                        this.btnBGRY_Click(sender, e);
                        break;
                    case "保管人员":
                        int co = oper.DeleteBaseBgry(lbName.SelectedValue.ToString());
                        this.btnBGRY_Click(sender, e);
                        break;
                    case "計量單位":
                        int l = oper.DeleteBaseJldw(lbName.SelectedValue.ToString());
                        this.btnJLDW_Click(sender, e);
                        break;
                    case "计量单位":
                        int cl = oper.DeleteBaseJldw(lbName.SelectedValue.ToString());
                        this.btnJLDW_Click(sender, e);
                        break;
                    case "品牌管理":
                        if (lbName.SelectedValue.ToString() != "")
                        {
                            DialogResult dialog = MessageBox.Show("確認删除品牌" + lbName.Text.ToString() + "麽?", "提示", MessageBoxButtons.YesNo);
                            if (dialog == DialogResult.Yes)
                            {
                                int m = oper.DeleteBaseBrand(lbName.SelectedValue.ToString());
                                this.btnQLFS_Click(sender, e);
                                
                            }
                            else
                            {
                                MessageBox.Show("已取消" + lbName.Text.ToString() + "的删除操作!", "提示");
                                
                            }
                        }
                        break;
                                           
                }
        }

        private void btnJLDW_Click(object sender, EventArgs e)
        {
            lbName.DataSource = oper.GetDataSetBaseJldw().Tables[0].DefaultView;
            lbName.DisplayMember = "jldw";
            lbName.ValueMember = "id";
            labTitle.Text = btnJLDW.Text;
            this.departVisible(false);
        }

        private void btnQLFS_Click(object sender, EventArgs e)
        {
            lbName.DataSource = oper.GetDataSetBaseBrand().Tables[0].DefaultView;
            lbName.DisplayMember = "BrandName";
            lbName.ValueMember = "id";
            labTitle.Text = btnQLFS.Text;
            this.departVisible(false);
        }
      
    }
}