public void GetOne() { ProxyAPICallModels pac = new ProxyAPICallModels(); // Act object result = pac.GetOne("560d002482b1591aa849ff6e"); // Assert Assert.AreEqual(result, "0"); }
public void Creat() { ProxyAPICallModels pac = new ProxyAPICallModels(); pac.API_Name = "GetGamePoints"; pac.Parameters = "{\"GameCodeInfo\":[\"C6B17C21-3751-4736-92DD-982CFCF96E1C\",\"4A287D31-3407-44E2-AED6-7E4EEE31B64C\",\"A9797B1B-439A-45C2-AB3E-57CC311D964B\",\"B821990C-2A1F-426D-85C3-390B0B16AF00\",\"8C0F981D-859F-4BAF-B9B6-947DC6D72AD7\"],\"UserId\":\"gotesta\",\"ExecUser\":\"SystemAdmin\",\"ExecIP\":\"192.168.1.1\"}"; pac.API_CName = "用戶批量獲取遊戲端點數(額度)API"; pac.ReturnCode = "200"; pac.ReturnData = "{\"Code\":\"200\",\"ErrMsg\":\"\",\"RetObj\":[{\"GameGUID\":\"C6B17C21-3751-4736-92DD-982CFCF96E1C\",\"Point\":0.00,\"GetTime\":\"2015-10-01 01:37:35\",\"Success\":true},{\"GameGUID\":\"A9797B1B-439A-45C2-AB3E-57CC311D964B\",\"Point\":0.00,\"GetTime\":\"2015-10-01 01:37:34\",\"Success\":true},{\"GameGUID\":\"4A287D31-3407-44E2-AED6-7E4EEE31B64C\",\"Point\":0.00,\"GetTime\":\"2015-10-01 01:37:35\",\"Success\":true},{\"GameGUID\":\"B821990C-2A1F-426D-85C3-390B0B16AF00\",\"Point\":0.00,\"GetTime\":\"2015-10-01 01:37:35\",\"Success\":true},{\"GameGUID\":\"8C0F981D-859F-4BAF-B9B6-947DC6D72AD7\",\"Point\":1381.19,\"GetTime\":\"2015-10-01 01:37:35\",\"Success\":true}]}"; pac.Description = "正常"; pac.ExecuteUser = "******"; // Act object result = pac.Creat(); // Assert Assert.AreEqual(result, "0"); }
public ActionResult ProxyAPICall_Add(ProxyAPICallModels pac) { object result = pac.Creat(); return View(); }
/// <summary> /// MongoDB測試-ProxyAPICall /// </summary> /// <returns></returns> public ActionResult ProxyAPICall_Add() { ProxyAPICallModels model = new ProxyAPICallModels(); return View(model); }
/// <summary> /// ProxyAPI呼叫記錄 - 取得全部 /// </summary> /// <returns>"0":成功, 其它:失敗</returns> public static object GetAll(out List<ProxyAPICallModels> pacs) { pacs = new List<ProxyAPICallModels>(); object result = "0"; try { //MongoDB.Driver 2.0.1 IMongoCollection<BsonDocument> collection = MongoDBCollections.GetCollection_ProxyAPICall(); //取得Log資料庫ProxyAPICall資料表 List<BsonDocument> docs = new List<BsonDocument>(); Task.Run(async () => { var tmp = await collection.Find(new BsonDocument()).ToListAsync(); docs = tmp.ToList(); }).GetAwaiter().GetResult(); List<ProxyAPICallModels> models = new List<ProxyAPICallModels>(); docs.ForEach(doc => { ProxyAPICallModels model = new ProxyAPICallModels(doc); models.Add(model); } ); pacs = models; //MongoDB.Driver 1.10 //MongoCollection<BsonDocument> collection = MongoDBCollections.GetCollection_ProxyAPICall(); //取得Log資料庫ProxyAPICall資料表 //var docs = collection.FindAll(); //List<ProxyAPICallModels> models = new List<ProxyAPICallModels>(); //foreach (var doc in docs) //{ // ProxyAPICallModels model = new ProxyAPICallModels(doc); // models.Add(model); //} //pacs = models; } catch (Exception ex) { result = ex.ToString(); } return result; }
/// <summary> /// ProxyAPI呼叫記錄 - 依條件取得 /// </summary> /// <returns>"0":成功, 其它:失敗</returns> public static object GetList(string API_Name, string ReturnCode, string UserId, out List<ProxyAPICallModels> pacs) { pacs = new List<ProxyAPICallModels>(); object result = "0"; try { //MongoDB.Driver 2.0.1 var builder = Builders<BsonDocument>.Filter; var filter = builder.Ne("_id", ""); //預設ID不為空 => 全列 if (!string.IsNullOrEmpty(API_Name)) filter = filter & builder.Regex("API_Name", ".*" + API_Name + ".*"); //字串部分比對 if (!string.IsNullOrEmpty(ReturnCode)) filter = filter & builder.Eq("ReturnCode", ReturnCode); if (!string.IsNullOrEmpty(UserId)) filter = filter & builder.Regex("Parameters.UserId", "/" + UserId + "/"); //字串部分比對 var collection = MongoDBCollections.GetCollection_ProxyAPICall(); //取得Log資料庫ProxyAPICall資料表 List<BsonDocument> docs = new List<BsonDocument>(); Task.Run(async () => { var tmp = await collection.Find(filter).ToListAsync(); docs = tmp.ToList(); }).GetAwaiter().GetResult(); List<ProxyAPICallModels> models = new List<ProxyAPICallModels>(); docs.ForEach(doc => { ProxyAPICallModels model = new ProxyAPICallModels(doc); models.Add(model); } ); pacs = models; //MongoDB.Driver 1.10 //var query = Query.NE("_id", ""); //預設ID不為空 => 全列 //if (!string.IsNullOrEmpty(API_Name)) // query = Query.And(query, Query.Matches("API_Name", API_Name)); //字串部分比對 //if (!string.IsNullOrEmpty(ReturnCode)) // query = Query.And(query, Query.EQ("ReturnCode", ReturnCode)); //if (!string.IsNullOrEmpty(UserId)) // query = Query.And(query, Query.Matches("Parameters.UserId", UserId)); //字串部分比對 //if (!string.IsNullOrEmpty(StartTime) && !string.IsNullOrEmpty(EndTime)) //{ // query = Query.And(query, Query.GTE("CTime", DateTime.Parse(StartTime).ToLocalTime())); // query = Query.And(query, Query.LTE("CTime", DateTime.Parse(EndTime).ToLocalTime())); //} //MongoCollection<BsonDocument> collection = MongoDBCollections.GetCollection_ProxyAPICall(); //取得Log資料庫ProxyAPICall資料表 //var docs = collection.Find(query); //List<ProxyAPICallModels> models = new List<ProxyAPICallModels>(); //foreach (var doc in docs) //{ // ProxyAPICallModels model = new ProxyAPICallModels(doc); // models.Add(model); //} //pacs = models; } catch (Exception ex) { result = ex.ToString(); } return result; }
/// <summary> /// ProxyAPI呼叫記錄 - 取得一筆 /// </summary> /// <returns>"0":成功, 其它:失敗</returns> public object GetOne(string ID) { object result = "0"; try { //MongoDB.Driver 2.0.1 var filter = Builders<BsonDocument>.Filter.Eq("_id", ObjectId.Parse(ID)); ProxyAPICallModels pac = new ProxyAPICallModels(); IMongoCollection<BsonDocument> collection = MongoDBCollections.GetCollection_ProxyAPICall(); //取得Log資料庫ProxyAPICall資料表 Task.Run(async () => { var doc = await collection.Find(filter).FirstAsync(); this.ID = doc.GetValue("_id", string.Empty).ToString().Replace("ObjectId(", "").Replace(")", ""); this.API_Name = doc.GetValue("API_Name", string.Empty).ToString(); this.Parameters = doc.GetValue("Parameters", string.Empty).ToString(); this.API_CName = doc.GetValue("API_CName", string.Empty).ToString(); this.ReturnCode = doc.GetValue("ReturnCode", string.Empty).ToString(); this.ReturnData = doc.GetValue("ReturnData", string.Empty).ToString(); this.Description = doc.GetValue("Description", string.Empty).ToString(); this.ExecuteUser = doc.GetValue("ExecuteUser", string.Empty).ToString(); DateTime tmp; DateTime.TryParse(doc.GetValue("CTime", DateTime.UtcNow).ToString(), out tmp); this.CTime = tmp.ToLocalTime(); }).GetAwaiter().GetResult(); //MongoDB.Driver 1.10 //MongoCollection<BsonDocument> collection = MongoDBCollections.GetCollection_ProxyAPICall(); //取得Log資料庫ProxyAPICall資料表 //var query = Query.EQ("_id", ObjectId.Parse(ID)); //var doc = collection.FindOne(query); //this.ID = doc.GetValue("_id", string.Empty).ToString().Replace("ObjectId(", "").Replace(")", ""); //this.API_Name = doc.GetValue("API_Name", string.Empty).ToString(); //this.Parameters = doc.GetValue("Parameters", string.Empty).ToString(); //this.API_CName = doc.GetValue("API_CName", string.Empty).ToString(); //this.ReturnCode = doc.GetValue("ReturnCode", string.Empty).ToString(); //this.ReturnData = doc.GetValue("ReturnData", string.Empty).ToString(); //this.Description = doc.GetValue("Description", string.Empty).ToString(); //this.ExecuteUser = doc.GetValue("ExecuteUser", string.Empty).ToString(); //DateTime tmp; //DateTime.TryParse(doc.GetValue("CTime", DateTime.UtcNow).ToString(), out tmp); //this.CTime = tmp.ToLocalTime(); } catch (Exception ex) { result = ex.ToString(); } return result; }