public MySqlDataReader list_note_favourite() { string sql = "SELECT * FROM `note` WHERE `note_favourite`='1' AND `note_has_delete`='0';"; MysqlBase mysqlbase = new MysqlBase(); MySqlDataReader reader = mysqlbase.query(sql); return(reader); }
public MySqlDataReader list_note_label(int lable_no) { string sql = "SELECT * FROM label a JOIN nl b JOIN note c WHERE `note_has_delete`='0' AND a.label_no =b.label_no AND c.note_no=b.note_no AND b.label_no='" + lable_no + "';"; MysqlBase mysqlbase = new MysqlBase(); MySqlDataReader reader = mysqlbase.query(sql); return(reader); }
public MySqlDataReader list_note_notenook(int notebook_no) { string sql = "SELECT * FROM `note` WHERE `note_has_delete`='0' AND `notebook_no` = " + notebook_no + ";"; MysqlBase mysqlbase = new MysqlBase(); MySqlDataReader reader = mysqlbase.query(sql); return(reader); }
//查询笔记本 public MySqlDataReader list_notebook() { string sql = "SELECT * FROM `notebook`;"; MysqlBase mysqlbase = new MysqlBase(); MySqlDataReader reader = mysqlbase.query(sql); return(reader); }
//获得默认笔记本 public int getDefault() { string sql = "SELECT `notebook_no` FROM `notebook` WHERE `notebook_default`='1'"; MysqlBase mysqlbase = new MysqlBase(); MySqlDataReader reader = mysqlbase.query(sql); reader.Read(); if (reader.HasRows) { return(reader.GetInt32("notebook_no")); } else { return(0); } }