public PatientRepository()
{
_server = new MongoServer(new MongoServerSettings { Server = new MongoServerAddress(_DBHOST), SafeMode = SafeMode.True });
//patients
_patients = _server.GetDatabase(_DBNAME).GetCollection<PatientModel>("patients");
_patients.EnsureIndex(IndexKeys.Ascending("_id"), IndexOptions.SetUnique(true));
_gridFS = _server.GetDatabase(_DBNAME).GridFS;
new MongoDB.Web.Providers.MongoDBMembershipProvider();
}
public MOngoTests()
{
server = MongoServer.Create();
database = server.GetDatabase("Diplome");
collection = database.GetCollection<Test>("companies");
collection.RemoveAll();
}
public void ReloadExisting()
{
connectionString = "mongodb://localhost/?safe=true";
server = MongoServer.Create(connectionString);
habraDb = server.GetDatabase("habr", SafeMode.True);
posts = habraDb.GetCollection<Post>("posts");
existedBeforeCount = posts.Count();
using (client = new WebClient())
{
client.Encoding = Encoding.UTF8;
foreach (var post in posts.FindAll())
{
try
{
Console.Clear();
Console.WriteLine(string.Format("Reloaded: {0} posts of {1} possible", reloadedCount, existedBeforeCount));
Console.WriteLine("Processing: " + post.Url);
Console.WriteLine("Loading...");
string pageContent = client.DownloadString(post.Url);
Console.WriteLine("Parsing...");
ParsePostPage(post.Url, pageContent);
}
catch { }
}
}
}
public void DownloadNew()
{
connectionString = "mongodb://localhost/?safe=true";
server = MongoServer.Create(connectionString);
habraDb = server.GetDatabase("habr", SafeMode.True);
posts = habraDb.GetCollection<Post>("posts");
existedBeforeCount = posts.Count();
int postListPage = 1;
while (downloadedCount < NEEDED_POST_COUNT)
{
using (client = new WebClient())
{
client.Encoding = Encoding.UTF8;
try
{
string url = "http://habrahabr.ru/posts/collective/";
if (postListPage > 1)
url += string.Format("page{0}/", postListPage);
string pageContent = client.DownloadString(url);
ParsePostListPage(pageContent);
postListPage++;
}
catch { }
}
}
}
public void Initialize(string connectionString)
{
var mongoUrl = new MongoUrl( connectionString );
var client = new MongoClient( mongoUrl );
_server = client.GetServer();
_database = _server.GetDatabase( mongoUrl.DatabaseName );
}
public TaskRepository()
{
var client = new MongoClient(Properties.Settings.Default.MongoConnection);
_server = client.GetServer();
_database = _server.GetDatabase("IntegrityGTD", SafeMode.True);
_tasks = _database.GetCollection<Task>("Tasks");
}
public void ConnectDB()
{
string connectionString = "mongodb://*****:*****@linus.mongohq.com:10061/238c698d_a07f_425c_a07d_155064079ba8";
client = new MongoClient(connectionString);
server = client.GetServer();
db = server.GetDatabase("238c698d_a07f_425c_a07d_155064079ba8");
}
public MongoEventStore(IMongoConfiguration mongoConfiguration, IEventBus eventBus)
: base(eventBus)
{
_server = MongoServer.Create(mongoConfiguration.Url);
var mongoDatabaseSettings = _server.CreateDatabaseSettings(mongoConfiguration.DatabaseName);
_database = _server.GetDatabase(mongoDatabaseSettings);
}
public void TestFixture_Setup()
{
_server = new MongoServer();
_db = _server.GetDatabase("TestSuiteDatabase");
DroppedCollectionResponse collResponse = _db.DropCollection("TestClasses");
_coll = _db.GetCollection<TestClass>("TestClasses");
}
public ContactRepository(string connection)
{
if (string.IsNullOrWhiteSpace(connection))
{
connection = "mongodb://*****:*****@example.com", index),
Name = string.Format("test{0}", index),
Phone = string.Format("{0}{0}{0} {0}{0}{0} {0}{0}{0}{0}", index)
};
AddContact(contact1);
}
}
public static void InitializeConnection()
{
client =
new MongoClient("mongodb://*****:*****@ds063779.mongolab.com:63779/mongochat");
server = client.GetServer();
db = server.GetDatabase("mongochat");
}
public void TestFixtureSetup()
{
_server = Configuration.TestServer;
_adminDatabase = _server.GetDatabase("admin");
_database = Configuration.TestDatabase;
_primary = _server.Primary;
}
public TodoRepository(string connection)
{
if (string.IsNullOrWhiteSpace(connection))
{
connection = ConfigurationManager.AppSettings["TodoConnectionString"];
}
_server = MongoServer.Create(connection);
_database = _server.GetDatabase(ConfigurationManager.AppSettings["TodoDatabaseName"], SafeMode.True);
_todos = _database.GetCollection<Todo>(ConfigurationManager.AppSettings["TodoTableName"]);
bool resetData = true;
bool.TryParse(ConfigurationManager.AppSettings["ResetData"], out resetData);
if (resetData)
{
_todos.RemoveAll();
for (int i = 0; i < 5; i++)
{
Todo todo = new Todo
{
Description = string.Format("Todo {0}", i + 1),
Done = (i % 3 == 0 ? true : false),
CreationDatetime = DateTime.Now,
DoneDatetime = null
};
if (todo.Done)
todo.DoneDatetime = DateTime.Now;
AddTodo(todo);
}
}
}
public MongoContext(string connectionString)
{
this.connectionString = connectionString;
this.server = MongoServer.Create(this.connectionString);
string databaseName = GetDatabaseName(this.connectionString);
this.database = server.GetDatabase(databaseName);
}
public HugRepository(string connectionString, string databaseName, IUserProfileRepository userProfileRepository)
{
_userProfileRepository = userProfileRepository;
_server = MongoServer.Create(connectionString);
_database = _server.GetDatabase(databaseName);
_mongoCollection = _database.GetCollection<PenedatingMongoUser>("users");
}
public void TestFixtureSetUp()
{
_server = MongoServer.Create(ConnStr);
if (_server.DatabaseExists(PropSetCollectionsDb))
_server.DropDatabase(PropSetCollectionsDb);
_testDb = _server.GetDatabase(PropSetCollectionsDb);
}
// ---------- PROPERTIES ----------
// ---------- CONSTRUCTORS ----------
/// <summary>
/// Creates a utility object that can be used to perform operations against a MongoDB server.
/// Note:
/// Uses the authentication and database information from the supplied configuration item.
/// </summary>
/// <param name="configurationFolderPath">The path to the folder containing the encrypted configuration file containing information required to establish the connection to the server.</param>
/// <param name="configurationItemName">The name of configuration item containing the information required to connect to the server. (Typically it's filename without the extension.)</param>
public MongoDBUtility(string configurationFolderPath, string configurationItemName)
{
if (!string.IsNullOrWhiteSpace(configurationFolderPath) && !string.IsNullOrWhiteSpace(configurationItemName))
{
ConfigurationItem configItem = new ConfigurationItem(configurationFolderPath, configurationItemName, true);
try
{
// Read the connection string from the configuration file.
url = MongoUrl.Create(configItem.Value);
client = new MongoClient(url);
server = client.GetServer();
database = server.GetDatabase(url.DatabaseName);
}
catch
{
throw new FormatException("Could not load configuration data from file. File is not of the correct format.");
}
}
else
{
if (string.IsNullOrWhiteSpace(configurationFolderPath))
{
throw new ArgumentNullException("configurationFolderPath", "A path to a configuration items folder must be supplied.");
}
else
{
throw new ArgumentNullException("configurationItemName", "The name of the configuration item to load must be supplied.");
}
}
}
private static void Go(long userId)
{
var settings = new MongoServerSettings
{
Server = new MongoServerAddress("127.0.0.1", 27017),
SafeMode = SafeMode.False
};
var mongoServer = new MongoServer(settings);
var database = mongoServer.GetDatabase("Test");
var map = new NoteMap();
var collection = new EntityCollection<Note>(database, map.GetDescriptor(), true);
var note = new Note
{
NoteID = "1",
Title = "This is a book.",
Content = "Oh yeah",
UserID = 123321L
};
// collection.InsertOnSubmit(note);
// collection.SubmitChanges();
// var data = collection.SelectTo(n => new { n.NoteID, n.UserID });
collection.Log = Console.Out;
var a = 4;
collection.Update(
n => new Note { },
n => true);
}
public static void FillDataForUser(MongoServer mongosvr)
{
MongoDatabase mongodb = mongosvr.GetDatabase("mongodb");
MongoCollection<BsonDocument> mongoJsCol = mongodb.GetCollection<BsonDocument>("system.js");
mongoJsCol.Insert<BsonDocument>(
new BsonDocument().Add("_id", "sum")
.Add("value", "function (x, y) { return x + y; }"));
MongoGridFS mongofs = mongodb.GetGridFS(new MongoGridFSSettings());
MongoCollection<User> mongoCol = mongodb.GetCollection<User>("User");
mongoCol.RemoveAll();
Random Ro = new Random();
///HugeData
for (int i = 0; i < 1000; i++)
{
mongoCol.Insert(new User()
{
ID = i.ToString(),
Name = "Tom",
Age = (byte)Ro.Next(100),
Age2 = (byte)Ro.Next(100),
Age3 = (byte)Ro.Next(100),
address = new Address()
{
street = "123 Main St.",
City = "Centerville",
state = "PA",
Zip = Ro.Next(20)
}
});
}
}
public PersistToMongo(string connectionString)
{
_mongoServer = new MongoClient(connectionString).GetServer();
string databaseName = MongoUrl.Create(connectionString).DatabaseName;
_mongoDatabase = _mongoServer.GetDatabase(databaseName);
_mongoCollection = _mongoDatabase.GetCollection(COLLECTION_NAME);
}
public static void EstablishConnection()
{
client = new MongoClient(connectionString);
server = client.GetServer();
database = server.GetDatabase(DbName);
entries = database.GetCollection<JSonReport>(collectionName);
}
public MongoUtil()
{
connectionString = "mongodb://localhost";
client = new MongoClient(connectionString);
server = client.GetServer();
database = server.GetDatabase("testwechat");
}
static MongoRepositoryContext() {
settings = new MongoRepositorySettings();
var url = new MongoUrl(ConfigurationManager.ConnectionStrings["SysDB"].ConnectionString);
client = new MongoClient(url);
server = client.GetServer();
database = server.GetDatabase(url.DatabaseName);
}
private void MongoSetup()
{
var connectionString = "mongodb://localhost";
client = new MongoClient(connectionString);
server = client.GetServer();
database = server.GetDatabase("Byob");
}
public MongoImpl(MongoServer connection, WriteConcern writeConcern)
{
this.writeConcern = writeConcern;
Helpers.Random.Value.NextBytes(initialValue);
collection =
connection.GetDatabase(typeof (SomeDocument).Name).GetCollection<SomeDocument>(typeof (SomeDocument).Name);
}
public MdbAccount()
{
m_Client = new MongoClient(Configuration.Database.Url);
m_Server = m_Client.GetServer();
m_Database = m_Server.GetDatabase(Configuration.Database.Name);
m_Collection = m_Database.GetCollection<Account>(MDBAccountTable);
}
public Impl(MongoServer connection, WriteConcern writeConcern)
{
_writeConcern = writeConcern;
new Random(BitConverter.ToInt32(Guid.NewGuid().ToByteArray().Take(4).ToArray(), 0)).NextBytes(_initialValue);
_collection =
connection.GetDatabase(typeof (SomeDocument).Name).GetCollection<SomeDocument>(typeof (SomeDocument).Name);
}
public PersonRepository()
{
string connectionString = "mongodb://localhost";
_server = MongoServer.Create(connectionString);
_peopleDb = _server.GetDatabase("Mono");
_people = _peopleDb.GetCollection<Person>("Person");
}
public DbInterface(String host)
{
this.host = host;
this.client = new MongoClient("mongodb://"+host);
this.server = client.GetServer();
this.docsRaw = server.GetDatabase("docs_raw");
this.docsColl = docsRaw.GetCollection<BsonDocument>("fs.files");
}
/// <summary>
/// Gets a new Instance
/// </summary>
public void Generate()
{
lock (SyncGenerate)
{
_mongo = MongoServer.Create(_mongoSettings.GetSettigns());
_database = _mongo.GetDatabase(_mongoSettings.Database);
}
}
public MongodbAccess()
{
mongo_server = MongoServer.Create(connect_string);
mongo_database = mongo_server.GetDatabase(database);
}
private MongoCollection<BsonDocument> GetSessionCollection(MongoServer conn)
{
return conn.GetDatabase("SessionState").GetCollection(nameCollection);
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmAddSharding_Load(object sender, EventArgs e)
{
if (!SystemManager.IsUseDefaultLanguage)
{
cmdClose.Text = SystemManager.MStringResource.GetText(StringResource.TextType.Common_Close);
cmdAddHost.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.AddConnection_Region_AddHost);
cmdRemoveHost.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.AddConnection_Region_RemoveHost);
lblReplHost.Text = SystemManager.MStringResource.GetText(StringResource.TextType.Common_Host);
lblReplPort.Text = SystemManager.MStringResource.GetText(StringResource.TextType.Common_Port);
Text = SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_Title);
tabAddSharding.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_AddSharding);
lblMainReplsetName.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_ReplsetName);
cmdAddSharding.Text = SystemManager.MStringResource.GetText(StringResource.TextType.Common_Add);
chkAdvance.Text = SystemManager.MStringResource.GetText(StringResource.TextType.Common_Advance_Option);
tabShardingConfig.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_EnableSharding);
lblDBName.Text = SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_DBName);
lblCollection.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_CollectionName);
lblIndexLName.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_FieldName);
cmdEnableCollectionSharding.Text =
SystemManager.MStringResource.GetText(
StringResource.TextType.ShardingConfig_Action_CollectionSharding);
cmdEnableDBSharding.Text =
SystemManager.MStringResource.GetText(StringResource.TextType.ShardingConfig_Action_DBSharding);
}
_prmSvr = SystemManager.GetCurrentServer();
MongoDatabase mongoDB = _prmSvr.GetDatabase(MongoDbHelper.DATABASE_NAME_CONFIG);
MongoCollection mongoCol = mongoDB.GetCollection("databases");
foreach (BsonDocument item in mongoCol.FindAllAs <BsonDocument>())
{
if (item.GetValue(MongoDbHelper.KEY_ID) != MongoDbHelper.DATABASE_NAME_ADMIN)
{
cmbDataBase.Items.Add(item.GetValue(MongoDbHelper.KEY_ID));
cmbShardKeyDB.Items.Add(item.GetValue(MongoDbHelper.KEY_ID));
}
}
foreach (var lst in MongoDbHelper.GetShardInfo(_prmSvr, MongoDbHelper.KEY_ID))
{
lstSharding.Items.Add(lst.Value);
}
mongoCol = mongoDB.GetCollection("shards");
cmbTagList.Items.Clear();
foreach (BsonDocument mShard in mongoCol.FindAllAs <BsonDocument>())
{
if (mShard.Contains("tags"))
{
foreach (BsonValue tag in mShard.GetElement("tags").Value.AsBsonArray)
{
//严格意义上说，不应该在同一个路由里面出现两个同名的标签。
if (!TagSet.ContainsKey(tag.ToString()))
{
TagSet.Add(tag.ToString(), mShard.GetElement(MongoDbHelper.KEY_ID).Value.ToString());
cmbTagList.Items.Add(mShard.GetElement(MongoDbHelper.KEY_ID).Value + "." + tag);
}
}
}
}
}
public List <xmlDataSources> findXML_Server(string kettext, string start_time, string end_time, string Rack_ID)
{
#region Read database info server
try
{
List <xmlDataSources> ClaimReport_Server = new List <xmlDataSources>();
MongoServer server = MongoServer.Create(connectionString);
MongoDatabase db1 = server.GetDatabase(DB_NAME);
MongoCollection collection1 = db1.GetCollection("KM_BiotechnologyXML_XmlData");
MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("KM_BiotechnologyXML_XmlData");
var query = new QueryDocument("Comments", kettext);
// var dd = Query.And(Query.EQ("jigoudaima", jigoudaima), Query.EQ("fapiaoleixing", fapiaoleixing));//同时满足多个条件
if (kettext != "")
{
foreach (BsonDocument emp in employees.Find(query))
{
xmlDataSources item = new xmlDataSources();
#region 数据
if (emp.Contains("_id"))
{
item.Id = (emp["_id"].ToString());
}
if (emp.Contains("Rack_ID"))
{
item.Rack_ID = (emp["Rack_ID"].ToString());
}
if (emp.Contains("Hole_ID"))
{
item.Hole_ID = (emp["Hole_ID"].ToString());
}
if (emp.Contains("Tube_ID"))
{
item.Tube_ID = (emp["Tube_ID"].ToString());
}
if (emp.Contains("FileName"))
{
item.FileName = (emp["FileName"].AsString);
}
if (emp.Contains("Comments"))
{
item.Comments = (emp["Comments"].AsString);
}
if (emp.Contains("OrderName"))
{
item.OrderName = (emp["OrderName"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
#endregion
// ClaimReport_Server.Add(item);
}
}
if (Rack_ID != "")
{
query = new QueryDocument("Rack_ID", Rack_ID);
foreach (BsonDocument emp in employees.Find(query))
{
xmlDataSources item = new xmlDataSources();
#region 数据
if (emp.Contains("_id"))
{
item.Id = (emp["_id"].ToString());
}
if (emp.Contains("Rack_ID"))
{
item.Rack_ID = (emp["Rack_ID"].ToString());
}
if (emp.Contains("Hole_ID"))
{
item.Hole_ID = (emp["Hole_ID"].ToString());
}
if (emp.Contains("Tube_ID"))
{
item.Tube_ID = (emp["Tube_ID"].ToString());
}
if (emp.Contains("FileName"))
{
item.FileName = (emp["FileName"].AsString);
}
if (emp.Contains("Comments"))
{
item.Comments = (emp["Comments"].AsString);
}
if (emp.Contains("OrderName"))
{
item.OrderName = (emp["OrderName"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
#endregion
// ClaimReport_Server.Add(item);
}
}
var query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", "")));
if (kettext != "" && Rack_ID == "")
{
query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", "")), Query.Matches("Comments", kettext));
}
if (Rack_ID != "" && kettext == "")
{
query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", "")), Query.EQ("Rack_ID", Rack_ID));
}
if (Rack_ID != "" && kettext != "")
{
query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", "")), Query.EQ("Rack_ID", Rack_ID), Query.EQ("Comments", kettext));
}
foreach (BsonDocument emp in employees.Find(query1))
{
xmlDataSources item = new xmlDataSources();
#region 数据
if (emp.Contains("_id"))
{
item.Id = (emp["_id"].ToString());
}
if (emp.Contains("Rack_ID"))
{
item.Rack_ID = (emp["Rack_ID"].ToString());
}
if (emp.Contains("Hole_ID"))
{
item.Hole_ID = (emp["Hole_ID"].ToString());
}
if (emp.Contains("Tube_ID"))
{
item.Tube_ID = (emp["Tube_ID"].ToString());
}
if (emp.Contains("FileName"))
{
item.FileName = (emp["FileName"].AsString);
}
if (emp.Contains("Comments"))
{
item.Comments = (emp["Comments"].AsString);
}
if (emp.Contains("OrderName"))
{
item.OrderName = (emp["OrderName"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
#endregion
ClaimReport_Server.Add(item);
}
return(ClaimReport_Server);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
return(null);
throw ex;
}
#endregion
}
public void ChangeDB(string dbname)
{
_mongoDb = _mongoServer.GetDatabase(dbname);
_mongoCollection = _mongoDb.GetCollection <T>(_collectionName);
_gridFS = _mongoDb.GridFS;
}
public List <xmlDataSources> findALLXML_Server()
{
try
{
List <xmlDataSources> ClaimReport_Server = new List <xmlDataSources>();
MongoServer server = MongoServer.Create(connectionString);
MongoDatabase db1 = server.GetDatabase(DB_NAME);
MongoCollection collection1 = db1.GetCollection("KM_BiotechnologyXML_XmlData");
MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("KM_BiotechnologyXML_XmlData");
foreach (BsonDocument emp in employees.FindAll())
{
xmlDataSources item = new xmlDataSources();
#region 数据
if (emp.Contains("_id"))
{
item.Id = (emp["_id"].ToString());
}
if (emp.Contains("Rack_ID"))
{
item.Rack_ID = (emp["Rack_ID"].ToString());
}
if (emp.Contains("Hole_ID"))
{
item.Hole_ID = (emp["Hole_ID"].ToString());
}
if (emp.Contains("Tube_ID"))
{
item.Tube_ID = (emp["Tube_ID"].ToString());
}
if (emp.Contains("FileName"))
{
item.FileName = (emp["FileName"].AsString);
}
if (emp.Contains("Comments"))
{
item.Comments = (emp["Comments"].AsString);
}
if (emp.Contains("OrderName"))
{
item.OrderName = (emp["OrderName"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
#endregion
ClaimReport_Server.Add(item);
}
return(ClaimReport_Server);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
return(null);
throw ex;
}
}
/// <summary>
/// Initializes a new instance of <c>MongoDBRepositoryContext</c> class.
/// </summary>
/// <param name="settings">The <see cref="IMongoDbRepositoryContextSettings"/> instance which contains
/// the setting information for initializing the repository context.</param>
public MongoDbRepositoryContext(IMongoDbRepositoryContextSettings settings)
{
this._settings = settings;
_server = new MongoServer(settings.ServerSettings);
_database = _server.GetDatabase(settings.DatabaseName, settings.GetDatabaseSettings(_server));
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="connectionString"></param>
/// <param name="databaseName"></param>
public MongoDBSslAggregatorPersistor(string connectionString, string databaseName)
{
var connectionParts = connectionString.Split(',');
string nodes = string.Empty;
string username = string.Empty;
string password = string.Empty;
string certPath = string.Empty;
string userdb = string.Empty;
string cert = string.Empty;
string certPassword = string.Empty;
foreach (string connectionPart in connectionParts)
{
var nameValue = connectionPart.Split('=');
switch (nameValue[0].ToLower())
{
case "nodes":
nodes = nameValue[1];
break;
case "userdb":
userdb = nameValue[1];
break;
case "username":
username = nameValue[1];
break;
case "password":
password = nameValue[1];
break;
case "certpath":
certPath = nameValue[1];
break;
case "cert":
cert = nameValue[1];
break;
case "certpassword":
certPassword = nameValue[1];
break;
}
}
var mongoNodes = nodes.Split(';');
List <X509Certificate> certs = null;
if (!string.IsNullOrEmpty(certPath))
{
if (string.IsNullOrEmpty(certPassword))
{
certs = new List <X509Certificate>
{
new X509Certificate2(certPath)
};
}
else
{
certs = new List <X509Certificate>
{
new X509Certificate2(certPath, certPassword)
};
}
}
if (!string.IsNullOrEmpty(cert))
{
if (string.IsNullOrEmpty(certPassword))
{
certs = new List <X509Certificate>
{
new X509Certificate2(Convert.FromBase64String(cert))
};
}
else
{
certs = new List <X509Certificate>
{
new X509Certificate2(Convert.FromBase64String(cert), certPassword)
};
}
}
List <MongoCredential> credentials = null;
if (!string.IsNullOrEmpty(username))
{
string db = "admin";
if (!string.IsNullOrEmpty(userdb))
{
db = userdb;
}
credentials = new List <MongoCredential>
{
MongoCredential.CreateCredential(db, username, password)
};
}
var settings = new MongoClientSettings
{
UseSsl = true,
Credentials = credentials,
ConnectionMode = ConnectionMode.Automatic,
Servers = mongoNodes.Select(x => new MongoServerAddress(x)),
SslSettings = new SslSettings
{
ClientCertificates = certs,
ClientCertificateSelectionCallback = (sender, host, certificates, certificate, issuers) => certificates[0],
CheckCertificateRevocation = false
}
};
var client = new MongoClient(settings);
MongoServer server = client.GetServer();
var mongoDatabase = server.GetDatabase(databaseName);
_collection = mongoDatabase.GetCollection <MongoDbSslData <object> >("Aggregator");
}
public Baza()
{
_client = new MongoClient("mongodb://localhost:27017");
_server = _client.GetServer();
_db = _server.GetDatabase("portal");
}
static void Main(string[] args)
{
Console.WriteLine("Connect...");
MongoServer mongo = MongoServer.Create();
mongo.Connect();
Console.WriteLine("Connected"); Console.WriteLine();
var db = mongo.GetDatabase("tutorial");
using (mongo.RequestStart(db))
{
var collection = db.GetCollection <BsonDocument>("books");
BsonDocument book = new BsonDocument()
.Add("_id", BsonValue.Create(BsonType.ObjectId))
.Add("author", "Ernest Hemingway")
.Add("title", "For Whom the Bell Tolls");
collection.Insert(book);
var query = new QueryDocument("author", "Ernest Hemingway");
foreach (BsonDocument item in collection.Find(query))
{
string json = item.ToJson();
Console.WriteLine(json);
Console.WriteLine();
JToken token = JToken.Parse(json);
token.SelectToken("title").Replace("some other title");
Console.WriteLine("Author: {0}, Title: {1}", token.SelectToken("author"), token.SelectToken("title"));
Console.WriteLine();
XNode node = JsonConvert.DeserializeXNode(json, "documents");
Console.WriteLine("Node:");
Console.WriteLine(node);
Console.WriteLine();
BsonElement author = item.GetElement("author");
BsonElement title = item.GetElement("title");
foreach (BsonElement element in item.Elements)
{
Console.WriteLine("Name: {0}, Value: {1}", element.Name, element.Value);
}
Console.WriteLine();
Console.WriteLine("Author: {0}, Title: {1}", author.Value, title.Value);
}
}
Console.WriteLine();
Console.Read();
mongo.Disconnect();
}
public MongoCollection getCollection(string dbName, string collectionName)
{
MongoDatabase db = server.GetDatabase(dbName);
return(db.GetCollection(collectionName));
}
public MongoConnectionManager()
{
_client = new MongoClient("mongodb://localhost:27017");
_server = _client.GetServer();
_db = _server.GetDatabase("PeopleDB");
}
public DataAccessProducto()
{
_client = new MongoClient("mongodb://localhost:27017");
_server = _client.GetServer();
_db = _server.GetDatabase("POSDB");
}
static void Main(string[] args)
{
// TO DO: Add your code here
int days = 20;
DateTime curDate = new DateTime(2017, 1, 30);
DateTime beginDate = curDate.AddDays(-1 * days);
DateTime endDate = curDate;
MongoClient client = new MongoClient("mongodb://localhost:27017");
MongoServer server = client.GetServer();
MongoDatabase database = server.GetDatabase("finance");
BsonElement[] eleArray = new BsonElement[1];
BsonDocument temp = new BsonDocument(new BsonElement[] { new BsonElement("$lt", endDate.ToString("yyyy-MM-dd")),
new BsonElement("$gte", beginDate.ToString("yyyy-MM-dd")) });
eleArray[0] = new BsonElement("date", temp);
Console.WriteLine(eleArray[0]);
QueryDocument query = new QueryDocument(eleArray);
Dictionary <string, int> plateCount = new Dictionary <string, int>();
MongoCollection <BsonDocument> collection = database.GetCollection <BsonDocument>("LeaderPlates");
foreach (BsonDocument document in collection.Find(query))
{
BsonValue bsonValue = null;
if (!document.TryGetValue("plates", out bsonValue))
{
continue;
}
if (bsonValue == null)
{
continue;
}
BsonArray plates = (BsonArray)bsonValue;
foreach (BsonValue plate in plates)
{
string name = (string)plate;
if (!plateCount.ContainsKey(name))
{
plateCount.Add(name, 1);
}
else
{
plateCount[name]++;
}
}
}
plateCount = SortDictionary_Desc(plateCount);
List <string> leaderPlates = new List <string>();
int k = 0;
int lastCount = 0;
foreach (KeyValuePair <string, int> kvp in plateCount)
{
k++;
if ((k > 3) && (kvp.Value < lastCount))
{
break;
}
Console.WriteLine("symbol:{0},count:{1}", kvp.Key, kvp.Value);
leaderPlates.Add(kvp.Key);
lastCount = kvp.Value;
}
BsonArray plateArray = new BsonArray(leaderPlates.Count);
foreach (string plate in leaderPlates)
{
plateArray.Add(plate);
}
BsonElement[] eleArray1 = new BsonElement[2];
eleArray1[0] = new BsonElement("date", temp);
temp = new BsonDocument(new BsonElement("$in", plateArray));
eleArray1[1] = new BsonElement("industry", temp);
Console.WriteLine("条件1：{0}，条件2：{1}", eleArray1[0], eleArray1[1]);
QueryDocument query1 = new QueryDocument(eleArray1);
List <BsonDocument> listBD = new List <BsonDocument>();
MongoCollection <BsonDocument> collection1 = database.GetCollection <BsonDocument>("IndustriesUpLimitStatis");
foreach (BsonDocument document in collection1.Find(query1))
{
listBD.Add(document);
}
eleArray1[1] = new BsonElement("area", temp);
Console.WriteLine("条件1：{0}，条件2：{1}", eleArray1[0], eleArray1[1]);
query1 = new QueryDocument(eleArray1);
collection1 = database.GetCollection <BsonDocument>("AreasUpLimitStatis");
foreach (BsonDocument document in collection1.Find(query1))
{
listBD.Add(document);
}
eleArray1[1] = new BsonElement("concept", temp);
Console.WriteLine("条件1：{0}，条件2：{1}", eleArray1[0], eleArray1[1]);
query1 = new QueryDocument(eleArray1);
collection1 = database.GetCollection <BsonDocument>("ConceptsUpLimitStatis");
foreach (BsonDocument document in collection1.Find(query1))
{
listBD.Add(document);
}
Console.WriteLine(listBD.Count);
Dictionary <string, List <string> > securityUpLimitStatis = new Dictionary <string, List <string> >();
foreach (BsonDocument document in listBD)
{
BsonArray documentArray = (BsonArray)document["securities"];
foreach (BsonDocument subDocument in documentArray)
{
string symbol = (string)subDocument["symbol"];
string time = (string)subDocument["time"];
List <string> ls = null;
if (!securityUpLimitStatis.TryGetValue(symbol, out ls))
{
ls = new List <string>();
securityUpLimitStatis.Add(symbol, ls);
}
if (!ls.Contains(time))
{
ls.Add(time);
}
}
}
Dictionary <string, int> securityUpLimitCount = new Dictionary <string, int>();
foreach (KeyValuePair <string, List <string> > kvp in securityUpLimitStatis)
{
securityUpLimitCount.Add(kvp.Key, kvp.Value.Count);
}
securityUpLimitCount = SortDictionary_Desc(securityUpLimitCount); //降序排序
foreach (KeyValuePair <string, int> kvp in securityUpLimitCount)
{
Console.WriteLine("symbol:{0},count:{1}", kvp.Key, kvp.Value);
}
}
private void okPicture_Click(object sender, EventArgs e)
{
try
{
MongoClient client = new MongoClient("mongodb://*****:*****@ds141902.mlab.com:41902/ox");
MongoServer server = client.GetServer();
MongoDatabase database = server.GetDatabase("ox");
MongoCollection mongoCollection = database.GetCollection <User>("User");
User user = new User();
BindingList <User> doclist = new BindingList <User>();
var getCollection = database.GetCollection <User>("User");
var insertUser = getCollection.AsQueryable().Where(pd => pd.Username == Username.Text);
foreach (var p in insertUser)
{
doclist.Add(p);
Application.DoEvents();
}
dataGridView1.DataSource = doclist;
if (dataGridView1.Rows.Count == 0)
{
if (!string.IsNullOrEmpty(Username.Text.Trim()) && !Username.Text.Equals("Username"))
{
user.Username = Username.Text;
}
else
{
MessageBox.Show("กรุณากรอกUsername");
}
if (!string.IsNullOrEmpty(Password.Text.Trim()) && !Password.Text.Equals("Password"))
{
user.Password = Password.Text;
}
else
{
MessageBox.Show("กรุณากรอกPassword");
}
if (!string.IsNullOrEmpty(User.Text.Trim()) && !User.Text.Equals("Name"))
{
user.Name = User.Text;
}
else
{
MessageBox.Show("กรุณากรอกName");
}
user.Avatar = null;
user.Win = 0;
user.Draw = 0;
user.Lose = 0;
if (!string.IsNullOrEmpty(Username.Text.Trim()) &&
!string.IsNullOrEmpty(Password.Text.Trim()) &&
!string.IsNullOrEmpty(User.Text.Trim()) &&
(!Username.Text.Equals("Username") &&
!Password.Text.Equals("Password") &&
!User.Text.Equals("Name")))
{
mongoCollection.Insert(user);
MessageBox.Show("สมัครเสร็จสิ้น");
}
else
{
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
}
}
protected override bool doJob()
{
Console.WriteLine("正在读取Tick数据生成涨停板数据分析表...");
/*Console.WriteLine("测试作业.........");
* return true;*/
try {
GMRealTimeProvider provider = (GMRealTimeProvider)ProviderManager.MarketDataProviders["GMRealTimeProvider"];
provider.Connect(10000);
if (!provider.IsConnected)
{
return(false);
}
string path = this.dataPath + "/" + this.curDate.Year.ToString() + "/" + this.curDate.Month.ToString();
if (!Directory.Exists(path))
{
Console.WriteLine("Trade数据目录不存在！");
return(false);
}
string dateString = this.curDate.ToString("yyyy-MM-dd");
List <AnalysisItem> analysisList = new List <AnalysisItem>();
DataFile file = null;
try {
file = DataFile.Open(path);
foreach (Instrument inst in InstrumentManager.Instruments)
{
if (inst.SecurityDesc.IndexOf("B") >= 0)
{
continue; //除去B股
}
if (inst.SecurityType == "IDX")
{
continue; //除去指数
}
FileSeries dailySeries = (FileSeries)inst.GetDataSeries(DataManager.EDataSeries.Daily);
if (dailySeries == null || dailySeries.Count <= 0)
{
continue;
}
int i = dailySeries.IndexOf(this.curDate);
if (i < 0)
{
continue; //没有日线，当日不开盘
}
i = i - 10 > 0?i - 10:0; //往前推10个交易日
DateTime firstDate = dailySeries[i].DateTime;
ISeriesObject[] dailys = dailySeries.GetArray(firstDate, this.curDate);
int k = dailys.Length - 1;
GMDaily gmDaily = (GMDaily)dailys[k];
if (gmDaily.Close / gmDaily.LastClose > 1.095) //今日涨停
{
AnalysisItem ai = new AnalysisItem();
ai.Date = gmDaily.DateTime;
ai.Symbol = inst.Symbol;
GMSDK.ShareIndex si = null;
//先读取当日股本，如果没有，则读取最近股本。一般情况下当日股本与最近股本相同，除非当天正好是除权日
List <GMSDK.ShareIndex> shareIndexList = provider.MdApi.GetShareIndex(ai.Symbol, dateString, dateString);
if (shareIndexList.Count <= 0)
{
shareIndexList = provider.MdApi.GetLastShareIndex(ai.Symbol);
}
if (shareIndexList.Count > 0)
{
si = shareIndexList[0];
}
if (si != null)
{
ai.FlowAShare = si.flow_a_share;
}
else
{
ai.FlowAShare = 0.0;
}
ai.LastClose = gmDaily.LastClose;
ai.Open = gmDaily.Open;
ai.High = gmDaily.High;
ai.Low = gmDaily.Low;
ai.Close = gmDaily.Close;
//换手率
if (ai.FlowAShare > 0)
{
ai.TurnoverRate = gmDaily.Volume / ai.FlowAShare * 100;
}
else
{
ai.TurnoverRate = 0.0;
}
//当日量与前5日均量比
int m = k - 1;
double sumVol = 0.0;
while (m >= 0 && m >= k - 5)
{
sumVol += ((Daily)dailys[m]).Volume;
m--;
}
double last5AvgVol = sumVol / (k - m - 1);
ai.VolDivLast5AvgVol = gmDaily.Volume / last5AvgVol;
//计算封板时间、时长等
bool flag = false;
string name = inst.Symbol + ".Trade";
if (!file.Series.Contains(name))
{
continue;
}
FileSeries series = file.Series[name];
ISeriesObject[] trades = series.GetArray(gmDaily.DateTime, gmDaily.DateTime.AddDays(1));
if (trades.Length <= 0)
{
continue;
}
GMTrade gmLastTrade = (GMTrade)trades[trades.Length - 1]; //最后一笔交易数据
if (gmLastTrade.Price < gmLastTrade.UpperLimit)
{
continue;
}
GMTrade lastGMTrade = null;
DateTime openTimeAM = gmDaily.Date.Add(new TimeSpan(9, 25, 0));
DateTime openTimePM = gmDaily.Date.Add(new TimeSpan(13, 0, 0));
foreach (ISeriesObject aTrade in trades)
{
GMTrade gmTrade = (GMTrade)aTrade;
if (!flag && gmTrade.Price == gmTrade.UpperLimit && gmTrade.DateTime >= openTimeAM)
{
ai.WhenUpLimit = gmTrade.DateTime - ai.Date;
flag = true;
}
if (flag && gmTrade.Price < gmTrade.UpperLimit)
{
ai.UpLimitBreaked = true;
}
//将下午13：00之后的每笔时间减去90分钟，这样便于计算封涨停的时长
if (gmTrade.DateTime >= openTimePM)
{
gmTrade.DateTime = gmTrade.DateTime.AddMinutes(-90);
}
if (flag && lastGMTrade != null && gmTrade.Price == gmTrade.UpperLimit && lastGMTrade.Price == gmTrade.UpperLimit)
{
ai.HowLongUpLimit += gmTrade.DateTime - lastGMTrade.DateTime;
}
if (flag)
{
lastGMTrade = gmTrade;
}
}
//封成比
name = inst.Symbol + ".Quote";
if (!file.Series.Contains(name))
{
continue;
}
series = file.Series[name];
ISeriesObject[] quotes = series.GetArray(gmDaily.DateTime, gmDaily.DateTime.AddDays(1));
if (quotes.Length <= 0)
{
continue;
}
GMQuote gmLastQuote = (GMQuote)quotes[quotes.Length - 1]; //最后一刻报价数据
ai.BidSizeDivVol = (double)gmLastQuote.BidSize / gmDaily.Volume;
if (k > 0)
{
GMDaily lastGMDaily = (GMDaily)dailys[k - 1];
if (lastGMDaily.Close / lastGMDaily.LastClose >= 1.099)
{
ai.LastUpLimited = true;
}
}
if (flag)
{
analysisList.Add(ai);
}
}
}
}catch (Exception ex) {
throw ex;
}finally{
file.Close();
}
Console.WriteLine("今日共有{0}只涨停。", analysisList.Count);
foreach (AnalysisItem ai in analysisList)
{
Console.WriteLine(@"Date:{0},Symbol:{1},昨收价:{2},昨日是否涨停:{3},开盘价:{4},
最高价:{5},最低价:{6},收盘价:{7},涨停时间:{8},是否开板:{9},涨停时长:{10},
成交量与昨日5日均量比:{11},收盘买一量与成交量比:{12},流通A股:{13},换手率:{14}" ,
ai.Date, ai.Symbol, ai.LastClose, ai.LastUpLimited, ai.Open, ai.High, ai.Low, ai.Close,
ai.WhenUpLimit, ai.UpLimitBreaked, ai.HowLongUpLimit, ai.VolDivLast5AvgVol, ai.BidSizeDivVol,
ai.FlowAShare, ai.TurnoverRate);
}
MongoClient client = new MongoClient("mongodb://localhost:27017");
MongoServer server = client.GetServer();
MongoDatabase database = server.GetDatabase("finance");
MongoCollection <BsonDocument> collection = database.GetCollection <BsonDocument>("UpLimitAnalysis");
foreach (AnalysisItem ai in analysisList)
{
BsonElement[] eleArray = new BsonElement[2];
eleArray[0] = new BsonElement("date", ai.Date.ToString("yyyy-MM-dd"));
eleArray[1] = new BsonElement("symbol", ai.Symbol);
QueryDocument query = new QueryDocument(eleArray);
collection.Remove(query);
BsonElement[] eleArray1 = new BsonElement[19];
eleArray1[0] = new BsonElement("date", ai.Date.ToString("yyyy-MM-dd"));
eleArray1[1] = new BsonElement("symbol", ai.Symbol);
eleArray1[2] = new BsonElement("flowashare", ai.FlowAShare);
eleArray1[3] = new BsonElement("lastclose", ai.LastClose);
eleArray1[4] = new BsonElement("lastuplimited", ai.LastUpLimited);
eleArray1[5] = new BsonElement("open", ai.Open);
eleArray1[6] = new BsonElement("high", ai.High);
eleArray1[7] = new BsonElement("low", ai.Low);
eleArray1[8] = new BsonElement("close", ai.Close);
eleArray1[9] = new BsonElement("whenuplimit", ai.WhenUpLimit.ToString());
eleArray1[10] = new BsonElement("uplimitbreaked", ai.UpLimitBreaked);
eleArray1[11] = new BsonElement("howlonguplimit", ai.HowLongUpLimit.ToString());
eleArray1[12] = new BsonElement("turnoverrate", ai.TurnoverRate);
eleArray1[13] = new BsonElement("voldivlast5avgvol", ai.VolDivLast5AvgVol);
eleArray1[14] = new BsonElement("bidsizedivvol", ai.BidSizeDivVol);
BsonDocument insert = new BsonDocument(eleArray1);
collection.Insert(insert);
}
return(true);
}catch (Exception ex) {
Console.WriteLine(ex.Message);
}
return(false);
}
static void simpleMongoDBUse()
{
string _connectionString = "Server=127.0.0.1";
string _dbName = "MyNorthwind";
string collectionName = "collectionName";
// MongoServer server =MongoServer.Create(_connectionString);
// MongoDatabase mongoDatabase = server.GetDatabase(_dbName);
//MongoCollection<BsonDocument> collection = mongoDatabase.GetCollection<BsonDocument>(collectionName);
//BsonDocument dom = new BsonDocument { { "CustomerName", "niezl" }, { "Address", "cnki" }, { "Tel", "12580" } };
MongoClient mongoclient = new MongoClient(_connectionString);
MongoServer server = mongoclient.GetServer();
MongoDatabase mongoDatabase = server.GetDatabase(_dbName);
MongoCollection <Customer> collection = mongoDatabase.GetCollection <Customer>(collectionName);
List <Customer> customerlist = new List <Customer>()
{
new Customer()
{
CustomerName = "xiaojie", Address = "_cnki", Tel = "12306"
},
new Customer()
{
CustomerName = "niezl", Address = "cnki", Tel = "12580"
}
};
Customer customer = new Customer()
{
CustomerName = "niezl", Address = "cnki", Tel = "12580"
};
Dictionary <string, List <Customer> > dic = new Dictionary <string, List <Customer> >();
dic.Add("Customer", customerlist);
//BsonDocument dom = new BsonDocument(dic);
//BsonDocument dom = customerlist.ToBsonDocument<List<Customer>>();
IMongoUpdate newdom = Update.Set("Address", "new_cnki");
IMongoQuery iq = new QueryDocument("CustomerName", "niezl");
IMongoQuery iqand = Query.And(Query.GTE("Tel", "12580"), Query.Matches("CustomerName", "/^nie/"));
try
{
// collection.Insert(dom);
//consoleBsonDocument(collection.Find(iq));
//collection.Update(iq,newdom);
//consoleBsonDocument(collection.Find(iq));
//collection.Remove(iq);
//consoleBsonDocument(collection.Find(iq));
// collection.Insert(customer);
collection.Update(iq, newdom);
var bsoncursor = collection.Find(iqand);
foreach (Customer bson in bsoncursor)
{
Console.WriteLine("CustomerName:" + bson.CustomerName);
Console.WriteLine("Address:" + bson.Address);
Console.WriteLine("Tel:" + bson.Tel);
}
}
catch (Exception e)
{
server.Disconnect();
}
finally {
server.Disconnect();
}
}
public void setUp()
{
if (!Directory.Exists("resource"))
{
Directory.CreateDirectory("resource");
}
object_id1 = Guid.NewGuid();
object_id2 = Guid.NewGuid();
FileStream fs = File.Open("resource/" + object_id1.ToString() + ".png", FileMode.Create);
using (StreamWriter w = new StreamWriter(fs))
{
w.Write("1234567890");
}
fs.Close();
fs = File.Open("resource/" + object_id1.ToString() + "_medium.jpeg", FileMode.Create);
using (StreamWriter w = new StreamWriter(fs))
{
w.Write("abcde");
}
fs.Close();
MongoDatabase db = mongodb.GetDatabase("wammer");
if (db.CollectionExists("attachments"))
{
db.Drop();
}
db.CreateCollection("attachments");
db.GetCollection <Attachment>("attachments").Insert(new Attachment
{
object_id = object_id1.ToString(),
group_id = "group1",
mime_type = "image/png",
file_size = 10,
image_meta = new ImageProperty
{
medium = new ThumbnailInfo
{
mime_type = "image/jpeg",
file_size = 5
}
}
});
db.GetCollection <Attachment>("attachments").Insert(new Attachment
{
object_id = object_id2.ToString(),
type = AttachmentType.image,
image_meta = new ImageProperty
{
medium = new ThumbnailInfo
{
mime_type = "image/jpeg",
file_size = 5
}
}
});
DriverCollection.Instance.Save(
new Driver
{
email = "*****@*****.**",
user_id = "driver1_id",
folder = "resource",
groups = new List <UserGroup>
{
new UserGroup {
group_id = "group1",
description = "group1 descript",
creator_id = "driver1_id",
name = "group1"
}
}
}
);
}
public BookRepository()
{
_client = new MongoClient("mongodb://localhost:27017");
_server = _client.GetServer();
_db = _server.GetDatabase("BookDB");
}
public void DoTest()
{
// ------------------------------
// 步骤一. 取得一个 MongoClient 对象.
// ------------------------------
// mongoDB 的 mongos 运行在 192.168.253.78:30000 端口上.
// mongoDB 的3个片 安装在 mongo01 / mongo02 / mongo03 这3台虚拟机上.
// 因为分片对 最终客户端， 是不可见的。
// 因此这里的 连接字符串， 仅仅包含 mongos 的地址信息.
//string connectionString = "mongodb://192.168.253.78:30000";
//MongoClient client = new MongoClient(connectionString);
// 下面这种情况, 是用于多个 mongos 进程的情况.
MongoClientSettings setting = new MongoClientSettings();
setting.ConnectionMode = ConnectionMode.ShardRouter;
setting.Servers = new List <MongoServerAddress>()
{
new MongoServerAddress("192.168.253.78", 30000),
new MongoServerAddress("192.168.253.78", 30001)
};
MongoClient client = new MongoClient(setting);
// ------------------------------
// 步骤二. 取得一个 MongoServer 对象.
// ------------------------------
// Get a Reference to a Server Object
MongoServer server = client.GetServer();
// ------------------------------
// 步骤三. 取得一个 MongoDatabase 对象.
// ------------------------------
// Get a Reference to a Database Object
MongoDatabase database = server.GetDatabase("test"); // "test" is the name of the database
// ------------------------------
// 步骤四. 取得一个 MongoCollection 对象.
// ------------------------------
// Get a Reference to a Collection Object
// "TestMain" is the name of the collection
MongoCollection <TestBasic> collection = database.GetCollection <TestBasic>("TestBasic");
// ------------------------------
// 步骤五. 完成 插入的相关操作.
// ------------------------------
for (int i = 0; i < 100000; i++)
{
TestBasic mainData = new TestBasic()
{
Name = String.Format("C# 访问 MongoDB 的例子代码 {0} : {1:yyyy-MM-dd HH:mm:ss} ", i, DateTime.Now)
};
// 完成插入处理.
collection.Insert(mainData);
}
Console.WriteLine("数据 已插入到 MongoDB");
Console.WriteLine("请到命令行方式下执行 db.TestBasic.find() 核对数据！");
Console.WriteLine("请到命令行方式下执行 db.printShardingStatus() 核对数据！");
Console.WriteLine("按回车键结束测试...");
Console.ReadLine();
}
public void TestFixtureSetUp()
{
_client = new MongoClient();
_server = _client.GetServer();
_database = _server.GetDatabase("database");
}
public void update_OrderServer(List <xmlDataSources> AddMAPResult)
{
MongoServer server = MongoServer.Create(connectionString);
MongoDatabase db1 = server.GetDatabase(DB_NAME);
MongoCollection collection1 = db1.GetCollection("KM_BiotechnologyXML_XmlData");
MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("KM_BiotechnologyXML_XmlData");
// collection1.RemoveAll();
if (AddMAPResult == null)
{
MessageBox.Show("No Data input Sever", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
foreach (xmlDataSources item in AddMAPResult)
{
IMongoQuery query = Query.EQ("_id", new ObjectId(item.Id));
#region 集合
var update = Update.Set("Rack_ID", item.Rack_ID.Trim());
collection1.Update(query, update);
if (item.Hole_ID == null)
{
item.Hole_ID = "";
}
update = Update.Set("Hole_ID", item.Hole_ID);
collection1.Update(query, update);
if (item.Tube_ID == null)
{
item.Tube_ID = "";
}
update = Update.Set("Tube_ID", item.Tube_ID);
collection1.Update(query, update);
if (item.FileName == null)
{
item.FileName = "";
}
update = Update.Set("FileName", item.FileName);
collection1.Update(query, update);
if (item.Input_Date == null)
{
item.Input_Date = "";
}
update = Update.Set("Input_Date", item.Input_Date);
collection1.Update(query, update);
if (item.Comments == null)
{
item.Comments = "";
}
update = Update.Set("Comments", item.Comments);
collection1.Update(query, update);
if (item.OrderName == null)
{
item.OrderName = "";
}
update = Update.Set("OrderName", item.OrderName);
collection1.Update(query, update);
#endregion
}
}
public virtual void SetupFixture()
{
_server = MongoServer.Create("mongodb://localhost");
_database = _server.GetDatabase("test");
}
public MongoContext() //constructor
{
_client = new MongoClient("mongodb://*****:*****@ds149433.mlab.com:49433/corevisesdb");
_server = _client.GetServer();
_database = _server.GetDatabase("corevisesdb");
}
public static void Connect()
{
Console.WriteLine("Mongo DB Test Application");
Console.WriteLine("====================================================");
Console.WriteLine("Started By:Kailash Chandra Behera");
Console.WriteLine("Started On: 14 July 2014");
Console.WriteLine("Configuration Setting: 172.16.1.24:27017");
Console.WriteLine("====================================================");
Console.WriteLine("Initializaing connection");
string connectionString = "mongodb://localhost:27017";
Console.WriteLine("Creating Client..........");
MongoClient client = null;
try
{
client = new MongoClient(connectionString);
Console.WriteLine("Client Created Successfuly........");
Console.WriteLine("Client: " + client.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Filed to Create Client.......");
Console.WriteLine(ex.Message);
}
Console.WriteLine("Initianting Mongo Db Server.......");
MongoServer server = null;
try
{
Console.WriteLine("Getting Servicer object......");
server = client.GetServer();
Console.WriteLine("Server object created Successfully....");
Console.WriteLine("Server :" + server.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Filed to getting Server Details");
Console.WriteLine(ex.Message);
}
Console.WriteLine("Initianting Mongo Databaser.........");
MongoDatabase database = null;
try
{
Console.WriteLine("Getting reference of database.......");
database = server.GetDatabase("kara_db");
Console.WriteLine("Database Name : " + database.Name);
}
catch (Exception ex)
{
Console.WriteLine("Failed to Get reference of Database");
Console.WriteLine("Error :" + ex.Message);
}
try
{
Console.WriteLine("Deleteing Collection Symbol");
database.DropCollection("Symbol");
}
catch (Exception ex)
{
Console.WriteLine("Failed to delete collection from Database");
Console.WriteLine("Error :" + ex.Message);
}
Console.WriteLine("Getting Collections from database Database.......");
MongoCollection symbolcollection = null;
try
{
symbolcollection = database.GetCollection <Symbol>("Symbols");
Console.WriteLine(symbolcollection.Count().ToString());
}
catch (Exception ex)
{
Console.WriteLine("Failed to Get collection from Database");
Console.WriteLine("Error :" + ex.Message);
}
ObjectId id = new ObjectId();
Console.WriteLine("Inserting document to collection............");
try
{
Symbol symbol = new Symbol();
symbol.Name = "Star";
symbolcollection.Insert(symbol);
id = symbol.ID;
Console.WriteLine(symbolcollection.Count().ToString());
}
catch (Exception ex)
{
Console.WriteLine("Failed to insert into collection of Database " + database.Name);
Console.WriteLine("Error :" + ex.Message);
}
try
{
//Console.WriteLine("Preparing Query Document............");
//List<Symbol> query = symbolcollection.AsQueryable<Entity>().Where<Entity>(sb => sb.Name == "Kailash").ToList();
//Symbol symbol = symbolcollection.AsQueryable<Entity>().Where<Entity>(sb => sb.ID == id).ToList();
}
catch (Exception ex)
{
Console.WriteLine("Failed to query from collection");
Console.WriteLine("Exception :" + ex.Message);
}
}
static void Main(string[] args)
{
// TO DO: Add your code here
DateTime beginDate = new DateTime(2017, 3, 24);
DateTime endDate = new DateTime(2017, 3, 25);
MongoClient client = new MongoClient("mongodb://localhost:27017");
MongoServer server = client.GetServer();
MongoDatabase database = server.GetDatabase("finance");
string username = "******";
string password = "******";
int ret = _md.Init(username, password, GMSDK.MDMode.MD_MODE_NULL, "", "", "");
if (ret != 0)
{
string msg = _md.StrError(ret);
Console.WriteLine(msg);
return;
}
DateTime curDate = beginDate;
//获取交易日历，以确定是否开市日
string dateString1 = "";
if (endDate.AddMonths(-1) > beginDate)
{
dateString1 = beginDate.ToString("yyyy-MM-dd");
}
else
{
dateString1 = endDate.AddMonths(-1).ToString("yyyy-MM-dd");
}
string dateString2 = endDate.AddDays(1).ToString("yyyy-MM-dd");
List <DateTime> tradeDates = GetTradeDates("SHSE", dateString1, dateString2);
while (curDate < endDate)
{
Console.WriteLine("日期：" + curDate.ToString("yyyy-MM-dd"));
if ((tradeDates.Count <= 0) || (!tradeDates.Contains(curDate)))
{
Console.WriteLine("今天不是交易日");
curDate = curDate.AddDays(1);
continue;
}
string monthString = curDate.ToString("yyyy-MM");
//区域统计数据准备
MongoCollection <BsonDocument> collection = database.GetCollection <BsonDocument>("Areas." + monthString);
Dictionary <string, List <string> > areaDict = new Dictionary <string, List <string> >();
foreach (BsonDocument document in collection.FindAll())
{
List <string> ls = null;
if (!areaDict.TryGetValue((string)document["code"], out ls))
{
ls = new List <string>();
areaDict.Add((string)document["code"], ls);
}
if (!(document["area"] is BsonNull))
{
ls.Add((string)document["area"]);
}
}
Dictionary <string, StatisItem> areaUpLimitStatis = new Dictionary <string, StatisItem>();
//行业统计数据准备
collection = database.GetCollection <BsonDocument>("Industries." + monthString);
Dictionary <string, List <string> > industryDict = new Dictionary <string, List <string> >();
foreach (BsonDocument document in collection.FindAll())
{
List <string> ls = null;
if (!industryDict.TryGetValue((string)document["code"], out ls))
{
ls = new List <string>();
industryDict.Add((string)document["code"], ls);
}
if (!(document["c_name"] is BsonNull))
{
ls.Add((string)document["c_name"]);
}
}
Dictionary <string, StatisItem> industryUpLimitStatis = new Dictionary <string, StatisItem>();
//概念统计数据准备
collection = database.GetCollection <BsonDocument>("Concepts." + monthString);
Dictionary <string, List <string> > conceptDict = new Dictionary <string, List <string> >();
foreach (BsonDocument document in collection.FindAll())
{
List <string> ls = null;
if (!conceptDict.TryGetValue((string)document["code"], out ls))
{
ls = new List <string>();
conceptDict.Add((string)document["code"], ls);
}
if (!(document["c_name"] is BsonNull))
{
ls.Add((string)document["c_name"]);
}
}
Dictionary <string, StatisItem> conceptUpLimitStatis = new Dictionary <string, StatisItem>();
//找出日线当天接近涨停股
List <Instrument> toUpLimit = new List <Instrument>();
foreach (Instrument instrument in InstrumentManager.Instruments)
{
if (instrument.SecurityType == "CS" && instrument.SecurityDesc.IndexOf('B') < 0)
{
DailySeries series = instrument.GetDailySeries(curDate.AddMonths(-3), curDate);
//下面这里要求日线数大于20，是为了排除新股
if (series.Count > 20)
{
GMDaily gmDaily = (GMDaily)series[series.Count - 1]; //最近一天的日线
if (gmDaily.Date != curDate)
{
continue;
}
//下面是对于st,*st的，因为名字判断不准确，故去掉
//if ((instrument.SecurityDesc.IndexOf("ST")>=0||instrument.SecurityDesc.IndexOf('S')>=0)
//&&(gmDaily.Close/gmDaily.LastClose>1.044)){
// toUpLimit.Add(instrument);
//}
//下面是对于普通股
if (gmDaily.Close / gmDaily.LastClose > 1.094)
{
toUpLimit.Add(instrument);
}
}
}
}
//读出Trade数据，确定是否真的涨停及涨停时间，交统计数据
string dataPath = "e:/QDData";
string path = dataPath + "/" + curDate.Year.ToString() + "/" + curDate.Month.ToString();
if (!Directory.Exists(path))
{
Console.WriteLine("Trade数据目录不存在！");
return;
}
try {
DataFile file = DataFile.Open(path);
try {
foreach (Instrument instrument in toUpLimit)
{
string name = instrument.Symbol + ".Trade";
if (!file.Series.Contains(name))
{
throw new Exception(instrument.Symbol + "的Trade数据不存在，请补充完整。");
}
FileSeries series = file.Series[name];
ISeriesObject[] trades = series.GetArray(curDate, curDate.AddDays(1));
if (trades.Length <= 0)
{
continue;
}
GMTrade gmLastTrade = (GMTrade)trades[trades.Length - 1]; //最后一笔交易数据
if (gmLastTrade.Price < gmLastTrade.UpperLimit)
{
continue;
}
foreach (ISeriesObject aTrade in trades)
{
GMTrade gmTrade = (GMTrade)aTrade;
if (gmTrade.Price == gmTrade.UpperLimit && gmTrade.DateTime >= curDate.Add(new TimeSpan(9, 25, 0)))
{
Console.WriteLine(instrument.Symbol + instrument.SecurityDesc + "在" + gmTrade.DateTime + "时涨停");
//区域统计
if (areaDict.ContainsKey(instrument.SecurityID))
{
List <string> areaList = areaDict[instrument.SecurityID];
foreach (string area in areaList)
{
StatisItem si = null;
if (!areaUpLimitStatis.TryGetValue(area, out si))
{
si = new StatisItem();
areaUpLimitStatis.Add(area, si);
}
si.AddSymbol(instrument.Symbol, gmTrade.DateTime);
}
}
//行业统计
if (industryDict.ContainsKey(instrument.SecurityID))
{
List <string> industryList = industryDict[instrument.SecurityID];
foreach (string industry in industryList)
{
StatisItem si = null;
if (!industryUpLimitStatis.TryGetValue(industry, out si))
{
si = new StatisItem();
industryUpLimitStatis.Add(industry, si);
}
si.AddSymbol(instrument.Symbol, gmTrade.DateTime);
}
}
//概念统计
if (conceptDict.ContainsKey(instrument.SecurityID))
{
List <string> conceptList = conceptDict[instrument.SecurityID];
foreach (string concept in conceptList)
{
StatisItem si = null;
if (!conceptUpLimitStatis.TryGetValue(concept, out si))
{
si = new StatisItem();
conceptUpLimitStatis.Add(concept, si);
}
si.AddSymbol(instrument.Symbol, gmTrade.DateTime);
}
}
break;
}
}
}
}catch (Exception ex) {
throw ex;
}
finally{
file.Close();
}
//区域统计写入数据库
MongoCollection <BsonDocument> collection1 = database.GetCollection <BsonDocument>("AreasUpLimitStatis");
BsonElement[] eleArray = new BsonElement[1];
eleArray[0] = new BsonElement("date", curDate.ToString("yyyy-MM-dd"));
QueryDocument query = new QueryDocument(eleArray);
collection1.Remove(query);
foreach (KeyValuePair <string, StatisItem> kvp in areaUpLimitStatis)
{
BsonElement[] eleArray1 = new BsonElement[4];
eleArray1[0] = new BsonElement("date", curDate.ToString("yyyy-MM-dd"));
eleArray1[1] = new BsonElement("area", kvp.Key);
eleArray1[2] = new BsonElement("count", kvp.Value.Count);
BsonArray bsonArray = new BsonArray(kvp.Value.Count);
foreach (KeyValuePair <string, DateTime> kvp1 in kvp.Value.Securities)
{
bsonArray.Add(new BsonDocument(new BsonElement[2] {
new BsonElement("symbol", kvp1.Key),
new BsonElement("time", kvp1.Value.ToString("yyyy-MM-dd HH:mm:ss"))
}));
}
eleArray1[3] = new BsonElement("securities", bsonArray);
BsonDocument insert = new BsonDocument(eleArray1);
collection1.Insert(insert);
}
//行业统计写入数据库
MongoCollection <BsonDocument> collection2 = database.GetCollection <BsonDocument>("IndustriesUpLimitStatis");
collection2.Remove(query);
foreach (KeyValuePair <string, StatisItem> kvp in industryUpLimitStatis)
{
BsonElement[] eleArray1 = new BsonElement[4];
eleArray1[0] = new BsonElement("date", curDate.ToString("yyyy-MM-dd"));
eleArray1[1] = new BsonElement("industry", kvp.Key);
eleArray1[2] = new BsonElement("count", kvp.Value.Count);
BsonArray bsonArray = new BsonArray(kvp.Value.Count);
foreach (KeyValuePair <string, DateTime> kvp1 in kvp.Value.Securities)
{
bsonArray.Add(new BsonDocument(new BsonElement[2] {
new BsonElement("symbol", kvp1.Key),
new BsonElement("time", kvp1.Value.ToString("yyyy-MM-dd HH:mm:ss"))
}));
}
eleArray1[3] = new BsonElement("securities", bsonArray);
BsonDocument insert = new BsonDocument(eleArray1);
collection2.Insert(insert);
}
//概念统计写入数据库
MongoCollection <BsonDocument> collection3 = database.GetCollection <BsonDocument>("ConceptsUpLimitStatis");
collection3.Remove(query);
foreach (KeyValuePair <string, StatisItem> kvp in conceptUpLimitStatis)
{
BsonElement[] eleArray1 = new BsonElement[4];
eleArray1[0] = new BsonElement("date", curDate.ToString("yyyy-MM-dd"));
eleArray1[1] = new BsonElement("concept", kvp.Key);
eleArray1[2] = new BsonElement("count", kvp.Value.Count);
BsonArray bsonArray = new BsonArray(kvp.Value.Count);
foreach (KeyValuePair <string, DateTime> kvp1 in kvp.Value.Securities)
{
bsonArray.Add(new BsonDocument(new BsonElement[2] {
new BsonElement("symbol", kvp1.Key),
new BsonElement("time", kvp1.Value.ToString("yyyy-MM-dd HH:mm:ss"))
}));
}
eleArray1[3] = new BsonElement("securities", bsonArray);
BsonDocument insert = new BsonDocument(eleArray1);
collection3.Insert(insert);
}
}catch (Exception ex) {
Console.WriteLine(ex.Message);
}
curDate = curDate.AddDays(1);
}
}
public IMongoDatabase GetDatabase(MongoDatabaseSettings databaseSettings)
{
return(new MongoDatabaseProxy(_mongoServer.GetDatabase(databaseSettings)));
}
public Repository()
{
var connectionString = ConfigurationManager.ConnectionStrings["MongoDb"].ConnectionString;
MongoClient client = new MongoClient(connectionString);
MongoServer server = client.GetServer();
MongoDatabase database = server.GetDatabase(ConfigurationManager.AppSettings["Database"]);
seedCollection = database.GetCollection <Seed>("seed");
seedCollection.CreateIndex(IndexKeys <Seed> .Ascending(_ => _.ImageHash));
memeCollection = database.GetCollection <Meme>("meme");
userCollection = database.GetCollection <User>("user");
userCommentCollection = database.GetCollection <UserComment>("userComment");
reportCollection = database.GetCollection <Report>("reported");
userCredentialCollection = database.GetCollection <Credentials>("userCredential");
imageCollection = database.GetCollection <Image>("image");
timeLineCollection = database.GetCollection <TimeLine>("timeLine");
hashTagCollection = database.GetCollection <HashTag>("hashtag");
hashTagMemeCollection = database.GetCollection <HashTagMeme>("hashtagMeme");
mailCollection = database.GetCollection <Mail>("mail");
if (!BsonClassMap.IsClassMapRegistered(typeof(List <IComment>)))
{
BsonClassMap.RegisterClassMap <List <IComment> >();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(Comment)))
{
BsonClassMap.RegisterClassMap <Comment>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(PositionRef)))
{
BsonClassMap.RegisterClassMap <PositionRef>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(List <IReply>)))
{
BsonClassMap.RegisterClassMap <List <IReply> >();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(Reply)))
{
BsonClassMap.RegisterClassMap <Reply>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(Report)))
{
BsonClassMap.RegisterClassMap <Report>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(UserLite)))
{
BsonClassMap.RegisterClassMap <UserLite>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(Image)))
{
BsonClassMap.RegisterClassMap <Image>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(TimeLine)))
{
BsonClassMap.RegisterClassMap <TimeLine>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(HashTag)))
{
BsonClassMap.RegisterClassMap <HashTag>();
}
if (!BsonClassMap.IsClassMapRegistered(typeof(Mail)))
{
BsonClassMap.RegisterClassMap <Mail>();
}
// Create index on hash tag in hashtag meme
hashTagMemeCollection.CreateIndex(IndexKeys <HashTagMeme> .Ascending(_ => _.HashTag));
}
public virtual void AddImportHouse(IEnumerable <ImportedHouse> houseList, int siteId, int userId, string id_Prefix, string siteUserName)
{
MongoServer houseCaijiMongoDbServer = GetMongoClient(connectionName);
MongoDatabase houseDb = houseCaijiMongoDbServer.GetDatabase(databaseName);
string dbCollection = "ImportHouse";
MongoCollection <BsonDocument> houseCollection = houseDb.GetCollection(dbCollection);
var query = Query.EQ("RefUser.UserID", userId);
var update = Update.Pull("RefUser", Query.EQ("UserID", userId));
houseCollection.Update(query, update, UpdateFlags.Multi);
foreach (ImportedHouse item in houseList)
{
string houseId = item.HouseID;
item.MoveStatus = 0;
item.HouseID = id_Prefix + "_" + item.HouseID;
item.SiteUserName = siteUserName;
item.SiteId = siteId;
if (item.houseInfo != null)
{
item.BuildType = 1;
}
else if (item.villaInfo != null)
{
item.BuildType = 2;
}
else if (item.shopInfo != null)
{
item.BuildType = 3;
}
else if (item.officeInfo != null)
{
item.BuildType = 4;
}
else if (item.factoryInfo != null)
{
item.BuildType = 5;
}
ImportedHouse oldHouse = houseCollection.FindOneAs <ImportedHouse>(Query.EQ("_id", item.HouseID));
if (oldHouse != null)
{
int moveHouseId = 0;
int moveStatus = 0;
if (oldHouse.RefUser == null)
{
item.RefUser = new List <ImportedHouseRefUser>();
}
else
{
item.RefUser = oldHouse.RefUser;
}
ImportedHouseRefUser thisRefUser = item.RefUser.Where(u => u.UserID == userId).FirstOrDefault();
if (thisRefUser != null)
{
moveHouseId = thisRefUser.MoveHouseId;
moveStatus = thisRefUser.MoveStatus;
}
else if (oldHouse.UserID == userId)
{
moveHouseId = oldHouse.MoveHouseId;
moveStatus = oldHouse.MoveStatus;
}
//oldHouse.MoveStatus = 0;
// oldHouse.UserID = 0;
// oldHouse.MoveHouseId = 0;
// oldHouse.RefUser = null;
//string oldStr = ZJB.Core.Utilities.StringUtility.ToMd5String(jss.Serialize(oldHouse));
// string newStr = ZJB.Core.Utilities.StringUtility.ToMd5String(jss.Serialize(item));
//if (oldStr != newStr)
//{
if (thisRefUser != null)
{
thisRefUser.MoveStatus = moveStatus;
thisRefUser.MoveHouseId = moveHouseId;
}
else
{
thisRefUser = new ImportedHouseRefUser()
{
UserID = userId,
MoveStatus = moveStatus,
MoveHouseId = moveHouseId
};
item.RefUser.Add(thisRefUser);
}
houseCollection.Save(item);
// }
}
else
{
List <ImportedHouseRefUser> refUserList = new List <ImportedHouseRefUser>();
refUserList.Add(new ImportedHouseRefUser()
{
MoveHouseId = 0,
UserID = userId,
MoveStatus = 0
});
item.RefUser = refUserList;
houseCollection.Save(item);
}
}
}
public MongoDBHelper(string databaseName)
{
server = new MongoClient(setting).GetServer();
this.databaseName = databaseName;
database = server.GetDatabase(databaseName);
}
