goodsreturn.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace FORU_SMS_.BaseClass
{
    public class GoodsReturn
    {
        DataConn Dconn = new DataConn();
        DataClass Dclass = new DataClass();

        public string _GoodsID;
        public string _GoodsName;
        public string _SupName;
        public string _SpecName;
        public int _ReturnNum;
        public int _NoReturnNum;
        public string _ReturnPeople;
        public string _GoodsPeople;
        public string _GoodsRemarks;

        public string GoodsID
        {
            set { _GoodsID = value; }
            get { return _GoodsID; }
        }

        public string GoodsName
        {
            set { _GoodsName = value; }
            get { return _GoodsName; }
        }

        public string SupName
        {
            set { _SupName = value; }
            get { return _SupName; }
        }

        public string SpecName
        {
            set { _SpecName = value; }
            get { return _SpecName; }

        }
        public int ReturnNum
        {
            set { _ReturnNum = value; }
            get { return _ReturnNum; }
        }   

        public int NoReturnNum
        {
            set { _NoReturnNum = value; }
            get { return _NoReturnNum; }
        }

        public string ReturnPeople
        {
            set { _ReturnPeople = value; }
            get { return _ReturnPeople; }
        }

        public string GoodsPeople
        {
            set { _GoodsPeople = value; }
            get { return _GoodsPeople; }
        }

        public string GoodsRemarks
        {
            set { _GoodsRemarks = value; }
            get { return _GoodsRemarks; }
        }

        public void returnGoods()
        {
            string sql = "";
            sql = sql + "insert into SMS_Return(GoodsID,GoodsName,SupName,SpecName,ReturnNum,NoReturnNum,ReturnPeople,GoodsPeople,GoodsRemarks) values "
            + "(@GoodsID,@GoodsName,@SupName,@SpecName,@ReturnNum,@NoReturnNum,@ReturnPeople,@GoodsPeople,@GoodsRemarks)";
            sql = sql + ";";
            sql = sql + "delete from SMS_Borrow where GoodsID=@GoodsID";
            SqlCommand sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            SqlDataAdapter adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@GoodsID", SqlDbType.VarChar, 20, "GoodsID").Value = this.GoodsID;
            sqlcom.Parameters.Add("@GoodsName", SqlDbType.VarChar, 50, "GoodsName").Value = this.GoodsName;
            sqlcom.Parameters.Add("@SupName", SqlDbType.VarChar, 50, "SupName").Value = this.SupName;
            sqlcom.Parameters.Add("@SpecName", SqlDbType.VarChar, 50, "SpecName").Value = this.SpecName;
            sqlcom.Parameters.Add("@ReturnNum", SqlDbType.Int, 4, "ReturnNum").Value = this.ReturnNum;
            sqlcom.Parameters.Add("@NoReturnNum", SqlDbType.Int, 4, "NoReturnNum").Value = this.NoReturnNum;
            sqlcom.Parameters.Add("@ReturnPeople", SqlDbType.VarChar, 20, "ReturnPeople").Value = this.ReturnPeople;
            sqlcom.Parameters.Add("@GoodsPeople", SqlDbType.VarChar, 20, "GoodsPeople").Value = this.GoodsPeople;
            sqlcom.Parameters.Add("@GoodsRemarks", SqlDbType.VarChar, 1000, "GoodsRemarks").Value = this.GoodsRemarks;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }
    }
}