public List <StepBackBO> GetListNextStepBack(WF_PROCESS process)
{
var query = (from step in this.context.WF_STEP.Where(x => x.WF_ID == process.WF_ID && x.STATE_END == process.CURRENT_STATE && x.IS_RETURN == true)
join tblLog in this.context.WF_LOG.Where(x => x.ITEM_ID == process.ITEM_ID && x.IS_RETURN != true && x.ITEM_TYPE == process.ITEM_TYPE && x.NGUONHAN_ID == process.USER_ID && x.STEP_ID != null)
on step.ID equals tblLog.STEP_ID into jlog
where jlog.Any()
select new StepBackBO()
{
ID = step.ID,
//NAME = "Trả về " + step.NAME,
NAME = "Trả về ",
STATE_BEGIN = step.STATE_END,
STATE_END = step.STATE_BEGIN,
WF_ID = step.WF_ID,
Log = jlog.OrderByDescending(x => x.create_at).FirstOrDefault()
}).ToList();
return(query);
}
public ActionResult DetailVanBanDen(long id, int type = VANBANDEN_CONSTANT.CHUA_XULY)
{
AssignUserInfo();
wfItemUserProcess = Get <WF_ITEM_USER_PROCESSBusiness>();
wfReviewUserBusiness = Get <WF_REVIEW_USERBusiness>();
dmDanhMucDataBusiness = Get <DM_DANHMUC_DATABusiness>();
hscvVanBanDenBusiness = Get <HSCV_VANBANDENBusiness>();
attachmentBusiness = Get <TAILIEUDINHKEMBusiness>();
var HSCVREADVANBANBusiness = Get <HSCVREADVANBANBusiness>();
HSCV_VANBANDEN entityVanBanDen = hscvVanBanDenBusiness.Find(id);
bool canAccess = wfItemUserProcess.CheckPermissionProcess(id, true == entityVanBanDen.IS_NOIBO ? MODULE_CONSTANT.VANBANDENNOIBO : MODULE_CONSTANT.VANBANDEN, currentUser.ID);
bool canReview = wfReviewUserBusiness.CheckPermissionReview(id, true == entityVanBanDen.IS_NOIBO ? MODULE_CONSTANT.VANBANDENNOIBO : MODULE_CONSTANT.VANBANDEN, currentUser.ID);
if ((!canAccess && !canReview) || entityVanBanDen == null)
{
return(Redirect("/Home/UnAuthor"));
}
var checkread = HSCVREADVANBANBusiness.repository.All()
.Where(x => x.USER_ID == currentUser.ID && x.TYPE == 1 && x.VANBAN_ID == id).FirstOrDefault();
if (checkread == null)
{
HSCV_READVANBAN readObj = new HSCV_READVANBAN();
readObj.TYPE = 1;
readObj.USER_ID = currentUser.ID;
readObj.VANBAN_ID = id;
HSCVREADVANBANBusiness.Save(readObj);
}
DetailVanBanDenViewModel model = new DetailVanBanDenViewModel();
DM_DANHMUC_DATA entityDonViGui = dmDanhMucDataBusiness.Find(entityVanBanDen.DONVI_ID);
DM_DANHMUC_DATA entityDoKhan = dmDanhMucDataBusiness.Find(entityVanBanDen.DOKHAN_ID);
DM_DANHMUC_DATA entityDoUuTien = dmDanhMucDataBusiness.Find(entityVanBanDen.DOMAT_ID);
DM_DANHMUC_DATA entityLinhVucVanBan = dmDanhMucDataBusiness.Find(entityVanBanDen.LINHVUCVANBAN_ID);
DM_DANHMUC_DATA entityLoaiVanBan = dmDanhMucDataBusiness.Find(entityVanBanDen.LOAIVANBAN_ID);
DM_DANHMUC_DATA entityLoaiCoQuan = dmDanhMucDataBusiness.Find(entityVanBanDen.LOAI_COQUAN_ID);
DM_DANHMUC_DATA entityThongTinLoaiVanBan = dmDanhMucDataBusiness.Find(entityVanBanDen.THONGTIN_LOAI_ID);
DM_DANHMUC_DATA entityCongVanDen = dmDanhMucDataBusiness.Find(entityVanBanDen.CONGVAN_DEN_ID);
model.currentUserId = currentUser.ID;
model.entityVanBanDen = entityVanBanDen;
model.nameOfDonViGui = entityDonViGui != null ? entityDonViGui.TEXT : string.Empty;
model.nameOfDoKhan = entityDoKhan != null ? entityDoKhan.TEXT : string.Empty;
model.nameOfDoUuTien = entityDoUuTien != null ? entityDoUuTien.TEXT : string.Empty;
model.nameOfLinhVucVanBan = entityLinhVucVanBan != null ? entityLinhVucVanBan.TEXT : string.Empty;
model.nameOfLoaiVanBan = entityLoaiVanBan != null ? entityLoaiVanBan.TEXT : string.Empty;
model.nameOfLoaiCoQuan = entityLoaiCoQuan != null ? entityLoaiCoQuan.TEXT : string.Empty;
model.nameOfThongTinLoaiBan = entityThongTinLoaiVanBan != null ? entityThongTinLoaiVanBan.TEXT : string.Empty;
model.nameOfCongVanDen = entityCongVanDen != null ? entityCongVanDen.TEXT : string.Empty;
model.groupOfTaiLieuDinhKems = attachmentBusiness.GetDataByItemID(entityVanBanDen.ID, LOAITAILIEU.VANBANDEN);
model.typeOfVanBanDen = type;
bool isFinish = hscvVanBanDenBusiness.CheckIsFinish(id);
model.canCreateCalendar = (entityVanBanDen.NGUOITAO == currentUser.ID && isFinish);
if (isFinish == false && entityVanBanDen.NGAYCONGTAC != null)
{
//kiểm tra người dùng có bước xử lý hay không?
bool hasSteps = false;
wfProcessBusiness = Get <WF_PROCESSBusiness>();
wfReviewUserBusiness = Get <WF_REVIEW_USERBusiness>();
wfReviewBusiness = Get <WF_REVIEWBusiness>();
wfStateBusiness = Get <WF_STATEBusiness>();
wfStepBusiness = Get <WF_STEPBusiness>();
wfStateFunctionBusiness = Get <WF_STATE_FUNCTIONBusiness>();
WF_PROCESS process = wfProcessBusiness.repository.All()
.Where(x => x.ITEM_ID == id && x.ITEM_TYPE == MODULE_CONSTANT.VANBANDEN &&
x.USER_ID == currentUser.ID).FirstOrDefault();
WF_REVIEW reviewReject = wfReviewBusiness.repository.All()
.Where(x => x.ITEMID == id && x.ITEMTYPE == MODULE_CONSTANT.VANBANDEN && x.IS_REJECT == true)
.OrderByDescending(x => x.ID).FirstOrDefault();
WF_FUNCTION function = null;
bool requireReview = false;
List <WF_STEP> nextSteps = new List <WF_STEP>();
List <StepBackBO> stepsBack = new List <StepBackBO>();
if (process != null)
{
if (process != null || reviewReject != null)
{
WF_STATE startState = wfStateBusiness.Find(process.CURRENT_STATE);
if (startState != null)
{
if (startState.IS_KETTHUC != true)
{
nextSteps = wfStepBusiness.GetListNextStep(process.WF_ID.GetValueOrDefault(), startState.ID);
stepsBack = wfStepBusiness.GetListNextStepBack(process);
}
function = wfStateFunctionBusiness.CheckGetFunction(startState.ID, entityVanBanDen.ID, MODULE_CONSTANT.VANBANDEN);
}
}
else if (process.IS_PENDING == true)
{
WF_REVIEW reviewFinish = wfReviewBusiness.repository.All()
.Where(x => x.ITEMID == id && x.ITEMTYPE == MODULE_CONSTANT.VANBANDEN && x.IS_FINISH != true)
.OrderByDescending(x => x.ID).FirstOrDefault();
if (reviewFinish != null)
{
requireReview = wfReviewUserBusiness.CheckReviewing(reviewFinish.ID, currentUser.ID);
}
}
hasSteps = (nextSteps.Any() || stepsBack.Any() || function != null || requireReview == true);
}
model.hasSteps = hasSteps;
if (hasSteps)
{
entityVanBanDen.NGAYCONGTAC = new DateTime(entityVanBanDen.NGAYCONGTAC.Value.Year, entityVanBanDen.NGAYCONGTAC.Value.Month, entityVanBanDen.NGAYCONGTAC.Value.Day);
lichCongTacBusiness = Get <LICHCONGTACBusiness>();
model.isDuplicateCalendar = lichCongTacBusiness.repository.All()
.Where(x => x.LANHDAO_ID == currentUser.ID &&
x.NGAY_CONGTAC.Equals(entityVanBanDen.NGAYCONGTAC.Value)).Count() > 0;
}
}
return(View(model));
}
