27,579
社区成员
发帖
与我相关
我的任务
分享
create proc Addhy
@xh char(15),
@xm varchar(50),
@sex char(5),
@xb varchar(50),
@bj varchar(30),
@sush char(10),
@lxfs varchar(15),
@bm varchar(50),
@zhw varchar(50),
@hf nvarchar(50),
@shj smalldatetime,
@shm nvarchar(200)
as
insert 会员表
values(@xh,@xm ,@sex,@xb,@bj,@sush,@lxfs,@bm,@zhw,@hf,@shj ,@shm)
go
Addhy 20072133524,小猪,男,文新系,null,null,null,组织部,null,null,null,null
private void button1_Click(object sender, EventArgs e)
{
User user = new User();
string num = textBox2.Text.Trim();
string name = textBox1.Text.Trim();
string sex = comboBox1.Text.Trim();
string xb = comboBox3.Text.Trim();
string bj = textBox4.Text.Trim();
string sush = textBox6.Text.Trim();
string dh = textBox5 .Text.Trim ();
string bm = comboBox2.Text.Trim();
string zhw = textBox3.Text.Trim();
string hf = comboBox4.Text.Trim();
string shj = comboBox5.Text.Trim();
string shm = textBox7.Text.Trim();
user.AddUser(num, name , sex, xb,bj ,sush ,dh ,bm,zhw,hf,shj ,shm );
}
public void AddUser(string addnum,string addname ,string addsex,string addxb,string addbj ,string addsush ,string adddh ,string addbm,string addzhw,string addhf,string addshj ,string addshm )
{
SqlParameter apxh = new SqlParameter("@xh", SqlDbType.Char, 15);
apxh.Value = addnum;
SqlParameter apxm = new SqlParameter("@xm", SqlDbType.Char, 8);
apxm.Value = addname;
SqlParameter apsex = new SqlParameter("@sex", SqlDbType.Char, 2);
apsex.Value = addsex;
SqlParameter apxb = new SqlParameter("@xb", SqlDbType.Char, 2);
apxb.Value = addxb;
SqlParameter apbj = new SqlParameter("@bj", SqlDbType.Char, 2);
apbj.Value = addbj;
SqlParameter apsush = new SqlParameter("@sush", SqlDbType.Char, 2);
apsush.Value = addsush;
SqlParameter apdh = new SqlParameter("@lxfs", SqlDbType.VarChar, 15);
apdh.Value = adddh;
SqlParameter apbm = new SqlParameter("@bm", SqlDbType.Char, 15);
apbm.Value = addbm;
SqlParameter apzhw = new SqlParameter("@zhw", SqlDbType.VarChar, 15);
apzhw.Value = addzhw;
SqlParameter aphf = new SqlParameter("@hf", SqlDbType.VarChar, 15);
aphf.Value = addhf;
SqlParameter apshj = new SqlParameter("@shj", SqlDbType.VarChar, 30);
apshj.Value = addshj;
SqlParameter apshm = new SqlParameter("@shm", SqlDbType.VarChar, 50);
apshm.Value = addshm;
SqlParameter[] addparms = { apxh, apxm, apsex, apxb, apbj, apsush, apdh, apbm, apzhw, aphf, apshj, apshm };
string sp = "Addhy";
AccessDatabase.ExecuteNonQuery(AccessDatabase.ConnectionString, CommandType.StoredProcedure, sp, addparms);
}
CREATE TABLE [dbo].[会员表](
[学号] [char](15) NOT NULL,
[姓名] [varchar](50) NULL,
[性别] [char](5) NULL,
[系别] [varchar](50) NULL,
[班级] [varchar](30) NULL,
[宿舍] [char](10) NULL,
[联系方式] [varchar](15) NULL,
[部门名称] [varchar](50) NULL,
[职位] [varchar](50) NULL,
[会费] [nvarchar](50) NULL,
[加入时间] [smalldatetime] NULL,
[说明] [nvarchar](200) NULL,
CONSTRAINT [PK__会员表__7E6CC920] PRIMARY KEY CLUSTERED
(
[学号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[会员表] WITH CHECK ADD CONSTRAINT [FK_会员表_部门表] FOREIGN KEY([部门名称])
REFERENCES [dbo].[部门表] ([部门名称])
GO
ALTER TABLE [dbo].[会员表] CHECK CONSTRAINT [FK_会员表_部门表]
GO
ALTER TABLE [dbo].[会员表] WITH CHECK ADD CONSTRAINT [FK_会员表_系别表] FOREIGN KEY([系别])
REFERENCES [dbo].[系别表] ([系别])
GO
ALTER TABLE [dbo].[会员表] CHECK CONSTRAINT [FK_会员表_系别表]