//tính tổng tiền
public float tongtien(String manv)
{
float tongtien = 0;
List <giohangDTO> listgiohang = new List <giohangDTO>();
DataTable data = new DataTable();
String query = @"select GIOHANG.MaHH,HANGHOA.TenHH,GIOHANG.SoLuong,HANGHOA.DonGia,GIOHANG.manv from giohang join hanghoa on HANGHOA.MaHH=GIOHANG.MaHH where GIOHANG.MaNV = '" + manv + "'";
data = SQLconnect.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
giohangDTO gh = new giohangDTO(item);
tongtien = tongtien + gh.Thanhtien;
}
return(tongtien);
}
//
public List <giohangDTO> showALLGiohang()
{
List <giohangDTO> listgiohang = new List <giohangDTO>();
DataTable data = new DataTable();
String query = @"select GIOHANG.MaHH,HANGHOA.TenHH,GIOHANG.SoLuong,HANGHOA.DonGia,GIOHANG.manv from giohang join hanghoa on HANGHOA.MaHH=GIOHANG.MaHH";
data = SQLconnect.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
giohangDTO gh = new giohangDTO(item);
listgiohang.Add(gh);
}
return(listgiohang);
}
//tìm kiếm
public List <giohangDTO> timkiem(String noidung)
{
List <giohangDTO> listgiohang = new List <giohangDTO>();
DataTable data = new DataTable();
String query = String.Format("select GIOHANG.MaHH,HANGHOA.TenHH,GIOHANG.SoLuong,HANGHOA.DonGia,GIOHANG.manv from giohang join hanghoa on HANGHOA.MaHH=GIOHANG.MaHH where HANGHOA.TenHH like '%{0}%' or GIOHANG.SoLuong like '%{0}%' or HANGHOA.DonGia like '%{0}%' or GIOHANG.manv like '%{0}%'", noidung);
data = SQLconnect.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
giohangDTO gh = new giohangDTO(item);
listgiohang.Add(gh);
}
return(listgiohang);
}
