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