Ejemplo n.º 1
0
        private void cmdSave_Click(object sender, EventArgs e)
        {
            if (!Isvalidata())
            {
                return;
            }
            var objDmucKhachhang = new KskDmucKhachhang();

            if (MEnAction == action.Insert)
            {
                objDmucKhachhang.IsNew    = true;
                objDmucKhachhang.NgayTao  = globalVariables.SysDate;
                objDmucKhachhang.NguoiTao = globalVariables.UserName;
            }
            else
            {
                objDmucKhachhang.MarkOld();
                objDmucKhachhang.IsLoaded = true;
                objDmucKhachhang.NgaySua  = globalVariables.SysDate;
                objDmucKhachhang.NguoiSua = globalVariables.UserName;
            }
            objDmucKhachhang.MaKhachHang  = Utility.sDbnull(txtMaKhachHang.Text, "");
            objDmucKhachhang.TenKhachHang = Utility.sDbnull(txtTenKhachHang.Text);
            objDmucKhachhang.DiaChi       = Utility.sDbnull(txtDiaChi.Text, "");
            objDmucKhachhang.MaSoThue     = Utility.sDbnull(txtMaSoThue.Text, "");
            objDmucKhachhang.NguoiDaiDien = Utility.sDbnull(txtNguoiDaiDien.Text, "");
            objDmucKhachhang.SoDienThoai  = Utility.sDbnull(txtSoDienThoai.Text, "");
            objDmucKhachhang.SoHopDong    = Utility.sDbnull(txtSohopDong.Text, "");
            objDmucKhachhang.NgayHopDong  = dtpNgayHopDong.Value;
            objDmucKhachhang.TrangThai    = Utility.ByteDbnull(chkTrangThai.Checked);
            objDmucKhachhang.SttHienThi   = Utility.Int16Dbnull(txtStthienThi.Text, 100);
            objDmucKhachhang.Save();
            txtIdKhachHang.Text = Utility.sDbnull(objDmucKhachhang.IdKhachHang);
            if (MEnAction == action.Insert)
            {
                ThemMoiLenLuoi();
            }
            else
            {
                UpdateLenLuoi();
            }
            if (chkThemMoiLienTuc.Checked)
            {
                ClearControl();
                MEnAction       = action.Insert;
                lblMessage.Text = MEnAction == action.Insert ? @"Thêm mới thành công" : @"Cập nhật thành công";
            }
            else
            {
                MEnAction       = action.Update;
                lblMessage.Text = MEnAction == action.Insert ? @"Thêm mới thành công" : @"Cập nhật thành công";
            }
            ModifyCommand();
        }
Ejemplo n.º 2
0
        private void GetData()
        {
            var objDmucKhachhang = new KskDmucKhachhang();

            objDmucKhachhang =
                new Select().From(KskDmucKhachhang.Schema)
                .Where(KskDmucKhachhang.Columns.IdKhachHang)
                .IsEqualTo(Utility.Int32Dbnull(txtIdKhachHang.Text))
                .ExecuteSingle <KskDmucKhachhang>();
            if (objDmucKhachhang != null)
            {
                txtMaKhachHang.Text  = Utility.sDbnull(objDmucKhachhang.MaKhachHang);
                txtTenKhachHang.Text = Utility.sDbnull(objDmucKhachhang.TenKhachHang);
                txtDiaChi.Text       = Utility.sDbnull(objDmucKhachhang.DiaChi);
                txtSoDienThoai.Text  = Utility.sDbnull(objDmucKhachhang.SoDienThoai);
                txtNguoiDaiDien.Text = Utility.sDbnull(objDmucKhachhang.NguoiDaiDien);
                txtMaSoThue.Text     = Utility.sDbnull(objDmucKhachhang.MaSoThue);
                txtSohopDong.Text    = Utility.sDbnull(objDmucKhachhang.SoHopDong);
                chkTrangThai.Checked = Utility.Byte2Bool(objDmucKhachhang.TrangThai);
                txtStthienThi.Text   = Utility.sDbnull(objDmucKhachhang.SttHienThi);
                dtpNgayHopDong.Value = Convert.ToDateTime(objDmucKhachhang.NgayHopDong);
            }
        }