public void HienThi(DataGridView dg, BindingNavigator bn, TextBox ma, TextBox ten, ComboBox nam)
{
BindingSource bs = new BindingSource();
bs.DataSource = Data.LayDSHocKi();
bn.BindingSource = bs;
dg.DataSource = bs;
if (ma.DataBindings.Count > 0)
{
ma.DataBindings.RemoveAt(0);
ten.DataBindings.RemoveAt(0);
nam.DataBindings.RemoveAt(0);
}
NamHocCtrl ctrlnam = new NamHocCtrl();
dg.Columns.Add(ctrlnam.ColumnNamHoc());
dg.Columns.RemoveAt(2);
ma.DataBindings.Add("Text", bs, "MAHOCKI");
ten.DataBindings.Add("Text", bs, "TENHOCKI");
NamHocData dataNam = new NamHocData();
nam.DataSource = dataNam.LayDSNamHoc();
nam.DisplayMember = "TENNAMHOC";
nam.ValueMember = "MANAMHOC";
nam.DataBindings.Add("SelectedValue", bs, "MANAM");
}
public void LayDSNamHoc(ComboBoxEx com)
{
NamHocData dt = new NamHocData();
com.DataSource = dt.LayDSNamHoc();
com.DisplayMember = "TENNAMHOC";
com.ValueMember = "MANAMHOC";
}
//Hien thi ComboBox
public void HienThiComboBox(ComboBoxEx comboBox)
{
NamHocData m_NHData = new NamHocData();
comboBox.DataSource = m_NHData.LayDsNamHoc();
comboBox.DisplayMember = "TenNamHoc";
comboBox.ValueMember = "MaNamHoc";
}
/// <summary>
///
/// </summary>
/// <param name="maNamHoc"></param>
/// <returns></returns>
public string LayMaTruoc(string maNamHoc)
{
if (this.Data == null)
{
this.Data = new NamHocData();
}
return(Convert.ToString(this.Data.LayMaTruoc(maNamHoc)));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public string LayMaCuoi()
{
if (this.Data == null)
{
this.Data = new NamHocData();
}
return(Convert.ToString(this.Data.LayMaCuoi()));
}
/// <summary>
///
/// </summary>
/// <param name="cmb"></param>
public void HienThiCombobox(ComboBox cmb)
{
if (this.Data == null)
{
this.Data = new NamHocData();
}
cmb.DataSource = this.Data.LayDS();
cmb.DisplayMember = "TenNamHoc";
cmb.ValueMember = "MaNamHoc";
}
/// <summary>
///
/// </summary>
/// <param name="col"></param>
public void HienThiDataGridComboBoxColumn(DataGridViewComboBoxColumn col)
{
if (this.Data == null)
{
this.Data = new NamHocData();
}
col.DataSource = this.Data.LayDS();
col.DisplayMember = "TenNamHoc";
col.ValueMember = "MaNamHoc";
col.DataPropertyName = "MaNamHoc";
}
public void HienThiDS(DataGridView dgvDS, BindingNavigator bnDS)
{
if (this.Data == null)
{
this.Data = new NamHocData();
}
BindingSource bs = new BindingSource();
bs.DataSource = this.Data.LayDS();
bnDS.BindingSource = bs;
dgvDS.DataSource = bs;
}
/// <summary>
///
/// </summary>
/// <param name="maNamHoc"></param>
/// <returns></returns>
public NamHocInfo LayTuMa(string maNamHoc)
{
if (this.Data == null)
{
this.Data = new NamHocData();
}
DataTable table = this.Data.LayTuMa(maNamHoc);
NamHocInfo info = new NamHocInfo();
if (table.Rows.Count > 0)
{
info.MaNamHoc = table.Rows[0]["MaNamHoc"].ToString();
info.TenNamHoc = table.Rows[0]["TenNamHoc"].ToString();
return(info);
}
return(null);
}
public NamHocController()
{
this.Data = new NamHocData();
}
