public ActionResult GetProjectPhaseList(int projectId)
{
try
{
var queryParams = new NameValueCollection();
if (!ParamHelper.CheckParaQ(ref queryParams))
{
return(Json(new ResponseEntity <int>(RegularFunction.RegularSqlRegexText), JsonRequestBehavior.AllowGet));
}
var query = new ProjectPhaseQuery(queryParams);
var sqlCondition = new StringBuilder();
sqlCondition.Append("ISNULL(IsDelete,0)!=1");
if (projectId != 0)
{
sqlCondition.Append(string.Format(" and projectId={0}", projectId));
}
PageRequest preq = new PageRequest
{
TableName = " [ProjectPhase] ",
Where = sqlCondition.ToString(),
Order = " Id ASC ",
IsSelect = true,
IsReturnRecord = true,
PageSize = query.PageSize,
PageIndex = query.PageIndex,
FieldStr = "*"
};
var result = new ProjectPhaseBLL().GetDataByPage(preq);
if (result != null)
{
result.ForEach(pp =>
{
pp.StartTimeStr = pp.StartTime.HasValue ? pp.StartTime.Value.ToString("yyyy-MM-dd") : string.Empty;
pp.PlannedStartTimeStr = pp.PlannedStartTime.HasValue ? pp.PlannedStartTime.Value.ToString("yyyy-MM-dd") : string.Empty;
pp.EndTimeStr = pp.EndTime.HasValue ? pp.EndTime.Value.ToString("yyyy-MM-dd") : string.Empty;
pp.PlannedEndTimeStr = pp.PlannedEndTime.HasValue ? pp.PlannedEndTime.Value.ToString("yyyy-MM-dd") : string.Empty;
});
}
var response = new ResponseEntity <object>(true, string.Empty,
new DataGridResultEntity <ProjectPhase>
{
TotalRecords = preq.Out_AllRecordCount,
DisplayRecords = preq.Out_PageCount,
ResultData = result
});
return(Json(response, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new ResponseEntity <object>(-999, string.Empty, ""), JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteRisk(RiskJsonRequest request)
{
var result = new ProjectPhaseBLL().GetDataById(request.projectPhaseId);
if (result == null)
{
return(Json(new ResponseEntity <int>(false, "阶段不存在", 0), JsonRequestBehavior.AllowGet));
}
var risks = new List <Risk>();
if (!string.IsNullOrEmpty(result.RiskJson))
{
risks = JsonConvert.DeserializeObject <List <Risk> >(result.RiskJson);
}
if (request.risk.id != 0) //更新
{
var targetRisk = risks.FirstOrDefault(t => t.id == request.risk.id);
risks.Remove(targetRisk);
}
string riskJson = JsonConvert.SerializeObject(risks);
var updateResult = new ProjectPhaseBLL().UpdateRisk(request.projectPhaseId, riskJson);
var response = new ResponseEntity <int>(updateResult.Success, updateResult.Message, updateResult.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{request.projectPhaseId}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveProjectPhase(ProjectPhase entity)
{
ResponseEntity <int> response;
if (entity.Id == 0)
{
entity.IsDelete = 0;
entity.CreateBy = "";
entity.CreateTime = DateTime.Now;
entity.UpdateBy = "";
entity.UpdateTime = DateTime.Now;
var result = new ProjectPhaseBLL().InsertProjectPhase(entity);
response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{result.Data}");
}
else
{
entity.UpdateBy = "";
entity.UpdateTime = DateTime.Now;
var result = new ProjectPhaseBLL().UpdateProjectPhase(entity);
response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{entity.Id}");
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult GetRiskSeverityList()
{
var riskSeveritiesStr = new ProjectPhaseBLL().getRiskSettings("TaskRiskSeverity");
var riskSeverities = riskSeveritiesStr.Split(';');
var response = new ResponseEntity <string[]>(true, "", riskSeverities);
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult GetTaskSubjectList()
{
var tasksStr = new ProjectPhaseBLL().GetTaskSubjects();
var tasks = tasksStr.Split(';');
var response = new ResponseEntity <string[]>(true, "", tasks);
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateLinkedForm(LinkedFormJsonRequest request)//int projectPhaseId, string linkedFormJson) //更新阶段的关联表单
{
var result = new ProjectPhaseBLL().UpdateLinkedForm(request.projectPhaseId, request.linkedFormJson);
var response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{request.projectPhaseId}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
//[AcceptVerbs(HttpVerbs.Get)]
public ActionResult UpdateAMDList(int projectPhaseId, string amdContentJson) //更新阶段的文档列表
{
var result = new ProjectPhaseBLL().UpdateAMDContent(projectPhaseId, amdContentJson);
var response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{projectPhaseId}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateStatus(int Id, int status) //
{
var result = new ProjectPhaseBLL().UpdateStatus(Id, status);
var response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{Id}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult GetProjectPhaseById(int Id)
{
var result = new ProjectPhaseBLL().GetDataById(Id);
if (result != null)
{
var response = new ResponseEntity <ProjectPhase>(true, ConstantDefine.TipQuerySuccess, result);
return(Json(response, JsonRequestBehavior.AllowGet));
}
else
{
var response = new ResponseEntity <ProjectPhase>(ConstantDefine.TipQueryFail);
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateTask(TaskJsonRequest request)
{
var result = new ProjectPhaseBLL().GetDataById(request.projectPhaseId);
if (result == null)
{
return(Json(new ResponseEntity <int>(false, "阶段不存在", 0), JsonRequestBehavior.AllowGet));
}
var tasks = new List <Task>();
if (!string.IsNullOrEmpty(result.TaskJson))
{
tasks = JsonConvert.DeserializeObject <List <Task> >(result.TaskJson);
}
if (!request.newTask) //更新
{
var targetTask = tasks.FirstOrDefault(t => t.id == request.task.id);
if (targetTask.id != 0)
{
targetTask.subject = request.task.subject;
targetTask.log = request.task.log;
targetTask.owner = request.task.owner;
targetTask.description = request.task.description;
//targetTask.detail = request.task.detail;
targetTask.startTime = request.task.startTime;
targetTask.endTime = request.task.endTime;
targetTask.updateTime = request.task.updateTime;
targetTask.workaround = request.task.workaround;
targetTask.status = request.task.status;
}
}
else //插入新的task
{
tasks.Add(request.task);
}
string taskJson = JsonConvert.SerializeObject(tasks);
var updateResult = new ProjectPhaseBLL().UpdateTask(request.projectPhaseId, taskJson);
var response = new ResponseEntity <int>(updateResult.Success, updateResult.Message, updateResult.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{request.projectPhaseId}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateRisk(RiskJsonRequest request)
{
var result = new ProjectPhaseBLL().GetDataById(request.projectPhaseId);
if (result == null)
{
return(Json(new ResponseEntity <int>(false, "阶段不存在", 0), JsonRequestBehavior.AllowGet));
}
var risks = new List <Risk>();
if (!string.IsNullOrEmpty(result.RiskJson))
{
risks = JsonConvert.DeserializeObject <List <Risk> >(result.RiskJson);
}
if (!request.newRisk) //更新
{
var targetRisk = risks.FirstOrDefault(t => t.id == request.risk.id);
if (targetRisk.id != 0)
{
targetRisk.riskType = request.risk.riskType;
targetRisk.severity = request.risk.severity;
targetRisk.detail = request.risk.detail;
targetRisk.nextSteps = request.risk.nextSteps;
targetRisk.assignedTo = request.risk.assignedTo;
targetRisk.targetDate = request.risk.targetDate;
targetRisk.status = request.risk.status;
targetRisk.workaround = request.risk.workaround;
}
}
else
{ //插入新的risk
risks.Add(request.risk);
}
string riskJson = JsonConvert.SerializeObject(risks);
var updateResult = new ProjectPhaseBLL().UpdateRisk(request.projectPhaseId, riskJson);
var response = new ResponseEntity <int>(updateResult.Success, updateResult.Message, updateResult.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateProjectPhase, $"{request.projectPhaseId}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult CompletePhase(int Id) //
{
var entity = new ProjectPhaseBLL().GetDataById(Id);
if (entity != null && entity.Status == 2)
{
return(Json(new ResponseEntity <object>(0, "该项目阶段已经完成", ""), JsonRequestBehavior.AllowGet));
}
var result = new ProjectPhaseBLL().CompletePhase(Id, 2);
var response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionCompletePhase, $"{Id}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult StartProjectPhase(int Id) //
{
var entity = new ProjectBLL().GetDataById(Id);
if (entity != null && entity.Status != (int)ProjectProgressStatus.NotStarted)
{
return(Json(new ResponseEntity <object>(-999, "项目已经启动", ""), JsonRequestBehavior.AllowGet));
}
var result = new ProjectPhaseBLL().StartProjectPhase(Id);
var response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleProject,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionStartPhase, $"{Id}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
