//新建笔记
public void newnote(string notename, DateTime createtime, DateTime modifytime, int hasdelete, int notebook, string text, string content, int favourite)
{
string sql = "INSERT INTO `note` (`note_name`,`note_create_time`, `note_modify_time`, `note_has_delete`, `notebook_no`, `note_text`, `note_content`, `note_favourite`) VALUES ('" + notename + "','" + createtime + "','" + modifytime + "','" + hasdelete + "','" + notebook + "','" + text + "','" + content + "','" + favourite + "');";
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
}
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_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_notebook()
{
string sql = "SELECT * FROM `notebook`;";
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 void setDefault(int notebook_no)
{
string sql = "UPDATE `notebook` SET `notebook_default`='0' WHERE `notebook_default`='1';";
string sql1 = "UPDATE `notebook` SET `notebook_default`='1' WHERE `notebook_no`=" + notebook_no + ";";
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
mysqlbase.execute(sql1);
}
//重命名
public void renameNotebook(int notebook_no, string new_notebook_name)
{
string sql = "UPDATE `notebook` SET `notebook_name`='" + new_notebook_name + "' WHERE (`notebook_no`='" + notebook_no + "');";
Console.WriteLine(sql);
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
}
//新建笔记本
public void create_notebook(string notebook_name)
{
//构建创建笔记本的sql语句
string sql = "INSERT INTO `notebook` (`notebook_name`, `notebook_default`) VALUES ('" + notebook_name + "','0')";
//实例化一个mysql连接基本对象,然后执行
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
}
//删除笔记本
public void delete_notebook(int notebook_no)
{
string sql = "DELETE FROM `notebook` WHERE (`notebook_no`='" + notebook_no + "');";
string sql1 = "DELETE FROM `note` WHERE (`notebook_no`='" + notebook_no + "')";
//实例化一个mysql连接基本对象,然后执行
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
mysqlbase.execute(sql1);
}
//获得默认笔记本
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);
}
}
