コード例 #1
0
        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);
            }
        }
コード例 #2
0
        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;
                }
            }
        }
コード例 #3
0
        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;
                }
            }
        }
コード例 #4
0
        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;
                }
            }
        }
コード例 #5
0
        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;
                    }
                }
            }
        }
コード例 #6
0
 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);
     }
 }