private void txtMaKhachHang_LostFocus(object sender, RoutedEventArgs e)
{
try
{
if (!txtMaKhachHang.Text.IsNullOrEmptyOrSpace())
{
KhachHangProcess processKH = new KhachHangProcess();
DataTable dt = processKH.getThongTinCoBanKHTheoMa(0, txtMaKhachHang.Text, Convert.ToInt32(ClientInformation.IdDonVi)).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
//lblDCSH_ID.Content = dr["ID"].ToString();
AfterGetKhachHang(dr);
}
}
else
{
ResetThongTinKhachHang();
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
private void ChonKhachHang()
{
List <string> lstDieuKien = new List <string>();
KhachHangProcess khProcess = new KhachHangProcess();
MaChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
//lstDieuKien.Add(ClientInformation.MaDonViGiaoDich);
lstDieuKien.Add(MaChiNhanh);
lstDieuKien.Add("NULL");
lstDieuKien.Add("NULL");
lstPopup = new List <DataRow>();
PopupProcess popupProcess = new PopupProcess();
popupProcess.getPopupInformation("POPUP_DS_KHACHHANG_BAOCAO", lstDieuKien);
SimplePopupResponse simplePopupResponse = ClientInformation.SimplePopup;
ucPopup popup = new ucPopup(true, simplePopupResponse, false);
popup.DuLieuTraVe = new ucPopup.LayDuLieu(LayDuLieuTuPopup);
Window win = new Window();
win.Content = popup;
win.WindowStartupLocation = WindowStartupLocation.CenterScreen;
win.ShowDialog();
if (lstPopup.Count > 0)
{
DataRow row = (DataRow)lstPopup.First();
txtMaKH.Text = row["MA_KHANG"].ToString();
lblTenKH.Content = row["TEN_KHANG"].ToString();
IdKhachHang = row["ID"].ToString();
}
}
private void GetValuesOnForm()
{
try
{
KhachHangProcess khProcess = new KhachHangProcess();
dsKhachHang = khProcess.getThongTinKHTheoID(_idKhachHang);
DataTable dtKhangHSo = null;
if (dsKhachHang != null && dsKhachHang.Tables.Count > 0)
{
dtKhangHSo = dsKhachHang.Tables[0];
tenkhachhang = dtKhangHSo.Rows[0]["ten_khang"].ToString();
diachi = dtKhangHSo.Rows[0]["dia_chi"].ToString();
gioitinh = dtKhangHSo.Rows[0]["DD_GIOI_TINH"].ToString();
ngaysinh = dtKhangHSo.Rows[0]["DD_NGAY_SINH"].ToString();
socmnd = dtKhangHSo.Rows[0]["DD_GTLQ_SO"].ToString();
ngaycap = dtKhangHSo.Rows[0]["DD_GTLQ_NGAY_CAP"].ToString();
noicap = dtKhangHSo.Rows[0]["DD_GTLQ_NOI_CAP"].ToString();
sosohokhau = dtKhangHSo.Rows[0]["SO_HO_KHAU"].ToString();
}
makhachhang = txtMaKhachHang.Text.Trim();
idkhachhang = _idKhachHang.ToString();
DataRowView dr = (DataRowView)raddgrThongTinDon.SelectedItem;
SoHDTD = dr["SO_HDTD"].ToString();
SoKUOC = dr["SO_KUOC"].ToString();
ngaybaocao = ClientInformation.NgayLamViecHienTai;
mangonngu = lstSourceNgonNgu.ElementAt(cmbNgonNgu.SelectedIndex).KeywordStrings.FirstOrDefault();
madinhdang = lstSourceDinhDang.ElementAt(cmbDinhDang.SelectedIndex).KeywordStrings.FirstOrDefault();
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void ThoaiDuyet()
{
try
{
KhachHangProcess process = new KhachHangProcess();
int[] arrayID = new int[0];
Mouse.OverrideCursor = Cursors.Wait;
try
{
foreach (DataRowView dr in grKhachHangDS.SelectedItems)
{
Array.Resize(ref arrayID, arrayID.Length + 1);
arrayID[arrayID.Length - 1] = Convert.ToInt32(dr["ID"]);
}
List <ClientResponseDetail> lstResponseDetail = new List <ClientResponseDetail>();
int ret = process.ThoaiDuyet(arrayID, ref lstResponseDetail);
CommonFunction.ThongBaoKetQua(lstResponseDetail);
TimKiem();
}
catch (System.Exception ex)
{
this.Cursor = Cursors.Arrow;
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
Mouse.OverrideCursor = Cursors.Arrow;
}
catch (System.Exception ex)
{
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
private void HienDanhMucKhachHang()
{
try
{
List <string> lstDieuKien = new List <string>();
KhachHangProcess khProcess = new KhachHangProcess();
machinhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
//lstDieuKien.Add(ClientInformation.MaDonViGiaoDich);
lstDieuKien.Add(machinhanh);
lstDieuKien.Add("NULL");
lstDieuKien.Add("NULL");
lstPopup = new List <DataRow>();
PopupProcess popupProcess = new PopupProcess();
popupProcess.getPopupInformation("POPUP_DS_KHACHHANG_BAOCAO", lstDieuKien);
SimplePopupResponse simplePopupResponse = ClientInformation.SimplePopup;
ucPopup popup = new ucPopup(true, simplePopupResponse, false);
popup.DuLieuTraVe = new ucPopup.LayDuLieu(LayDuLieuTuPopup);
Window win = new Window();
win.Content = popup;
win.Title = LLanguage.SearchResourceByKey(simplePopupResponse.PopupTitle);
win.WindowStartupLocation = WindowStartupLocation.CenterScreen;
win.ShowDialog();
if (lstPopup.Count > 0)
{
DataTable dt = new DataTable();
dt = lstPopup.CopyToDataTable();
if (!LObject.IsNullOrEmpty(dt) && dt.Rows.Count > 0)
{
if (dt.Columns.Contains("STT"))
{
dt.Columns.Remove("STT");
}
if (LObject.IsNullOrEmpty(dtKhachHang))
{
dtKhachHang = new DataTable();
}
else
{
dt.Merge(dtKhachHang);
}
var result = dt.AsEnumerable().Select(x => x).Distinct(System.Data.DataRowComparer.Default).ToList();
dtKhachHang = result.CopyToDataTable();
grKhachHang.ItemsSource = null;
grKhachHang.ItemsSource = dtKhachHang;
}
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
private void ThoaiDuyet()
{
if (LMessage.ShowMessage("M.DungChung.HoiThoaiDuyet", LMessage.MessageBoxType.Question) == MessageBoxResult.Yes)
{
try
{
KhachHangProcess process = new KhachHangProcess();
int[] arrayID = new int[0];
Mouse.OverrideCursor = Cursors.Wait;
try
{
for (int i = 0; i < grKhachHangDS.Items.Count; i++)
{
DataRowView dr = (DataRowView)grKhachHangDS.Items[i];
if (Convert.ToBoolean(dr["CHON"]) == true)
{
Array.Resize(ref arrayID, arrayID.Length + 1);
arrayID[arrayID.Length - 1] = Convert.ToInt32(dr["ID"]);
}
}
if (arrayID.Length > 0)
{
List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>();
ApplicationConstant.ResponseStatus ret = process.ThoaiDuyetGDChuyenDiaBan(arrayID, ref listClientResponseDetail);
if (ret == ApplicationConstant.ResponseStatus.THANH_CONG)
{
LMessage.ShowMessage("M.DungChung.ThoaiDuyetThanhCong", LMessage.MessageBoxType.Information);
}
else
{
CommonFunction.ThongBaoKetQua(listClientResponseDetail);
}
TimKiem();
}
else
{
LMessage.ShowMessage("M.DungChung.ChuaChonBanGhi", LMessage.MessageBoxType.Warning);
}
}
catch (System.Exception ex)
{
this.Cursor = Cursors.Arrow;
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
catch (System.Exception ex)
{
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
}
private void GetValuesOnForm()
{
try
{
KhachHangProcess khProcess = new KhachHangProcess();
dsKhachHang = khProcess.getThongTinKHTheoID(_idKhachHang);
DataTable dtKhangHSo = null;
if (chkInMauMoi.IsChecked == false)
{
if (dsKhachHang != null && dsKhachHang.Tables.Count > 0)
{
dtKhangHSo = dsKhachHang.Tables[0];
tenkhachhang = dtKhangHSo.Rows[0]["ten_khang"].ToString();
diachi = dtKhangHSo.Rows[0]["dia_chi"].ToString();
gioitinh = dtKhangHSo.Rows[0]["DD_GIOI_TINH"].ToString();
ngaysinh = dtKhangHSo.Rows[0]["DD_NGAY_SINH"].ToString();
socmnd = dtKhangHSo.Rows[0]["DD_GTLQ_SO"].ToString();
ngaycap = dtKhangHSo.Rows[0]["DD_GTLQ_NGAY_CAP"].ToString();
noicap = dtKhangHSo.Rows[0]["DD_GTLQ_NOI_CAP"].ToString();
sosohokhau = dtKhangHSo.Rows[0]["SO_HO_KHAU"].ToString();
DataRowView drv = (DataRowView)raddgrThongTinDon.SelectedItem;
sTenMucDichVay = drv["TEN_DMUC"].ToString();
}
makhachhang = txtMaKhachHang.Text.Trim();
idkhachhang = _idKhachHang.ToString();
DataRowView dr = (DataRowView)raddgrThongTinDon.SelectedItem;
sotienvay = LNumber.ToDecimal(dr["SO_TIEN_XIN_VAY"]).ToString();
maDXVV = dr["MA_DXVV"].ToString();
masanpham = dr["MA_SAN_PHAM"].ToString();
}
else
{
makhachhang = "";
idkhachhang = _idKhachHang.ToString();
sotienvay = "0";
maDXVV = "";
masanpham = "";
tenkhachhang = "";
diachi = "";
gioitinh = "";
ngaysinh = "";
socmnd = "";
ngaycap = "";
noicap = "";
sosohokhau = "";
sTenMucDichVay = "";
}
ngaybaocao = ClientInformation.NgayLamViecHienTai;
mangonngu = lstSourceNgonNgu.ElementAt(cmbNgonNgu.SelectedIndex).KeywordStrings.FirstOrDefault();
madinhdang = lstSourceDinhDang.ElementAt(cmbDinhDang.SelectedIndex).KeywordStrings.FirstOrDefault();
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void LoadDuLieu()
{
try
{
KhachHangProcess process = new KhachHangProcess();
DataSet ds = process.getTreeView(AppConfig.LoginedUser.MaDonViQuanLy, AppConfig.LoginedUser.UserName);
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void HienDanhMucKhachHang()
{
try
{
List <string> lstDieuKien = new List <string>();
KhachHangProcess khProcess = new KhachHangProcess();
string lstIDKH = "";
if (!txtMaKhachHang.Text.IsNullOrEmptyOrSpace())
{
lstIDKH = "(" + _idKhachHang.ToString() + ")";
}
else
{
lstIDKH = "(0)";
}
lstDieuKien.Add(ClientInformation.MaDonViGiaoDich);
lstDieuKien.Add("NULL");
lstDieuKien.Add("NULL");
lstPopup = new List <DataRow>();
PopupProcess popupProcess = new PopupProcess();
popupProcess.getPopupInformation("POPUP_DS_KHACHHANG_BAOCAO", lstDieuKien);
SimplePopupResponse simplePopupResponse = ClientInformation.SimplePopup;
ucPopup popup = new ucPopup(true, simplePopupResponse, false);
popup.DuLieuTraVe = new ucPopup.LayDuLieu(LayDuLieuTuPopup);
Window win = new Window();
win.Content = popup;
win.Title = LLanguage.SearchResourceByKey(simplePopupResponse.PopupTitle);
win.WindowStartupLocation = WindowStartupLocation.CenterScreen;
win.ShowDialog();
if (lstPopup.Count > 0)
{
DataRow dr = lstPopup[0];
_idKhachHang = Convert.ToInt32(dr["ID"]);
dsKhachHang = khProcess.getThongTinCoBanKHTheoID(_idKhachHang);
if (dsKhachHang != null && dsKhachHang.Tables[0].Rows.Count > 0)
{
txtMaKhachHang.Text = dsKhachHang.Tables[0].Rows[0]["MA_KHANG"].ToString();
txtTenKhachHang.Text = dsKhachHang.Tables[0].Rows[0]["TEN_KHANG"].ToString();
txtDiaChi.Text = dsKhachHang.Tables[0].Rows[0]["DIA_CHI"].ToString();
LayDSDonVayVon(_idKhachHang);
}
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void GetValuesOnForm()
{
try
{
lstIdKhachHang = new List <string>();
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];
idNhom = lstSourceNhom.ElementAt(cmbNhom.SelectedIndex).KeywordStrings[1];
manhom = lstSourceNhom.ElementAt(cmbNhom.SelectedIndex).KeywordStrings[0];
mangonngu = lstSourceNgonNgu.ElementAt(cmbNgonNgu.SelectedIndex).KeywordStrings.FirstOrDefault();
madinhdang = lstSourceDinhDang.ElementAt(cmbDinhDang.SelectedIndex).KeywordStrings.FirstOrDefault();
ngaybaocao = LDateTime.DateToString(Convert.ToDateTime(raddtNgayBaoCao.Value), ApplicationConstant.defaultDateTimeFormat);
foreach (DataRowView drv in grdKhachHang.SelectedItems)
{
lstIdKhachHang.Add(drv["ID"].ToString());
_idKhachHang = Convert.ToInt32(drv["ID"]);
}
if (lstIdKhachHang.Count > 0)
{
KhachHangProcess khProcess = new KhachHangProcess();
dsKhachHang = khProcess.getThongTinKHTheoID(_idKhachHang);
DataTable dtKhangHSo = null;
if (dsKhachHang != null && dsKhachHang.Tables.Count > 0)
{
dtKhangHSo = dsKhachHang.Tables[0];
tenkhachhang = dtKhangHSo.Rows[0]["TEN_KHANG"].ToString();
makhachhang = dtKhangHSo.Rows[0]["MA_KHANG"].ToString();
diachi = dtKhangHSo.Rows[0]["DIA_CHI"].ToString();
gioitinh = dtKhangHSo.Rows[0]["DD_GIOI_TINH"].ToString();
ngaysinh = dtKhangHSo.Rows[0]["DD_NGAY_SINH"].ToString();
socmnd = dtKhangHSo.Rows[0]["DD_GTLQ_SO"].ToString();
ngaycap = dtKhangHSo.Rows[0]["DD_GTLQ_NGAY_CAP"].ToString();
noicap = dtKhangHSo.Rows[0]["DD_GTLQ_NOI_CAP"].ToString();
sosohokhau = dtKhangHSo.Rows[0]["SO_HO_KHAU"].ToString();
}
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
/// <summary>
/// Xóa dữ liệu
/// </summary>
private void Xoa()
{
if (LMessage.ShowMessage("Thực hiện xóa dữ liệu ?", LMessage.MessageBoxType.Question) == MessageBoxResult.Yes)
{
KhachHangProcess process = new KhachHangProcess();
int[] arrayID = new int[0];
Mouse.OverrideCursor = Cursors.Wait;
try
{
DataRowView dr = (DataRowView)grNhomKhachHangDS.SelectedItem;
Array.Resize(ref arrayID, arrayID.Length + 1);
arrayID[arrayID.Length - 1] = Convert.ToInt32(dr["id"]);
//if (process.deleteDonVi(arrayID))
//{
// LMessage.ShowMessage("M.DungChung.XoaThanhCong", LMessage.MessageBoxType.Information);
//}
//else
//{
// LMessage.ShowMessage("M.DungChung.XoaKhongThanhCong", LMessage.MessageBoxType.Warning);
//}
}
catch (System.Exception ex)
{
this.Cursor = Cursors.Arrow;
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.XoaKhongThanhCong", ex).ShowDialog();
}
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
Mouse.OverrideCursor = Cursors.Arrow;
}
}
public void OnModify()
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
KhachHangProcess process = new KhachHangProcess();
List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>();
bool ret = false;
AfterModify(ret, listClientResponseDetail);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
private void btnKhachHang_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
var process = new PopupProcess();
List <string> lstDieuKien = new List <string>();
lstDieuKien.Add(lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First());
process.getPopupInformation(DatabaseConstant.DanhSachTruyVan.POPUP_DS_KHACHHANG_PGD.getValue(), lstDieuKien);
SimplePopupResponse simplePopupResponse = ClientInformation.SimplePopup;
ucPopup popup = new ucPopup(false, simplePopupResponse, false);
popup.DuLieuTraVe = new ucPopup.LayDuLieu(LayDuLieuTuPopup);
Window win = new Window();
win.Content = popup;
Mouse.OverrideCursor = Cursors.Arrow;
win.WindowStartupLocation = WindowStartupLocation.CenterScreen;
win.Title = "Danh sách khách hàng";
win.ShowDialog();
if (lstPopup != null)
{
DataRow row = lstPopup[0];
KhachHangProcess processKH = new KhachHangProcess();
DataRow dr = processKH.getThongTinCoBanKHTheoID(Convert.ToInt32(row[1])).Tables[0].Rows[0];
AfterGetKhachHang(dr);
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
