private void bt_tinh_Click(object sender, EventArgs e) { ConnectData con = new ConnectData(); String kt = "select MAHNANG from TBL_CTHD where sohd = " + txt_sohd.Text + " and MAHNANG like 'lk%'"; DataTable dt = con.Getdatatable(kt); String kt2 = "select MAHNANG from TBL_CTHD where sohd = " + txt_sohd.Text + " and MAHNANG like 'mt%'"; DataTable dt2 = con.Getdatatable(kt2); if (dt.Rows.Count > 0) { string sql2 = "select sum((SOLUONG*lk.DONGIA)) as tienlk " + " from TBL_CTHD ct, TBLLINHKIEN lk, TBLHOADON hd " + " where ct.MAHNANG = lk.MALK and ct.SOHD = hd.SOHD and ct.SOHD = " + txt_sohd.Text; tienlk = con.GetScalar(sql2); } if (dt2.Rows.Count > 0) { string sql = "select sum((SOLUONG*mt.DONGIA)) as tienmay " + " from TBL_CTHD ct, TBLMAYTINH mt, TBLHOADON hd " + " where ct.MAHNANG = mt.MAMAY and ct.SOHD = hd.SOHD and ct.SOHD = " + txt_sohd.Text; tienmay = con.GetScalar(sql); } txt_thanhtien.Text = (tienlk + tienmay).ToString(); string sql3 = "select MAHNANG as [Mã mặt hàng], SOLUONG as [Số lượng mua] from TBL_CTHD where sohd=" + txt_sohd.Text; dataGridView1.DataSource = con.Getdatatable(sql3); }
private void cbb_chon_SelectedIndexChanged(object sender, EventArgs e) { if (cbb_chon.Text == "Mua linh kiện") { DataTable dt = new DataTable(); string sql = "select MALK, TENLK from TBLLINHKIEN "; ConnectData con = new ConnectData(); dt = con.Getdatatable(sql); cbb_masp.DataSource = dt; cbb_masp.DisplayMember = "MALK"; cbb_masp.ValueMember = "MALK"; cbb_tensp.DataSource = dt; cbb_tensp.DisplayMember = "TENLK"; cbb_tensp.ValueMember = "MALK"; } else { DataTable dt = new DataTable(); string sql = "select MAMAY, TENMAY from TBLMAYTINH "; ConnectData con = new ConnectData(); dt = con.Getdatatable(sql); cbb_masp.DataSource = dt; cbb_masp.DisplayMember = "MAMAY"; cbb_masp.ValueMember = "MAMAY"; cbb_tensp.DataSource = dt; cbb_tensp.DisplayMember = "TENMAY"; cbb_tensp.ValueMember = "MAMAY"; } }
private void bt_mt_Click(object sender, EventArgs e) { ConnectData con = new ConnectData(); dataGridView1.DataSource = con.Getdatatable("select TENMAY as [Tên máy tính], SUM(soluong) as [Tổng số lượng mua] from TBL_CTHD ct, TBLMAYTINH mt where ct.MAHNANG = mt.MAMAY group by TENMAY having sum(soluong) >5"); }
private void bt_hd_Click(object sender, EventArgs e) { ConnectData con = new ConnectData(); dataGridView1.DataSource = con.Getdatatable("select SOHD, sum(thanhtien) as [Số tiền mua] from TBLHOADON group by SOHD having sum(THANHTIEN) >100000"); }
private void bt_lk_Click(object sender, EventArgs e) { ConnectData con = new ConnectData(); dataGridView1.DataSource = con.Getdatatable("select TENLK as [Tên linh kiện], SUM(soluong) as [Tổng số lượng mua] from TBL_CTHD ct, TBLLINHKIEN lk where ct.MAHNANG = lk.MALK group by TENLK having sum(soluong) >10"); }