public string RefundAll(string accountID) { var account = new MongoDBTool().GetMongoCollection <AccountModel>().Find(x => x.AccountID.Equals(new ObjectId(accountID))).FirstOrDefault(); if (account == null) { return("账户不存在"); } if (account.WeChatOrders == null) { return("账户订单不存在"); } List <string> wxOrderList = new List <string>(); account.WeChatOrders.ForEach(x => { if (!string.IsNullOrEmpty(x.WXOrderId)) { wxOrderList.Add(x.WXOrderId); Refund.Run(x.WXOrderId, null, x.Total.ConvertToMoneyCent(), x.Total.ConvertToMoneyCent()); Thread.Sleep(200); } }); return(new BaseResponseModel <List <string> >() { JsonData = wxOrderList }.ToJson()); }
// GET: /<controller>/ public IActionResult Index(string key) { ViewData["key"] = key; var db = new MongoDBTool().GetMongoCollection <We7Temp>(); We7Temp data = null; if (MainConfig.IsDev) #pragma warning disable CS0162 // Unreachable code detected { data = db.Find(x => x.We7TempID.Equals(new ObjectId(key))).FirstOrDefault(); } #pragma warning restore CS0162 // Unreachable code detected else { data = db.FindOneAndDelete(x => x.We7TempID.Equals(new ObjectId(key))); } if (data == null) { return(RedirectToAction("Index", "Error")); } ViewData["we7Data"] = data.Data; var jObject = (JObject)JsonConvert.DeserializeObject(data.Data); var uniacid = (string)jObject["uniacid"]; if (!string.IsNullOrEmpty(uniacid)) { HttpContext.Session.PushWe7Data(data.Data); } //hasIdentity = true; return(RedirectToAction("Index", "Merchant")); }
public string Cmd() { var mongo = new MongoDBTool().GetMongoCollection <TestTTL>(); var options = new CreateIndexOptions <TestTTL>(); var be = new BsonElement("expireAfterSeconds", 20); //options.StorageEngine = new BsonDocument { { "fsdfdsfd", 20 } }; //options.Weights = new BsonDocument { { "expireAfterSeconds", 20 } }; options.Name = "testIndex"; options.Version = 1; //mongo.Indexes.CreateOne(new BsonDocument() { { "CreateTime", 1 } } ,options); var bd = new BsonDocument() { { "CreateTime", 1 } }; var idk = Builders <TestTTL> .IndexKeys; //idk.Combine(); idk.Ascending(x => x.CreateTime); var iod = new IndexOptionDefaults(); options.ExpireAfter = new TimeSpan(0, 0, 20); mongo.Indexes.CreateOne(new BsonDocument() { { "CreateTime", 1 } }, options); mongo.InsertOne(new TestTTL() { CreateTime = DateTime.Now, Code = "fsdfsdf" }); return("sss"); }
// GET: /<controller>/ public IActionResult Index(string key) { ViewData["key"] = key; var db = new MongoDBTool().GetMongoCollection <We7Temp>(); We7Temp data = null; if (hostingEnvironment.IsDevelopment()) { data = db.Find(x => x.We7TempID.Equals(new ObjectId(key))).FirstOrDefault(); } else { data = db.FindOneAndDelete(x => x.We7TempID.Equals(new ObjectId(key))); } if (data == null) { return(RedirectToAction("Index", "Error")); } ViewData["we7Data"] = data.Data; JObject jObject = (JObject)JsonConvert.DeserializeObject(data.Data); string uniacid = (string)jObject["uniacid"]; if (!string.IsNullOrEmpty(uniacid)) { HttpContext.Session.PushWe7Data(data.Data); } //hasIdentity = true; return(RedirectToAction("Index", "Merchant")); }
private void button1_Click(object sender, EventArgs e) { if (checkBox1.Checked) { connectStr = textBox5.Text; } else { connectStr = $"mongodb://{textBox3.Text}:{textBox4.Text}@${textBox1.Text}/{textBox6.Text}?authSource=admin"; } LoadForm.ShowLoading(this); Task.Factory.StartNew(() => { try { MongoDBTool.Connect(connectStr).GetDataBases(); this.Invoke(new Action(() => { button2.Enabled = true; LoadForm.HideLoading(); })); } catch (Exception ex) { LoadForm.HideLoading(); this.Invoke(new Action(() => { MessageBox.Show(this, "连接失败!\n\r" + ex.Message); })); } }); }
public async Task <IActionResult> FS() { var mongo = new MongoDBTool().GetMongoDatabase(); var bucket = new GridFSBucket(mongo); string newJsonPath = $@"{hostingEnvironment.ContentRootPath}/wwwroot/account/car_number_new.json"; await bucket.UploadFromBytesAsync(Path.GetFileNameWithoutExtension(newJsonPath), System.IO.File.ReadAllBytes(newJsonPath)); return(this.JsonSuccessStatus()); }
private static void WriteCertFileConfig(string uniacid, ProcessMiniConfig pmc) { var document = new MongoDBTool().GetMongoCollection <BsonDocument>("CompanyModel").Find(Builders <BsonDocument> .Filter.Eq("uniacid", uniacid)).FirstOrDefault(); BsonValue cfn; if (document != null && document.TryGetValue("CertFileName", out cfn)) { pmc.SSLCERT_PATH = $"{MainConfig.BaseDir}{MainConfig.CertsDir}/{uniacid}/{cfn.ToString()}"; } }
public async Task <IActionResult> FSDown() { var mongo = new MongoDBTool().GetMongoDatabase(); var bucket = new GridFSBucket(mongo); string newJsonPath = $@"{hostingEnvironment.ContentRootPath}/wwwroot/account/car_number_new.json"; byte[] data = await bucket.DownloadAsBytesByNameAsync("car_number_new"); return(File(data, "application/json", "car_number_new.json")); }
public IActionResult Test() { var collection = new MongoDBTool().GetMongoCollection <WeChatCountModel>(); var filter = Builders <WeChatCountModel> .Filter; var filterSum = (filter.Eq("CountDataList.DataType", WeChatCountType.周的画像) | filter.Eq("CountDataList.DataType", WeChatCountType.月的画像) | filter.Eq("CountDataList.DataType", WeChatCountType.昨天的画像)); var list = collection.Find(filterSum).ToList(); return(list.ToJsonSuccess(this)); }
/// <summary> /// 头像上传 /// </summary> /// <param name="openId"></param> /// <returns></returns> public string UploadAvatar(string accountID) { BaseResponseModel <String> responseModel = new BaseResponseModel <String>(); if (string.IsNullOrEmpty(accountID)) { responseModel.StatusCode = (int)ActionParams.code_error_null; responseModel.JsonData = $@"参数:openId:{accountID}"; return(JsonConvert.SerializeObject(responseModel)); } long size = 0; var files = Request.Form.Files; try { foreach (var file in files) { var filename = ContentDispositionHeaderValue .Parse(file.ContentDisposition) .FileName .Trim('"'); string saveDir = $@"{ConstantProperty.BaseDir}{ConstantProperty.AvatarDir}"; if (!Directory.Exists(saveDir)) { Directory.CreateDirectory(saveDir); } filename = filename.Substring(filename.LastIndexOf(".")); string saveName = ConstantProperty.AvatarDir + $@"{accountID}{filename}"; filename = ConstantProperty.BaseDir + saveName; size += file.Length; using (FileStream fs = System.IO.File.Create(filename)) { file.CopyTo(fs); fs.Flush(); var filter = Builders <AccountModel> .Filter.Eq(x => x.AccountID, new ObjectId(accountID)); var update = Builders <AccountModel> .Update.Set(x => x.AccountAvatar, saveName); var dbTool = new MongoDBTool(); dbTool.GetMongoCollection <AccountModel>().UpdateOne(filter, update); } } responseModel.StatusCode = (int)ActionParams.code_ok; } catch (Exception) { responseModel.StatusCode = (int)ActionParams.code_error; throw; } return(JsonConvert.SerializeObject(responseModel)); }
/// <summary> /// 微信支付成功返回数据 /// </summary> /// <param name="data"></param> private void OnPaySuccess(WxPayData data) { var attach = (string)data.GetValue("attach"); var wxOrderId = (string)data.GetValue("transaction_id"); if (string.IsNullOrEmpty(attach)) { var em = new ExceptionModel() { Content = "微信支付返回:attach为空" }; em.Save(); throw em; } if (string.IsNullOrEmpty(wxOrderId)) { var em = new ExceptionModel() { Content = "微信支付返回:微信订单号为空" }; em.Save(); throw em; } string[] aa = attach.Split(','); string uniacid = aa[0]; string accountID = aa[1]; string orderID = aa[2]; var mongo = new MongoDBTool(); var accountCollection = mongo.GetMongoCollection <AccountModel>(); var filter = Builders <AccountModel> .Filter; var filterSum = filter.Eq(x => x.AccountID, new ObjectId(accountID)) & filter.Eq("Orders.OrderID", new ObjectId(orderID)); var account = accountCollection.Find(filterSum).FirstOrDefault(); var wcOrder = account.Orders.Find(x => x.OrderID.Equals(new ObjectId(orderID)) && !x.IsPaid); if (wcOrder == null) { var em = new ExceptionModel() { Content = "微信支付返回:订单不存在或者已经生成" }; em.Save(); throw em; } var update = Builders <AccountModel> .Update .Set("Orders.$.WeChatOrderID", wxOrderId) .Set("Orders.$.IsPaid", true); accountCollection.UpdateOne(filterSum, update); }
private static void DoResetSAOT(object state) { var collection = new MongoDBTool().GetMongoCollection<AccountModel>(); var accountList = collection.Find(Builders<AccountModel>.Filter.Empty).ToList(); accountList.ForEach(x => { if (x.LastRefreshTime.DayOfYear <= DateTime.Now.DayOfYear - 1) { collection.UpdateOne(y => y.uniacid.Equals(x.uniacid) && y.AccountID.Equals(x.AccountID), Builders<AccountModel>.Update.Set(y => y.CanShareTimes, 5).Set(y => y.CanOpenJackTimes, 2)); } }); }
// GET: /<controller>/ public IActionResult Index(string key) { if (key == null) { return(new RedirectToActionResult("Index", "WebError", new { errorType = ErrorType.ErrorNoUserOrTimeOut })); } ViewData["key"] = key; var db = new MongoDBTool().GetMongoCollection <We7Temp>(); We7Temp data = null; if (MainConfig.IsDev || hostingEnvironment.IsDevelopment()) { data = db.Find(x => x.We7TempID.Equals(new ObjectId(key))).FirstOrDefault(); } else { data = db.FindOneAndDelete(x => x.We7TempID.Equals(new ObjectId(key))); } if (data == null) { return(new RedirectToActionResult("Index", "WebError", new { errorType = ErrorType.ErrorNoUserOrTimeOut })); } ViewData["we7Data"] = data.Data; JObject jObject = (JObject)JsonConvert.DeserializeObject(data.Data); string uniacid = (string)jObject["uniacid"]; if (!string.IsNullOrEmpty(uniacid)) { HttpContext.Session.PushWe7Data(data.Data); } //hasIdentity = true; //var urlReferrer = HttpContext.Request.Headers["referer"].FirstOrDefault(); //if (urlReferrer!=null) //{ // var urlBase = urlReferrer.ToString(); // HttpContext.SetReferrer(urlBase); //} //HttpContext.SetReferrer(JsonConvert.SerializeObject(HttpContext.Request.Headers)); string preUrl = Request.Headers["Referer"]; if (HttpContext.GetReferrer() == null && preUrl != null) { HttpContext.SetReferrer(preUrl); } return(RedirectToAction("Index", "Merchant")); }
/// <summary> /// 获取账户信息 /// </summary> /// <param name="accountID">账户Id</param> /// <returns></returns> public string GetAccountInfo(string accountID) { BaseResponseModel <AccountModel> responseModel = new BaseResponseModel <AccountModel>(); if (accountID == null) { responseModel.StatusCode = (int)ActionParams.code_error_null; return(JsonConvert.SerializeObject(responseModel)); } responseModel.StatusCode = (int)ActionParams.code_ok; try { var account = new MongoDBTool().GetMongoCollection <AccountModel>().Find(x => x.AccountID.Equals(new ObjectId(accountID))).FirstOrDefault(); if (account == null) { responseModel.StatusCode = (int)ActionParams.code_null; } //查询三代 responseModel.JsonData = account; } catch (Exception) { responseModel.StatusCode = (int)ActionParams.code_error; throw; } JsonSerializerSettings jsonSerializerSettings = new JsonSerializerSettings(); jsonSerializerSettings.ContractResolver = new LimitPropsContractResolver( new string[] { "StatusCode", "JsonData", "AccountName", "AccountAvatar", "OrderList", "ServicePhone", "WaitingJoin", "WaitingSend", "WaitingAssess", "OrderLocationPhone", "OrderLocationPersonName", "ProvinceCityArea", "AddressDetail" }); return(JsonConvert.SerializeObject(responseModel, jsonSerializerSettings)); }
/// <summary> /// 双击treeview /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tview_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { TreeNode node = Treeview.SelectedNode; if (node == null) { return; } if (node.Level == 0) { node.Nodes.Clear(); getServers(); Treeview.ExpandAll(); } else if (node.Level == 1) { node.Nodes.Clear(); getDatabaseinfo(node); } else if (node.Level == 4) { if (null != newcontentForm) { ConnectionModel conModel = _ConnectList.Find(delegate(ConnectionModel con) { return(con.ID.ToString().Equals(Treeview.SelectedNode.Parent.Parent.Parent.Tag.ToString())); }); if (conModel.DbType.Equals(DatabaseType.MongoDB.ToString())) { //todo MongoDBTool.Connect(conModel.ConnectionString).GetList(node.Parent.Parent.Text, node.Text, "{\"find\":\"Account\", limit:20, sort:{AddTime:-1}}"); } else { conConnectionString = Treeview.SelectedNode.Parent.Parent.Tag.ToString(); try { conModel.TableName = Treeview.SelectedNode.Text; conModel.Database = Treeview.SelectedNode.Parent.Parent.Text; conModel.IsView = Treeview.SelectedNode.Tag.ToString().Equals("V"); newcontentForm?.Invoke(conModel); } catch { } } } } }
private void button2_Click(object sender, EventArgs e) { Task.Factory.StartNew(() => { LoadForm.ShowLoading(this); try { var mongoTool = MongoDBTool.Connect(connectStr); var dataBaseNames = mongoTool.GetDataBases(); var dataBaseName = ""; if (dataBaseNames != null && dataBaseNames.Any()) { if (System.Linq.Enumerable.Count(dataBaseNames) == 1) { dataBaseName = dataBaseNames.First(); } else { dataBaseName = "all"; } } this.Invoke(new Action(() => { Connection connectionModel = new Connection(); connectionModel.Database = dataBaseName; connectionModel.ID = Guid.NewGuid(); connectionModel.Name = mongoTool.ServerInfo + "(MongoDB)[" + connectionModel.Database + "]"; connectionModel.DbType = DatabaseType.MongoDB.ToString(); connectionModel.ConnectionString = connectStr; UtilsHelper.AddConnection(connectionModel); this.DialogResult = DialogResult.OK; this.Close(); })); } catch (Exception ex) { MessageBox.Show("连接失败!\n\r" + ex.Message); } LoadForm.HideLoading(); }); }
private string GetSimpleGoodsDetail(string goodsID) { BaseResponseModel <ResponseGoodsDetail> responseModel = new BaseResponseModel <ResponseGoodsDetail>(); var goods = new MongoDBTool().GetMongoCollection <GoodsModel>().Find(x => x.GoodsID.Equals(new ObjectId(goodsID))).FirstOrDefault(); if (goods == null) { responseModel.StatusCode = (int)ActionParams.code_null; } responseModel.StatusCode = (int)ActionParams.code_ok; JsonSerializerSettings jsonSerializerSettings = new JsonSerializerSettings(); jsonSerializerSettings.ContractResolver = new LimitPropsContractResolver( new string[] { "StatusCode", "JsonData", "GoodsInfo", "JackGoods", "GoodsID", "GoodsTitle", "GoodsDetail", "GoodsPrice", "GoodsOldPrice", "GoodsPayType", "GoodsMainImages", "GoodsSales", "GoodsOtherImages", "FileUrlData", "GoodsPeopleNum", "AssessmentList", "AssessmentContent", "AssessAccount", "AccountName", "AssessTime", "AccountAvatar" }); responseModel.JsonData = new ResponseGoodsDetail() { GoodsInfo = new JackPotModel() { JackGoods = goods } }; return(JsonConvert.SerializeObject(responseModel, jsonSerializerSettings)); }
public string RequestLogin(string code, string iv, string encryptedData) { BaseResponseModel <AccountModel> responseModel = new BaseResponseModel <AccountModel>(); AccountModel accountCard = null; WXSmallAppCommon.Models.WXAccountInfo wXAccount = WXSmallAppCommon.WXInteractions.WXLoginAction.ProcessRequest(code, iv, encryptedData); if (wXAccount.OpenId != null) { var filter = Builders <AccountModel> .Filter.And(Builders <AccountModel> .Filter.Eq(x => x.OpenID, wXAccount.OpenId)); var collection = new MongoDBTool().GetMongoCollection <AccountModel>(); var update = Builders <AccountModel> .Update.Set(x => x.LastChangeTime, DateTime.Now); accountCard = collection.FindOneAndUpdate <AccountModel>(filter, update); if (accountCard == null) { int gender = wXAccount.Gender == 1 ? 1 : wXAccount.Gender == 2 ? 2 : 3; //string avatarUrl = DownloadAvatar(wXAccount.AvatarUrl, wXAccount.OpenId); string avatarUrl = wXAccount.AvatarUrl; accountCard = new AccountModel() { OpenID = wXAccount.OpenId, HasRedPocket = false, AccountName = wXAccount.NickName, Gender = gender, AccountAvatar = avatarUrl, CreateTime = DateTime.Now, LastChangeTime = DateTime.Now }; collection.InsertOne(accountCard); } } int stautsCode = (int)(ActionParams.code_error); if (accountCard != null) { responseModel.JsonData = accountCard; stautsCode = (int)(ActionParams.code_ok); } responseModel.StatusCode = stautsCode; JsonSerializerSettings jsonSerializerSettings = new JsonSerializerSettings(); string[] param = new string[] { "StatusCode", "JsonData", "AccountID", "HasRedPocket" }; jsonSerializerSettings.ContractResolver = new LimitPropsContractResolver(param); string jsonString = JsonConvert.SerializeObject(responseModel, jsonSerializerSettings); Console.WriteLine("json#####UserInfo:" + jsonString); return(jsonString); }
/// <summary> /// 获取分页商品列表 /// </summary> /// <param name="pageIndex">页码0-...</param> /// <param name="goodsPayType">商品交易类型:0.2人拼团,1.2-6人拼团,2.1分夺宝</param> /// <returns></returns> public string GetGoodsList(int pageIndex, int goodsPayType) { BaseResponseModel <List <GoodsModel> > responseModel = new BaseResponseModel <List <GoodsModel> >(); responseModel.StatusCode = (int)ActionParams.code_ok; try { var filter = Builders <GoodsModel> .Filter.Eq(x => x.GoodsPayType, goodsPayType); var find = new MongoDBTool().GetMongoCollection <GoodsModel>().Find(filter).Skip(pageIndex * pageSize); var count = find.Count(); var pageSum = (count / pageSize) + (count % pageSize == 0 ? 0 : 1); List <GoodsModel> GoodsModelList = null; if (pageSum >= pageIndex + 1) { GoodsModelList = find.Skip(pageIndex * pageSize).Limit(pageSize).ToList(); if (GoodsModelList == null || GoodsModelList.Count == 0) { responseModel.StatusCode = (int)ActionParams.code_error_null; } } else { responseModel.StatusCode = (int)ActionParams.code_null; } responseModel.JsonData = GoodsModelList; } catch (Exception) { responseModel.StatusCode = (int)ActionParams.code_error; } JsonSerializerSettings jsonSerializerSettings = new JsonSerializerSettings(); jsonSerializerSettings.ContractResolver = new LimitPropsContractResolver(new string[] { "StatusCode", "JsonData", "GoodsID", "GoodsTitle", "GoodsPrice", "GoodsSales", "GoodsListImage", "FileUrlData" }); return(JsonConvert.SerializeObject(responseModel, jsonSerializerSettings)); }
/// <summary> /// 根据openId 查询用户信息 /// </summary> /// <param name="openId"></param> /// <returns></returns> public string FindPersonInfo(string openId) { var collectiion = new MongoDBTool().GetMongoCollection <AccountCard>("AccountCard"); var filter = Builders <AccountCard> .Filter.Eq(x => x.OpenId, openId); var list = collectiion.Find <AccountCard>(f => f.OpenId.Equals(openId)); AccountCard accountCard = null; accountCard = list.FirstOrDefault(); //驼峰 //string jsonString = JsonConvert.SerializeObject(new BaseResponseModel<AccountCard>() { JsonData = accountCard, StatusCode = (int)ActionParams.code_ok },new JsonSerializerSettings { ContractResolver=new Newtonsoft.Json.Serialization.CamelCasePropertyNamesContractResolver()}); string jsonString = JsonConvert.SerializeObject(new BaseResponseModel <AccountCard>() { JsonData = accountCard, StatusCode = (int)ActionParams.code_ok }); return(jsonString); }
public string RequestCreateJackPot(string accountID, string goodsID) { var mongo = new MongoDBTool(); var accountFilter = Builders <AccountModel> .Filter.Eq(x => x.AccountID, new ObjectId(accountID)); var goodsFilter = Builders <GoodsModel> .Filter.Eq(x => x.GoodsID, new ObjectId(goodsID)); var account = mongo.GetMongoCollection <AccountModel>().Find(accountFilter).FirstOrDefault(); var goods = mongo.GetMongoCollection <GoodsModel>().Find(goodsFilter).FirstOrDefault(); JsApiPay jsApiPay = new JsApiPay(); jsApiPay.openid = account.OpenID; jsApiPay.total_fee = goods.GoodsPrice; var body = "test"; var attach = "test"; var goods_tag = goods.GoodsTitle; jsApiPay.GetUnifiedOrderResult(body, attach, goods_tag); return(jsApiPay.GetJsApiParameters()); }
public IActionResult CallMany() { var mongo = new MongoDBTool(); var company = mongo.GetMongoCollection <CompanyModel>().Find(x => x.uniacid.Equals("24")).FirstOrDefault(); if (company == null || company.YTX == null) { var em = new ExceptionModel() { Content = "商户未设置云通信信息" }; em.Save(); return(this.JsonErrorStatus()); } string jsonData = JsonConvert.SerializeObject(new MeetingPhoneModel() { appid = company.YTX.AppID, creator = "15501022450", meetingname = "ceshi", parties = new Party[] { new Party() { name = "22", phone = "13245437784" } } } ); string url = "/call/TeleMeeting.wx"; string result = new PhoneHelper(company.YTX).SendRequest(url, jsonData); var jObj = (JObject)JsonConvert.DeserializeObject(result); JToken statuscode; bool hasVal = jObj.TryGetValue("statusCode", out statuscode); if (hasVal && statuscode.ToString().Equals("0")) { return(this.JsonSuccessStatus()); } return(this.JsonErrorStatus()); }
public IActionResult ReceiveWe7Data() { try { string json = new StreamReader(Request.Body).ReadToEnd(); var db = new MongoDBTool().GetMongoCollection <We7Temp>(); var we7Temp = new We7Temp() { Data = json }; db.InsertOne(we7Temp); return(new JsonResponse1 <string>() { JsonData = we7Temp.We7TempID.ToString() }.ToJsonResult(this)); } catch (Exception) { return(this.JsonErrorStatus()); } }
public string ReceiveWe7Data() { try { string json = new StreamReader(Request.Body).ReadToEnd(); var db = new MongoDBTool().GetMongoCollection <We7Temp>(); var we7Temp = new We7Temp() { Data = json }; db.InsertOne(we7Temp); return(new BaseResponseModel <string>() { StatusCode = Tools.ActionParams.code_ok, JsonData = we7Temp.We7TempID.ToString() }.ToJson()); } catch (Exception) { return(JsonResponseModel.ErrorJson); throw; } }
public string RequestLogin(string code, string iv, string encryptedData) { AccountCard accountCard = null; WXSmallAppCommon.Models.WXAccountInfo wXAccount = WXSmallAppCommon.WXInteractions.WXLoginAction.ProcessRequest(code, iv, encryptedData); if (wXAccount.openId != null) { var filter = Builders <AccountCard> .Filter.And(Builders <AccountCard> .Filter.Eq(x => x.OpenId, wXAccount.openId)); var collection = new MongoDBTool().GetMongoCollection <AccountCard>("AccountCard"); var update = Builders <AccountCard> .Update.Set(x => x.LastLoginTime, DateTime.Now); accountCard = collection.FindOneAndUpdate <AccountCard>(filter, update); if (accountCard == null) { accountCard = new AccountCard() { OpenId = wXAccount.openId, AccountName = wXAccount.nickName, Gender = wXAccount.gender, AvatarUrl = wXAccount.avatarUrl, City = wXAccount.city, Province = wXAccount.province, CreateTime = DateTime.Now, LastLoginTime = DateTime.Now }; collection.InsertOne(accountCard); } } BaseResponseModel <AccountCard> responseModel = new BaseResponseModel <AccountCard>(); int stautsCode = (int)(ActionParams.code_error); if (accountCard != null) { responseModel.JsonData = accountCard; stautsCode = (int)(ActionParams.code_ok); } responseModel.StatusCode = stautsCode; string jsonString = JsonConvert.SerializeObject(responseModel); Console.WriteLine("json**3:" + jsonString); return(jsonString); }
/// <summary> /// 刷新数据库表和视图 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void 刷新ToolStripMenuItem2_Click(object sender, EventArgs e) { TreeNode node = Treeview.SelectedNode; if (node.Level == 3) { node = node.Parent; } if (node.Level == 4) { node = node.Parent.Parent; } node.Nodes.Clear(); Connection conModel = null; try { conModel = _ConnectList.Find(delegate(Connection con) { return(con.ID.ToString().Equals(node.Parent.Tag.ToString())); }); IDbObject dbObject; if (conModel.DbType.Equals(DatabaseType.MsAccess.ToString())) { dbObject = new WEF.DbDAL.OleDb.DbObject(conConnectionString); ShowTablesAndViews(node, dbObject.GetTables(""), dbObject.GetVIEWs("")); } else if (conModel.DbType.Equals(DatabaseType.SqlServer.ToString())) { dbObject = new WEF.DbDAL.SQL2000.DbObject(conConnectionString); ShowTablesAndViews(node, dbObject.GetTables(node.Text), dbObject.GetVIEWs(node.Text)); } else if (conModel.DbType.Equals(DatabaseType.SqlServer9.ToString())) { dbObject = new WEF.DbDAL.SQL2005.DbObject(conConnectionString); ShowTablesAndViews(node, dbObject.GetTables(node.Text), dbObject.GetVIEWs(node.Text)); } else if (conModel.DbType.Equals(DatabaseType.Oracle.ToString())) { dbObject = new WEF.DbDAL.Oracle.DbObject(conConnectionString); ShowTablesAndViews(node, dbObject.GetTables(node.Text), dbObject.GetVIEWs(node.Text)); } else if (conModel.DbType.Equals(DatabaseType.MySql.ToString())) { dbObject = new WEF.DbDAL.MySql.DbObject(conConnectionString); ShowTablesAndViews(node, dbObject.GetTables(node.Text), dbObject.GetVIEWs(node.Text)); } else if (conModel.DbType.Equals(DatabaseType.Sqlite3.ToString())) { dbObject = new WEF.DbDAL.SQLite.DbObject(conConnectionString); ShowTablesAndViews(node, dbObject.GetTables(node.Text), dbObject.GetVIEWs(node.Text)); } else if (conModel.DbType.Equals(DatabaseType.MongoDB.ToString())) { var mongoDBTool = MongoDBTool.Connect(conConnectionString); ShowCollections(node, mongoDBTool.GetCollections(node.Text)); } node.ExpandAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "出错啦!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }