private void LoadAgain()
{
var r = new DatabaseNV();
List <CustomerParameter> lst = new List <CustomerParameter>();
DataTable dt = r.SelectData("Load", lst);
this.dataGridViewPhongban.DataSource = dt;
this.buttonSua.Enabled = false;
}
private void comboBoxPhongban_TextChanged(object sender, EventArgs e)
{
string TenPB = this.comboBoxPhongban.Text;
List <CustomerParameter> lst = new List <CustomerParameter>();
lst.Add(new CustomerParameter()
{
key = "@tenphongban", value = TenPB
});
var r = new DatabaseNV();
dataGridViewLuong.DataSource = r.SelectData("BANGLUONGTHEOPHONG", lst);
}
public void LoadAgain()
{
var db = new DatabaseNV();
List <CustomerParameter> lst = new List <CustomerParameter>();
lst.Add(new CustomerParameter()
{
key = "@tukhoa", value = textBoxTimkiem.Text
});
string sql = "";
if (this.radioButton1.Checked == true)
{
sql = "SelectAllNhanVien";
}
if (this.radioButton2.Checked == true)
{
sql = "SelectAllNhanVienHetHan";
}
dgvKetQua.DataSource = db.SelectData(sql, lst);
}
