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