//Giam gia trị gio khi dia hinh là dạng dia hinh A
private void chkA_CheckedChanged(object sender, EventArgs e)
{
// cbxHuyen_SelectedIndexChanged(sender, e);
//string vungALGio ;
if (chkA.Checked == true)
{
switch (dgvThongso.Rows[0].Cells[1].Value)
{
case "I-A":
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG") - 0.10;
break;
}
case "II-A":
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG") - 0.12;
break;
}
case "III-A":
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG") - 0.15;
break;
}
default:
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG");
break;
}
}
else
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG");
}
}
//chon dia hinh khi huyen thay doi
private void cbxHuyen_SelectedIndexChanged(object sender, EventArgs e)
{
//tra dia hinh
using (OleDbConnection cnn = new OleDbConnection())
{
cnn.ConnectionString = strlink;
if (cnn.State != ConnectionState.Open)
{
cnn.Open();
}
string strQuery = "SELECT* FROM Data where ID = " + cbxHuyen.SelectedValue;
OleDbDataAdapter ada = new OleDbDataAdapter(strQuery, cnn);
DataTable tabl = new DataTable();
ada.Fill(tabl);
cnn.Dispose();
cnn.Close();
cbxDiaHinh.SelectedItem = tabl.Rows[0]["Vung2"].ToString();// lua chon dang dia hinh tuong ung- phai add gia tri truoc
//cbxDiaHinh.DataSource = tabl;//Cai nay khong cho sua du lieu
//cbxDiaHinh.DisplayMember = "VUNG2";
//tra vung gio
dgvThongso.Rows[0].Cells[1].Value = tabl.Rows[0]["vung"].ToString();
//Gan gia tri cho cell trong dgvThongso
dgvThongso.Rows[1].Cells[1].Value = cbxDiaHinh.Text; // ToString();
//Tra Gia tri gioi han dao dong cua tan so rieng fL
vungALGio = tabl.Rows[0]["VUNG1"].ToString(); //truyen tam cai string nay
dgvThongso.Rows[3].Cells[1].Value = TanSofL.tanSofL(vungALGio, "fL");//antSofL(vungALGio);
//Tinh trị so ap luc gio
if (chkA.Checked == true)
{
switch (dgvThongso.Rows[0].Cells[1].Value)
{
case "I-A":
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG") - 0.1;
break;
}
case "II-A":
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG") - 0.12;
break;
}
case "III-A":
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG") - 0.15;
break;
}
default:
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG");
break;
}
}
else
{
dgvThongso.Rows[2].Cells[1].Value = TanSofL.tanSofL(vungALGio, "ALG");
}
}
}
