void LoadCombo_NgachBac()
{
try
{
dtBacHeSo = oBacHeSo.GetData();
if (dtBacHeSo.Rows.Count > 0)
{
DataTable dtMaNgach = dtBacHeSo.DefaultView.ToTable(true, new string[2] {
"ma_ngach", "ten_ngach"
});
dtMaNgach.Columns.Add("ma_ten_ngach", typeof(string), "ten_ngach + '-' + ma_ngach");
DataView dv = dtMaNgach.AsDataView();
dv.Sort = "ten_ngach";
dtMaNgach = dv.ToTable();
comb_NgachMoi.DataSource = dtMaNgach;
comb_NgachMoi.ValueMember = "ma_ngach";
comb_NgachMoi.DisplayMember = "ma_ten_ngach";
DataTable dtBac = dtBacHeSo.DefaultView.ToTable(true, new string[2] {
"bac", "id"
});
comb_BacMoi.DataSource = dtBac;
comb_BacMoi.DisplayMember = "bac";
comb_BacMoi.ValueMember = "id";
}
}
catch (Exception)
{
}
}
private void Prepare_Data_BacHeSo()
{
dtBacHeSo = oBacHeSo.GetData();
Load_Data_Cbo_Ngach();
try
{
string m_ma_ngach = comb_Ngach.SelectedValue.ToString();
/*var result = (from c in dtBacHeSo.AsEnumerable()
* where c.Field<string>("ma_ngach") == m_ma_ngach && c.Field<bool>("tinh_trang") == true
* select new { id = c.Field<int>("id"), bac = c.Field<int>("bac"), he_so = c.Field<double>("he_so") }
* ).ToList();
*/
DateTime m_tu_ngay_select = dtp_TuNgay.Value;
var result = (from c in dtBacHeSo.AsEnumerable()
where c.Field <string>("ma_ngach") == m_ma_ngach && m_tu_ngay_select >= c.Field <DateTime>("tu_ngay") && m_tu_ngay_select <= c.Field <DateTime?>("den_ngay")
orderby c.Field <int>("bac")
select new { id = c.Field <int>("id"), bac = c.Field <int>("bac"), he_so = c.Field <double>("he_so") }
).ToList();
if (result.Count == 0)
{
result = (from c in dtBacHeSo.AsEnumerable()
where c.Field <string>("ma_ngach") == m_ma_ngach && c.Field <bool>("tinh_trang") == true && m_tu_ngay_select >= c.Field <DateTime>("tu_ngay")
orderby c.Field <int>("bac")
select new { id = c.Field <int>("id"), bac = c.Field <int>("bac"), he_so = c.Field <double>("he_so") }
).ToList();
}
DataTable dt = ToDataTable(result);
comb_Bac.DataSource = dt;
comb_Bac.DisplayMember = "bac";
comb_Bac.ValueMember = "id";
if (result.Count != 0)
{
int m_id = Convert.ToInt32(comb_Bac.SelectedValue.ToString());
var result1 = (from c in dtBacHeSo.AsEnumerable()
where c.Field <int>("id") == m_id
select c.Field <double>("he_so"));
double m_he_so = result1.ElementAt <double>(0);
txt_HeSo.Text = m_he_so.ToString();
}
else
{
txt_HeSo.Text = "";
}
}
catch { }
}
private void BacHeSo_Load(object sender, EventArgs e)
{
ResetInterface(true);
dtDSBacHeSo = oBacHeSo.GetData();
if (dtDSBacHeSo != null)
{
PrepareDataSource();
EditDtgInterface();
}
LoadCboNgach();
}
private void RefreshDataSource()
{
Business.Luong.BacHeSo bacheso = new Business.Luong.BacHeSo();
dtDSBacHeSo = bacheso.GetData();
PrepareDataSource();
}
private void RefreshDataSource()
{
Business.Luong.BacHeSo bacheso = new Business.Luong.BacHeSo();
dtDSBacHeSo = bacheso.GetData();
PrepareDataSource();
}
