public bool setKeyIsIdentity(string listname)
{
string sql = "";
sql = "ALTER TABLE " + listname + " ADD ID int IDENTITY(1, 1)";
try
{
DBHelperSQL.ExecuteNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public bool createTalbe(string tablename)
{
//添加表语句
string add_table = "create table [" + tablename + "] (ID varchar(50) not null primary key, modifycontent varchar(400), username varchar(50), LSH varchar(50), modifytime datetime)";
try
{
DBHelperSQL.ExecuteNonQuery(add_table);
return(true);
}
catch
{
return(false);
}
}
public bool addkeyVacharMaxInList(string listname, string keyname)
{
string sql = "";
sql = "ALTER table [" + listname + "] ADD " + keyname + " varchar(MAX) null";
try
{
DBHelperSQL.ExecuteNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public bool addDateTimekeyInList(string listname, string keyname)
{
string sql = "";
sql = "ALTER table [" + listname + "] ADD " + keyname + " DATETIME null";
try
{
DBHelperSQL.ExecuteNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public bool createTalbe(string tablename, string addKeyString)
{
//添加表语句
string add_table = "create table [" + tablename + "] (" + addKeyString + ")";
try
{
DBHelperSQL.ExecuteNonQuery(add_table);
return(true);
}
catch (Exception er)
{
ini.INIIO.saveLogInf("数据库语句异常:" + er.Message);
return(false);
}
}
