//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"); } } }