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(); }
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); } }