/// <summary> /// 查询公告通知接受人情况表 /// 2018-12-24 /// add by lpl /// </summary> /// <param name="entity"></param> /// <returns></returns> public List <DocNotfPersonEntity> search(DocNotfPersonEntity entity, string limittime = null) { try { return(Dal.SearchQuery(entity, limittime)); } catch (Exception e) { throw e; } }
public string GetJieShouQk(string Id, string limit, string page) { var entity = new DocNotfPersonEntity() { ContentId = Id }; var data = new DocNotfPersonBall().search(entity); var pagecount = data.Count; //分页有空重写,linq实现的数据量过大效率会出现瓶颈 data = data.Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(limit)).Take(Convert.ToInt32(limit)).ToList(); var result = new LayTableModel <DocNotfPersonEntity> { code = 0, msg = "成功", count = pagecount, data = data }; return(JsonConvert.SerializeObject(result)); }
public string AddDoc(string title, string content, string sendname, string iszd, string filepath, string tglx) { string[] sendArray = sendname.Split(','); string Id = Guid.NewGuid().ToString(); DocumentNotificationEntity entity = new DocumentNotificationEntity() { Id = Id, Title = title, Publisher = CurrentUser.CrmUser.UserName, ReleaseTime = NowDate, Iszd = iszd, GGContent = content, Sendname = sendname, FilePath = filepath, Category = tglx, JieShouAllCount = sendArray.Length, JieShouCount = 0, //公共字段 CreateBy = CurrentUser.CrmUser.UserName, CreateOn = NowDate, CreatorId = CurrentUser.CrmUser.Id, UpdateBy = CurrentUser.CrmUser.UserName, UpdateOn = NowDate, UpdateId = CurrentUser.CrmUser.Id }; if (new DocumentNotificationBll().Insert(entity)) { List <DocNotfPersonEntity> list = new List <DocNotfPersonEntity>(); for (int i = 0; i < sendArray.Length; i++) { DocNotfPersonEntity docNotfPerson = new DocNotfPersonEntity() { Pid = sendArray[i], IsJS = "0",//默认不接受 Title = entity.Title, Publisher = entity.Publisher, ReleaseTime = entity.ReleaseTime, Category = entity.Category, //公共字段 RowStatus = 1, CreateBy = CurrentUser.CrmUser.UserName, CreateOn = NowDate, CreatorId = CurrentUser.CrmUser.Id, UpdateBy = CurrentUser.CrmUser.UserName, UpdateOn = NowDate, UpdateId = CurrentUser.CrmUser.Id, ContentId = Id }; list.Add(docNotfPerson); } //批量插入人员,后期把所有内容都写入都事务中去处理,防止插入数据失败,方便回滚 new DocNotfPersonBall().InsertNotfPerson(list); return("1"); } else { return("0"); } }
/// <summary> /// 获取公告通知表数据 /// add by lpl /// 2018-12-14 /// </summary> /// <param name="fileId"></param> /// <returns></returns> public string GetAllDoc(string limit, string page, string Title, string datafw, string Gglx) { #region 根据当前用户ID,取出属于当前用户的通告列表 ////取当前用户 //var usersId = _crmUserBll.GetUserEntity(CurrentUser.CrmUser.Id); ////搜索当前用户接受到的所有通知 //var personentity = new DocNotfPersonEntity() //{ // Pid = usersId.Id //}; //var person = new DocNotfPersonBall().search(personentity); ////拼接字符串,用来通知公告表筛选 //string jieshouGuid = ""; //foreach (DocNotfPersonEntity doc in person) //{ // jieshouGuid += "'" + doc.ContentId + "',"; //} //jieshouGuid = jieshouGuid.TrimEnd(','); ////jieshouGuid = jieshouGuid.TrimEnd('\''); #endregion var usersId = _crmUserBll.GetUserEntity(CurrentUser.CrmUser.Id); var entity = new DocumentNotificationEntity() { Title = Title, Category = Gglx }; var personentity = new DocNotfPersonEntity() { Title = Title, Category = Gglx, Pid = usersId.Id }; var data = new List <DocumentNotificationEntity>(); var data2 = new List <DocNotfPersonEntity>(); //领导权限 var userrole = new CrmUserRoleEntity() { UserId = usersId.Id, RoleId = "96518d03-85c3-4ec3-a42c-ad56b9501099" }; var list = new CrmUserRoleBll().GetSearchResult(userrole); //管理员权限 var adminrole = new CrmUserRoleEntity() { UserId = usersId.Id, RoleId = "09c19ef1-77ef-4483-b7db-c09284d0deff" }; var list2 = new CrmUserRoleBll().GetSearchResult(adminrole); //搜索条件 //是管理员或者领导 if (list.Count > 0 || list2.Count > 0) { //不查询接受人,全部可以看到 data = new DocumentNotificationBll().SearchQuery(entity, datafw); var pagecount = data.Count; //分页有空重写,linq实现的数据量过大效率会出现瓶颈 data = data.Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(limit)).Take(Convert.ToInt32(limit)).ToList(); var result = new LayTableModel <DocumentNotificationEntity> { code = 0, msg = "成功", count = pagecount, data = data }; return(JsonConvert.SerializeObject(result)); } else { //如果不是领导,而是接收人,则需要重新绑定数据源 data2 = new DocNotfPersonBall().search(personentity, datafw); //分页有空重写,linq实现的数据量过大效率会出现瓶颈 data2 = data2.Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(limit)).Take(Convert.ToInt32(limit)).ToList(); var pagecount = data2.Count; var result = new LayTableModel <DocNotfPersonEntity> { code = 0, msg = "成功", count = pagecount, data = data2 }; return(JsonConvert.SerializeObject(result)); } }