/// <summary>
        /// Su kien luu thong tin chi tiet xuong grid
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tlbSaveThongTin_Click(object sender, RoutedEventArgs e)
        {
            if (Validation())
            {
                AutoComboBox au           = new AutoComboBox();
                string       loai_giay_to = au.getEntryByDisplayName(lstSourceLoaiGiayTo, ref cmbLoaiGiayTo).KeywordStrings[0];
                string       noi_cap      = au.getEntryByDisplayName(lstSourceNoiCap, ref cmbNoiCap).KeywordStrings[0];
                DateTime     ngay_cap     = Convert.ToDateTime(raddtNgayCap.Value);
                DateTime     ngay_het_han = Convert.ToDateTime(raddtNgayHetHan.Value);

                if (!isUpdate)
                {
                    _dtSource.Rows.Add(false, grGiayToLienQuanDS.Items.Count + 1, -1, -1, loai_giay_to, txtSoGiayTo.Text.Trim(), ngay_cap.ToString("yyyyMMdd"),
                                       ngay_het_han.ToString("yyyyMMdd"), noi_cap, cmbLoaiGiayTo.Text, ngay_cap.ToString("dd/MM/yyyy"), ngay_het_han.ToString("dd/MM/yyyy"),
                                       cmbNoiCap.Text);
                    idTuSinh = idTuSinh - 1;
                }
                else
                {
                    DataRowView dr = (DataRowView)grGiayToLienQuanDS.SelectedItem;
                    dr["GTLQ_LOAI"]           = loai_giay_to;
                    dr["GTLQ_SO"]             = txtSoGiayTo.Text.Trim();
                    dr["GTLQ_NGAY_CAP"]       = ngay_cap.ToString("yyyyMMdd");
                    dr["GTLQ_NGAY_HHAN"]      = ngay_het_han.ToString("yyyyMMdd");
                    dr["GTLQ_NOI_CAP"]        = noi_cap;
                    dr["GTLQ_LOAI_TEXT"]      = cmbLoaiGiayTo.Text;
                    dr["GTLQ_NGAY_CAP_TEXT"]  = ngay_cap.ToString("dd/MM/yyyy");
                    dr["GTLQ_NGAY_HHAN_TEXT"] = ngay_het_han.ToString("dd/MM/yyyy");
                    dr["GTLQ_NOI_CAP_TEXT"]   = cmbNoiCap.Text;
                }
                ResetForm();
            }
        }
Пример #2
0
        /// <summary>
        /// Kiem tra du lieu truoc khi luu xuong grid
        /// </summary>
        /// <returns></returns>
        private bool Validation()
        {
            AutoComboBox      au            = new AutoComboBox();
            AutoCompleteEntry auDinhKhoan   = au.getEntryByDisplayName(lstSourceDinhKhoan, ref cmbDinhKhoan);
            AutoCompleteEntry auLoaiChungTu = au.getEntryByDisplayName(lstSourceLoaiChungTu, ref cmbLoaiChungTu);

            if (LString.IsNullOrEmptyOrSpace(txtNhomDinhKhoan.Text))
            {
                LMessage.ShowMessage("Nhóm định khoản không được để trống", LMessage.MessageBoxType.Warning);
                txtNhomDinhKhoan.Focus();
                return(false);
            }
            else if (auDinhKhoan == null)
            {
                LMessage.ShowMessage("Định khoản không được để trống", LMessage.MessageBoxType.Warning);
                cmbDinhKhoan.Focus();
                return(false);
            }
            else if (LString.IsNullOrEmptyOrSpace(txtMaPhanLoai.Text))
            {
                LMessage.ShowMessage("Mã phân loại không được để trống", LMessage.MessageBoxType.Warning);
                cmbDinhKhoan.Focus();
                return(false);
            }
            else if (auLoaiChungTu == null)
            {
                LMessage.ShowMessage("Loại chứng từ không được để trống", LMessage.MessageBoxType.Warning);
                cmbLoaiChungTu.Focus();
                return(false);
            }
            return(true);
        }
Пример #3
0
        /// <summary>
        /// Su kien luu thong tin chi tiet xuong grid
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tlbSaveThongTin_Click(object sender, RoutedEventArgs e)
        {
            if (Validation())
            {
                if (this.grDinhKhoan.GroupDescriptors.Count > 0)
                {
                    this.grDinhKhoan.GroupDescriptors.RemoveAt(0);
                }

                AutoComboBox      au            = new AutoComboBox();
                AutoCompleteEntry auDinhKhoan   = au.getEntryByDisplayName(lstSourceDinhKhoan, ref cmbDinhKhoan);
                AutoCompleteEntry auLoaiChungTu = au.getEntryByDisplayName(lstSourceLoaiChungTu, ref cmbLoaiChungTu);

                DataRowView dr = null;
                if (!isUpdate)
                {
                    DataRow drAdd = _dtSource.NewRow();
                    _dtSource.Rows.Add(drAdd);
                    dr         = _dtSource.DefaultView[_dtSource.Rows.Count - 1];
                    dr["CHON"] = false;
                    dr["STT"]  = grDinhKhoan.Items.Count;
                    dr["ID"]   = -1;
                    idTuSinh   = idTuSinh - 1;
                }
                else
                {
                    dr = (DataRowView)grDinhKhoan.SelectedItem;
                }

                if (dr == null)
                {
                    DataRow drAdd = _dtSource.NewRow();
                    _dtSource.Rows.Add(drAdd);
                    dr         = _dtSource.DefaultView[_dtSource.Rows.Count - 1];
                    dr["CHON"] = false;
                    dr["STT"]  = grDinhKhoan.Items.Count;
                    dr["ID"]   = -1;
                    idTuSinh   = idTuSinh - 1;
                }

                dr["DINHKHOAN_MA"]  = auDinhKhoan.KeywordStrings[0];
                dr["DINHKHOAN_TEN"] = auDinhKhoan.DisplayName;
                dr["MA_PHAN_LOAI"]  = txtMaPhanLoai.Text;
                dr["TEN_PHAN_LOAI"] = lblTenPhanLoai.Content.ToString();
                dr["NHOM_DK"]       = txtNhomDinhKhoan.Text;
                dr["CHUNGTU_MA"]    = auLoaiChungTu.KeywordStrings[0];
                dr["CHUNGTU_TEN"]   = auLoaiChungTu.DisplayName;

                this.grDinhKhoan.GroupDescriptors.Add(new ColumnGroupDescriptor()
                {
                    Column        = this.grDinhKhoan.Columns["NHOM_DK"],
                    SortDirection = ListSortDirection.Ascending
                });
                ResetForm();
            }
        }
Пример #4
0
        private void TaoTreeView()
        {
            Presentation.Process.KeToanProcess process = new Presentation.Process.KeToanProcess();
            AutoComboBox au = new AutoComboBox();

            try
            {
                AutoCompleteEntry auDonVi = au.getEntryByDisplayName(lstSourceDonVi, ref cmbDonVi);
                if (auDonVi != null)
                {
                    trvPhanLoai.Items.Clear();
                    dtMaPhanLoai = process.getDanhSachMaPhanLoai(auDonVi.KeywordStrings[0], "(''" + BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri() + "'')", BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(), "%");
                    if (dtMaPhanLoai != null && dtMaPhanLoai.Tables.Count > 0)
                    {
                        dtMaPhanLoai.Relations.Add("Master2Detail", dtMaPhanLoai.Tables[0].Columns["ID"], dtMaPhanLoai.Tables[0].Columns["ID_PLOAI_CHA"]);
                        DataView dv = dtMaPhanLoai.Tables[0].DefaultView;
                        dv.RowFilter            = "ID_PLOAI_CHA IS NULL";
                        trvPhanLoai.ItemsSource = dv;
                    }
                }
            }
            catch (System.Exception ex)
            {
                LMessage.ShowMessage("M.DungChung.LoiLoadDuLieu", LMessage.MessageBoxType.Error);
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
            finally
            {
                au      = null;
                process = null;
            }
        }
Пример #5
0
        /// <summary>
        /// Kiem tra du lieu truoc khi luu
        /// </summary>
        /// <returns></returns>
        private bool Validation()
        {
            AutoComboBox      au      = new AutoComboBox();
            AutoCompleteEntry auVitri = au.getEntryByDisplayName(lstSourceViTri, ref cmbViTri);

            if (LString.IsNullOrEmptyOrSpace(txtHoTen.Text))
            {
                CommonFunction.ThongBaoTrong(lblHoTen.Content.ToString());
                txtHoTen.Focus();
                return(false);
            }
            else if (auVitri == null)
            {
                CommonFunction.ThongBaoTrong(lblViTri.Content.ToString());
                cmbViTri.Focus();
                return(false);
            }
            else if (LString.IsNullOrEmptyOrSpace(txtDienThoai.Text))
            {
                CommonFunction.ThongBaoTrong(lblSoDienThoai.Content.ToString());
                txtDienThoai.Focus();
                return(false);
            }
            return(true);
        }
        private void cmbNSD_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            AutoComboBox      au    = new AutoComboBox();
            AutoCompleteEntry auNSD = au.getEntryByDisplayName(lstSourceNguoiBanGiao, ref cmbNSD);

            maChucVu         = auNSD.KeywordStrings[1].SplitByDelimiter("#")[0];
            tenChucVu        = auNSD.KeywordStrings[1].SplitByDelimiter("#")[1];
            lbChucVu.Content = tenChucVu;
        }
        /// <summary>
        /// Kiem tra du lieu truoc khi luu
        /// </summary>
        /// <returns></returns>
        private bool Validation()
        {
            AutoComboBox      au           = new AutoComboBox();
            AutoCompleteEntry loai_giay_to = au.getEntryByDisplayName(lstSourceLoaiGiayTo, ref cmbLoaiGiayTo);
            AutoCompleteEntry noi_cap      = au.getEntryByDisplayName(lstSourceNoiCap, ref cmbNoiCap);

            if (loai_giay_to == null)
            {
                CommonFunction.ThongBaoTrong(lblLoaiGiayTo.Content.ToString());
                cmbLoaiGiayTo.Focus();
                return(false);
            }
            else if (LString.IsNullOrEmptyOrSpace(txtSoGiayTo.Text))
            {
                CommonFunction.ThongBaoTrong(lblSoGiayTo.Content.ToString());
                txtSoGiayTo.Focus();
                return(false);
            }
            else if (raddtNgayCap.Value == null)
            {
                CommonFunction.ThongBaoTrong(lblNgayCap.Content.ToString());
                raddtNgayCap.Focus();
                return(false);
            }
            else if (noi_cap == null)
            {
                CommonFunction.ThongBaoTrong(lblNoiCap.Content.ToString());
                cmbNoiCap.Focus();
                return(false);
            }
            else if (raddtNgayHetHan.Value == null)
            {
                CommonFunction.ThongBaoTrong(lblNgayHetHan.Content.ToString());
                raddtNgayHetHan.Focus();
                return(false);
            }
            else if (Convert.ToDateTime(raddtNgayHetHan.Value) < Convert.ToDateTime(raddtNgayCap.Value))
            {
                LMessage.ShowMessage("M.KhachHang.Popup.ucThongTinCoBanHoGD.LoiNgayHetHan", LMessage.MessageBoxType.Warning);
                raddtNgayHetHan.Focus();
                return(false);
            }
            return(true);
        }
Пример #8
0
        void LoadDulieu()
        {
            AutoComboBox au = new AutoComboBox();

            try
            {
                DataTable         dtBaoCao = null;
                AutoCompleteEntry auDonVi  = au.getEntryByDisplayName(lstSourceDonVi, ref cmbDonVi);
                LDatatable.MakeParameterTable(ref dtBaoCao);
                string maPhanLoai = "(";
                foreach (object item in trvPhanLoai.CheckedItems)
                {
                    DataRowView dr = item as DataRowView;
                    if (dr["MA_PLOAI"].ToString().Length != 1)
                    {
                        maPhanLoai += "''" + dr["MA_PLOAI"].ToString() + "'',";
                    }
                }

                if (trvPhanLoai.CheckedItems.Count > 0)
                {
                    maPhanLoai = maPhanLoai.Substring(0, maPhanLoai.Length - 1) + ")";
                }
                else
                {
                    maPhanLoai = "";
                }
                string ngayHluc = "";
                if (teldtNgayHieuLuc.Value.HasValue)
                {
                    ngayHluc = teldtNgayHieuLuc.Value.GetValueOrDefault().ToString(ApplicationConstant.defaultDateTimeFormat);
                }
                LDatatable.AddParameter(ref dtBaoCao, "@MaDViTao", "STRING", auDonVi.KeywordStrings.FirstOrDefault());
                LDatatable.AddParameter(ref dtBaoCao, "@MaDViQLy", "STRING", ClientInformation.MaDonViQuanLy);
                LDatatable.AddParameter(ref dtBaoCao, "@MaPhanLoai", "STRING", ClientInformation.MaDonViQuanLy);
                LDatatable.AddParameter(ref dtBaoCao, "@MaSo", "STRING", txtMaSo.Text);
                LDatatable.AddParameter(ref dtBaoCao, "@TenSo", "STRING", txtTenSo.Text);
                LDatatable.AddParameter(ref dtBaoCao, "@TinhChat", "STRING", cmbTinhChat.SelectedValue.ToString());
                LDatatable.AddParameter(ref dtBaoCao, "@NgayHLuc", "STRING", ngayHluc);

                DataSet   ds = new KeToanProcess().GetDSGhiSoKBao(dtBaoCao);
                DataTable dt = ds.Tables["DANH_SACH"];
                grdGhiSoTKhoan.ItemsSource = dt.DefaultView;
            }
            catch (Exception ex)
            {
            }
        }
Пример #9
0
        private void cmbTaiKhoanTK_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            AutoComboBox auto = new AutoComboBox();

            try
            {
                AutoCompleteEntry au = auto.getEntryByDisplayName(lstSourceTaiKhoanKhongKyHan, ref cmbTaiKhoanTK);
                if (au != null)
                {
                    string[] a = au.KeywordStrings[0].Split('#');
                    numSoDuTaiKhoanTK.Value = Convert.ToDouble(a[0]);
                    cmbTaiKhoanTK.Tag       = a[1];
                }
            }
            catch (System.Exception ex)
            {
                CommonFunction.ThongBaoLoi(ex);
                LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
            }
        }
        /// <summary>
        /// Kiem tra du lieu truoc khi luu
        /// </summary>
        /// <returns></returns>
        private bool Validation()
        {
            AutoComboBox au = new AutoComboBox();

            if (LString.IsNullOrEmptyOrSpace(txtMaKhachHang.Text))
            {
                CommonFunction.ThongBaoTrong(lblMaKhachHang.Content.ToString());
                txtMaKhachHang.Focus();
                return(false);
            }

            else if (au.getEntryByDisplayName(lstSourceMoiQuanHe, ref cmbMoiQuanHe) == null)
            {
                CommonFunction.ThongBaoTrong(lblMoiQuanHe.Content.ToString());
                cmbMoiQuanHe.Focus();
                return(false);
            }

            return(true);
        }
        /// <summary>
        /// Luu du lieu
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tlbSave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (Validation())
                {
                    AutoComboBox      au    = new AutoComboBox();
                    AutoCompleteEntry auNSD = au.getEntryByDisplayName(lstSourceNguoiBanGiao, ref cmbNSD);

                    if (DuLieuTraVe != null)
                    {
                        List <TS_BAN_GIAO_CT_GIAO_NHAN> list = new List <TS_BAN_GIAO_CT_GIAO_NHAN>();
                        TS_BAN_GIAO_CT_GIAO_NHAN        nbg  = new TS_BAN_GIAO_CT_GIAO_NHAN();
                        nbg.MA_HSO  = auNSD.KeywordStrings.First();
                        nbg.TEN_HSO = auNSD.DisplayName;
                        if (rbBenGiao.IsChecked == true)
                        {
                            nbg.DAI_DIEN = "Bên giao";
                        }
                        else if (rbBenNhan.IsChecked == true)
                        {
                            nbg.DAI_DIEN = "Bên nhận";
                        }
                        else if (rbKhac.IsChecked == true)
                        {
                            nbg.DAI_DIEN = txtDaiDienKhac.Text;
                        }
                        nbg.MA_CHUC_VU  = maChucVu;
                        nbg.TEN_CHUC_VU = tenChucVu;
                        list.Add(nbg);
                        DuLieuTraVe(list);
                    }
                    CustomControl.CommonFunction.CloseUserControl(this);
                }
            }
            catch (Exception ex)
            {
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
        }
Пример #12
0
 /// <summary>
 /// Su kien luu thong tin chi tiet xuong grid
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void tlbSaveThongTin_Click(object sender, RoutedEventArgs e)
 {
     if (Validation())
     {
         AutoComboBox      au      = new AutoComboBox();
         AutoCompleteEntry auViTri = au.getEntryByDisplayName(lstSourceViTri, ref cmbViTri);
         if (!isUpdate)
         {
             _dtSource.Rows.Add(false, grNguoiDaiDien.Items.Count + 1, idTuSinh + 1, -1, txtHoTen.Text.Trim(), auViTri.DisplayName, auViTri.KeywordStrings[0], txtDienThoai.Text);
             //idTuSinh = idTuSinh - 1;
         }
         else
         {
             DataRowView dr = (DataRowView)grNguoiDaiDien.SelectedItem;
             dr["DDIEN_HO_TEN"]     = txtHoTen.Text.Trim();
             dr["DDIEN_VI_TRI_TEN"] = auViTri.DisplayName;
             dr["DDIEN_VI_TRI"]     = auViTri.KeywordStrings[0];
             dr["DDIEN_DTHOAI"]     = txtDienThoai.Text.Trim();
         }
         ResetForm();
     }
 }
        /// <summary>
        /// Kiem tra du lieu truoc khi luu
        /// </summary>
        /// <returns></returns>
        private bool Validation()
        {
            AutoComboBox      au    = new AutoComboBox();
            AutoCompleteEntry auNSD = au.getEntryByDisplayName(lstSourceNguoiBanGiao, ref cmbNSD);

            if (auNSD == null)
            {
                CommonFunction.ThongBaoTrong("Chưa chọn người sử dụng");
                cmbNSD.Focus();
                return(false);
            }
            else if (rbBenGiao.IsChecked == false && rbBenNhan.IsChecked == false && rbKhac.IsChecked == false)
            {
                CommonFunction.ThongBaoTrong("Chưa chọn đại diện");
                return(false);
            }
            else if (rbKhac.IsChecked == true && txtDaiDienKhac.Text.IsNullOrEmptyOrSpace())
            {
                CommonFunction.ThongBaoTrong("Chưa nhập thông tin đại diện khác");
                return(false);
            }
            return(true);
        }
        /// <summary>
        /// Su kien luu thong tin chi tiet xuong grid
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tlbSaveThongTin_Click(object sender, RoutedEventArgs e)
        {
            if (Validation())
            {
                AutoComboBox au          = new AutoComboBox();
                string       moi_quan_he = au.getEntryByDisplayName(lstSourceMoiQuanHe, ref cmbMoiQuanHe).KeywordStrings[0];

                if (!isUpdate)
                {
                    _dtSource.Rows.Add(false, grKhachHang.Items.Count + 1, idTuSinh - 1, -1, txtMaKhachHang.Text.Trim(), moi_quan_he, lblTenKhachHang.Content,
                                       cmbMoiQuanHe.Text);
                    idTuSinh = idTuSinh - 1;
                }
                else
                {
                    DataRowView dr = (DataRowView)grKhachHang.SelectedItem;
                    dr["KHLQ_MA"]               = txtMaKhachHang.Text.Trim();
                    dr["KHLQ_TEN"]              = lblTenKhachHang.Content;
                    dr["KHLQ_MOI_QUAN_HE"]      = moi_quan_he;
                    dr["KHLQ_MOI_QUAN_HE_TEXT"] = cmbMoiQuanHe.Text;
                }
                ResetForm();
            }
        }
        /// <summary>
        /// Tìm kiếm nâng cao
        /// </summary>
        private void TimKiem()
        {
            AutoComboBox      au           = new AutoComboBox();
            AutoCompleteEntry auLyDo       = au.getEntryByDisplayName(lstSourceLyDoRa, ref cmbLyDoRaKhoiNhom);
            AutoCompleteEntry auLoaiGiayTo = au.getEntryByDisplayName(lstSourceLoaiGiayTo, ref cmbLoaiGiayTo);

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

            if (ucTrangThaiNVu.GetItemsSelected() == "NULL")
            {
                LDatatable.AddParameter(ref dt, "@TrangThaiNghiepVu", "STRING", "");
            }
            else
            {
                LDatatable.AddParameter(ref dt, "@TrangThaiNghiepVu", "STRING", ucTrangThaiNVu.GetItemsSelected());
            }

            LDatatable.AddParameter(ref dt, "@IdDonVi", "INT", ma_don_vi);
            LDatatable.AddParameter(ref dt, "@IdKhuVuc", "INT", ma_khu_vuc);
            LDatatable.AddParameter(ref dt, "@IdCum", "INT", ma_cum);
            LDatatable.AddParameter(ref dt, "@IdNhom", "INT", ma_nhom);
            LDatatable.AddParameter(ref dt, "@SoGD", "STRING", txtSoGD.Text);

            if (raddtTuNgayGD.Value != null)
            {
                LDatatable.AddParameter(ref dt, "@NgayGDTu", "STRING", txtMaKH.Text);
            }
            else
            {
                LDatatable.AddParameter(ref dt, "@NgayGDTu", "STRING", "");
            }

            if (raddtDenNgayGD.Value != null)
            {
                LDatatable.AddParameter(ref dt, "@NgayGDDen", "STRING", txtMaKH.Text);
            }
            else
            {
                LDatatable.AddParameter(ref dt, "@NgayGDDen", "STRING", "");
            }

            if (auLyDo != null)
            {
                LDatatable.AddParameter(ref dt, "@LyDo", "STRING", auLyDo.KeywordStrings[0]);
            }
            else
            {
                LDatatable.AddParameter(ref dt, "@LyDo", "STRING", "");
            }

            LDatatable.AddParameter(ref dt, "@MaKhang", "STRING", txtMaKH.Text);
            LDatatable.AddParameter(ref dt, "@TenKhang", "STRING", txtTenKH.Text);

            if (auLoaiGiayTo != null)
            {
                LDatatable.AddParameter(ref dt, "@LoaiGTO", "STRING", txtMaKH.Text);
            }
            else
            {
                LDatatable.AddParameter(ref dt, "@LoaiGTO", "STRING", "");
            }

            LDatatable.AddParameter(ref dt, "@SoGTO", "STRING", txtSoGiayTo.Text);
            LDatatable.AddParameter(ref dt, "@Email", "STRING", txtEmail.Text);
            LDatatable.AddParameter(ref dt, "@SoDThoai", "STRING", txtDienThoai.Text);
            LDatatable.AddParameter(ref dt, "@TenDangNhap", "STRING", ClientInformation.TenDangNhap);
            LDatatable.AddParameter(ref dt, "@DonViQLy", "STRING", ClientInformation.MaDonViQuanLy);

            // Tim kiem
            Presentation.Process.KhachHangProcess process = new Presentation.Process.KhachHangProcess();
            DataSet ds = process.getChuyenDiaBanDS(dt);

            if (ds != null && ds.Tables.Count > 0)
            {
                grKhachHangDS.ItemsSource = ds.Tables[0].DefaultView;
                if (!LObject.IsNullOrEmpty(grKhachHangDS.SelectedItems))
                {
                    grKhachHangDS.SelectedItems.Clear();
                }
                lblSumDonVi.Content = ds.Tables[0].Rows.Count.ToString();
            }
            Mouse.OverrideCursor = Cursors.Arrow;
        }
Пример #16
0
        private void GetDataOnForm(ref DANH_SACH_KHE_UOC_VONG_VAY obj)
        {
            List <Presentation.Process.TinDungServiceRef.DANH_SACH_SO> lstRutTien = new List <Presentation.Process.TinDungServiceRef.DANH_SACH_SO>();
            List <Presentation.Process.TinDungServiceRef.DANH_SACH_SO> lstNopTien = new List <Presentation.Process.TinDungServiceRef.DANH_SACH_SO>();

            if (_kheUoc.DSACH_SO_NOP_TIEN != null)
            {
                _kheUoc.DSACH_SO_NOP_TIEN = null;
            }

            if (_kheUoc.DSACH_SO_RUT_TIEN != null)
            {
                _kheUoc.DSACH_SO_RUT_TIEN = null;
            }

            if (chkNopBangTienMat.IsChecked == true)
            {
                _kheUoc.THUC_THU_TIEN_MAT = Convert.ToDecimal(numTienMat.Value);
            }

            if (chkTKTietKiemKhongKyHan.IsChecked == true)
            {
                _kheUoc.NOP_TIEN_TU_TKKKH = "CO";
                AutoComboBox      auto = new AutoComboBox();
                AutoCompleteEntry au   = auto.getEntryByDisplayName(lstSourceTaiKhoanKhongKyHan, ref cmbTaiKhoanTK);
                Presentation.Process.TinDungServiceRef.DANH_SACH_SO objRutTK = new Presentation.Process.TinDungServiceRef.DANH_SACH_SO();
                objRutTK.SO_SO          = au.DisplayName;
                objRutTK.SO_TAI_KHOAN   = cmbTaiKhoanTK.Tag.ToString();
                objRutTK.SO_DU          = Convert.ToDecimal(numSoDuTaiKhoanTK.Value);
                objRutTK.SO_TIEN_RUT_RA = Convert.ToDecimal(numSoTienRutTuTK.Value);
                lstRutTien.Add(objRutTK);
            }
            else
            {
                _kheUoc.NOP_TIEN_TU_TKKKH = "KHONG";
            }

            if (chkTKKhongKyHanTienThua.IsChecked == false)
            {
                _kheUoc.NOP_TIEN_VAO_TKKKH = "KHONG";
            }
            else
            {
                _kheUoc.NOP_TIEN_VAO_TKKKH = "CO";
                DataTable dt = ((DataView)grTKKhongKyHanTienThua.ItemsSource).Table;
                foreach (DataRow dr in dt.Rows)
                {
                    if (!dr["so_so_tg"].ToString().Equals(obj.SO_SO_TG))
                    {
                        Presentation.Process.TinDungServiceRef.DANH_SACH_SO objNopTK = new Presentation.Process.TinDungServiceRef.DANH_SACH_SO();
                        if (!dr["so_so_tg"].ToString().Equals(_kheUoc.SO_SO_TG))
                        {
                            objNopTK.SO_SO           = dr["so_so_tg"].ToString();
                            objNopTK.SO_TAI_KHOAN    = dr["so_tai_khoan"].ToString();
                            objNopTK.SO_DU           = Convert.ToDecimal(dr["so_tien"]);
                            objNopTK.SO_TIEN_NOP_VAO = Convert.ToDecimal(dr["so_tien_nop"]);
                            lstNopTien.Add(objNopTK);
                            obj.THUC_THU_NOP_VAO_TKKKH += Convert.ToDecimal(dr["so_tien_nop"]);
                        }
                    }
                    else
                    {
                        obj.THUC_THU_TKQD += Convert.ToDecimal(dr["so_tien_nop"]);
                    }
                }
            }

            //if (chkGhiTKNoiBo.IsChecked == false)
            //{
            _kheUoc.GHI_NHAN_VAO_TKNB = "KHONG";
            //}
            //else
            //{
            //    _kheUoc.GHI_NHAN_VAO_TKNB = "CO";
            //}

            if (chkTraTruocHan.IsChecked == false)
            {
                _kheUoc.TRA_GOC_LAI_TRUOC_HAN = "KHONG";
            }
            else
            {
                _kheUoc.TRA_GOC_LAI_TRUOC_HAN = "CO";
                _kheUoc.TONG_TIEN_TRA_TRUOC   = Convert.ToDecimal(numSoTienNop.Value);
            }

            if (lstNopTien != null && lstNopTien.Count > 0)
            {
                obj.DSACH_SO_NOP_TIEN = lstNopTien.ToArray();
            }

            if (lstRutTien != null && lstRutTien.Count > 0)
            {
                obj.DSACH_SO_RUT_TIEN = lstRutTien.ToArray();
            }

            _kheUoc.PHI_TRA_TRUOC = Convert.ToDecimal(numPhiTraTruoc.Value);

            PhanBoSoTienThuDuoc();
        }
Пример #17
0
        /// <summary>
        /// Tìm kiếm nâng cao
        /// </summary>
        private void TimKiem()
        {
            string maPhanLoai = "(";
            string tthaiNvu   = "";

            foreach (object item in trvPhanLoai.CheckedItems)
            {
                DataRowView dr = (DataRowView)item;
                maPhanLoai += dr["MA_PLOAI"] + ",";
            }

            if (trvPhanLoai.CheckedItems.Count > 0)
            {
                maPhanLoai = maPhanLoai.Substring(0, maPhanLoai.Length - 1) + ")";
            }
            else
            {
                maPhanLoai = "";
            }

            if (ucTrangThaiNVu.GetItemsSelected() != "NULL")
            {
                tthaiNvu = ucTrangThaiNVu.GetItemsSelected();
            }
            else
            {
                tthaiNvu = "";
            }

            KeToanProcess process = new KeToanProcess();
            AutoComboBox  au      = new AutoComboBox();

            Mouse.OverrideCursor = Cursors.Wait;
            try
            {
                AutoCompleteEntry auDonVi = au.getEntryByDisplayName(lstSourceDonVi, ref cmbDonVi);
                DataSet           ds      = process.getDanhSachMaPhanLoai(auDonVi.KeywordStrings[0], tthaiNvu, BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(), maPhanLoai);
                raddgrPhanLoaiTK.ItemsSource = null;
                if (ds != null && ds.Tables.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        dr["TRANG_THAI"] = BusinessConstant.layNgonNguNghiepVu(dr["TTHAI_NVU"].ToString());
                        dr["TCHAT_CNO"]  = BusinessConstant.layNgonNguTuGiaTri(dr["MA_TCHAT_CNO"].ToString(), "CO_KHONG");
                    }

                    raddgrPhanLoaiTK.ItemsSource = ds.Tables[0].DefaultView;
                    lblSum.Content = ds.Tables[0].Rows.Count.ToString("#");
                }
                else
                {
                    raddgrPhanLoaiTK.ItemsSource = null;
                    lblSum.Content = 0;
                }
            }
            catch (System.Exception ex)
            {
                LMessage.ShowMessage("M.DungChung.LoiLoadDuLieu", LMessage.MessageBoxType.Error);
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
            finally
            {
                process = null;
                au      = null;
            }
            Mouse.OverrideCursor = Cursors.Arrow;
        }
Пример #18
0
        /// <summary>
        /// Kiem tra du lieu truoc khi luu
        /// </summary>
        /// <returns></returns>
        private bool Validation()
        {
            AutoComboBox au = new AutoComboBox();

            if (LString.IsNullOrEmptyOrSpace(txtTenKhachHang.Text))
            {
                CommonFunction.ThongBaoTrong(lblHoTen.Content.ToString());
                txtTenKhachHang.Focus();
                return(false);
            }
            else if (raddtNgaySinh.Value == null)
            {
                CommonFunction.ThongBaoTrong(lblNgayThangNamSinh.Content.ToString());
                raddtNgaySinh.Focus();
                return(false);
            }
            else if (au.getEntryByDisplayName(lstSourceGioiTinh, ref cmbGioiTinh) == null)
            {
                CommonFunction.ThongBaoTrong(lblGioiTinh.Content.ToString());
                cmbGioiTinh.Focus();
                return(false);
            }
            else if (au.getEntryByDisplayName(lstSourceMoiQuanHe, ref cmbMoiQuanHe) == null)
            {
                CommonFunction.ThongBaoTrong(lblMoiQuanHe.Content.ToString());
                cmbMoiQuanHe.Focus();
                return(false);
            }
            else if (au.getEntryByDisplayName(lstSourceSucKhoe, ref cmbTTSucKhoe) == null)
            {
                CommonFunction.ThongBaoTrong(lblTTSucKhoe.Content.ToString());
                cmbTTSucKhoe.Focus();
                return(false);
            }
            else if (Convert.ToDateTime(raddtNgaySinh.Value) > LDateTime.GetCurrentDate())
            {
                LMessage.ShowMessage("M.KhachHang.Popup.ucThongTinCoBanHoGD.LoiNgaySinh", LMessage.MessageBoxType.Warning);
                raddtNgaySinh.Focus();
                return(false);
            }

            if (chkNguoiThuaKe.IsChecked == true || chkNguoiDongTrachNhiem.IsChecked == true)
            {
                AutoCompleteEntry loai_giay_to = au.getEntryByDisplayName(lstSourceLoaiGiayTo, ref cmbLoaiGiayTo);
                AutoCompleteEntry noi_cap      = au.getEntryByDisplayName(lstSourceNoiCap, ref cmbNoiCap);
                //if (loai_giay_to == null)
                //{
                //    CommonFunction.ThongBaoTrong(lblLoaiGiayTo.Content.ToString());
                //    cmbLoaiGiayTo.Focus();
                //    return false;
                //}
                //else if (LString.IsNullOrEmptyOrSpace(txtSoGiayTo.Text))
                //{
                //    CommonFunction.ThongBaoTrong(lblSoGiayTo.Content.ToString());
                //    txtSoGiayTo.Focus();
                //    return false;
                //}
                //else if (raddtNgayCap.Value == null)
                //{
                //    CommonFunction.ThongBaoTrong(lblNgayCap.Content.ToString());
                //    raddtNgayCap.Focus();
                //    return false;
                //}
                //else if (noi_cap == null)
                //{
                //    CommonFunction.ThongBaoTrong(lblNoiCap.Content.ToString());
                //    cmbNoiCap.Focus();
                //    return false;
                //}
            }
            return(true);
        }
Пример #19
0
        /// <summary>
        /// Su kien luu thong tin chi tiet xuong grid
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tlbSaveThongTin_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (Validation())
                {
                    AutoComboBox au          = new AutoComboBox();
                    string       gioi_tinh   = au.getEntryByDisplayName(lstSourceGioiTinh, ref cmbGioiTinh).KeywordStrings[0];
                    string       suc_khoe    = au.getEntryByDisplayName(lstSourceSucKhoe, ref cmbTTSucKhoe).KeywordStrings[0];
                    string       moi_quan_he = au.getEntryByDisplayName(lstSourceMoiQuanHe, ref cmbMoiQuanHe).KeywordStrings[0];

                    DateTime    ngay_sinh = Convert.ToDateTime(raddtNgaySinh.Value);
                    int         tuoi      = LDateTime.CountYearBetweenDates(LDateTime.GetCurrentDate(), Convert.ToDateTime(raddtNgaySinh.Value));
                    DataRowView dr        = null;
                    if (!isUpdate)
                    {
                        DataRow drAdd = _dtSource.NewRow();
                        _dtSource.Rows.Add(drAdd);
                        dr             = _dtSource.DefaultView[_dtSource.Rows.Count - 1];
                        dr["CHON"]     = false;
                        dr["STT"]      = grThanhVienTrongGD.Items.Count;
                        dr["ID_KHANG"] = -1;
                        idTuSinh       = idTuSinh - 1;
                    }
                    else
                    {
                        dr = (DataRowView)grThanhVienTrongGD.SelectedItem;
                    }

                    if (dr == null)
                    {
                        DataRow drAdd = _dtSource.NewRow();
                        _dtSource.Rows.Add(drAdd);
                        dr             = _dtSource.DefaultView[_dtSource.Rows.Count - 1];
                        dr["CHON"]     = false;
                        dr["STT"]      = grThanhVienTrongGD.Items.Count;
                        dr["ID_KHANG"] = -1;
                        idTuSinh       = idTuSinh - 1;
                    }

                    dr["GD_HO_TEN"]            = txtTenKhachHang.Text.Trim();
                    dr["GD_NGAY_SINH"]         = ngay_sinh.ToString("yyyyMMdd");
                    dr["GD_NGAY_SINH_TEXT"]    = ngay_sinh.ToString(@"dd/MM/yyyy");
                    dr["GD_TUOI"]              = tuoi;
                    dr["GD_GIOI_TINH"]         = gioi_tinh;
                    dr["GD_GIOI_TINH_TEXT"]    = cmbGioiTinh.Text;
                    dr["GD_MOI_QUAN_HE"]       = moi_quan_he;
                    dr["GD_MOI_QUAN_HE_TEXT"]  = cmbMoiQuanHe.Text;
                    dr["GD_TTRANG_SKHOE"]      = suc_khoe;
                    dr["GD_TTRANG_SKHOE_TEXT"] = cmbTTSucKhoe.Text;
                    dr["GD_NGHE_NGHIEP"]       = chkCoViecLam.IsChecked;
                    dr["GD_NGUOI_TKE"]         = chkNguoiThuaKe.IsChecked;
                    dr["GD_NGUOI_DONG_TNHIEM"] = chkNguoiDongTrachNhiem.IsChecked;
                    if (!LString.IsNullOrEmptyOrSpace(txtMaThanhVienGD.Text))
                    {
                        dr["GD_MA_DONG_TNHIEM"] = txtMaThanhVienGD.Text;
                    }
                    else
                    {
                        dr["GD_MA_DONG_TNHIEM"] = "DTN" + DateTime.Now.ToString("yyyyMMddHHmmss");
                    }

                    if (chkNguoiThuaKe.IsChecked == true || chkNguoiDongTrachNhiem.IsChecked == true)
                    {
                        AutoCompleteEntry auLoaiGiayTo = au.getEntryByDisplayName(lstSourceLoaiGiayTo, ref cmbLoaiGiayTo);
                        AutoCompleteEntry auNoiCap     = au.getEntryByDisplayName(lstSourceNoiCap, ref cmbNoiCap);

                        dr["GD_GTLQ_SO"] = txtSoGiayTo.Text;
                        if (!LObject.IsNullOrEmpty(auNoiCap))
                        {
                            dr["GD_GTLQ_NOI_CAP"] = auNoiCap.KeywordStrings[0];
                        }
                        dr["GD_GTLQ_NOI_CAP_TEXT"] = cmbNoiCap.Text;
                        if (!LObject.IsNullOrEmpty(auLoaiGiayTo))
                        {
                            dr["GD_GTLQ_LOAI"] = auLoaiGiayTo.KeywordStrings[0];
                        }
                        dr["GD_GTLQ_LOAI_TEXT"] = cmbLoaiGiayTo.Text;
                        if (!LObject.IsNullOrEmpty(raddtNgayCap.Value))
                        {
                            DateTime ngay_cap = Convert.ToDateTime(raddtNgayCap.Value);
                            dr["GD_GTLQ_NGAY_CAP"]      = ngay_cap.ToString("yyyyMMdd");
                            dr["GD_GTLQ_NGAY_CAP_TEXT"] = ngay_cap.ToString("dd/MM/yyyy");
                        }
                    }

                    ResetForm();
                }
            }
            catch (Exception ex)
            {
                LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
                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;
        }
        /// <summary>
        /// Tìm kiếm nâng cao
        /// </summary>
        private void TimKiem()
        {
            Mouse.OverrideCursor = Cursors.Wait;

            KeToanProcess process = new KeToanProcess();
            AutoComboBox  au      = new AutoComboBox();

            try
            {
                if (cmbDonVi.SelectedIndex < 0)
                {
                    return;
                }

                AutoCompleteEntry auDonVi = au.getEntryByDisplayName(lstSourceDonVi, ref cmbDonVi);

                string maDonVi    = "(";
                string ngayDL     = "";
                string maPhanLoai = "(";
                string tinhChatTK = "";


                string maChon = lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(0);
                string donVi  = "";
                foreach (AutoCompleteEntry item in lstSourceDonVi)
                {
                    donVi = item.KeywordStrings.ElementAt(0);
                    if (donVi.Contains(maChon))
                    {
                        maDonVi += "''" + donVi + "'',";
                    }
                }
                maDonVi = maDonVi.Substring(0, maDonVi.Length - 1) + ")";


                foreach (object item in trvPhanLoai.CheckedItems)
                {
                    DataRowView dr = item as DataRowView;
                    if (dr["MA_PLOAI"].ToString().Length != 1)
                    {
                        maPhanLoai += "''" + dr["MA_PLOAI"].ToString() + "'',";
                    }
                }

                if (trvPhanLoai.CheckedItems.Count > 0)
                {
                    maPhanLoai = maPhanLoai.Substring(0, maPhanLoai.Length - 1) + ")";
                }
                else
                {
                    maPhanLoai = "";
                }

                if (raddtSoDuNgay.Value != null)
                {
                    ngayDL = Convert.ToDateTime(raddtSoDuNgay.Value).ToString("yyyyMMdd");
                }

                DataTable dtThamSo = null;
                LDatatable.MakeParameterTable(ref dtThamSo);
                LDatatable.AddParameter(ref dtThamSo, "@MaDonVi", "STRING", maDonVi);
                LDatatable.AddParameter(ref dtThamSo, "@MaPhanLoai", "STRING", maPhanLoai);
                LDatatable.AddParameter(ref dtThamSo, "@MaTK", "STRING", txtMaPhanLoaiTK.Text);
                LDatatable.AddParameter(ref dtThamSo, "@TenTK", "STRING", "");
                LDatatable.AddParameter(ref dtThamSo, "@NgayDL", "STRING", ngayDL);
                LDatatable.AddParameter(ref dtThamSo, "@SoDuTu", "DECIMAL", "0");
                LDatatable.AddParameter(ref dtThamSo, "@SoDuDen", "DECIMAL", "0");
                LDatatable.AddParameter(ref dtThamSo, "@TinhChat", "STRING", tinhChatTK);

                DataSet ds = process.getDanhSachTaiKhoanChiTiet(dtThamSo, "DANH_SACH");
                raddgrDanhSachTK.ItemsSource = null;
                if (ds != null && ds.Tables.Count > 0)
                {
                    raddgrDanhSachTK.ItemsSource = ds.Tables[0].DefaultView;
                    lblSumSoTK.Content           = ds.Tables[0].Rows.Count.ToString("###,###,###");

                    decimal tongSoDu = 0;
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        tongSoDu += Convert.ToDecimal(dr["SODU"]);
                    }
                    lblSumSoDu.Content = tongSoDu.ToString("###,###,###,###,###,###");
                }
            }
            catch (System.Exception ex)
            {
                LMessage.ShowMessage("M.DungChung.LoiLoadDuLieu", LMessage.MessageBoxType.Error);
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
            finally
            {
                process = null;
                au      = null;
            }

            Mouse.OverrideCursor = Cursors.Arrow;
        }