public ActionResult ConvertToWord(string id, string printName) { LeaveEntity leave = leaveApp.GetForm(id); UserEntity user = userApp.GetForm(leave.F_UserId); UserEntity approvalLeader = userApp.GetForm(leave.F_ApprovalLeaderId); UserEntity checkLeader = userApp.GetForm(leave.F_CheckLeaderId); OrganizeEntity organ = organizeApp.GetForm(user.F_DepartmentId); RoleEntity role = roleApp.GetForm(user.F_RoleId); if (leaveApp.ConvertToWord(leave, user, checkLeader, approvalLeader, organ, role, printName)) { return(Success("操作成功。")); } return(Error("操作失败。")); }
public ActionResult GetProposalList(Pagination pagination, string keyword, string pro_dep, string pro_send_dep, DateTime?planBeginDate, DateTime?planEndDate, DateTime?cheDDBeginDate, DateTime?cheDDEndDate, string status) { try { bool isIE = false, isRevice = false; var departId = OperatorProvider.Provider.GetCurrent().DepartmentId; var departName = organizeApp.GetForm(departId).F_FullName; if (OperatorProvider.Provider.GetCurrent().UserName != "admin") { var RoleId = OperatorProvider.Provider.GetCurrent().RoleId; var roleList = roleApp.GetManList(); var role = roleApp.GetForm(RoleId); if (roleList.Contains(RoleId)) { isRevice = true; } if (role != null && (role.F_FullName.Equals("IE工程师") || role.F_FullName.Equals("厂长"))) { isIE = true; } } else { isIE = true; } var query = proposalApp.GetList(pagination, departName, keyword, pro_dep, pro_send_dep, planBeginDate, planEndDate, cheDDBeginDate, cheDDEndDate, status, isIE, isRevice); var data = new { rows = query, total = pagination.total, page = pagination.page, records = pagination.records }; return(Content(data.ToJson())); } catch (Exception ex) { new ErrorLogApp().SubmitForm(ex); return(Content(ex.ToJson())); } }
public ActionResult GetFormJson(string keyValue) { var data = roleApp.GetForm(keyValue); if (data.F_LastModifyUserId != null) { var data1 = userApp.GetForm(data.F_LastModifyUserId); if (data1 != null) { data.F_LastModifyUserId = data1.F_RealName; } } if (data.F_CreatorUserId != null) { var data2 = userApp.GetForm(data.F_CreatorUserId); if (data2 != null) { data.F_CreatorUserId = data2.F_RealName; } } return(Content(data.ToJson())); }
public ActionResult GetFormJson(string keyValue) { var data = roleApp.GetForm(keyValue); return(Content(data.ToJson())); }
public ActionResult Info() { var user = OperatorProvider.Provider.GetCurrent(); var entity = userApp.GetForm(user.UserId); string OrganizeName = string.Empty; ViewBag.OrganizeName = organizeApp.GetForm(entity.F_OrganizeId)?.F_FullName; ViewBag.DepartmentName = organizeApp.GetForm(entity.F_DepartmentId)?.F_FullName; ViewBag.RoleName = string.IsNullOrWhiteSpace(entity.F_RoleId) == true ? "" : roleApp.GetForm(entity.F_RoleId)?.F_FullName; ViewBag.Duty = string.IsNullOrWhiteSpace(entity.F_DutyId) == true ? "" : dutyApp.GetForm(entity.F_DutyId)?.F_FullName; return(View(entity)); }
public ActionResult GetFormJson(string keyValue) { var entity = roleApp.GetForm(keyValue); return(Content(entity.ToJson())); }
/// <summary> /// 获取系统默认考核方案 /// </summary> /// <param name="pagination">分页</param> /// <param name="templete_type">方案类型</param> /// <returns></returns> public List <TaskOverviewModel> GetTaskListOverview(Pagination pagination, string task_name, int?task_statue, int?task_type, string user_id) { StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append(@"SELECT td.id,td.task_name,td.assessment_start_time , td.assessment_end_time ,u.F_RealName AS task_sponsor_name,td.creator_user_id, uu.F_RealName AS creator_user_name, td.task_distribute_statue AS task_distribute_statue,td.task_type,td.create_time "); sqlBuilder.Append(@"FROM t_kpi_task_distribution td LEFT JOIN sys_user u ON td.task_sponsor=u.F_Id LEFT JOIN sys_user uu ON td.creator_user_id=uu.F_Id "); sqlBuilder.AppendFormat("WHERE td.statue=0 "); if (!string.IsNullOrEmpty(task_name)) { sqlBuilder.AppendFormat("AND td.task_name like '%{0}%' ", task_name); } if (task_statue != null) { sqlBuilder.AppendFormat("AND td.task_distribute_statue={0} ", task_statue); } if (task_type != null) { sqlBuilder.AppendFormat("AND td.task_type={0} ", task_type); if (task_type == 1) { //若个人方案 sqlBuilder.AppendFormat("AND uu.F_OrganizeId='{0}' ", OperatorProvider.Provider.GetCurrent().CompanyId); } } //客户经理权限:个人任务管理里只能看到已经分发给自己的任务 if (OperatorProvider.Provider.GetCurrent() == null) { return(null); } RoleEntity roleEntity = roleApp.GetForm(OperatorProvider.Provider.GetCurrent().RoleId); if (roleEntity == null) { return(null); } if (roleEntity.F_FullName.Equals("客户经理") || roleEntity.F_FullName.Equals("经理室")) { StringBuilder sqlBuilder2 = new StringBuilder(); sqlBuilder2.AppendFormat(@"SELECT a.* FROM ({0}) a INNER JOIN t_self_task_detail st ON st.task_object=a.id AND st.task_statue=2 AND st.person='{1}' ", sqlBuilder, OperatorProvider.Provider.GetCurrent().UserId); sqlBuilder = sqlBuilder2; } IEnumerable <TaskOverviewModel> retData = null; if (pagination == null || pagination.rows == 0) { retData = service.BasicQueryListT <TaskOverviewModel>(sqlBuilder.ToString()); } else { retData = service.FindListBySql <TaskOverviewModel>(sqlBuilder.ToString(), pagination); } return(retData == null ? null : retData.ToList()); }
public ActionResult GetFormJsonDetail(string keyValue) { var data = userApp.GetForm(keyValue); if (data.F_Gender != null) { string sql = "select * from Sys_ItemsDetail,Sys_Items where Sys_Items.F_Id = Sys_ItemsDetail.F_ItemId and Sys_Items.F_EnCode ='sex' and Sys_ItemsDetail.F_ItemCode = '" + data.F_Gender + "'"; List <ItemsDetailEntity> ItemsDetailEntityList = itemsDetailApp.FildSql(sql); if (ItemsDetailEntityList != null && ItemsDetailEntityList.Count > 0) { data.F_Gender = ItemsDetailEntityList[0].F_ItemName; } } if (data.F_IsAdministrator != null) { string sql = "select * from Sys_ItemsDetail,Sys_Items where Sys_Items.F_Id = Sys_ItemsDetail.F_ItemId and Sys_Items.F_EnCode ='userType' and Sys_ItemsDetail.F_ItemCode = '" + data.F_IsAdministrator + "'"; List <ItemsDetailEntity> ItemsDetailEntityList = itemsDetailApp.FildSql(sql); if (ItemsDetailEntityList != null && ItemsDetailEntityList.Count > 0) { data.F_IsAdministrator = ItemsDetailEntityList[0].F_ItemName; } } if (data.F_OrganizeId != null) { var data1 = organizeApp.GetForm(data.F_OrganizeId); if (data1 != null) { data.F_OrganizeId = data1.F_FullName; } } if (data.F_RoleId != null) { var data2 = roleApp.GetForm(data.F_RoleId); if (data2 != null) { data.F_RoleId = data2.F_FullName; } } if (data.F_DutyId != null) { var data3 = roleApp.GetForm(data.F_DutyId); if (data3 != null) { data.F_DutyId = data3.F_FullName; } } //if (data.F_LastModifyUserId != null) //{ // var data1 = userApp.GetForm(data.F_LastModifyUserId); // data.F_LastModifyUserId = data1.F_RealName; //} //if (data.F_CreatorUserId != null) //{ // var data2 = userApp.GetForm(data.F_CreatorUserId); // data.F_CreatorUserId = data2.F_RealName; //} return(Content(data.ToJson())); }