/// <summary> /// 添加一个群,个人分组也是 /// </summary> /// <param name="group">群资料</param> /// <returns>成功?</returns> public bool addGroup(Group group) { string cmdString = "INSERT INTO " + DBcolumns.TABLE_GROUP + "("+ DBcolumns.GROUP_NAME+","+ DBcolumns.GROUP_NUM + ","+ DBcolumns.GROUP_TIME+","+ DBcolumns.GROUP_NOTICE+","+ DBcolumns.GROUP_TYPE+") VALUES(\'" + //group.GroupId + ",\'" + group.GroupName + "\'," + group.Num + ",\'" + group.Time + "\',\'" + group.Notice + "\',\'" + group.Type + "\')"; ExecuteNonQuery(cmdString, Constant.globalDbPath + "global.db"); return true; }
/// <summary> /// 查询群的资料 /// </summary> /// <param name="groupId">群ID</param> /// <returns>群资料</returns> public Group queryGroup(int groupId) { string cmdString = "SELECT * FROM "+ DBcolumns.TABLE_GROUP+" WHERE " + DBcolumns.GROUP_ID + " = " + groupId; SQLiteConnection conn = new SQLiteConnection("Data Source=" + Constant.globalDbPath + "global.db"); conn.Open(); SQLiteCommand cmd = new SQLiteCommand(cmdString,conn); SQLiteDataReader dr = cmd.ExecuteReader(); int count = dr.FieldCount; if (dr.Read()) { Group gr = new Group(); gr.GroupId = dr.GetInt32(0); gr.GroupName = dr.GetString(1); gr.Num = dr.GetInt32(2); gr.Time = dr.GetString(3) ; gr.Notice = dr.GetString(4); gr.Type = dr.GetString(5); conn.Close(); return gr; } conn.Close(); return null; }