public void OnApprove() { Mouse.OverrideCursor = Cursors.Wait; try { TaiSanDamBaoProcess processTSDB = new TaiSanDamBaoProcess(); List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>(); bool ret = false; action = DatabaseConstant.Action.DUYET; ret = LockData(); List <int> lst = new List <int>(); objHDTC = new TDTD_HOP_DONG_TCHAP(); objHDTC.ID = idHDTC; objHDTC.MA_HDTC = maHDTC; lst.Add(idHDTC); objHDTC.DSACH_ID_XOA = lst.ToArray(); if (ret) { ret = processTSDB.HopDongTheChapTDTD(action, ref objHDTC, ref listClientResponseDetail); } AfterApprove(ret, listClientResponseDetail); } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } finally { Mouse.OverrideCursor = Cursors.Arrow; } }
void LoadDuLieu() { try { string sMaTrangThaiNVu = ucTrangThaiNVu.GetItemsSelected(); if (sMaTrangThaiNVu.Equals("NULL")) { sMaTrangThaiNVu = "(''CDU'',''DDU'',''TCD'',''THD'')"; } #region Điều kiện tìm kiếm RadTreeViewItem item = tvwTaiSan.SelectedItem as RadTreeViewItem; if (item == null) { Mouse.OverrideCursor = Cursors.Arrow; return; } string loaiDonVi = item.Uid.ToString(); string maDonVi = item.Tag.ToString(); #endregion // Phân trang int StartRow = 1; int EndRow = ClientInformation.SoLuongBanGhi; int CurrentPagging = 1; int PaggingSize = ClientInformation.SoLuongBanGhi; DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@INP_MA_TRANG_THAI_NGHIEP_VU", "string", sMaTrangThaiNVu); LDatatable.AddParameter(ref dt, "@INP_SO_HDTC", "string", txtSoHD.Text); LDatatable.AddParameter(ref dt, "@INP_MA_KHANG", "string", txtMaKH.Text); LDatatable.AddParameter(ref dt, "@INP_TEN_KHANG", "string", txtTenKH.Text); LDatatable.AddParameter(ref dt, "@INP_NGAY_HOP_DONG", "string", raddtNgayHopDong.Value == null? "":raddtNgayHopDong.Value.Value.ToString("yyyyMMdd")); LDatatable.AddParameter(ref dt, "@INP_USER", "string", ClientInformation.TenDangNhap); LDatatable.AddParameter(ref dt, "@MA_DVI_QLY", "string", ClientInformation.MaDonViQuanLy); LDatatable.AddParameter(ref dt, "@MA_NNGU", "string", ClientInformation.NgonNgu); LDatatable.AddParameter(ref dt, "@StartRow", "string", StartRow.ToString()); LDatatable.AddParameter(ref dt, "@EndRow", "string", EndRow.ToString()); DataSet ds = new TaiSanDamBaoProcess().GetDanhSachHopDongTheChapTDTD(dt); if (ds != null && ds.Tables.Count > 0) { grDSTaiSan.DataContext = ds.Tables[0].DefaultView; } else { grDSTaiSan.Items.Clear(); } } 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; } }
private void SetFormData() { Mouse.OverrideCursor = Cursors.Wait; //lstTSDB = new List<TDTD_TAI_SAN_DAM_BAO>(); try { DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@INP_IDHDTC", "string", idHDTC.ToString()); DataSet ds = new TaiSanDamBaoProcess().GetHopDongTheChapTDTD(dt); if (!ds.IsNullOrEmpty() && ds.Tables.Count > 1) { dt = ds.Tables[0]; idHDTC = Convert.ToInt32(dt.Rows[0]["ID"]); txtSoHopDong.Text = dt.Rows[0]["MA_HDTC"].ToString(); txtMaKH.Text = dt.Rows[0]["MA_KHANG"].ToString(); lblTTinKHang.Content = dt.Rows[0]["TEN_KHANG"].ToString(); teldtNgayCNhat.Value = LDateTime.StringToDate(dt.Rows[0]["NGAY_HDTC"].ToString(), ApplicationConstant.defaultDateTimeFormat); txtDienGiai.Text = dt.Rows[0]["DIEN_GIAI"].ToString(); tThai_NVu = dt.Rows[0]["TTHAI_NVU"].ToString(); lblTrangThai.Content = BusinessConstant.layNgonNguNghiepVu(tThai_NVu); maDviQLy = dt.Rows[0]["MA_DVI_QLY"].ToString(); maDViTao = dt.Rows[0]["MA_DVI_TAO"].ToString(); txtNguoiLap.Text = dt.Rows[0]["NGUOI_NHAP"].ToString(); if (dt.Rows[0]["NGUOI_CNHAT"] != DBNull.Value) { txtNguoiCapNhat.Text = dt.Rows[0]["NGUOI_CNHAT"].ToString(); } teldtNgayNhap.Value = LDateTime.StringToDate(dt.Rows[0]["NGAY_NHAP"].ToString(), ApplicationConstant.defaultDateTimeFormat); if (dt.Rows[0]["NGAY_CNHAT"] != DBNull.Value) { teldtNgayCNhat.Value = LDateTime.StringToDate(dt.Rows[0]["NGAY_CNHAT"].ToString(), ApplicationConstant.defaultDateTimeFormat); } txtTrangThai.Text = BusinessConstant.layNgonNguSuDung(dt.Rows[0]["TTHAI_BGHI"].ToString()); dt = ds.Tables[1]; lstTSDB = dt.Rows.OfType <DataRow>().ToList(); raddgrDSachTSDB.ItemsSource = null; raddgrDSachTSDB.ItemsSource = lstTSDB; SetGtriTong(lstTSDB); } } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } finally { Mouse.OverrideCursor = Cursors.Arrow; } }
void LoadDuLieu() { TaiSanDamBaoProcess tsdbProcess = new TaiSanDamBaoProcess(); this.Cursor = Cursors.Wait; try { string slstDonVi = "NULL"; if (lstDonVi.Count > 0) { slstDonVi = ""; foreach (string sDonVi in lstDonVi) { slstDonVi += ",''" + sDonVi + "''"; } slstDonVi = slstDonVi.Substring(1); } string TThaiNvu = ucTrangThaiNVu.GetItemsSelected(); string SoHDTC = txtSoHDTD.Text; string NgayHDTu = teldtNgayHopDongTu.Value != null?LDateTime.DateToString((DateTime)teldtNgayHopDongTu.Value, ApplicationConstant.defaultDateTimeFormat) : ""; string NgayHDDen = teldtNgayHopDongDen.Value != null?LDateTime.DateToString((DateTime)teldtNgayHopDongDen.Value, ApplicationConstant.defaultDateTimeFormat) : ""; string MaTS = txtMaTaiSan.Text; string TenTS = txtTenTaiSan.Text; string TongGTriTu = txtGiaTriTu.Value != null?txtGiaTriTu.Value.ToString() : "0"; string TongGTriDen = txtGiaTriDen.Value != null?txtGiaTriDen.Value.ToString() : "0"; string MaKHang = txtMaKhachHang.Text; string TenKHang = txtTenKhachHang.Text; string LoaiGiayTo = lstLoaiGTo.ElementAt(cmbLoaiGiayTo.SelectedIndex).KeywordStrings.FirstOrDefault(); string SoGiayTo = txtSoGiayTo.Text; string DienThoai = txtDienThoai.Text; string Email = txtEmail.Text; DataSet ds = tsdbProcess.getDanhSachHopDongTC(TThaiNvu, SoHDTC, NgayHDTu, NgayHDDen, MaTS, TenTS, TongGTriTu, TongGTriDen, MaKHang, TenKHang, LoaiGiayTo, SoGiayTo, DienThoai, Email, slstDonVi); if (ds != null) { raddgrHopDongTheChapDS.ItemsSource = null; raddgrHopDongTheChapDS.ItemsSource = ds.Tables[0]; } } catch (Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error); } finally { tsdbProcess = null; this.Cursor = Cursors.Arrow; } }
void LoadDuLieuPhanTrang() { try { string sMaTrangThaiNVu = ucTrangThaiNVu.GetItemsSelected(); #region Điều kiện tìm kiếm RadTreeViewItem item = tvwTaiSan.SelectedItem as RadTreeViewItem; string loaiDonVi = item.Uid.ToString(); string maDonVi = item.Tag.ToString(); #endregion // Phân trang DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@INP_MA_TRANG_THAI_NGHIEP_VU", "string", sMaTrangThaiNVu); LDatatable.AddParameter(ref dt, "@INP_SO_HDTC", "string", txtSoHD.Text); LDatatable.AddParameter(ref dt, "@INP_MA_KHANG", "string", txtMaKH.Text); LDatatable.AddParameter(ref dt, "@INP_TEN_KHANG", "string", txtTenKH.Text); LDatatable.AddParameter(ref dt, "@INP_USER", "string", ClientInformation.TenDangNhap); LDatatable.AddParameter(ref dt, "@MA_DVI_QLY", "string", ClientInformation.MaDonViQuanLy); LDatatable.AddParameter(ref dt, "@StartRow", "string", StartRow.ToString()); LDatatable.AddParameter(ref dt, "@EndRow", "string", EndRow.ToString()); DataSet ds = new TaiSanDamBaoProcess().GetDanhSachHopDongTheChap(dt); if (ds != null && ds.Tables.Count > 0) { DataTable serverDataTable = ds.Tables[0]; int totalRecord = Int32.Parse(ds.Tables[1].Rows[0][0].ToString()); decimal totalSum = Decimal.Parse(ds.Tables[2].Rows[0][0].ToString()); DataTable clientDataTable = CommonFunction.BuildClientDataTable(serverDataTable, CurrentPagging, PaggingSize, totalRecord); //grdKheUocDS.ItemsSource = ds.Tables["DANH_SACH"].DefaultView; grDSTaiSan.ItemsSource = clientDataTable.DefaultView; grDSTaiSan.SelectedItems.Clear(); lblSumKhachHang.Content = totalRecord.ToString(); lblSumDuNo.Content = totalSum.ToString("N0"); } } 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; } }
public void OnSave() { if (!Validation()) { return; } GetFormData(ref objHDTC, BusinessConstant.layTrangThaiNghiepVu(tThai_NVu)); TaiSanDamBaoProcess processTSDB = new TaiSanDamBaoProcess(); List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>(); bool ret = false; if (idHDTC == 0) { ret = processTSDB.HopDongTheChapTDTD(DatabaseConstant.Action.THEM, ref objHDTC, ref listClientResponseDetail); } else { ret = processTSDB.HopDongTheChapTDTD(DatabaseConstant.Action.SUA, ref objHDTC, ref listClientResponseDetail); } AfterSave(ret, listClientResponseDetail); }