sms_goodsin.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_GoodsIn : Form
    {
        BaseClass.DataClass Dclass = new FORU_SMS_.BaseClass.DataClass();
        BaseClass.AddGoods AGood = new FORU_SMS_.BaseClass.AddGoods();
        public SMS_GoodsIn()
        {
            InitializeComponent();
        }

        private void SMS_GoodsIn_Load(object sender, EventArgs e)
        {
            dgvISManage.Controls.Add(hScrollBar1);
            Dclass.BindComboBox("select StoreName from SMS_Store", "SMS_Store", "StoreName", cboxSName);
            Dclass.BindComboBox("select SupName from SMS_Sup", "SMS_Sup", "SupName", cboxPName);
            DataSet ds = Dclass.GetDataSet("select * from V_Goods", "V_Goods");
            dgvISManage.DataSource = ds.Tables[0];
            this.txtISGID.Text = System.DateTime.Parse(Convert.ToString(System.DateTime.Now)).ToString("yyyyMMddhhmmss");
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (this.txtISGID.Text == "")
            {
                MessageBox.Show("产品编号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.txtISGID.Focus();
            }
            else if (this.txtISGName.Text == "")
            {
                MessageBox.Show("产品名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.txtISGName.Focus();
            }
            else if (this.txtISGNum.Text == "")
            {
                MessageBox.Show("产品数量不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.txtISGNum.Focus();
            }
            else if (this.txtGIPrice.Text == "")
            {
                MessageBox.Show("产品单价不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.txtGIPrice.Focus();
            }
            else if (this.txtHPeople.Text == "")
            {
                MessageBox.Show("经手人不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.txtHPeople.Focus();
            }
            else
            {
                AGood._GoodsID = this.txtISGID.Text.ToString();
                AGood._GoodsName = this.txtISGName.Text.Trim();
                AGood._SupName = this.cboxSName.Text.Trim();        //仓库
                AGood._SpecName = this.txtGSpec.Text.Trim();        //货物规格
                AGood._StoreName = this.cboxPName.Text.Trim();      //供应商
                AGood._UnitName = this.cboxGUnit.Text.Trim();
                AGood._GoodsNum = int.Parse(this.txtISGNum.Text.Trim());
                AGood._GoodsPrice = double.Parse(this.txtGIPrice.Text.Trim());
                AGood._GoodsAPrice = double.Parse(this.txtGSPrice.Text);
                AGood._GoodsPeople = this.txtHPeople.Text.Trim();
                AGood._GoodsRemarks = this.txtISRemark.Text.Trim();
                Dclass.saveGoods(AGood);
                DataSet ds = Dclass.GetDataSet("select * from V_Goods", "V_Goods");
                dgvISManage.DataSource = ds.Tables[0];
                MessageBox.Show("数据保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.txtISGID.Text = System.DateTime.Parse(Convert.ToString(System.DateTime.Now)).ToString("yyyyMMddhhmmss");
                this.txtISGName.Text = "";
                this.cboxPName.Text = "";
                this.txtGSpec.Text = "";
                this.cboxGUnit.Text = "";
                this.txtISGNum.Text = "";
                this.txtGIPrice.Text = "";
                this.txtGSPrice.Text = "";
                this.txtHPeople.Text = "";
                this.txtISRemark.Text = "";
            }
           
        }

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

        private void txtISGNum_TextChanged(object sender, EventArgs e)
        {
            if (txtGIPrice.Text != "" && txtISGNum.Text != "")
            {
                this.txtGSPrice.Text = Convert.ToString(Convert.ToUInt64(this.txtGIPrice.Text) * Convert.ToUInt64(this.txtISGNum.Text));
            }
        }

        private void txtGIPrice_TextChanged(object sender, EventArgs e)
        {
            if (txtISGNum.Text != "")
            {
                this.txtGSPrice.Text = Convert.ToString(Convert.ToUInt64(this.txtGIPrice.Text) * Convert.ToUInt64(this.txtISGNum.Text));
            }
            else
            {
                this.txtGSPrice.Text = this.txtGIPrice.Text;
            }
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            if (dgvISManage.SelectedRows.Count == 0)
            {
                MessageBox.Show("请选择一条要删除的项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            else 
            {
                try
                {
                    Dclass.ExecuteSql("delete from V_Goods where 货物编号='" + this.dgvISManage.SelectedRows[0].Cells[0].Value.ToString().Trim() + "'");
                    //SMS_GoodsIn_Load()
                    DataSet ds = Dclass.GetDataSet("select * from V_Goods", "V_Goods");
                    dgvISManage.DataSource = ds.Tables[0];
                    MessageBox.Show("删除成功！");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
        }

        private void txtGIPrice_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;
            }
        }

        private void txtISGNum_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;
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {

        }

        private void button2_Click(object sender, EventArgs e)
        {
            dgvISManage.Refresh();
            DataSet ds = Dclass.GetDataSet("select * from V_Goods", "V_Goods");
            dgvISManage.DataSource = ds.Tables[0];
            this.txtISGID.Refresh();
            this.txtISGID.Text = System.DateTime.Parse(Convert.ToString(System.DateTime.Now)).ToString("yyyyMMddhhmmss");
        }

        private void dgvISManage_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (this.dgvISManage.SelectedRows.Count == 0)
            {
                MessageBox.Show("至于选择一个项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            else
            {
                SMS_UpGoods UG = new SMS_UpGoods(this.dgvISManage.SelectedRows[0].Cells[0].Value.ToString());
                UG.ShowDialog();
            }
        }

    }
}