sms_goodsout.cs

库存管理系统,对企业仓库的产品进行管理,使用C#语句 .net 平台开发

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 FORU_SMS_
{
    public partial class SMS_GoodsOut : Form
    {
        BaseClass.DataConn Dconn = new FORU_SMS_.BaseClass.DataConn();
        BaseClass.DataClass Dclass = new FORU_SMS_.BaseClass.DataClass();
        BaseClass.GoodsOut Gout = new FORU_SMS_.BaseClass.GoodsOut();
        SqlDataReader sqlRead;
        public SMS_GoodsOut()
        {
            InitializeComponent();
        }

        private void SMS_GoodsOut_Load(object sender, EventArgs e)
        {
            dgvOSManage.Controls.Add(hScrollBar1);
            Dclass.BindComboBox("select StoreName from SMS_Store", "SMS_Store", "StoreName", cboxSName);
            Dclass.BindComboBox("select DepName from SMS_DepartMent", "SMS_DepartMent","DepName", cboxGDep);
            Dclass.BindComboBox("select GoodsName from SMS_Goods", "SMS_Goods", "GoodsName", cboxGName);
            DataSet ds = Dclass.GetDataSet("select GoodsID AS 货物编号, GoodsName AS 货物名称, SupName AS 仓库名称,"
            + "SpecName AS 货物规格, UnitName AS 计量单位,GoodsNum AS 出库数量, GoodsPrice AS 货物单价, GoodsAPrice AS 总金额,"
            + "GoodsTime AS 出库日期,GoodsPeople AS 经手人, UpGoodsPeople AS 提货人,GoodsDep As 提货单位, GoodsRemarks AS 备注 from SMS_GoodsOut", "SMS_GoodsOut");
            dgvOSManage.DataSource = ds.Tables["SMS_GoodsOut"];
        }

        private void cboxGName_SelectedIndexChanged(object sender, EventArgs e)
        {
            sqlRead = Dclass.GetRead("select GoodsID,GoodsNum,UnitName,SpecName,GoodsPrice,GoodsAPrice,GoodsPeople from SMS_Goods where GoodsName='" + this.cboxGName.Text.Trim() + "'");
            //and SupName='" + this.cboxSName.Text.Trim() + "'
            if (sqlRead.Read())
            {
                this.cboxGUnit.Text = sqlRead["UnitName"].ToString().Trim();
                this.txtOSGNum.Text = sqlRead["GoodsNum"].ToString().Trim();
                this.cboxGSpec.Text = sqlRead["SpecName"].ToString().Trim();
                this.txtGOPrice.Text = sqlRead["GoodsPrice"].ToString().Trim();
                this.txtGSPrice.Text = sqlRead["GoodsAPrice"].ToString().Trim();
                this.txtHPeople.Text = sqlRead["GoodsPeople"].ToString().Trim();
                this.GoodsID.Text = sqlRead["GoodsID"].ToString().Trim();
            }
            sqlRead.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            dgvOSManage.Refresh();
            DataSet ds = Dclass.GetDataSet("select GoodsID AS 货物编号, GoodsName AS 货物名称, SupName AS 仓库名称,"
            + "SpecName AS 货物规格, UnitName AS 计量单位,GoodsNum AS 出库数量, GoodsPrice AS 货物单价, GoodsAPrice AS 总金额,"
            + "GoodsTime AS 出库日期,GoodsPeople AS 经手人, UpGoodsPeople AS 提货人,GoodsDep As 提货单位, GoodsRemarks AS 备注 from SMS_GoodsOut", "SMS_GoodsOut");
            dgvOSManage.DataSource = ds.Tables[0];
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            sqlRead = Dclass.GetRead("select GoodsID,GoodsNum,UnitName,SpecName,GoodsPrice,GoodsAPrice,GoodsPeople from SMS_Goods where GoodsName='" + this.cboxGName.Text.Trim() + "'");
            if (sqlRead.Read())
            {
                if (Convert.ToInt32(sqlRead["GoodsNum"].ToString().Trim()) < 1)
                {
                    MessageBox.Show("库存不足！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    if (this.cboxSName.Text == "")
                    {
                        MessageBox.Show("仓库名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        cboxSName.Focus();
                    }
                    else if (this.cboxGName.Text == "")
                    {
                        MessageBox.Show("产品名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        cboxGName.Focus();
                    }
                    else if (this.cboxGSpec.Text == "")
                    {
                        MessageBox.Show("产品规格不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        cboxGSpec.Focus();
                    }
                    else if (this.txtOSGNum.Text == "")
                    {
                        MessageBox.Show("产品数量不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        txtOSGNum.Focus();
                    }
                    else if (Convert.ToInt32(this.txtOSGNum.Text) == 0)
                    {
                        MessageBox.Show("产品数量不能为0！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        txtOSGNum.Text = "";
                        txtOSGNum.Focus();
                    }
                    else if (Convert.ToInt32(this.txtOSGNum.Text) > Convert.ToInt32(sqlRead["GoodsNum"].ToString().Trim()))
                    {
                        MessageBox.Show("没有足够的货物！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.txtOSGNum.Text = "";
                        this.txtOSGNum.Focus();
                    }
                    else if (this.txtOSPeople.Text == "")
                    {
                        MessageBox.Show("提取人不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        txtOSPeople.Focus();
                    }
                    else if (this.cboxGDep.Text == "")
                    {
                        MessageBox.Show("提取单位不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        cboxGUnit.Focus();
                    }
                    else
                    {
                        Gout._GoodsID = this.GoodsID.Text.ToString().Trim();
                        Gout._GoodsName = this.cboxGName.Text.ToString().Trim();
                        Gout._SpecName = this.cboxGSpec.Text.ToString().Trim();
                        Gout._SupName = this.cboxSName.Text.ToString().Trim();
                        Gout._UnitName = this.cboxGUnit.Text.ToString().Trim();
                        Gout._UpGoodsPeople = this.txtOSPeople.Text.ToString().Trim();
                        Gout._GoodsPeople = this.txtHPeople.Text.ToString().Trim();
                        Gout._GoodsDep = this.cboxGDep.Text.ToString().Trim();
                        Gout._GoodsNum = int.Parse(this.txtOSGNum.Text.Trim());
                        Gout._GoodsPrice = double.Parse(this.txtGOPrice.Text.Trim());
                        Gout._GoodsAPrice = double.Parse(this.txtGSPrice.Text.Trim());
                        Gout._GoodsRemarks = this.txtOSRemark.Text.ToString().Trim();
                        Gout.OutGoods();

                        dgvOSManage.Refresh();
                        DataSet ds = Dclass.GetDataSet("select GoodsID AS 货物编号, GoodsName AS 货物名称, SupName AS 仓库名称,"
                        + "SpecName AS 货物规格, UnitName AS 计量单位,GoodsNum AS 出库数量, GoodsPrice AS 货物单价, GoodsAPrice AS 总金额,"
                        + "GoodsTime AS 出库日期,GoodsPeople AS 经手人, UpGoodsPeople AS 提货人,GoodsDep As 提货单位, GoodsRemarks AS 备注 from SMS_GoodsOut", "SMS_GoodsOut");
                        dgvOSManage.DataSource = ds.Tables[0];

                        MessageBox.Show("提交成功！");

                        Dclass.BindComboBox("select GoodsName from SMS_Goods", "SMS_Goods", "GoodsName", cboxGName);
                        //cboxGName.Items.Clear();
                        //DataTable dt = Dclass.GetDataTable("select GoodsName from SMS_Goods");
                        //for (int i = 0; i < dt.Rows.Count; i++)
                        //{
                        //    this.cboxGName.Items.Add(dt.Rows[i][0].ToString().Trim());
                        //}

                        this.cboxGSpec.Text = "";
                        this.cboxGUnit.Text = "";
                        this.txtOSGNum.Text = "";
                        this.txtGOPrice.Text = "";
                        this.txtGSPrice.Text = "";
                        this.txtHPeople.Text = "";
                        this.txtOSRemark.Text = "";
                    }
                }
            }
            sqlRead.Close();

        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            if (this.dgvOSManage.SelectedRows.Count == 0)
            {
                MessageBox.Show("请选择一个操作项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                try
                {
                    Dclass.ExecuteSql("delete from SMS_GoodsOut where GoodsID='" + dgvOSManage.SelectedRows[0].Cells[0].Value.ToString() + "'");
                    SMS_GoodsOut_Load(sender, e);
                    MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch (Exception exc)
                {
                    MessageBox.Show(exc.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
                    //MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    //dgvOSManage.Refresh();
                    //DataSet ds = Dclass.GetDataSet("select GoodsID AS 货物编号, GoodsName AS 货物名称, SupName AS 仓库名称,"
                    //+ "SpecName AS 货物规格, UnitName AS 计量单位,GoodsNum AS 出库数量, GoodsPrice AS 货物单价, GoodsAPrice AS 总金额,"
                    //+ "GoodsTime AS 出库日期,GoodsPeople AS 经手人, UpGoodsPeople AS 提货人,GoodsDep As 提货单位, GoodsRemarks AS 备注 from SMS_GoodsOut", "SMS_GoodsOut");
                    //dgvOSManage.DataSource = ds.Tables[0];
            }
        }


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

        private void txtOSGNum_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar <= 57 && e.KeyChar >= 48 || e.KeyChar == 46 || e.KeyChar == 8)
            {
                e.Handled = false;
            }
            else
            {
                e.Handled = true;
            }
        }

    }
}