/// <summary> /// 通过查询条件获取推送信息列表 /// </summary> /// <param name="searchParam"></param> /// <param name="para"></param> /// <returns></returns> public JsonResult GetWeChatPushListBySearch(SearchWeChatPushList searchParam, GridParams para) { if (para.sortdatafield == null) { para.sortdatafield = "CreatedDate"; para.sortorder = "desc"; } para.pagenum = para.pagenum + 1;//页0,+1 var model = _historyLogic.GetWeChatPushListBySearch(searchParam, para); return(Json(model, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 通过查询条件获取推送信息列表(已提交) /// </summary> /// <param name="searchParam"></param> /// <param name="para"></param> /// <returns></returns> public JsonResult GetWeChatPushListBySearch(SearchWeChatPushList searchParam, GridParams para) { if (para.sortdatafield == null) { para.sortdatafield = "CreatedDate"; para.sortorder = "desc"; } para.pagenum = para.pagenum + 1;//页0,+1 //List<DeparTment_1> departmenteList = _dl.GetDepartmentList(searchParam, para); var model = _cl.GetWeChatPushListBySearch(searchParam, para); return(new ConfigurableJsonResult { Data = model, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
/// <summary> /// 通过查询条件获取推送信息列表(已推送) /// </summary> /// <param name="searchParam"></param> /// <param name="para"></param> /// <returns></returns> public JsonResultModel <V_Business_WeChatPushMain_Information> GetWeChatPushListBySearch(SearchWeChatPushList searchParam, GridParams para) { using (SqlSugarClient db = SugarDao_MsSql.GetInstance()) { JsonResultModel <V_Business_WeChatPushMain_Information> jsonResult = new JsonResultModel <V_Business_WeChatPushMain_Information>(); //只查询三个月内的数据 DateTime endDate = DateTime.Now.AddMonths(-3); // var personModel = new Business_Personnel_Information() { UserID = "1323397305", Vguid = Guid.Parse("8F3D8CCC-82D9-4A76-B0C7-2DC585D86B64") }; var query = db.Queryable <V_Business_WeChatPushMain_Information>().Where(i => i.Status == 4 && i.History == "1" && i.PushDate > endDate); if (CurrentUser.GetCurrentUser().LoginName != "sysAdmin") { var mainDep = db.Queryable <Master_Organization>().Where(i => i.ParentVguid == null).Select(i => i.Vguid).SingleOrDefault(); //大众交通集团 var listChildDep = db.Queryable <Master_Organization>().Where(i => i.ParentVguid == mainDep).Select(i => i.Vguid).ToList(); //大众出租租赁 listChildDep.Add(mainDep); Guid currentDep = Guid.Parse(CurrentUser.GetCurrentUser().Department); //首先查询登录人的部门 if (!listChildDep.Contains(currentDep)) { var listDep = db.SqlQuery <Guid>("SELECT * FROM dbo.TF_OrganizationFDetail('" + currentDep + "')"); //找到该部门以及其所有子部门 var list = db.Queryable <Sys_User>().In(i => i.Department, listDep).Select(i => i.LoginName).ToList(); query.Where(i => list.Contains(i.PushPeople)); //找到该部门中人员所推送的消息 } } if (!string.IsNullOrEmpty(searchParam.Title)) { query.Where(c => c.Title.Contains(searchParam.Title)); //标题 } if (!string.IsNullOrEmpty(searchParam.PushType.ToString())) { query.Where(c => c.PushType == searchParam.PushType); //推送类型 } if (!string.IsNullOrEmpty(searchParam.Important.ToString())) { query.Where(c => c.Important == searchParam.Important); //是否重要 } if (!string.IsNullOrEmpty(searchParam.PeriodOfValidity.ToString())) { DateTime pushDate = DateTime.Parse(searchParam.PushDate.ToString().Replace("0:00:00", "23:59:59")); query.Where(c => c.PushDate < pushDate); //有效时间 } query.OrderBy(para.sortdatafield + " " + para.sortorder); int pageCount = 0; jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize, ref pageCount); jsonResult.TotalRows = pageCount; string logData = JsonHelper.ModelToJson(jsonResult); _ll.SaveLog(3, 37, CurrentUser.GetCurrentUser().LoginName, "推送历史", logData); return(jsonResult); } }
/// <summary> /// 通过查询条件获取推送信息列表(已提交) /// </summary> /// <param name="searchParam"></param> /// <param name="para"></param> /// <returns></returns> public JsonResultModel <V_Business_WeChatPushMain_Information> GetWeChatPushListBySearch(SearchWeChatPushList searchParam, GridParams para) { return(_cs.GetWeChatPushListBySearch(searchParam, para)); }
/// <summary> /// 通过查询条件获取推送信息列表(已提交) /// </summary> /// <param name="searchParam"></param> /// <param name="para"></param> /// <returns></returns> public JsonResultModel <V_Business_WeChatPushMain_Information> GetWeChatPushListBySearch(SearchWeChatPushList searchParam, GridParams para) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { JsonResultModel <V_Business_WeChatPushMain_Information> jsonResult = new JsonResultModel <V_Business_WeChatPushMain_Information>(); var query = _dbMsSql.Queryable <V_Business_WeChatPushMain_Information>().Where(i => i.Status == 2); if (CurrentUser.GetCurrentUser().LoginName.ToLower() != "sysadmin") { var mainDep = _dbMsSql.Queryable <Master_Organization>().Where(i => i.ParentVguid == null).Select(i => i.Vguid).SingleOrDefault(); //大众交通集团 var listChildDep = _dbMsSql.Queryable <Master_Organization>().Where(i => i.ParentVguid == mainDep).Select(i => i.Vguid).ToList(); //大众出租租赁 listChildDep.Add(mainDep); Guid currentDep = Guid.Parse(CurrentUser.GetCurrentUser().Department); //首先查询登录人的部门 if (!listChildDep.Contains(currentDep)) { var listDep = _dbMsSql.SqlQuery <Guid>("SELECT * FROM dbo.TF_OrganizationFDetail('" + currentDep + "')"); //找到该部门以及其所有子部门 var list = _dbMsSql.Queryable <Sys_User>().In(i => i.Department, listDep).Select(i => i.LoginName).ToList(); query.Where(i => list.Contains(i.PushPeople)); //找到该部门中人员所推送的消息 } } if (!string.IsNullOrEmpty(searchParam.Title)) { query.Where(c => c.Title.Contains(searchParam.Title));//标题 } if (!string.IsNullOrEmpty(searchParam.PushType.ToString())) { query.Where(c => c.PushType == searchParam.PushType);//推送类型 } if (!string.IsNullOrEmpty(searchParam.Important.ToString())) { query.Where(c => c.Important == searchParam.Important);//是否重要 } if (!string.IsNullOrEmpty(searchParam.PeriodOfValidity.ToString())) { DateTime effectiveDate = DateTime.Parse(searchParam.PeriodOfValidity.ToString().Replace("0:00:00", "23:59:59")); query.Where(c => c.PeriodOfValidity < effectiveDate);//有效时间 } query.OrderBy(para.sortdatafield + " " + para.sortorder); int pageCount = 0; jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize, ref pageCount); jsonResult.TotalRows = pageCount; //存入操作日志表 string logData = JsonHelper.ModelToJson(jsonResult); _ll.SaveLog(3, 16, Common.CurrentUser.GetCurrentUser().LoginName, "推送已提交列表", logData); return(jsonResult); } }