public VanBanChildBO GetBO(long id) { var result = (from vb in this.context.QUANLY_VANBAN join mst in this.context.DM_DANHMUC_DATA on vb.COQUAN_BANHANH_ID equals(int) mst.ID into group1 from gCoQuanBanHanh in group1.DefaultIfEmpty() join tl in this.context.TAILIEUDINHKEM on vb.HOSO_ID equals tl.ITEM_ID into group2 from gTaiLieu in group2.DefaultIfEmpty() where vb.ID == id select new VanBanChildBO { HOSO_ID = vb.HOSO_ID.Value, COQUAN_BANHANH_ID = vb.COQUAN_BANHANH_ID, VANBAN_ID = vb.ID, COQUAN_BANHANH_NAME = gCoQuanBanHanh.TEXT, NGAYBANHANH = vb.NGAYBANHANH, SO_KYHIEU = vb.SO_KYHIEU, TRICHYEU_VANBAN = vb.TRICHYEU_VANBAN, TAILIEU_ID = gTaiLieu.TAILIEU_ID, TAILIEU_NAME = gTaiLieu.TENTAILIEU }).FirstOrDefault(); if (result != null) { // public const int VANBAN = 1999; var listTailieu = new TAILIEUDINHKEMBusiness(new UnitOfWork()).GetDataByItemID(result.VANBAN_ID, 1999); if (listTailieu.Any()) { var taiLieu = listTailieu.FirstOrDefault(); if (taiLieu != null) { result.TAILIEU_ID = taiLieu.TAILIEU_ID; result.TAILIEU_NAME = taiLieu.TENTAILIEU; } } result.NGAYBANHANH_FORMAT = string.Format("{0:dd/MM/yyyy}", result.NGAYBANHANH); return(result); } return(new VanBanChildBO()); }
public List <VanBanChildBO> GetByHoSo(long?hoSoId = 0) { var result = (from vb in this.context.QUANLY_VANBAN join mst in this.context.DM_DANHMUC_DATA on vb.COQUAN_BANHANH_ID equals(int) mst.ID into group1 from gCoQuanBanHanh in group1.DefaultIfEmpty() where vb.HOSO_ID == hoSoId select new VanBanChildBO { HOSO_ID = vb.HOSO_ID.Value, COQUAN_BANHANH_ID = vb.COQUAN_BANHANH_ID, VANBAN_ID = vb.ID, COQUAN_BANHANH_NAME = gCoQuanBanHanh.TEXT, NGAYBANHANH = vb.NGAYBANHANH, SO_KYHIEU = vb.SO_KYHIEU, TRICHYEU_VANBAN = vb.TRICHYEU_VANBAN }).ToList(); if (result.Any()) { foreach (var item in result) { // public const int VANBAN = 1999; var listTailieu = new TAILIEUDINHKEMBusiness(new UnitOfWork()).GetDataByItemID(item.VANBAN_ID, 1999); if (listTailieu.Any()) { var taiLieu = listTailieu.FirstOrDefault(); if (taiLieu != null) { item.TAILIEU_ID = taiLieu.TAILIEU_ID; item.TAILIEU_NAME = taiLieu.TENTAILIEU; } } item.NGAYBANHANH_FORMAT = string.Format("{0:dd/MM/yyyy}", item.NGAYBANHANH); } return(result); } return(new List <VanBanChildBO>()); }