storedata.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 StoreData
    {
        DataConn Dconn = new DataConn();
        DataClass Dclass = new DataClass();

        public int _StoreID;
        public string _StoreName;
        public string _ForName;
        public string _StorePhone;
        public string _StoreDepart;
        public string _StoreAddre;
        public string _StoreRemark;

        public int StoreID
        {
            set { _StoreID = value; }
            get { return _StoreID; }
        }

        public string StoreName
        {
            set { _StoreName = value; }
            get { return _StoreName; }
        }

        public string ForName
        {
            set { _ForName = value; }
            get { return _ForName; }
        }

        public string StorePhone
        {
            set { _StorePhone = value; }
            get { return _StorePhone; }
        }

        public string StoreDepart
        {
            set { _StoreDepart = value; }
            get { return _StoreDepart; }
        }

        public string StoreAddre
        {
            set { _StoreAddre = value; }
            get { return _StoreAddre; }
        }

        public string StoreRemark
        {
            set { _StoreRemark = value; }
            get { return _StoreRemark; }
        }

        public void addStore()
        {
            string sql = "";
            sql = sql + "insert into SMS_Store(StoreName,ForName,StorePhone,StoreDepart,StoreAddre,StoreRemark) values "
            + "(@StoreName,@ForName,@StorePhone,@StoreDepart,@StoreAddre,@StoreRemark)";
            SqlCommand sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            SqlDataAdapter adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@StoreName", SqlDbType.VarChar, 50).Value = this.StoreName;
            sqlcom.Parameters.Add("@ForName", SqlDbType.VarChar, 20).Value = this.ForName;
            sqlcom.Parameters.Add("@StorePhone", SqlDbType.VarChar, 15).Value = this.StorePhone;
            sqlcom.Parameters.Add("@StoreDepart", SqlDbType.VarChar, 50).Value = this.StoreDepart;
            sqlcom.Parameters.Add("@StoreAddre", SqlDbType.VarChar, 100).Value = this.StoreAddre;
            sqlcom.Parameters.Add("@StoreRemark", SqlDbType.VarChar, 1000).Value = this.StoreRemark;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }

        public void editStore()
        {
            string sql = "";
            sql = sql + "update SMS_Store set StoreName=@StoreName,ForName=@ForName,StorePhone=@StorePhone,StoreDepart=@StoreDepart,StoreAddre=@StoreAddre,StoreRemark=@StoreRemark where StoreID=" + this.StoreID + "";
            SqlCommand sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            SqlDataAdapter adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@StoreName", SqlDbType.VarChar, 50).Value = this.StoreName;
            sqlcom.Parameters.Add("@ForName", SqlDbType.VarChar, 20).Value = this.ForName;
            sqlcom.Parameters.Add("@StorePhone", SqlDbType.VarChar, 15).Value = this.StorePhone;
            sqlcom.Parameters.Add("@StoreDepart", SqlDbType.VarChar, 50).Value = this.StoreDepart;
            sqlcom.Parameters.Add("@StoreAddre", SqlDbType.VarChar, 100).Value = this.StoreAddre;
            sqlcom.Parameters.Add("@StoreRemark", SqlDbType.VarChar, 1000).Value = this.StoreRemark;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }
    }
}