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