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;
}
}
}
