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

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