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

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(); 
            } 
        } 
    } 
}