private void frmReport_Load(object sender, EventArgs e) { DataAccess da = new DataAccess(); DataSet dsNhomSP = da.getAllNhomSP(); //cbTKTenNhomSP.Items.Add("Tất cả"); if (dsNhomSP != null && dsNhomSP.Tables[0] != null) { for (int k = 0; k < dsNhomSP.Tables[0].Rows.Count; k++) { cbTKTenNhomSP.Items.Add(dsNhomSP.Tables[0].Rows[k]["TenNhomSP"].ToString()); cbTenNhomSP.Items.Add(dsNhomSP.Tables[0].Rows[k]["TenNhomSP"].ToString()); cbDSBHProduct.Items.Add(dsNhomSP.Tables[0].Rows[k]["TenNhomSP"].ToString()); } } DataSet dsNhanvien = da.getAllNhanvien(); cbDSHBEmployee.Items.Add("Tất cả"); cbTKHDEmployee.Items.Add("Tất cả"); if (dsNhanvien != null && dsNhanvien.Tables[0] != null) { for (int k = 0; k < dsNhanvien.Tables[0].Rows.Count; k++) { cbDSHBEmployee.Items.Add(dsNhanvien.Tables[0].Rows[k]["Ten"].ToString()); cbTKHDEmployee.Items.Add(dsNhanvien.Tables[0].Rows[k]["Ten"].ToString()); } } DataSet dsPhong = da.getAllPhong(); cbDSBHRoom.Items.Add("Tất cả"); cbDSBHRoom.Items.Add("Bán lẻ"); cbTKHDRoom.Items.Add("Tất cả"); cbTKHDRoom.Items.Add("Bán lẻ"); if (dsPhong != null && dsPhong.Tables[0] != null) { for (int k = 0; k < dsPhong.Tables[0].Rows.Count; k++) { cbDSBHRoom.Items.Add(dsPhong.Tables[0].Rows[k]["TenPhong"].ToString()); cbTKHDRoom.Items.Add(dsPhong.Tables[0].Rows[k]["TenPhong"].ToString()); } } DateTime temp = DateTime.Now; string month = temp.Month.ToString(); string year = temp.Year.ToString(); for (int i = 0; i < 12; i++) { if (month == cbMonthByMonth.Items[i].ToString()) { cbMonthByMonth.SelectedIndex = i; } if (month == cbDSBHMonthByMonth.Items[i].ToString()) { cbDSBHMonthByMonth.SelectedIndex = i; } if (month == cbTKHDByMonthMonth.Items[i].ToString()) { cbTKHDByMonthMonth.SelectedIndex = i; } } for (int i = 0; i < 30; i++) { if (year == cbYearByMonth.Items[i].ToString()) { cbYearByMonth.SelectedIndex = i; } if (year == cbDSBHYearByMonth.Items[i].ToString()) { cbDSBHYearByMonth.SelectedIndex = i; } if (year == cbTKHDByMonthYear.Items[i].ToString()) { cbTKHDByMonthYear.SelectedIndex = i; } } }