void BuildTreeKhuVuc()
{
try
{
TinDungProcess tindunProcess = new TinDungProcess();
DataSet ds = tindunProcess.getDanhSachDonVi(AppConfig.LoginedUser.MaDonVi, AppConfig.LoginedUser.UserName);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
DataRow drRoot = dt.Rows[0];
tvwKhuVuc.Nodes.Clear();
TreeNode rootItem = new TreeNode();
rootItem.Text = drRoot["ten_gdich"].ToString();
rootItem.Value = drRoot["ma_dvi"].ToString();
//rootItem.Checked = true;
tvwKhuVuc.Nodes.Add(rootItem);
BuildSubTreeKhuVuc(rootItem);
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
void tlbCapNhatLich_Click(object sender, RoutedEventArgs e)
{
_TDVMKHEUOC = radDanhSachKheUoc.SelectedItem as TDVM_KHE_UOC;
index = objDanhSach.IndexOf(_TDVMKHEUOC);
if (index < 0)
{
return;
}
List <TDVM_KHE_UOC> lstTDVM_KHE_UOC = new List <TDVM_KHE_UOC>();
TD_KHOACHVM[] lstDieuKien = raddgrThongTinLapLich.ItemsSource as TD_KHOACHVM[];
TD_KHOACHVM_CT[] lstKeHoach = null;
_TDVMKHEUOC.DSACH_KHOACHVM = lstDieuKien;
_TDVMKHEUOC.DSACH_KHOACHVM_CTIET = lstKeHoach;
lstTDVM_KHE_UOC.Add(_TDVMKHEUOC);
KUOCVMDS.DSACH_KHE_UOC = lstTDVM_KHE_UOC.ToArray();
List <ClientResponseDetail> lstresponseDetail = new List <ClientResponseDetail>();
int iret = new TinDungProcess().LapKheUocDanhSach_01(DatabaseConstant.Action.TINH_TOAN_LICH_TRA_NO, ref KUOCVMDS, ref lstresponseDetail);
if (iret > 0)
{
lstTDVM_KHE_UOC = KUOCVMDS.DSACH_KHE_UOC.ToList();
_TDVMKHEUOC = lstTDVM_KHE_UOC.FirstOrDefault();
objDanhSach[index] = _TDVMKHEUOC;
radDanhSachKheUoc.ItemsSource = objDanhSach;
radDanhSachKheUoc.Rebind();
radDanhSachKheUoc.SelectedItem = _TDVMKHEUOC;
}
else
{
CommonFunction.ThongBaoKetQua(lstresponseDetail);
}
}
private void OnSave()
{
Cursor = Cursors.Wait;
List <ClientResponseDetail> lstResponseDetail = new List <ClientResponseDetail>();
int iret = 0;
try
{
if (Validation())
{
if (GetDataForm())
{
iret = new TinDungProcess().DiaBanSanPham(DatabaseConstant.Action.THEM, ref obj, ref lstResponseDetail);
AfterSave(iret, lstResponseDetail);
}
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
}
finally
{
lstResponseDetail = null;
Cursor = Cursors.Arrow;
}
}
private void LayThongTinKeHoach()
{
TinDungProcess process = new TinDungProcess();
try
{
DataSet ds = process.getThongTinKeHoach(_kheUoc.MA_KHE_UOC, _ngayThuTien, Presentation.Process.Common.ClientInformation.MaDonVi);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
grGocLaiTruocHan.ItemsSource = ds.Tables[0].DefaultView;
foreach (DataRow dr in ds.Tables[0].Rows)
{
_soTienGocConPhaiNop += Convert.ToDecimal(dr["kh_tra_goc"]);
}
}
else
{
chkTraTruocHan.Tag = "False";
}
}
catch (System.Exception ex)
{
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
finally
{
process = null;
}
}
private void LayThongTinKeHoachThucTeChon()
{
TinDungProcess process = new TinDungProcess();
try
{
DataSet ds = process.getThongTinKeHoachPopup(_kheUoc.MA_KHE_UOC, _lstNgayThuTien);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
dtKeHoach = ds.Tables[0];
}
else
{
CommonFunction.ThongBaoLoi("Kế hoạch không tồn tại");
}
}
catch (System.Exception ex)
{
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
finally
{
process = null;
}
}
private void Xoa()
{
if (tlbDelete.IsEnabled == false)
{
return;
}
Cursor = Cursors.Wait;
List <int> lstID = new List <int>();
UtilitiesProcess process = new UtilitiesProcess();
bool retLockData = true;
try
{
if (dgrVongVayDS.SelectedItems.Count > 0)
{
if (LMessage.ShowMessage("M.DungChung.HoiXoa", LMessage.MessageBoxType.Question) == MessageBoxResult.Yes)
{
foreach (DataRowView dr in dgrVongVayDS.SelectedItems)
{
lstID.Add(Convert.ToInt32(dr["ID"]));
}
// Yêu cầu lock dữ liệu
retLockData = process.LockData(DatabaseConstant.Module.TDTT,
DatabaseConstant.Function.TDVM_VONG_VAY,
DatabaseConstant.Table.TD_VONG_VAY,
DatabaseConstant.Action.XOA,
lstID);
if (!retLockData)
{
return;
}
List <ClientResponseDetail> ResponseDetail = new List <ClientResponseDetail>();
bool bResult = new TinDungProcess().XoaVongVayTinDung(lstID.ToArray(), ref ResponseDetail);
if (bResult)
{
LoadDuLieu();
}
CommonFunction.ThongBaoKetQua(ResponseDetail);
}
}
}
catch (Exception ex)
{
LMessage.ShowMessage("M.DanhMuc.LoiChung", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
// Yêu cầu Unlock dữ liệu
retLockData = process.UnlockData(DatabaseConstant.Module.TDTT,
DatabaseConstant.Function.TDVM_VONG_VAY,
DatabaseConstant.Table.TD_VONG_VAY,
DatabaseConstant.Action.XOA,
lstID);
}
Cursor = Cursors.Arrow;
}
void LoadData()
{
try
{
string MaTrangThai = ucTrangThaiNVu.GetItemsSelected();
string SoGiaoDich = txtSoGiaoDich.Text;
string NgayDieuChinhTu = teldtNgayDieuChinhTu.Value != null?LDateTime.DateToString(teldtNgayDieuChinhTu.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat) : "";
string NgayDieuChinhDen = teldtNgayDieuChinhDen.Value != null?LDateTime.DateToString(teldtNgayDieuChinhDen.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat) : "";
string MaNguonVon = "";
string TenNguonVon = "";
string MaHDTD = "";
string MaKUOC = "";
string NgayNhanNoTu = teldtNgayNhanNoTu.Value != null?LDateTime.DateToString(teldtNgayNhanNoTu.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat) : "";
string NgayNhanNoDen = teldtNgayNhanNoDen.Value != null?LDateTime.DateToString(teldtNgayNhanNoDen.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat) : "";
string NgayDaoHanTu = teldtNgayDaoHanTu.Value != null?LDateTime.DateToString(teldtNgayDaoHanTu.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat) : "";
string NgayDaoHanDen = teldtNgayDaoHanDen.Value != null?LDateTime.DateToString(teldtNgayDaoHanDen.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat) : "";
string SoTienGNganTu = txtSoTienVayTu.Value.GetValueOrDefault(0).ToString();
string SoTienGNganDen = txtSoTienVayDen.Value.GetValueOrDefault(0).ToString();
string SoDuTu = txtSoDuTu.Value.GetValueOrDefault(0).ToString();
string SoDuDen = txtSoDuDen.Value.GetValueOrDefault(0).ToString();
string ThoiHanVayTu = txtThoiHanVayTu.Value.GetValueOrDefault(0).ToString();
string ThoiHanVayDen = txtThoiHanVayDen.Value.GetValueOrDefault(0).ToString();
string ThoiHanVayDViTu = "";
string ThoiHanVayDViDen = "";
string LSuatTu = txtLaiSuatTu.Value.GetValueOrDefault(0).ToString();
string LSuatDen = txtLaiSuatTu.Value.GetValueOrDefault(0).ToString();
string MaKhachHang = txtMaKhachHang.Text;
string TenKhachHang = txtTenKhachHang.Text;
string LoaiGiayTo = "";
string SoGiayTo = txtSoGiayTo.Text;
string DienThoai = txtDienThoai.Text;
string Email = txtEmail.Text;
string MaSanPham = ClientInformation.MaDonViGiaoDich;
if (LObject.IsNullOrEmpty(tvwKhuVuc.SelectedItem))
{
tvwKhuVuc.SelectedItem = tvwKhuVuc.Items[0];
}
string ListKVuc = ((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString();
DataSet ds = new TinDungProcess().GetDanhSachDieuChinhLSuat(MaTrangThai, SoGiaoDich, NgayDieuChinhTu, NgayDieuChinhDen, MaNguonVon, TenNguonVon, MaHDTD, MaKUOC, NgayNhanNoTu, NgayNhanNoDen, NgayDaoHanTu, NgayDaoHanDen, SoTienGNganTu, SoTienGNganDen, SoDuTu, SoDuDen, ThoiHanVayTu, ThoiHanVayDen, ThoiHanVayDViTu, ThoiHanVayDViDen, LSuatTu, LSuatDen, MaKhachHang, TenKhachHang, LoaiGiayTo, SoGiayTo, DienThoai, Email, MaSanPham, ListKVuc);
if (ds != null)
{
grdDieuChinhLS.ItemsSource = ds.Tables["DANH_SACH"].DefaultView;
}
if (!LObject.IsNullOrEmpty(grdDieuChinhLS.SelectedItems))
{
grdDieuChinhLS.SelectedItems.Clear();
}
}
catch (System.Exception ex)
{
}
}
void Xoa()
{
if (!tlbDelete.IsEnabled)
{
return;
}
Cursor = Cursors.Wait;
try
{
if (raddgrHDTDDS.SelectedItems.Count > 0)
{
if (LMessage.ShowMessage("M.DungChung.HoiXoa", LMessage.MessageBoxType.Question) == MessageBoxResult.Yes)
{
List <TD_HDTDVM> lstHDTDVM = new List <TD_HDTDVM>();
List <int> lstID = new List <int>();
foreach (DataRowView dr in raddgrHDTDDS.SelectedItems)
{
lstID.Add(Convert.ToInt32(dr["ID"]));
objHDTDVM.HDTD_VM = new TD_HDTDVM();
objHDTDVM.HDTD_VM.ID = Convert.ToInt32(dr["ID"]);
objHDTDVM.HDTD_VM.MA_HDTDVM = dr["MA_HDTDVM"].ToString();
objHDTDVM.HDTD_VM.TTHAI_NVU = dr["TTHAI_NVU"].ToString();
objHDTDVM.HDTD_VM.SO_GDICH = dr["SO_GDICH"].ToString();
lstHDTDVM.Add(objHDTDVM.HDTD_VM);
}
objHDTDVM.DSACH_HDTD_VM = lstHDTDVM.ToArray();
// Yêu cầu lock dữ liệu
UtilitiesProcess process = new UtilitiesProcess();
bool retLockData = process.LockData(DatabaseConstant.Module.TDVM,
DatabaseConstant.Function.TDVM_CHI_TIET_HOP_DONG,
DatabaseConstant.Table.TD_HDTDVM,
DatabaseConstant.Action.XOA,
lstID);
List <ClientResponseDetail> ResponseDetail = new List <ClientResponseDetail>();
int bResult = new TinDungProcess().XoaHopDongTinDungViMo(objHDTDVM, ref ResponseDetail);
if (bResult == 1)
{
LoadData();
}
CommonFunction.ThongBaoKetQua(ResponseDetail);
// Yêu cầu Unlock dữ liệu
retLockData = process.UnlockData(DatabaseConstant.Module.TDVM,
DatabaseConstant.Function.TDVM_CHI_TIET_HOP_DONG,
DatabaseConstant.Table.TD_HDTDVM,
DatabaseConstant.Action.XOA,
lstID);
}
}
}
catch (Exception ex)
{
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
Cursor = Cursors.Arrow;
}
void LoadDataForm()
{
DataSet ds = new TinDungProcess().GetThongTinChiTietGDichDuThu(TDVMDUTHU.MA_GIAO_DICH);
if (ds != null)
{
LoadTabThongTinChung(ds);
LoadTabKiemSoat(ds);
OnModify();
}
}
void OnCancel()
{
if (iDGiaoDich > 0)
{
TDVMDUTHU.ID_GIAO_DICH = iDGiaoDich;
TDVMDUTHU.MA_GIAO_DICH = _objKiemSoat.SO_GIAO_DICH;
TDVMDUTHU.NGUOI_CAP_NHAT = ClientInformation.TenDangNhap;
TDVMDUTHU.NGAY_CAP_NHAT = ClientInformation.NgayLamViecHienTai;
List <ClientResponseDetail> lstClientDetail = new List <ClientResponseDetail>();
int iret = new TinDungProcess().ThoaiDuyetGiaoDichDuThu(ref TDVMDUTHU, ref lstClientDetail);
AfterCancel(lstClientDetail, iret);
}
}
private List <string> Tuchoi(string listitem)
{
List <string> listResult = new List <string>();
if (listitem != "")
{
List <int> lstID = new List <int>();
string[] str = listitem.Split(';');
if (str != null && str.Length > 0)
{
for (int k = 0; k < str.Length; k++)
{
lstID.Add(Convert.ToInt32(str[k]));
}
}
List <ClientResponseDetail> ResponseDetail = new List <ClientResponseDetail>();
UtilitiesProcess process = new UtilitiesProcess();
if (process.LockData(DatabaseConstant.Module.TDVM,
DatabaseConstant.Function.TDVM_SAN_PHAM_TDVM,
DatabaseConstant.Table.TD_SAN_PHAM,
DatabaseConstant.Action.TU_CHOI_DUYET,
lstID))
{
bool bResult = new TinDungProcess().TuChoiSanPhamTinDung(lstID, ref ResponseDetail);
if (bResult)
{
foreach (ClientResponseDetail cl in ResponseDetail)
{
listResult.Add(LanguageEngine.Instance().GetContent(LanguageType.TypeMessage, cl.Result) + "#" + LanguageEngine.Instance().GetContent(LanguageType.TypeMessage, cl.Detail.Split('#')[0]));
}
// Yeu cau Unlook du lieu
process.UnlockData(DatabaseConstant.Module.TDVM,
DatabaseConstant.Function.TDVM_SAN_PHAM_TDVM,
DatabaseConstant.Table.TD_SAN_PHAM,
DatabaseConstant.Action.TU_CHOI_DUYET,
lstID);
LoadDuLieu();
}
else
{
listResult.Add("M.DungChung.DuyetKhongThanhCong#" + LanguageEngine.Instance().GetContent(LanguageType.TypeMessage, "M.DungChung.DuyetKhongThanhCong"));
}
}
else
{
listResult.Add("M.ResponseMessage.Common.LockDataInvalid#" + LanguageEngine.Instance().GetContent(LanguageType.TypeMessage, "M.ResponseMessage.Common.LockDataInvalid"));
}
}
return(listResult);
}
/// <summary>
/// Từ chối duyệt
/// </summary>
private void TuChoi()
{
if (!tlbRefuse.IsEnabled)
{
return;
}
try
{
if (grdDangKySanPhamDS.SelectedItems.Count > 0)
{
if (LMessage.ShowMessage("M.DungChung.HoiDuyet", LMessage.MessageBoxType.Question) == MessageBoxResult.Yes)
{
List <int> lstID = new List <int>();
foreach (DataRowView dr in grdDangKySanPhamDS.SelectedItems)
{
lstID.Add(Convert.ToInt32(dr["ID"]));
}
List <ClientResponseDetail> ResponseDetail = new List <ClientResponseDetail>();
UtilitiesProcess process = new UtilitiesProcess();
bool retLockData = process.LockData(DatabaseConstant.Module.TDVM,
DatabaseConstant.Function.TDVM_SAN_PHAM_TDVM,
DatabaseConstant.Table.TD_SAN_PHAM,
DatabaseConstant.Action.TU_CHOI_DUYET,
lstID);
bool bResult = new TinDungProcess().TuChoiSanPhamTinDung(lstID, ref ResponseDetail);
if (bResult)
{
CommonFunction.ThongBaoKetQua(ResponseDetail);
// Yeu cau Unlook du lieu
retLockData = process.UnlockData(DatabaseConstant.Module.TDVM,
DatabaseConstant.Function.TDVM_SAN_PHAM_TDVM,
DatabaseConstant.Table.TD_SAN_PHAM,
DatabaseConstant.Action.TU_CHOI_DUYET,
lstID);
LoadDuLieu();
}
else
{
LMessage.ShowMessage("M.DungChung.DuyetKhongThanhCong", LMessage.MessageBoxType.Error);
}
}
}
}
catch (Exception ex)
{
LMessage.ShowMessage("M.DanhMuc.LoiChung", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
void OnSave()
{
List <ClientResponseDetail> lstResponse = new List <ClientResponseDetail>();
int iret = 0;
if (iDGiaoDich == 0)
{
iret = new TinDungProcess().ThemMoiGiaoDichDuThu(ref TDVMDUTHU, ref lstResponse);
}
else
{
iret = new TinDungProcess().SuaGiaoDichDuThu(ref TDVMDUTHU, ref lstResponse);
}
AfterSave(lstResponse, iret);
}
private void LayDSDonVayVon(int idKhachHang)
{
try
{
DataSet dsDonVayVon = new DataSet();
TinDungProcess tdProcess = new TinDungProcess();
dsDonVayVon = tdProcess.LayDSDonVayVon(idKhachHang);
if (dsDonVayVon == null)
{
return;
}
//raddgrThongTinDon.DataContext = dsDonVayVon.Tables[0].DefaultView;
raddgrThongTinDon.ItemsSource = dsDonVayVon.Tables[0].DefaultView;
raddgrThongTinDon.Rebind();
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void HienThiDSTaiSan(string idKuoc)
{
try
{
DataSet dsTaiSan = new DataSet();
TinDungProcess tdProcess = new TinDungProcess();
dsTaiSan = tdProcess.LayTaiSanTheoIDKuoc(idKuoc);
_listTSDB = new List <DANH_SACH_TSDB>();
DANH_SACH_TSDB objTSDB = new DANH_SACH_TSDB();
if (dsTaiSan != null && dsTaiSan.Tables.Count > 0)
{
foreach (DataRow dr in dsTaiSan.Tables[0].Rows)
{
objTSDB = new DANH_SACH_TSDB();
objTSDB.GTRI_CON_DBAO = Convert.ToDecimal(dr["GTRI_CON_DBAO"]);
objTSDB.GTRI_DAM_BAO = Convert.ToDecimal(dr["GTRI_DAM_BAO"]);
objTSDB.GTRI_DBAO_DTUONG = Convert.ToDecimal(dr["GTRI_DBAO_DTUONG"]);
objTSDB.GTRI_DINH_GIA = Convert.ToDecimal(dr["GTRI_DINH_GIA"]);
objTSDB.GTRI_TSDB_XLN = Convert.ToDecimal(dr["GIA_TRI_TS_DB"]);
objTSDB.GTRI_TY_LE = Convert.ToDecimal(dr["GTRI_TY_LE"]);
objTSDB.ID_TSDB = Convert.ToInt32(dr["ID_TSDB"]);
objTSDB.MA_HDTC = dr["MA_HDTC"].ToString();
objTSDB.MA_LOAI_TSDB = dr["MA_LOAI_TSDB"].ToString();
objTSDB.MA_TSDB = dr["MA_TSDB"].ToString();
objTSDB.TEN_TAI_SAN = dr["TEN_TSDB"].ToString();
objTSDB.MA_THAM_CHIEU = dr["MA_TCHIEU"].ToString();
objTSDB.MA_KHE_UOC = _objKuoc.MA_KUOCVM;
_listTSDB.Add(objTSDB);
}
}
grdTaiSanDamBao.ItemsSource = _listTSDB;
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
/// <summary>
/// Xu ly nghiep vu
/// </summary>
#region Xu ly nghiep vu
private void OnAction()
{
Cursor = Cursors.Wait;
int iret = 1;
List <ClientResponseDetail> lstClientResponseDetail = new List <ClientResponseDetail>();
try
{
if (!Validation())
{
return;
}
if (objLichThuGocLai.IsNullOrEmpty())
{
objLichThuGocLai = new TDVM_LICH_THU_GOC_LAI();
}
AutoCompleteEntry au = lstSourceBDauTra.ElementAt(cmbThangBDTra.SelectedIndex);
AutoCompleteEntry auNN = lstNguyenNhanTDoi.ElementAt(cbbNguyenNhanThayDoi.SelectedIndex);
objLichThuGocLai.DSACH_KUOCVM = lstDanhSachKUOC.ToArray();
objLichThuGocLai.ID_CUM = idCum;
objLichThuGocLai.MA_CUM = maCum;
objLichThuGocLai.NGAY_BAT_DAU = au.KeywordStrings[2];
objLichThuGocLai.NGUYEN_NHAN_TDOI = auNN.KeywordStrings.FirstOrDefault();
iret = new TinDungProcess().LapLichThuGocLai(DatabaseConstant.Action.TINH_TOAN_LICH_TRA_NO, ref objLichThuGocLai, ref lstClientResponseDetail);
CommonFunction.ThongBaoKetQua(lstClientResponseDetail);
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
}
finally
{
Cursor = Cursors.Arrow;
}
}
/// <summary>
/// Load dữ liệu
/// </summary>
private void LoadDuLieu()
{
Cursor = Cursors.Wait;
try
{
TinDungProcess tindungProcess = new TinDungProcess();
string lstTrangThai = ucTrangThai.GetItemsSelected();
string sMaVongVay = txtMaVongVay.Text;
string sNgayLapTu = teldtNgayLapTu.Value != null?LDateTime.DateToString((DateTime)teldtNgayLapTu.Value, ApplicationConstant.defaultDateTimeFormat) : "";
string sNgayLapDen = teldtNgayLapDen.Value != null?LDateTime.DateToString((DateTime)teldtNgayLapDen.Value, ApplicationConstant.defaultDateTimeFormat) : "";
string sHanMucGocVay = lstHanMucGocVay.ElementAt(cmbTinhChatGocVay.SelectedIndex).KeywordStrings.First();
string sHanMucKyHan = lstHanMucKyHan.ElementAt(cmbTinhChatKyHan.SelectedIndex).KeywordStrings.First();
if (tvwKhuVuc.SelectedItem == null)
{
tvwKhuVuc.SelectedItem = tvwKhuVuc.Items[0];
}
string ListKVuc = "";
if (((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString().Substring(0, 3).Equals("DVI"))
{
RadTreeViewItem itemDVI = (RadTreeViewItem)tvwKhuVuc.SelectedItem;
foreach (RadTreeViewItem item in itemDVI.Items)
{
if (item.Tag.ToString().Substring(0, 3).Equals("CNH"))
{
ListKVuc += ",''" + item.Tag.ToString() + "''";
}
}
ListKVuc = ListKVuc.Substring(3);
ListKVuc = ListKVuc.Substring(0, ListKVuc.Length - 2);
}
else if (((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString().Substring(0, 3).Equals("CNH"))
{
ListKVuc = ((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString();
}
else if (((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString().Substring(0, 3).Equals("PGD"))
{
ListKVuc = ((RadTreeViewItem)((RadTreeViewItem)tvwKhuVuc.SelectedItem).Parent).Tag.ToString();
}
else if (((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString().Substring(0, 3).Equals("CUM"))
{
ListKVuc = ((RadTreeViewItem)((RadTreeViewItem)((RadTreeViewItem)tvwKhuVuc.SelectedItem).Parent).Parent).Tag.ToString();
}
DataSet ds = tindungProcess.getDanhSachVongVonVay(lstTrangThai, sMaVongVay, sNgayLapTu, sNgayLapDen, sHanMucGocVay, sHanMucKyHan, "%", ListKVuc);
if (ds != null & ds.Tables[0].Columns.Count > 0)
{
dgrVongVayDS.ItemsSource = null;
dgrVongVayDS.ItemsSource = ds.Tables[0].DefaultView;
if (!LObject.IsNullOrEmpty(dgrVongVayDS.SelectedItems))
{
dgrVongVayDS.SelectedItems.Clear();
}
}
}
catch (Exception ex)
{
LMessage.ShowMessage("M.DanhMuc.LoiChung", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
Cursor = Cursors.Arrow;
}
private void LayThongTinKheUoc(int idKheUoc, string sMaKheUoc, string sLoai)
{
TinDungProcess tdProcess = new TinDungProcess();
TDVM_KHE_UOC objKuoc = new TDVM_KHE_UOC();
objKuoc.KUOC_VM = new TD_KUOCVM();
objKuoc.KUOC_VM.ID = idKheUoc;
objKuoc.KUOC_VM.MA_KUOCVM = sMaKheUoc;
int iRet = 0;
if (sLoai.Equals("GetByID"))
{
iRet = tdProcess.GetKUocById(ref objKuoc);
}
else
{
iRet = tdProcess.GetKUocByMaKuoc(ref objKuoc);
}
decimal decDuNoLai = 0;
_objKHang = new KH_KHANG_HSO();
if (iRet != 0)
{
if (objKuoc.KUOC_VM != null)
{
decDuNoLai = objKuoc.KUOC_VM.LAI_PHAI_THU - objKuoc.KUOC_VM.LAI_DA_THU;
_objKuoc = objKuoc.KUOC_VM;
if (_objKuoc.MA_DVI_TAO != ClientInformation.MaDonViGiaoDich)
{
_objKuoc = null;
XoaDuLieu();
return;
}
HienThiDSTaiSan(_objKuoc.ID.ToString());
_decDuPhongCuThe = objKuoc.KUOC_VM.SO_TIEN_TLDP;
txtSoKheUoc.Text = objKuoc.KUOC_VM.MA_KUOCVM;
teldtNgayVay.Value = LDateTime.StringToDate(objKuoc.KUOC_VM.NGAY_GIAI_NGAN, "yyyyMMdd");
txtThoiHanVay.Text = objKuoc.KUOC_VM.TGIAN_VAY.ToString();
cmbThoiHanVay.SelectedIndex = lstThoiHanVay.IndexOf(lstThoiHanVay.FirstOrDefault(e => e.KeywordStrings[0].Equals(objKuoc.KUOC_VM.TGIAN_VAY_DVI_TINH)));
txtLaiSuat.Value = Convert.ToDouble(objKuoc.KUOC_VM.LAI_SUAT);
teldtNgayDaoHan.Value = LDateTime.StringToDate(objKuoc.KUOC_VM.NGAY_DAO_HAN, "yyyyMMdd");
txtSoTienVay.Value = Convert.ToDouble(objKuoc.KUOC_VM.SO_TIEN_GIAI_NGAN);
cmbNhomNo.SelectedIndex = lstNhomNo.IndexOf(lstNhomNo.FirstOrDefault(e => e.KeywordStrings[0].Equals(objKuoc.KUOC_VM.NHOM_NO_HIEN_TAI)));
txtDuNoGoc.Value = Convert.ToDouble(objKuoc.KUOC_VM.SO_DU);
txtDuNoLai.Value = Convert.ToDouble(decDuNoLai);
txtXuKyDuNoGoc.Value = Convert.ToDouble(objKuoc.KUOC_VM.SO_DU);
txtXuKyDuNoLai.Value = Convert.ToDouble(decDuNoLai);
iRet = tdProcess.GetKHangByKuoc(ref _objKHang, objKuoc);
}
else
{
txtSoKheUoc.Text = "";
teldtNgayVay.Value = LDateTime.StringToDate(ClientInformation.NgayLamViecHienTai, "yyyyMMdd");
txtThoiHanVay.Text = "0";
cmbThoiHanVay.SelectedIndex = lstThoiHanVay.IndexOf(lstThoiHanVay.FirstOrDefault(e => e.KeywordStrings[0].Equals(BusinessConstant.KY_HAN_DVI_TINH.THANG.layGiaTri())));
txtLaiSuat.Value = 0;
teldtNgayDaoHan.Value = LDateTime.StringToDate(ClientInformation.NgayLamViecHienTai, "yyyyMMdd");
txtSoTienVay.Value = 0;
cmbNhomNo.SelectedIndex = lstNhomNo.IndexOf(lstNhomNo.FirstOrDefault(e => e.KeywordStrings[0].Equals(BusinessConstant.NHOM_NO.NHOM1.layGiaTri())));
txtDuNoGoc.Value = 0;
txtDuNoLai.Value = 0;
txtXuKyDuNoGoc.Value = 0;
txtXuKyDuNoLai.Value = 0;
}
}
TToanTrichLapDuPhongChiPhi();
}
private void LoadDuLieu()
{
try
{
TinDungProcess tindungProcess = new TinDungProcess();
string maDonVi = cmbDonVi.SelectedItem.Value;// "0001";// lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(0);
string MaTTNVu = "";
if (cbChoduyet.Checked)
{
MaTTNVu = MaTTNVu + "''" + cbChoduyet.Value + "'',";
}
if (cbDaduyet.Checked)
{
MaTTNVu = MaTTNVu + "''" + cbDaduyet.Value + "'',";
}
if (cbThoaiduyet.Checked)
{
MaTTNVu = MaTTNVu + "''" + cbThoaiduyet.Value + "'',";
}
if (cbDaduyet.Checked)
{
MaTTNVu = MaTTNVu + "''" + cbDaduyet.Value + "'',";
}
if (MaTTNVu != "")
{
MaTTNVu = "(" + MaTTNVu.Substring(0, MaTTNVu.Length - 1) + ")";
}
string MaLoaiSP = cmbLoaiSanPham.SelectedItem.Value; //lstLoaiSanPham.ElementAt(cmbLoaiSanPham.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaTinhTrangHLuc = cmbTinhTrang.SelectedItem.Value; // lstHieuLuc.ElementAt(cmbTinhTrang.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaMucDichVay = cmbMucDich.SelectedItem.Value; //lstMucDichSuDung.ElementAt(cmbMucDich.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaNguonVon = cmbLoaiVay.SelectedItem.Value; // lstNguonVon.ElementAt(cmbLoaiVay.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaPhuongThucTinhLai = cmbPhuongThucTinhLai.SelectedItem.Value; // lstPhuongThucTinhLai.ElementAt(cmbPhuongThucTinhLai.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaLoaiLSuat = cmbLoaiLaiSuat.SelectedItem.Value; //lstLoaiLaiSuat.ElementAt(cmbLoaiLaiSuat.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaSanPham = txtMaSanPham.Text;
string TenSanPham = txtTenSanPham.Text;
string NgayADungTu = "";
if (teldtNgayADungTu.Text != "")
{
NgayADungTu = LDateTime.DateToString(LDateTime.StringToDate(teldtNgayADungTu.Text, "dd/MM/yyyy"), ApplicationConstant.defaultDateTimeFormat);
}
string NgayADungDen = "";
if (teldtNgayADungDen.Text != "")
{
NgayADungDen = LDateTime.DateToString(LDateTime.StringToDate(teldtNgayADungDen.Text, "dd/MM/yyyy"), ApplicationConstant.defaultDateTimeFormat);
}
string NgayHetHanTu = "";
if (teldtNgayHetHanTu.Text != "")
{
NgayHetHanTu = LDateTime.DateToString(LDateTime.StringToDate(teldtNgayHetHanTu.Text, "dd/MM/yyyy"), ApplicationConstant.defaultDateTimeFormat);
}
string NgayHetHanDen = "";
if (teldtNgayHetHanDen.Text != "")
{
NgayHetHanDen = LDateTime.DateToString(LDateTime.StringToDate(teldtNgayHetHanDen.Text, "dd/MM/yyyy"), ApplicationConstant.defaultDateTimeFormat);
}
string UserName = "";
string ListPThucVay = "";
foreach (TreeNode item in tvwLoaiVay.CheckedNodes)
{
ListPThucVay += ",''" + item.Value.ToString() + "''";
}
if (ListPThucVay.Length > 0)
{
ListPThucVay = "(" + ListPThucVay.Substring(1) + ")";
}
grdDangKySanPhamDS.DataSource = tindungProcess.getDanhSachSanPhamTinDung(MaTTNVu, MaLoaiSP, MaTinhTrangHLuc, MaMucDichVay, MaNguonVon, MaPhuongThucTinhLai, MaLoaiLSuat, MaSanPham, TenSanPham, NgayADungTu, NgayADungDen, NgayHetHanTu, NgayHetHanDen, ListPThucVay, UserName, maDonVi).Tables["DANH_SACH"];
grdDangKySanPhamDS.DataBind();
// grdDangKySanPhamDS.DataSource = _mdata;
// TotalRecords = _mdata.Rows.Count;
// ClonePageData(_mdata, pagenumber, pagesize);
// // .DefaultView;
//// //if (!LObject.IsNullOrEmpty(grdDangKySanPhamDS.SelectedItems))
// // grdDangKySanPhamDS.SelectedItems.Clear();
// grdDangKySanPhamDS.DataSource = _mpageData;
// pages1.TotalRecords = currentPage1.TotalRecords = TotalRecords;
// currentPage1.TotalPages = pages1.CalculateTotalPages();
// currentPage1.PageIndex = pages1.PageIndex;
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LayDuLieu()
{
Cursor = Cursors.Wait;
try
{
lstDanhSachSanpham.Clear();
if (LObject.IsNullOrEmpty(tvwKhuVuc.SelectedItem))
{
tvwKhuVuc.SelectedItem = tvwKhuVuc.Items[0];
}
string ListKVuc = "";
if (((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString().Substring(0, 3).Equals("CUM"))
{
ListKVuc = MaDiaBan;
}
if (ListKVuc.IsNullOrEmptyOrSpace())
{
ListKVuc = "0";
}
string MaSanPham = "0";
if (cmbSanPham.SelectedIndex > -1)
{
MaSanPham = lstSourceSanPham.ElementAt(cmbSanPham.SelectedIndex).KeywordStrings[1];
}
string LoaiSanPham = "";
if (cmbLoaiSanPham.SelectedIndex > -1)
{
LoaiSanPham = lstSourceLoaiSanPham.ElementAt(cmbLoaiSanPham.SelectedIndex).KeywordStrings.FirstOrDefault();
}
string maChiNhanh = "";
if (cmbChiNhanh.SelectedIndex > -1)
{
maChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
}
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@INP_CHIEU_DLIEU", "string", obj.CHIEU_DU_LIEU);
LDatatable.AddParameter(ref dt, "@INP_SAN_PHAM", "string", MaSanPham);
LDatatable.AddParameter(ref dt, "@INP_DBAN", "string", ListKVuc);
LDatatable.AddParameter(ref dt, "@INP_LOAI_SAN_PHAM", "string", LoaiSanPham);
LDatatable.AddParameter(ref dt, "@INP_MA_DVI", "string", maChiNhanh);
DataSet ds = new TinDungProcess().GetThongTinDiaBanSanPham(dt);
if (!LObject.IsNullOrEmpty(ds) && ds.Tables.Count > 0)
{
dt = ds.Tables["CHI_TIET"];
if (!LObject.IsNullOrEmpty(dt) && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM_DBAN_CTIET objSanPhamDiaBan = new SAN_PHAM_DBAN_CTIET();
objSanPhamDiaBan.ID = Convert.ToInt32(dr["ID"]);
objSanPhamDiaBan.ID_DBAN = Convert.ToInt32(dr["ID_DBAN"]);
objSanPhamDiaBan.ID_SAN_PHAM = Convert.ToInt32(dr["ID_DBAN"]);
objSanPhamDiaBan.LOAI_DBAN = dr["LOAI_DBAN"].ToString();
objSanPhamDiaBan.MA_DBAN = dr["MA_DBAN"].ToString();
objSanPhamDiaBan.MA_DVI_QLY = dr["MA_DVI_QLY"].ToString();
objSanPhamDiaBan.MA_DVI_TAO = dr["MA_DVI_TAO"].ToString();
objSanPhamDiaBan.MA_SAN_PHAM = dr["MA_SAN_PHAM"].ToString();
objSanPhamDiaBan.NGAY_ADUNG = dr["NGAY_ADUNG"].ToString();
objSanPhamDiaBan.NGAY_CNHAT = dr["NGAY_CNHAT"].ToString();
objSanPhamDiaBan.NGAY_HHAN = dr["NGAY_HHAN"].ToString();
objSanPhamDiaBan.NGAY_NHAP = dr["NGAY_NHAP"].ToString();
objSanPhamDiaBan.TEN_SAN_PHAM = dr["TEN_SAN_PHAM"].ToString();
objSanPhamDiaBan.TEN_DBAN = dr["TEN_DBAN"].ToString();
objSanPhamDiaBan.NGUOI_CNHAT = dr["NGUOI_CNHAT"].ToString();
objSanPhamDiaBan.NGUOI_NHAP = dr["NGUOI_NHAP"].ToString();
objSanPhamDiaBan.TTHAI_BGHI = dr["TTHAI_BGHI"].ToString();
objSanPhamDiaBan.TTHAI_NVU = dr["TTHAI_NVU"].ToString();
lstDanhSachSanpham.Add(objSanPhamDiaBan);
}
radDanhSachLichPhat.ItemsSource = lstDanhSachSanpham;
radDanhSachLichPhat.Rebind();
}
else
{
lstDanhSachSanpham.Clear();
radDanhSachLichPhat.ItemsSource = lstDanhSachSanpham;
radDanhSachLichPhat.Rebind();
}
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Cursor = Cursors.Arrow;
}
}
private void LoadDuLieu()
{
try
{
TinDungProcess tindungProcess = new TinDungProcess();
string sMaTrangThaiNVu = "";
if (cbChoduyet.Checked)
{
sMaTrangThaiNVu = sMaTrangThaiNVu + "''" + cbChoduyet.Value + "'',";
}
if (cbDaduyet.Checked)
{
sMaTrangThaiNVu = sMaTrangThaiNVu + "''" + cbDaduyet.Value + "'',";
}
if (cbThoaiduyet.Checked)
{
sMaTrangThaiNVu = sMaTrangThaiNVu + "''" + cbThoaiduyet.Value + "'',";
}
if (cbDaduyet.Checked)
{
sMaTrangThaiNVu = sMaTrangThaiNVu + "''" + cbDaduyet.Value + "'',";
}
if (sMaTrangThaiNVu != "")
{
sMaTrangThaiNVu = "(" + sMaTrangThaiNVu.Substring(0, sMaTrangThaiNVu.Length - 1) + ")";
}
string NgayNhanNoTu = "";
if (txtNgayNhanNoTu.Text != "")
{
NgayNhanNoTu = txtNgayNhanNoTu.Text != null?LDateTime.DateToString(DateTime.ParseExact(txtNgayNhanNoTu.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture), ApplicationConstant.defaultDateTimeFormat) : "";
}
string NgayNhanNoDen = "";
if (txtNgayNhanNoTu.Text != "")
{
NgayNhanNoDen = txtNgayNhanNoTu.Text != null?LDateTime.DateToString(DateTime.ParseExact(txtNgayNhanNoTu.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture), ApplicationConstant.defaultDateTimeFormat) : "";
}
string NgayDaoHanTu = "";
if (txtNgayNhanNoTu.Text != "")
{
NgayDaoHanTu = txtNgayNhanNoTu.Text != null?LDateTime.DateToString(DateTime.ParseExact(txtNgayNhanNoTu.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture), ApplicationConstant.defaultDateTimeFormat) : "";
}
string NgayDaoHanDen = "";
if (txtNgayNhanNoTu.Text != "")
{
NgayDaoHanDen = txtNgayNhanNoTu.Text != null?LDateTime.DateToString(DateTime.ParseExact(txtNgayNhanNoTu.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture), ApplicationConstant.defaultDateTimeFormat) : "";
}
string SoTienGNTu = txtSoTienGNTu.Text != null?txtSoTienGNTu.Text.ToString() : "";
string SoTienGNDen = txtSoTienGNTu.Text != null?txtSoTienGNTu.Text.ToString() : "";
string SoDuTu = txtSoTienGNTu.Text != null?txtSoTienGNTu.Text.ToString() : "";
string SoDuDen = txtSoTienGNTu.Text != null?txtSoTienGNTu.Text.ToString() : "";
string ThoiHanTu = "";
string ThoiHanDen = "";
string ThoiHanDViTu = "%";
string ThoiHanDViDen = "%";
string LaiSuatTu = "";
string LaiSuatDen = "";
string LoaiGiayTo = "%";
string MaSanPham = "%";
//if (cmbSanPham.SelectedIndex > -1) MaSanPham = lstSanPhamTinDung.ElementAt(cmbSanPham.SelectedIndex).KeywordStrings.First();
string SoGiayTo = "%";
//if (tvwKhuVuc.SelectedNode == null)
//tvwKhuVuc.SelectedNode = tvwKhuVuc.Nodes[0];
string ListKVuc = "CNH0001";
//if (((TreeNode)tvwKhuVuc.SelectedNode).Value.ToString().Substring(0, 3).Equals("DVI"))
//{
// TreeNode itemDVI = (TreeNode)tvwKhuVuc.SelectedNode;
// foreach (TreeNode item in itemDVI.ChildNodes)
// {
// if (item.Value.ToString().Substring(0, 3).Equals("CNH"))
// ListKVuc += ",''" + item.Value.ToString() + "''";
// }
// ListKVuc = ListKVuc.Substring(3);
// ListKVuc = ListKVuc.Substring(0, ListKVuc.Length - 2);
//}
//else
// ListKVuc = ((TreeNode)tvwKhuVuc.SelectedNode).Value.ToString();
// Phân trang
int StartRow = 1;
int EndRow = ClientInformation.SoLuongBanGhi;
DataSet ds = new TinDungProcess().getDanhSachKUOCVM(sMaTrangThaiNVu, txtSoDonVayVon.Text, txtSoKheUoc.Text, NgayNhanNoTu, NgayNhanNoDen, NgayDaoHanTu, NgayDaoHanDen, SoTienGNTu, SoTienGNDen, SoDuTu, SoDuDen, ThoiHanTu, ThoiHanDen, ThoiHanDViTu, ThoiHanDViDen, LaiSuatTu, LaiSuatDen, txtMaKH.Text, txtTenKH.Text, LoaiGiayTo, SoGiayTo, txtDienThoai.Text, txtEmail.Text, MaSanPham, ListKVuc, AppConfig.LoginedUser.UserName.ToString(), AppConfig.LoginedUser.MaDonViQuanLy.ToString(), StartRow.ToString(), "15");
grdDangKyKheUocDS.DataSource = ds.Tables[0];
grdDangKyKheUocDS.DataBind();
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LayDuLieu()
{
Cursor = Cursors.Wait;
try
{
string idKhuVuc = "0";
string _namTruoc = "";
_namDL = LDateTime.DateToString(raddtNamLichThuPhat.Value.GetValueOrDefault(), "yyyy");
if (chkDuLieuNamTruoc.IsChecked.GetValueOrDefault())
{
_namTruoc = LDateTime.DateToString(raddtNamLichThuPhat.Value.GetValueOrDefault().AddYears(-1), "yyyy");
}
if (tvwKhuVuc.SelectedItem == null)
{
tvwKhuVuc.SelectedItem = tvwKhuVuc.Items[0];
}
RadTreeViewItem item = tvwKhuVuc.SelectedItem as RadTreeViewItem;
if (item.Tag.ToString().Substring(0, 3) == "KVU")
{
idKhuVuc = item.Tag.ToString().Substring(3);
}
SetDataControl();
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@INP_ID_KVUC", "string", idKhuVuc);
LDatatable.AddParameter(ref dt, "@INP_NAM_DL", "string", _namDL);
LDatatable.AddParameter(ref dt, "@INP_NAM_TRUOC", "string", _namTruoc);
DataSet ds = new TinDungProcess().GetThongTinDatLichThuPhatVon(dt);
if (!LObject.IsNullOrEmpty(ds) && ds.Tables.Count > 0)
{
dt = ds.Tables["CHI_TIET"];
if (!LObject.IsNullOrEmpty(dt) && dt.Rows.Count > 0)
{
List <CUM_LICH> lstCumFull = new List <CUM_LICH>();
foreach (DataRow dr in dt.Rows)
{
CUM_LICH objCum = new CUM_LICH();
objCum.ID = Convert.ToInt32(dr["ID"]);
objCum.ID_CUM = Convert.ToInt32(dr["ID_CUM"]);
objCum.ID_KVUC = Convert.ToInt32(dr["ID_KVUC"]);
objCum.MA_CUM = dr["MA_CUM"].ToString();
objCum.TEN_CUM = dr["TEN_CUM"].ToString();
objCum.MA_LOAI_LICH = dr["MA_LOAI_LICH"].ToString();
objCum.NAM = dr["NAM"].ToString();
objCum.JAN = dr["JAN"].ToString();
objCum.FEB = dr["FEB"].ToString();
objCum.MAR = dr["MAR"].ToString();
objCum.APR = dr["APR"].ToString();
objCum.MAY = dr["MAY"].ToString();
objCum.JUN = dr["JUN"].ToString();
objCum.JUL = dr["JUL"].ToString();
objCum.AUG = dr["AUG"].ToString();
objCum.SEP = dr["SEP"].ToString();
objCum.OCT = dr["OCT"].ToString();
objCum.NOV = dr["NOV"].ToString();
objCum.DEC = dr["DEC"].ToString();
objCum.TTHAI_BGHI = dr["TTHAI_BGHI"].ToString();
objCum.TTHAI_NVU = dr["TTHAI_NVU"].ToString();
objCum.MA_DVI_QLY = dr["MA_DVI_QLY"].ToString();
objCum.MA_DVI_TAO = dr["MA_DVI_TAO"].ToString();
objCum.NGAY_NHAP = dr["NGAY_NHAP"].ToString();
objCum.NGUOI_NHAP = dr["NGUOI_NHAP"].ToString();
objCum.NGAY_CNHAT = dr["NGAY_CNHAT"].ToString();
objCum.NGUOI_CNHAT = dr["NGUOI_CNHAT"].ToString();
lstCumFull.Add(objCum);
}
lstPhatVon = lstCumFull.Where(f => f.MA_LOAI_LICH == "PHAT_VON").ToList();
lstThuVon = lstCumFull.Where(f => f.MA_LOAI_LICH == "THU_VON").ToList();
}
else
{
lstPhatVon = new List <CUM_LICH>();
lstThuVon = new List <CUM_LICH>();
}
radDanhSachLichPhat.ItemsSource = lstPhatVon;
radDanhSachLichThu.ItemsSource = lstThuVon;
radDanhSachLichPhat.Rebind();
radDanhSachLichThu.Rebind();
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Cursor = Cursors.Arrow;
}
}
void LoadDataPhanTrang()
{
Cursor = Cursors.Wait;
string TThaiNVu = ucTrangThaiNVu.GetItemsSelected();
string SoHDTD = txtSoHDTD.Text;
string NgayHopDongTu = teldtNgayLapHDTu.Value != null?LDateTime.DateToString((DateTime)teldtNgayLapHDTu.Value, ApplicationConstant.defaultDateTimeFormat) : "";
string NgayHopDongDen = teldtNgayLapHDDen.Value != null?LDateTime.DateToString((DateTime)teldtNgayLapHDDen.Value, ApplicationConstant.defaultDateTimeFormat) : "";
string LSuatQHanTu = txtLaiSuatQHTu.Value != null?txtLaiSuatQHTu.Value.ToString() : "";
string LSuatQHanDen = txtLaiSuatQHDen.Value != null?txtLaiSuatQHDen.Value.ToString() : "";
string LSuatCoCauTu = txtLaiSuatTu.Value != null?txtLaiSuatTu.Value.ToString() : "";
string LSuatCoCauDen = txtLaiSuatDen.Value != null?txtLaiSuatDen.Value.ToString() : "";
string MaKhachHang = txtMaKhachHang.Text;
string TenKhachHang = txtTenKhachHang.Text;
string LoaiGiayTo = lstLoaiGiayTo.ElementAt(cmbLoaiGiayTo.SelectedIndex).KeywordStrings.First();
string SoGiayTo = txtSoGiayTo.Text;
string DienThoai = txtDienThoai.Text;
string Email = txtEmail.Text;
if (tvwKhuVuc.SelectedItem == null)
{
tvwKhuVuc.SelectedItem = tvwKhuVuc.Items[0];
}
string ListKVuc = "";
if (((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString().Substring(0, 3).Equals("DVI"))
{
RadTreeViewItem itemDVI = (RadTreeViewItem)tvwKhuVuc.SelectedItem;
foreach (RadTreeViewItem item in itemDVI.Items)
{
if (item.Tag.ToString().Substring(0, 3).Equals("CNH"))
{
ListKVuc += ",''" + item.Tag.ToString() + "''";
}
}
ListKVuc = ListKVuc.Substring(3);
ListKVuc = ListKVuc.Substring(0, ListKVuc.Length - 2);
}
else
{
ListKVuc = ((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString();
}
DataSet ds = new TinDungProcess().getDanhSachHDTDVM(TThaiNVu, SoHDTD, NgayHopDongTu, NgayHopDongDen, LSuatQHanTu, LSuatQHanDen, LSuatCoCauTu, LSuatCoCauDen, MaKhachHang, TenKhachHang, LoaiGiayTo, SoGiayTo, DienThoai, Email, "", ListKVuc, ClientInformation.TenDangNhap, ClientInformation.MaDonViQuanLy, StartRow.ToString(), EndRow.ToString());
if (ds != null && ds.Tables.Count > 0)
{
DataTable serverDataTable = ds.Tables[0];
int totalRecord = Int32.Parse(ds.Tables[1].Rows[0][0].ToString());
DataTable clientDataTable = CommonFunction.BuildClientDataTable(serverDataTable, CurrentPagging, PaggingSize, totalRecord);
//raddgrHDTDDS.ItemsSource = ds.Tables["DANH_SACH"].DefaultView;
raddgrHDTDDS.ItemsSource = clientDataTable.DefaultView;
if (!LObject.IsNullOrEmpty(raddgrHDTDDS.SelectedItems))
{
raddgrHDTDDS.SelectedItems.Clear();
}
lblSumKhachHang.Content = totalRecord.ToString();
}
Cursor = Cursors.Arrow;
}
private void LoadDuLieu()
{
Cursor = Cursors.Wait;
try
{
TinDungProcess tindungProcess = new TinDungProcess();
maDonVi = lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(0);
string MaTTNVu = ucCheckBoxList.GetItemsSelected();
string MaLoaiSP = lstLoaiSanPham.ElementAt(cmbLoaiSanPham.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaTinhTrangHLuc = lstHieuLuc.ElementAt(cmbTinhTrang.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaMucDichVay = lstMucDichSuDung.ElementAt(cmbMucDich.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaNguonVon = lstNguonVon.ElementAt(cmbLoaiVay.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaPhuongThucTinhLai = lstPhuongThucTinhLai.ElementAt(cmbPhuongThucTinhLai.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaLoaiLSuat = lstLoaiLaiSuat.ElementAt(cmbLoaiLaiSuat.SelectedIndex).KeywordStrings.FirstOrDefault();
string MaSanPham = txtMaSanPham.Text;
string TenSanPham = txtTenSanPham.Text;
string NgayADungTu = "";
if (teldtNgayADungTu.Value != null)
{
NgayADungTu = LDateTime.DateToString((DateTime)teldtNgayADungTu.Value, ApplicationConstant.defaultDateTimeFormat);
}
string NgayADungDen = "";
if (teldtNgayADungDen.Value != null)
{
NgayADungDen = LDateTime.DateToString((DateTime)teldtNgayADungDen.Value, ApplicationConstant.defaultDateTimeFormat);
}
string NgayHetHanTu = "";
if (teldtNgayHetHanTu.Value != null)
{
NgayHetHanTu = LDateTime.DateToString((DateTime)teldtNgayHetHanTu.Value, ApplicationConstant.defaultDateTimeFormat);
}
string NgayHetHanDen = "";
if (teldtNgayHetHanDen.Value != null)
{
NgayHetHanDen = LDateTime.DateToString((DateTime)teldtNgayHetHanDen.Value, ApplicationConstant.defaultDateTimeFormat);
}
string ListPThucVay = "";
foreach (RadTreeViewItem item in tvwLoaiVay.CheckedItems)
{
ListPThucVay += ",''" + item.Tag.ToString() + "''";
}
if (ListPThucVay.Length > 0)
{
ListPThucVay = "(" + ListPThucVay.Substring(1) + ")";
}
string UserName = "";
DataSet ds = tindungProcess.getDanhSachSanPhamTinDung(MaTTNVu, MaLoaiSP, MaTinhTrangHLuc, MaMucDichVay, MaNguonVon, MaPhuongThucTinhLai, MaLoaiLSuat, MaSanPham, TenSanPham, NgayADungTu, NgayADungDen, NgayHetHanTu, NgayHetHanDen, ListPThucVay, UserName, maDonVi);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables["DANH_SACH"].Rows)
{
dr["TEN_TTHAI_NVU"] = BusinessConstant.layNgonNguNghiepVu(dr["TTHAI_NVU"].ToString());
}
grdDangKySanPhamDS.ItemsSource = ds.Tables["DANH_SACH"].DefaultView;
if (!LObject.IsNullOrEmpty(grdDangKySanPhamDS.SelectedItems))
{
grdDangKySanPhamDS.SelectedItems.Clear();
}
}
}
catch (Exception ex)
{
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Cursor = Cursors.Arrow;
}
}
