public string getArea()
{
claim = (JwtClaim)_accessor.HttpContext.Items["user"];
List <SYS_AREA> model = SystemService.getArea(connstr);
LayTableModel <List <SYS_AREA> > table = new LayTableModel <List <SYS_AREA> >();
table.message = "success";
table.code = 200;
table.total = model.Count;
table.rows = new Rows <List <SYS_AREA> >();
table.rows.item = new List <SYS_AREA>();
table.rows.item = model;
return(JsonConvert.SerializeObject(table));
}
public string getToDo()
{
claim = (JwtClaim)_accessor.HttpContext.Items["user"];
if (claim.area == 0)
{
claim.uid = "";
}
List <ToDoModel> model = ToDoService.getToDo(claim.uid, connstr);
LayTableModel <List <ToDoModel> > table = new LayTableModel <List <ToDoModel> >();
table.message = "success";
table.code = 200;
table.total = model.Count;
table.rows = new Rows <List <ToDoModel> >();
table.rows.item = new List <ToDoModel>();
table.rows.item = model;
return(JsonConvert.SerializeObject(table));
}
/// <summary>
/// add by lpl
/// 2019-1-3
/// 加载权利事项
/// </summary>
/// <param name="limit"></param>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult LoadItem(string limit, string page, string Item, string LX)
{
PowerItemEntity powerItemEntity = new PowerItemEntity()
{
LX = LX,
Item = Item
};
var data = new PowerItemBll().QueryList(powerItemEntity);
var pagecount = data.Count;
data = data.Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(limit)).Take(Convert.ToInt32(limit)).ToList();
var result = new LayTableModel <PowerItemEntity>
{
code = 0,
msg = "成功",
count = pagecount,
data = data
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
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));
}
/// <summary>
/// 公文管理展示
/// </summary>
/// <param name="limit"></param>每页显示数量
/// <param name="page"></param>当前页码
/// <returns></returns>
public string GongWenIndex(string limit, string page)
{
var user = CurrentUser.CrmUser;
//公文管理权限
bool isMangerGongWen = new CrmUserMenuBll().GetAuthorizationByUserId("OA", "MangerAuthorization", user.Id);
if (isMangerGongWen)
{
//用Linq分页，用ORM自身的非常慢，后面研究为什么这么慢
var data = new GongGaoMangerBll().QueryList();
var pagecount = data.Count;
data = data.Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(limit)).Take(Convert.ToInt32(limit)).ToList();
var result = new LayTableModel <GongGaoMangerEntity>
{
code = 0,
msg = "成功",
count = pagecount,
data = data
};
return(JsonConvert.SerializeObject(result));
}
else
{
//非管理权限，查询公文详情表
var data = new GongGaoDetialBll().QueryList(user.Id);
var pagecount = data.Count;
data = data.Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(limit)).Take(Convert.ToInt32(limit)).ToList();
var result = new LayTableModel <GongGaoDetialEntity>
{
code = 0,
msg = "成功",
count = pagecount,
data = data
};
return(JsonConvert.SerializeObject(result));
}
}
/// <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));
}
}