/// <summary> /// Khởi tạo cấu trúc datasource /// </summary> private void KhoiTaoDataSource() { Presentation.Process.KhachHangProcess process = new Presentation.Process.KhachHangProcess(); DataSet ds = process.getThongTinKhac("VKH_KHANG_LQUAN"); if (ds != null && ds.Tables.Count > 0) { _dtSource = ds.Tables[0]; } }
/// <summary> /// Đưa các control của form về trạng thái mặc định /// </summary> private void SetFormThanhVienGD(int idKhachHang) { Presentation.Process.KhachHangProcess process = new Presentation.Process.KhachHangProcess(); try { DataSet dsSourceKHang = process.getThongTinKHTheoID(idKhachHang); if (dsSourceKHang != null && dsSourceKHang.Tables.Count > 0) { DataRow dr = dsSourceKHang.Tables["KH_KHANG_HSO"].Rows[0]; isUpdate = false; txtMaThanhVienGD.Text = dr["MA_KHANG"].ToString(); txtTenKhachHang.Text = dr["TEN_KHANG"].ToString(); raddtNgaySinh.Value = LDateTime.StringToDate(dr["DD_NGAY_SINH"].ToString(), "yyyyMMdd"); if (!LString.IsNullOrEmptyOrSpace(dr["DD_GIOI_TINH"].ToString())) { cmbGioiTinh.SelectedIndex = lstSourceGioiTinh.IndexOf(lstSourceGioiTinh.FirstOrDefault(f => f.KeywordStrings.First().Equals(dr["DD_GIOI_TINH"].ToString()))); } cmbMoiQuanHe.SelectedIndex = 0; cmbTTSucKhoe.SelectedIndex = 0; chkThongTinCoBanGDinh.IsChecked = false; chkNguoiThuaKe.IsChecked = false; chkNguoiDongTrachNhiem.IsChecked = false; txtSoGiayTo.Text = ""; raddtNgayCap.Value = null; cmbLoaiGiayTo.SelectedIndex = lstSourceLoaiGiayTo.IndexOf(lstSourceLoaiGiayTo.FirstOrDefault(f => f.KeywordStrings.First().Equals(BusinessConstant.LOAI_GIAY_TO.CHUNG_MINH_ND.layGiaTri()))); cmbNoiCap.SelectedIndex = -1; txtTenKhachHang.Focus(); } } catch (System.Exception ex) { if (ex.GetType() == typeof(CustomException)) { new frmThongBaoLoi(ex.Message, ex.InnerException).ShowDialog(); } else if (ex.InnerException.GetType() == typeof(CustomException)) { new frmThongBaoLoi(ex.InnerException.Message, ex.InnerException).ShowDialog(); } else { new frmThongBaoLoi("M.DungChung.LoiLoadDuLieu", ex).ShowDialog(); } LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } finally { process = null; } }
/// <summary> /// Load dữ liệu lên form /// </summary> private void LoadDuLieu() { try { Presentation.Process.KhachHangProcess process = new Presentation.Process.KhachHangProcess(); //DataSet ds = process.getTreeView(Presentation.Process.Common.ClientInformation.IdDonVi); // Nếu người dùng là NVDV, QTDV thì chỉ lấy thông tin đơn vị mình // Nếu người dùng là NVTW,... thì lấy thông tin toàn hệ thống // (Truongnx: popup chỉ lấy thông tin khách hàng thuộc đơn vị mình) int idDonVi = 0; idDonVi = ClientInformation.IdDonVi; //if (ClientInformation.LoaiNguoiSuDung.Equals(BusinessConstant.LoaiNguoiSuDung.CAP_NVDV.layGiaTri()) || // ClientInformation.LoaiNguoiSuDung.Equals(BusinessConstant.LoaiNguoiSuDung.CAP_QTDV.layGiaTri())) //{ // idDonVi = ClientInformation.IdDonVi; //} //else //{ // idDonVi = DatabaseConstant.ID_TOCHUC; //} DataSet ds = process.getTreeView(idDonVi); if (ds != null && ds.Tables.Count > 0) { dtSourceTree = ds.Tables[0]; if (dtSourceTree != null && dtSourceTree.Rows.Count > 0) { DataRow drFirst = dtSourceTree.Rows[0]; string cond = "convert(path,System.String) like '0#" + drFirst["idparent"].ToString() + @"/%'"; DataRow[] drRoot = dtSourceTree.Select(cond, "id"); foreach (DataRow dr in drRoot) { RadTreeViewItem item = new RadTreeViewItem(); item.Header = dr["ten"]; item.Tag = dr["path"]; tvwKhachHangDS.Items.Add(item); tvwKhachHangDS.SelectedItem = item; dtSourceTree.Rows.Remove(dr); BuildTreeCungCap(item); item.IsExpanded = true; } } } } catch (System.Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } }
//private void radpage_PageIndexChanged(object sender, PageIndexChangedEventArgs e) //{ // if (e.NewPageIndex < radpage.PageCount) // { // CurrentPagging = e.NewPageIndex + 1; // StartRow = (CurrentPagging - 1) * PaggingSize + 1; // EndRow = StartRow + PaggingSize; // //radpage = new RadDataPager(); // TimKiemPhanTrang(); // } //} /// <summary> /// Tìm kiếm phân trang /// </summary> private void TimKiemPhanTrang() { Mouse.OverrideCursor = Cursors.Wait; DataTable dt = null; LDatatable.MakeParameterTable(ref dt); // Lay du lieu treeview cho tim kiem string ma_don_vi = "-1"; string ma_khu_vuc = "-1"; string ma_cum = "-1"; string ma_nhom = "-1"; if (tvwKhachHangDS.SelectedItem != null) { RadTreeViewItem item = tvwKhachHangDS.SelectedItem as RadTreeViewItem; string level = item.Tag.ToString().Split('#')[0]; string[] path = item.Tag.ToString().Split('#')[1].Split('/'); string type = item.Tag.ToString().Split('#')[2]; if (type == "DVI") { ma_don_vi = path[path.Length - 1]; } else { ma_don_vi = path[0]; //ma_khu_vuc = path[1]; //ma_cum = path[1]; if (type == "KVUC") { ma_khu_vuc = path[1]; } if (type == "CUM") { if (path.Length > 2) { ma_cum = path[2]; } else { ma_cum = path[1]; } } if (type == "NHOM") { if (path.Length > 3) { ma_nhom = path[3]; } else { ma_nhom = path[2]; } } } } // Thong tin ngay gia nhap if (raddtTuNgayGiaNhap.Value != null) { LDatatable.AddParameter(ref dt, "@NgayGiaNhapTu", "STRING", Convert.ToDateTime(raddtTuNgayGiaNhap.Value).ToString("yyyyMMdd")); } else { LDatatable.AddParameter(ref dt, "@NgayGiaNhapTu", "STRING", ""); } if (raddtDenNgayGiaNhap.Value != null) { LDatatable.AddParameter(ref dt, "@NgayGiaNhapDen", "STRING", Convert.ToDateTime(raddtDenNgayGiaNhap.Value).ToString("yyyyMMdd")); } else { LDatatable.AddParameter(ref dt, "@NgayGiaNhapDen", "STRING", ""); } // Lay du lieu tu cac combobox AutoComboBox au = new AutoComboBox(); AutoCompleteEntry nganhKT = au.getEntryByDisplayName(lstSourceNganhKinhTe, ref cmbNganhKT); AutoCompleteEntry loaihinhToChuc = au.getEntryByDisplayName(lstSourceLoaiHinhToChuc, ref cmbLoaiHinhToChuc); AutoCompleteEntry loaiKhachHang = au.getEntryByDisplayName(lstSourceLoaiKhachHang, ref cmbLoaiKhachHang); if (nganhKT != null) { LDatatable.AddParameter(ref dt, "@NganhKT", "STRING", nganhKT.KeywordStrings[0]); } else { LDatatable.AddParameter(ref dt, "@NganhKT", "STRING", ""); } if (loaihinhToChuc != null) { LDatatable.AddParameter(ref dt, "@LoaiHinhToChuc", "STRING", loaihinhToChuc.KeywordStrings[0]); } else { LDatatable.AddParameter(ref dt, "@LoaiHinhToChuc", "STRING", ""); } if (loaiKhachHang != null) { LDatatable.AddParameter(ref dt, "@LoaiKhachHang", "STRING", loaiKhachHang.KeywordStrings[0]); } else { LDatatable.AddParameter(ref dt, "@LoaiKhachHang", "STRING", ""); } // Them du lieu vao tim kiem if (ucTrangThaiNVu.GetItemsSelected() == "NULL") { LDatatable.AddParameter(ref dt, "@TrangThaiNghiepVu", "STRING", ""); } else { LDatatable.AddParameter(ref dt, "@TrangThaiNghiepVu", "STRING", ucTrangThaiNVu.GetItemsSelected()); } LDatatable.AddParameter(ref dt, "@MaKhachHang", "STRING", txtMaKH.Text); LDatatable.AddParameter(ref dt, "@TenKhachHang", "STRING", txtTenKH.Text); LDatatable.AddParameter(ref dt, "@DkienMPA", "STRING", ""); if (cmbDanToc.SelectedIndex >= 0) { LDatatable.AddParameter(ref dt, "@DanToc", "STRING", lstSourceDanToc.ElementAt(cmbDanToc.SelectedIndex).KeywordStrings.First()); } else { LDatatable.AddParameter(ref dt, "@DanToc", "STRING", ""); } if (cmbGioiTinh.SelectedIndex >= 0) { LDatatable.AddParameter(ref dt, "@GioiTinh", "STRING", lstSourceGioiTinh.ElementAt(cmbGioiTinh.SelectedIndex).KeywordStrings.First()); } else { LDatatable.AddParameter(ref dt, "@GioiTinh", "STRING", ""); } if (cmbLHCongTac.SelectedIndex >= 0) { LDatatable.AddParameter(ref dt, "@NgheNghiep", "STRING", lstSourceLHinhCongTac.ElementAt(cmbLHCongTac.SelectedIndex).KeywordStrings.First()); } else { LDatatable.AddParameter(ref dt, "@NgheNghiep", "STRING", ""); } LDatatable.AddParameter(ref dt, "@TuoiTu", "STRING", Convert.ToInt32(numTuoiTu.Value).ToString()); LDatatable.AddParameter(ref dt, "@TuoiDen", "STRING", Convert.ToInt32(numTuoiDen.Value).ToString()); LDatatable.AddParameter(ref dt, "@NgayHienTai", "STRING", ClientInformation.NgayLamViecHienTai); LDatatable.AddParameter(ref dt, "@SoCMND", "STRING", txtCMND.Text); LDatatable.AddParameter(ref dt, "@SoDkyKDoanh", "STRING", txtSoDKKD.Text); LDatatable.AddParameter(ref dt, "@TenDangNhap", "STRING", ClientInformation.TenDangNhap); LDatatable.AddParameter(ref dt, "@DonViQLy", "STRING", ClientInformation.MaDonViQuanLy); LDatatable.AddParameter(ref dt, "@DonVi", "INT", ma_don_vi); LDatatable.AddParameter(ref dt, "@KhuVuc", "INT", ma_khu_vuc); LDatatable.AddParameter(ref dt, "@Cum", "INT", ma_cum); LDatatable.AddParameter(ref dt, "@Nhom", "INT", ma_nhom); LDatatable.AddParameter(ref dt, "@StartRow", "INT", StartRow.ToString()); LDatatable.AddParameter(ref dt, "@EndRow", "INT", EndRow.ToString()); // Tim kiem Presentation.Process.KhachHangProcess process = new Presentation.Process.KhachHangProcess(); DataSet ds = process.getKetQuaTimKiemNangCao(dt); 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); //grKhachHangDS.ItemsSource = ds.Tables[0].DefaultView; //lblSumKhachHang.Content = ds.Tables[0].Rows.Count.ToString(); lblSumKhachHang.Content = totalRecord; //radpage.Source = ds.Tables[0].DefaultView; //radpage = new RadDataPager(); //radpage.Source = clientDataTable.DefaultView; //radpage.PageSize = PaggingSize; //radpage.PageIndex = CurrentPagging - 1; //grKhachHangDS.ItemsSource = radpage.PagedSource; grKhachHangDS.ItemsSource = null; grKhachHangDS.ItemsSource = clientDataTable.DefaultView; if (!LObject.IsNullOrEmpty(grKhachHangDS.SelectedItem)) { grKhachHangDS.SelectedItems.Clear(); } } Mouse.OverrideCursor = Cursors.Arrow; }