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