private void xembaocao_Click(object sender, EventArgs e)
{
if (Loai.SelectedIndex == 0)
{
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct;
}
else
if (Loai.SelectedIndex > 0 && Ten.Text != "")
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN=TBL_HOADON.MAHDBAN "
+ " where LOAISANPHAM='" + Loai.SelectedItem.ToString() + "' and TENSANPHAM= '" + Ten.Text + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Loai.SelectedIndex > 0)
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ "where LOAISANPHAM='" + Loai.SelectedItem.ToString() + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Ten.Text != "")
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ " where TENSANPHAM='" + Ten.Text + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
}
private void Loai_SelectedIndexChanged(object sender, EventArgs e)
{
if (Loai.SelectedIndex == 0)
{
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct;
}
else
if (Loai.SelectedIndex > 0 && Ten.Text != "")
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ "where LOAISANPHAM='" + Loai.SelectedItem.ToString() + "' and TENSANPHAM= '" + Ten.Text + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Loai.SelectedIndex > 0)
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ "where LOAISANPHAM='" + Loai.SelectedItem.ToString() + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Ten.Text != "")
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ " where TENSANPHAM='" + Ten.Text + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Loai.SelectedIndex > 0 && Ten.Text != "" && Tu.Value <= Den.Value)
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ " where TENSANPHAM='" + Ten.Text + "'and LOAISANPHAM = '" + Loai.SelectedItem.ToString() + "' and NGAYBAN >='" + Tu.Value.ToShortDateString() + "'and NGAYBAN<='" + Den.Value.ToShortDateString() + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Tu.Value <= Den.Value)
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ " where NGAYBAN >='" + Tu.Value.ToShortDateString() + "'and NGAYBAN<='" + Den.Value.ToShortDateString() + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Loai.SelectedIndex > 0 && Tu.Value <= Den.Value)
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ "where LOAISANPHAM = '" + Loai.SelectedItem.ToString() + "' and NGAYBAN >='" + Tu.Value.ToShortDateString() + "'and NGAYBAN<='" + Den.Value.ToShortDateString() + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
else
if (Ten.Text != "" && Tu.Value <= Den.Value)
{
TBhoadonct tbhoadonct_1 = new TBhoadonct("select MASAPHAM,TENSANPHAM,sum(SOLUONG),Sum(GIA) from TBL_HOADONCT join TBL_HOADON on TBL_HOADONCT.MAHDBAN = TBL_HOADON.MAHDBAN "
+ "where TENSANPHAM='" + Ten.Text + "' and NGAYBAN >='" + Tu.Value.ToShortDateString() + "'and NGAYBAN<='" + Den.Value.ToShortDateString() + "'" +
"group by MASAPHAM, TENSANPHAM");
dataGridViewbanchay.DataSource = null;
dataGridViewbanchay.DataSource = tbhoadonct_1;
}
}