public static bool SuaCTTTDaTonTai(GhiKQVaoPKDTO SuaDTO) { string sTruyVan = string.Format("update CTTT set TenThuoc= N'{0}', SoLuong='{1}', DonGia ={2}, CachDung=N'{3}', TrangThai = '1' where MaPK='{4}' and TenThuoc=N'{5}' ", SuaDTO.Tenthuoc, SuaDTO.Soluong, SuaDTO.Dongia, SuaDTO.Cachdung, SuaDTO.Mapk, SuaDTO.Tenthuoc); Con = DataProvider.KetNoi(); try { // thuc thi truy van bool KetQua = DataProvider.ThucThiNonQuery(sTruyVan, Con); // dong truy van DataProvider.DongKetNoi(Con); if (KetQua == true) { return(true); } else { return(false); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); DataProvider.DongKetNoi(Con); return(false); } }
public static List <TaiKhoan_DTO> LayDSTK() { string sTruyVan = "select * from TAIKHOAN"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <TaiKhoan_DTO> lstSach = new List <DTO.TaiKhoan_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { TaiKhoan_DTO TK = new TaiKhoan_DTO(); TK.ID = int.Parse(dt.Rows[i]["ID"].ToString()); TK.TaiKhoan = dt.Rows[i]["TaiKhoan"].ToString(); TK.TenHienThi = dt.Rows[i]["TenHienThi"].ToString(); TK.MauKhau = dt.Rows[i]["MatKhau"].ToString(); TK.QuyenHan = dt.Rows[i]["QuyenHan"].ToString(); lstSach.Add(TK); } DataProvider.DongKetNoi(con); return(lstSach); }
public static List <CTMuonTra_DTO> LayDSCTMuonTra() { string sTruyVan = "select * from CTMuonTra"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <CTMuonTra_DTO> lstCTMuonTra = new List <DTO.CTMuonTra_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { CTMuonTra_DTO CTMT = new CTMuonTra_DTO(); CTMT.ID = int.Parse(dt.Rows[i]["ID"].ToString()); CTMT.MaMuonTra = dt.Rows[i]["MaMuonTra"].ToString(); CTMT.MaSach = dt.Rows[i]["TenSach"].ToString(); CTMT.DaTra = dt.Rows[i]["DaTra"].ToString(); CTMT.NgayTra = dt.Rows[i]["NgayTra"].ToString(); CTMT.GhiChu = dt.Rows[i]["GhiChu"].ToString(); lstCTMuonTra.Add(CTMT); } DataProvider.DongKetNoi(con); return(lstCTMuonTra); }
public static bool XoaCTTT(GhiKQVaoPKDTO a) { string sTruyVan = string.Format("update CTTT set TrangThai = '0' where MaPK='{0}' and TenThuoc=N'{1}' ", a.Mapk, a.Tenthuoc); Con = DataProvider.KetNoi(); try { // thuc thi truy van bool KetQua = DataProvider.ThucThiNonQuery(sTruyVan, Con); // dong truy van DataProvider.DongKetNoi(Con); if (KetQua == true) { return(true); } else { return(false); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); DataProvider.DongKetNoi(Con); return(false); } }
public static List <Sach_DTO> LayDSSach() { string sTruyVan = "select * from SACH"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <Sach_DTO> lstSach = new List <DTO.Sach_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { Sach_DTO s = new Sach_DTO(); s.MaSach = dt.Rows[i]["MaSach"].ToString(); s.TenSach = dt.Rows[i]["TenSach"].ToString(); s.TheLoai = dt.Rows[i]["TheLoai"].ToString(); s.TinhTrang = dt.Rows[i]["TinhTrang"].ToString(); s.SoLuong = dt.Rows[i]["SoLuong"].ToString(); s.NhaXB = dt.Rows[i]["NXB"].ToString(); s.NamXB = dt.Rows[i]["NamXB"].ToString(); s.TacGia = dt.Rows[i]["TacGia"].ToString(); lstSach.Add(s); } DataProvider.DongKetNoi(con); return(lstSach); }
// sửa học sinh public static bool SuaHS(HocSinhDTO hs) { try { string sTruyVan = string.Format("update tblHocSinh set HoTen=N'{0}', IDLop={1}, NgaySinh={2}, GioiTinh=N'{3}', DiaChi=N'{4}', SDT={5} where IDHocSinh={6}", hs.HoTen, hs.IDLop, hs.NgaySinh, hs.GioiTinh, hs.DiaChi, hs.SDT, hs.IDHocSinh); con = DataProvider.KetNoi(); DataProvider.ThucThiTruyVan(sTruyVan, con); string s = string.Format("update tblLop set SoLuong=(select COUNT(IDHocSinh) from tblHocSinh where IDLop={0}) where IDLop={0}", hs.IDLop); DataProvider.ThucThiTruyVan(s, con); DataProvider.DongKetNoi(con); return(true); } catch { return(false); } }
public GhiKQVaoPKDTO LayGiaThuoc(GhiKQVaoPKDTO a) { string sTruyVan = " select Gia from THUOC where TenThuoc = N'" + a.Tenthuoc + "'"; // Mo Kết Nối Con = DataProvider.KetNoi(); // Tiến Hành Truy Vấn DataTable dt = DataProvider.LoadTable(sTruyVan, Con); if (dt.Rows.Count == 0) { return(null); } if (dt.Rows.Count == 1) { GhiKQVaoPKDTO gkqdto = new GhiKQVaoPKDTO(); gkqdto.Gia = float.Parse(dt.Rows[0]["Gia"].ToString()); DataProvider.DongKetNoi(Con); return(gkqdto); } else { DataProvider.DongKetNoi(Con); return(null); } }
// Tìm ds nhân viên theo tên, trả về null nếu không thấy public static List <NhanVien_DTO> TimNhanVienTheoTen(string ten) { string sTruyVan = string.Format(@"select * from nhanvien where tennv like '%{0}%'", ten); con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <NhanVien_DTO> lstNhanVien = new List <DTO.NhanVien_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { NhanVien_DTO nv = new NhanVien_DTO(); nv.SMaNV = dt.Rows[i]["manv"].ToString(); nv.SHoLot = dt.Rows[i]["holot"].ToString(); nv.STen = dt.Rows[i]["tennv"].ToString(); nv.SPhai = dt.Rows[i]["phai"].ToString(); nv.DtNgaySinh = DateTime.Parse(dt.Rows[i]["ngaysinh"].ToString()); nv.SMaCV = dt.Rows[i]["macv"].ToString(); lstNhanVien.Add(nv); } DataProvider.DongKetNoi(con); return(lstNhanVien); }
public static bool KiemTraTienDo(string idpost, string taikhoan) { try { con = DataProvider.KetNoi(); string sTruyVan = string.Format("select TongComment-TienDo as kt from tblWork where IDPost='{0}' and TaiKhoan=N'{1}'", idpost, taikhoan); DataTable dt = DataProvider.LayDataTable(sTruyVan, con); DataProvider.DongKetNoi(con); if (dt.Rows[0]["kt"].ToString() != "0") { return(true); } else { con = DataProvider.KetNoi(); sTruyVan = string.Format("update tblWork set TrangThai=N'Hoàn tất' where IDPost='{0}'", idpost); DataProvider.ThucThiTruyVanNonQuery(sTruyVan, con); DataProvider.DongKetNoi(con); return(false); } } catch { return(false); } }
// Them CTTT public static bool ThemCTTT(GhiKQVaoPKDTO gkqDTO) { //string sTruyVan = string.Format("insert into CTTT values (N'{0}',N'{1}','{2}','{3}', '1')", gkqDTO.Mapk, gkqDTO.Tenthuoc, gkqDTO.Soluong, gkqDTO.Cachdung, gkqDTO.Trangthai); string sTruyVan = string.Format("INSERT INTO CTTT (MaPK, TenThuoc, SoLuong, DonGia, CachDung, TrangThai) VALUES('{0}',N'{1}','{2}','{3}', N'{4}', '1')", gkqDTO.Mapk, gkqDTO.Tenthuoc, gkqDTO.Soluong, gkqDTO.Dongia, gkqDTO.Cachdung, gkqDTO.Trangthai); Con = DataProvider.KetNoi(); try { // thuc thi truy van bool KetQua = DataProvider.ThucThiNonQuery(sTruyVan, Con); // dong ket noi DataProvider.DongKetNoi(Con); if (KetQua == true) { return(true); } else { return(false); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); DataProvider.DongKetNoi(Con); return(false); } }
//Them Nhan Vien Moi & Login moi cho nhan vien do public static bool ThemNhanVien(NhanVien_DTO nvDTO) { try { //Them Nhan Vien vao tblNhanVien string strTruyVan1 = "INSERT INTO NHANVIEN(HOTEN_NV,NS_NV,GT_NV,SDT_NV,DIACHI_NV,NGAYVAOLAM,MA_CV)VALUES(@HOTEN_NV,@NS_NV,@GT_NV,@SDT_NV,@DIACHI_NV,@NGAYVAOLAM,@MA_CV)"; con = new SqlConnection(strChuoiKetNoi); SqlCommand cmd = new SqlCommand(strTruyVan1, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HOTEN_NV", nvDTO.StrHoTenNV); cmd.Parameters.AddWithValue("@NS_NV", nvDTO.StrNSNV); cmd.Parameters.AddWithValue("@GT_NV", nvDTO.StrGTNV); cmd.Parameters.AddWithValue("@SDT_NV", nvDTO.StrSDTNV); cmd.Parameters.AddWithValue("@DIACHI_NV", nvDTO.StrDiaChiNV); cmd.Parameters.AddWithValue("@NGAYVAOLAM", nvDTO.StrNgayLam); cmd.Parameters.AddWithValue("@MA_CV", nvDTO.StrMaCV); cmd.ExecuteNonQuery(); ////Them user pass quyen vao tblLogin //string strTruyVan2 = string.Format("INSERT INTO LOGIN(MA_NV,USERNAME, PASS,QUYEN) VALUES ((SELECT MAX(MA_NV) FROM NHANVIEN),'{1}','{2}','{3}')", // nvDTO.StrMaNV, nvDTO.StrUsername, nvDTO.StrPassword, nvDTO.StrQuyen); //con = DataProvider.MoKetNoi(); //DataProvider.ThucThiTruyVanNonQuery(strTruyVan2, con); return(true); } catch (Exception) { return(false); } finally { DataProvider.DongKetNoi(con); } }
public static List <KhachHang_DTO> takeCustomersFID(string id) { string sQuery = @"select k.* from Phong p, KhachHang k WHERE p.MaPhong= k.MaPhong And p.MaPhong = '" + id + "' "; //where p.MaPhong = k.MaPhong AND p.MaPhong = 'P003' conn = DataProvider.Connect(); DataTable dt = DataProvider.dataSQuery(sQuery, conn); if (dt.Rows.Count == 0) { return(null); } List <KhachHang_DTO> Cus = new List <KhachHang_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { KhachHang_DTO K = new KhachHang_DTO(); K.MaKH = dt.Rows[i]["MaKH"].ToString(); K.TenKH = dt.Rows[i]["TenKH"].ToString(); K.Cmnd = int.Parse(dt.Rows[i]["CMND"].ToString()); K.QuocTich = dt.Rows[i]["QuocTich"].ToString(); K.GioiTinh = dt.Rows[i]["GioiTinh"].ToString(); K.NgaySinh = DateTime.Parse(dt.Rows[i]["NgaySinh"].ToString()); K.Sdt = int.Parse(dt.Rows[i]["SDT"].ToString()); K.MaPhong = dt.Rows[i]["MaPhong"].ToString(); Cus.Add(K); } DataProvider.DongKetNoi(conn); return(Cus); }
public static List <NhanVien_DTO> LayDSNhanVien() { string sTruyVan = "select * from NHANVIEN"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <NhanVien_DTO> lstNhanVien = new List <DTO.NhanVien_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { NhanVien_DTO nv = new NhanVien_DTO(); nv.MaNV = dt.Rows[i]["MaNV"].ToString(); nv.TenNV = dt.Rows[i]["TenNV"].ToString(); nv.NgaySinh = Convert.ToDateTime(dt.Rows[i]["NgaySinh"]); nv.NgayVaoLam = Convert.ToDateTime(dt.Rows[i]["NgayVaoLam"]); nv.GioiTinh = dt.Rows[i]["Gioitinh"].ToString(); nv.DiaChi = dt.Rows[i]["DiaChiNV"].ToString(); nv.DienThoai = dt.Rows[i]["DienThoai"].ToString(); lstNhanVien.Add(nv); } DataProvider.DongKetNoi(con); return(lstNhanVien); }
// Load CTTT public static List <GhiKQVaoPKDTO> LoadCTTT(GhiKQVaoPKDTO a) { // Khai báo truy vấn SQL string sTruyVan = " select CTTT.TenThuoc, CTTT.SoLuong, THUOC.DonViTinh, CTTT.CachDung from CTTT, THUOC where CTTT.TenThuoc = THUOC.TenThuoc and CTTT.TrangThai = '1' and CTTT.MaPK = '" + a.Mapk + "'"; // Mo Kết Nối Con = DataProvider.KetNoi(); // Tiến Hành Truy Vấn DataTable dt = DataProvider.LoadTable(sTruyVan, Con); if (dt.Rows.Count == 0) { return(null); } //tạo list GhiKetQuaVaoPhieuKham_DTO List <GhiKQVaoPKDTO> listgkqdto = new List <GhiKQVaoPKDTO>(); for (int i = 0; i < dt.Rows.Count; i++) { GhiKQVaoPKDTO dto = new GhiKQVaoPKDTO(); dto.Tenthuoc = dt.Rows[i]["TenThuoc"].ToString(); dto.Soluong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); dto.Donvitinh = dt.Rows[i]["DonViTinh"].ToString(); dto.Cachdung = dt.Rows[i]["CachDung"].ToString(); listgkqdto.Add(dto); } DataProvider.DongKetNoi(Con); return(listgkqdto); }
// Lấy quá trình lương theo khoảng thời gian public static List <QuaTrinhLuong_DTO> LayQuaTrinhLuongTheoNgay(DateTime ngbd, DateTime ngkt) { string sTruyVan = string.Format(@"select * from quatrinhluong where ngaybd between '{0}' and '{1}'", ngbd, ngkt); con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <QuaTrinhLuong_DTO> lstQTLuong = new List <QuaTrinhLuong_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { QuaTrinhLuong_DTO qtl = new QuaTrinhLuong_DTO(); qtl.SMaNV = dt.Rows[i]["manv"].ToString(); qtl.DtNgayBD = DateTime.Parse(dt.Rows[i]["ngaybd"].ToString()); qtl.FHSLuong = float.Parse(dt.Rows[i]["hsluong"].ToString()); qtl.BGhiChu = bool.Parse(dt.Rows[i]["ghichu"].ToString()); lstQTLuong.Add(qtl); } DataProvider.DongKetNoi(con); return(lstQTLuong); }
// Lấy tất cả quá trình lương public static List <QuaTrinhLuong_DTO> LayQuaTrinhLuong() { string sTruyVan = "select q.*,n.* from quatrinhluong q,nhanvien n where q.manv=n.manv"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <QuaTrinhLuong_DTO> lstQTLuong = new List <QuaTrinhLuong_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { QuaTrinhLuong_DTO qtl = new QuaTrinhLuong_DTO(); qtl.SMaNV = dt.Rows[i]["manv"].ToString(); qtl.DtNgayBD = DateTime.Parse(dt.Rows[i]["ngaybd"].ToString()); qtl.FHSLuong = float.Parse(dt.Rows[i]["hsluong"].ToString()); qtl.BGhiChu = bool.Parse(dt.Rows[i]["ghichu"].ToString()); qtl.NvNhanVien = new NhanVien_DTO(); qtl.NvNhanVien.SHoLot = dt.Rows[i]["holot"].ToString(); qtl.NvNhanVien.STen = dt.Rows[i]["tennv"].ToString(); lstQTLuong.Add(qtl); } DataProvider.DongKetNoi(con); return(lstQTLuong); }
// Lấy thông tin nhân viên với hệ số lương đang hưởng (ghichu=1) public static List <BangLuong_DTO> LayBangLuongHienHanh() { string sTruyVan = "select n.manv, n.holot+' '+n.tennv as hoten, n.phai, n.ngaysinh, c.tencv, c.hsphucap, q.hsluong from nhanvien n, chucvu c, quatrinhluong q where n.macv=c.macv and n.manv=q.manv and q.ghichu=1"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <BangLuong_DTO> lstBangLuong = new List <DTO.BangLuong_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { BangLuong_DTO bl = new BangLuong_DTO(); bl.SMaNV = dt.Rows[i]["manv"].ToString(); bl.SHoTen = dt.Rows[i]["hoten"].ToString(); bl.SPhai = dt.Rows[i]["phai"].ToString(); bl.DtNgaySinh = DateTime.Parse(dt.Rows[i]["ngaysinh"].ToString()); bl.SChucVu = dt.Rows[i]["tencv"].ToString(); bl.FHSPhuCap = float.Parse(dt.Rows[i]["hsphucap"].ToString()); bl.FHSLuong = float.Parse(dt.Rows[i]["hsluong"].ToString()); lstBangLuong.Add(bl); } DataProvider.DongKetNoi(con); return(lstBangLuong); }
// xóa khách hàng public static bool deleteCustomers(KhachHang_DTO KH) { string sQuery = string.Format(@"delete from KhachHang where MaKH = '{0}'", KH.MaKH); bool kq = DataProvider.queryWithoutData(sQuery, conn); DataProvider.DongKetNoi(conn); return(kq); }
public static bool ThemCTMuonTra(CTMuonTra_DTO CTMT) { con = DataProvider.MoKetNoi(); string sTruyVan = @"insert into CTMuonTra values(N'" + CTMT.MaMuonTra + "',N'" + CTMT.MaSach + "',N'" + CTMT.DaTra + "',N'" + CTMT.NgayTra + "',N'" + CTMT.GhiChu + "')"; bool kq = DataProvider.TruyVanKhongLayDuLieu(sTruyVan, con); DataProvider.DongKetNoi(con); return(kq); }
public static DataTable DoanhThuTheoPhong(string maphong) { string query = string.Format("usp_doanhthutheophong @maphong =N'%{0}%'", maphong); con = DataProvider.HamKetNoi(); table = DataProvider.Load(query, con); DataProvider.DongKetNoi(con); return(table); }
public static bool ThemTL(Theloai_DTO TL) { con = DataProvider.MoKetNoi(); string sTruyVan = @"insert into TheLoai values(N'" + TL.MaLoai + "',N'" + TL.TenLoai + "')"; bool kq = DataProvider.TruyVanKhongLayDuLieu(sTruyVan, con); DataProvider.DongKetNoi(con); return(kq); }
public static bool Xoa(HoaDonNhapDTO hd) { string sTruyVan = string.Format("delete tblHoaDonNhap where MaHDNhap={0}", hd.MaHDNhap); con = DataProvider.KetNoi(); DataProvider.ThucThiTruyVan(sTruyVan, con); DataProvider.DongKetNoi(con); return(true); }
public static bool ThemNXB(NhaXuatBan_DTO NXB) { con = DataProvider.MoKetNoi(); string sTruyVan = @"insert into NhaXuatBan values(N'" + NXB.MaNXB + "',N'" + NXB.TenNXB + "')"; bool kq = DataProvider.TruyVanKhongLayDuLieu(sTruyVan, con); DataProvider.DongKetNoi(con); return(kq); }
public static bool ThemSach(Sach_DTO s) { con = DataProvider.MoKetNoi(); string sTruyVan = @"insert into SACH values(N'" + s.MaSach + "',N'" + s.TenSach + "',N'" + s.TheLoai + "',N'" + s.TinhTrang + "',N'" + s.SoLuong + "',N'" + s.NhaXB + "',N'" + s.NamXB + "',N'" + s.TacGia + "')"; bool kq = DataProvider.TruyVanKhongLayDuLieu(sTruyVan, con); DataProvider.DongKetNoi(con); return(kq); }
public static bool ThemNhanVien(NhanVien_DTO nv) { con = DataProvider.MoKetNoi(); string sTruyVan = @"insert into NhanVien values(N'" + nv.MaNV + "',N'" + nv.TenNV + "',N'" + nv.NgaySinh + "',N'" + nv.NgayVaoLam + "',N'" + nv.GioiTinh + "',N'" + nv.DiaChi + "',N'" + nv.DienThoai + "')"; bool kq = DataProvider.TruyVanKhongLayDuLieu(sTruyVan, con); DataProvider.DongKetNoi(con); return(kq); }
public static bool sua(HoaDonNhapDTO hd) { string sTruyVan = string.Format("update tblHoaDonNhap set NgayNhap='{0}',MaNhaCC={1} where MaHDNhap={2}", hd.NgayNhap, hd.MaNhaCC, hd.MaHDNhap); con = DataProvider.KetNoi(); DataProvider.ThucThiTruyVan(sTruyVan, con); DataProvider.DongKetNoi(con); return(true); }
public static bool ThemTK(TaiKhoan_DTO TK) { con = DataProvider.MoKetNoi(); string sTruyVan = @"insert into TaiKhoan values(N'" + TK.TaiKhoan + "',N'" + TK.TenHienThi + "',N'" + TK.MauKhau + "',N'" + TK.QuyenHan + "')"; bool kq = DataProvider.TruyVanKhongLayDuLieu(sTruyVan, con); DataProvider.DongKetNoi(con); return(kq); }
public static bool UpdateTongTien(ChiTietNhapDTO hh) { string sTruyVan = string.Format("update tblHoaDonNhap set TongTien=(select sum(SoLuong*DonGia) from tblChiTietNhap a where a.MaHDNhap={0}) where MaHDNhap={0}", hh.MaHDNhap); con = DataProvider.KetNoi(); DataProvider.ThucThiTruyVan(sTruyVan, con); DataProvider.DongKetNoi(con); return(true); }
public static bool them(HoaDonNhapDTO hd) { string sTruyVan = string.Format("insert into tblHoaDonNhap values ({0},'{1}',{2},{3})", hd.MaHDNhap, hd.NgayNhap, hd.TongTien, hd.MaNhaCC); con = DataProvider.KetNoi(); DataProvider.ThucThiTruyVan(sTruyVan, con); DataProvider.DongKetNoi(con); return(true); }
public static bool SuaCTMuonTra(CTMuonTra_DTO CTMT) { string sTruyVan = @"update CTMuonTra set MaMuonTra =N'" + CTMT.MaMuonTra + "',TenSach = N'" + CTMT.MaSach + "' , DaTra = N'" + CTMT.DaTra + "' , NgayTra = N'" + CTMT.NgayTra + "', GhiChu = N'" + CTMT.GhiChu + "' where ID='" + CTMT.ID + "'"; con = DataProvider.MoKetNoi(); bool kq = DataProvider.TruyVanKhongLayDuLieu(sTruyVan, con); DataProvider.DongKetNoi(con); return(kq); }