private void Load_Data(String sql)
{
Sqlprovider kn = new Sqlprovider();
DataSet ds = new DataSet();
SqlDataAdapter dap = new SqlDataAdapter(sql, kn.conn);
dap.Fill(ds);
dgvhh.DataSource = ds.Tables[0];
}
public void ComboKH()
{
Sqlprovider kn = new Sqlprovider();
SqlDataAdapter da = new SqlDataAdapter("select MAKH from KHACHHANG", kn.conn);
DataTable dt = new DataTable();
da.Fill(dt);
cbmakh.DisplayMember = "MAKH";
cbmakh.ValueMember = "MAKH";
cbmakh.DataSource = dt;
}
public void ComboHD()
{
Sqlprovider kn = new Sqlprovider();
SqlDataAdapter da = new SqlDataAdapter("select MAHD from HOADON", kn.conn);
DataTable dt = new DataTable();
da.Fill(dt);
cbmahd.DisplayMember = "MAHD";
cbmahd.ValueMember = "MAHD";
cbmahd.DataSource = dt;
}
public void ComboNV()
{
Sqlprovider kn = new Sqlprovider();
SqlDataAdapter da = new SqlDataAdapter("select MANV from NHANVIEN where LOAINV='Loai1'", kn.conn);
DataTable dt = new DataTable();
da.Fill(dt);
cbmanv.DisplayMember = "MANV";//Word là tên trường bạn muốn hiển thị trong combobox
cbmanv.ValueMember = "MANV";
cbmanv.DataSource = dt;
}
private void button5_Click(object sender, EventArgs e)
{
Sqlprovider kn = new Sqlprovider();
SqlCommand cmd = new SqlCommand("select SUM(SOLUONG) from CTHOADON where MAHH='" + txtma.Text + "'", kn.conn);
kn.conn.Open();
int n = (int)cmd.ExecuteScalar();
kn.conn.Close();
txtsoluonggiam.Text = n.ToString();
}
private void button4_Click(object sender, EventArgs e)
{
Sqlprovider kn = new Sqlprovider();
SqlCommand cmd = new SqlCommand("select SUM(THANHTIEN) from CTHOADON where MAHD='" + txtma.Text + "'", kn.conn);
kn.conn.Open();
int n = (int)cmd.ExecuteScalar();
kn.conn.Close();
txttt.Text = n.ToString();
}
private void cbmahh_SelectedIndexChanged(object sender, EventArgs e)
{
Sqlprovider kn = new Sqlprovider();
kn.conn.Open();
SqlCommand cmd = new SqlCommand("select * from HANGHOA where MAHH='" + cbmahh.SelectedValue.ToString() + "'", kn.conn);
SqlDataReader Reader = cmd.ExecuteReader();
if (Reader.HasRows)
{
Reader.Read();
txtgia.Text = Reader.GetInt32(6).ToString();
}
}
