mytelephonebook.cs

同学学习时的即性之作,电话本仅供大家作为参考.

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

namespace 电话本
{
    class myTelephoneBook
    {
        private int id;
        private string name;
        private string telephone;
        public int ID {
            get 
            { 
                return id; 
            }
            set 
            {
                id = value;
            }
        }
        public string Name {
            get
            { 
                return name;
            }
            set 
            { 
                name = value;
            }
        }
        public string Telephone {
            get 
            { 
                return telephone;
            }
            set 
            { 
                telephone = value;
            }
        }
        public myTelephoneBook() { 
        
        }
        public void add() {
            
            SqlConnection conn = new SqlConnection("server=张辉\\SQLEXPRESS;integrated security=SSPI;database=张辉");
            string addUser = "insert into 电话本(name,telephone)values('" + this.name + "','" + this.telephone + "')";
            conn.Open();
            if (conn.Database!=null)
            {
                SqlCommand comm = new SqlCommand(addUser, conn);
                if (comm.ExecuteNonQuery() > 0)
                {
                    MessageBox.Show("添加成功");
                }
            }
            else {
                MessageBox.Show("错误");
            }
            conn.Close();
        }
        public void delete() {
            
            SqlConnection conn = new SqlConnection("server=张辉\\SQLEXPRESS;integrated security=SSPI;database=张辉");
            //string deleteUser = "delete from 电话本 where id=@id";
            SqlCommand comm = new SqlCommand("delete from 电话本 where id=@id",conn);
            SqlParameter par = new SqlParameter("@id",SqlDbType.Int);
            par.Value=this.id;
           
            conn.Open();
            comm.Parameters.Add(par);
            comm.ExecuteNonQuery();
            
            conn.Close();
        }
        public void show() {

            SqlConnection conn = new SqlConnection("server=张辉\\SQLEXPRESS;integrated security=SSPI;database=张辉");
            
            SqlCommand comm = new SqlCommand();
            comm.CommandText = "proc_show";
            comm.CommandType = CommandType.StoredProcedure;
            comm.Connection = conn;
            conn.Open();
            SqlParameter[] pars = new SqlParameter[2];
            pars[0] = new SqlParameter("@name", this.name);
            pars[1] = new SqlParameter("@telephone", this.telephone);
            comm.Parameters.AddRange(pars);
            SqlParameter par = new SqlParameter("@id",SqlDbType.Int);

            par.Direction = ParameterDirection.Output;
            comm.Parameters.Add(par);
            
            int x=comm.ExecuteNonQuery();
            this.id = Convert.ToInt16(par.Value);
            conn.Close();
            
        }
    }
}