www.pudn.com > FORU(SMS).rar > SMS_Borrow.cs

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_Borrow : Form 
    { 
        BaseClass.DataClass Dclass = new FORU_SMS_.BaseClass.DataClass(); 
        BaseClass.DataConn Dconn = new FORU_SMS_.BaseClass.DataConn(); 
        BaseClass.GoodsBor Gbor = new FORU_SMS_.BaseClass.GoodsBor(); 
        SqlDataReader sqlRead; 
        DataSet ds; 
        public SMS_Borrow() 
        { 
            InitializeComponent(); 
        } 
 
        private void SMS_Borrow_Load(object sender, EventArgs e) 
        { 
            dgvBGManage.Controls.Add(hScrollBar1); 
            Dclass.BindComboBox("select StoreName from SMS_Store", "SMS_Store", "StoreName", cboxSName); 
            Dclass.BindComboBox("select GoodsName from SMS_Goods", "SMS_Goods", "GoodsName", cboxGName); 
            ds = Dclass.GetDataSet("select GoodsID AS 产品编号,GoodsName AS 产品名称,SupName AS 仓库名称,SpecName AS 货物规格,GoodsNum AS 出库数量," 
            + "BorName AS 借货人,GoodsPeople AS 经手人,BorDeparment AS 借货单位,GoodsRemarks AS 备注 from SMS_Borrow", "SMS_Borrow"); 
            dgvBGManage.DataSource = ds.Tables["SMS_Borrow"]; 
        } 
 
        private void cboxGName_SelectedIndexChanged(object sender, EventArgs e) 
        { 
            sqlRead = Dclass.GetRead("select GoodsID,SpecName from SMS_Goods where GoodsName='" + this.cboxGName.Text.Trim() + "'"); 
            if (sqlRead.Read()) 
            { 
                this.GoodsID.Text = sqlRead["GoodsID"].ToString().Trim(); 
                this.cboxGSpec.Text = sqlRead["SpecName"].ToString().Trim(); 
            } 
            sqlRead.Close(); 
        } 
 
        private void btnAdd_Click(object sender, EventArgs e) 
        { 
            if (this.txtBGNum.Text == "") 
            { 
                MessageBox.Show("产品数量不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
                this.cboxGName.Focus(); 
            } 
            else if (this.txtBGPeople.Text == "") 
            { 
                MessageBox.Show("借货人不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
                this.txtBGPeople.Focus(); 
            } 
            else if (this.txtHPeople.Text == "") 
            { 
                MessageBox.Show("经手人不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
                this.txtHPeople.Focus(); 
            } 
            else if (this.txtBGNum.Text == "") 
            { 
                MessageBox.Show("借出数量不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
                this.txtBGNum.Focus(); 
            } 
            else if (Convert.ToInt32(this.txtBGNum.Text.Trim()) == 0) 
            { 
                MessageBox.Show("借出数量不能为0！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
                this.txtBGNum.Focus(); 
            } 
            else 
            { 
                sqlRead = Dclass.GetRead("select GoodsID,GoodsName,SpecName,GoodsNum 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 (Convert.ToInt32(this.txtBGNum.Text) > Convert.ToInt32(sqlRead["GoodsNum"].ToString().Trim())) 
                    { 
                        MessageBox.Show("没有足够的货物！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
                        this.txtBGNum.Text = ""; 
                        this.txtBGNum.Focus(); 
                    } 
                    else 
                    { 
                        Gbor._GoodsID = this.GoodsID.Text.Trim(); 
                        Gbor._GoodsName = this.cboxGName.Text.Trim(); 
                        Gbor._SpecName = this.cboxGSpec.Text.Trim(); 
                        Gbor._SupName = this.cboxSName.Text.Trim(); 
                        Gbor._GoodsNum = int.Parse(this.txtBGNum.Text.Trim()); 
                        Gbor._BorDeparment = this.txtBGDepart.Text.Trim(); 
                        Gbor._GoodsPeople = this.txtHPeople.Text.Trim(); 
                        Gbor._BorName = this.txtBGPeople.Text.Trim(); 
                        Gbor._GoodsRemarks = this.txtBGRemark.Text.Trim(); 
                        Gbor.barGoods(); 
                        MessageBox.Show("提交成功！"); 
                        dgvBGManage.Refresh(); 
                        ds = Dclass.GetDataSet("select GoodsID AS 产品编号,GoodsName AS 产品名称,SupName AS 仓库名称,SpecName AS 货物规格,GoodsNum AS 出库数量," 
            + "BorName AS 借货人,GoodsPeople AS 经手人,BorDeparment AS 借货单位,GoodsRemarks AS 备注 from SMS_Borrow", "SMS_Borrow"); 
                        dgvBGManage.DataSource = ds.Tables["SMS_Borrow"]; 
                        //cboxGName.Items.Clear(); 
                        Dclass.BindComboBox("select GoodsName from SMS_Goods", "SMS_Goods", "GoodsName", cboxGName); 
                        this.cboxGSpec.Text = ""; 
                        this.txtBGNum.Text = ""; 
                    } 
                } 
            } 
        } 
 
 
        private void btnDel_Click(object sender, EventArgs e) 
        { 
            if (dgvBGManage.SelectedRows.Count == 0) 
            { 
                MessageBox.Show("请选择一个操作项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
            } 
            else 
            { 
                try 
                { 
                    Dclass.ExecuteSql("delete from SMS_Borrow where GoodsID='" + this.dgvBGManage.SelectedRows[0].Cells[0].Value.ToString() + "'"); 
                    MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
                    SMS_Borrow_Load(sender, e); 
                } 
                catch (Exception ex) 
                { 
                    MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); 
                } 
            } 
        } 
 
 
        private void btnRGManage_Click(object sender, EventArgs e) 
        { 
            if (dgvBGManage.SelectedRows.Count == 0) 
            { 
                MessageBox.Show("请选择一个操作项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); 
            } 
            else 
            { 
                SMS_ReturnGoods Rgoods = new SMS_ReturnGoods(this.dgvBGManage.SelectedRows[0].Cells[0].Value.ToString()); 
                Rgoods.Show(); 
            } 
        } 
 
 
        private void txtBGNum_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 btnExit_Click(object sender, EventArgs e) 
        { 
            this.Close(); 
        } 
    } 
}