コード例 #1
0
        public bool del(BIEUMAU_M04 bm)
        {
            BIEUMAU_M04 _bm = db.BIEUMAU_M04s.Where(m => m.ID == bm.ID).FirstOrDefault();

            if (_bm != null)
            {
                _bm.TT_XOA = true;
                return(true);
            }
            return(false);
        }
コード例 #2
0
        public bool editInfo_m04(BIEUMAU_M04 bm)
        {
            BIEUMAU_M04 _bm = db.BIEUMAU_M04s.OrderByDescending(i => i.ID).First();

            if (_bm != null)
            {
                try
                {
                    _bm = bm;
                    return(true);
                }
                catch (Exception e) { return(false); }
            }
            return(false);
        }
コード例 #3
0
ファイル: UF_MauSo4a.cs プロジェクト: NhatLam310399/PM_QLGTDD
        private void M04_btn_Luu_Click(object sender, EventArgs e)
        {
            lstTxt = new List <TextBox>();
            lstTxt.Add(M04_NSD_txt_diaChi);
            lstTxt.Add(M04_NSD_txt_hoTen);
            lstTxt.Add(M04_NSD_txt_so);
            lstTxt.Add(M04_txt_cua);
            lstTxt.Add(M04_txt_diaChiDat);
            lstTxt.Add(M04_txt_dtDat);
            lstTxt.Add(M04_txt_hoTenNguoiVD);
            lstTxt.Add(M04_txt_kinhGui);
            lstTxt.Add(M04_txt_ndQuyenSD);
            lstTxt.Add(M04_txt_nguonGocSD);
            lstTxt.Add(M04_txt_nhuCauGhiNo);
            lstTxt.Add(M04_txt_quyenSo);
            lstTxt.Add(M04_txt_sdHanChe);
            lstTxt.Add(M04_txt_suDungChung);
            lstTxt.Add(M04_txt_suDungMD);
            lstTxt.Add(M04_txt_suDungRieng);

            lstTxt.Add(M04_txt_thuaDatSo);
            lstTxt.Add(M04_txt_toBanDoSo);


            List <TextBox> lstTxt2 = new List <TextBox>();

            lstTxt2.Add(M04_txt_CLN_loaicay);
            lstTxt2.Add(M04_txt_CLN_soHuuChung);
            lstTxt2.Add(M04_txt_CLN_soHuuRieng);
            lstTxt2.Add(M04_txt_NO_dtSan);
            lstTxt2.Add(M04_txt_NO_dtXD);
            lstTxt2.Add(M04_txt_NO_ketCau);
            lstTxt2.Add(M04_txt_NO_loaiNhaO);
            lstTxt2.Add(M04_txt_NO_soHuuChung);
            lstTxt2.Add(M04_txt_NO_soHuuRieng);
            lstTxt2.Add(M04_txt_NO_soTang);
            lstTxt2.Add(M04_txt_RSX_dienTich);
            lstTxt2.Add(M04_txt_RSX_loaiCay);
            lstTxt2.Add(M04_txt_RSX_nguonVon);
            lstTxt2.Add(M04_txt_RSX_nhanChuyenQuyen);
            lstTxt2.Add(M04_txt_RSX_NNKTT);
            lstTxt2.Add(M04_txt_RSX_NNTT);
            lstTxt2.Add(M04_txt_RSX_soHuuChung);
            lstTxt2.Add(M04_txt_RSX_soHuuRieng);
            lstTxt2.Add(M04_txt_RSX_tuTrong);
            lstTxt2.Add(M04_txt_NO_thsd);
            lstTxt2.Add(M04_txt_CLN_thsd);
            lstTxt2.Add(M04_txt_RSX_thsd);


            lstTxt2.Add(M04_txt_CLN_dt);
            for (int i = 0; i < lstTxt.Count; i++)
            {
                if (string.IsNullOrEmpty(lstTxt[i].Text) || lstTxt[i].Text == placeholder)
                {
                    MessageBox.Show("Phải điền đấy đầy đủ thông tin!");
                    return;
                }
            }
            for (int j = 0; j < lstTxt2.Count; j++)
            {
                if (lstTxt2[j].Text == "" || lstTxt2[j].Text == placeholder)
                {
                    lstTxt2[j].Text = 0.ToString();
                }
            }

            BIEUMAU_M04 _bm = new BIEUMAU_M04();

            _bm.DENGHIKHAC          = M04_txt_deNghiKhac.Text;
            _bm.DIACHI_NVD          = M04_NSD_txt_diaChi.Text;
            _bm.DIACHI_THUADAT      = M04_txt_diaChiDat.Text;
            _bm.DTSAN_NO            = float.Parse(M04_txt_NO_dtSan.Text);
            _bm.DTXAYDUNG_NO        = float.Parse(M04_txt_NO_dtXD.Text);
            _bm.DT_CLN              = float.Parse(M04_txt_CLN_dt.Text);
            _bm.DT_RSX              = float.Parse(M04_txt_RSX_dienTich.Text);
            _bm.DT_TD               = float.Parse(M04_txt_dtDat.Text);
            _bm.GIAYTOKEMTHEO       = Mau04_txt_giayTokemTheo.Text;
            _bm.HOTEN_NVD           = M04_NSD_txt_hoTen.Text;
            _bm.ID_LOAIBIEUMAU      = 4;
            _bm.KETCAU_NO           = M04_txt_NO_ketCau.Text;
            _bm.KINHGUI             = M04_txt_kinhGui.Text;
            _bm.CUA_TD              = M04_txt_cua.Text;
            _bm.QUYENSUDUNGHANCHESO = int.Parse(M04_txt_sdHanChe.Text);
            _bm.NDQUYENSD_TD        = M04_txt_ndQuyenSD.Text;
            _bm.LOAICAY_CLN         = M04_txt_CLN_loaicay.Text;
            _bm.LOAICAY_RSX         = M04_txt_RSX_loaiCay.Text;
            _bm.LOAINHAO_NO         = M04_txt_NO_loaiNhaO.Text;
            _bm.TUTHOIDIEM_TD       = DateTime.Parse(M04_dtp_tuThoiDiem.Value.ToString("MM/dd/yyyy"));
            _bm.NGAYVIETDON         = DateTime.Parse(M04_dtp_NgayVD.Value.ToString("MM/dd/yyyy"));
            _bm.NHU_CAU_GHI_NO      = M04_txt_nhuCauGhiNo.Text;
            _bm.QUYENSO             = int.Parse(M04_txt_quyenSo.Text);
            _bm.SDCHUNG_RSX         = float.Parse(M04_txt_RSX_soHuuChung.Text);
            _bm.SDRIENG_RSX         = float.Parse(M04_txt_RSX_soHuuRieng.Text);
            _bm.SHCHUNG_CLN         = float.Parse(M04_txt_CLN_soHuuChung.Text);
            _bm.SHRIENG_CLN         = float.Parse(M04_txt_CLN_soHuuRieng.Text);
            _bm.SHCHUNG_NO          = float.Parse(M04_txt_NO_soHuuChung.Text);
            _bm.SHRIENG_NO          = float.Parse(M04_txt_NO_soHuuRieng.Text);
            _bm.SHRIENG_TD          = float.Parse(M04_txt_suDungRieng.Text);
            _bm.SHCHUNG_TD          = float.Parse(M04_txt_suDungChung.Text);
            _bm.SO                 = M04_NSD_txt_so.Text;
            _bm.SOTANG_NO          = int.Parse(M04_txt_NO_soTang.Text);
            _bm.THOIHANDENGHISD_TD = M04_txt_tgdenghiSDD.Text;
            _bm.THOIHANSDDEN_CLN   = M04_txt_CLN_thsd.Text;
            _bm.THOIHANSDDEN_NO    = M04_txt_NO_thsd.Text;
            _bm.THOIHANSDDEN_RSX   = M04_txt_RSX_thsd.Text;
            _bm.THUADATSO          = int.Parse(M04_txt_thuaDatSo.Text);
            _bm.TOBANDOSO          = M04_txt_toBanDoSo.Text;
            _bm.TT_XOA             = false;
            _bm.TT_XUAT            = false;
            _bm.MUCDICHSD          = M04_txt_suDungMD.Text;
            _bm.NGUONGOC_TD        = M04_txt_nguonGocSD.Text;
            if (dal.saveInfo_M04(_bm))
            {
                MessageBox.Show("Lưu thành công!");
            }
            else
            {
                MessageBox.Show("Lưu thất bại, vui lòng thử lại!");
            }
        }
コード例 #4
0
        public bool saveInfo_M04(BIEUMAU_M04 bm)
        {
            BIEUMAU_M04 _bm = new BIEUMAU_M04();

            try
            {
                if (bm.DTSAN_NO != 0)
                {
                    _bm.DTSAN_NO = bm.DTSAN_NO;
                }
                if (bm.DTXAYDUNG_NO != 0)
                {
                    _bm.DTXAYDUNG_NO = bm.DTXAYDUNG_NO;
                }
                if (bm.DT_CLN != 0)
                {
                    _bm.DT_CLN = bm.DT_CLN;
                }
                if (bm.DT_RSX != 0)
                {
                    _bm.DT_RSX = bm.DT_RSX;
                }

                if (bm.SDCHUNG_RSX != 0)
                {
                    _bm.SDCHUNG_RSX = bm.SDCHUNG_RSX;
                }
                if (bm.SDRIENG_RSX != 0)
                {
                    _bm.SDRIENG_RSX = bm.SDRIENG_RSX;
                }
                if (bm.SHCHUNG_CLN != 0)
                {
                    _bm.SHCHUNG_CLN = bm.SHCHUNG_CLN;
                }
                if (bm.SHCHUNG_NO != 0)
                {
                    _bm.SHCHUNG_NO = bm.SHCHUNG_NO;
                }
                if (bm.SHRIENG_NO != 0)
                {
                    _bm.SHRIENG_NO = bm.SHRIENG_NO;
                }
                if (bm.THOIHANSDDEN_CLN != "0")
                {
                    _bm.THOIHANSDDEN_CLN = bm.THOIHANSDDEN_CLN;
                }
                if (bm.THOIHANSDDEN_NO != "0")
                {
                    _bm.THOIHANSDDEN_NO = bm.THOIHANSDDEN_NO;
                }
                if (bm.THOIHANSDDEN_RSX != "0")
                {
                    _bm.THOIHANSDDEN_RSX = bm.THOIHANSDDEN_RSX;
                }
                if (bm.KETCAU_NO != "0")
                {
                    _bm.KETCAU_NO = bm.KETCAU_NO;
                }
                if (bm.LOAICAY_CLN != "0")
                {
                    _bm.LOAICAY_CLN = bm.LOAICAY_CLN;
                }
                if (bm.LOAICAY_RSX != "0")
                {
                    _bm.LOAICAY_RSX = bm.LOAICAY_RSX;
                }
                if (bm.LOAINHAO_NO != "0")
                {
                    _bm.LOAINHAO_NO = bm.LOAINHAO_NO;
                }
                if (bm.SOTANG_NO != 0)
                {
                    _bm.SOTANG_NO = bm.SOTANG_NO;
                }
                _bm.DT_TD              = bm.DT_TD;
                _bm.SHRIENG_TD         = bm.SHRIENG_TD;
                _bm.SHCHUNG_TD         = bm.SHCHUNG_TD;
                _bm.DENGHIKHAC         = bm.DENGHIKHAC;
                _bm.DIACHI_NVD         = bm.DIACHI_NVD;
                _bm.DIACHI_THUADAT     = bm.DIACHI_THUADAT;
                _bm.GIAYTOKEMTHEO      = bm.GIAYTOKEMTHEO;
                _bm.HOTEN_NVD          = bm.HOTEN_NVD;
                _bm.ID_LOAIBIEUMAU     = bm.ID_LOAIBIEUMAU;
                _bm.KINHGUI            = bm.KINHGUI;
                _bm.NGAYVIETDON        = bm.NGAYVIETDON;
                _bm.NHU_CAU_GHI_NO     = bm.NHU_CAU_GHI_NO;
                _bm.QUYENSO            = bm.QUYENSO;
                _bm.SO                 = bm.SO;
                _bm.THOIHANDENGHISD_TD = bm.THOIHANDENGHISD_TD;

                _bm.THUADATSO           = bm.THUADATSO;
                _bm.TOBANDOSO           = bm.TOBANDOSO;
                _bm.TT_XOA              = bm.TT_XOA;
                _bm.TT_XUAT             = bm.TT_XUAT;
                _bm.MUCDICHSD           = bm.MUCDICHSD;
                _bm.TUTHOIDIEM_TD       = bm.TUTHOIDIEM_TD;
                _bm.NGUONGOC_TD         = bm.NGUONGOC_TD;
                _bm.QUYENSUDUNGHANCHESO = bm.QUYENSUDUNGHANCHESO;
                _bm.CUA_TD              = bm.CUA_TD;
                _bm.NDQUYENSD_TD        = bm.NDQUYENSD_TD;
                db.BIEUMAU_M04s.InsertOnSubmit(_bm);
                db.SubmitChanges();
                return(true);
            }
            catch (Exception e) {
                return(false);
            }
        }