private void GetSoPhu()
{
try
{
if (!txtMaKhachHang.Text.IsNullOrEmptyOrSpace())
{
string loaiKyHan = string.Empty;
if (lstSourceLoaiSoPhu.ElementAt(cmbLoaiBaoCao.SelectedIndex).KeywordStrings.First().Equals(BusinessConstant.LOAI_SO_PHU.SO_PHU_TGUI_CO_KY_HAN.layGiaTri()))
{
loaiKyHan = "CO_KY_HAN";
}
else if (lstSourceLoaiSoPhu.ElementAt(cmbLoaiBaoCao.SelectedIndex).KeywordStrings.First().Equals(BusinessConstant.LOAI_SO_PHU.SO_PHU_TGUI_KHONG_KY_HAN.layGiaTri()))
{
loaiKyHan = "KHONG_KY_HAN";
}
DataSet ds = new BaoCaoProcess().GetSoPhuTienGui(idKhachHang, loaiKyHan);
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables["SO_PHU_TGUI"];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
private void HienDuLieuLenGrid()
{
try
{
string sLoai = "CBTD";
string sMaChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
string sMaPhongGD = "";
if (cmbPhongGD.Items.Count > 0)
{
sMaPhongGD = lstSourcePhongGD.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
}
else
{
return;
}
DataSet dsSource = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
dsSource = bcProcess.LayDuLieuBCSaoKeTKCKH(sMaChiNhanh, sMaPhongGD, sLoai);
if (dsSource != null && dsSource.Tables.Count > 0)
{
radgrdKVSP.ItemsSource = dsSource.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LoadDsDXVVCu()
{
try
{
machinhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
maphonggd = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
idKhuVuc = lstSourceKhuVuc.ElementAt(cmbKhuVuc.SelectedIndex).KeywordStrings[1];
idCum = lstSourceCum.ElementAt(cmbCum.SelectedIndex).KeywordStrings[1];
manhom = lstSourceNhom.ElementAt(cmbNhom.SelectedIndex).KeywordStrings[0];
macum = lstSourceCum.ElementAt(cmbCum.SelectedIndex).KeywordStrings[0];
makhuvuc = lstSourceKhuVuc.ElementAt(cmbKhuVuc.SelectedIndex).KeywordStrings[0];
DataSet dsDXVV = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
dsDXVV = bcProcess.GetDXVVCuTheoNhom(manhom);
if (dsDXVV != null && dsDXVV.Tables.Count > 0)
{
grdDXVV.DataContext = dsDXVV.Tables[0].DefaultView;
}
grdDXVV.SelectAll();
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void GetTaiKhoan()
{
string MaChiNhanh = string.Empty;
if (cmbChiNhanh.SelectedIndex >= 0 && !lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First().IsNullOrEmptyOrSpace())
{
MaChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
}
string maLoaiTien = string.Empty;
if (cmbLoaiTien.SelectedIndex >= 0 && !lstSourceLoaiTien.ElementAt(cmbLoaiTien.SelectedIndex).KeywordStrings.First().IsNullOrEmptyOrSpace())
{
maLoaiTien = lstSourceLoaiTien.ElementAt(cmbLoaiTien.SelectedIndex).KeywordStrings.First();
}
DataSet ds = new BaoCaoProcess().GetPLoaiTKTheoDonViTienTe(MaChiNhanh, maLoaiTien);
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables["DSACH"];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
private void GetTaiKhoan()
{
if (cmbPhongGD.SelectedIndex >= 0)
{
AutoCompleteEntry auPGD = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex);
AutoCompleteEntry auChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex);
string maDonVi = string.Empty;
if (!auPGD.KeywordStrings.First().Equals("%"))
{
maDonVi = auPGD.KeywordStrings.First();
}
else
{
maDonVi = auChiNhanh.KeywordStrings.First();
}
DataSet ds = new BaoCaoProcess().GetTaiKhoanTienGuiNganHang(maDonVi);
if (ds != null && ds.Tables.Count > 0)
{
grTaiKhoanTienGuiNH.ItemsSource = ds.Tables[0];
}
else
{
grTaiKhoanTienGuiNH.ItemsSource = null;
}
}
}
private void GetTaiKhoan()
{
string maDonVi = string.Empty;
if (cmbPhongGD.SelectedIndex >= 0 && !lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First().IsNullOrEmptyOrSpace())
{
maDonVi = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
}
else
{
maDonVi = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
}
MaChiNhanh = maDonVi;
string CapTaiKhoan = cmbCapBaoCao.SelectedValue.ToString();
DataSet ds = new BaoCaoProcess().GetPhanLoaiTheoDonVi(MaChiNhanh, CapTaiKhoan);
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables["PLOAI"];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
private void GetTaiKhoan()
{
if (!bLoad)
{
return;
}
string maDonVi = string.Empty;
if (cmbPhongGD.SelectedIndex >= 0 && !lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First().IsNullOrEmptyOrSpace())
{
maDonVi = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First();
}
else
{
maDonVi = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
}
string maDonViQLy = string.Empty;
maDonViQLy = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
string tuNgay = LDateTime.DateToString(raddtTuNgay.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat);
string denNgay = LDateTime.DateToString(raddtDenNgay.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat);
DataSet ds = new BaoCaoProcess().GetSoCTGSTheoDonViNgayBC(maDonViQLy, maDonVi, tuNgay, denNgay);
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables["CTU_GHI_SO"];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
private void GetTaiKhoan()
{
string maDonVi = string.Empty;
if (cmbPhongGD.SelectedIndex >= 0 && !lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First().IsNullOrEmptyOrSpace())
{
maDonVi = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First();
}
else
{
maDonVi = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
}
string maDonViQLy = string.Empty;
maDonViQLy = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
DataSet ds = new BaoCaoProcess().GetTaiKhoanTienMatTheoDonVi(maDonViQLy, maDonVi);
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables["TKHOAN_TIENMAT"];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
private void grKhachHang_SelectionChanged(object sender, Telerik.Windows.Controls.SelectionChangeEventArgs e)
{
BaoCaoProcess baocaoProcess = new BaoCaoProcess();
string maKhachHang = "";
string maSanPham = lstSourceSanPham.ElementAt(cmbSanPham.SelectedIndex).KeywordStrings.FirstOrDefault();
for (int i = 0; i < grKhachHang.SelectedItems.Count; i++)
{
DataRow dr = (DataRow)grKhachHang.SelectedItems[i];
maKhachHang = maKhachHang + ",'" + dr["MA_KHANG"].ToString() + "'";
}
if (!maKhachHang.IsNullOrEmptyOrSpace())
{
maKhachHang = maKhachHang.Substring(1, maKhachHang.Length - 1);
}
DataSet ds = baocaoProcess.GetKheUocKhachHang(maKhachHang, maSanPham);
if (!ds.IsNullOrEmpty() && ds.Tables.Count > 0)
{
grKheUoc.ItemsSource = ds.Tables[0];
}
else
{
grKheUoc.ItemsSource = null;
}
}
private void LoadDuLieu()
{
if (raddtTuNgay.Value == null || raddtDenNgay == null)
{
return;
}
Mouse.OverrideCursor = Cursors.Wait;
try
{
machinhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
maphonggd = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
tungay = Convert.ToDateTime(raddtTuNgay.Value).ToString(ApplicationConstant.defaultDateTimeFormat);
denngay = Convert.ToDateTime(raddtDenNgay.Value).ToString(ApplicationConstant.defaultDateTimeFormat);
BaoCaoProcess bcProcess = new BaoCaoProcess();
DataSet ds = new DataSet();
ds = bcProcess.LayChiTieuThuongCanBo(machinhanh, maphonggd, tungay, denngay);
if (ds != null && ds.Tables.Count > 0)
{
grid.DataContext = ds.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
private void LayThongTinTheoCum()
{
BaoCaoProcess baocaoProcess = new BaoCaoProcess();
List <string> lstDK = new List <string>();
string maCum = "";
if (cmbCum.SelectedIndex >= 0)
{
maCum = lstSourceCum_Select.ElementAt(cmbCum.SelectedIndex).KeywordStrings.ElementAt(0);
}
DataSet ds = baocaoProcess.GetThongTinTheoCum(maCum);
if (!ds.IsNullOrEmpty() && ds.Tables.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
if (dr["NGAY_GIAI_NGAN"] != null && !LString.IsNullOrEmptyOrSpace(dr["NGAY_GIAI_NGAN"].ToString()))
{
raddtNgayPhatVon.Value = LDateTime.StringToDate(dr["NGAY_GIAI_NGAN"].ToString(), "yyyyMMdd");
}
else
{
raddtNgayPhatVon.Value = LDateTime.StringToDate(ClientInformation.NgayLamViecHienTai, "yyyyMMdd");
}
}
else
{
raddtNgayPhatVon.Value = LDateTime.StringToDate(ClientInformation.NgayLamViecHienTai, "yyyyMMdd");
}
}
private void GetTaiKhoan()
{
string maChiNhanh = maChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
DataSet ds = new BaoCaoProcess().LayPhanLoaiTienGuiKhoBac(maChiNhanh);
if (ds != null && ds.Tables.Count > 0)
grSoTienGuiDS.ItemsSource = ds.Tables[0];
else
grSoTienGuiDS.ItemsSource = null;
}
public GDKT_TONG_HOP_DU_LIEU_KTOAN()
{
InitializeComponent();
LoadCombobox();
// Lấy thông tin báo cáo và tham số
BaoCaoProcess process = new BaoCaoProcess();
process.LayThongTinBaoCao(ID_REPORT, CODE_REPORT, ref htBaoCao, ref lstHtBaoCaoTso);
GetLastDate();
}
private void LoadNhanVien()
{
string magiaodich = txtMaGD.Text.Trim();
BaoCaoProcess bcProcess = new BaoCaoProcess();
DataSet dsNhanVien = new DataSet();
dsNhanVien = bcProcess.LayDanhSachNhanVienTinhLuong(magiaodich);
if (dsNhanVien != null && dsNhanVien.Tables.Count > 0)
{
grid.DataContext = dsNhanVien.Tables[0].DefaultView;
}
}
private void LoadDsNhanvien()
{
machinhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
maphonggd = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
BaoCaoProcess bcProcess = new BaoCaoProcess();
DataSet dsNhanVien = new DataSet();
dsNhanVien = bcProcess.LayDanhSachNhanVienInTongHopCPLuong(machinhanh, maphonggd);
if (dsNhanVien != null && dsNhanVien.Tables.Count > 0)
{
grid.DataContext = dsNhanVien.Tables[0].DefaultView;
}
}
private void GetTaiKhoan()
{
string maChiNhanh = maChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
DataSet ds = new BaoCaoProcess().GetTaiKhoanCongNoTheoDonVi(maChiNhanh, BusinessConstant.CoKhong.CO.layGiaTri(), BusinessConstant.TinhChatSoDu.NO.layGiaTri());
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables[0];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
private void cmbNhom_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
AutoCompleteEntry auNhom = lstSourceNhom_Select.ElementAt(cmbNhom.SelectedIndex);
DataSet ds = new BaoCaoProcess().GetKhachHangTheoNhom(auNhom.KeywordStrings[0].ToString());
if (ds != null && ds.Tables.Count > 0)
{
grDanhSachKH.ItemsSource = ds.Tables[0];
}
else
{
grDanhSachKH.ItemsSource = null;
}
}
private void LoadDuLieu()
{
AutoCompleteEntry auBieuMau = listBaoCao.ElementAt(cmbLoaiBieu.SelectedIndex);
AutoCompleteEntry auChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex);
AutoCompleteEntry auPGD = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex);
string NgayChotDuLieu = LDateTime.DateToString(raddtNgayChotSoLieu.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat);
string NgayDauThang = LDateTime.DateToString(raddtNgayChotSoLieu.Value.GetValueOrDefault().GetFirstDateOfMonth(), ApplicationConstant.defaultDateTimeFormat);
string NgayCuoiThang = LDateTime.DateToString(raddtNgayChotSoLieu.Value.GetValueOrDefault().GetLastDateOfMonth(), ApplicationConstant.defaultDateTimeFormat);
DataSet ds = new BaoCaoProcess().GetDuLieuNhapBCTK(auChiNhanh.KeywordStrings[0], auPGD.KeywordStrings[0], auBieuMau.KeywordStrings[0], NgayChotDuLieu, NgayDauThang, NgayCuoiThang);
if (!LObject.IsNullOrEmpty(ds) && !LObject.IsNullOrEmpty(ds.Tables["BCTK"]))
{
raddgrDuLieuBCao.ItemsSource = ds.Tables["BCTK"].DefaultView;
}
}
private void tlbSave_Click(object sender, RoutedEventArgs e)
{
ApplicationConstant.ResponseStatus responseStatus = ApplicationConstant.ResponseStatus.KHONG_THANH_CONG;
if (Vadition())
{
GetDataForm();
responseStatus = new BaoCaoProcess().NhapDuLieuDauVaoBCTK(ref lstBCTKDuLieu);
if (responseStatus.Equals(ApplicationConstant.ResponseStatus.KHONG_THANH_CONG))
{
LMessage.ShowMessage("M.DungChung.LuuDuLieuKhongThanhCong", LMessage.MessageBoxType.Error);
}
else
{
LMessage.ShowMessage("M.DungChung.LuuDuLieuThanhCong", LMessage.MessageBoxType.Information);
}
}
}
private void GetTaiKhoan()
{
string maChiNhanh = string.Empty;
maChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
DataSet ds = new BaoCaoProcess().GetPhanLoaiTKTheoDonVi(maChiNhanh);
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables[0];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
private void LoadDsDXVVMoi()
{
try
{
DataSet dsDXVV = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
dsDXVV = bcProcess.GetDXVVMoiTheoNhom(txtMaNhom.Text);
if (dsDXVV != null && dsDXVV.Tables.Count > 0)
{
grdDXVV.DataContext = dsDXVV.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LoadDuLieuKHang()
{
if (cmbNhom.SelectedIndex < 0)
{
return;
}
AutoCompleteEntry au = lstSourceNhom.ElementAt(cmbNhom.SelectedIndex);
DataSet ds = new BaoCaoProcess().GetKhachHangTheoNhom(au.KeywordStrings[0]);
if (!LObject.IsNullOrEmpty(ds) && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables[0].DefaultView;
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
private void LoadDSNhom()
{
try
{
DataSet dsNhom = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
string idCum = lstSourceCum.ElementAt(cmbCum.SelectedIndex).KeywordStrings[1];
dsNhom = bcProcess.LayDSNhom(idCum);
if (dsNhom != null && dsNhom.Tables.Count > 0)
{
grdKhachHang.DataContext = dsNhom.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LoadDSKhuVuc()
{
try
{
DataSet dsKhuVuc = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
maphonggd = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
dsKhuVuc = bcProcess.LayDSCum(maphonggd);
if (dsKhuVuc != null && dsKhuVuc.Tables.Count > 0)
{
grdKhuVuc.DataContext = dsKhuVuc.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LoadDSCum()
{
try
{
string machinhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
string maphonggd = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
string idKhuVuc = lstSourceKhuVuc.ElementAt(cmbKhuVuc.SelectedIndex).KeywordStrings[1];
DataSet dsCum = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
dsCum = bcProcess.LayDSCum(idKhuVuc, machinhanh, maphonggd);
if (dsCum != null && dsCum.Tables.Count > 0)
{
grdKhachHang.DataContext = dsCum.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LoadDsTaiKhoanCongNo()
{
try
{
DataSet dsTKhoan = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
MaChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
//MaPhongGiaoDich = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
MaPhongGiaoDich = lstSourcePhongGD.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First();
dsTKhoan = bcProcess.LayDsTaiKhoanCongNo(MaChiNhanh, MaPhongGiaoDich);
if (dsTKhoan != null && dsTKhoan.Tables.Count > 0)
{
grSoTienGuiDS.DataContext = dsTKhoan.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LayDanhSachKheUoc(int idKhachHang)
{
try
{
DataSet dsDonVayVon = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
dsDonVayVon = bcProcess.LayDSKUocTieuDungBIDV(idKhachHang);
if (dsDonVayVon == null)
{
return;
}
//raddgrThongTinKUoc.DataContext = dsDonVayVon.Tables[0].DefaultView;
raddgrThongTinKUoc.ItemsSource = dsDonVayVon.Tables[0].DefaultView;
raddgrThongTinKUoc.Rebind();
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void GetDoiTuongTaiKhoan()
{
if (!txtSoTaiKhoan.Text.IsNullOrEmptyOrSpace())
{
AutoCompleteEntry auPGD = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex);
DataSet ds = new BaoCaoProcess().GetDanhSachDoiTuongTaiKhoan(txtSoTaiKhoan.Text);
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables[0];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
else
{
LMessage.ShowMessage("Chưa chọn tài khoản.", LMessage.MessageBoxType.Warning);
}
}
private void HienThiDuLieuKhachHang()
{
BaoCaoProcess baocaoProcess = new BaoCaoProcess();
List <string> lstDK = new List <string>();
string maCum = "";
if (cmbCum.SelectedIndex >= 0)
{
maCum = lstSourceCum_Select.ElementAt(cmbCum.SelectedIndex).KeywordStrings.ElementAt(0);
}
DataSet ds = baocaoProcess.GetKhachHangTheoCum(maCum);
if (!ds.IsNullOrEmpty() && ds.Tables.Count > 0)
{
grKhachHang.ItemsSource = ds.Tables[0];
}
else
{
grKhachHang.ItemsSource = null;
}
}
private void LoadDsThanhVien()
{
try
{
MaChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
//maphonggd = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.FirstOrDefault();
//idKhuVuc = lstSourceKhuVuc.ElementAt(cmbKhuVuc.SelectedIndex).KeywordStrings[1];
MaCum = lstSourceCum_Select.ElementAt(cmbCum.SelectedIndex).KeywordStrings.First();
//manhom = lstSourceNhom.ElementAt(cmbNhom.SelectedIndex).KeywordStrings[0];
DataSet dsNhanVien = new DataSet();
BaoCaoProcess bcProcess = new BaoCaoProcess();
dsNhanVien = bcProcess.GetKhachHangTheoCum(MaCum);
if (dsNhanVien != null && dsNhanVien.Tables.Count > 0)
{
grdKhachHang.DataContext = dsNhanVien.Tables[0].DefaultView;
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
