public static DataTable relation_table()
{
string sql = "SELECT ID,table_name,table_show_name FROM table_relation";
DataTable dt = new DataTable();
dt = Db_connect.getdata(sql);
return(dt);
}
public static DataTable show_table(string table_name)
{
string sql = "SELECT * FROM " + table_name;
DataTable dt = new DataTable();
dt = Db_connect.getdata(sql);
return(dt);
}
public static List <string> show_table_name()
{
List <string> list = new List <string>();
string sql = "SELECT ID,table_name,table_show_name FROM table_relation";
DataTable dt = new DataTable();
dt = Db_connect.getdata(sql);
foreach (DataRow row in dt.Rows)
{
list.Add(row[2].ToString());
}
return(list);
}
public static string get_table_name(string show_name)
{
string sql = "SELECT table_name FROM table_relation where table_show_name = '" + show_name + "'";
string table_name = "";
DataTable dt = new DataTable();
dt = Db_connect.getdata(sql);
if (dt.Rows.Count != 1)
{
throw new MyException("存在多条重复数据");
}
else
{
table_name = dt.Rows[0][0].ToString();
}
return(table_name);
}
public static void delrelation(int ID)
{
//对数据库进添加一个用户操作
string sql = "DELETE FROM table_relation WHERE ID = @ID";
OleDbParameter[] para =
{
new OleDbParameter("@ID", OleDbType.Integer),
/*
* 我不知道这样写有什么区别，除了更简单还有什么好处
* new OleDbParameter("@age",age)
*/
};
para[0].Value = ID;
Db_connect.runsql(sql, para);
}
public static void insertrelation(string table, string show_name)
{
//对数据库进添加一个用户操作
string sql = "insert into table_relation(table_name,table_show_name)values(@table_name,@table_show_name)";
OleDbParameter[] para =
{
new OleDbParameter("@table_name", OleDbType.VarChar),
new OleDbParameter("@table_show_name", OleDbType.VarChar),
/*
* 我不知道这样写有什么区别，除了更简单还有什么好处
* new OleDbParameter("@age",age)
*/
};
para[0].Value = table;
para[1].Value = show_name;
Db_connect.runsql(sql, para);
}
public static void updaterelation(int ID, string table, string show_name)
{
//对数据库进添加一个用户操作
string sql = "UPDATE table_relation SET table_name = @table_name,table_show_name=@table_show_name WHERE ID = @ID";
OleDbParameter[] para =
{
new OleDbParameter("@table_name", OleDbType.VarChar),
new OleDbParameter("@table_show_name", OleDbType.VarChar),
new OleDbParameter("@ID", OleDbType.Integer),
/*
* 我不知道这样写有什么区别，除了更简单还有什么好处
* new OleDbParameter("@age",age)
*/
};
para[0].Value = table;
para[1].Value = show_name;
para[2].Value = ID;
Db_connect.runsql(sql, para);
}
public static bool have_relation(string table)
{
string sql_search = "SELECT ID,table_name,table_show_name FROM table_relation WHERE table_name ='" + table + "'";
return(Db_connect.have_line(sql_search));
}
