mongodb实现MSsql中的in操作
mongodb实现MSsql中的in操作 public async Task> GetRoleForMenuAuthority(string roleid) { var rid = roleid.Split(char.Parse(",")); List rids = new List(); for (int i = ...
mongodb多字段分组统计、多表联查脚本
db.T_ZXJC_FQXSSJB.aggregate([ { $group: { _id: {"pwxkzbh":"$pwxkzbh","xkpfkwybm":"$xkpfkwybm","dwmc":"$dwmc","pfkmc":"$pfkmc"}, maxtime: { $max: '$data_time'},m...
Mongodb 删除重复数据
db.getCollection("T_ZXJC_FSSSData").aggregate([ {//聚合字段 $group:{_id:{dwmc:'$dwmc',pfkmc:"$pfkmc",pwxkzbh:"$pwxkzbh",mn:"$mn",xkpfkwybm:"$xkpfkwybm",data_time...
Mongodb 批量更新子文档(子数据集)
Mongodb 批量更新子文档(子数据集) 数据样例如下： { "_id": ObjectId("638da214663eedfbd7c9db1e"), "dwmc": "宁乡东城污水处理有限公司", "pfkmc": "东城污水处理厂入口", "pwxkzbh": " 9143012432568089280...
Mongodb 删除重复数据
db.getCollection("T_ZXJC_FSSSData").aggregate([ {//聚合字段 $group:{_id:{dwmc:'$dwmc',pfkmc:"$pfkmc",pwxkzbh:"$pwxkzbh",mn:"$mn",xkpfkwybm:"$xkpfkwybm",data_time...