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);
}
