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