public HoaDonChiTietDatHang[] LietKeHoaDonChiTietVoiMSDH(string MSDH) { HoaDonChiTietDatHang[] arrHoaDonChiTietDatHang = new HoaDonChiTietDatHang[0]; // Provide the query string with a parameter placeholder. string queryString = @"SELECT * From HDChiTietDatHang hdct INNER JOIN ThucUong thucUong ON hdct.MSHH = thucUong.MSHH Where MSDH=@MSDH"; // Specify the parameter value. string msdh = MSDH; // Create and open the connection in a using block. This // ensures that all resources will be closed and disposed // when the code exits. using (SqlConnection connection = new SqlConnection(connectionString)) { // Create the Command and Parameter objects. SqlCommand command = new SqlCommand(queryString, connection); command.Parameters.AddWithValue("@MSDH", msdh); // Open the connection in a try/catch block. // Create and execute the DataReader, writing the result // set to the console window. try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); int soLuongHoaDonChiTietDatHang = this.LietKeSoLuongHoaDonChiTietDatHangVoiMSDH(msdh); arrHoaDonChiTietDatHang = new HoaDonChiTietDatHang[soLuongHoaDonChiTietDatHang]; int i = 0; while (reader.Read()) { // Parse data to model HoaDonChiTietDatHang HoaDonChiTietDatHang mHoaDonChiTietDatHang = new HoaDonChiTietDatHang(); mHoaDonChiTietDatHang.MSDH = reader[0].ToString(); mHoaDonChiTietDatHang.MSHH = reader[1].ToString(); mHoaDonChiTietDatHang.SoLuong = int.Parse(reader[2].ToString()); mHoaDonChiTietDatHang.TiLeGiam = int.Parse(reader[3].ToString()); arrHoaDonChiTietDatHang[i] = mHoaDonChiTietDatHang; i++; } reader.Close(); } catch (Exception ex) { // Console.WriteLine(ex.Message); } // Console.ReadLine(); } return(arrHoaDonChiTietDatHang); }
public HoaDonChiTietDatHang[] LietKeHoaDonChiTiet() { HoaDonChiTietDatHang[] arrHoaDonChiTietDatHang = new HoaDonChiTietDatHang[0]; // Provide the query string with a parameter placeholder. string queryString = "SELECT * From HDChiTietDatHang"; // Create and open the connection in a using block. This // ensures that all resources will be closed and disposed // when the code exits. using (SqlConnection connection = new SqlConnection(connectionString)) { // Create the Command and Parameter objects. SqlCommand command = new SqlCommand(queryString, connection); // Open the connection in a try/catch block. // Create and execute the DataReader, writing the result // set to the console window. try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); int soLuongHoaDonChiTietDatHang = this.LietKeSoLuongHoaDonChiTietDatHang(); arrHoaDonChiTietDatHang = new HoaDonChiTietDatHang[soLuongHoaDonChiTietDatHang]; int i = 0; while (reader.Read()) { // Console.WriteLine("\t{0}\t\t\t{1}\t\t{2}\t\t{3}", // reader[0], reader[1], reader[2], reader[3]); // Parse data to model HoaDonChiTietDatHang HoaDonChiTietDatHang mHoaDonChiTietDatHang = new HoaDonChiTietDatHang(); mHoaDonChiTietDatHang.MSDH = reader[0].ToString(); mHoaDonChiTietDatHang.MSHH = reader[1].ToString(); mHoaDonChiTietDatHang.SoLuong = int.Parse(reader[2].ToString()); mHoaDonChiTietDatHang.TiLeGiam = int.Parse(reader[3].ToString()); arrHoaDonChiTietDatHang[i] = mHoaDonChiTietDatHang; i++; } reader.Close(); } catch (Exception ex) { // Console.WriteLine(ex.Message); } // Console.ReadLine(); } return(arrHoaDonChiTietDatHang); }