void GetFormData(BusinessConstant.TrangThaiNghiepVu nghiepvu, BusinessConstant.TrangThaiBanGhi bghi)
{
TDVMDUTHU = new TDVM_DU_THU();
lstDuThu = (List <DANH_SACH_KHE_UOC_DU_THU>)raddgrDuThuDS.ItemsSource;
TDVMDUTHU.DSACH_KHE_UOC = lstDuThu.ToArray();
TDVMDUTHU.MA_GIAO_DICH = txtSoGD.Text;
TDVMDUTHU.ID_GIAO_DICH = iDGiaoDich;
TDVMDUTHU.DIEN_GIAI = txtDienGiai.Text;
TDVMDUTHU.DU_THU_DEN_NGAY = LDateTime.DateToString(teldtDuThuDenNgay.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat);
TDVMDUTHU.LOAI_TIEN = ClientInformation.MaDongNoiTe;
TDVMDUTHU.MA_DVI = ClientInformation.MaDonViGiaoDich;
TDVMDUTHU.NGAY_GIAO_DICH = LDateTime.DateToString(teldtNgayGD.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat);
TDVMDUTHU.TRANG_THAI_BAN_GHI = bghi.layGiaTri();
TDVMDUTHU.TRANG_THAI_NGHIEP_VU = nghiepvu.layGiaTri();
TDVMDUTHU.TY_LE = (decimal)numTyLe.Value.GetValueOrDefault(100);
TDVMDUTHU.NGAY_LAP = ClientInformation.NgayLamViecHienTai;
TDVMDUTHU.NGUOI_LAP = ClientInformation.TenDangNhap;
if (iDGiaoDich > 0)
{
TDVMDUTHU.NGAY_LAP = LDateTime.DateToString(teldtNgayNhap.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat);;
TDVMDUTHU.NGUOI_LAP = txtNguoiLap.Text;
TDVMDUTHU.NGAY_CAP_NHAT = ClientInformation.NgayLamViecHienTai;
TDVMDUTHU.NGUOI_CAP_NHAT = ClientInformation.TenDangNhap;
}
}
/// <summary>
/// Đưa dữ liệu từ form vào object DM_PHAN_HE_GD
/// </summary>
/// <param name="banghi">Trạng thái bản ghi</param>
/// <param name="nghiepvu">Trạng thái nghiệp vụ</param>
/// <param name="nguoi_cnhap">Tên người cập nhật</param>
/// <returns></returns>
private Presentation.Process.DanhMucServiceRef.DM_PHAN_HE_GD LayDuLieu(BusinessConstant.TrangThaiNghiepVu nghiepvu, string nguoi_cnhat)
{
Presentation.Process.DanhMucServiceRef.DM_PHAN_HE_GD obj = new Presentation.Process.DanhMucServiceRef.DM_PHAN_HE_GD();
if (idPhanHeGD != 0)
{
obj.ID = idPhanHeGD;
}
obj.MA_LOAI_GDICH = txtMaLoaiGD.Text;
obj.TEN_LOAI_GDICH = txtTenLoaiGD.Text;
obj.TEN_TAT = txtTentat.Text;
obj.MA_PHAN_HE = cmbPhanHe.SelectedValue.ToString();
obj.ID_PHAN_HE = 0;
//obj.TTHAI_BGHI = cmbTrangThaiSDung.SelectedValue.ToString();
obj.TTHAI_NVU = BusinessConstant.layGiaTri(nghiepvu);
obj.MA_DVI_TAO = Presentation.Process.Common.ClientInformation.MaDonVi;
obj.MA_DVI_QLY = Presentation.Process.Common.ClientInformation.MaDonVi;
if (!LString.IsNullOrEmptyOrSpace(nguoi_cnhat))
{
obj.NGUOI_CNHAT = nguoi_cnhat;
obj.NGAY_CNHAT = LDateTime.GetCurrentDate(ApplicationConstant.defaultDateTimeFormat);
}
else
{
obj.NGUOI_NHAP = Presentation.Process.Common.ClientInformation.TenDangNhap;
obj.NGAY_NHAP = LDateTime.GetCurrentDate(ApplicationConstant.defaultDateTimeFormat);
}
return(obj);
}
void BeforeSave(BusinessConstant.TrangThaiNghiepVu nghiepvu, BusinessConstant.TrangThaiBanGhi bghi)
{
Cursor = Cursors.Wait;
cbbMaTienTe.Focus();
try
{
if (!nghiepvu.Equals(BusinessConstant.TrangThaiNghiepVu.LUU_TAM))
{
if (!Validation())
{
Cursor = Cursors.Arrow;
return;
}
}
GetDataForm(bghi, nghiepvu);
OnSave();
}
catch (System.Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Cursor = Cursors.Arrow;
}
}
private void AfterSave(BusinessConstant.TrangThaiNghiepVu nghiepvu, BusinessConstant.TrangThaiSuDung sudung)
{
try
{
Cursor = Cursors.Wait;
if (!Validation() && nghiepvu.Equals(BusinessConstant.TrangThaiNghiepVu.CHO_DUYET))
{
return;
}
DM_KHU_VUC obj = GetDataForm(nghiepvu, sudung);
// Lock dữ liệu nếu người dùng chấp nhận cảnh báo
UtilitiesProcess process = new UtilitiesProcess();
List <int> listLockId = new List <int>();
listLockId.Add(idKhuVuc);
bool retLockData = true;
if (idKhuVuc > 0)
{
retLockData = process.LockData(DatabaseConstant.Module.DMDC,
DatabaseConstant.Function.DC_DM_KHU_VUC,
DatabaseConstant.Table.DM_KHU_VUC,
DatabaseConstant.Action.SUA,
listLockId);
}
if (retLockData)
{
OnSave(obj);
}
}
catch (System.Exception ex)
{
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Cursor = Cursors.Arrow;
// Unlock dữ liệu nếu người dùng chấp nhận cảnh báo
UtilitiesProcess process = new UtilitiesProcess();
List <int> listLockId = new List <int>();
listLockId.Add(idKhuVuc);
bool retLockData = true;
if (idKhuVuc > 0)
{
retLockData = process.UnlockData(DatabaseConstant.Module.DMDC,
DatabaseConstant.Function.DC_DM_KHU_VUC,
DatabaseConstant.Table.DM_KHU_VUC,
DatabaseConstant.Action.SUA,
listLockId);
}
}
}
/// <summary>
/// Luu du lieu
/// </summary>
/// <param name="banghi"></param>
/// <param name="nghiepvu"></param>
void Luu(BusinessConstant.TrangThaiBanGhi banghi, BusinessConstant.TrangThaiNghiepVu nghiepvu)
{
if (Vadidate())
{
DanhMucProcess danhmucProcess = new DanhMucProcess();
try
{
Presentation.Process.DanhMucServiceRef.DM_TINH_TP objTTP = new Presentation.Process.DanhMucServiceRef.DM_TINH_TP();
LayDuLieu(ref objTTP, banghi, nghiepvu);
int iResutl = 0;
//if (LstChiTiet == null)
// iResutl = danhmucProcess.ThemTinhTP(objTTP);
//else
//{
// objTTP.ID = int.Parse(LstChiTiet[1].ToString());
// iResutl = danhmucProcess.updateTinhTP(objTTP);
//}
if (iResutl > 0)
{
LMessage.ShowMessage("M.DanhMuc.ucQuocGiaCT.LuuDuLieuThanhCong", LMessage.MessageBoxType.Information);
if (OnSavingComleted != null)
{
OnSavingComleted(null, EventArgs.Empty);
}
if (cbMultiAdd.IsChecked == true)
{
ClearForm();
}
else
{
PresentationWPF.CustomControl.CommonFunction.CloseUserControl(this);
}
}
else
{
LMessage.ShowMessage("M.DanhMuc.ucQuocGiaCT.LoiLuuDuLieu", LMessage.MessageBoxType.Error);
}
}
catch (Exception ex)
{
LMessage.ShowMessage("M.DanhMuc.ucQuocGiaCT.LoiLuuDuLieu", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
}
private DM_KHU_VUC GetDataForm(BusinessConstant.TrangThaiNghiepVu nghiepvu, BusinessConstant.TrangThaiSuDung sudung)
{
DM_KHU_VUC obj = new DM_KHU_VUC();
DataSet dsDVi = new DanhMucProcess().getDonViTheoMa(lstSourcePGD.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings[0]);
obj.ID = idKhuVuc;
obj.ID_DVI = Convert.ToInt32(dsDVi.Tables[0].Rows[0]["ID"]);
obj.MA_DVI = lstSourcePGD.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.FirstOrDefault();
obj.MA_DVI_QLY = ClientInformation.MaDonVi;
obj.MA_DVI_TAO = lstSourcePGD.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.FirstOrDefault();
obj.MA_KVUC = txtMaKhuVuc.Text;
obj.TEN_KVUC = txtTenKhuVuc.Text;
obj.TEN_TAT = txtTenTat.Text;
obj.TTHAI_NVU = nghiepvu.layGiaTri();
obj.TTHAI_BGHI = sudung.layGiaTri();
obj.NGAY_CNHAT = idKhuVuc > 0 ? ClientInformation.NgayLamViecHienTai : "";
obj.NGUOI_CNHAT = idKhuVuc > 0 ? ClientInformation.TenDangNhap : "";
obj.NGAY_NHAP = idKhuVuc == 0 ? ClientInformation.NgayLamViecHienTai : LDateTime.DateToString(txtNgayLap.Value.GetValueOrDefault(), ApplicationConstant.defaultDateTimeFormat);
obj.NGUOI_NHAP = idKhuVuc == 0 ? ClientInformation.TenDangNhap : txtNguoiLap.Text;
return(obj);
}
void GetDataForm(BusinessConstant.TrangThaiBanGhi bghi, BusinessConstant.TrangThaiNghiepVu nghiepvu)
{
try
{
AutoCompleteEntry auLoaiTien = lstSourceLoaiTien.ElementAt(cbbMaTienTe.SelectedIndex);
if (LObject.IsNullOrEmpty(objTYGIA))
{
objTYGIA = new TY_GIA_CT();
}
List <DANH_SACH_TY_GIA_CT> lst = raddgrDSTyGia.ItemsSource as List <DANH_SACH_TY_GIA_CT>;
objTYGIA.DSACH_TY_GIA_CT = lst.ToArray();
objTYGIA.ID_TY_GIA = idTienTe;
objTYGIA.MA_LOAI_TIEN = auLoaiTien.KeywordStrings.FirstOrDefault();
objTYGIA.NGAY_AP_DUNG = ClientInformation.NgayLamViecHienTai;
idTienTeCT = lst.Select(f => f.ID_TY_GIA_CT).ToList();
}
catch (System.Exception ex)
{
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
void BeforeSave(BusinessConstant.TrangThaiNghiepVu nghiepvu, BusinessConstant.TrangThaiBanGhi bghi)
{
if (!nghiepvu.Equals(BusinessConstant.TrangThaiNghiepVu.LUU_TAM))
{
if (!VaditionData())
{
return;
}
}
List <int> lstId = new List <int>();
lstId.Add(iDGiaoDich);
// Yêu cầu Unlock dữ liệu
UtilitiesProcess process = new UtilitiesProcess();
bool retLockData = process.LockData(DatabaseConstant.Module.TDVM,
DatabaseConstant.Function.TDVM_DU_THU,
DatabaseConstant.Table.KT_GIAO_DICH,
DatabaseConstant.Action.SUA,
lstId);
GetFormData(nghiepvu, bghi);
OnSave();
}
/// <summary>
/// Lấy trạng thái bản ghi dựa theo action và trạng thái bản ghi hiện tại
/// </summary>
/// <returns></returns>
public static string LayTrangThaiBanGhi(DatabaseConstant.Action action, BusinessConstant.TrangThaiNghiepVu status)
{
string trangthai = "";
switch (action)
{
case DatabaseConstant.Action.LUU_TAM:
if (status == BusinessConstant.TrangThaiNghiepVu.DA_DUYET)
{
trangthai = BusinessConstant.TrangThaiNghiepVu.SUA_SAU_DUYET.layGiaTri();
}
else if (status == BusinessConstant.TrangThaiNghiepVu.CHO_DUYET)
{
trangthai = BusinessConstant.TrangThaiNghiepVu.LUU_TAM.layGiaTri();
}
else if (status == BusinessConstant.TrangThaiNghiepVu.SUA_SAU_DUYET)
{
trangthai = BusinessConstant.layGiaTri(BusinessConstant.TrangThaiNghiepVu.LUU_TAM_SUA_SAU_DUYET);
}
else
{
trangthai = BusinessConstant.TrangThaiNghiepVu.LUU_TAM.layGiaTri();
}
break;
case DatabaseConstant.Action.LUU:
if (status == BusinessConstant.TrangThaiNghiepVu.DA_DUYET)
{
trangthai = BusinessConstant.TrangThaiNghiepVu.SUA_SAU_DUYET.layGiaTri();
}
else if (status == BusinessConstant.TrangThaiNghiepVu.SUA_SAU_DUYET)
{
trangthai = BusinessConstant.TrangThaiNghiepVu.CHO_DUYET.layGiaTri();
}
else
{
trangthai = BusinessConstant.TrangThaiNghiepVu.CHO_DUYET.layGiaTri();
}
break;
case DatabaseConstant.Action.TRINH_DUYET:
if (status == BusinessConstant.TrangThaiNghiepVu.DA_DUYET)
{
trangthai = BusinessConstant.TrangThaiNghiepVu.SUA_SAU_DUYET.layGiaTri();
}
else if (status == BusinessConstant.TrangThaiNghiepVu.SUA_SAU_DUYET)
{
trangthai = BusinessConstant.TrangThaiNghiepVu.CHO_DUYET.layGiaTri();
}
else
{
trangthai = BusinessConstant.TrangThaiNghiepVu.CHO_DUYET.layGiaTri();
}
break;
case DatabaseConstant.Action.DUYET:
trangthai = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri();
break;
case DatabaseConstant.Action.THOAI_DUYET:
trangthai = BusinessConstant.TrangThaiNghiepVu.THOAI_DUYET.layGiaTri();
break;
case DatabaseConstant.Action.TU_CHOI_DUYET:
trangthai = BusinessConstant.TrangThaiNghiepVu.TU_CHOI.layGiaTri();
break;
}
return(trangthai);
}
private void GetFormData(ref TDTD_HOP_DONG_TCHAP obj, BusinessConstant.TrangThaiNghiepVu tthaiNVu)
{
try
{
obj = new TDTD_HOP_DONG_TCHAP();
obj.ID = idHDTC;
obj.MA_HDTC = txtSoHopDong.Text;
obj.MA_KHANG = txtMaKH.Text;
obj.NGAY_HDTC = teldtNgayHopDong.Value.Value.ToString("yyyyMMdd");
lstTSDB = raddgrDSachTSDB.ItemsSource as List <DataRow>;
obj.SO_PLUC_HD = soPhuLucTC;
if (idHDTC == 0)
{
obj.MA_DVI_QLY = ClientInformation.MaDonVi;
obj.MA_DVI_TAO = ClientInformation.MaDonViGiaoDich;
obj.NGAY_NHAP = ClientInformation.NgayLamViecHienTai;
obj.NGUOI_NHAP = ClientInformation.TenDangNhap;
obj.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri();
}
else
{
obj.MA_DVI_QLY = maDviQLy;
obj.MA_DVI_TAO = maDViTao;
obj.NGAY_NHAP = teldtNgayNhap.Value.GetValueOrDefault().ToString(ApplicationConstant.defaultDateTimeFormat);
obj.NGUOI_NHAP = txtNguoiLap.Text;
obj.NGAY_CNHAT = ClientInformation.NgayLamViecHienTai;
obj.NGUOI_CNHAT = ClientInformation.TenDangNhap;
obj.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri();
}
obj.TTHAI_NVU = tthaiNVu.layGiaTri();
obj.DIEN_GIAI = txtDienGiai.Text;
List <TDTD_TAI_SAN_DAM_BAO> lstTaiSan = new List <TDTD_TAI_SAN_DAM_BAO>();
foreach (DataRow dr in lstTSDB)
{
TDTD_TAI_SAN_DAM_BAO objTS = new TDTD_TAI_SAN_DAM_BAO();
objTS.ID = LNumber.StringToInt32(dr["ID"].ToString());
objTS.MA_TSDB = dr["MA_TSDB"].ToString();
objTS.TEN_TSDB = dr["TEN_TSDB"].ToString();
objTS.MA_LOAI_TSDB = dr["MA_LOAI_TSDB"].ToString();
objTS.SO_SO_TK = dr["SO_SO_TK"].ToString();
objTS.MO_TAI_LMF = dr["MO_TAI_LMF"].ToString();
objTS.GIA_TRI_TAI_SAN = LNumber.ToDecimal(dr["GTRI_TAI_SAN"].ToString());
objTS.TI_LE_DAM_BAO = LNumber.ToDecimal(dr["TI_LE_DAM_BAO"].ToString());
objTS.GIA_TRI_DAM_BAO = LNumber.ToDecimal(dr["GTRI_DAM_BAO"].ToString());
objTS.DIEN_GIAI = dr["DIEN_GIAI"].ToString();
objTS.TTHAI_BGHI = dr["TTHAI_BGHI"].ToString();
objTS.TTHAI_NVU = dr["TTHAI_NVU"].ToString();
objTS.MA_DVI_QLY = dr["MA_DVI_QLY"].ToString();
objTS.MA_DVI_TAO = dr["MA_DVI_TAO"].ToString();
objTS.NGAY_NHAP = dr["NGAY_NHAP"].ToString();
objTS.NGUOI_NHAP = dr["NGUOI_NHAP"].ToString();
objTS.NGAY_CNHAT = dr["NGAY_CNHAT"].ToString();
objTS.NGUOI_CNHAT = dr["NGUOI_CNHAT"].ToString();
lstTaiSan.Add(objTS);
}
obj.DSACH_TAI_SAN_DBAO = lstTaiSan.ToArray();
obj.TONG_GIA_TRI = lstTaiSan.Sum(f => f.GIA_TRI_DAM_BAO);
if (lstIDXoa.IsNullOrEmpty())
{
lstIDXoa = new List <int>();
}
obj.DSACH_ID_XOA = lstIDXoa.ToArray();
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
}
/// <summary>
/// Lưu dữ liệu
/// </summary>
private void Luu(BusinessConstant.TrangThaiNghiepVu nghiepvu, string nguoi_cnhat)
{
if (Validation())
{
DanhMucProcess danhmucProcess = new DanhMucProcess();
try
{
// Lấy dữ liệu từ giao diện đưa vào object
Presentation.Process.DanhMucServiceRef.DM_PHAN_HE_GD obj = new Presentation.Process.DanhMucServiceRef.DM_PHAN_HE_GD();
obj = LayDuLieu(nghiepvu, nguoi_cnhat);
// Lưu dữ liệu
if (idPhanHeGD == 0)
{
if (!danhmucProcess.checkMaDonViDaSuDung(obj.MA_LOAI_GDICH))
{
if (danhmucProcess.ThemPhanHeGD(obj) != null)
{
LMessage.ShowMessage("M.DanhMuc.ucPhanHeGDCT.LuuDuLieuThanhCong", LMessage.MessageBoxType.Information);
idPhanHeGD = obj.ID;
if (cbMultiAdd.IsChecked == true)
{
ResetForm();
idPhanHeGD = 0;
}
else
{
Dong();
}
}
else
{
LMessage.ShowMessage("M.DanhMuc.ucPhanHeGDCT.LuuDuLieuKoThanhCong", LMessage.MessageBoxType.Error);
}
}
else
{
LMessage.ShowMessage("M.DanhMuc.ucPhanHeGDCT.MaDonViDaDuocSuDung", LMessage.MessageBoxType.Warning);
txtMaLoaiGD.Focus();
}
}
else
{
if (danhmucProcess.SuaPhanHeGD(obj) != null)
{
LMessage.ShowMessage("M.DanhMuc.ucPhanHeGDCT.LuuDuLieuThanhCong", LMessage.MessageBoxType.Information);
}
else
{
LMessage.ShowMessage("M.DanhMuc.ucPhanHeGDCT.LuuDuLieuKoThanhCong", LMessage.MessageBoxType.Error);
}
Dong();
}
}
catch (System.Exception ex)
{
LMessage.ShowMessage("M.DanhMuc.ucPhanHeGDCT.LoiLuuDuLieu", LMessage.MessageBoxType.Error);
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
danhmucProcess = null;
}
}
}
/// <summary>
/// Lay du lieu tu control dieu khien dua vao object
/// </summary>
/// <param name="obj"></param>
/// <param name="banghi"></param>
/// <param name="nghiepvu"></param>
void LayDuLieu(ref Presentation.Process.DanhMucServiceRef.DC_TSUAT obj, BusinessConstant.TrangThaiBanGhi banghi, BusinessConstant.TrangThaiNghiepVu nghiepvu)
{
obj.MA_TSUAT = txtMa.Text;
obj.TEN_TSUAT = txtTen.Text;
obj.TSUAT_LAN = Convert.ToInt32(nudLan.Value);
obj.TSUAT_TGIAN_SLUONG = Convert.ToInt32(nudThoiGian.Value);
obj.TSUAT_TGIAN_DVI_TINH = lstSourceTanSuat.ElementAt(cmbLoaiThoiGian.SelectedIndex).KeywordStrings.First();
obj.NGAY_NHAP = LDateTime.GetCurrentDate(ApplicationConstant.defaultDateTimeFormat);
obj.MA_DVI_QLY = ClientInformation.MaDonVi;
obj.MA_DVI_TAO = ClientInformation.MaDonVi;
obj.NGUOI_NHAP = ClientInformation.TenDangNhap;
obj.TTHAI_BGHI = BusinessConstant.layGiaTri(banghi);
obj.TTHAI_NVU = BusinessConstant.layGiaTri(nghiepvu);
}
/// <summary>
/// Lay du lieu tu control dieu khien dua vao object
/// </summary>
/// <param name="obj"></param>
/// <param name="banghi"></param>
/// <param name="nghiepvu"></param>
void LayDuLieu(ref Presentation.Process.DanhMucServiceRef.DM_TINH_TP obj, BusinessConstant.TrangThaiBanGhi banghi, BusinessConstant.TrangThaiNghiepVu nghiepvu)
{
obj.MA_TINHTP = txtMaSo.Text;
obj.TEN_TINHTP = txtTenDayDu.Text;
obj.TEN_TAT = txtTenTat.Text;
obj.ID_VUNG_MIEN = int.Parse(IdVung);
obj.NGAY_NHAP = LDateTime.GetCurrentDate(ApplicationConstant.defaultDateTimeFormat);
obj.MA_DVI_QLY = ClientInformation.MaDonVi;
obj.MA_DVI_TAO = ClientInformation.MaDonVi;
obj.NGUOI_NHAP = ClientInformation.TenDangNhap;
obj.TTHAI_BGHI = BusinessConstant.layGiaTri(banghi);
obj.TTHAI_NVU = BusinessConstant.layGiaTri(nghiepvu);
}
