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