/// <summary> /// Load dữ liệu lên form /// </summary> private void LoadDuLieu() { try { Presentation.Process.HuyDongVonProcess process = new Presentation.Process.HuyDongVonProcess(); //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]; } } } } 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.HuyDongVonProcess process = new Presentation.Process.HuyDongVonProcess(); 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); lblSumKhachHang.Content = totalRecord; grKhachHangDS.ItemsSource = null; grKhachHangDS.ItemsSource = clientDataTable.DefaultView; if (!LObject.IsNullOrEmpty(grKhachHangDS.SelectedItem)) { grKhachHangDS.SelectedItems.Clear(); } } Mouse.OverrideCursor = Cursors.Arrow; }