/// <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
}
