public ActionResult EditHoSo(long id)
{
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
HOSOCANBOBusiness = Get <HOSOCANBOBusiness>();
HoSoCanBoVM model = new HoSoCanBoVM();
model.HoSo = HOSOCANBOBusiness.Find(id);
model.LstGioiTinh = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_GIOITINH", 0, model.HoSo.GIOITINH.HasValue ? model.HoSo.GIOITINH.Value : 0);
model.LstDanToc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_DANTOC", 0, model.HoSo.DANTOC.HasValue ? model.HoSo.DANTOC.Value : 0);
model.LstTonGiao = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TONGIAO", 0, model.HoSo.TONGIAO.HasValue ? model.HoSo.TONGIAO.Value : 0);
model.LstNgach = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_NGACH", 0, model.HoSo.NGACHCONGCHUCVIENCHUC.HasValue ? model.HoSo.NGACHCONGCHUCVIENCHUC.Value : 0);
model.LstTrinhDoGiaoDuc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TRINHDOGIAODUC", 0, model.HoSo.TRINHDOGIAODUC.HasValue ? model.HoSo.TRINHDOGIAODUC.Value : 0);
model.LstTrinhDoChuyenMon = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TRINHDOCHUYENMON", 0, model.HoSo.TRINHDOCHUYENMONCAONHAT.HasValue ? model.HoSo.TRINHDOCHUYENMONCAONHAT.Value : 0);
model.LstLyLuanChinhTri = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_LYLUANCHINHTRI", 0, model.HoSo.LYLUANCHINHTRI.HasValue ? model.HoSo.LYLUANCHINHTRI.Value : 0);
model.LstQuanLyNhaNuoc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_QUANLYNHANUOC", 0, model.HoSo.QUANLYNHANUOC.HasValue ? model.HoSo.QUANLYNHANUOC.Value : 0);
model.LstNgoaiNgu = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_NGOAINGU", 0, model.HoSo.NGOAINGU.HasValue ? model.HoSo.NGOAINGU.Value : 0);
model.LstTinHoc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TINHOC", 0, model.HoSo.TINHOC.HasValue ? model.HoSo.TINHOC.Value : 0);
model.LstTinhTrangSucKhoe = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TINHTRANGSUCKHOE", 0, model.HoSo.SUCKHOE.HasValue ? model.HoSo.SUCKHOE.Value : 0);
model.LstNhomMau = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_NHOMMAU", 0, model.HoSo.NHOMMAU.HasValue ? model.HoSo.NHOMMAU.Value : 0);
model.LstGiaDinhChinhSach = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_GIADINHCHINHSACH", 0, model.HoSo.GIADINHCHINHSACH.HasValue ? model.HoSo.GIADINHCHINHSACH.Value : 0);
model.LstChucVu = DM_DANHMUC_DATABusiness.DsByMaNhom("DMCHUCVU", 0, model.HoSo.CHUCVUHIENTAI.HasValue ? model.HoSo.CHUCVUHIENTAI.Value : 0);
model.LstDonViHienTai = CCTC_THANHPHANBusiness.GetDropDownList(model.HoSo.DONVI_ID.HasValue ? model.HoSo.DONVI_ID.Value : 0);
return(View("Create", model));
}
/// <summary>
/// @author:duynn
/// @since:16/06/2019
/// @description: danh sách phòng ban
/// </summary>
/// <returns></returns>
//[CodeAllowAccess(Code = "DsCCTC")]
public ActionResult Index()
{
AssignUserInfo();
CCTC_THANHPHANBusiness = Get<CCTC_THANHPHANBusiness>();
DMLoaiDonViBusiness = Get<DMLoaiDonViBusiness>();
DM_DANHMUC_DATABusiness = Get<DM_DANHMUC_DATABusiness>();
CCTC_THANHPHAN_SEARCHBO searchModel = new CCTC_THANHPHAN_SEARCHBO();
SessionManager.SetValue("CctcThanhPhanSearch", searchModel);
CoCauToChucIndexModel viewModel = new CoCauToChucIndexModel()
{
GroupData = CCTC_THANHPHANBusiness.GetDataByPage(searchModel, currentUser),
DS_TYPE = DMLoaiDonViBusiness.DSLoaiDonVi(),
DS_CATEGORY = DM_DANHMUC_DATABusiness.DsByMaNhom("DMCAPPHONGBAN", currentUser.ID)
};
#region settings deptId
int deptId = 0;
if (currentUser.ListVaiTro.Any(x => x.MA_VAITRO == "QLHT"))
{
CCTC_THANHPHAN leaderDept = CCTC_THANHPHANBusiness.Find(currentUser.DM_PHONGBAN_ID.GetValueOrDefault());
if (leaderDept != null)
{
deptId = leaderDept.PARENT_ID.HasValue ? leaderDept.PARENT_ID.Value : leaderDept.ID;
}
}
else if (currentUser.ListVaiTro.Any(x => x.MA_VAITRO == "QLHT_HUYENUY") || currentUser.ListVaiTro.Any(x => x.MA_VAITRO == "QLHT_XAPHUONG"))
{
}
return View(viewModel);
}
public PartialViewResult GetReportCriteriaForm(int reportType)
{
AssignUserInfo();
dmDanhMucDataBusiness = Get <DM_DANHMUC_DATABusiness>();
cctcThanhPhanBusiness = Get <CCTC_THANHPHANBusiness>();
ReportVanBanDenFilterViewModel viewModel = new ReportVanBanDenFilterViewModel(reportType);
switch (reportType)
{
case LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LOAI_VANBANDEN:
viewModel.groupOfItemCategoryFilter = dmDanhMucDataBusiness.DsByMaNhom(DMLOAI_CONSTANT.LOAI_VANBAN, 0);
break;
case LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDEN:
viewModel.groupOfItemCategoryFilter = dmDanhMucDataBusiness.DsByMaNhom(DMLOAI_CONSTANT.LINHVUCVANBAN, 0);
break;
default:
viewModel.groupOfItemCategoryFilter = dmDanhMucDataBusiness.DsByMaNhom(DMLOAI_CONSTANT.DONVIGUI_VANBAN, 0);
break;
}
var demo = currentUser.DeptParentID.GetValueOrDefault();
viewModel.groupOfDeparmtents = cctcThanhPhanBusiness.GetChildrenOfDepartments(currentUser.DM_PHONGBAN_ID.GetValueOrDefault(), currentUser.DeptParentID.GetValueOrDefault(), currentUser);
return(PartialView("_ReportVanBanDenFilter", viewModel));
}
public PartialViewResult EditStorage(long id)
{
DungLuongLuuTruModel model = new DungLuongLuuTruModel();
DUNGLUONG_LUUTRUBusiness = Get <DUNGLUONG_LUUTRUBusiness>();
DM_NGUOIDUNGBusiness = Get <DM_NGUOIDUNGBusiness>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
DUNGLUONG_LUUTRU Storage = DUNGLUONG_LUUTRUBusiness.GetDataByUser(id);
if (Storage == null)
{
Storage = new DUNGLUONG_LUUTRU();
Storage.DUNGLUONG = ThuMucLuuTruConstant.DefaultStorage;
Storage.TYPE = ThuMucLuuTruConstant.DetaultType;
Storage.USER_ID = 0;
}
model.Storage = Storage;
DM_NGUOIDUNG NguoiDung = DM_NGUOIDUNGBusiness.Find(id);
if (NguoiDung == null)
{
NguoiDung = new DM_NGUOIDUNG();
}
CCTC_THANHPHAN DonVi = CCTC_THANHPHANBusiness.Find(NguoiDung.DM_PHONGBAN_ID);
if (DonVi == null)
{
DonVi = new CCTC_THANHPHAN();
}
model.NguoiDung = NguoiDung;
model.DonVi = DonVi;
return(PartialView("_SetupStorage", model));
}
public ActionResult TaoSoVanBanTheoNam(int year, string code)
{
AssignUserInfo();
DM_DANHMUC_DATABusiness = Get<DM_DANHMUC_DATABusiness>();
CCTC_THANHPHANBusiness = Get<CCTC_THANHPHANBusiness>();
DM_NHOMDANHMUCBusiness = Get<DM_NHOMDANHMUCBusiness>();
var Nhom = DM_NHOMDANHMUCBusiness.repository.All().Where(x => x.GROUP_CODE == code).FirstOrDefault();
if (Nhom != null)
{
string TenSo = Nhom.GROUP_NAME + " " + year.ToString();
var LstTypeLabel = CCTC_THANHPHANBusiness.repository.All().Where(x => x.TYPE == 10).ToList();
foreach (var item in LstTypeLabel)
{
var checkExist = DM_DANHMUC_DATABusiness.repository.All().Where(x => x.DEPTID == item.ID && x.DATA == year && x.TEXT == TenSo).FirstOrDefault();
if (checkExist == null)
{
DM_DANHMUC_DATA model = new DM_DANHMUC_DATA();
model.DM_NHOM_ID = Nhom.ID;
model.TEXT = TenSo;
model.DATA = year;
model.DEPTID = item.ID;
DM_DANHMUC_DATABusiness.Save(model);
}
}
}
return Redirect("/");
}
public ActionResult Edit(long id)
{
HSCV_VANBANDENBusiness = Get <HSCV_VANBANDENBusiness>();
var VanBan = HSCV_VANBANDENBusiness.Find(id);
AssignUserInfo();
if (VanBan == null || currentUser.ID != VanBan.NGUOITAO)
{
return(RedirectToAction("NotFound", "Home", new { area = "" }));
}
HscvVanBanPhatHanhModel model = new HscvVanBanPhatHanhModel();
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
TAILIEUDINHKEMBusiness = Get <TAILIEUDINHKEMBusiness>();
//model.ListDoMat = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOMAT);
model.ListDoKhan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOKHAN);
model.ListDoUuTien = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOUUTIEN);
model.ListLoaiVanBan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.LOAI_VANBAN);
model.ListLinhVucVanBan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.LINHVUCVANBAN);
model.Extension = VbDenExtension;
model.MaxSize = VbDenSize;
model.ListTaiLieu = TAILIEUDINHKEMBusiness.GetDataByItemID(id, LOAITAILIEU.VANBANDEN);
model.VanBan = VanBan;
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
model.TreeDonVi = CCTC_THANHPHANBusiness.GetTree(0);
HSCV_VANBANDEN_DONVINHANBusiness = Get <HSCV_VANBANDEN_DONVINHANBusiness>();
var ListDonViId = HSCV_VANBANDEN_DONVINHANBusiness.GetData(id);
model.ListDonVi = model.ListDonVi = CCTC_THANHPHANBusiness.GetDataByIds(ListDonViId.Where(o => o.DONVI_ID.HasValue).Select(x => x.DONVI_ID.Value).ToList());
return(View("Create", model));
}
public ActionResult Index()
{
HscvVanBanPhatHanhModel model = new HscvVanBanPhatHanhModel();
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
//model.ListDoMat = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOMAT);
model.ListDoKhan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOKHAN);
model.ListDoUuTien = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOUUTIEN);
model.ListLoaiVanBan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.LOAI_VANBAN);
model.ListLinhVucVanBan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.LINHVUCVANBAN);
HSCV_VANBANDENBusiness = Get <HSCV_VANBANDENBusiness>();
HSCV_VANBANDEN_SEARCH searchModel = new HSCV_VANBANDEN_SEARCH();
AssignUserInfo();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
List <int> Ids = new List <int>();
if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.DONVI))
{
CCTC_THANHPHAN DonVi = CCTC_THANHPHANBusiness.Find(currentUser.DM_PHONGBAN_ID);
if (DonVi != null && DonVi.PARENT_ID.HasValue && DonVi.PARENT_ID.Value > 0)
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(DonVi.PARENT_ID.Value).Select(x => x.ID).ToList();
Ids.Add(DonVi.PARENT_ID.Value);
model.TreeData = CCTC_THANHPHANBusiness.GetTree(DonVi.PARENT_ID.Value);
searchModel.DONVI_ID = DonVi.PARENT_ID.Value;
}
else
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0).Select(x => x.ID).ToList();
Ids.Add(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
searchModel.DONVI_ID = currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0;
}
}
//Nếu là quản lý phòng ban
else if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.PHONGBAN))
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0).Select(x => x.ID).ToList();
Ids.Add(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
searchModel.DONVI_ID = currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0;
}
else
{
Ids.Add(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
//searchModel.USER_ID = currentUser.ID;
}
searchModel.ListDonVi = Ids;
if (model.TreeData == null)
{
model.TreeData = CCTC_THANHPHANBusiness.GetTree(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
}
searchModel.pageSize = MaxPerpage;
searchModel.pageIndex = 1;
searchModel.ListIds = initIds(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
model.ListResult = HSCV_VANBANDENBusiness.GetDaTaByPage(searchModel, MaxPerpage);
SessionManager.SetValue("VanBanDenSearch", searchModel);
//model.ListVanBan = initVanBanDi();
model.UserInfoBO = currentUser;
return(View(model));
}
public JsonResult Save(FormCollection form)
{
AssignUserInfo();
JsonResultBO result = new JsonResultBO(true);
CCTC_THANHPHANBusiness = Get<CCTC_THANHPHANBusiness>();
try
{
var id = form["ID"].ToIntOrZero();
var dept = CCTC_THANHPHANBusiness.Find(id) ?? new CCTC_THANHPHAN();
var parent = CCTC_THANHPHANBusiness.Find(dept.PARENT_ID);
dept.PARENT_ID = form["PARENT_ID"].ToIntOrNULL();
dept.NAME = form["NAME"]?.Trim();
dept.CODE = form["CODE"]?.Trim();
var existCode = CCTC_THANHPHANBusiness.CheckExistCode(dept.CODE, id);
if (existCode)
{
deptId = currentUser.DM_PHONGBAN_ID.GetValueOrDefault();
result.Status = false;
result.Message = "Mã phòng ban đã tồn tại";
return Json(result);
}
var existName = CCTC_THANHPHANBusiness.CheckExistName(dept.NAME, id);
if (existName)
{
deptId = currentUser.DeptParentID.GetValueOrDefault();
result.Status = false;
result.Message = "Tên phòng ban đã tồn tại";
return Json(result);
}
dept.TYPE = form["TYPE"].ToIntOrZero();
dept.CATEGORY = form["CATEGORY"].ToIntOrZero();
dept.THUTU = form["THUTU"].ToIntOrZero();
dept.ITEM_LEVEL = parent.ITEM_LEVEL + 1;
dept.NGUOITAO = currentUser.ID;
dept.NGAYTAO = DateTime.Now;
if (dept.TYPE == 10)
{
dept.CAN_SEND_SMS = form["CAN_SEND_SMS"].ToIntOrZero() > 0;
}
CCTC_THANHPHANBusiness.Save(dept);
return Json(result);
}
catch
{
deptId = currentUser.DM_PHONGBAN_ID.GetValueOrDefault();
}
viewModel.TreeData = CCTC_THANHPHANBusiness.GetTree(deptId);
#endregion
return View(viewModel);
result.Status = false;
result.Message = "Cập nhật phòng ban không thành công";
return Json(result);
}
public JsonResult ReloadPage()
{
var user = GetUserInfo();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
var dataTree = CCTC_THANHPHANBusiness.GetTree(user.DM_PHONGBAN_ID.GetValueOrDefault(0));
return(Json(dataTree, JsonRequestBehavior.AllowGet));
}
public PartialViewResult ChangeKhoiDonVi(int?KHOIDONVI_ID)
{
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
List <SelectListItem> LstCoCauToChuc = CCTC_THANHPHANBusiness.repository.All().Where(x => x.PARENT_ID == KHOIDONVI_ID).Select(
x => new SelectListItem()
{
Text = x.NAME,
Value = x.ID.ToString(),
}).ToList();
return(PartialView("_ListDonVi", LstCoCauToChuc));
}
public ActionResult Index()
{
var user = GetUserInfo();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
DungLuongLuuTruModel model = new DungLuongLuuTruModel();
var dataTree = CCTC_THANHPHANBusiness.GetTree(user.DM_PHONGBAN_ID.GetValueOrDefault(0));
model.TreeData = dataTree;
DMLoaiDonViBusiness = Get <DMLoaiDonViBusiness>();
model.DS_TYPE = DMLoaiDonViBusiness.DSLoaiDonVi();
return(View(model));
}
public JsonResult SearchData(FormCollection form)
{
AssignUserInfo();
CCTC_THANHPHANBusiness = Get<CCTC_THANHPHANBusiness>();
var searchModel = (CCTC_THANHPHAN_SEARCHBO)SessionManager.GetValue("CctcThanhPhanSearch") ?? new CCTC_THANHPHAN_SEARCHBO();
searchModel.pageSize = 20;
searchModel.QR_MAPHONGBAN = form["QR_MAPHONGBAN"];
searchModel.QR_LOAIPHONGBAN = form["QR_LOAIPHONGBAN"].ToIntOrNULL();
searchModel.QR_CAPPHONGBAN = form["QR_CAPPHONGBAN"].ToIntOrNULL();
searchModel.QR_TENPHONGBAN = form["QR_TENPHONGBAN"];
SessionManager.SetValue("CctcThanhPhanSearch", searchModel);
var data = CCTC_THANHPHANBusiness.GetDataByPage(searchModel, currentUser, 1, searchModel.pageSize);
return Json(data);
}
//private List<>
#endregion
#region Các hàm partialview
public PartialViewResult GetUserPhongBan(int id)
{
DM_NGUOIDUNGBusiness = Get <DM_NGUOIDUNGBusiness>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
var model = new DungLuongLuuTruModel();
List <int> Ids = CCTC_THANHPHANBusiness.GetDSChild(id).Select(x => x.ID).ToList();
Ids.Add(id);
var lstUser = DM_NGUOIDUNGBusiness.GetByPhongBan(Ids, 0, new List <int>());
var node = CCTC_THANHPHANBusiness.Find(id);
model.Item = node;
model.ListNguoiDung = lstUser;
return(PartialView("_DsNguoiDungPartial", model));
}
public JsonResult GetData(int pageIndex, string sortQuery, int pageSize)
{
AssignUserInfo();
CCTC_THANHPHANBusiness = Get<CCTC_THANHPHANBusiness>();
var searchModel = (CCTC_THANHPHAN_SEARCHBO)SessionManager.GetValue("CctcThanhPhanSearch") ?? new CCTC_THANHPHAN_SEARCHBO();
if (!string.IsNullOrEmpty(sortQuery))
{
searchModel.sortQuery = sortQuery;
}
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("CctcThanhPhanSearch", searchModel);
var data = CCTC_THANHPHANBusiness.GetDataByPage(searchModel, currentUser, pageIndex, pageSize);
return Json(data);
}
public JsonResult Delele(int id)
{
JsonResultBO result = new JsonResultBO(true);
CCTC_THANHPHANBusiness = Get<CCTC_THANHPHANBusiness>();
try
{
CCTC_THANHPHANBusiness.repository.Delete(id);
CCTC_THANHPHANBusiness.Save();
return Json(result);
}
catch
{
result.Status = false;
result.Message = "Xóa phòng ban thành công";
return Json(result);
}
}
/// <summary>
/// @author: duynn
/// </summary>
/// <returns></returns>
public PartialViewResult EditRecipients(int id = 0)
{
AssignUserInfo();
RecipientBusiness = Get <QL_NGUOINHAN_VANBANBusiness>();
UserBusiness = Get <DM_NGUOIDUNGBusiness>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
QLNguoiNhanVanBanEditViewModel viewModel = new QLNguoiNhanVanBanEditViewModel();
QL_NGUOINHAN_VANBAN entity = RecipientBusiness.Find(id) ?? new QL_NGUOINHAN_VANBAN();
List <long> choosenUserIds = new List <long>();
/**
* dah sách ngươi dùng
*/
if (!string.IsNullOrEmpty(entity.NGUOINHAN_IDS))
{
choosenUserIds = entity.NGUOINHAN_IDS.ToListLong(',');
}
/**
* lấy danh sách người dùng phòng ban
*/
List <NguoiDungPhongBanBO> groupDepts = UserBusiness.GetUsersOfDepartments();
//if (currentUser.ListVaiTro.Any(x=>x.MA_VAITRO == "QLHT"))
//{
// groupDeptUsers = UserBusiness.GetUsersOfDepartments();
//}
//else
//{
// groupDeptUsers = UserBusiness.GetUsersOfDepartments(currentUser.DM_PHONGBAN_ID.GetValueOrDefault());
//}
foreach (var dept in groupDepts)
{
SelectListGroup group = new SelectListGroup()
{
Name = dept.PhongBan.NAME
};
viewModel.GroupUsers.AddRange(this.GetGroupUsers(group, choosenUserIds, dept.LstNguoiDung));
}
viewModel.Department = CCTC_THANHPHANBusiness.Find(currentUser.DM_PHONGBAN_ID) ?? new CCTC_THANHPHAN();
viewModel.IsSystemAdmin = currentUser.ListVaiTro.Any(x => x.MA_VAITRO == "QLHT");
viewModel.Entity = entity;
return(PartialView("_EditRecipient", viewModel));
}
public ActionResult CreateLichCongTac(long idVanBanDen = 0)
{
AssignUserInfo();
hscvVanBanDenBusiness = Get <HSCV_VANBANDENBusiness>();
cctcThanhPhanBusiness = Get <CCTC_THANHPHANBusiness>();
dmNguoiDungBusiness = Get <DM_NGUOIDUNGBusiness>();
dmDanhMucDataBusiness = Get <DM_DANHMUC_DATABusiness>();
wfLogBusiness = Get <WF_LOGBusiness>();
EditLichCongTacViewModel model = new EditLichCongTacViewModel();
long userId = 0;
if (idVanBanDen > 0)
{
HSCV_VANBANDEN entityVanBanDen = hscvVanBanDenBusiness.Find(idVanBanDen);
if (entityVanBanDen != null && entityVanBanDen.NGUOITAO == currentUser.ID && hscvVanBanDenBusiness.CheckIsFinish(entityVanBanDen.ID))
{
LICHCONGTAC calendar = new LICHCONGTAC();
calendar.TIEUDE = entityVanBanDen.TRICHYEU;
calendar.NGAY_CONGTAC = entityVanBanDen.NGAYCONGTAC ?? DateTime.Now;
calendar.GIO_CONGTAC = entityVanBanDen.GIO_CONGTAC.GetValueOrDefault();
calendar.PHUT_CONGTAC = entityVanBanDen.PHUT_CONGTAC.GetValueOrDefault();
model = new EditLichCongTacViewModel(calendar);
model.entityLichCongTac = calendar;
//lấy người xử lý cuối làm người chủ trì công tác
DM_NGUOIDUNG_BO lastProcessor = wfLogBusiness.GetFinalProcessor(entityVanBanDen.ID, MODULE_CONSTANT.VANBANDEN);
userId = lastProcessor.ID;
}
else
{
return(Redirect("/Home/UnAuthor"));
}
}
else if (SessionManager.HasValue("CreateCalendarOfTheDay"))
{
LICHCONGTAC entityCalendar = (LICHCONGTAC)SessionManager.GetValue("CreateCalendarOfTheDay");
model = new EditLichCongTacViewModel(entityCalendar);
SessionManager.Remove("CreateCalendarOfTheDay");
}
model.groupOfLanhDaos = dmNguoiDungBusiness.GetDropDownByDeptParentId(currentUser.DeptParentID.GetValueOrDefault(), userId);
model.groupOfDestinations = dmDanhMucDataBusiness.GetGroupTextByCode(DMLOAI_CONSTANT.DIEM_DEN);
return(View("EditLichCongTac", model));
}
public ActionResult Create()
{
HscvVanBanPhatHanhModel model = new HscvVanBanPhatHanhModel();
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
//model.ListDoMat = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOMAT);
model.ListDoKhan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOKHAN);
model.ListDoUuTien = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.DOUUTIEN);
model.ListLoaiVanBan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.LOAI_VANBAN);
model.ListLinhVucVanBan = DM_DANHMUC_DATABusiness.GetDataByCode(DMLOAI_CONSTANT.LINHVUCVANBAN);
model.ListTaiLieu = new List <TAILIEUDINHKEM>();
model.VanBan = new HSCV_VANBANDEN();
model.Extension = VbDenExtension;
model.MaxSize = VbDenSize;
model.ListDonVi = new List <CCTC_THANHPHAN>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
model.TreeDonVi = CCTC_THANHPHANBusiness.GetTree(0);
return(View(model));
}
public string GetChild(string pid, string sort)
{
UserInfoBO user = GetUserInfo();
List <THUMUC_LUUTRU_BO> subMenu = new List <THUMUC_LUUTRU_BO>();
List <TAILIEUDINHKEM_BO> lstTaiLieu = new List <TAILIEUDINHKEM_BO>();
TAILIEUDINHKEMBusiness = Get <TAILIEUDINHKEMBusiness>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
int pID = pid.ToIntOrZero();
THUMUC_LUUTRUBusiness = Get <THUMUC_LUUTRUBusiness>();
EFILE_CHIASEBusiness = Get <EFILE_CHIASEBusiness>();
THUMUC_LUUTRU THUMUC = THUMUC_LUUTRUBusiness.Find(pID);
if (THUMUC != null)
{
if (THUMUC.PERMISSION.HasValue && THUMUC.PERMISSION.Value == FolderPermission.CAN_WRITE)
{
subMenu = new List <THUMUC_LUUTRU_BO>();
}
else
{
CCTC_THANHPHAN DONVI = new CCTC_THANHPHAN();
if (THUMUC != null)
{
DONVI = CCTC_THANHPHANBusiness.Find(THUMUC.DONVI_ID);
}
else
{
DONVI = CCTC_THANHPHANBusiness.Find(user.DM_PHONGBAN_ID);
}
List <int> Ids = new List <int>();
#region Lấy tài liệu + thư mục con
subMenu = TAILIEUDINHKEMBusiness.getListFileByFolder(pID, LOAITAILIEU.TM_UPLOAD, 0, DONVI.NAME, THUMUC);
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
subMenu.AddRange(THUMUC_LUUTRUBusiness.GetThuMucByParent(pID, 0, Ids));
#endregion
}
}
return(JsonConvert.SerializeObject(subMenu));
}
public ActionResult UpdateLichCongTac(long id)
{
AssignUserInfo();
JsonResultBO editResult = new JsonResultBO(true);
cctcThanhPhanBusiness = Get <CCTC_THANHPHANBusiness>();
dmNguoiDungBusiness = Get <DM_NGUOIDUNGBusiness>();
lichCongTacBusiness = Get <LICHCONGTACBusiness>();
dmDanhMucDataBusiness = Get <DM_DANHMUC_DATABusiness>();
LICHCONGTAC entity = lichCongTacBusiness.Find(id);
if (entity != null && entity.IS_DELETE != true && entity.NGAY_CONGTAC.IsOldWeek() == false)
{
EditLichCongTacViewModel model = new EditLichCongTacViewModel(entity);
model.groupOfLanhDaos = dmNguoiDungBusiness.GetDropDownByDeptParentId(currentUser.DeptParentID.GetValueOrDefault(), entity.LANHDAO_ID.GetValueOrDefault());
model.groupOfDestinations = dmDanhMucDataBusiness.GetGroupTextByCode(DMLOAI_CONSTANT.DIEM_DEN);
return(View("EditLichCongTac", model));
}
return(Redirect("/Home/UnAuthor"));
}
public ActionResult Create()
{
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
HoSoCanBoVM model = new HoSoCanBoVM();
model.HoSo = new HOSO_CANBO_THONGTINCHUNG();
model.LstGioiTinh = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_GIOITINH", 0);
model.LstDanToc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_DANTOC", 0);
model.LstTonGiao = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TONGIAO", 0);
model.LstNgach = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_NGACH", 0);
model.LstTrinhDoGiaoDuc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TRINHDOGIAODUC", 0);
model.LstTrinhDoChuyenMon = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TRINHDOCHUYENMON", 0);
model.LstLyLuanChinhTri = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_LYLUANCHINHTRI", 0);
model.LstQuanLyNhaNuoc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_QUANLYNHANUOC", 0);
model.LstNgoaiNgu = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_NGOAINGU", 0);
model.LstTinHoc = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TINHOC", 0);
model.LstTinhTrangSucKhoe = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_TINHTRANGSUCKHOE", 0);
model.LstNhomMau = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_NHOMMAU", 0);
model.LstGiaDinhChinhSach = DM_DANHMUC_DATABusiness.DsByMaNhom("NHANSU_GIADINHCHINHSACH", 0);
model.LstChucVu = DM_DANHMUC_DATABusiness.DsByMaNhom("DMCHUCVU", 0);
model.LstDonViHienTai = CCTC_THANHPHANBusiness.GetDropDownList();
return(View(model));
}
public ActionResult DetailVanBan(long ID)
{
AssignUserInfo();
#region check quyền truy cập của người dùng đến văn bản hiện tại
WF_ITEM_USER_PROCESSBusiness = Get <WF_ITEM_USER_PROCESSBusiness>();
WF_PROCESSBusiness = Get <WF_PROCESSBusiness>();
HSCV_VANBANDIBusiness = Get <HSCV_VANBANDIBusiness>();
DM_NGUOIDUNGBusiness = Get <DM_NGUOIDUNGBusiness>();
var WF_REVIEW_USERBusiness = Get <WF_REVIEW_USERBusiness>();
DM_DANHMUC_DATABusiness DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
// check quyền truy cập theo workflow
bool HasPermissionAccess = WF_ITEM_USER_PROCESSBusiness.CheckPermissionProcess(ID, MODULE_CONSTANT.VANBANTRINHKY, currentUser.ID);
// check quyền truy cập với quyền review
bool HasPermissionReview = WF_REVIEW_USERBusiness.CheckPermissionReview(ID, MODULE_CONSTANT.VANBANTRINHKY, currentUser.ID);
bool HasPermissionMainProcess = WF_PROCESSBusiness.CheckPermissionProcess(ID, MODULE_CONSTANT.VANBANTRINHKY, currentUser.ID);
if (!HasPermissionAccess && !HasPermissionReview)
{
return(Redirect("/Home/UnAuthor"));
}
ThongTinVanBanDiVM myModel = new ThongTinVanBanDiVM();
myModel.VanBanTrinhKy = HSCV_VANBANDIBusiness.Find(ID);
myModel.HasPermissionMainProcess = HasPermissionMainProcess;
if (myModel.VanBanTrinhKy == null)
{
return(Redirect("/Home/UnAuthor"));
}
#region lấy tên danh mục - do dữ liệu văn bản rất lớn cho nên không join với bảng danh mục mà thực hiện 3,4 câu sub-query, tốc độ nhanh hơn
// chỉ áp dụng kiểu truy vấn này với màn hình chi tiết 1 văn bản
// ở màn hình danh sách tuyệt đối không áp dụng query ntn
var DanhMucDoKhan = DM_DANHMUC_DATABusiness.Find(myModel.VanBanTrinhKy.DOKHAN_ID);
if (DanhMucDoKhan != null)
{
myModel.STR_DOKHAN = DanhMucDoKhan.TEXT;
}
var DanhMucDoUuTien = DM_DANHMUC_DATABusiness.Find(myModel.VanBanTrinhKy.DOUUTIEN_ID);
if (DanhMucDoUuTien != null)
{
myModel.STR_DOUUTIEN = DanhMucDoUuTien.TEXT;
}
var DanhMucLinhVuc = DM_DANHMUC_DATABusiness.Find(myModel.VanBanTrinhKy.LINHVUCVANBAN_ID);
if (DanhMucLinhVuc != null)
{
myModel.STR_LINHVUCVANBAN = DanhMucLinhVuc.TEXT;
}
var DanhMucLoaiVanBan = DM_DANHMUC_DATABusiness.Find(myModel.VanBanTrinhKy.LOAIVANBAN_ID);
if (DanhMucLoaiVanBan != null)
{
myModel.STR_LOAIVANBAN = DanhMucLoaiVanBan.TEXT;
}
var NguoiKyVanBan = DM_NGUOIDUNGBusiness.Find(myModel.VanBanTrinhKy.NGUOIKY_ID);
if (NguoiKyVanBan != null)
{
myModel.STR_NGUOIKY = NguoiKyVanBan.HOTEN;
}
//Danh sách tài liệu đính kèm của văn bản
TAILIEUDINHKEMBusiness = Get <TAILIEUDINHKEMBusiness>();
myModel.ListTaiLieu = TAILIEUDINHKEMBusiness.GetDataByItemID(ID, LOAITAILIEU.VANBAN);
if (!string.IsNullOrEmpty(myModel.VanBanTrinhKy.DONVINHAN_INTERNAL_ID))
{
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
myModel.ListDonVi = CCTC_THANHPHANBusiness.GetDataByIds(myModel.VanBanTrinhKy.DONVINHAN_INTERNAL_ID.ToListInt(','));
}
else
{
myModel.ListDonVi = new List <CCTC_THANHPHAN>();
}
#endregion
#endregion
#region danh sách comment
var HscvVanBanDiTraoDoiBusiness = Get <HSCV_VANBANDI_TRAODOIBusiness>();
myModel.LstNoiDungTraoDoi = HscvVanBanDiTraoDoiBusiness.GetListCommentByVanBanDiId(ID);
myModel.LstRootComment = myModel.LstNoiDungTraoDoi.Where(x => x.REPLY_ID == null).OrderByDescending(x => x.NGAYTAO).ToList();
List <long> LstRootCommentIds = myModel.LstRootComment.Select(x => x.ID).ToList();
var LstTaiLieuComment = TAILIEUDINHKEMBusiness.GetDataForTaskByListItemId(LstRootCommentIds, LOAITAILIEU.NOIDUNGTRAODOIVANBANDI);
myModel.LstTaiLieuComment = LstTaiLieuComment;
#endregion
return(View(myModel));
}
public JsonResult SavePhatHanhVanBan(FormCollection col)
{
AssignUserInfo();
SMSDAL.SendSMSDAL sms = new SMSDAL.SendSMSDAL();
SYS_TINNHANBusiness = Get <SYS_TINNHANBusiness>();
LogSMSBusiness = Get <LogSMSBusiness>();
HSCV_VANBANDIBusiness = Get <HSCV_VANBANDIBusiness>();
HSCV_VANBANDENBusiness = Get <HSCV_VANBANDENBusiness>();
DM_NHOMDANHMUCBusiness = Get <DM_NHOMDANHMUCBusiness>();
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
TAILIEUDINHKEMBusiness = Get <TAILIEUDINHKEMBusiness>();
DM_NGUOIDUNGBusiness = Get <DM_NGUOIDUNGBusiness>();
WF_MODULEBusiness = Get <WF_MODULEBusiness>();
WF_PROCESSBusiness = Get <WF_PROCESSBusiness>();
WF_STATE_FUNCTIONBusiness = Get <WF_STATE_FUNCTIONBusiness>();
WF_STATEBusiness = Get <WF_STATEBusiness>();
WF_STREAMBusiness = Get <WF_STREAMBusiness>();
WF_FUNCTION_DONEBusiness = Get <WF_FUNCTION_DONEBusiness>();
WF_LOGBusiness = Get <WF_LOGBusiness>();
WF_ITEM_USER_PROCESSBusiness = Get <WF_ITEM_USER_PROCESSBusiness>();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
string selectedDept = col["department-choose"];
long? ID = col["ID"].ToLongOrNULL();
if (0 >= ID)
{
return(Json(new { Type = "ERROR", Message = "Không tìm thấy văn bản cần lưu sổ và phát hành" }));
}
#region cập nhật thông tin văn bản đi
HSCV_VANBANDI VanBanDi = HSCV_VANBANDIBusiness.Find(ID);
if (VanBanDi == null)
{
return(Json(new { Type = "ERROR", Message = "Không tìm thấy văn bản cần lưu sổ và phát hành" }));
}
if (!string.IsNullOrEmpty(col["SOHIEU"]))
{
VanBanDi.SOHIEU = col["SOHIEU"];
}
VanBanDi.USER_RECEIVE_DIRECTLY = col["USERS_RECEIVE_SPECIAL"];
VanBanDi.DONVINHAN_INTERNAL_ID = selectedDept;
VanBanDi.SOTHEOSO = col["SOTHEOSO"];
VanBanDi.SOVANBAN_ID = col["SOVANBAN_ID"].ToIntOrNULL();
if (!string.IsNullOrEmpty(col["TRICHYEU"]))
{
VanBanDi.TRICHYEU = col["TRICHYEU"].Trim();
}
if (!string.IsNullOrEmpty(col["NGAY_HIEULUC"]))
{
try
{
VanBanDi.NGAYCOHIEULUC = col["NGAY_HIEULUC"].ToDateTime();
}
catch (Exception e)
{
}
}
if (!string.IsNullOrEmpty(col["NGAYHET_HIEULUC"]))
{
try
{
VanBanDi.NGAYHETHIEULUC = col["NGAYHET_HIEULUC"].ToDateTime();
}
catch (Exception e)
{
}
}
if (!string.IsNullOrEmpty(col["NGAYBANHANH"]))
{
try
{
VanBanDi.NGAYBANHANH = col["NGAYBANHANH"].ToDateTime();
}
catch (Exception e)
{
}
}
HSCV_VANBANDIBusiness.Save(VanBanDi);
#endregion
//cập nhật số đi theo văn bản vào số văn bản hiện tại
int numbSoDiTheoSo = VanBanDi.SOTHEOSO.GetPrefixNumber();
DM_DANHMUC_DATABusiness.UpdateSoVanBan(VanBanDi.SOVANBAN_ID.GetValueOrDefault(), numbSoDiTheoSo);
#region Convert Văn bản
List <int> ListDonVi = selectedDept.ToListInt(',');
DateTime? NGAY_HIEULUC = col["NGAY_HIEULUC"].ToDateTime();
DateTime? NGAYHET_HIEULUC = col["NGAYHET_HIEULUC"].ToDateTime();
string TRICHYEU = col["TRICHYEU"];
string SOHIEU = col["SOHIEU"];
if (!string.IsNullOrEmpty(SOHIEU))
{
SOHIEU = SOHIEU.Trim();
}
if (!string.IsNullOrEmpty(TRICHYEU))
{
TRICHYEU = TRICHYEU.Trim();
}
List <TAILIEUDINHKEM> ListTaiLieu = TAILIEUDINHKEMBusiness.GetDataByItemID(ID.HasValue ? ID.Value : 0, LOAITAILIEU.VANBAN);
DM_NGUOIDUNG NguoiDung = DM_NGUOIDUNGBusiness.Find(VanBanDi.NGUOIKY_ID);
#endregion
#region cập nhật wf function done
var process = WF_PROCESSBusiness.GetProcess(VanBanDi.ID, MODULE_CONSTANT.VANBANTRINHKY);
var function = WF_STATE_FUNCTIONBusiness.GetStateFunction((int)process.CURRENT_STATE);
var functionDone = new WF_FUNCTION_DONE();
functionDone.ITEM_TYPE = MODULE_CONSTANT.VANBANTRINHKY;
functionDone.ITEM_ID = VanBanDi.ID;
functionDone.STATE = process.CURRENT_STATE;
functionDone.FUNCTION_STATE = function.ID;
functionDone.create_at = DateTime.Now;
functionDone.create_by = currentUser.ID;
WF_FUNCTION_DONEBusiness.Save(functionDone);
var log = new WF_LOG();
log.ITEM_ID = VanBanDi.ID;
log.ITEM_TYPE = MODULE_CONSTANT.VANBANTRINHKY;
log.MESSAGE = "<div class='label label-info'>Đã phát hành</div>";
log.WF_ID = process.WF_ID;
log.create_at = DateTime.Now;
log.create_by = currentUser.ID;
log.NGUOIXULY_ID = currentUser.ID;
WF_LOGBusiness.Save(log);
//Ghi nhận luồng đã xử lý xong
var state = WF_STATEBusiness.Find(process.CURRENT_STATE);
if (state != null && state.IS_KETTHUC == true)
{
process.IS_END = true;
WF_PROCESSBusiness.Save(process);
}
var itemprocess = WF_ITEM_USER_PROCESSBusiness.repository.All().Where(x =>
x.ITEM_ID == process.ITEM_ID && x.ITEM_TYPE == process.ITEM_TYPE &&
x.STEP_ID == process.CURRENT_STATE)
.FirstOrDefault();
if (itemprocess != null)
{
itemprocess.DAXULY = true;
WF_ITEM_USER_PROCESSBusiness.Save(itemprocess);
}
#endregion
//gửi văn bản đi cho đơn vị
SaveVanBanPhatHanhToDonVi(VanBanDi, sms);
//gửi văn bản đi cho cá nhân
SaveVanBanPhatHanhToCaNhan(VanBanDi, sms);
return(Json(new { Type = "SUCCESS", Message = "Lưu sổ và phát hành văn bản thành công" }));
}
public ActionResult Detail(long id)
{
HSCV_VANBANDENBusiness = Get <HSCV_VANBANDENBusiness>();
var VanBanBO = HSCV_VANBANDENBusiness.FindById(id);
if (VanBanBO == null)
{
return(RedirectToAction("NotFound", "Home", new { area = "" }));
}
AssignUserInfo();
HSCV_VANBANDEN_DONVINHANBusiness = Get <HSCV_VANBANDEN_DONVINHANBusiness>();
var ListDonViId = HSCV_VANBANDEN_DONVINHANBusiness.GetData(id);
//Nếu là quản lý đơn vị
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.DONVI))
{
CCTC_THANHPHAN DonVi = CCTC_THANHPHANBusiness.Find(currentUser.DM_PHONGBAN_ID);
List <int> Ids = new List <int>();
if (DonVi != null && DonVi.PARENT_ID.HasValue && DonVi.PARENT_ID.Value > 0)
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(DonVi.PARENT_ID.Value).Select(x => x.ID).ToList();
Ids.Add(DonVi.PARENT_ID.Value);
}
else
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0).Select(x => x.ID).ToList();
Ids.Add(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
}
if (ListDonViId.Where(x => Ids.Contains(x.DONVI_ID.Value)).Count() == 0)
{
return(RedirectToAction("NotFound", "Home", new { area = "" }));
}
//if (!VanBanBO.DONVI_ID.HasValue || !Ids.Contains(VanBanBO.DONVI_ID.Value))
//{
// return RedirectToAction("NotFound", "Home", new { area = "" });
//}
}
//Nếu là quản lý phòng ban
else if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.PHONGBAN))
{
List <int> Ids = CCTC_THANHPHANBusiness.GetDSChild(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0).Select(x => x.ID).ToList();
Ids.Add(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
if (ListDonViId.Where(x => Ids.Contains(x.DONVI_ID.Value)).Count() == 0)
{
return(RedirectToAction("NotFound", "Home", new { area = "" }));
}
//if (!VanBanBO.DONVI_ID.HasValue || !Ids.Contains(VanBanBO.DONVI_ID.Value))
//{
// return RedirectToAction("NotFound", "Home", new { area = "" });
//}
}
else if (currentUser.ID != VanBanBO.NGUOITAO && !ListDonViId.Select(x => x.DONVI_ID).Contains(currentUser.DM_PHONGBAN_ID))
{
return(RedirectToAction("NotFound", "Home", new { area = "" }));
}
//List<long> Ids = initIds(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
//if (VanBanBO.VANBANDI_ID.HasValue && !Ids.Contains(VanBanBO.VANBANDI_ID.Value))
//{
// return RedirectToAction("NotFound", "Home");
//}
HscvVanBanPhatHanhModel model = new HscvVanBanPhatHanhModel();
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
TAILIEUDINHKEMBusiness = Get <TAILIEUDINHKEMBusiness>();
model.ListTaiLieu = TAILIEUDINHKEMBusiness.GetDataByItemID(id, LOAITAILIEU.VANBANDEN);
model.VanBanBO = VanBanBO;
model.ListDonVi = model.ListDonVi = CCTC_THANHPHANBusiness.GetDataByIds(ListDonViId.Where(o => o.DONVI_ID.HasValue).Select(x => x.DONVI_ID.Value).ToList());
return(View(model));
}
public JsonResult searchData(FormCollection form)
{
HSCV_VANBANDENBusiness = Get <HSCV_VANBANDENBusiness>();
var searchModel = SessionManager.GetValue("VanBanDenSearch") as HSCV_VANBANDEN_SEARCH;
if (searchModel == null)
{
searchModel = new HSCV_VANBANDEN_SEARCH();
searchModel.pageSize = MaxPerpage;
}
int DONVI_ID = form["DONVI_ID"].ToIntOrZero();
if (DONVI_ID > 0)
{
AssignUserInfo();
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
List <int> Ids = new List <int>();
if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.DONVI))
{
CCTC_THANHPHAN DonVi = CCTC_THANHPHANBusiness.Find(currentUser.DM_PHONGBAN_ID);
Ids = new List <int>();
if (DonVi != null && DonVi.PARENT_ID.HasValue && DonVi.PARENT_ID.Value > 0)
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(DonVi.PARENT_ID.Value).Select(x => x.ID).ToList();
Ids.Add(DonVi.PARENT_ID.Value);
}
else
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0).Select(x => x.ID).ToList();
Ids.Add(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
}
}
else if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.PHONGBAN))
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0).Select(x => x.ID).ToList();
Ids.Add(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
}
if (Ids.Contains(DONVI_ID))
{
Ids = CCTC_THANHPHANBusiness.GetDSChild(DONVI_ID).Select(x => x.ID).ToList();
Ids.Add(DONVI_ID);
searchModel.ListDonVi = Ids;
}
else
{
searchModel.ListDonVi = Ids;
}
}
searchModel.SOHIEU = form["SOHIEU"];
searchModel.TRICHYEU = form["TRICHYEU"];
searchModel.DOKHAN_ID = form["DOKHAN_ID"].ToIntOrNULL();
searchModel.DOMAT_ID = form["DOMAT_ID"].ToIntOrNULL();
searchModel.LINHVUCVANBAN_ID = form["LINHVUCVANBAN_ID"].ToIntOrNULL();
searchModel.LOAIVANBAN_ID = form["LOAIVANBAN_ID"].ToIntOrNULL();
searchModel.NGUOIKY = form["NGUOIKY"];
searchModel.NGAYBANHANH_TU = form["BANHANH_TU"].ToDateTime();
searchModel.NGAYBANHANH_DEN = form["BANHANH_DEN"].ToDateTime();
SessionManager.SetValue("VanBanDenSearch", searchModel);
var data = HSCV_VANBANDENBusiness.GetDaTaByPage(searchModel, searchModel.pageSize, 1);
return(Json(data));
}
public PartialViewResult GetReportResult(FormCollection form)
{
AssignUserInfo();
string categoryCode = string.Empty;
string reportTitle = string.Empty;
string departmentExtensionTitle = string.Empty;
int reportType = form["reportType"].ToIntOrZero();
int timeFilterType = form["timeFilterType"].ToIntOrZero();
int queryItemCategoryType = form["queryItemCategoryType"].ToIntOrZero();
int queryDepartment = form["queryDepartment"].ToIntOrZero();
DateTime?queryDateStart;
DateTime?queryDateEnd;
hscvVanBanDenBusiness = Get <HSCV_VANBANDENBusiness>();
dmDanhMucDataBusiness = Get <DM_DANHMUC_DATABusiness>();
cctcThanhPhanBusiness = Get <CCTC_THANHPHANBusiness>();
CCTC_THANHPHAN department = cctcThanhPhanBusiness.Find(queryDepartment);
departmentExtensionTitle = department != null?string.Format("CỦA ĐƠN VỊ {0}", department.NAME.ToUpper()) : string.Empty;
DM_DANHMUC_DATA category = dmDanhMucDataBusiness.Find(queryItemCategoryType) ?? new DM_DANHMUC_DATA();
category.TEXT = string.IsNullOrEmpty(category.TEXT) ? string.Empty : category.TEXT.ToUpper();
ReportVanBanDenResultViewModel viewModel = new ReportVanBanDenResultViewModel();
viewModel.reportType = reportType;
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LOAI_VANBANDEN)
{
categoryCode = DMLOAI_CONSTANT.LOAI_VANBAN;
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDEN)
{
categoryCode = DMLOAI_CONSTANT.LINHVUCVANBAN;
}
else
{
categoryCode = DMLOAI_CONSTANT.DONVIGUI_VANBAN;
}
if (timeFilterType == LOAI_BAOCAO_THOIGIAN_CONSTANT.NGAY)
{
queryDateStart = form["queryDateStart"].ToDateTime();
queryDateEnd = form["queryDateEnd"].ToDateTime();
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LOAI_VANBANDEN)
{
reportTitle = string.Format("THỐNG KÊ VĂN BẢN ĐẾN THEO LOẠI {0} TỪ NGÀY {1} ĐẾN NGÀY {2} {3}", category.TEXT, queryDateStart.Value.ToVietnameseDateFormat(), queryDateEnd.Value.ToVietnameseDateFormat(), departmentExtensionTitle);
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDEN)
{
reportTitle = string.Format("THỐNG KÊ VĂN BẢN ĐẾN THEO LĨNH VỰC {0} TỪ NGÀY {1} ĐẾN NGÀY {2} {3}", category.TEXT, queryDateStart.Value.ToVietnameseDateFormat(), queryDateEnd.Value.ToVietnameseDateFormat(), departmentExtensionTitle);
}
else
{
reportTitle = string.Format("THỐNG KÊ VĂN BẢN ĐẾN THEO ĐƠN VỊ {0} GỬI TỪ NGÀY {1} ĐẾN NGÀY {2} {3}", category.TEXT, queryDateStart.Value.ToVietnameseDateFormat(), queryDateEnd.Value.ToVietnameseDateFormat(), departmentExtensionTitle);
}
}
else if (timeFilterType == LOAI_BAOCAO_THOIGIAN_CONSTANT.THANG)
{
int month = form["queryMonth"].ToIntOrZero();
int year = form["queryYear"].ToIntOrZero();
queryDateStart = new DateTime(year, month, 1);
queryDateEnd = new DateTime(year, month, DateTime.DaysInMonth(year, month));
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LOAI_VANBANDEN)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐẾN THEO LOẠI {0} TRONG THÁNG {1} NĂM {2} {3}", category.TEXT, month, year, departmentExtensionTitle);
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDEN)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐẾN THEO LĨNH VỰC {0} TRONG THÁNG {1} NĂM {2} {3}", category.TEXT, month, year, departmentExtensionTitle);
}
else
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐẾN THEO ĐƠN VỊ {0} GỬI TRONG THÁNG {1} NĂM {2} {3}", category.TEXT, month, year, departmentExtensionTitle);
}
}
else
{
int year = form["queryYearOnly"].ToIntOrZero();
queryDateStart = new DateTime(year, 1, 1);
queryDateEnd = new DateTime(year, 12, 31);
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LOAI_VANBANDEN)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐẾN THEO LOẠI {0} TRONG NĂM {1} {2}", category.TEXT, year, departmentExtensionTitle);
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDEN)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐẾN THEO LĨNH VỰC {0} TRONG NĂM {1} {2}", category.TEXT, year, departmentExtensionTitle);
}
else
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐẾN THEO ĐƠN VỊ {0} GỬI TRONG NĂM {1} {2}", category.TEXT, year, departmentExtensionTitle);
}
}
viewModel.title = reportTitle;
viewModel.groupOfReportResultItems = hscvVanBanDenBusiness.GetStatisticResultByCategory(queryDepartment, MODULE_CONSTANT.VANBANDEN, categoryCode, queryDateStart, queryDateEnd, queryItemCategoryType);
SessionManager.SetValue("ReportVanBanDen" + reportType, viewModel);
return(PartialView("_ReportVanBanDenResult", viewModel));
}
public ActionResult DanhGiaChatLuong()
{
CCTC_THANHPHANBusiness = Get <CCTC_THANHPHANBusiness>();
DM_NGUOIDUNGBusiness = Get <DM_NGUOIDUNGBusiness>();
AssignUserInfo();
// Chỉ lấy các khối đơn vị
ReportViewModel model = new ReportViewModel();
if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.DONVI))
{
List <SelectListItem> LstCoCauToChuc = CCTC_THANHPHANBusiness.repository.All().Where(x => x.PARENT_ID == currentUser.DeptParentID && x.ID != currentUser.DM_PHONGBAN_ID).Select(
x => new SelectListItem()
{
Text = x.NAME,
Value = x.ID.ToString(),
}).ToList();
model.LstCoCauToChuc = LstCoCauToChuc;
model.LstDonVi = new List <SelectListItem>();
model.HasRoleAssignUnit = true;
model.LstNhanVien = new List <SelectListItem>();
}
else if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.PHONGBAN))
{
CCTC_THANHPHAN DonVi = CCTC_THANHPHANBusiness.Find(currentUser.DM_PHONGBAN_ID);
if (DonVi != null)
{
SelectListItem selectListItem = new SelectListItem();
selectListItem.Text = DonVi.NAME;
selectListItem.Value = DonVi.ID.ToString();
selectListItem.Selected = true;
List <SelectListItem> selectListItems = new List <SelectListItem>();
selectListItems.Add(selectListItem);
model.LstCoCauToChuc = selectListItems;
model.LstDonVi = CCTC_THANHPHANBusiness.GetDataByParent(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0, 0);
}
else
{
model.LstCoCauToChuc = new List <SelectListItem>();
model.LstDonVi = new List <SelectListItem>();
}
model.HasRoleAssignDepartment = true;
model.LstNhanVien = new List <SelectListItem>();
if (model.LstDonVi.Count == 0 && currentUser.DM_PHONGBAN_ID.HasValue)
{
List <int> LstTmpDonVi = new List <int>();
LstTmpDonVi.Add(currentUser.DM_PHONGBAN_ID.Value);
model.LstNhanVien = DM_NGUOIDUNGBusiness.GetByPhongBan(LstTmpDonVi, 0, new List <int>())
.Select(x => new SelectListItem
{
Text = x.HOTEN,
Value = x.ID.ToString()
}).ToList();
}
}
else if (IsInActivities(currentUser.ListThaoTac, PermissionVanbanModel.CANHAN))
{
CCTC_THANHPHAN DonVi = CCTC_THANHPHANBusiness.Find(currentUser.DM_PHONGBAN_ID);
if (DonVi != null)
{
SelectListItem selectListItem = new SelectListItem();
selectListItem.Text = DonVi.NAME;
selectListItem.Value = DonVi.ID.ToString();
selectListItem.Selected = true;
List <SelectListItem> selectListItems = new List <SelectListItem>();
selectListItems.Add(selectListItem);
model.LstDonVi = selectListItems;
model.LstNhanVien = DM_NGUOIDUNGBusiness.GetDsNguoiDung(currentUser.DM_PHONGBAN_ID.HasValue ? currentUser.DM_PHONGBAN_ID.Value : 0);
}
else
{
model.LstDonVi = new List <SelectListItem>();
}
model.HasRoleAssignChuyenVien = true;
}
return(View(model));
}
public PartialViewResult GetReportResult(FormCollection form)
{
string categoryCode = string.Empty;
string reportTitle = string.Empty;
int reportType = form["reportType"].ToIntOrZero();
int timeFilterType = form["timeFilterType"].ToIntOrZero();
int queryItemCategoryType = form["queryItemCategoryType"].ToIntOrZero();
int queryDepartment = form["queryDepartment"].ToIntOrZero();
string categoryName = string.Empty;
string departmentTitleExtenstion = string.Empty;
DateTime?queryDateStart;
DateTime?queryDateEnd;
hscvVanBanDiBusiness = Get <HSCV_VANBANDIBusiness>();
dmDanhMucDataBusiness = Get <DM_DANHMUC_DATABusiness>();
cctcThanhPhanBusiness = Get <CCTC_THANHPHANBusiness>();
CCTC_THANHPHAN department = cctcThanhPhanBusiness.Find(queryDepartment);
departmentTitleExtenstion = department != null && string.IsNullOrEmpty(department.NAME) == false ?
(reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_DONVINHAN_VANBANDI ? string.Format("TỪ ĐƠN VỊ {0}", department.NAME.ToUpper()) : string.Format("CỦA ĐƠN VỊ {0}", department.NAME.ToUpper()))
: string.Empty;
ReportVanBanDiResultViewModel viewModel = new ReportVanBanDiResultViewModel();
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_HINHTHUC_VANBANDI)
{
categoryCode = DMLOAI_CONSTANT.LOAI_VANBAN;
if (queryItemCategoryType > 0)
{
DM_DANHMUC_DATA category = dmDanhMucDataBusiness.Find(queryItemCategoryType) ?? new DM_DANHMUC_DATA();
categoryName = string.IsNullOrEmpty(category.TEXT) ? string.Empty : category.TEXT.ToUpper();
}
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDI)
{
categoryCode = DMLOAI_CONSTANT.LINHVUCVANBAN;
if (queryItemCategoryType > 0)
{
DM_DANHMUC_DATA category = dmDanhMucDataBusiness.Find(queryItemCategoryType) ?? new DM_DANHMUC_DATA();
categoryName = string.IsNullOrEmpty(category.TEXT) ? string.Empty : category.TEXT.ToUpper();
}
}
else
{
categoryCode = DMLOAI_CONSTANT.LINHVUCVANBAN;
if (queryItemCategoryType > 0)
{
CCTC_THANHPHAN receiveDepartment = cctcThanhPhanBusiness.Find(queryItemCategoryType) ?? new CCTC_THANHPHAN();
categoryName = string.IsNullOrEmpty(receiveDepartment.NAME) ? string.Empty : receiveDepartment.NAME.ToUpper();
}
}
if (timeFilterType == LOAI_BAOCAO_THOIGIAN_CONSTANT.NGAY)
{
queryDateStart = form["queryDateStart"].ToDateTime();
queryDateEnd = form["queryDateEnd"].ToDateTime();
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_HINHTHUC_VANBANDI)
{
reportTitle = string.Format("THỐNG KÊ VĂN BẢN ĐI THEO HÌNH THỨC {0} TỪ NGÀY {1} ĐẾN NGÀY {2} {3}", categoryName, queryDateStart.Value.ToVietnameseDateFormat(), queryDateEnd.Value.ToVietnameseDateFormat(), departmentTitleExtenstion);
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDI)
{
reportTitle = string.Format("THỐNG KÊ VĂN BẢN ĐI THEO LĨNH VỰC {0} TỪ NGÀY {1} ĐẾN NGÀY {2} {3}", categoryName, queryDateStart.Value.ToVietnameseDateFormat(), queryDateEnd.Value.ToVietnameseDateFormat(), departmentTitleExtenstion);
}
else
{
reportTitle = string.Format("THỐNG KÊ VĂN BẢN ĐI ĐÃ GỬI CHO ĐƠN VỊ {0} TỪ NGÀY {1} ĐẾN NGÀY {2} {3}", categoryName, queryDateStart.Value.ToVietnameseDateFormat(), queryDateEnd.Value.ToVietnameseDateFormat(), departmentTitleExtenstion);
}
}
else if (timeFilterType == LOAI_BAOCAO_THOIGIAN_CONSTANT.THANG)
{
int month = form["queryMonth"].ToIntOrZero();
int year = form["queryYear"].ToIntOrZero();
queryDateStart = new DateTime(year, month, 1);
queryDateEnd = new DateTime(year, month, DateTime.DaysInMonth(year, month));
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_HINHTHUC_VANBANDI)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐI THEO HÌNH THỨC {0} TRONG THÁNG {1} NĂM {2} {3}", categoryName, month, year, departmentTitleExtenstion);
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDI)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐI THEO LĨNH VỰC {0} TRONG THÁNG {1} NĂM {2} {3}", categoryName, month, year, departmentTitleExtenstion);
}
else
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐI ĐÃ GỬI CHO ĐƠN VỊ {0} TRONG THÁNG {1} NĂM {2} {3}", categoryName, month, year, departmentTitleExtenstion);
}
}
else
{
int year = form["queryYearOnly"].ToIntOrZero();
queryDateStart = new DateTime(year, 1, 1);
queryDateEnd = new DateTime(year, 12, 31);
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_HINHTHUC_VANBANDI)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐI THEO HÌNH THỨC {0} TRONG NĂM {1} {2}", categoryName, year, departmentTitleExtenstion);
}
else if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_LINHVUC_VANBANDI)
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐI THEO LĨNH VỰC {0} TRONG NĂM {1} {2}", categoryName, year, departmentTitleExtenstion);
}
else
{
reportTitle = string.Format("BÁO CÁO VĂN BẢN ĐI ĐÃ GỬI CHO ĐƠN VỊ {0} TRONG NĂM {1} {2}", categoryName, year, departmentTitleExtenstion);
}
}
viewModel.title = reportTitle;
viewModel.reportType = reportType;
if (reportType == LOAI_BAOCAO_VANBAN_CONSTANT.BAOCAO_DONVINHAN_VANBANDI)
{
viewModel.groupOfReportResultItems = hscvVanBanDiBusiness.GetStatisticResultByInteralDepartment(queryDepartment, queryDateStart, queryDateEnd, queryItemCategoryType);
}
else
{
viewModel.groupOfReportResultItems = hscvVanBanDiBusiness.GetStatisticResultByCategory(queryDepartment, categoryCode, queryDateStart, queryDateEnd, queryItemCategoryType);
}
SessionManager.SetValue("ReportVanBanDi" + reportType, viewModel);
return(PartialView("_ReportVanBanDiResult", viewModel));
}
