(纯代码)基于C#-winform的书店采购管理系统的设计
Book.cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
namespace WindowsFormsApplication1
{
class Book
{
private string bookid;
public string Bookid
{
get { return bookid; }
set { bookid = value ; }
}
private string bookname;
public string Bookname
{
get { return bookname; }
set { bookname = value ; }
}
private string languages;
public string Languages
{
get { return languages; }
set { languages = value ; }
}
private string author;
public string Author
{
get { return author; }
set { author = value ; }
}
private string price;
public string Price
{
get { return price; }
set { price = value ; }
}
private string comment;
public string Comment
{
get { return comment; }
set { comment = value ; }
}
}
}
BookData.cs
using System;
using System. Collections. Generic;
using System. Data. SqlClient;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
namespace WindowsFormsApplication1
{
class BookData
{
private SqlConnection conn;
private SqlCommand cmd;
private SqlDataReader dr;
public BookData ( )
{
string connString = DBConnect. connstring;
conn = new SqlConnection ( connString) ; ;
cmd = conn. CreateCommand ( ) ;
}
public List< Book> Select ( )
{
List< Book> list = new List < Book > ( ) ;
cmd. CommandText = "select * from bookinfo" ;
conn. Open ( ) ;
dr = cmd. ExecuteReader ( ) ;
if ( dr. HasRows)
{
while ( dr. Read ( ) )
{
Book data = new Book ( ) ;
data. Bookid = dr[ 0 ] . ToString ( ) ;
data. Bookname= dr[ 1 ] . ToString ( ) ;
data. Languages = dr[ 2 ] . ToString ( ) ;
data. Author = dr[ 3 ] . ToString ( ) ;
data. Price = dr[ 4 ] . ToString ( ) ;
data. Comment = dr[ 5 ] . ToString ( ) ;
list. Add ( data) ;
}
}
conn. Close ( ) ;
return list;
}
public Book Select ( string bookid)
{
cmd. CommandText = "select * from bookinfo where bookid=@bookid" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@bookid" , bookid) ;
conn. Open ( ) ;
dr = cmd. ExecuteReader ( ) ;
Book data = new Book ( ) ;
if ( dr. HasRows)
{
dr. Read ( ) ;
data. Bookid = dr[ 0 ] . ToString ( ) ;
data. Bookname = dr[ 1 ] . ToString ( ) ;
data. Languages = dr[ 2 ] . ToString ( ) ;
data. Author = dr[ 3 ] . ToString ( ) ;
data. Price = dr[ 4 ] . ToString ( ) ;
data. Comment = dr[ 5 ] . ToString ( ) ;
}
conn. Close ( ) ;
return data;
}
public void Delete ( string bookname1)
{
cmd. CommandText = "delete from bookinfo where bookname=@book" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@book" , bookname1) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
public List< Book> Select ( string bookid, string bookname, string languages, string author, string comment)
{
string tj1 = " 1=1 " ;
string tj2 = " 1=1 " ;
string tj3 = " 1=1 " ;
string tj4 = " 1=1 " ;
string tj5 = " 1=1 " ;
if ( bookid != "" )
{
tj1 = " bookid like @bookid " ;
}
if ( bookname != "" )
{
tj2 = " bookname = @bookname " ;
}
if ( languages != "" )
{
tj3 = " languages = @languages " ;
}
if ( author != "" )
{
tj4 = " author = @author " ;
}
if ( comment != "" )
{
tj5 = " comment = @comment " ;
}
string tj = " where " + tj1 + " and " + tj2 + " and " + tj3 + " and " + tj4 + " and " + tj5;
List< Book> list = new List < Book > ( ) ;
cmd. CommandText = "select * from bookinfo" + tj;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@bookid" , "%" + bookid+ "%" ) ;
cmd. Parameters. AddWithValue ( "@bookname" , bookname) ;
cmd. Parameters. AddWithValue ( "@languages" , languages) ;
cmd. Parameters. AddWithValue ( "@author" , author) ;
cmd. Parameters. AddWithValue ( "@comment" , comment) ;
conn. Open ( ) ;
dr = cmd. ExecuteReader ( ) ;
if ( dr. HasRows)
{
while ( dr. Read ( ) )
{
Book data = new Book ( ) ;
data. Bookid = dr[ 0 ] . ToString ( ) ;
data. Bookname = dr[ 1 ] . ToString ( ) ;
data. Languages = dr[ 2 ] . ToString ( ) ;
data. Author = dr[ 3 ] . ToString ( ) ;
data. Price = dr[ 4 ] . ToString ( ) ;
data. Comment = dr[ 5 ] . ToString ( ) ;
list. Add ( data) ;
}
}
conn. Close ( ) ;
return list;
}
public void Update ( string bookid, string bookname, string languages, string author, string price, string comment)
{
cmd. CommandText = "update bookinfo set bookid=@bookid,bookname=@bookname,languages=@languages,author=@author,price=@price,comment=@comment where bookid = @bookid" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@bookid" , bookid) ;
cmd. Parameters. AddWithValue ( "@bookname" , bookname) ;
cmd. Parameters. AddWithValue ( "@languages" , languages) ;
cmd. Parameters. AddWithValue ( "@author" , author) ;
cmd. Parameters. AddWithValue ( "@price" , price) ;
cmd. Parameters. AddWithValue ( "@comment" , comment) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
public bool Add ( string bookid, string bookname, string languages, string author, string price, string comment)
{
cmd. CommandText = "insert into bookinfo values(@bookid,@bookname,@languages,@author,@price,@comment)" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@bookid" , bookid) ;
cmd. Parameters. AddWithValue ( "@bookname" , bookname) ;
cmd. Parameters. AddWithValue ( "@languages" , languages) ;
cmd. Parameters. AddWithValue ( "@author" , author) ;
cmd. Parameters. AddWithValue ( "@price" , price) ;
cmd. Parameters. AddWithValue ( "@comment" , comment) ;
conn. Open ( ) ;
int n = cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
if ( n > 0 )
{
return true ;
}
else
{
return false ;
}
}
}
}
DBConnect.cs
using System;
using System. Collections. Generic;
using System. Configuration;
using System. Data. SqlClient;
using System. Linq;
using System. Text;
namespace WindowsFormsApplication1
{
class DBConnect
{
public static string connstring = ConfigurationManager. ConnectionStrings[ "WindowsFormsApplication1.Properties.Settings.BOOKConnectionString1" ] . ToString ( ) ;
}
}
Loginid.cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
class Loginid
{
public static string loginid = "" ;
public static string role = "1" ;
}
}
vip.cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
namespace WindowsFormsApplication1
{
public class Vip
{
private string vip_id;
public string Vip_id
{
get { return vip_id; }
set { vip_id = value ; }
}
private string vip_name;
public string Vip_name
{
get { return vip_name; }
set { vip_name = value ; }
}
private string id_card;
public string Id_card
{
get { return id_card; }
set { id_card = value ; }
}
private string telephone;
public string Telephone
{
get { return telephone; }
set { telephone = value ; }
}
private string vip_role;
public string Vip_role
{
get { return vip_role; }
set { vip_role = value ; }
}
}
}
denglu.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Configuration;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class denglu : Form
{
public denglu ( )
{
InitializeComponent ( ) ;
}
private void denglu_Load ( object sender, EventArgs e)
{
}
private void linkLabel1_LinkClicked ( object sender, LinkLabelLinkClickedEventArgs e)
{
zhuce Z = new zhuce ( 1 ) ;
Z. Show ( ) ;
this . Hide ( ) ;
}
private void button1_Click ( object sender, EventArgs e)
{
string user_id, pass;
bool flag = false ;
string flag1 = "False" ;
user_id = textBox1. Text;
pass = textBox2. Text;
string connString = DBConnect. connstring;
SqlConnection con = new SqlConnection ( connString) ;
if ( textBox1. Text == "" )
MessageBox. Show ( "用户名不能为空!" , "提示" ) ;
else if ( textBox2. Text == "" )
MessageBox. Show ( "密码不能为空!" , "提示" ) ;
try
{
con. Open ( ) ;
string sqlstring = "select * from userinfo where user_id='" + user_id + "'and password='" + pass + "'" ;
SqlCommand command = new SqlCommand ( sqlstring, con) ;
SqlDataReader thisReader = command. ExecuteReader ( ) ;
while ( thisReader. Read ( ) )
{
if ( ( thisReader. GetValue ( 0 ) . ToString ( ) . Trim ( ) ) == ( user_id. ToString ( ) . Trim ( ) ) )
{
if ( thisReader. GetValue ( 1 ) . ToString ( ) . Trim ( ) == pass. ToString ( ) . Trim ( ) )
{
flag = true ;
Loginid. role = thisReader. GetValue ( 2 ) . ToString ( ) . Trim ( ) ;
}
}
}
con. Close ( ) ;
}
catch ( Exception ex2)
{
MessageBox. Show ( "连接远程SQL数据库发生错误:" + ex2. ToString ( ) , "错误!" ) ;
}
try
{
con. Open ( ) ;
string sqlstring1 = "select * from [user] where user_id='" + user_id + "'" ;
SqlCommand command1 = new SqlCommand ( sqlstring1, con) ;
SqlDataReader thisReader1 = command1. ExecuteReader ( ) ;
while ( thisReader1. Read ( ) )
{
flag1 = thisReader1[ 4 ] . ToString ( ) . Trim ( ) ;
}
con. Close ( ) ;
}
catch ( Exception ex2)
{
MessageBox. Show ( "连接远程SQL数据库发生错误:" + ex2. ToString ( ) , "错误!" ) ;
}
if ( flag && flag1 == "True" )
{
MessageBox. Show ( "登陆成功!" ) ;
Loginid. loginid = this . textBox1. Text;
mian C = new mian ( ) ;
C. Show ( ) ;
this . Hide ( ) ;
}
else if ( flag== false )
{
MessageBox. Show ( "请检查你的用户名和密码!" ) ;
textBox1. Focus ( ) ;
}
else if ( flag1== "False" )
{
MessageBox. Show ( "你的账号无效!" ) ;
textBox1. Focus ( ) ;
}
}
private void button2_Click ( object sender, EventArgs e)
{
System. Environment. Exit ( 0 ) ;
}
}
}
zhuce.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class zhuce : Form
{
private int bs;
public zhuce ( )
{
InitializeComponent ( ) ;
}
public zhuce ( int strtext)
{
InitializeComponent ( ) ;
bs = strtext;
}
public void c ( )
{
textBox1. Text = "" ;
textBox2. Text = "" ;
}
private void button1_Click ( object sender, EventArgs e)
{
if ( textBox1. Text == "" | textBox2. Text == "" )
{
MessageBox. Show ( "请输入完整信息" ) ;
return ;
}
string connString = DBConnect. connstring;
SqlConnection conn = new SqlConnection ( connString) ;
string sqlSelect = "select user_id from userinfo where user_id='" + textBox1. Text. Trim ( ) + "'" ;
SqlCommand cmd1 = new SqlCommand ( sqlSelect, conn) ;
conn. Open ( ) ;
object result1 = cmd1. ExecuteScalar ( ) ;
if ( result1 != null )
{
MessageBox. Show ( "该账户已被注册" ) ;
conn. Close ( ) ;
return ;
}
conn. Close ( ) ;
string sql = "insert into userinfo(user_id,password,role)" ;
sql + = "values('{0}','{1}','{2}')" ;
sql = string . Format ( sql, textBox1. Text, textBox2. Text, "1" ) ;
SqlCommand cmd = new SqlCommand ( sql, conn) ;
conn. Open ( ) ;
int reslt = cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
c ( ) ;
MessageBox. Show ( "注册成功" ) ;
if ( bs == 1 )
{
denglu D = new denglu ( ) ;
D. Show ( ) ;
this . Hide ( ) ;
}
}
private void button2_Click ( object sender, EventArgs e)
{
if ( bs == 1 )
{
denglu D = new denglu ( ) ;
D. Show ( ) ;
this . Hide ( ) ;
}
else
{
this . Hide ( ) ;
}
}
}
}
mian.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class mian : Form
{
public mian ( )
{
InitializeComponent ( ) ;
}
private void mian_Load ( object sender, EventArgs e)
{
label1. Text = "当前账号:" + Loginid. loginid;
}
private void toolStripButton1_Click ( object sender, EventArgs e)
{
mian1 Z1 = new mian1 ( ) ;
Z1. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton2_Click ( object sender, EventArgs e)
{
mian2_ Z2 = new mian2_ ( ) ;
Z2. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton3_Click ( object sender, EventArgs e)
{
mian3 Z3 = new mian3 ( ) ;
Z3. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton4_Click ( object sender, EventArgs e)
{
mian4 Z4 = new mian4 ( ) ;
Z4. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton5_Click ( object sender, EventArgs e)
{
mian5 Z5 = new mian5 ( ) ;
Z5. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton6_Click ( object sender, EventArgs e)
{
mian6 Z6 = new mian6 ( ) ;
Z6. Show ( ) ;
this . Hide ( ) ;
}
}
}
mian1.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class mian1 : Form
{
public mian1 ( )
{
InitializeComponent ( ) ;
}
private string Bookid = "" ;
private static mian1 xg = null ;
public mian1 ( string bookid)
{
InitializeComponent ( ) ;
this . Bookid = bookid;
}
private void toolStripButton1_Click ( object sender, EventArgs e)
{
mian1 Z1 = new mian1 ( ) ;
Z1. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton2_Click ( object sender, EventArgs e)
{
mian2_ Z2 = new mian2_ ( ) ;
Z2. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton3_Click ( object sender, EventArgs e)
{
mian3 Z3 = new mian3 ( ) ;
Z3. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton4_Click ( object sender, EventArgs e)
{
mian4 Z4 = new mian4 ( ) ;
Z4. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton5_Click ( object sender, EventArgs e)
{
mian5 Z5 = new mian5 ( ) ;
Z5. Show ( ) ;
this . Hide ( ) ;
}
private void toolStripButton6_Click ( object sender, EventArgs e)
{
mian6 Z6 = new mian6 ( ) ;
Z6. Show ( ) ;
this . Hide ( ) ;
}
private void mian1_Load ( object sender, EventArgs e)
{
}
public static mian1 NewXiuGai ( string bookid)
{
if ( xg == null || xg. IsDisposed)
{
xg = new mian1 ( bookid) ;
}
return xg;
}
private void button2_Click ( object sender, EventArgs e)
{
string bookid = textBox1. Text;
string bookname = textBox2. Text;
string languages = textBox3. Text;
string author = textBox4. Text;
string price = textBox5. Text;
string comment = textBox6. Text;
BookData ida = new BookData ( ) ;
ida. Update ( bookid, bookname, languages, author, price, comment) ;
mian3. bs = 1 ;
this . Close ( ) ;
}
private void button1_Click ( object sender, EventArgs e)
{
string bookid = textBox1. Text;
string bookname = textBox2. Text;
string languages = textBox3. Text;
string author = textBox4. Text;
string price = textBox5. Text;
string comment = textBox6. Text;
BookData ida = new BookData ( ) ;
ida. Add ( bookid, bookname, languages, author, price, comment) ;
mian3. bs = 1 ;
this . Close ( ) ;
}
}
}
mian2.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Text;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class mian2_ : WindowsFormsApplication1. mian
{
public mian2_ ( )
{
InitializeComponent ( ) ;
}
private void label1_Click ( object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick ( object sender, DataGridViewCellEventArgs e)
{
}
private void mian2__Load ( object sender, EventArgs e)
{
this . bookinfoTableAdapter1. Fill ( this . bOOKDataSet1. bookinfo) ;
}
private void label7_Click ( object sender, EventArgs e)
{
}
private void label10_Click ( object sender, EventArgs e)
{
}
private void textBox1_TextChanged ( object sender, EventArgs e)
{
}
private void button1_Click ( object sender, EventArgs e)
{
string bookid = textBox1. Text;
string bookname = textBox2. Text;
string languages = textBox3. Text;
string author = textBox4. Text;
string comment = textBox5. Text;
BookData da = new BookData ( ) ;
dataGridView1. DataSource = da. Select ( bookid, bookname, languages, author, comment) ;
dataGridView1. AutoGenerateColumns = false ;
}
public void c ( )
{
textBox1. Text = "" ;
textBox2. Text = "" ;
textBox3. Text = "" ;
textBox4. Text = "" ;
textBox5. Text = "" ;
}
private void button2_Click ( object sender, EventArgs e)
{
c ( ) ;
}
}
}
mian3.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Text;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class mian3 : WindowsFormsApplication1. mian
{
public static int bs = 0 ;
public mian3 ( )
{
InitializeComponent ( ) ;
}
private void mian3_Load ( object sender, EventArgs e)
{
this . bookinfoTableAdapter1. Fill ( this . bOOKDataSet1. bookinfo) ;
BookData da = new BookData ( ) ;
dataGridView1. DataSource = da. Select ( ) ;
dataGridView1. AutoGenerateColumns = false ;
dataGridView1. ClearSelection ( ) ;
}
private void button4_Click ( object sender, EventArgs e)
{
MessageBoxButtons btn = MessageBoxButtons. YesNoCancel;
if ( MessageBox. Show ( "确定要删除么?" , "删除数据" , btn) == DialogResult. Yes)
{
string bookname1 = textBox6. Text;
BookData da = new BookData ( ) ;
if ( textBox6. Text!= "" )
da. Delete ( bookname1) ;
else
{
try
{
Book data = dataGridView1. SelectedRows[ 0 ] . DataBoundItem as Book;
da. Delete ( data. Bookid) ;
}
catch ( Exception ex)
{
MessageBox. Show ( ex. Message. ToString ( ) ) ;
}
}
dataGridView1. DataSource = da. Select ( ) ;
}
}
private void button1_Click ( object sender, EventArgs e)
{
string bookid = textBox1. Text;
string bookname = textBox2. Text;
string languages = textBox3. Text;
string author = textBox4. Text;
string comment = textBox5. Text;
BookData da = new BookData ( ) ;
dataGridView1. DataSource = da. Select ( bookid, bookname, languages, author, comment) ;
dataGridView1. AutoGenerateColumns = false ;
}
public void c ( )
{
textBox1. Text = "" ;
textBox2. Text = "" ;
textBox3. Text = "" ;
textBox4. Text = "" ;
textBox5. Text = "" ;
}
private void button5_Click ( object sender, EventArgs e)
{
c ( ) ;
}
private void button2_Click ( object sender, EventArgs e)
{
mian1 tj = new mian1 ( ) ;
tj. Show ( ) ;
tj. Focus ( ) ;
}
private void button3_Click ( object sender, EventArgs e)
{
if ( dataGridView1. SelectedRows. Count > 0 )
{
Book data = dataGridView1. SelectedRows[ 0 ] . DataBoundItem as Book;
mian1 xg = mian1. NewXiuGai ( data. Bookid) ;
xg. Show ( ) ;
xg. Focus ( ) ;
}
else
{
MessageBox. Show ( "没有选中任何项!" ) ;
}
}
private void timer1_Tick ( object sender, EventArgs e)
{
if ( bs == 1 )
{
BookData da = new BookData ( ) ;
dataGridView1. DataSource = da. Select ( ) ;
bs = 0 ;
}
}
private void textBox6_TextChanged ( object sender, EventArgs e)
{
}
private void label8_Click ( object sender, EventArgs e)
{
}
}
}
mian4.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Text;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class mian4 : WindowsFormsApplication1. mian
{
public mian4 ( )
{
InitializeComponent ( ) ;
}
private void mian4_Load ( object sender, EventArgs e)
{
this . bookinfoTableAdapter1. Fill ( this . bOOKDataSet1. bookinfo) ;
this . payTableAdapter1. Fill ( this . bOOKDataSet1. pay) ;
}
private void button1_Click ( object sender, EventArgs e)
{
Form1 xs = new Form1 ( ) ;
xs. Show ( ) ;
xs. Focus ( ) ;
}
private void fillToolStripButton_Click ( object sender, EventArgs e)
{
}
private void button2_Click ( object sender, EventArgs e)
{
rj rj = new rj ( ) ;
rj. Show ( ) ;
rj. Focus ( ) ;
}
}
}
mian5.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Text;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class mian5 : WindowsFormsApplication1. mian
{
public mian5 ( )
{
InitializeComponent ( ) ;
}
private void mian5_Load ( object sender, EventArgs e)
{
this . bookinfoTableAdapter1. Fill ( this . bOOKDataSet1. bookinfo) ;
this . purchaseTableAdapter1. Fill ( this . bOOKDataSet1. purchase) ;
}
private void button1_Click ( object sender, EventArgs e)
{
Form2 cg = new Form2 ( ) ;
cg. Show ( ) ;
cg. Focus ( ) ;
}
}
}
mian6.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Text;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class mian6 : WindowsFormsApplication1. mian
{
public mian6 ( )
{
InitializeComponent ( ) ;
}
private void button1_Click ( object sender, EventArgs e)
{
Form3 gk = new Form3 ( ) ;
gk. Show ( ) ;
gk. Focus ( ) ;
}
private void button2_Click ( object sender, EventArgs e)
{
Form4 xg = new Form4 ( ) ;
xg. Show ( ) ;
xg. Focus ( ) ;
}
private void button3_Click ( object sender, EventArgs e)
{
if ( Loginid. role == "0" )
{
Form5 qx = new Form5 ( ) ;
qx. Show ( ) ;
qx. Focus ( ) ;
}
else
{
MessageBox. Show ( "当前账号无权限打开" ) ;
return ;
}
}
}
}
Form1.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1 ( )
{
InitializeComponent ( ) ;
}
private SqlConnection conn;
private SqlCommand cmd;
private void dateTimePicker1_ValueChanged ( object sender, EventArgs e)
{
}
public bool Add ( string paycode, string bookid, string bookname, string vip_id, DateTime pay_date, string price, string num, string id)
{
int n= 0 ;
try
{
string connString = DBConnect. connstring;
conn = new SqlConnection ( connString) ;
cmd = conn. CreateCommand ( ) ;
}
catch ( Exception ex2)
{
MessageBox. Show ( "连接远程SQL数据库发生错误:" + ex2. ToString ( ) , "错误!" ) ;
}
try
{
cmd. CommandText = "insert into pay values(@paycode,@bookid,@bookname,@vip_id,@pay_date,@price,@num,@id)" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@paycode" , paycode) ;
cmd. Parameters. AddWithValue ( "@bookid" , bookid) ;
cmd. Parameters. AddWithValue ( "@bookname" , bookname) ;
cmd. Parameters. AddWithValue ( "@vip_id" , vip_id) ;
cmd. Parameters. AddWithValue ( "@pay_date" , pay_date) ;
cmd. Parameters. AddWithValue ( "@price" , price) ;
cmd. Parameters. AddWithValue ( "@num" , num) ;
cmd. Parameters. AddWithValue ( "@id" , id) ;
conn. Open ( ) ;
n = cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
catch ( Exception ex2)
{
MessageBox. Show ( "销售单添加发生错误:" + ex2. ToString ( ) , "错误!" ) ;
}
if ( n > 0 )
{
return true ;
}
else
{
return false ;
}
}
private void button1_Click ( object sender, EventArgs e)
{
string paycode = textBox1. Text;
string bookid = textBox2. Text;
string bookname = textBox3. Text;
string vip_id = textBox4. Text;
DateTime pay_date = Convert. ToDateTime ( dateTimePicker1. Text) ;
string price = textBox5. Text;
string num = textBox6. Text;
string id = textBox7. Text;
Add ( paycode, bookid, bookname, vip_id, pay_date, price, num, id) ;
this . Close ( ) ;
}
}
}
Form2.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class Form2 : Form
{
public Form2 ( )
{
InitializeComponent ( ) ;
}
private SqlConnection conn;
private SqlCommand cmd;
public bool Add ( string purchase_id, string bookid, string bookname, string number, string id, string id_end)
{
int n = 0 ;
try
{
string connString = DBConnect. connstring;
conn = new SqlConnection ( connString) ;
cmd = conn. CreateCommand ( ) ;
}
catch ( Exception ex2)
{
MessageBox. Show ( "连接远程SQL数据库发生错误:" + ex2. ToString ( ) , "错误!" ) ;
}
try
{
cmd. CommandText = "insert into purchase values(@purchase_id,@bookid,@bookname,@number,@id,@id_end)" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@purchase_id" , purchase_id) ;
cmd. Parameters. AddWithValue ( "@bookid" , bookid) ;
cmd. Parameters. AddWithValue ( "@bookname" , bookname) ;
cmd. Parameters. AddWithValue ( "@number" , number) ;
cmd. Parameters. AddWithValue ( "@id" , id) ;
cmd. Parameters. AddWithValue ( "@id_end" , id_end) ;
conn. Open ( ) ;
n = cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
catch ( Exception ex2)
{
MessageBox. Show ( "采购单添加发生错误:" + ex2. ToString ( ) , "错误!" ) ;
}
if ( n > 0 )
{
return true ;
}
else
{
return false ;
}
}
private void button1_Click ( object sender, EventArgs e)
{
string purchase_id = textBox1. Text;
string bookid = textBox2. Text;
string bookname = textBox3. Text;
string number = textBox4. Text;
string id = textBox5. Text;
string id_end = textBox6. Text;
Add ( purchase_id, bookid, bookname, number, id, id_end) ;
this . Close ( ) ;
}
}
}
Form3.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class Form3 : Form
{
private SqlConnection conn;
private SqlCommand cmd;
private SqlDataReader dr;
public Form3 ( )
{
InitializeComponent ( ) ;
string connString = DBConnect. connstring;
conn = new SqlConnection ( connString) ;
cmd = conn. CreateCommand ( ) ;
}
private void Form3_Load ( object sender, EventArgs e)
{
this . vipTableAdapter1. Fill ( this . bOOKDataSet1. vip) ;
}
public void Delete ( string vip_id)
{
cmd. CommandText = "delete from vip where vip_id=@vip_id" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@vip_id" , vip_id) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
public List< Vip> Select ( string vip_id, string vip_name, string id_card, string telephone, string vip_role)
{
string tj1 = " 1=1 " ;
string tj2 = " 1=1 " ;
string tj3 = " 1=1 " ;
string tj4 = " 1=1 " ;
string tj5 = " 1=1 " ;
if ( vip_id != "" )
{
tj1 = " vip_id like @vip_id " ;
}
if ( vip_name != "" )
{
tj2 = " vip_name = @vip_name " ;
}
if ( id_card != "" )
{
tj3 = " id_card = @id_card " ;
}
if ( telephone != "" )
{
tj4 = " telephone = @telephone " ;
}
if ( vip_role != "" )
{
tj5 = " vip_role = @vip_role " ;
}
string tj = " where " + tj1 + " and " + tj2 + " and " + tj3 + " and " + tj4 + " and " + tj5;
List< Vip> list = new List < Vip > ( ) ;
cmd. CommandText = "select * from vip" + tj;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@vip_id" , "%" + vip_id + "%" ) ;
cmd. Parameters. AddWithValue ( "@vip_name" , vip_name) ;
cmd. Parameters. AddWithValue ( "@id_card" , id_card) ;
cmd. Parameters. AddWithValue ( "@telephone" , telephone) ;
cmd. Parameters. AddWithValue ( "@vip_role" , vip_role) ;
conn. Open ( ) ;
dr = cmd. ExecuteReader ( ) ;
if ( dr. HasRows)
{
while ( dr. Read ( ) )
{
Vip data = new Vip ( ) ;
data. Vip_id = dr[ 0 ] . ToString ( ) ;
data. Vip_name = dr[ 1 ] . ToString ( ) ;
data. Id_card = dr[ 2 ] . ToString ( ) ;
data. Telephone = dr[ 3 ] . ToString ( ) ;
data. Vip_role = dr[ 4 ] . ToString ( ) ;
list. Add ( data) ;
}
}
conn. Close ( ) ;
return list;
}
public void Update ( string vip_id, string vip_name, string id_card, string telephone, string vip_role)
{
cmd. CommandText = "update vip set vip_id=@vip_id,vip_name=@vip_name, id_card=@id_card,telephone=@telephone,vip_role=@vip_role where vip_id = @vip_id" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@vip_id" , vip_id) ;
cmd. Parameters. AddWithValue ( "@vip_name" , vip_name) ;
cmd. Parameters. AddWithValue ( "@id_card" , id_card) ;
cmd. Parameters. AddWithValue ( "@telephone" , telephone) ;
cmd. Parameters. AddWithValue ( "@vip_role" , vip_role) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
public bool Add ( string vip_id, string vip_name, string id_card, string telephone, string vip_role)
{
cmd. CommandText = "insert into vip values(@vip_id,@vip_name,@id_card,@telephone,@vip_role)" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@vip_id" , vip_id) ;
cmd. Parameters. AddWithValue ( "@vip_name" , vip_name) ;
cmd. Parameters. AddWithValue ( "@id_card" , id_card) ;
cmd. Parameters. AddWithValue ( "@telephone" , telephone) ;
cmd. Parameters. AddWithValue ( "@vip_role" , vip_role) ;
conn. Open ( ) ;
int n = cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
if ( n > 0 )
{
return true ;
}
else
{
return false ;
}
}
private void button1_Click ( object sender, EventArgs e)
{
string vip_id = textBox1. Text;
string vip_name = textBox2. Text;
string id_card = textBox3. Text;
string telephone = textBox4. Text;
string vip_role = textBox5. Text;
dataGridView1. DataSource = Select ( vip_id, vip_name, id_card, telephone, vip_role) ;
dataGridView1. AutoGenerateColumns = false ;
}
private void button2_Click ( object sender, EventArgs e)
{
string vip_id = textBox1. Text;
string vip_name = textBox2. Text;
string id_card = textBox3. Text;
string telephone = textBox4. Text;
string vip_role = textBox5. Text;
Add ( vip_id, vip_name, id_card, telephone, vip_role) ;
}
private void button3_Click ( object sender, EventArgs e)
{
string vip_id = textBox1. Text;
string vip_name = textBox2. Text;
string id_card = textBox3. Text;
string telephone = textBox4. Text;
string vip_role = textBox5. Text;
Update ( vip_id, vip_name, id_card, telephone, vip_role) ;
}
private void button4_Click ( object sender, EventArgs e)
{
string vip_id = textBox1. Text;
Delete ( vip_id) ;
}
public void c ( )
{
textBox1. Text = "" ;
textBox2. Text = "" ;
textBox3. Text = "" ;
textBox4. Text = "" ;
textBox5. Text = "" ;
}
private void button5_Click ( object sender, EventArgs e)
{
c ( ) ;
}
}
}
Form4.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class Form4 : Form
{
private SqlConnection conn;
private SqlCommand cmd;
public Form4 ( )
{
InitializeComponent ( ) ;
string connString = DBConnect. connstring;
conn = new SqlConnection ( connString) ; ;
cmd = conn. CreateCommand ( ) ;
}
private void label1_Click ( object sender, EventArgs e)
{
}
public void c ( )
{
textBox1. Text = "" ;
textBox2. Text = "" ;
}
private void Form4_Load ( object sender, EventArgs e)
{
label1. Text = "当前账号:" + Loginid. loginid;
}
private void button1_Click ( object sender, EventArgs e)
{
string password1 = textBox1. Text;
string password2 = textBox2. Text;
string user_id = Loginid. loginid;
if ( textBox1. Text == "" | textBox2. Text == "" )
{
MessageBox. Show ( "请输入完整信息" ) ;
return ;
}
if ( textBox1. Text == textBox2. Text)
{
cmd. CommandText = "update userinfo set password=@password where user_id = @user_id" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@user_id" , user_id) ;
cmd. Parameters. AddWithValue ( "@password" , password1) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
MessageBox. Show ( "修改成功" ) ;
return ;
}
else
{
MessageBox. Show ( "密码不一致" ) ;
return ;
}
}
}
}
Form5.cs
using System;
using System. Collections. Generic;
using System. ComponentModel;
using System. Data;
using System. Data. SqlClient;
using System. Drawing;
using System. Linq;
using System. Text;
using System. Threading. Tasks;
using System. Windows. Forms;
namespace WindowsFormsApplication1
{
public partial class Form5 : Form
{
private SqlConnection conn;
private SqlCommand cmd;
private SqlDataReader dr;
private string password = "" ;
private string role = "" ;
private string status = "" ;
private int bs = 0 ;
public Form5 ( )
{
InitializeComponent ( ) ;
string connString = DBConnect. connstring;
conn = new SqlConnection ( connString) ;
cmd = conn. CreateCommand ( ) ;
}
private void Form5_Load ( object sender, EventArgs e)
{
this . userTableAdapter. Fill ( this . bOOKDataSet1. user) ;
groupBox1. Text = "当前账号:" + Loginid. loginid ;
}
public void Delete ( string id)
{
cmd. CommandText = "delete from [user] where id=@id" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@id" , id) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
public void Update ( string id, string name, string user_id, string password, string status)
{
cmd. CommandText = "update [user] set id=@id,name=@name,user_id=@user_id,password=@password,status=@status where id = @id" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@id" , id) ;
cmd. Parameters. AddWithValue ( "@name" , name) ;
cmd. Parameters. AddWithValue ( "@user_id" , user_id) ;
cmd. Parameters. AddWithValue ( "@password" , password) ;
cmd. Parameters. AddWithValue ( "@status" , status) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
public bool Add ( string id, string name, string user_id, string password, string status)
{
cmd. CommandText = "insert into [user] values(@id,@name,@user_id,@password,@status)" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@id" , id) ;
cmd. Parameters. AddWithValue ( "@name" , name) ;
cmd. Parameters. AddWithValue ( "@user_id" , user_id) ;
cmd. Parameters. AddWithValue ( "@password" , password) ;
cmd. Parameters. AddWithValue ( "@status" , status) ;
conn. Open ( ) ;
int n = cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
if ( n > 0 )
{
return true ;
}
else
{
return false ;
}
}
private void groupBox1_Enter ( object sender, EventArgs e)
{
}
private void button3_Click ( object sender, EventArgs e)
{
if ( Loginid. role== "0" )
{
user B = new user ( ) ;
B. Show ( ) ;
B. Focus ( ) ;
}
else
{
MessageBox. Show ( "当前账号不是最高权限" ) ;
return ;
}
}
private void linkLabel1_LinkClicked ( object sender, LinkLabelLinkClickedEventArgs e)
{
zhuce Z = new zhuce ( 2 ) ;
Z. Show ( ) ;
Z. Focus ( ) ;
}
private void button1_Click ( object sender, EventArgs e)
{
string user_id = comboBox1. Text. Trim ( ) ;
string id = textBox1. Text;
string name = textBox2. Text;
status = ( radioButton1. Checked == true ? "1" : "0" ) ;
if ( textBox1. Text == "" )
MessageBox. Show ( "用户名不能为空!" , "提示" ) ;
else if ( textBox2. Text == "" )
MessageBox. Show ( "密码不能为空!" , "提示" ) ;
cmd. CommandText = "select * from userinfo where user_id='" + user_id + "'" ;
cmd. Parameters. Clear ( ) ;
conn. Open ( ) ;
dr = cmd. ExecuteReader ( ) ;
while ( dr. Read ( ) )
{
password = dr[ 1 ] . ToString ( ) . Trim ( ) ;
}
conn. Close ( ) ;
cmd. CommandText = "select id from [user] where user_id='" + user_id + "'" ;
cmd. Parameters. Clear ( ) ;
conn. Open ( ) ;
object result1 = cmd. ExecuteScalar ( ) ;
if ( result1 != null )
bs = 0 ;
else
bs = 1 ;
conn. Close ( ) ;
if ( bs== 1 )
Add ( id, name, user_id, password, status) ;
else
Update ( id, name, user_id, password, status) ;
}
private void button2_Click ( object sender, EventArgs e)
{
string id = textBox1. Text;
Delete ( id) ;
}
private void comboBox1_SelectedIndexChanged ( object sender, EventArgs e)
{
string user_id = comboBox1. Text. Trim ( ) ;
cmd. CommandText = "select * from userinfo where user_id='" + user_id + "'" ;
cmd. Parameters. Clear ( ) ;
conn. Open ( ) ;
dr = cmd. ExecuteReader ( ) ;
while ( dr. Read ( ) )
{
role = dr[ 2 ] . ToString ( ) . Trim ( ) ;
}
conn. Close ( ) ;
if ( role== "0" )
checkBox1. Checked = true ;
else if ( role== "1" )
{
checkBox1. Checked = false ;
}
cmd. CommandText = "select * from [user] where user_id='" + user_id + "'" ;
cmd. Parameters. Clear ( ) ;
conn. Open ( ) ;
dr = cmd. ExecuteReader ( ) ;
while ( dr. Read ( ) )
{
status = dr[ 4 ] . ToString ( ) . Trim ( ) ;
}
conn. Close ( ) ;
if ( status == "True" )
radioButton1. Checked = true ;
else if ( status == "False" )
{
radioButton1. Checked = false ;
radioButton2. Checked = true ;
}
}
private void checkBox1_CheckedChanged ( object sender, EventArgs e)
{
string user_id = comboBox1. Text. Trim ( ) ;
role = ( checkBox1. Checked == true ? "0" : "1" ) ;
cmd. CommandText = "update userinfo set role=@role where user_id='" + user_id + "'" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@role" , role) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
private void radioButton1_CheckedChanged ( object sender, EventArgs e)
{
string user_id = comboBox1. Text. Trim ( ) ;
if ( bs== 0 )
{
role = ( radioButton1. Checked == true ? "True" : "False" ) ;
cmd. CommandText = "update [user] set status=@status where user_id='" + user_id + "'" ;
cmd. Parameters. Clear ( ) ;
cmd. Parameters. AddWithValue ( "@status" , status) ;
conn. Open ( ) ;
cmd. ExecuteNonQuery ( ) ;
conn. Close ( ) ;
}
}
}
}
user.cs
rj.cs
数据库表创建语句:
CREATE TABLE [ dbo] . [ bookinfo] (
[ bookid] [ nchar ] ( 10 ) NOT NULL ,
[ bookname] [ nvarchar] ( 50 ) NULL ,
[ languages] [ nchar ] ( 10 ) NULL ,
[ author] [ nchar ] ( 10 ) NULL ,
[ price] [ nchar ] ( 10 ) NULL ,
[ comment ] [ int ] NULL
) ON [ PRIMARY ]
GO
CREATE TABLE [ dbo] . [ pay] (
[ paycode] [ nchar ] ( 10 ) NOT NULL ,
[ bookid] [ nchar ] ( 10 ) NOT NULL ,
[ bookname] [ nvarchar] ( 50 ) NOT NULL ,
[ vip_id] [ nchar ] ( 10 ) NOT NULL ,
[ pay_date] [ datetime ] NOT NULL ,
[ price] [ nchar ] ( 10 ) NOT NULL ,
[ num] [ int ] NOT NULL ,
[ id] [ nchar ] ( 10 ) NOT NULL
) ON [ PRIMARY ]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE trigger Tri3 on [ dbo] . [ pay]
for insert
as
begin
declare @c char ( 10 ) , @d int
select @c = bookid from inserted
select @d = num from inserted
update bookinfo
set comment = comment - @d
where bookid= @c
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE trigger [ dbo] . [ Tri4] on [ dbo] . [ pay]
for update
as
begin
declare @c1 char ( 10 ) , @c2 char ( 10 ) , @d1 int , @d2 int
select @c1 = bookid from deleted
select @c2 = bookid from inserted
select @d1 = num from deleted
select @d2 = num from inserted
if ( @c1 = @c2 )
update bookinfo
set comment = comment - ( @d2 - @d1 )
where bookid= @c1
else
update bookinfo
set comment = comment + @d1
where bookid= @c1
update bookinfo
set comment = comment - @d2
where bookid= @c2
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE TABLE [ dbo] . [ purchase] (
[ purchase_id] [ nchar ] ( 10 ) NOT NULL ,
[ bookid] [ nchar ] ( 10 ) NOT NULL ,
[ bookname] [ nvarchar] ( 50 ) NOT NULL ,
[ number] [ int ] NOT NULL ,
[ id] [ nchar ] ( 10 ) NOT NULL ,
[ id_end] [ nchar ] ( 10 ) NULL
) ON [ PRIMARY ]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE trigger Tri1 on [ dbo] . [ purchase]
for insert
as
begin
declare @a char ( 10 ) , @b int
select @a = bookid from inserted
select @b = number from inserted
update bookinfo
set comment = comment + @b
where bookid= @a
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE trigger [ dbo] . [ Tri2] on [ dbo] . [ purchase]
for update
as
begin
declare @a1 char ( 10 ) , @a2 char ( 10 ) , @b1 int , @b2 int
select @a1 = bookid from deleted
select @a2 = bookid from inserted
select @b1 = number from deleted
select @b2 = number from inserted
if ( @a1 = @a2 )
update bookinfo
set comment = comment + ( @b2 - @b1 )
where bookid= @a1
else
update bookinfo
set comment = comment - @b1
where bookid= @a1
update bookinfo
set comment = comment + @b2
where bookid= @a2
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE TABLE [ dbo] . [ user ] (
[ id] [ nchar ] ( 10 ) NOT NULL ,
[ name] [ nchar ] ( 10 ) NULL ,
[ user_id] [ nchar ] ( 10 ) NOT NULL ,
[ password] [ nchar ] ( 10 ) NULL ,
[ status ] [ bit ] NOT NULL
) ON [ PRIMARY ]
GO
CREATE TABLE [ dbo] . [ userinfo] (
[ user_id] [ nchar ] ( 10 ) NOT NULL ,
[ password] [ nchar ] ( 10 ) NULL ,
[ role] [ int ] NOT NULL
) ON [ PRIMARY ]
GO
CREATE TABLE [ dbo] . [ vip] (
[ vip_id] [ nchar ] ( 10 ) NOT NULL ,
[ vip_name] [ varchar ] ( 50 ) NULL ,
[ id_card] [ varchar ] ( 50 ) NULL ,
[ telephone] [ varchar ] ( 50 ) NULL ,
[ vip_role] [ int ] NULL
) ON [ PRIMARY ]
GO