//新建笔记 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); } }