public TkxxDAL() { SqlServerHelper Sql = new SqlServerHelper(); if (!Sql.CheckTableExists("tkxx")) { string sql = "create table tkxx(" + "id int identity(1,1) not null primary key," + "mc nvarchar(500) not null," + "jg nvarchar(500) not null," + "fs int not null" + ")"; Sql.ExecuteSql(sql); } }
public SjxxDAL() { SqlServerHelper Sql = new SqlServerHelper(); if (!Sql.CheckTableExists("sjxx")) { string sql = "create table sjxx(" + "id int identity(1,1) not null primary key," + "mc nvarchar(50) not null," + "lb nvarchar(50) not null," + "sm nvarchar(50) null," + "url nvarchar(500) null" + ")"; Sql.ExecuteSql(sql); } }
public LoginDAL() { SqlServerHelper Sql = new SqlServerHelper(); if (!Sql.CheckTableExists("yhxx")) { string sql = "create table yhxx(" + "yhzh nvarchar(20) not null primary key," + "yhxm nvarchar(20) not null," + "yhmm nvarchar(50) not null," + "yhjs nvarchar(50) default '普通管理员' not null" + ")"; Sql.ExecuteSql(sql); sql = "insert into yhxx(yhzh,yhxm,yhmm,yhjs) values('admin','admin','admin','系统管理员')"; Sql.ExecuteSql(sql); } }