public static DataTable GetDataSoLuongKiemTraBanVe(DateTime?startDate, DateTime?endDate)
{
DateTime dateNow = ManageBase.GetDateNow();
#region Create datatable
DataTable dt = new DataTable("Data");
DataColumn dc = new DataColumn("STT", typeof(string));
dt.Columns.Add(dc);
dc = new DataColumn("Phuong", typeof(string));
dt.Columns.Add(dc);
dc = new DataColumn("TongSoBienNhan", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("BienNhanHopLy", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("BienNhanHuy", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("TongBanVeDaKiemTra", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("SoBanVeDat", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("TyLeBanVeDat", typeof(double));
dt.Columns.Add(dc);
dc = new DataColumn("SoBanVeChuaDat", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("TyLeBanVeChuaDat", typeof(double));
dt.Columns.Add(dc);
dc = new DataColumn("SoBanVeDungHan_DKT", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("SoBanVeQuaHan_DKT", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("TongBanVeChuaKiemTra", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("SoBanVeDungHan_CKT", typeof(int));
dt.Columns.Add(dc);
dc = new DataColumn("SoBanVeQuaHan_CKT", typeof(int));
dt.Columns.Add(dc);
#endregion
#region Set data
int stt = 1;
RelationPredicateBucket filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(XaFields.HuyenId == 769);
EntityCollection ecXa = GenericEntityColManagerBase <XaEntityFactory> .SelectAll(0, null, filter);
Dictionary <int, string> dictXa = new Dictionary <int, string>();
int tongSoBienNhan, bienNhanHopLy, bienNhanHuy, tongBanVeDKT, soBanVeDat, soBanVeChuaDat, soBanVeDungHan_DKT, soBanVeQuaHan_DKT, tongBanVeChuaKiemTra, soBanVeDungHan_CKT, soBanVeQuaHan_CKT;
foreach (XaEntity item in ecXa)
{
DataRow dr = dt.NewRow();
dr["STT"] = stt.ToString();
dr["Phuong"] = item.TenXa;
#region Hồ sơ đăng ký kiểm tra
filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(ThongTinHoSoFields.XaId == item.XaId);
if (startDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop >= startDate);
}
if (endDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop <= endDate);
}
tongSoBienNhan = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .GetDbCount(filter);
filter.PredicateExpression.Add(ThongTinHoSoFields.HoSoKhongHopLy == true);
bienNhanHuy = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .GetDbCount(filter);
bienNhanHopLy = tongSoBienNhan - bienNhanHuy;
#endregion
#region Hồ sơ đã kiểm tra
filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(ThongTinHoSoFields.XaId == item.XaId);
if (startDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop >= startDate);
}
if (endDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop <= endDate);
}
filter.PredicateExpression.Add(ThongTinHoSoFields.HoSoDaKiemTra == true);
tongBanVeDKT = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .GetDbCount(filter);
filter.PredicateExpression.Add(ThongTinHoSoFields.HoSoChuaDat == true);
soBanVeChuaDat = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .GetDbCount(filter);
soBanVeDat = tongBanVeDKT - soBanVeChuaDat;
filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(ThongTinHoSoFields.XaId == item.XaId);
if (startDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop >= startDate);
}
if (endDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop <= endDate);
}
filter.PredicateExpression.Add(ThongTinHoSoFields.HoSoDaKiemTra == true);
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayTraHoSo <= ThongTinHoSoFields.NgayHenTra | ThongTinHoSoFields.NgayHenTra >= dateNow);
soBanVeDungHan_DKT = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .GetDbCount(filter);
soBanVeQuaHan_DKT = tongBanVeDKT - soBanVeDungHan_DKT;
#endregion
#region Hồ sơ chưa kiểm tra
filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(ThongTinHoSoFields.XaId == item.XaId);
if (startDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop >= startDate);
}
if (endDate != null)
{
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayNop <= endDate);
}
filter.PredicateExpression.Add(ThongTinHoSoFields.HoSoDaKiemTra == false);
tongBanVeChuaKiemTra = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .GetDbCount(filter);
filter.PredicateExpression.Add(ThongTinHoSoFields.NgayTraHoSo <= ThongTinHoSoFields.NgayHenTra | ThongTinHoSoFields.NgayHenTra >= dateNow);
soBanVeDungHan_CKT = GenericEntityColManagerBase <ThongTinHoSoEntityFactory> .GetDbCount(filter);
soBanVeQuaHan_CKT = tongBanVeChuaKiemTra - soBanVeDungHan_CKT;
#endregion
dr["TongSoBienNhan"] = tongSoBienNhan;
dr["BienNhanHopLy"] = bienNhanHopLy;
dr["BienNhanHuy"] = bienNhanHuy;
dr["TongBanVeDaKiemTra"] = tongBanVeDKT;
dr["SoBanVeDat"] = soBanVeDat;
dr["SoBanVeChuaDat"] = soBanVeChuaDat;
if (tongBanVeDKT > 0)
{
dr["TyLeBanVeDat"] = Math.Round(soBanVeDat / (double)tongBanVeDKT * 100, 2);
dr["TyLeBanVeChuaDat"] = 100 - (double)dr["TyLeBanVeDat"];
}
dr["SoBanVeDungHan_DKT"] = soBanVeDungHan_DKT;
dr["SoBanVeQuaHan_DKT"] = soBanVeQuaHan_DKT;
dr["TongBanVeChuaKiemTra"] = tongBanVeChuaKiemTra;
dr["SoBanVeDungHan_CKT"] = soBanVeDungHan_CKT;
dr["SoBanVeQuaHan_CKT"] = soBanVeQuaHan_CKT;
stt++;
dt.Rows.Add(dr);
}
#endregion
return(dt);
}
public static bool SaveThongTinHoSo(ref ThongTinHoSo value)
{
bool result = true;
try
{
DateTime dateNow = ManageBase.GetDateNow();
ThongTinHoSoEntity thongTinHoSoEntity = new ThongTinHoSoEntity();
thongTinHoSoEntity.ThongTinHoSoId = value.ThongTinHoSoId;
thongTinHoSoEntity.IsNew = value.IsNew;
thongTinHoSoEntity.XaId = GlobalVariable.XaId;
thongTinHoSoEntity.SoBienNhan = value.SoBienNhan;
thongTinHoSoEntity.NgayNop = value.NgayNop;
thongTinHoSoEntity.NgayHenTra = value.NgayHenTra;
thongTinHoSoEntity.NgayTraHoSo = value.NgayTraHoSo;
thongTinHoSoEntity.NgayKiemTraNoiNghiep = value.NgayKiemTraNoiNghiep;
thongTinHoSoEntity.SoBanVe = value.SoBanVe;
thongTinHoSoEntity.PhiDoVe = value.PhiDoVe;
thongTinHoSoEntity.GioiTinhNguoiNop = new bool?(value.GioiTinhNguoiNop);
thongTinHoSoEntity.NguoiNopHoSo = value.NguoiNopHoSo;
thongTinHoSoEntity.SoGiayToNguoiNop = value.SoGiayToNguoiNop;
thongTinHoSoEntity.PhiThamDinh = value.PhiThamDinh;
thongTinHoSoEntity.ChuyenVienId = value.ChuyenVienId;
thongTinHoSoEntity.ChuyenVienKiemTra = value.ChuyenVienKiemTra;
thongTinHoSoEntity.CongTyDoVeId = value.CongTyDoVeId;
thongTinHoSoEntity.CongTyDoVe = value.CongTyDoVe;
thongTinHoSoEntity.HoSoChuaDat = value.HoSoChuaDat;
thongTinHoSoEntity.HoSoDaKiemTra = value.HoSoDaKiemTra;
thongTinHoSoEntity.HoSoKhongHopLy = value.HoSoKhongHopLy;
thongTinHoSoEntity.RootId = value.RootId;
UserLog userLog = new UserLog();
userLog.NguoiDungId = new int?(GlobalVariable.NguoiDungId);
userLog.NgayChinhSua = new DateTime?(dateNow);
userLog.LogHistory = value.LichSuCapNhat;
thongTinHoSoEntity.LichSuCapNhat = JsonConvert.SerializeObject(userLog);
List <string> list = new List <string>();
bool flag = value.ThongTinChiTiet.ListGiayChungNhan != null;
if (flag)
{
foreach (GiayChungNhan current in value.ThongTinChiTiet.ListGiayChungNhan)
{
bool flag2 = !string.IsNullOrEmpty(current.SoSerial);
if (flag2)
{
list.Add(current.SoSerial);
}
}
}
thongTinHoSoEntity.SoHieuGiayChungNhan = string.Join(" ", list);
list = new List <string>();
List <string> list2 = new List <string>();
bool flag3 = value.ThongTinChiTiet.ListChu != null;
if (flag3)
{
foreach (ChuSuDung current2 in value.ThongTinChiTiet.ListChu)
{
bool flag4 = !string.IsNullOrEmpty(current2.HoTen);
if (flag4)
{
list.Add(current2.HoTen);
}
bool flag5 = !string.IsNullOrEmpty(current2.SoGiayTo);
if (flag5)
{
list2.Add(current2.SoGiayTo);
}
}
}
thongTinHoSoEntity.HoTen = string.Join(" ", list);
thongTinHoSoEntity.SoGiayTo = string.Join(" ", list2);
list = new List <string>();
list2 = new List <string>();
List <string> list3 = new List <string>();
bool flag6 = value.ThongTinChiTiet.ListThua != null;
if (flag6)
{
foreach (ThuaDat current3 in value.ThongTinChiTiet.ListThua)
{
bool flag7 = !list.Contains(current3.SoThuTuThua);
if (flag7)
{
list.Add(current3.SoThuTuThua);
}
bool flag8 = !list2.Contains(current3.SoHieuToBanDo);
if (flag8)
{
list2.Add(current3.SoHieuToBanDo);
}
}
}
thongTinHoSoEntity.SoThuTuThua = string.Join(" ", list);
thongTinHoSoEntity.SoHieuToBanDo = string.Join(" ", list2);
thongTinHoSoEntity.GhiChu = value.GhiChu;
thongTinHoSoEntity.LoaiBienDongId = value.LoaiBienDongId;
bool isNew = value.IsNew;
if (isNew)
{
thongTinHoSoEntity.HoSoMoiNhat = true;
}
else
{
thongTinHoSoEntity.HoSoMoiNhat = value.LaHoSoMoiNhat;
}
thongTinHoSoEntity.NguoiDungId = new int?(GlobalVariable.NguoiDungId);
thongTinHoSoEntity.ChiTietHoSo = JsonConvert.SerializeObject(value.ThongTinChiTiet);
thongTinHoSoEntity.KhoaChaId = value.KhoaChaId;
value.ThongTinHoSoId = ManageBase.SaveThongTinHoSo(thongTinHoSoEntity);
value.IsSuccess = true;
value.NguoiCapNhat = GlobalVariable.HoTenNguoiDung;
bool flag9 = string.IsNullOrEmpty(value.NguoiCapNhat);
if (flag9)
{
value.NguoiCapNhat = GlobalVariable.TenDangNhap;
}
value.NgayChinhSua = new DateTime?(dateNow);
value.LichSuCapNhat = userLog;
value.LaHoSoMoiNhat = thongTinHoSoEntity.HoSoMoiNhat;
bool flag10 = value.IsNew && value.KhoaChaId.HasValue;
if (flag10)
{
ManageBase.Update(new ThongTinHoSoEntity
{
HoSoMoiNhat = false,
NguoiDungId = new int?(GlobalVariable.NguoiDungId)
}, new RelationPredicateBucket
{
PredicateExpression =
{
ThongTinHoSoFields.ThongTinHoSoId == value.KhoaChaId
}
});
}
value.IsNew = false;
}
catch (Exception var_27_4C1)
{
result = false;
}
return(result);
}