/// <summary> /// 获得所有群 /// </summary> public static List <exRoom> GetRooms() { List <exRoom> Rooms = new List <exRoom>(); string sql = "select * from Rooms"; System.Data.SQLite.SQLiteDataReader dr = SQLiteDBHelper.ExecuteReader(sql, null); if (dr != null) { while (dr.Read()) { exRoom Room = new exRoom(); { Room.RoomID = Convert.ToString(dr["RoomID"]); Room.RoomName = Convert.ToString(dr["RoomName"]); Room.Notice = Convert.ToString(dr["Notice"]); Room.UserIDs = Convert.ToString(dr["Users"]); Room.OrderID = Convert.ToInt32(dr["OrderID"]); Room.CreateUserID = Convert.ToString(dr["CreateUserID"]); } Rooms.Add(Room); } dr.Close(); } dr.Dispose(); return(Rooms); }
/// <summary> /// 群信息更新事件 /// </summary> /// <param name="sender"></param> /// <param name="Room"></param> private void fs_UpdateRoom(object sender, exRoom Room) { if (this.UpdateRoom != null) { this.UpdateRoom(this, Room); } }
private void butCreateGroup_Click(object sender, EventArgs e) { if (this.textBoxGroupName.Text.Trim() == "") { MessageBox.Show("组名不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.textBoxGroupName.Focus(); return; } this.butCreateGroup.Enabled = false; this.isUpdateSuccess = false; exRoom NewRoom = new exRoom(); NewRoom.RoomID = this.textBoxGroupID.Text.Trim(); NewRoom.UserIDs = ""; NewRoom.CreateUserID = this.textBoxCreateUser.Text; //群组创建用户编号 NewRoom.RoomName = this.textBoxGroupName.Text; //群组名称 NewRoom.Notice = this.textBoxGroupNotice.Text; //群组通知 foreach (ListViewItem item in this.listViewGroupUsers.Items) { NewRoom.UserIDs += item.Text + ";"; } if (CreateRoom != null) { CreateRoom(this, NewRoom); } this.timer1.Enabled = true;//启动检测更新 }
private void butOK_Click(object sender, EventArgs e) { if (!IsCreate && myUserID != textBoxCreateUser.Text) { this.Close(); return; } if (this.textBoxGroupName.Text.Trim() == "") { MessageBox.Show("组名不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.textBoxGroupName.Focus(); return; } this.butOK.Enabled = false; this.isUpdateSuccess = false; exRoom NewRoom = new exRoom(); NewRoom.UserIDs = ""; NewRoom.RoomID = this.textBoxGroupID.Text; //组编号 NewRoom.CreateUserID = this.textBoxCreateUser.Text; //群组创建用户编号 NewRoom.RoomName = this.textBoxGroupName.Text; //群组名称 NewRoom.Notice = this.textBoxGroupNotice.Text; //群组通知 foreach (ListViewItem item in this.listViewGroupUsers.Items) { NewRoom.UserIDs += item.Text + ";"; } string newVersion = NewRoom.RoomName.Trim() + NewRoom.Notice.Trim() + NewRoom.UserIDs; if (newVersion == oldVersion)//如果未做修改,则退出 { this.Close(); return; } if (this.UpdateRoom != null) { this.UpdateRoom(this, NewRoom); } this.timer1.Enabled = true;//启动检测更新 }
/// <summary> /// 树图节点选中后事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void treeView_Organization_AfterSelect(object sender, TreeViewEventArgs e) { this.txtRecord.Clear(); this.ButLast.Enabled = false; this.ButDown.Enabled = false; this.ButFirst.Enabled = false; this.ButUp.Enabled = false; this.ButDelRecord.Enabled = false; this.PageCount = 0; this.CurrPage = 0; if (e.Node.Tag is exUser) { exUser user = e.Node.Tag as exUser; this.SelectUserID = user.UserID; this.MessageType = IMLibrary3.Enmu.MessageType.User; } else if (e.Node.Tag is exRoom) { exRoom room = e.Node.Tag as exRoom; this.SelectUserID = room.RoomID; this.MessageType = IMLibrary3.Enmu.MessageType.Group; } else if (e.Node.ImageIndex == 17) { this.MessageType = IMLibrary3.Enmu.MessageType.Notice; } this.PageCount = GetPageCount(this.SelectUserID); if (this.PageCount > 0) { DBRecordToRichTextBox(1); } this.TextBoxPage.Text = this.CurrPage.ToString() + "/" + this.PageCount.ToString(); }
/// <summary> /// 添加或更新一个群信息 /// </summary> /// <param name="Groups"></param> public static void UpdateRooms(exRoom room) { #region 单次插入数据 string sql = "insert into Rooms(RoomID,RoomName,Users, Notice,CreateUserID) values(@RoomID,@RoomName,@Users,@Notice,@CreateUserID)"; System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[] { new System.Data.SQLite.SQLiteParameter("@RoomID", room.RoomID), new System.Data.SQLite.SQLiteParameter("@RoomName", room.RoomName), new System.Data.SQLite.SQLiteParameter("@Users", room.UserIDs), new System.Data.SQLite.SQLiteParameter("@Notice", room.Notice), new System.Data.SQLite.SQLiteParameter("@CreateUserID", room.CreateUserID), }; try { SQLiteDBHelper.ExecuteNonQuery(sql, parameters); } catch { try { sql = "update Rooms set RoomName=@RoomName,Users=@Users,Notice=@Notice,CreateUserID=@CreateUserID where RoomID=@RoomID"; SQLiteDBHelper.ExecuteNonQuery(sql, parameters); } catch (Exception ex) { MessageBox.Show(ex.Source + ex.Message); } } #endregion #region 一次性事务添加 //SQLiteConnection con = new SQLiteConnection(); //创建连接 //SQLiteCommand cmd = null; //con.ConnectionString = conStr; //try //{ // con.Open(); // using (SQLiteTransaction dbTrans = con.BeginTransaction()) //使用事务 // { // using (cmd = con.CreateCommand()) // { // cmd.CommandText = "insert into Groups(GroupID,GroupName,SuperiorID,orderID) values(?,?,?,?)"; // SQLiteParameter Field1 = cmd.CreateParameter(); //添加字段 // SQLiteParameter Field2 = cmd.CreateParameter(); // SQLiteParameter Field3 = cmd.CreateParameter(); // SQLiteParameter Field4 = cmd.CreateParameter(); // cmd.Parameters.Add(Field1); // cmd.Parameters.Add(Field2); // cmd.Parameters.Add(Field3); // cmd.Parameters.Add(Field4); // foreach (OurMsg.Organization.exGroup group in Groups) // { // Field1.Value = group.GroupID; //字符赋值 // Field2.Value = group.GroupName; // Field3.Value = group.SuperiorID; // Field4.Value = group.OrderID; // cmd.ExecuteNonQuery(); // } // } // dbTrans.Commit(); //提交事务执行 // } //} //catch (Exception ex) //{ // MessageBox.Show(ex.Source + ex.Message); //} //finally //{ // con.Close(); //} #endregion }