frmismanage.cs

对库存商品进行管理。采用SQL SERVER 创建后台数据库

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;

namespace SMS.GoodsManage
{
    public partial class frmISManage : Form
    {
        SMS.BaseClass.DataCon datacon = new SMS.BaseClass.DataCon();
        SMS.BaseClass.DataOperate doperate = new SMS.BaseClass.DataOperate();
        public frmISManage()
        {
            InitializeComponent();
        }
        
        private void frmISManage_Load(object sender, EventArgs e)
        {
            dgvISManage.Controls.Add(hScrollBar1);
            doperate.cboxBind("select StoreName from tb_Storage", "tb_Storage", "StoreName", cboxSName);
            doperate.cboxBind("select PrName from tb_Provider", "tb_Provider", "PrName", cboxPName);
            DataSet myds = datacon.getds("select ISID as 入库编号,GoodsID as 货物编号,GoodsName as 货物名称,PrName as 供应商名称,"
                + "StoreName as 仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,GoodsNum as 入库数量,"
                + "GoodsPrice as 进货价格,GoodsAPrice as 总金额,ISDate as 入库日期,HandlePeople as 经手人,"
                + "ISRemark as 备注 from tb_InStore", "tb_InStore");
            dgvISManage.DataSource = myds.Tables[0];
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (txtISGID.Text == "")
            {
                MessageBox.Show("货物编号不能为空！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            if (txtGIPrice.Text == "")
            {
                MessageBox.Show("货物单价不能为空！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                int P_int_returnValue = doperate.InsertGoods(Convert.ToInt32(txtISGID.Text.Trim()), txtISGName.Text.Trim(),
                    cboxPName.Text.Trim(), cboxSName.Text.Trim(), txtGSpec.Text.Trim(), cboxGUnit.Text.Trim(),
                    Convert.ToInt32(txtISGNum.Text.Trim()), Convert.ToDecimal(txtGIPrice.Text.Trim()), txtHPeople.Text.Trim(), txtISRemark.Text.Trim());
                if (P_int_returnValue == 100)
                {
                    MessageBox.Show("该货物号已经被占用！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else if (P_int_returnValue == 200)
                {
                    MessageBox.Show("这类货物已经存在惟一编号！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("货物入库成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    frmISManage_Load(sender, e);
                }
            }
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            try
            {
                datacon.getcom("delete from tb_InStore where ISID="
                    + Convert.ToString(dgvISManage[0, dgvISManage.CurrentCell.RowIndex].Value).Trim() + "");
                MessageBox.Show("货物删除成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                frmISManage_Load(sender, e);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }

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

        private void dgvISManage_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtISGID.Text = Convert.ToString(dgvISManage[1,dgvISManage.CurrentCell.RowIndex].Value).Trim();
            txtISGName.Text = Convert.ToString(dgvISManage[2, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            cboxSName.Text = Convert.ToString(dgvISManage[4, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            cboxPName.Text = Convert.ToString(dgvISManage[3, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            txtGSpec.Text = Convert.ToString(dgvISManage[5, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            cboxGUnit.Text = Convert.ToString(dgvISManage[6, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            txtISGNum.Text = Convert.ToString(dgvISManage[7, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            txtGIPrice.Text = Convert.ToString(dgvISManage[8, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            txtGSPrice.Text = Convert.ToString(dgvISManage[9, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            txtHPeople.Text = Convert.ToString(dgvISManage[11, dgvISManage.CurrentCell.RowIndex].Value).Trim();
            txtISRemark.Text = Convert.ToString(dgvISManage[12, dgvISManage.CurrentCell.RowIndex].Value).Trim();
        }

        private void txtGIPrice_TextChanged(object sender, EventArgs e)
        {
            try
            {
                txtGSPrice.Text = Convert.ToString(Convert.ToDecimal(txtGIPrice.Text.Trim()) * Convert.ToInt32(txtISGNum.Text.Trim())).Trim();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }

        private void frmISManage_FormClosed(object sender, FormClosedEventArgs e)
        {
            this.Close();
        }
    }
}