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