public void luuCTHD(DTO_HDNH hd)
{
sql = "INSERT INTO CTHDNHAP VALUES (@mahd, @mahh, @sl, @thanhtien)";
conn.Open();
cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@mahd", hd.Mahd);
cmd.Parameters.AddWithValue("@mahh", hd.Mahh);
cmd.Parameters.AddWithValue("@sl", hd.SL);
cmd.Parameters.AddWithValue("@thanhtien", hd.Thanhtien);
cmd.ExecuteNonQuery();
conn.Close();
}
public void luuHD(DTO_HDNH hd)
{
sql = "INSERT INTO HDNHAPHH VALUES(@mahd, @ngay, @manv, @tongtien)";
conn.Open();
cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@mahd", hd.Mahd);
cmd.Parameters.AddWithValue("@ngay", hd.NgayNhap);
cmd.Parameters.AddWithValue("@manv", hd.Manv);
cmd.Parameters.AddWithValue("@tongtien", hd.TongTien);
cmd.ExecuteNonQuery();
conn.Close();
}
public List <DTO_HDNH> autoComplete(DTO_HDNH hd)
{
List <DTO_HDNH> giatri = new List <DTO_HDNH>();
sql = "SELECT TENHH FROM HANGHOA";
conn.Open();
cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
hd.Ten = dr[0].ToString();
giatri.Add(hd);
}
conn.Close();
return(giatri);
}
public List <DTO_HDNH> timGiaVaMa(DTO_HDNH hd)
{
List <DTO_HDNH> giatri = new List <DTO_HDNH>();
sql = "SELECT DONGIA, MAHH FROM HANGHOA WHERE TENHH = N'" + hd.Ten + "'";
conn.Open();
cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
hd.DonGia = int.Parse(dr[0].ToString());
hd.Mahh = int.Parse(dr[1].ToString());
giatri.Add(hd);
}
conn.Close();
return(giatri);
}
public List <DTO_HDNH> auto(DTO_HDNH hd)
{
return(dao.autoComplete(hd));
}
public List <DTO_HDNH> timGiaVaMa(DTO_HDNH hd)
{
return(dao.timGiaVaMa(hd));
}
public void luuCTHD(DTO_HDNH hd)
{
dao.luuCTHD(hd);
}
