public async Task <IActionResult> ApproveReportList([FromBody] ApproveReportListRequest requestDto)
{
//申请人审批 也可以不是申请人
var commonReportBiz = new CommonReportThemeBiz();
var approveModel = await commonReportBiz.GetReportApproveModelByGuid(requestDto.ApproveGuid);
if (approveModel == null)
{
return(Failed(ErrorCode.DataBaseError, "无审批数据，请检查!"));
}
if (!approveModel.ApplyUserGuid.Equals(UserID))
{
return(Failed(ErrorCode.DataBaseError, "不是申请人，无权限操作该记录!"));
}
if (IsRightStatusForOperation(approveModel))
{
approveModel.ListApproverGuid = UserID;
approveModel.ApprovedReason = requestDto.ApprovedReason;
approveModel.ApprovedDatetime = DateTime.Now;
if (requestDto.ApproveStatus.ToString().Equals(ReportApproveStatusEnum.Adopt.ToString()))
{
//注意多一个状态
approveModel.ApproveScheduleEnum = ReportApproveScheduleEnums.Complete.ToString();
approveModel.ApproveStatus = ReportApproveStatusEnum.Adopt.ToString();
}
if (requestDto.ApproveStatus.ToString().Equals(ReportApproveStatusEnum.Reject.ToString()))
{
//运营拒绝后，审批单到了SqlWrite 还是 SqlApprove，暂定 SqlApprove
// SqlApprove可自己重写sql，也可以拒绝后到SqlWrite
approveModel.ApproveScheduleEnum = ReportApproveScheduleEnums.Approve.ToString();
approveModel.ApproveStatus = ReportApproveStatusEnum.Reject.ToString();
}
var result = await commonReportBiz.UpdateApproveModel(approveModel);
return(Success(result));
}
else
{
return(Failed(ErrorCode.DataBaseError, "该申请状态不是可审批状态，请检查!"));
}
}
public async Task <IActionResult> CancelMyApprove([FromBody] CancelMyApproveRequest requestDto)
{
var commonReportBiz = new CommonReportThemeBiz();
var approveModel = await commonReportBiz.GetReportApproveModelByGuid(requestDto.ApproveGuid);
if (!approveModel.ApplyUserGuid.Equals(UserID))
{
return(Failed(ErrorCode.UserData, "您不是该记录申请人，无法取消！"));
}
if (approveModel.ApproveScheduleEnum.Equals(ReportApproveScheduleEnums.Complete.ToString()))
{
return(Failed(ErrorCode.DataBaseError, "该记录状态为已完成，无法取消！"));
}
approveModel.ApproveStatus = ReportApproveStatusEnum.Cancel.ToString();//取消
approveModel.LastUpdatedDate = DateTime.Now;
approveModel.LastUpdatedBy = UserID;
var result = await commonReportBiz.UpdateApproveModel(approveModel);
return(Success(result));
}
public async Task <IActionResult> ITApproveSql([FromBody] ITApproveSqlRequest requestDto)
{
//var currentUserGuid = "f071f4959e9a4f118095f58de3ce548a";//zhikai
//if (!UserID.Equals(currentUserGuid))
//{
// return Failed(ErrorCode.DataBaseError, "您不是SQL审核人，无法操作!");
//}
var commonReportBiz = new CommonReportThemeBiz();
var approveModel = await commonReportBiz.GetReportApproveModelByGuid(requestDto.ApproveGuid);
if (approveModel == null)
{
return(Failed(ErrorCode.DataBaseError, "无审批数据，请检查!"));
}
if (approveModel.SQLWriterGuid.Equals(UserID))
{
return(Failed(ErrorCode.DataBaseError, "无法审批，SQL审批需要不同的人操作!"));
}
var themeModel = await commonReportBiz.GetReportThemeModelByThemeGuid(approveModel.ThemeGuid);
if (themeModel == null)
{
return(Failed(ErrorCode.DataBaseError, "无主题数据，请检查!"));
}
if (IsITSQLRightStatusForOperation(approveModel))
{
approveModel.ApprovedReason = requestDto.ApprovedReason;
approveModel.ApprovedDatetime = DateTime.Now;
approveModel.SQLApproverGuid = UserID;
approveModel.LastUpdatedBy = UserID;
approveModel.LastUpdatedDate = DateTime.Now;
var result = false;
if (requestDto.ApproveStatus.ToString().Equals(ReportApproveStatusEnum.Adopt.ToString()))
{
if (!IsRightSQLStr(requestDto.ThemeSqlStr))
{
return(Failed(ErrorCode.UserData, "SQL有误，请检查!"));
}
themeModel.SQLStr = requestDto.ThemeSqlStr;
themeModel.LastUpdatedBy = UserID;
themeModel.LastUpdatedDate = DateTime.Now;
approveModel.ApproveScheduleEnum = ReportApproveScheduleEnums.Approve.ToString();
approveModel.ApproveStatus = ReportApproveStatusEnum.Pending.ToString();
result = await commonReportBiz.UpdateThemeAndApproveModel(themeModel, approveModel);
}
if (requestDto.ApproveStatus.ToString().Equals(ReportApproveStatusEnum.Reject.ToString()))
{
if (string.IsNullOrWhiteSpace(requestDto.ApprovedReason))
{
return(Failed(ErrorCode.UserData, "审核驳回，原因不能为空！"));
}
approveModel.ApproveScheduleEnum = ReportApproveScheduleEnums.SqlWrite.ToString();
approveModel.ApproveStatus = ReportApproveStatusEnum.Reject.ToString();
result = await commonReportBiz.UpdateApproveModel(approveModel);
}
return(Success(result));
}
else
{
return(Failed(ErrorCode.DataBaseError, "该申请状态不是可审批状态，请检查!"));
}
}
public async Task <IActionResult> ITSubmitSqlOrRefuseDemand([FromBody] ITSubmitSqlOrRefuseDemandRequest requestDto)
{
//var currentUserGuid = "942c0c1db7794095ac9e2abfe6bde264";//zhiliang 942c0c1db7794095ac9e2abfe6bde264
//if (!UserID.Equals(currentUserGuid))
//{
// return Failed(ErrorCode.DataBaseError, "您不是SQL撰写人，无法操作!");
//}
var commonReportBiz = new CommonReportThemeBiz();
var approveModel = await commonReportBiz.GetReportApproveModelByGuid(requestDto.ApproveGuid);
if (approveModel == null)
{
return(Failed(ErrorCode.DataBaseError, "无审批数据，请检查!"));
}
var themeModel = await commonReportBiz.GetReportThemeModelByThemeGuid(approveModel.ThemeGuid);
if (themeModel == null)
{
return(Failed(ErrorCode.DataBaseError, "无主题数据，请检查!"));
}
if (IsITRightStatusForOperation(approveModel))
{
approveModel.ApprovedReason = requestDto.ApprovedReason;
approveModel.ApprovedDatetime = DateTime.Now;
approveModel.SQLWriterGuid = UserID;
approveModel.LastUpdatedBy = UserID;
approveModel.LastUpdatedDate = DateTime.Now;
var result = false;
if (requestDto.ApproveStatus.ToString().Equals(ReportApproveStatusEnum.Adopt.ToString()))
{
if (!IsRightSQLStr(requestDto.Sqlstr))
{
return(Failed(ErrorCode.UserData, "SQL有误，请检查!"));
}
themeModel.SQLStr = requestDto.Sqlstr;
themeModel.LastUpdatedBy = UserID;
themeModel.LastUpdatedDate = DateTime.Now;
approveModel.ApproveScheduleEnum = ReportApproveScheduleEnums.SqlWrite.ToString();
approveModel.ApproveStatus = ReportApproveStatusEnum.Pending.ToString();
var conditionModelList = new List <ReportConditionModel>();
foreach (var item in requestDto.ConditionInfoList)
{
if (!IsRightConditionSQLStr(item.FieldValueSql))
{
return(Failed(ErrorCode.UserData, "条件SQL有误，请检查!"));
}
var model = new ReportConditionModel
{
ConditionGuid = Guid.NewGuid().ToString("N"),
ThemeGuid = approveModel.ThemeGuid,
Name = item.Name,
FieldCode = item.FieldCode,
FieldValueSql = item.FieldValueSql,//需要加验证
IsRightSql = item.IsRightSql,
ValueType = item.ValueType,
ValueRange = item.ValueRange,
ExtensionField = "",
Sort = item.Sort,
CreatedBy = UserID,
CreationDate = DateTime.Now,
LastUpdatedBy = UserID,
LastUpdatedDate = DateTime.Now,
OrgGuid = "..",
Enable = true
};
conditionModelList.Add(model);
}
result = await commonReportBiz.UpdateThemeAndApproveModel(themeModel, approveModel, conditionModelList);
}
if (requestDto.ApproveStatus.ToString().Equals(ReportApproveStatusEnum.Reject.ToString()))
{
if (string.IsNullOrWhiteSpace(requestDto.ApprovedReason))
{
return(Failed(ErrorCode.UserData, "审核驳回，原因不能为空！"));
}
approveModel.ApproveScheduleEnum = ReportApproveScheduleEnums.Apply.ToString();
approveModel.ApproveStatus = ReportApproveStatusEnum.Reject.ToString();
result = await commonReportBiz.UpdateApproveModel(approveModel);
}
return(Success(result));
}
else
{
return(Failed(ErrorCode.DataBaseError, "该申请状态不是可审批状态，请检查!"));
}
}