public ActionResult GetGridJson(Pagination pagination, string keyword)
{
var data = new
{
rows = userApp.GetList(pagination, keyword),
total = pagination.total,
page = pagination.page,
records = pagination.records
};
return(Content(data.ToJson()));
}
public ActionResult GetGridJson(Pagination pagination, string keyword)
{
var newsTypeList = fileApp.GetList();
var listResult = (from a in fileApp.GetList(pagination, keyword)
join b in userApp.GetList() on a.F_UploadUser equals b.F_Id into team
from c in team.DefaultIfEmpty()
select new FileEntity()
{
F_FileMax = a.F_FileMax,
F_Id = a.F_Id,
F_FileName = a.F_FileName,
F_FileVersion = a.F_FileVersion,
F_UploadDate = a.F_UploadDate,
F_UploadUser = c.F_RealName
}).ToList();
var data = new
{
rows = listResult,
total = pagination.total,
page = pagination.page,
records = pagination.records
};
return(Content(data.ToJson()));
}
//
// GET: /StatisticsManage/Department/
public override ActionResult Index()
{
string organizeId = Common.GetString("organizeid");
string startDT = Common.GetString("startdt"); // Request["StartDT"];
string endDT = Common.GetString("enddt"); // Request["EndDT"];
UserApp userApp = new UserApp();
organizeId = string.IsNullOrEmpty(organizeId) ? NFine.Code.OperatorProvider.Provider.GetCurrent().CompanyId : organizeId;//获取到当前的组织结构id
//todo 找出该组织的下级
OrganizeApp organizeApp = new OrganizeApp();
var organizeData = organizeApp.GetList(organizeId);
List <string> listOrganizeId = organizeData.Select(x => x.F_Id).ToList();// new List<string>() { organizeId };
//var userData = userApp.GetList(listOrganizeId);
ViewBag.OrganizeList = organizeData.Select(x => x.F_FullName).ToJson();
//todo 找出每个员工的完成情况 放入内存中 执行逻辑操作
TaskApp taskApp = new TaskApp();
//var taskData = taskApp.GetList(userData.Select(x => x.F_Id).ToList());
List <Report> listReports = new List <Report>();
ItemsDetailApp itemsDetailApp = new ItemsDetailApp();
var itemsData = itemsDetailApp.GetItemList(schedule);
foreach (var item in itemsData)
{
Report report = new Report();
report.name = item.F_ItemName;
List <int> listCount = new List <int>();
foreach (var organizeItem in organizeData)
{
//todo 获取组织下的所有员工
//获取组织下的组织
var data = organizeApp.GetAllList(organizeItem.F_Id);
List <string> listOrganizeNext = new List <string>();
foreach (var organizeItemNext in data)
{
listOrganizeNext.Add(organizeItemNext);
}
//获取下级下的所有员工
var userData = userApp.GetList(listOrganizeNext);
//获取下级下的所有员工的任务
var taskData = taskApp.GetList(userData.Select(x => x.F_Id).ToList());
if (!string.IsNullOrEmpty(startDT))
{
var time = Utils.ObjectToDateTime(startDT);
taskData = taskData.Where(d => d.F_CreatorTime > time).ToList();
}
if (!string.IsNullOrEmpty(endDT))
{
var time = Utils.ObjectToDateTime(endDT);
taskData = taskData.Where(d => d.F_CreatorTime <= time).ToList();
}
listCount.Add(taskData.Count(d => d.F_Status == item.F_Id));
}
report.data = listCount;
listReports.Add(report);
}
ViewBag.Series = listReports.ToJson();
return(View());
}
public ActionResult GetGridJson(Pagination pagination, string keyword)
{
pagination.sord = "asc";
pagination.sidx = "F_DepartmentId";
var data = userApp.GetList(pagination, keyword);
return(DataGrid(pagination.records, data));
}
public ActionResult GetGridJson(Pagination pagination, string keyword)
{
pagination.order = "asc";
pagination.sort = "F_DepartmentId";
var data = userApp.GetList(pagination, keyword);
return(ResultLayUiTable(pagination.records, data));
}
public ActionResult Default()
{
var organizeId = NFine.Code.OperatorProvider.Provider.GetCurrent().CompanyId;//获取到当前的组织结构id
UserApp userApp = new UserApp();
TaskApp taskApp = new TaskApp();
OrganizeApp organizeApp = new OrganizeApp();
var organizeData = organizeApp.GetAllList(organizeId);
List <string> listOrganizeNext = new List <string>();
foreach (var item in organizeData)
{
listOrganizeNext.Add(item);
}
var userData = userApp.GetList(listOrganizeNext);
var taskData = taskApp.GetList(userData.Select(x => x.F_Id).ToList());
DateTime dt = DateTime.Now; //当前时间
//当天待处理任务
ViewBag.DayTaskDoing = taskData.Count(d => d.F_Status == Doing && d.F_CreatorTime > dt.AddDays(-1) && d.F_CreatorTime <= dt);
//本周待处理任务
DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一
DateTime endWeek = startWeek.AddDays(6); //本周周日
ViewBag.WeekTaskDoing = taskData.Count(d => d.F_Status == Doing && d.F_CreatorTime > startWeek && d.F_CreatorTime <= endWeek);
//本周已处理任务
ViewBag.WeekTaskDone = taskData.Count(d => d.F_Status == Done && d.F_CreatorTime > startWeek && d.F_CreatorTime <= endWeek);
//本月待处理任务
DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初
DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末
//本月任务
var tempTask = taskData.Where(d => d.F_CreatorTime > startMonth && d.F_CreatorTime <= endMonth).ToList();
//本月待处理
ViewBag.MonthTaskDoing = tempTask.Count(d => d.F_Status == Doing);
//本月已处理任务
ViewBag.MonthTaskDone = tempTask.Count(d => d.F_Status == Done);
//本月未完成
ViewBag.MonthTaskNone = tempTask.Count(d => d.F_Status != Done && d.F_Status != Doing);
//最近6个月的完成情况
List <int> listLineChartData = new List <int>();
List <string> listLineChartName = new List <string>();
for (int i = 6; i > 0; i--)
{
startMonth = dt.AddMonths(-i).AddDays(1 - dt.Day); //当月月初
endMonth = startMonth.AddMonths(1).AddDays(-1); //当月月末
var tempCount = taskData.Count(d => d.F_Status == Done && d.F_CreatorTime > startMonth && d.F_CreatorTime <= endMonth);
listLineChartData.Add(tempCount);
listLineChartName.Add(dt.AddMonths(-i).Year + "年" + dt.AddMonths(-i).Month + "月");
}
ViewBag.LineChartData = listLineChartData.ToJson();
ViewBag.LineChartName = listLineChartName.ToJson();
return(View());
}
public ActionResult GetGridJson(Pagination pagination, string keyword)
{
var companyId = OperatorProvider.Provider.GetCurrent().CompanyId;
var data = new
{
rows = _userApp.GetList(pagination, keyword, companyId),
total = pagination.total,
page = pagination.page,
records = pagination.records
};
return(Content(data.ToJson()));
}
public ActionResult GetGridJson(Pagination pagination, string keyword)
{
string organizeId = Common.GetString("organizeid"); //组织id
string startTime = Common.GetString("startdt"); // 开始时间
string endTime = Common.GetString("enddt"); // 结束时间
string schedule = Common.GetString("schedule"); //进度
//TODO 找出该组织下的员工
UserApp userApp = new UserApp();
var userData = userApp.GetList(pagination, keyword, organizeId);
//ViewBag.UserList = userData.Select(x => x.F_RealName).ToJson();
//todo 找出每个员工的完成情况 放入内存中 执行逻辑操作
TaskApp taskApp = new TaskApp();
var taskData = taskApp.GetList(userData.Select(x => x.F_Id).ToList());
List <Series> list = new List <Series>();
foreach (var item in userData)
{
Series series = new Series();
series.id = item.F_Id;
series.name = item.F_RealName;
series.tel = item.F_MobilePhone;
var tempTask = taskData.Where(d => d.F_UserId == item.F_Id);
if (!string.IsNullOrEmpty(schedule))
{
tempTask = tempTask.Where(d => d.F_Status == schedule);
}
if (!string.IsNullOrEmpty(startTime))
{
tempTask = tempTask.Where(d => d.F_CreatorTime > Utils.ObjectToDateTime(startTime));
}
if (!string.IsNullOrEmpty(endTime))
{
tempTask = tempTask.Where(d => d.F_CreatorTime <= Utils.ObjectToDateTime(endTime));
}
series.count = tempTask.Count();
series.schedule = schedule;
list.Add(series);
}
var data = new
{
rows = list,
total = pagination.total,
page = pagination.page,
records = pagination.records
};
return(Content(data.ToJson()));
}
public ActionResult GetGridJson(Pagination pagination, string keyword)
{
var watch = Common.TimerStart();
var data = userApp.GetList(pagination, keyword);
var jsondata = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = Common.TimerEnd(watch)
};
return(ToJsonResult(jsondata));
}
//[HttpGet]
//[HttpPost]
//[HandlerAjaxOnly]
public ActionResult GetSysUserJson(string keyValue)
{
RoleEntity role = (new RoleApp()).GetModel(keyValue);
UserApp userApp = new UserApp();
var data = userApp.GetList("");
if (role != null)
{
data = data.FindAll(p => p.F_RoleId == role.F_Id && p.F_EnabledMark == true);
}
else
{
data = userApp.GetUserList("");
}
return(Content(data.ToJson()));
}
private object GetUserList()
{
UserApp userApp = new UserApp();
var data = userApp.GetList();
Dictionary <string, object> dictionary = new Dictionary <string, object>();
foreach (UserEntity item in data)
{
var fieldItem = new
{
encode = item.F_Account,
fullname = item.F_RealName
};
dictionary.Add(item.F_Id, fieldItem);
}
return(dictionary);
}
//[HttpGet]
//[HttpPost]
//[HandlerAjaxOnly]
public ActionResult GetSysUserJson(string keyValue)
{
RoleEntity role = (new RoleApp()).GetModel(keyValue);
UserApp userApp = new UserApp();
var data = userApp.GetList("");
if (role != null)
{
data = data.FindAll(p => p.F_RoleId == role.F_Id && p.F_EnabledMark == true);
}
else
{
data = userApp.GetUserList("");
}
for (int i = 0; i < data.Count; i++)
{
data[i].F_DepartmentId = CommonApp.GetDepartName(data[i].F_DepartmentId);
}
return(Content(data.ToJson()));
}
public ActionResult GetGridJson(Pagination pagination, string keyword, string itemId)
{
List <string> list = null;
if (!string.IsNullOrEmpty(keyword))
{
list = OrganizeApp.getDepartByName(keyword);
}
var query = userApp.GetList(pagination, keyword, itemId, list);
query = query.OrderByDescending(q => q.F_Id).Skip((pagination.page - 1) * pagination.rows).Take(pagination.rows).ToList();
var data = new
{
rows = query,
total = pagination.total,
page = pagination.page,
records = pagination.records
};
return(Content(data.ToJson()));
}
public ActionResult CreateSysUser()
{
List <UserEntity> sysusers = new List <UserEntity>();
UserApp userApp = new UserApp();
var data = app.GetList("");
foreach (DingTalkUserEntity dduser in data)
{
UserEntity user = sysusers.Find(t => t.F_DingTalkUserId == dduser.UserId && dduser.UserName == t.F_DingTalkUserName);
if (user == null)
{
UserEntity model = new UserEntity();
model.F_Account = ZhPinyinHelper.ChConvertPinyin(dduser.UserName);
model.F_RealName = dduser.UserName;
model.F_NickName = dduser.UserName;
model.F_DepartmentId = "80E10CD5-7591-40B8-A005-BCDE1B961E76";
model.F_DutyId = "23ED024E-0AAA-4C8D-9216-D1AB93348D26";
model.F_OrganizeId = "5AB270C0-5D33-4203-A54F-4552699FDA3C";
model.F_RoleId = "2691AB91-3010-465F-8D92-60A97425A45E";
model.F_Gender = true;
model.F_EnabledMark = true;
model.F_IsAdmin = false;
model.F_DingTalkUserId = dduser.UserId;
model.F_DingTalkUserName = dduser.UserName;
model.F_DingTalkAvatar = dduser.Avatar;
model.F_MobilePhone = dduser.Mobile;
UserLogOnEntity userLogOnEntity = new UserLogOnEntity();
userLogOnEntity.F_UserPassword = "******";
userApp.SubmitForm(model, userLogOnEntity, null);
}
}
DingTalkUserEntity entity = new DingTalkUserEntity();
sysusers = userApp.GetList("");
return(Success("发送成功。"));
}
public List <AttachmentEntity> GetList(Pagination pagination, string keyword)
{
// 获取当前登录用户ID和部门ID
string userID = OperatorProvider.Provider.GetCurrent().UserId;
string departID = OperatorProvider.Provider.GetCurrent().DepartmentId;
// 获取当前用户实体对象
UserApp userApp = new UserApp();
UserEntity user = userApp.GetList().Find(t => t.F_Id == userID);
// 查找当前用户所在部门及下级部门
string childIDs = GetAllChild((new OrganizeApp()).GetList(), departID);
string departandChildIDs = "'" + departID + "'" + (childIDs.IsEmpty() ? "" : "," + childIDs);
departandChildIDs = departandChildIDs.ToLower();
var expression = ExtLinq.True <AttachmentEntity>();
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.F_Name.Contains(keyword));
}
if (user != null)
{
switch (user.F_AttachmentLevel)
{
case 1:
// 仅本人
expression = expression.And(t => t.F_CreatorUserId.Equals(userID, StringComparison.CurrentCultureIgnoreCase));
break;
case 2:
// 仅本部门
{
var userList = userApp.GetList().FindAll(t => t.F_DepartmentId.Equals(departID, StringComparison.CurrentCultureIgnoreCase));
string userIDs = ""; userList.ForEach(t => userIDs += (userIDs.IsEmpty() ? "'" : ",'") + t.F_Id.ToLower() + "'");
expression = expression.And(t => userIDs.Contains(t.F_CreatorUserId));
}
break;
case 3:
// 本部门及下级
{
var userList = userApp.GetList().FindAll(t => departandChildIDs.Contains(t.F_DepartmentId.ToLower()));
string userIDs = ""; userList.ForEach(t => userIDs += (userIDs.IsEmpty() ? "'" : ",'") + t.F_Id.ToLower() + "'");
expression = expression.And(t => userIDs.Contains(t.F_CreatorUserId));
}
break;
case 9:
// 所有
break;
default:
break;
}
}
else
{
expression = expression.And(t => false);
}
return(service.FindList(expression, pagination));
}
public ActionResult GetListJson()
{
var data = userApp.GetList();
return(Content(data.ToJson()));
}
public ActionResult GetGridDataStatisticsJson(Pagination pagination, string keyword, string starttime)
{
DateTime now = DateTime.Now;
if (!string.IsNullOrEmpty(starttime))
{
now = starttime.ToDate();
}
var lists = new List <DataStatisticsForm>();
foreach (var item in userApp.GetList(pagination, keyword))
{
var list = new DataStatisticsForm();
list.F_DepartmentId = item.F_DepartmentId;
list.F_Id = item.F_Id;
list.name = item.F_RealName;
var baocan = reportApp.GetCurrentTime(item.F_Id, now, 1);
list.baocan = "未报";
if (baocan != null)
{
list.baocan = "已报";
}
var attl = attlApp.GetCurrentTime(item.F_AttCard, now, true);
list.shangban = "×";
if (attl != null)
{
list.shangban = "√";
}
var attl2 = attlApp.GetCurrentTime(item.F_AttCard, now, false);
list.xiaban = "×";
if (attl2 != null)
{
list.xiaban = "√";
}
var pos = posApp.GetCurrentTime(item.F_PosCard, now, 0);
list.zaocan = "×";
if (pos != null)
{
list.zaocan = "√";
}
var pos1 = posApp.GetCurrentTime(item.F_PosCard, now, 1);
list.wucan = "×";
if (pos1 != null)
{
list.wucan = "√";
}
var pos2 = posApp.GetCurrentTime(item.F_PosCard, now, 2);
list.wancan = "×";
if (pos2 != null)
{
list.wancan = "√";
}
int bu = 0;
int kou = 0;
PosT(now, item.F_PosCard, item.F_AttCard, item.F_Id, out bu, out kou);
list.yujibuzhu = (bu * 15).ToString();
list.cishu = (kou).ToString();
lists.Add(list);
}
var data = new
{
rows = lists,
total = pagination.total,
page = pagination.page,
records = pagination.records
};
return(Content(data.ToJson()));
}
public ActionResult GetAllGridJson(string keyword)
{
var data = userApp.GetList(keyword);
return(Content(data.ToJson()));
}