public List <DTO_CT> getListTS(string matruong)
{
_conn.Open();
string SQL = string.Format("Select Nam,ChiTieu from TuyenSinh where ChiTieu > 0 AND MaTruong = '" + matruong + "'");
Console.WriteLine(SQL);
// Command
SqlCommand cmd = new SqlCommand(SQL, _conn);
SqlDataReader data = cmd.ExecuteReader();
List <DTO_CT> listCt = new List <DTO_CT>();
while (data.Read())
{
DTO_CT ct = new DTO_CT(Int32.Parse(data[0].ToString()), Int32.Parse(data[1].ToString()));
listCt.Add(ct);
}
_conn.Close();
return(listCt);
}
public bool updateTruong_Dubaocung(string matruong)
{
_conn.Open();
string SQL = string.Format("Select Nam,ChiTieu from TuyenSinh where ChiTieu > 0 AND MaTruong = '" + matruong + "'");
Console.WriteLine(SQL);
// Command
SqlCommand cmd = new SqlCommand(SQL, _conn);
SqlDataReader data = cmd.ExecuteReader();
List <DTO_CT> listCt = new List <DTO_CT>();
while (data.Read())
{
DTO_CT ct = new DTO_CT(Int32.Parse(data[0].ToString()), Int32.Parse(data[1].ToString()));
listCt.Add(ct);
}
_conn.Close();
int n = listCt.Count;
if (n != 0)
{
try
{
_conn.Open();
string SQL_1 = string.Format("Select TuyenSinh.MaTruong,TiLeDo,SoLaoDong,TuyenSinh.Nam as ts_nam,TuyenSinh.ChiTieu as ts_chitieu,dubaocung.Nam as dbc_nam from dubaocung Inner Join TuyenSinh on TuyenSinh.MaTruong = dubaocung.MaTruong where dubaocung.MaTruong = '" + matruong + "'");
Console.WriteLine(SQL_1);
// Command
SqlCommand cmd_1 = new SqlCommand(SQL_1, _conn);
SqlDataReader data_1 = cmd_1.ExecuteReader();
while (data_1.Read())
{
int dbc_nam = Int32.Parse(data_1[5].ToString());
int ts_nam = Int32.Parse(data_1[3].ToString());
double tile = Convert.ToDouble(data_1[1].ToString());
int chitieu = 0;
if (dbc_nam > 2017)
{
chitieu = bptoithieu(listCt, n, dbc_nam);
int dubao = (int)(chitieu * tile) / 100;
DTO_DuBao db = new DTO_DuBao(matruong, (float)tile, dubao, dbc_nam, chitieu);
DAL_DuBao dal_db = new DAL_DuBao();
dal_db.updateDuBaoCung(db);
}
else
{
if (dbc_nam == ts_nam)
{
chitieu = Int32.Parse(data_1[4].ToString());
int dubao = (int)(chitieu * tile) / 100;
DTO_DuBao db = new DTO_DuBao(matruong, (float)tile, dubao, dbc_nam, chitieu);
DAL_DuBao dal_db = new DAL_DuBao();
dal_db.updateDuBaoCung(db);
}
}
}
return(true);
}
catch (Exception e)
{
MessageBox.Show("Có lỗi trong khi update!");
}
finally
{
// Dong ket noi
_conn.Close();
}
}
return(false);
}
