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