public bool loginReadDB()
{
// db = new System.Util.DataBase(dataBaseServerIP, dataBase, dataBaseUser, dataBasePassword);
db = new System.Util.DataBase();
return(db.init());
}
public void updataRoomFromDB()
{
Room cacheRoom;
/*
* cacheRoom = new Room("", "大厅", "rooms.bmp");
* cacheRoom.personOfRoom = new List<Person>() { new Person("001", cacheRoom, "13419506744"), new Person("002", cacheRoom, "18627283312") };
* this.splitContainer2.Panel2.Controls.Add(cacheRoom);
* rooms.Add(cacheRoom);
* */
System.Util.DataBase db = Login.db;
if (!db.init())
{
System.Windows.Forms.MessageBox.Show("登陆失败", "数据库访问失败....请检查数据库配置");
return;
}
// db.command.Parameters.Add("@AgentID", System.Data.SqlDbType.NChar);
//db.command.Parameters["@AgentID"].Value = this.agent;
//查询所有数据库有的房间信息
System.Data.SqlClient.SqlDataReader roomInfo = db.queryData("SELECT g.[GROUPID] ,[GROUPEXT] ,[GROUPNAME],[adminpwd],[djpwd],[saypwd],[listenpwd],[AddFalg],[LeaveFlag],[groupright],[PASSWORD],[MaxCount],ga.USERID FROM MIT_T_GROUP as g left join MIT_T_GROUP_ADMIN ga on g.GROUPID=ga.GROUPID order by GROUPID desc ");
if (!roomInfo.HasRows)
{
return;
}
while (roomInfo.Read())
{
cacheRoom = new Room(roomInfo["GROUPID"].ToString(), roomInfo["GROUPNAME"].ToString(), "rooms.bmp");
this.splitContainer2.Panel2.Controls.Add(cacheRoom);
rooms.Add(cacheRoom);
}
RA = new Room[rooms.Count];
// System.Windows.Forms.MessageBox.Show(RA.Length.ToString(), "ss");
db.closeDataBase();
//查询房间的人的信息
db.command.Parameters.Add("@GROUPID", System.Data.SqlDbType.NChar);
foreach (Room r in rooms)
{
int i = 0; RA[i] = r;
//添加右键
r.ContextMenuStrip = roomRightClick;
db.command.Parameters["@GROUPID"].Value = r.roomNumber;
System.Data.SqlClient.SqlDataReader personInfo = db.queryData("SELECT m.[MEMBERID] ,[MEMBEREXT] ,[MEMBERNAME],[sex],[CTILINE],[extline],[dept],[msequence],[email],[fax],[mobile],gm.GROUPID,gm.STATUS,gm.sequence FROM [Esunnet].[dbo].[MIT_T_MEMBER] m left join MIT_T_GROUPMEMBER gm on m.MEMBERID=gm.MEMBERID where gm.GROUPID=@GROUPID");
if (!personInfo.HasRows)
{
db.closeDataBase();
continue;
}
while (personInfo.Read())
{
r.personOfRoom.Add(new Person(personInfo["extline"].ToString(), personInfo["MEMBERNAME"].ToString(), personInfo["mobile"].ToString(), r));
//添加房间的人的事
if (Room.personControl == null)
{
Room.personControl = personControl1;
personControl1.showPerson(r);
}
}
db.closeDataBase();
}
panel2AddRoom();
}
