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