private static ExcludeIncludeFieldsList ConvertEntityTypeFieldNamesToExcludedIncludedFields( EntityType entityType, IEnumerable <string> fieldNames) { if (fieldNames == null) { return(null); } var fieldMap = GetEntityTypeFieldMap(entityType); if (fieldMap == null) { return(null); } var fields = new IncludeFieldsList(); foreach (var fieldName in fieldNames) { var field = fieldMap.FirstOrDefault(f => f.Key.Equals(fieldName, StringComparison.OrdinalIgnoreCase)); if (!fields.Contains(field.Value)) { fields.Add(field.Value); } } return(fields.Count > 0 ? fields : null); }
public static EmployeeCollection GetEmployees() { var relations = new RelationCollection { EmployeeEntityBase.Relations.ContactEntityUsingContactID }; ISortExpression lastFirstAlpha = (ContactFields.LastName | SortOperator.Ascending) & (ContactFields.FirstName | SortOperator.Ascending); var employees = new EmployeeCollection(); IPrefetchPath prefetch = new PrefetchPath((int)EntityType.EmployeeEntity) { EmployeeEntityBase.PrefetchPathContact }; var includeFields = new IncludeFieldsList(ContactFields.LastName, ContactFields.FirstName, EmployeeFields.EmployeeID); employees.GetMulti(null, 0, lastFirstAlpha, relations, prefetch, includeFields, 0, 0); return(employees); }
public static DataTable GetDataTongPhiDoVe(DateTime?startDate, DateTime?endDate) { #region Get data RelationPredicateBucket filter = new RelationPredicateBucket(); if (startDate != null) { filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop >= startDate); } if (endDate != null) { filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop <= endDate); } filter.PredicateExpression.Add(ThongTinHoSoFields.HoSoMoiNhat == true); IncludeFieldsList includeFields = new IncludeFieldsList(); includeFields.AddRange(new List <EntityField2> { ThongTinHoSoFields.SoThuTuThua, ThongTinHoSoFields.SoHieuToBanDo, ThongTinHoSoFields.LoaiBienDongId, ThongTinHoSoFields.PhiDoVe, ThongTinHoSoFields.PhiThamDinh, ThongTinHoSoFields.XaId, ThongTinHoSoFields.RootId, ThongTinHoSoFields.KhoaChaId }); EntityCollection ec = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .SelectAll(0, null, filter, includeFields); EntityCollection ecXa = GenericEntityColManagerBase <XaEntityFactory> .SelectAll(0, null, new RelationPredicateBucket()); Dictionary <int, string> dictXa = new Dictionary <int, string>(); foreach (XaEntity item in ecXa) { dictXa.Add(item.XaId, item.TenXa); } #endregion #region create datatable DataTable dt = new DataTable("Data"); DataColumn dc = new DataColumn("STT", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoThua", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoTo", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("Phuong", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoLanBienDong", typeof(int)); dt.Columns.Add(dc); dc = new DataColumn("PhiDoVe", typeof(double)); dt.Columns.Add(dc); dc = new DataColumn("PhiThamDinh", typeof(double)); dt.Columns.Add(dc); #endregion #region Set data int stt = 1; foreach (ThongTinHoSoEntity item in ec) { DataRow dr = dt.NewRow(); dr["STT"] = stt.ToString(); dr["SoThua"] = item.SoThuTuThua; dr["SoTo"] = item.SoHieuToBanDo; if (dictXa.ContainsKey(item.XaId)) { dr["Phuong"] = dictXa[item.XaId]; } int soLanBienDong = 0; double tongPhiDoVe = 0, tongPhiThamDinh = 0; if (item.KhoaChaId.HasValue) { filter = new RelationPredicateBucket(); filter.PredicateExpression.Add(ThongTinHoSoFields.RootId == item.RootId); includeFields = new IncludeFieldsList(); includeFields.AddRange(new List <EntityField2> { ThongTinHoSoFields.LoaiBienDongId, ThongTinHoSoFields.PhiDoVe, ThongTinHoSoFields.PhiThamDinh }); EntityCollection ecTemp = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .SelectAll(0, null, filter, includeFields); foreach (ThongTinHoSoEntity itemTTHS in ecTemp) { if (itemTTHS.LoaiBienDongId.HasValue) { soLanBienDong++; } if (itemTTHS.PhiDoVe.HasValue) { tongPhiDoVe += itemTTHS.PhiDoVe.Value; } if (itemTTHS.PhiThamDinh.HasValue) { tongPhiThamDinh += itemTTHS.PhiThamDinh.Value; } } } else { if (item.LoaiBienDongId.HasValue) { soLanBienDong = 1; } if (item.PhiDoVe.HasValue) { tongPhiDoVe = item.PhiDoVe.Value; } if (item.PhiThamDinh.HasValue) { tongPhiThamDinh = item.PhiThamDinh.Value; } } dr["SoLanBienDong"] = soLanBienDong; dr["PhiDoVe"] = tongPhiDoVe; dr["PhiThamDinh"] = tongPhiThamDinh; stt++; dt.Rows.Add(dr); } #endregion return(dt); }
public static DataTable GetDataByLoaiBienDong(DateTime?startDate, DateTime?endDate, List <int> lstLoaibienDongId) { #region Get data RelationPredicateBucket filter = new RelationPredicateBucket(); if (startDate != null) { filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop >= startDate); } if (endDate != null) { filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop <= endDate); } if (lstLoaibienDongId.Count > 0) { filter.PredicateExpression.Add(ThongTinHoSoFields.LoaiBienDongId == lstLoaibienDongId); } IncludeFieldsList includeFields = new IncludeFieldsList(); includeFields.AddRange(new List <EntityField2> { ThongTinHoSoFields.SoBienNhan, ThongTinHoSoFields.LoaiBienDongId, ThongTinHoSoFields.NgayNop, ThongTinHoSoFields.PhiDoVe, ThongTinHoSoFields.PhiThamDinh, ThongTinHoSoFields.XaId }); EntityCollection ec = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .SelectAll(0, null, filter, includeFields); EntityCollection ecXa = GenericEntityColManagerBase <XaEntityFactory> .SelectAll(0, null, new RelationPredicateBucket()); Dictionary <int, string> dictXa = new Dictionary <int, string>(); foreach (XaEntity item in ecXa) { dictXa.Add(item.XaId, item.TenXa); } EntityCollection ecLoaiBD = GenericEntityColManagerBase <LoaiBienDongEntityFactory> .SelectAll(0, null, new RelationPredicateBucket()); Dictionary <int, string> dictLoaiBD = new Dictionary <int, string>(); foreach (LoaiBienDongEntity item in ecLoaiBD) { dictLoaiBD.Add(item.LoaiBienDongId, item.TenLoaiBienDong); } #endregion #region create datatable DataTable dt = new DataTable("Data"); DataColumn dc = new DataColumn("STT", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("LoaiBienDong", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoBienNhan", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("NgayNhan", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("PhiDoVe", typeof(double)); dt.Columns.Add(dc); dc = new DataColumn("PhiThamDinh", typeof(double)); dt.Columns.Add(dc); dc = new DataColumn("Phuong", typeof(string)); dt.Columns.Add(dc); #endregion #region Set data int stt = 1; foreach (ThongTinHoSoEntity item in ec) { DataRow dr = dt.NewRow(); dr["STT"] = stt.ToString(); if (item.LoaiBienDongId != null && dictLoaiBD.ContainsKey((int)item.LoaiBienDongId)) { dr["LoaiBienDong"] = dictLoaiBD[(int)item.LoaiBienDongId]; } dr["SoBienNhan"] = item.SoBienNhan; dr["NgayNhan"] = item.NgayNop?.ToString("dd/MM/yyyy"); if (item.PhiDoVe.HasValue) { dr["PhiDoVe"] = item.PhiDoVe; } if (item.PhiThamDinh.HasValue) { dr["PhiThamDinh"] = item.PhiThamDinh; } if (dictXa.ContainsKey(item.XaId)) { dr["Phuong"] = dictXa[item.XaId]; } stt++; dt.Rows.Add(dr); } #endregion return(dt); }
public static DataTable GetPhiDoVeByNgayKiemTraNoiNghiep(DateTime?startDate, DateTime?endDate) { #region Get data RelationPredicateBucket filter = new RelationPredicateBucket(); if (startDate != null) { filter.PredicateExpression.Add(ThongTinHoSoFields.NgayKiemTraNoiNghiep >= startDate); } if (endDate != null) { filter.PredicateExpression.Add(ThongTinHoSoFields.NgayKiemTraNoiNghiep <= endDate); } IncludeFieldsList includeFields = new IncludeFieldsList(); includeFields.AddRange(new List <EntityField2> { ThongTinHoSoFields.SoBienNhan, ThongTinHoSoFields.SoBanVe, ThongTinHoSoFields.NgayNop, ThongTinHoSoFields.NgayTraHoSo, ThongTinHoSoFields.NguoiNopHoSo, ThongTinHoSoFields.NgayKiemTraNoiNghiep, ThongTinHoSoFields.SoThuTuThua, ThongTinHoSoFields.SoHieuToBanDo, ThongTinHoSoFields.PhiDoVe, ThongTinHoSoFields.PhiThamDinh, ThongTinHoSoFields.XaId }); EntityCollection ec = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .SelectAll(0, null, filter, includeFields); EntityCollection ecXa = GenericEntityColManagerBase <XaEntityFactory> .SelectAll(0, null, new RelationPredicateBucket()); Dictionary <int, string> dictXa = new Dictionary <int, string>(); foreach (XaEntity item in ecXa) { dictXa.Add(item.XaId, item.TenXa); } #endregion #region create datatable DataTable dt = new DataTable("PhiDoVe"); DataColumn dc = new DataColumn("STT", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoBienNhan", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoBanVe", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("NgayNhan", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("NgayTraHoSo", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("TenNguoiNop", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("NgayKiemTraNoiNghiep", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoThua", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("SoTo", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("Phuong", typeof(string)); dt.Columns.Add(dc); dc = new DataColumn("PhiDoVe", typeof(double)); dt.Columns.Add(dc); dc = new DataColumn("PhiThamDinh", typeof(double)); dt.Columns.Add(dc); #endregion #region Set data int stt = 1; foreach (ThongTinHoSoEntity item in ec) { DataRow dr = dt.NewRow(); dr["STT"] = stt.ToString(); dr["SoBienNhan"] = item.SoBienNhan; dr["SoBanVe"] = item.SoBanVe; dr["NgayNhan"] = item.NgayNop?.ToString("dd/MM/yyyy"); dr["NgayTraHoSo"] = item.NgayTraHoSo?.ToString("dd/MM/yyyy"); dr["TenNguoiNop"] = item.NguoiNopHoSo; dr["NgayKiemTraNoiNghiep"] = item.NgayKiemTraNoiNghiep?.ToString("dd/MM/yyyy"); dr["SoThua"] = item.SoThuTuThua; dr["SoTo"] = item.SoHieuToBanDo; if (dictXa.ContainsKey(item.XaId)) { dr["Phuong"] = dictXa[item.XaId]; } if (item.PhiDoVe.HasValue) { dr["PhiDoVe"] = item.PhiDoVe; } if (item.PhiThamDinh.HasValue) { dr["PhiThamDinh"] = item.PhiThamDinh; } stt++; dt.Rows.Add(dr); } #endregion return(dt); }
private static ExcludeIncludeFieldsList ConvertEntityTypeFieldNamesToExcludedIncludedFields( EntityType entityType, IEnumerable<string> fieldNames) { if (fieldNames == null) return null; var fieldMap = GetEntityTypeFieldMap(entityType); if (fieldMap == null) return null; var fields = new IncludeFieldsList(); foreach (var fieldName in fieldNames) { var field = fieldMap.FirstOrDefault(f => f.Key.Equals(fieldName, StringComparison.OrdinalIgnoreCase)); if (!fields.Contains(field.Value)) fields.Add(field.Value); } return fields.Count > 0 ? fields : null; }
public static EntityCollection SelectAll(int iTop, ISortExpression sorter, IRelationPredicateBucket filter, IncludeFieldsList includeFields) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { adapter.FetchEntityCollection(ec, filter, iTop, sorter, null, includeFields); } return(ec); }