private void LoadComboboxKhuVuc() { if (cmbPhongGD.SelectedIndex >= 0) { // khởi tạo combobox string maPhongGD = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First(); string idPhongGD = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings[3]; // khởi tạo combobox var results = dtSourceKhuVuc.AsEnumerable().Select(x => x).Where(x => x.Field <int>("ID_DVI").Equals(LNumber.StringToInt32(idPhongGD))).ToList(); if (results.Count() > 0) { dtSourceKhuVuc_Select = results.CopyToDataTable(); new AutoComboBoxListCheckes().GenAutoComboBox(dtSourceKhuVuc_Select, ref cmbKhuVuc); } } }
private void GetFormData(ref List <DC_HAN_MUC> lstObjHanMuc) { try { lstObjHanMuc = new List <DC_HAN_MUC>(); #region Thông tin hạn mức giao dịch DC_HAN_MUC objHMGiaoDich = new DC_HAN_MUC(); objHMGiaoDich.ID = 0; objHMGiaoDich.MA_DTUONG_LOAI = lstLoaiDoiTuong.ElementAt(cmbLoaiDoiTuong.SelectedIndex).KeywordStrings.First(); objHMGiaoDich.ID_DTUONG = LNumber.StringToInt32(txtMaDoiTuong.Tag.ToString()); objHMGiaoDich.MA_DTUONG = txtMaDoiTuong.Text; objHMGiaoDich.LOAI_HAN_MUC = BusinessConstant.LOAI_HAN_MUC.CHUNG.layGiaTri(); objHMGiaoDich.ID_CNANG = null; objHMGiaoDich.MA_CNANG = null; objHMGiaoDich.ID_TNANG = null; objHMGiaoDich.MA_TNANG = "ADD"; objHMGiaoDich.MIN = 0; if (chkHMGiaoDichToiDa.IsChecked == false) { objHMGiaoDich.MAX = (decimal)numHMGiaoDich.Value; } objHMGiaoDich.NGAY_ADUNG = LDateTime.DateToString(teldtNgayHieuLuc.Value.Value, "yyyyMMdd"); if (teldtNgayHetHieuLuc.Value is DateTime) { objHMGiaoDich.NGAY_HHAN = LDateTime.DateToString(teldtNgayHetHieuLuc.Value.Value, "yyyyMMdd"); } //Thông tin kiểm soát objHMGiaoDich.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(); objHMGiaoDich.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri(); objHMGiaoDich.MA_DVI_QLY = ClientInformation.MaDonVi; objHMGiaoDich.MA_DVI_TAO = ClientInformation.MaDonViGiaoDich; objHMGiaoDich.NGAY_NHAP = ClientInformation.NgayLamViecHienTai; objHMGiaoDich.NGUOI_NHAP = ClientInformation.TenDangNhap; if (_action == DatabaseConstant.Action.SUA) { objHMGiaoDich.NGAY_CNHAT = ClientInformation.NgayLamViecHienTai; objHMGiaoDich.NGUOI_CNHAT = ClientInformation.TenDangNhap; } lstObjHanMuc.Add(objHMGiaoDich); #endregion #region Thông tin hạn mức phê duyệt DC_HAN_MUC objHMPheDuyet = new DC_HAN_MUC(); objHMPheDuyet.ID = 0; objHMPheDuyet.MA_DTUONG_LOAI = lstLoaiDoiTuong.ElementAt(cmbLoaiDoiTuong.SelectedIndex).KeywordStrings.First(); objHMPheDuyet.ID_DTUONG = LNumber.StringToInt32(txtMaDoiTuong.Tag.ToString()); objHMPheDuyet.MA_DTUONG = txtMaDoiTuong.Text; objHMPheDuyet.LOAI_HAN_MUC = BusinessConstant.LOAI_HAN_MUC.CHUNG.layGiaTri(); objHMPheDuyet.ID_CNANG = null; objHMPheDuyet.MA_CNANG = null; objHMPheDuyet.ID_TNANG = null; objHMPheDuyet.MA_TNANG = "APPROVE"; objHMPheDuyet.MIN = 0; if (chkHMPheDuyetToiDa.IsChecked == false) { objHMPheDuyet.MAX = (decimal)numHMPheDuyet.Value; } objHMPheDuyet.NGAY_ADUNG = LDateTime.DateToString(teldtNgayHieuLuc.Value.Value, "yyyyMMdd"); if (teldtNgayHetHieuLuc.Value is DateTime) { objHMPheDuyet.NGAY_HHAN = LDateTime.DateToString(teldtNgayHetHieuLuc.Value.Value, "yyyyMMdd"); } //Thông tin kiểm soát objHMPheDuyet.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(); objHMPheDuyet.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri(); objHMPheDuyet.MA_DVI_QLY = ClientInformation.MaDonVi; objHMPheDuyet.MA_DVI_TAO = ClientInformation.MaDonViGiaoDich; objHMPheDuyet.NGAY_NHAP = ClientInformation.NgayLamViecHienTai; objHMPheDuyet.NGUOI_NHAP = ClientInformation.TenDangNhap; if (_action == DatabaseConstant.Action.SUA) { objHMPheDuyet.NGAY_CNHAT = ClientInformation.NgayLamViecHienTai; objHMPheDuyet.NGUOI_CNHAT = ClientInformation.TenDangNhap; } lstObjHanMuc.Add(objHMPheDuyet); #endregion } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } }
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; } }
private void LoadGridViewKhuVuc() { if (cmbPhongGD.SelectedIndex >= 0) { string maPhongGiaoDich = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings.First(); string idPhongGiaoDich = lstSourcePhongGD_Select.ElementAt(cmbPhongGD.SelectedIndex).KeywordStrings[3]; var results = dtSourceKhuVuc.AsEnumerable().Select(x => x).Where(x => x.Field <int>("ID_DVI").Equals(LNumber.StringToInt32(idPhongGiaoDich))).ToList(); if (!LObject.IsNullOrEmpty(results) && results.Count() > 0) { dtSourceKhuVuc_Select = results.CopyToDataTable(); grKhuVuc.ItemsSource = dtSourceKhuVuc_Select; } else { grKhuVuc.ItemsSource = null; } } grCum.ItemsSource = null; }