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