supdata.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 SupData
    {
        DataConn Dconn = new DataConn();
        DataClass Dclass = new DataClass();
        public string _SupName;
        public string _ContactName;
        public string _SupPhone;
        public string _SupFax;
        public string _SupRemark;
        public int _SupID;

        public int SupID
        {
            set { _SupID = value; }
            get { return _SupID; }
        }

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

        public string ContactName
        {
            set { _ContactName = value; }
            get { return _ContactName; }
        }

        public string SupPhone
        {
            set { _SupPhone = value; }
            get { return _SupPhone; }
        }

        public string SupFax
        {
            set { _SupFax = value; }
            get { return _SupFax; }
        }

        public string SupRemark
        {
            set { _SupRemark = value; }
            get { return _SupRemark; }
        }

        public void addSup()
        {
            string sql = "";
            sql = sql + "insert into SMS_Sup(SupName,ContactName,SupPhone,SupFax,SupRemark) values (@SupName,@ContactName,@SupPhone,@SupFax,@SupRemark)";
            SqlCommand sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            SqlDataAdapter adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@SupName", SqlDbType.VarChar, 100).Value = this.SupName;
            sqlcom.Parameters.Add("@ContactName", SqlDbType.VarChar, 20).Value = this.ContactName;
            sqlcom.Parameters.Add("@SupPhone", SqlDbType.VarChar, 20).Value = this.SupPhone;
            sqlcom.Parameters.Add("@SupFax", SqlDbType.VarChar, 20).Value = this.SupFax;
            sqlcom.Parameters.Add("@SupRemark", SqlDbType.VarChar, 1000).Value = this.SupRemark;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }

        public void editSup()
        {
            string sql = "";
            sql = sql + "update SMS_Sup set SupName=@SupName,ContactName=@ContactName,SupPhone=@SupPhone,SupFax=@SupFax,SupRemark=@SupRemark where SupID=" + this.SupID + "";
            SqlCommand sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            SqlDataAdapter adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@SupName", SqlDbType.VarChar, 100).Value = this.SupName;
            sqlcom.Parameters.Add("@ContactName", SqlDbType.VarChar, 20).Value = this.ContactName;
            sqlcom.Parameters.Add("@SupPhone", SqlDbType.VarChar, 20).Value = this.SupPhone;
            sqlcom.Parameters.Add("@SupFax", SqlDbType.VarChar, 20).Value = this.SupFax;
            sqlcom.Parameters.Add("@SupRemark", SqlDbType.VarChar, 1000).Value = this.SupRemark;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }
    }
}