public bool LayThongTinVeDon(string MaDangKyBienDong) { try { using (DMCWebEntities db = new DMCWebEntities()) { long _maDangKyBienDong = long.Parse(MaDangKyBienDong); if (Session["LoaiHoSo"] == "DuBi") { var kq = from h in db.tblDonXinDangKyBienDongDuBis where h.ID == _maDangKyBienDong select h; Session["MaDVHC"] = kq.Single().DonViHanhChinh; if (Session["MaDVHC"] != null && Session["MaDVHC"].ToString() != "") { drDonViHanhChinh.SelectedValue = Session["MaDVHC"].ToString(); } Session["LoaiBienDong"] = kq.Single().LoaiBienDong; string s = Session["LoaiBienDong"].ToString(); if (Convert.ToInt32(Session["LoaiBienDong"]) > 0) { drLoaiBienDong.SelectedValue = Session["LoaiBienDong"].ToString(); } return(true); } else if (Session["LoaiHoSo"] == "ChinhThuc") { var kq = from h in db.tblDonXinDangKyBienDongs where h.MaDangKyBienDong == _maDangKyBienDong select h; Session["MaDVHC"] = kq.Single().DonViHanhChinh; if (Session["MaDVHC"] != null && Session["MaDVHC"].ToString() != "") { drDonViHanhChinh.SelectedValue = Session["MaDVHC"].ToString(); } Session["LoaiBienDong"] = kq.Single().LoaiBienDong; string s = Session["LoaiBienDong"].ToString(); if (Convert.ToInt32(Session["LoaiBienDong"]) > 0) { drLoaiBienDong.SelectedValue = Session["LoaiBienDong"].ToString(); } return(true); } else { return(false); } } } catch (Exception ex) { string s = ex.Message; return(false); } }
protected void grvNhaO_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { NhapThongTinNhaO_Visible(true); string _maNhaO = e.CommandArgument.ToString(); Session["ThaoTac"] = ThaoTac.DangSua; Session["MaNhaO"] = _maNhaO; using (DMCWebEntities db = new DMCWebEntities()) { long maNhaO = long.Parse(_maNhaO); var q = (from n in db.tblThongTinNhaOs where n.MaNhaO == maNhaO select n).Single(); tblThongTinNhaO nha = (tblThongTinNhaO)q; lblMaNhaO.Text = nha.MaNhaO.ToString(); drLoaiNhaO.SelectedValue = nha.LoaiNhaO; txtDienTichXayDung.Text = nha.DienTichXayDung; txtDienTichSan.Text = nha.DienTichSan; txtSoHuuChung.Text = nha.SoHuuChung; txtSoHuuRieng.Text = nha.SoHuuRieng; txtKetCau.Text = nha.KetCau; txtHanCheNha.Text = nha.ThoiHanSoHuu; drHanCheNha.SelectedValue = nha.CoHanCheThoiHanSoHuu.ToString(); txtSoTang.Text = nha.SoTang; } } }
protected void grvThuaDat_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { NhapThongTinThuaDat_Visible(true); string _maThuaDat = e.CommandArgument.ToString(); Session["ThaoTac"] = ThaoTac.DangSua; Session["MaThuaDat"] = _maThuaDat; using (DMCWebEntities db = new DMCWebEntities()) { long maThuaDat = long.Parse(_maThuaDat); var thuadatdangxet = (from td in db.tblThuaDats where td.MaThuaDat == maThuaDat select td).Single(); tblThuaDat thua = (tblThuaDat)thuadatdangxet; lblMaThuaDat.Text = thua.MaThuaDat.ToString(); lblMaHoSo.Text = thua.MaHoSo.ToString(); txtToBanDo.Text = thua.ToBanDo; txtSoThua.Text = thua.SoThua; txtDiaChi.Text = thua.DiaChi; txtDienTich.Text = thua.DienTich; txtDTSDChung.Text = thua.SuDungChung; txtDTSDRieng.Text = thua.SuDungRieng; txtMucDich.Text = thua.MucDichSuDung; txtThoiHan.Text = thua.ThoiHanSuDung; txtNgayBatDau.Text = thua.NgayBatDauSuDung.ToString(); drHanChe.SelectedValue = thua.CoHanCheSuDung.ToString(); txtHanChe.Text = thua.NoiDungHanCheSuDung; drLoaiNguonGoc.SelectedValue = thua.LoaiNguonGocSuDung; } } }
protected void grvChu_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { NhapThongTinChu_Visible(true); string _maChu = e.CommandArgument.ToString(); Session["ThaoTac"] = ThaoTac.DangSua; Session["MaChu"] = _maChu; using (DMCWebEntities db = new DMCWebEntities()) { long maChu = long.Parse(_maChu); var q = (from c in db.tblChus where c.MaChu == maChu select c).Single(); tblChu chu = (tblChu)q; lblMaChu.Text = "Mã chủ: " + _maChu.ToString(); txtHoTen.Text = chu.HoTen; drDanhXung.Text = chu.DanhXung; txtNamSinh.Text = chu.NamSinh; txtDiaChi.Text = chu.DiaChi; txtSoDinhDanh.Text = chu.SoDinhDanh; txtNoiCap.Text = chu.NoiCap; txtNgayCap.Text = chu.NgayCap.ToString(); txtDinhDanh.Text = chu.DinhDanh; } } }
protected void grvChu_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { NhapThongTinChu_Visible(true); string _maChu = e.CommandArgument.ToString(); Session["ThaoTac"] = ThaoTac.DangSua; Session["MaChu"] = _maChu; using (DMCWebEntities db = new DMCWebEntities()) { long maChu = long.Parse(_maChu); if (Session["LoaiHoSo"] == "DuBi") { tblChuDuBi chu = db.tblChuDuBis.SingleOrDefault(n => n.MaChu == maChu); lblMaChu.Text = _maChu.ToString(); txtHoTen.Text = chu.HoTen; drDanhXung.Text = chu.DanhXung; txtNamSinh.Text = chu.NamSinh; txtDiaChi.Text = chu.DiaChi; txtSoDinhDanh.Text = chu.SoDinhDanh; txtNoiCap.Text = chu.NoiCap; txtNgayCap.Text = chu.NgayCap.ToString(); txtDinhDanh.Text = chu.DinhDanh; } else if (Session["LoaiHoSo"] == "ChinhThuc") { tblChu chu = db.tblChus.SingleOrDefault(n => n.MaChu == maChu); lblMaChu.Text = "Mã chủ: " + _maChu.ToString(); txtHoTen.Text = chu.HoTen; drDanhXung.Text = chu.DanhXung; txtNamSinh.Text = chu.NamSinh; txtDiaChi.Text = chu.DiaChi; txtSoDinhDanh.Text = chu.SoDinhDanh; txtNoiCap.Text = chu.NoiCap; txtNgayCap.Text = chu.NgayCap.ToString(); txtDinhDanh.Text = chu.DinhDanh; } } } }
public bool LayThongTinHoSo(string MaHoSo) { try { using (DMCWebEntities db = new DMCWebEntities()) { long _maHS = long.Parse(MaHoSo); var kq = from h in db.tblHoSoes join dt in db.tblChuHoSoes on h.MaHoSo equals dt.MaHoSo where h.MaHoSo == _maHS select new { MaHS = h.MaHoSo, Dvhc = h.DonViHanhChinh, LoaiDT = h.LoaiDoiTuong }; Session["MaDVHC"] = kq.Single().Dvhc; string strLoaiDoiTuong = kq.Single().LoaiDT; if (strLoaiDoiTuong == null || strLoaiDoiTuong == "") { drLoaiDoiTuong.SelectedIndex = -1; } else { drLoaiDoiTuong.SelectedValue = strLoaiDoiTuong; } drDonViHanhChinh.SelectedValue = Session["MaDVHC"].ToString(); return(true); } } catch (Exception ex) { string s = ex.Message; return(false); } }