public List <ChiTietHDBH> ChiTietHDBH_GetByTop(string Top, string Where, string Order) { List <ChiTietHDBH> list = new List <ChiTietHDBH>(); using (SqlCommand dbCmd = new SqlCommand("sp_ChiTietHDBH_getByTop", openConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); dr.Close(); dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ChiTietHDBH obj = new ChiTietHDBH(); obj.ChiTietHDBHIDataReader(dr); list.Add(obj); } } dr.Close(); } return(list); }
public bool ChiTietHDBH_Update(ChiTietHDBH data) { bool check = false; try { using (SqlCommand dbCmd = new SqlCommand("sp_ChiTietHDBH_Update", openConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@MaHDBH", data.MaHDBH)); dbCmd.Parameters.Add(new SqlParameter("@SoLuong", data.SoLuongMua)); dbCmd.Parameters.Add(new SqlParameter("@GiaBan", data.GiaBan)); dbCmd.Parameters.Add(new SqlParameter("@MaHH", data.MaHH)); int r = dbCmd.ExecuteNonQuery(); if (r > 0) { check = true; } } } catch { } return(check); }
public List <ChiTietHDBH> HoaDonBanHang_Query(string top, string where, string order) { List <ChiTietHDBH> list = new List <ChiTietHDBH>(); string query = "select tb_HDBanHang.*, tb_CTHDBanHang.SoLuong, tb_CTHDBanHang.GiaBan, tb_CTHDBanHang.MaHH, tb_HangHoa.TenHH," + " tb_HangHoa.MaLoai, tb_LoaiHangHoa.TenLoai from tb_HDBanHang, tb_CTHDBanHang, tb_HangHoa, tb_LoaiHangHoa " + "where tb_HDBanHang.MaHDBH = tb_CTHDBanHang.MaHDBH and tb_CTHDBanHang.MaHH = tb_HangHoa.MaHH and" + " tb_HangHoa.MaLoai = tb_LoaiHangHoa.MaLoai " + where; using (SqlCommand dbCmd = new SqlCommand(query, openConnection())) { SqlDataReader dr = dbCmd.ExecuteReader(); dr.Close(); dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ChiTietHDBH obj = new ChiTietHDBH(); obj.ChiTietHDBHIDataReader(dr); list.Add(obj); } } dr.Close(); } return(list); }