/// <summary>
/// 复制菜单项目
/// </summary>
/// <param name="orgMenuItem">原始的菜单</param>
/// <returns>克隆的菜单</returns>
public static ToolStripMenuItem Clone(this ToolStripMenuItem orgMenuItem)
{
var cloneMenuItem = new ToolStripMenuItem();
//!!!typeof的参数必须是ToolStripMenuItem的基类!!!如果使用Control则不能取到值!!!
//感谢CSDN网友beargo在帖子【如何获取事件已定制方法名?】里面的提示，网上的例子没有说明这个问题
//坑爹啊。。。。。。。。
Delegate[] _List = GetObjectEventList(orgMenuItem, "EventClick", typeof(ToolStripItem));
if (!SystemManager.MonoMode)
{
//悲催MONO不支持
if (_List != null && _List[0] != null)
{
try
{
cloneMenuItem.Click += (x, y) => _List[0].DynamicInvoke(x, y);
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex, cloneMenuItem.Text);
}
}
}
cloneMenuItem.Text = orgMenuItem.Text;
cloneMenuItem.Enabled = orgMenuItem.Enabled;
cloneMenuItem.BackgroundImage = orgMenuItem.BackgroundImage;
cloneMenuItem.Image = orgMenuItem.Image;
//子菜单的复制
foreach (ToolStripMenuItem item in orgMenuItem.DropDownItems)
{
cloneMenuItem.DropDownItems.Add(item.Clone());
}
return(cloneMenuItem);
}
/// <summary>
/// Fill Server Status to treeview
/// </summary>
/// <param name="trvSvrStatus"></param>
public static void FillSrvStatusToList(TreeViewColumns trvSvrStatus)
{
var SrvDocList = new List <BsonDocument>();
foreach (String mongoSvrKey in _mongoConnSvrLst.Keys)
{
try
{
MongoServer mongoSvr = _mongoConnSvrLst[mongoSvrKey];
if (!SystemManager.GetCurrentServerConfig(mongoSvrKey).Health)
{
continue;
}
//flydreamer提供的代码
//感谢 魏琼东 的Bug信息,一些命令必须以Admin执行
if (SystemManager.GetCurrentServerConfig(mongoSvrKey).LoginAsAdmin)
{
BsonDocument ServerStatusDoc = CommandHelper.ExecuteMongoSvrCommand(CommandHelper.serverStatus_Command, mongoSvr).Response;
SrvDocList.Add(ServerStatusDoc);
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
}
}
FillDataToTreeView("Server Status", trvSvrStatus, SrvDocList, 0);
//打开第一层
foreach (TreeNode item in trvSvrStatus.DatatreeView.Nodes)
{
item.Expand();
}
}
/// <summary>
/// 复制菜单项目StripButton
/// </summary>
/// <param name="orgMenuItem">原始的菜单</param>
/// <returns>克隆的菜单StripButton</returns>
public static ToolStripButton CloneFromMenuItem(this ToolStripMenuItem orgMenuItem)
{
var cloneButton = new ToolStripButton();
//!!!typeof的参数必须是ToolStripMenuItem的基类!!!如果使用Control则不能取到值!!!
//感谢CSDN网友beargo在帖子【如何获取事件已定制方法名?】里面的提示，网上的例子没有说明这个问题
//坑爹啊。。。。。。。。
Delegate[] _List = GetObjectEventList(orgMenuItem, "EventClick", typeof(ToolStripItem));
if (!SystemManager.MonoMode)
{
//悲催MONO不支持
if (_List != null && _List[0] != null)
{
try
{
cloneButton.Click += (x, y) => { _List[0].DynamicInvoke(x, y); };
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
}
}
}
cloneButton.Image = orgMenuItem.Image;
cloneButton.Enabled = orgMenuItem.Enabled;
cloneButton.Text = orgMenuItem.Text;
cloneButton.Checked = orgMenuItem.Checked;
cloneButton.DisplayStyle = ToolStripItemDisplayStyle.Image;
return(cloneButton);
}
///在使用GirdFileSystem的时候，请注意：
///1.Windows 系统的文件名不区分大小写，不过，filename一定是区分大小写的，如果大小写不匹配的话，会发生无法找到文件的问题
///2.Download的时候，不能使用SlaveOk选项！
/// <summary>
/// 打开文件
/// </summary>
/// <param name="strFileName"></param>
public static void OpenFile(String strRemoteFileName)
{
MongoDatabase mongoDB = SystemManager.GetCurrentDataBase();
MongoGridFS gfs = mongoDB.GetGridFS(new MongoGridFSSettings());
String[] strLocalFileName = strRemoteFileName.Split(System.IO.Path.DirectorySeparatorChar);
try
{
if (!Directory.Exists(TempFileFolder))
{
Directory.CreateDirectory(TempFileFolder);
}
String LocalFileName = TempFileFolder + System.IO.Path.DirectorySeparatorChar + strLocalFileName[strLocalFileName.Length - 1];
gfs.Download(LocalFileName, strRemoteFileName);
System.Diagnostics.Process.Start(LocalFileName);
}
catch (System.ComponentModel.Win32Exception)
{
MyMessageBox.ShowEasyMessage("Error", "No Program can open this file");
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex, "Error", "Exception happend when open file");
}
}
/// <summary>
/// 数据库操作
/// </summary>
/// <param name="strObjTag"></param>
/// <param name="dbName"></param>
/// <param name="func"></param>
/// <param name="tr"></param>
/// <returns></returns>
public static String DataBaseOpration(String strObjTag, String dbName, Oprcode func, TreeNode tr)
{
String rtnResult = String.Empty;
MongoServer mongoSvr = GetMongoServerBySvrPath(strObjTag);
String strSvrPath = SystemManager.GetTagData(strObjTag);
String svrKey = strSvrPath.Split("/".ToCharArray())[(int)PathLv.InstanceLv];
var result = new CommandResult(new BsonDocument());
if (mongoSvr != null)
{
switch (func)
{
case Oprcode.Create:
if (!mongoSvr.DatabaseExists(dbName))
{
//从权限上看，clusterAdmin是必须的
//但是能够建立数据库，不表示能够看到里面的内容！
//dbAdmin可以访问数据库。
//clusterAdmin能创建数据库但是不能访问数据库。
try
{
mongoSvr.GetDatabase(dbName);
tr.Nodes.Add(UIHelper.FillDataBaseInfoToTreeNode(dbName, mongoSvr, svrKey + "/" + svrKey));
}
catch (Exception ex)
{
//如果使用没有dbAdmin权限的clusterAdmin。。。。
SystemManager.ExceptionDeal(ex);
}
}
break;
case Oprcode.Drop:
if (mongoSvr.DatabaseExists(dbName))
{
result = mongoSvr.DropDatabase(dbName);
if (tr != null)
{
tr.TreeView.Nodes.Remove(tr);
}
if (!result.Response.Contains("err"))
{
return(String.Empty);
}
return(result.Response["err"].ToString());
}
break;
case Oprcode.Repair:
//其实Repair的入口不在这个方法里面
CommandHelper.ExecuteMongoDBCommand(CommandHelper.repairDatabase_Command, SystemManager.GetCurrentDataBase());
break;
default:
break;
}
}
return(rtnResult);
}
/// <summary>
/// 将数据Opr放入ListView
/// </summary>
/// <param name="lstSrvOpr"></param>
public static void FillCurrentOprToList(ListView lstSrvOpr)
{
lstSrvOpr.Clear();
lstSrvOpr.Columns.Add("Name");
lstSrvOpr.Columns.Add("opid");
lstSrvOpr.Columns.Add("active");
lstSrvOpr.Columns.Add("lockType");
lstSrvOpr.Columns.Add("waitingForLock");
lstSrvOpr.Columns.Add("secs_running");
lstSrvOpr.Columns.Add("op");
lstSrvOpr.Columns.Add("ns");
lstSrvOpr.Columns.Add("query");
lstSrvOpr.Columns.Add("client");
lstSrvOpr.Columns.Add("desc");
lstSrvOpr.Columns.Add("connectionId");
lstSrvOpr.Columns.Add("numYields");
foreach (String mongoSvrKey in _mongoConnSvrLst.Keys)
{
try
{
MongoServer mongoSvr = _mongoConnSvrLst[mongoSvrKey];
//感谢 魏琼东 的Bug信息,一些命令必须以Admin执行
if (!SystemManager.GetCurrentServerConfig(mongoSvrKey).Health ||
!SystemManager.GetCurrentServerConfig(mongoSvrKey).LoginAsAdmin)
{
continue;
}
List <String> databaseNameList = mongoSvr.GetDatabaseNames().ToList();
foreach (String strDBName in databaseNameList)
{
try
{
MongoDatabase mongoDB = mongoSvr.GetDatabase(strDBName);
BsonDocument dbStatus = mongoDB.GetCurrentOp();
BsonArray doc = dbStatus.GetValue("inprog").AsBsonArray;
foreach (BsonDocument item in doc)
{
var lst = new ListViewItem(mongoSvrKey + "." + strDBName);
foreach (String itemName in item.Names)
{
lst.SubItems.Add(item.GetValue(itemName).ToString());
}
lstSrvOpr.Items.Add(lst);
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
}
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
}
}
lstSrvOpr.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
/// <summary>
/// 当前对象的MONGO命令
/// </summary>
/// <param name="mMongoCommand">命令对象</param>
/// <param name="ShowMsgBox"></param>
/// <returns></returns>
public static CommandResult ExecuteMongoCommand(MongoCommand mMongoCommand, Boolean ShowMsgBox = true)
{
var ResultCommandList = new List <CommandResult>();
var mCommandResult = new CommandResult(new BsonDocument());
try
{
switch (mMongoCommand.RunLevel)
{
case MongoDbHelper.PathLv.CollectionLv:
if (String.IsNullOrEmpty(mMongoCommand.CommandString))
{
mCommandResult = ExecuteMongoColCommand(mMongoCommand.cmdDocument,
SystemManager.GetCurrentCollection());
}
else
{
mCommandResult = ExecuteMongoColCommand(mMongoCommand.CommandString,
SystemManager.GetCurrentCollection());
}
break;
case MongoDbHelper.PathLv.DatabaseLv:
mCommandResult = ExecuteMongoDBCommand(mMongoCommand.cmdDocument,
SystemManager.GetCurrentDataBase());
break;
case MongoDbHelper.PathLv.InstanceLv:
mCommandResult = ExecuteMongoSvrCommand(mMongoCommand.cmdDocument,
SystemManager.GetCurrentServer());
break;
default:
break;
}
ResultCommandList.Add(mCommandResult);
if (ShowMsgBox)
{
MyMessageBox.ShowMessage(mMongoCommand.CommandString, mMongoCommand.CommandString + " Result",
MongoDbHelper.ConvertCommandResultlstToString(ResultCommandList), true);
}
}
catch (IOException ex)
{
SystemManager.ExceptionDeal(ex, mMongoCommand.CommandString,
"IOException,Try to set Socket TimeOut more long at connection config");
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex, mMongoCommand.CommandString);
}
return(mCommandResult);
}
/// <summary>
/// 执行聚合
/// </summary>
/// <param name="AggregateDoc"></param>
/// <returns></returns>
public static CommandResult Aggregate(BsonArray AggregateDoc)
{
//db.runCommand( { aggregate: "people", pipeline: [<pipeline>] } )
try
{
CommandDocument agg = new CommandDocument();
agg.Add(new BsonElement("aggregate", new BsonString(SystemManager.GetCurrentCollection().Name)));
agg.Add(new BsonElement("pipeline", AggregateDoc));
MongoCommand Aggregate_Command = new MongoCommand(agg, PathLv.DatabaseLV);
return(ExecuteMongoCommand(Aggregate_Command, false));
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
return(new CommandResult(new BsonDocument()));
}
}
public static String LoadFile()
{
OpenFileDialog dialog = new OpenFileDialog();
String Context = String.Empty;
if (dialog.ShowDialog() == DialogResult.OK)
{
try
{
StreamReader reader = new StreamReader(dialog.FileName);
Context = reader.ReadToEnd();
reader.Close();
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
}
}
return(Context);
}
/// <summary>
/// 增加管理服务器
/// </summary>
/// <param name="configLst"></param>
/// <returns></returns>
public static void AddServer(List <ConfigHelper.MongoConnectionConfig> configLst)
{
for (int i = 0; i < configLst.Count; i++)
{
ConfigHelper.MongoConnectionConfig config = configLst[i];
try
{
if (_mongoConnSvrLst.ContainsKey(config.ConnectionName))
{
_mongoConnSvrLst.Remove(config.ConnectionName);
}
_mongoConnSvrLst.Add(config.ConnectionName, CreateMongoServer(ref config));
//更新一些运行时的变量
SystemManager.ConfigHelperInstance.ConnectionList[config.ConnectionName] = config;
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex, "Exception", "Can't Connect to Server：" + config.ConnectionName);
}
}
}
/// <summary>
/// 当前对象的MONGO命令
/// </summary>
/// <param name="cmd">命令对象</param>
/// <returns></returns>
public static void ExecuteMongoCommand(MongoCommand cmd)
{
var Command = new CommandDocument {
{ cmd.CommandString, 1 }
};
List <CommandResult> ResultCommandList = new List <CommandResult>();
CommandResult rtn = new CommandResult();
try
{
switch (cmd.RunLevel)
{
case PathLv.CollectionLV:
rtn = ExecuteMongoColCommand(cmd.CommandString, SystemManager.GetCurrentCollection());
break;
case PathLv.DatabaseLV:
rtn = ExecuteMongoDBCommand(Command, SystemManager.GetCurrentDataBase());
break;
case PathLv.ServerLV:
rtn = ExecuteMongoSvrCommand(Command, SystemManager.GetCurrentServer());
break;
default:
break;
}
ResultCommandList.Add(rtn);
MyMessageBox.ShowMessage(cmd.CommandString, cmd.CommandString + " Result", MongoDBHelper.ConvertCommandResultlstToString(ResultCommandList), true);
}
catch (System.IO.IOException ex)
{
MyMessageBox.ShowMessage(cmd.CommandString, "IOException,Try to set Socket TimeOut more long at connection config", ex.ToString(), true);
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex, cmd.CommandString);
}
}
/// <summary>
/// 上传文件
/// </summary>
/// <remarks>Mongo允许同名文件，因为id才是主键</remarks>
/// <param name="strFileName"></param>
public static UploadResult UpLoadFile(String strFileName, UpLoadFileOption Option)
{
MongoDatabase mongoDB = SystemManager.GetCurrentDataBase();
MongoGridFS gfs = mongoDB.GetGridFS(new MongoGridFSSettings());
String RemoteName = String.Empty;
if (Option.FileNameOpt == enumGFSFileName.filename)
{
RemoteName = new FileInfo(strFileName).Name;
}
else
{
if (Option.DirectorySeparatorChar != Path.DirectorySeparatorChar)
{
RemoteName = strFileName.Replace(Path.DirectorySeparatorChar, Option.DirectorySeparatorChar);
}
else
{
RemoteName = strFileName;
}
}
try
{
OnActionDone(new ActionDoneEventArgs(RemoteName + " Uploading "));
if (!gfs.Exists(RemoteName))
{
gfs.Upload(strFileName, RemoteName);
return(UploadResult.Complete);
}
else
{
switch (Option.AlreadyOpt)
{
case enumGFSAlready.JustAddIt:
gfs.Upload(strFileName, RemoteName);
return(UploadResult.Complete);
case enumGFSAlready.RenameIt:
String ExtendName = new FileInfo(strFileName).Extension;
String MainName = RemoteName.Substring(0, RemoteName.Length - ExtendName.Length);
int i = 1;
while (gfs.Exists(MainName + i.ToString() + ExtendName))
{
i++;
}
gfs.Upload(strFileName, MainName + i.ToString() + ExtendName);
return(UploadResult.Complete);
case enumGFSAlready.SkipIt:
return(UploadResult.Skip);
case enumGFSAlready.OverwriteIt:
gfs.Delete(RemoteName);
gfs.Upload(strFileName, RemoteName);
return(UploadResult.Complete);
case enumGFSAlready.Stop:
return(UploadResult.Skip);
}
return(UploadResult.Skip);
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
return(UploadResult.Exception);
}
}
/// <summary>
/// 获取实例节点
/// </summary>
/// <param name="mongoConnKey"></param>
/// <param name="config">由于是结构体，必须ref</param>
/// <param name="mongoConn"></param>
/// <param name="mMasterServerInstace"></param>
/// <param name="mServer"></param>
/// <param name="UserList"></param>
/// <returns></returns>
private static TreeNode GetInstanceNode(String mongoConnKey,
ref ConfigHelper.MongoConnectionConfig config,
MongoServer mongoConn,
MongoServerInstance mMasterServerInstace,
MongoServer mServer,
EachDatabaseUser UserList)
{
bool isReplsetMasterServer = mMasterServerInstace == null;
//无论如何，都改为主要服务器读优先
var svrInstanceNode = new TreeNode();
String connSvrKey;
connSvrKey = isReplsetMasterServer
? mongoConnKey + "/" + mongoConnKey
: mongoConnKey + "/" + mMasterServerInstace.Address.ToString().Replace(":", "@");
svrInstanceNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.WebServer;
svrInstanceNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.WebServer;
svrInstanceNode.Text = isReplsetMasterServer ? "Connection" : "Server[" + mMasterServerInstace.Address + "]";
if (!String.IsNullOrEmpty(config.UserName) & (!String.IsNullOrEmpty(config.Password)))
{
//是否是认证模式，应该取决于服务器！
config.AuthMode = true;
}
//获取ReadOnly
config.IsReadOnly = false;
List <string> databaseNameList;
if (!String.IsNullOrEmpty(config.DataBaseName))
{
//单数据库模式
TreeNode mongoSingleDbNode;
mongoSingleDbNode = isReplsetMasterServer
? FillDataBaseInfoToTreeNode(config.DataBaseName, mServer,
mongoConnKey + "/" + mongoConnKey)
: FillDataBaseInfoToTreeNode(config.DataBaseName, mServer,
mongoConnKey + "/" + mMasterServerInstace.Address);
mongoSingleDbNode.Tag = MongoDbHelper.SINGLE_DATABASE_TAG + ":" + connSvrKey + "/" + config.DataBaseName;
mongoSingleDbNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
mongoSingleDbNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
svrInstanceNode.Nodes.Add(mongoSingleDbNode);
svrInstanceNode.Tag = MongoDbHelper.SINGLE_DB_SERVER_TAG + ":" + connSvrKey;
//获取User信息
if (config.AuthMode)
{
try
{
//尝试添加用户信息
UserList.AddUser(mongoConn.GetDatabase(config.DataBaseName), config.UserName);
}
catch
{
//可能出现没有权限的问题，这里就认为无法取得权限
}
}
}
else
{
MongoServer instantSrv;
if (isReplsetMasterServer)
{
instantSrv = mServer;
databaseNameList = mServer.GetDatabaseNames().ToList();
}
else
{
MongoClientSettings setting = MongoDbHelper.CreateMongoClientSettingsByConfig(ref config);
setting.ConnectionMode = ConnectionMode.Direct;
//When Replset Case,Application need to read admin DB information
//if Primary,there will be exception
setting.ReadPreference = ReadPreference.PrimaryPreferred;
setting.Server = mMasterServerInstace.Address;
instantSrv = new MongoClient(setting).GetServer();
databaseNameList = instantSrv.GetDatabaseNames().ToList();
}
foreach (String strDbName in databaseNameList)
{
TreeNode mongoDbNode;
try
{
mongoDbNode = FillDataBaseInfoToTreeNode(strDbName, instantSrv, connSvrKey);
mongoDbNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
mongoDbNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
svrInstanceNode.Nodes.Add(mongoDbNode);
if (config.AuthMode)
{
try
{
//尝试添加用户信息
UserList.AddUser(mongoConn.GetDatabase(strDbName), config.UserName);
}
catch
{
//可能出现没有权限的问题，这里就认为无法取得权限
}
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex, strDbName + "Exception", strDbName + "Exception");
mongoDbNode = new TreeNode(strDbName + " (Exception)")
{
ImageIndex = (int)GetSystemIcon.MainTreeImageType.Database,
SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Database
};
svrInstanceNode.Nodes.Add(mongoDbNode);
}
}
if (isReplsetMasterServer)
{
svrInstanceNode.Tag = MongoDbHelper.SERVER_TAG + ":" + mongoConnKey + "/" + mongoConnKey;
}
else
{
if (mongoConn.ReplicaSetName != null)
{
svrInstanceNode.Tag = MongoDbHelper.SERVER_REPLSET_MEMBER_TAG + ":" + mongoConnKey + "/" +
mMasterServerInstace.Address.ToString().Replace(":", "@");
}
}
}
if (MongoDbHelper._mongoInstanceLst.ContainsKey(connSvrKey))
{
MongoDbHelper._mongoInstanceLst.Remove(connSvrKey);
}
if (!isReplsetMasterServer)
{
MongoDbHelper._mongoInstanceLst.Add(connSvrKey, mMasterServerInstace);
}
return(svrInstanceNode);
}
/// <summary>
/// 将Mongodb的服务器在树形控件中展示
/// </summary>
/// <param name="trvMongoDB"></param>
public static void FillConnectionToTreeView(TreeView trvMongoDB)
{
trvMongoDB.Nodes.Clear();
foreach (String mongoConnKey in MongoDbHelper._mongoConnSvrLst.Keys)
{
MongoServer mongoSrv = MongoDbHelper._mongoConnSvrLst[mongoConnKey];
var ConnectionNode = new TreeNode();
var UserList = new EachDatabaseUser();
try
{
//ReplSetName只能使用在虚拟的Replset服务器，Sharding体系等无效。虽然一个Sharding可以看做一个ReplSet
ConfigHelper.MongoConnectionConfig config =
SystemManager.ConfigHelperInstance.ConnectionList[mongoConnKey];
ConnectionNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Connection;
ConnectionNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Connection;
//ReplSet服务器需要Connect才能连接。可能因为这个是虚拟的服务器，没有Mongod实体。
//不过现在改为全部显示的打开连接
mongoSrv.Connect();
//mongoSvr.ReplicaSetName只有在连接后才有效，但是也可以使用Config.ReplsetName
ConnectionNode.Text = mongoConnKey;
ConnectionNode.Nodes.Add(GetInstanceNode(mongoConnKey, ref config, mongoSrv, null, mongoSrv,
UserList));
if (mongoSrv.ReplicaSetName != null)
{
ConnectionNode.Tag = MongoDbHelper.CONNECTION_REPLSET_TAG + ":" + config.ConnectionName;
var ServerListNode = new TreeNode("Servers")
{
SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Servers,
ImageIndex = (int)GetSystemIcon.MainTreeImageType.Servers
};
foreach (MongoServerInstance ServerInstace in mongoSrv.Instances)
{
ServerListNode.Nodes.Add(GetInstanceNode(mongoConnKey, ref config, mongoSrv, ServerInstace,
null, UserList));
}
ConnectionNode.Nodes.Add(ServerListNode);
config.ServerRole = ConfigHelper.SvrRoleType.ReplsetSvr;
}
else
{
BsonDocument ServerStatusDoc = CommandHelper.ExecuteMongoSvrCommand(CommandHelper.serverStatus_Command, mongoSrv).Response;
//ServerStatus可能没有权限打开
if (ServerStatusDoc.Contains("process") &&
ServerStatusDoc.GetElement("process").Value == MongoDbHelper.ServerStatus_PROCESS_MONGOS)
{
//Shard的时候，必须将所有服务器的ReadPreferred设成可读
config.ServerRole = ConfigHelper.SvrRoleType.ShardSvr;
ConnectionNode.Tag = MongoDbHelper.CONNECTION_CLUSTER_TAG + ":" + config.ConnectionName;
var ShardListNode = new TreeNode("Shards")
{
SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Servers,
ImageIndex = (int)GetSystemIcon.MainTreeImageType.Servers
};
foreach (var lst in MongoDbHelper.GetShardInfo(mongoSrv, "host"))
{
var ShardNode = new TreeNode
{
Text = lst.Key,
SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Servers,
ImageIndex = (int)GetSystemIcon.MainTreeImageType.Servers
};
String strHostList = lst.Value;
String[] strAddress = strHostList.Split("/".ToCharArray());
String strAddresslst;
if (strAddress.Length == 2)
{
//#1 replset/host:port,host:port
ShardNode.Text += "[Replset:" + strAddress[0] + "]";
strAddresslst = strAddress[1];
}
else
{
//#2 host:port,host:port
strAddresslst = strHostList;
}
foreach (String item in strAddresslst.Split(",".ToCharArray()))
{
var tinySetting = new MongoClientSettings
{
ConnectionMode = ConnectionMode.Direct,
ReadPreference = ReadPreference.PrimaryPreferred,
ReplicaSetName = strAddress[0]
};
//防止无法读取Sharding状态。Sharding可能是一个Slaver
MongoServerAddress SecondaryAddr;
if (item.Split(":".ToCharArray()).Length == 2)
{
SecondaryAddr = new MongoServerAddress(item.Split(":".ToCharArray())[0],
Convert.ToInt32(item.Split(":".ToCharArray())[1]));
}
else
{
SecondaryAddr = new MongoServerAddress(item.Split(":".ToCharArray())[0]);
}
tinySetting.Server = SecondaryAddr;
MongoServer ReplsetMember = new MongoClient(tinySetting).GetServer();
ShardNode.Nodes.Add(GetInstanceNode(mongoConnKey, ref config, mongoSrv,
ReplsetMember.Instance, null, UserList));
}
ShardListNode.Nodes.Add(ShardNode);
}
ConnectionNode.Nodes.Add(ShardListNode);
}
else
{
//Server Status mongod
//Master - Slave 的判断
BsonElement replElement;
ServerStatusDoc.TryGetElement("repl", out replElement);
if (replElement == null)
{
config.ServerRole = ConfigHelper.SvrRoleType.DataSvr;
}
else
{
config.ServerRole = replElement.Value.AsBsonDocument.GetElement("ismaster").Value ==
BsonBoolean.True
? ConfigHelper.SvrRoleType.MasterSvr
: ConfigHelper.SvrRoleType.SlaveSvr;
}
ConnectionNode.Tag = MongoDbHelper.CONNECTION_TAG + ":" + config.ConnectionName;
}
}
//设定是否可用
config.Health = true;
//设定版本
if (mongoSrv.BuildInfo != null)
{
config.MongoDBVersion = mongoSrv.BuildInfo.Version;
}
SystemManager.ConfigHelperInstance.ConnectionList[mongoConnKey] = config;
switch (config.ServerRole)
{
case ConfigHelper.SvrRoleType.DataSvr:
ConnectionNode.Text = "[Data] " + ConnectionNode.Text;
break;
case ConfigHelper.SvrRoleType.ShardSvr:
ConnectionNode.Text = "[Cluster] " + ConnectionNode.Text;
break;
case ConfigHelper.SvrRoleType.ReplsetSvr:
ConnectionNode.Text = "[Replset] " + ConnectionNode.Text;
break;
case ConfigHelper.SvrRoleType.MasterSvr:
ConnectionNode.Text = "[Master] " + ConnectionNode.Text;
break;
case ConfigHelper.SvrRoleType.SlaveSvr:
ConnectionNode.Text = "[Slave] " + ConnectionNode.Text;
break;
default:
break;
}
trvMongoDB.Nodes.Add(ConnectionNode);
if (MongoDbHelper._mongoUserLst.ContainsKey(mongoConnKey))
{
MongoDbHelper._mongoUserLst[mongoConnKey] = UserList;
}
else
{
MongoDbHelper._mongoUserLst.Add(mongoConnKey, UserList);
}
}
catch (MongoAuthenticationException ex)
{
//需要验证的数据服务器，没有Admin权限无法获得数据库列表
if (!SystemManager.IsUseDefaultLanguage)
{
ConnectionNode.Text += "[" +
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_AuthenticationException) + "]";
SystemManager.ExceptionDeal(ex,
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_AuthenticationException),
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_AuthenticationException_Note));
}
else
{
ConnectionNode.Text += "[MongoAuthenticationException]";
SystemManager.ExceptionDeal(ex, "MongoAuthenticationException:",
"Please check UserName and Password");
}
ConnectionNode.Tag = MongoDbHelper.CONNECTION_EXCEPTION_TAG + ":" + mongoConnKey;
trvMongoDB.Nodes.Add(ConnectionNode);
}
catch (MongoCommandException ex)
{
//listDatabase命令错误，本质是用户名称错误
if (ex.CommandResult.Response["errmsg"] == "unauthorized")
{
if (!SystemManager.IsUseDefaultLanguage)
{
ConnectionNode.Text += "[" +
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_AuthenticationException) + "]";
SystemManager.ExceptionDeal(ex,
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_AuthenticationException),
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_AuthenticationException_Note));
}
else
{
ConnectionNode.Text += "[MongoAuthenticationException]";
SystemManager.ExceptionDeal(ex, "MongoAuthenticationException:",
"Please check UserName and Password");
}
}
else
{
if (!SystemManager.IsUseDefaultLanguage)
{
ConnectionNode.Text += "[" +
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_NotConnected) + "]";
SystemManager.ExceptionDeal(ex,
SystemManager.MStringResource.GetText(StringResource.TextType.Exception_NotConnected),
"Unknown Exception");
}
else
{
ConnectionNode.Text += "[Exception]";
SystemManager.ExceptionDeal(ex, "Not Connected", "Unknown Exception");
}
}
ConnectionNode.Tag = MongoDbHelper.CONNECTION_EXCEPTION_TAG + ":" + mongoConnKey;
trvMongoDB.Nodes.Add(ConnectionNode);
}
catch (MongoConnectionException ex)
{
//暂时不处理任何异常，简单跳过
//无法连接的理由：
//1.服务器没有启动
//2.认证模式不正确
if (!SystemManager.IsUseDefaultLanguage)
{
ConnectionNode.Text += "[" +
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_NotConnected) + "]";
SystemManager.ExceptionDeal(ex,
SystemManager.MStringResource.GetText(StringResource.TextType.Exception_NotConnected),
SystemManager.MStringResource.GetText(StringResource.TextType.Exception_NotConnected_Note));
}
else
{
ConnectionNode.Text += "[Exception]";
SystemManager.ExceptionDeal(ex, "Not Connected",
"Mongo Server may not Startup or Auth Mode is not correct");
}
ConnectionNode.Tag = MongoDbHelper.CONNECTION_EXCEPTION_TAG + ":" + mongoConnKey;
trvMongoDB.Nodes.Add(ConnectionNode);
}
catch (Exception ex)
{
if (!SystemManager.IsUseDefaultLanguage)
{
ConnectionNode.Text += "[" +
SystemManager.MStringResource.GetText(
StringResource.TextType.Exception_NotConnected) + "]";
SystemManager.ExceptionDeal(ex,
SystemManager.MStringResource.GetText(StringResource.TextType.Exception_NotConnected),
"Unknown Exception");
}
else
{
ConnectionNode.Text += "[Exception]";
SystemManager.ExceptionDeal(ex, "Not Connected", "Unknown Exception");
}
ConnectionNode.Tag = MongoDbHelper.CONNECTION_EXCEPTION_TAG + ":" + mongoConnKey;
trvMongoDB.Nodes.Add(ConnectionNode);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="mongoConnKey"></param>
/// <param name="config"></param>
/// <param name="mongoConn"></param>
/// <param name="mServerInstace"></param>
/// <param name="mServer"></param>
/// <returns></returns>
private static TreeNode GetInstanceNode(String mongoConnKey, ConfigHelper.MongoConnectionConfig config,
MongoServer mongoConn, MongoServerInstance mServerInstace, MongoServer mServer)
{
Boolean isServer = false;
//无论如何，都改为主要服务器读优先
if (mServerInstace == null)
{
isServer = true;
}
TreeNode SvrInstanceNode = new TreeNode();
String ConnSvrKey;
if (isServer)
{
ConnSvrKey = mongoConnKey + "/" + mongoConnKey;
}
else
{
ConnSvrKey = mongoConnKey + "/" + mServerInstace.Address.ToString().Replace(":", "@");
}
SvrInstanceNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.WebServer;
SvrInstanceNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.WebServer;
if (isServer)
{
SvrInstanceNode.Text = "Connection";
}
else
{
SvrInstanceNode.Text = "Server[" + mServerInstace.Address.ToString() + "]";
}
if ((!String.IsNullOrEmpty(config.UserName)) & (!String.IsNullOrEmpty(config.Password)))
{
config.AuthMode = true;
}
//获取ReadOnly
config.IsReadOnly = false;
List <String> databaseNameList = new List <String>();
if (!String.IsNullOrEmpty(config.DataBaseName))
{
//单数据库模式
TreeNode mongoSingleDBNode;
if (isServer)
{
mongoSingleDBNode = FillDataBaseInfoToTreeNode(config.DataBaseName, mServer, mongoConnKey + "/" + mongoConnKey);
}
else
{
mongoSingleDBNode = FillDataBaseInfoToTreeNode(config.DataBaseName, MongoServer.Create(mServerInstace.Settings), mongoConnKey + "/" + mServerInstace.Address.ToString());
}
mongoSingleDBNode.Tag = SINGLE_DATABASE_TAG + ":" + ConnSvrKey + "/" + config.DataBaseName;
mongoSingleDBNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
mongoSingleDBNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
SvrInstanceNode.Nodes.Add(mongoSingleDBNode);
SvrInstanceNode.Tag = SINGLE_DB_SERVER_TAG + ":" + ConnSvrKey;
if (config.AuthMode)
{
config.IsReadOnly = mongoConn.GetDatabase(config.DataBaseName).FindUser(config.UserName).IsReadOnly;
}
}
else
{
MongoServer InstantSrv;
if (isServer)
{
InstantSrv = mServer;
databaseNameList = mServer.GetDatabaseNames().ToList <String>();
}
else
{
MongoServerSettings setting = mongoConn.Settings.Clone();
setting.ConnectionMode = ConnectionMode.Direct;
//When Replset Case,Application need to read admin DB information
//if Primary,there will be exception
setting.ReadPreference = ReadPreference.PrimaryPreferred;
setting.Server = mServerInstace.Address;
InstantSrv = new MongoServer(setting);
databaseNameList = InstantSrv.GetDatabaseNames().ToList <String>();
}
foreach (String strDBName in databaseNameList)
{
TreeNode mongoDBNode;
try
{
mongoDBNode = FillDataBaseInfoToTreeNode(strDBName, InstantSrv, ConnSvrKey);
mongoDBNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
mongoDBNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
SvrInstanceNode.Nodes.Add(mongoDBNode);
if (strDBName == MongoDBHelper.DATABASE_NAME_ADMIN)
{
if (config.AuthMode)
{
config.IsReadOnly = mongoConn.GetDatabase(strDBName).FindUser(config.UserName).IsReadOnly;
}
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex, strDBName + "Exception", strDBName + "Exception");
mongoDBNode = new TreeNode(strDBName + " (Exception)");
mongoDBNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
mongoDBNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
SvrInstanceNode.Nodes.Add(mongoDBNode);
}
}
if (isServer)
{
SvrInstanceNode.Tag = SERVER_TAG + ":" + mongoConnKey + "/" + mongoConnKey;
}
else
{
if (mongoConn.ReplicaSetName != null)
{
SvrInstanceNode.Tag = SERVER_REPLSET_MEMBER_TAG + ":" + mongoConnKey + "/" + mServerInstace.Address.ToString().Replace(":", "@");
}
}
}
if (_mongoInstanceLst.ContainsKey(ConnSvrKey))
{
_mongoInstanceLst.Remove(ConnSvrKey);
}
if (!isServer)
{
_mongoInstanceLst.Add(ConnSvrKey, mServerInstace);
}
return(SvrInstanceNode);
}
/// <summary>
/// Fill Database status to ListView
/// </summary>
/// <param name="lstSvr"></param>
public static void FillDataBaseStatusToList(ListView lstSvr)
{
lstSvr.Clear();
if (SystemManager.IsUseDefaultLanguage)
{
lstSvr.Columns.Add("DataBaseName");
lstSvr.Columns.Add("CollectionCount");
lstSvr.Columns.Add("DataSize");
lstSvr.Columns.Add("FileSize");
lstSvr.Columns.Add("IndexCount");
lstSvr.Columns.Add("IndexSize");
lstSvr.Columns.Add("ObjectCount");
lstSvr.Columns.Add("StorageSize");
}
else
{
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_DataBaseName));
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_CollectionCount));
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_DataSize));
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_FileSize));
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_IndexCount));
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_IndexSize));
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_ObjectCount));
lstSvr.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.DataBase_Status_StorageSize));
}
foreach (String mongoSvrKey in _mongoConnSvrLst.Keys)
{
try
{
MongoServer mongoSvr = _mongoConnSvrLst[mongoSvrKey];
//感谢 魏琼东 的Bug信息,一些命令必须以Admin执行
if (!SystemManager.GetCurrentServerConfig(mongoSvrKey).Health ||
!SystemManager.GetCurrentServerConfig(mongoSvrKey).LoginAsAdmin)
{
continue;
}
List <String> databaseNameList = mongoSvr.GetDatabaseNames().ToList();
foreach (String strDBName in databaseNameList)
{
MongoDatabase mongoDB = mongoSvr.GetDatabase(strDBName);
DatabaseStatsResult dbStatus = mongoDB.GetStats();
var lst = new ListViewItem(mongoSvrKey + "." + strDBName);
try
{
lst.SubItems.Add(dbStatus.CollectionCount.ToString());
}
catch (Exception)
{
lst.SubItems.Add("0");
}
lst.SubItems.Add(GetSize(dbStatus.DataSize));
lst.SubItems.Add(GetSize(dbStatus.FileSize));
lst.SubItems.Add(dbStatus.IndexCount.ToString());
lst.SubItems.Add(GetSize(dbStatus.IndexSize));
lst.SubItems.Add(dbStatus.ObjectCount.ToString());
lst.SubItems.Add(GetSize(dbStatus.StorageSize));
lstSvr.Items.Add(lst);
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
}
}
lstSvr.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
/// <summary>
/// 获得一个表示数据库结构的节点
/// </summary>
/// <param name="strDBName"></param>
/// <param name="mongoSvr"></param>
/// <param name="mongoSvrKey"></param>
/// <returns></returns>
private static TreeNode FillDataBaseInfoToTreeNode(String strDBName, MongoServer mongoSvr, String mongoSvrKey)
{
String strShowDBName = strDBName;
if (!SystemManager.IsUseDefaultLanguage)
{
if (SystemManager.mStringResource.LanguageType == "Chinese")
{
switch (strDBName)
{
case DATABASE_NAME_ADMIN:
strShowDBName = "管理员权限(admin)";
break;
case "local":
strShowDBName = "本地(local)";
break;
case "config":
strShowDBName = "配置(config)";
break;
default:
break;
}
}
}
TreeNode mongoDBNode = new TreeNode(strShowDBName);
mongoDBNode.Tag = DATABASE_TAG + ":" + mongoSvrKey + "/" + strDBName;
MongoDatabase mongoDB = mongoSvr.GetDatabase(strDBName);
TreeNode UserNode = new TreeNode("User", (int)GetSystemIcon.MainTreeImageType.UserIcon, (int)GetSystemIcon.MainTreeImageType.UserIcon);
UserNode.Tag = USER_LIST_TAG + ":" + mongoSvrKey + "/" + mongoDB.Name + "/" + COLLECTION_NAME_USER;
mongoDBNode.Nodes.Add(UserNode);
TreeNode JsNode = new TreeNode("JavaScript", (int)GetSystemIcon.MainTreeImageType.JavaScriptList, (int)GetSystemIcon.MainTreeImageType.JavaScriptList);
JsNode.Tag = JAVASCRIPT_TAG + ":" + mongoSvrKey + "/" + mongoDB.Name + "/" + COLLECTION_NAME_JAVASCRIPT;
mongoDBNode.Nodes.Add(JsNode);
TreeNode GFSNode = new TreeNode("Grid File System", (int)GetSystemIcon.MainTreeImageType.GFS, (int)GetSystemIcon.MainTreeImageType.GFS);
GFSNode.Tag = GRID_FILE_SYSTEM_TAG + ":" + mongoSvrKey + "/" + mongoDB.Name + "/" + COLLECTION_NAME_GFS_FILES;
mongoDBNode.Nodes.Add(GFSNode);
TreeNode mongoSysColListNode = new TreeNode("Collections(System)", (int)GetSystemIcon.MainTreeImageType.SystemCol, (int)GetSystemIcon.MainTreeImageType.SystemCol);
mongoSysColListNode.Tag = SYSTEM_COLLECTION_LIST_TAG + ":" + mongoSvrKey + "/" + mongoDB.Name;
mongoDBNode.Nodes.Add(mongoSysColListNode);
TreeNode mongoColListNode = new TreeNode("Collections(General)", (int)GetSystemIcon.MainTreeImageType.CollectionList, (int)GetSystemIcon.MainTreeImageType.CollectionList);
mongoColListNode.Tag = COLLECTION_LIST_TAG + ":" + mongoSvrKey + "/" + mongoDB.Name;
List <String> colNameList = mongoDB.GetCollectionNames().ToList <String>();
foreach (String strColName in colNameList)
{
switch (strColName)
{
case COLLECTION_NAME_USER:
//system.users,fs,system.js这几个系统级别的Collection不需要放入
break;
case COLLECTION_NAME_JAVASCRIPT:
foreach (BsonDocument t in mongoDB.GetCollection(COLLECTION_NAME_JAVASCRIPT).FindAll())
{
TreeNode js = new TreeNode(t.GetValue(KEY_ID).ToString());
js.ImageIndex = (int)GetSystemIcon.MainTreeImageType.JsDoc;
js.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.JsDoc;
js.Tag = JAVASCRIPT_DOC_TAG + ":" + mongoSvrKey + "/" + mongoDB.Name + "/" + COLLECTION_NAME_JAVASCRIPT + "/" + t.GetValue(KEY_ID).ToString();
JsNode.Nodes.Add(js);
}
break;
default:
TreeNode mongoColNode = new TreeNode();
try
{
mongoColNode = FillCollectionInfoToTreeNode(strColName, mongoDB, mongoSvrKey);
}
catch (Exception ex)
{
mongoColNode = new TreeNode(strColName + "[exception:]");
mongoColNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Err;
mongoColNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Err;
SystemManager.ExceptionDeal(ex);
}
if (IsSystemCollection(mongoDB.Name, strColName))
{
switch (strColName)
{
case COLLECTION_NAME_GFS_CHUNKS:
case COLLECTION_NAME_GFS_FILES:
GFSNode.Nodes.Add(mongoColNode);
break;
default:
mongoSysColListNode.Nodes.Add(mongoColNode);
break;
}
}
else
{
mongoColListNode.Nodes.Add(mongoColNode);
}
break;
}
}
mongoDBNode.Nodes.Add(mongoColListNode);
mongoDBNode.ImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
mongoDBNode.SelectedImageIndex = (int)GetSystemIcon.MainTreeImageType.Database;
return(mongoDBNode);
}
/// <summary>
/// fill Collection status to ListView
/// </summary>
/// <param name="lstData"></param>
public static void FillCollectionStatusToList(ListView lstData)
{
lstData.Clear();
if (SystemManager.IsUseDefaultLanguage)
{
lstData.Columns.Add("CollectionName");
lstData.Columns.Add("ObjectCount");
lstData.Columns.Add("DataSize");
lstData.Columns.Add("LastExtentSize");
lstData.Columns.Add("StorageSize");
lstData.Columns.Add("TotalIndexSize");
//2012-3-6
lstData.Columns.Add("IsCapped");
lstData.Columns.Add("MaxDocuments");
lstData.Columns.Add("AverageObjectSize");
lstData.Columns.Add("PaddingFactor");
}
else
{
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_CollectionName));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_ObjectCount));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_DataSize));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_LastExtentSize));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_StorageSize));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_TotalIndexSize));
//2012-3-6
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_IsCapped));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_MaxDocuments));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_AverageObjectSize));
lstData.Columns.Add(
SystemManager.MStringResource.GetText(StringResource.TextType.Collection_Status_PaddingFactor));
}
foreach (String mongoSvrKey in _mongoConnSvrLst.Keys)
{
try
{
MongoServer mongoSvr = _mongoConnSvrLst[mongoSvrKey];
//感谢 魏琼东 的Bug信息,一些命令必须以Admin执行
if (!SystemManager.GetCurrentServerConfig(mongoSvrKey).Health ||
!SystemManager.GetCurrentServerConfig(mongoSvrKey).LoginAsAdmin)
{
continue;
}
List <String> databaseNameList = mongoSvr.GetDatabaseNames().ToList();
foreach (String strDBName in databaseNameList)
{
MongoDatabase mongoDB = mongoSvr.GetDatabase(strDBName);
List <String> colNameList = mongoDB.GetCollectionNames().ToList();
foreach (String strColName in colNameList)
{
try
{
CollectionStatsResult CollectionStatus = mongoDB.GetCollection(strColName).GetStats();
var lst = new ListViewItem(mongoSvrKey + "." + strDBName + "." + strColName);
lst.SubItems.Add(CollectionStatus.ObjectCount.ToString());
lst.SubItems.Add(GetSize(CollectionStatus.DataSize));
lst.SubItems.Add(GetSize(CollectionStatus.LastExtentSize));
lst.SubItems.Add(GetSize(CollectionStatus.StorageSize));
lst.SubItems.Add(GetSize(CollectionStatus.TotalIndexSize));
//2012-3-6
lst.SubItems.Add(CollectionStatus.IsCapped.ToString());
//https://jira.mongodb.org/browse/CSHARP-665
try
{
//注意：这个MaxDocuments只是在CappedCollection时候有效
lst.SubItems.Add(CollectionStatus.MaxDocuments.ToString());
}
catch (Exception ex)
{
//溢出
lst.SubItems.Add(Int32.MaxValue.ToString());
SystemManager.ExceptionLog(ex);
}
lst.SubItems.Add(CollectionStatus.ObjectCount != 0
? GetSize((long)CollectionStatus.AverageObjectSize)
: "0");
try
{
//在某些条件下，这个值会抛出异常，IndexKeyNotFound
lst.SubItems.Add(CollectionStatus.PaddingFactor.ToString());
}
catch (Exception)
{
lst.SubItems.Add("0");
}
lstData.Items.Add(lst);
}
catch (Exception ex)
{
//throw;
//TODO:排序时候会发生错误，所以暂时不对应
//lstData.Items.Add(new ListViewItem(strColName + "[Exception]"));
SystemManager.ExceptionDeal(ex);
}
}
}
}
catch (Exception ex)
{
SystemManager.ExceptionDeal(ex);
}
}
lstData.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
