private void loadData_Vao_GridView()
{
List <TienCongDTO> listTienCong = tcBus.select();
if (listTienCong == null)
{
MessageBox.Show("Có lỗi khi lấy thông tin");
return;
}
dgvTiencong.Columns.Clear();
dgvTiencong.DataSource = null;
dgvTiencong.AutoGenerateColumns = false;
dgvTiencong.AllowUserToAddRows = false;
dgvTiencong.DataSource = listTienCong;
DataGridViewTextBoxColumn clmatiencong = new DataGridViewTextBoxColumn();
clmatiencong.Name = "matiencong";
clmatiencong.HeaderText = "Mã tiền công";
clmatiencong.DataPropertyName = "matiencong";
clmatiencong.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvTiencong.Columns.Add(clmatiencong);
DataGridViewTextBoxColumn clloaidichvu = new DataGridViewTextBoxColumn();
clloaidichvu.Name = "tendichvu";
clloaidichvu.HeaderText = "Tên dịch vụ";
clloaidichvu.DataPropertyName = "tendichvu";
clloaidichvu.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvTiencong.Columns.Add(clloaidichvu);
DataGridViewTextBoxColumn cltiencong = new DataGridViewTextBoxColumn();
cltiencong.Name = "tiencong";
cltiencong.HeaderText = "Tiền công";
cltiencong.DataPropertyName = "tiencong";
cltiencong.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvTiencong.Columns.Add(cltiencong);
CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[dgvTiencong.DataSource];
myCurrencyManager.Refresh();
}
private void loadData_Vao_GridView()
{
List <TienCongDTO> listTienCong = tcBus.select();
if (listTienCong == null)
{
MessageBox.Show("Có lỗi khi lấy DB");
return;
}
data_tiencong.Columns.Clear();
data_tiencong.DataSource = null;
data_tiencong.AutoGenerateColumns = false;
data_tiencong.AllowUserToAddRows = false;
data_tiencong.DataSource = listTienCong;
DataGridViewTextBoxColumn clMa = new DataGridViewTextBoxColumn();
clMa.Name = "Matc";
clMa.HeaderText = "Mã tiền công";
clMa.DataPropertyName = "Maloaitiencong";
data_tiencong.Columns.Add(clMa);
DataGridViewTextBoxColumn clTen = new DataGridViewTextBoxColumn();
clTen.Name = "Tenloaitc";
clTen.HeaderText = "Tên tiền công";
clTen.DataPropertyName = "Tenloaitiencong";
data_tiencong.Columns.Add(clTen);
DataGridViewTextBoxColumn clTiencong = new DataGridViewTextBoxColumn();
clTiencong.Name = "Tiencong";
clTiencong.HeaderText = "Tiền công";
clTiencong.DataPropertyName = "Tiencong";
data_tiencong.Columns.Add(clTiencong);
CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[data_tiencong.DataSource];
myCurrencyManager.Refresh();
}
private void loadTienCong_combobox()
{
List <TienCongDTO> listTienCong = tcBus.select();
if (listTienCong == null)
{
MessageBox.Show("Có lỗi khi lấy loại Tiền Công từ DB");
return;
}
cb_tiencong.DataSource = new BindingSource(listTienCong, String.Empty);
cb_tiencong.DisplayMember = "tenloaitiencong";
cb_tiencong.ValueMember = "maloaitiencong";
tb_giatiencong.DataBindings.Clear();
tb_giatiencong.DataBindings.Add("Text", cb_tiencong.DataSource, "TienCong");
CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[cb_tiencong.DataSource];
myCurrencyManager.Refresh();
if (cb_tiencong.Items.Count > 0)
{
cb_tiencong.SelectedIndex = 0;
}
}