public void UpdateHDB(EC_HoaDonBan _hd)
{
string sqlquery = (@"UPDATE tb_HDB
SET manv =N'{0}', ngaylap ='{1}', makh =N'{2}', tongtien ='{3}' where sohdb=N'{4}'");
sqlquery = string.Format(sqlquery, _hd.MaNV, _hd.NgayLap, _hd.MaKH, _hd.TongTien, _hd.SoHDB);
Connect.ExcuteNonQuery(sqlquery);
}
public void AddHDB(EC_HoaDonBan _hd)
{
string sqlquery = (@"INSERT INTO tb_HDB ( sohdb, manv, ngaylap, makh, tongtien)
VALUES (N'{0}',N'{1}','{2}',N'{3}','{4}')");
sqlquery = string.Format(sqlquery, _hd.SoHDB, _hd.MaNV, _hd.NgayLap, _hd.MaKH, _hd.TongTien);
Connect.ExcuteNonQuery(sqlquery);
}
public void AddHDB(EC_HoaDonBan _hoadonban)
{
if (!sqlhoadonban.CheckHDB(_hoadonban.SoHDB))
{
sqlhoadonban.AddHDB(_hoadonban);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public DataTable CreateTbHDB(EC_HoaDonBan _hdb)
{
if (_hdb.NgayLap == "%")
{
string sqlquery = "SELECT * FROM tb_HDB where sohdb like N'%{0}%' and manv like N'%{1}%' and ngaylap like '%{2}%' and makh like '%{3}%' and tongtien like '%{4}%'";
sqlquery = string.Format(sqlquery, _hdb.SoHDB, _hdb.MaNV, _hdb.NgayLap, _hdb.MaKH, _hdb.TongTien);
return(Connect.CreateTable(sqlquery));
}
else
{
string sqlquery = "SELECT * FROM tb_HDB where sohdb like N'%{0}%' and manv like N'%{1}%' and ngaylap = '{2}' and makh like '%{3}%' and tongtien like '%{4}%'";
sqlquery = string.Format(sqlquery, _hdb.SoHDB, _hdb.MaNV, _hdb.NgayLap, _hdb.MaKH, _hdb.TongTien);
return(Connect.CreateTable(sqlquery));
}
}
public void DeleteHDB(EC_HoaDonBan _hoadonban)
{
sqlhoadonban.DeleteHDB(_hoadonban);
}
public void UpdateHDB(EC_HoaDonBan _hoadonban)
{
sqlhoadonban.UpdateHDB(_hoadonban);
}
public DataTable CreateTbHDB(EC_HoaDonBan _hdb)
{
return(sqlhoadonban.CreateTbHDB(_hdb));
}
public void DeleteHDB(EC_HoaDonBan _hd)
{
Connect.ExcuteNonQuery("DELETE FROM [tb_CTHDB] WHERE sohdb=N'" + _hd.SoHDB + "'");
Connect.ExcuteNonQuery("DELETE FROM [tb_HDB] WHERE sohdb=N'" + _hd.SoHDB + "'");
}
