public ChiTietHoaDonBan GetOneCTHDN(string id)
{
DataTable dt = db.GetData("SELECT * FROM chiTietHoaDonBan WHERE maHoaDonBan='" + id + "'");
ChiTietHoaDonBan l = new ChiTietHoaDonBan();
l.maHoaDonBan = int.Parse(dt.Rows[0][0].ToString());
l.maSp = dt.Rows[0][1].ToString();
l.soLuong = int.Parse(dt.Rows[0][2].ToString());
l.giaBan = int.Parse(dt.Rows[0][3].ToString());
return(l);
}
public List <ChiTietHoaDonBan> GetAllCTHDN()
{
DataTable dt = db.GetData("SELECT * FROM chiTietHoaDonBan");
List <ChiTietHoaDonBan> li = new List <ChiTietHoaDonBan>();
foreach (DataRow dr in dt.Rows)
{
ChiTietHoaDonBan l = new ChiTietHoaDonBan();
l.maHoaDonBan = int.Parse(dr[0].ToString());
l.maSp = dr[1].ToString();
l.soLuong = int.Parse(dr[2].ToString());
l.giaBan = int.Parse(dr[3].ToString());
li.Add(l);
}
return(li);
}
public List <ChiTietHoaDonBan> Thongke(string ngay, string thang, string nam)
{
DataTable dt = db.GetData("SELECT HD.ngayBan, CT.maSp, SP.tenSP, CT.giaBan, CT.soLuong FROM HoaDonBan HD INNER JOIN chiTietHoaDonBan CT INNER JOIN DienThoai SP ON SP.maSp = CT.maSp ON HD.maHoaDonBan = CT.maHoaDonBan WHERE DAY(HD.ngayBan) = '" + ngay + "' AND MONTH(HD.ngayBan) = '" + thang + "' AND YEAR(HD.ngayBan) = '" + nam + "'");
List <ChiTietHoaDonBan> li = new List <ChiTietHoaDonBan>();
foreach (DataRow dr in dt.Rows)
{
ChiTietHoaDonBan l = new ChiTietHoaDonBan();
l.ngayBan = dr[0].ToString();
l.maSp = dr[1].ToString();
l.tenSp = dr[2].ToString();
l.giaBan = int.Parse(dr[3].ToString());
l.soLuong = int.Parse(dr[4].ToString());
li.Add(l);
}
return(li);
}
public List <ChiTietHoaDonBan> GetListChiTiet(string id)
{
DataTable dt = db.GetData("SELECT CT.*, DT.tenSp, DT.hinhAnh FROM chiTietHoaDonBan CT INNER JOIN DienThoai DT ON CT.maSp = DT.maSp WHERE maHoaDonBan = '" + id + "'");
List <ChiTietHoaDonBan> li = new List <ChiTietHoaDonBan>();
foreach (DataRow dr in dt.Rows)
{
ChiTietHoaDonBan l = new ChiTietHoaDonBan();
l.maHoaDonBan = int.Parse(dr[0].ToString());
l.maSp = dr[1].ToString();
l.soLuong = int.Parse(dr[2].ToString());
l.giaBan = int.Parse(dr[3].ToString());
l.tenSp = dr[4].ToString();
l.hinhAnh = dr[5].ToString();
li.Add(l);
}
return(li);
}
public void themCTHDN(ChiTietHoaDonBan x)
{
string sql = "INSERT INTO chiTietHoaDonBan VALUES('" + x.maHoaDonBan + "','" + x.maSp + "','" + x.soLuong + "', '" + x.giaBan + "')";
db.WriteData(sql);
}