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);
}
}
