private void THYCKH_Load(object sender, EventArgs e)
{
thbus = new THYCBUS();
List <THYCDTO> lsth = thbus.select_THYC();
Load_Datagridview1(lsth);
dataGridView1.Columns["TINH"].Visible = false;
dataGridView1.Columns["HUYEN"].Visible = false;
dataGridView1.Columns["XA"].Visible = false;
dataGridView1.Columns["EMAIL"].Visible = false;
dataGridView1.Columns["DUONG"].Visible = false;
dataGridView1.Columns["SONHA"].Visible = false;
dataGridView1.Columns["LAU"].Visible = false;
dataGridView1.Columns["PHONG"].Visible = false;
dataGridView1.Columns["WEBSITE"].Visible = false;
dataGridView1.Columns["SDTBAN1"].Visible = false;
dataGridView1.Columns["SDTBAN2"].Visible = false;
dataGridView1.Columns["PHONGBAN"].Visible = false;
dataGridView1.Columns["GHICHU"].Visible = false;
dataGridView1.Columns["MAPTGUIHANG"].Visible = false;
dataGridView1.Columns["KHUCAOOC"].Visible = false;
dataGridView1.Columns["THOIGIANKHDAPUNG"].Visible = false;
dataGridView1.Columns["YEUCAU"].Visible = false;
dataGridView1.Columns["GIATRIPO"].Visible = false;
dataGridView1.Columns["NHANDINHTHUCTRANG"].Visible = false;
dataGridView1.Columns["QUATRINHXULY"].Visible = false;
dataGridView1.Columns["MATHUCHIENYEUCAU"].Visible = false;
dataGridView1.Columns["mst"].Visible = false;
dataGridView1.Columns["sdt"].Visible = false;
}
private void button3_Click(object sender, EventArgs e)
{
int index = dataGridView1.CurrentRow.Index;
dataGridView1.Columns["MATHUCHIENYEUCAU"].Visible = true;
string key;
key = dataGridView1.Rows[index].Cells[9].Value.ToString();
dataGridView1.Columns["MATHUCHIENYEUCAU"].Visible = false;
THYCDTO thdto = new THYCDTO();
THYCBUS thbus = new THYCBUS();
thdto = thbus.collect_update(key);
THYCKH_3T frthyc = new THYCKH_3T(thdto);
frthyc.ShowDialog();
dataGridView1.Refresh();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
List <THYCDTO> lsth = thbus.select_THYC();
Load_Datagridview1(lsth);
dataGridView1.Columns["TINH"].Visible = false;
dataGridView1.Columns["HUYEN"].Visible = false;
dataGridView1.Columns["XA"].Visible = false;
dataGridView1.Columns["EMAIL"].Visible = false;
dataGridView1.Columns["DUONG"].Visible = false;
dataGridView1.Columns["SONHA"].Visible = false;
dataGridView1.Columns["LAU"].Visible = false;
dataGridView1.Columns["PHONG"].Visible = false;
dataGridView1.Columns["WEBSITE"].Visible = false;
dataGridView1.Columns["SDTBAN1"].Visible = false;
dataGridView1.Columns["SDTBAN2"].Visible = false;
dataGridView1.Columns["PHONGBAN"].Visible = false;
dataGridView1.Columns["GHICHU"].Visible = false;
dataGridView1.Columns["MAPTGUIHANG"].Visible = false;
dataGridView1.Columns["KHUCAOOC"].Visible = false;
dataGridView1.Columns["THOIGIANKHDAPUNG"].Visible = false;
dataGridView1.Columns["YEUCAU"].Visible = false;
dataGridView1.Columns["GIATRIPO"].Visible = false;
dataGridView1.Columns["NHANDINHTHUCTRANG"].Visible = false;
dataGridView1.Columns["QUATRINHXULY"].Visible = false;
dataGridView1.Columns["MATHUCHIENYEUCAU"].Visible = false;
dataGridView1.Columns["mst"].Visible = false;
dataGridView1.Columns["sdt"].Visible = false;
}
private void btLuu_Sua_Click(object sender, EventArgs e)
{
THYCDTO thuchien = new THYCDTO();
var checkedButton = tabPage2.Controls.OfType <RadioButton>()
.FirstOrDefault(r => r.Checked);
thuchien.MATHUCHIENYEUCAU = IDtemp;
thuchien.mst = txtMST.Text;
thuchien.sdt = txtMobile.Text;
thuchien.TENCOQUAN = txtCoQuan.Text;
thuchien.LAU = int.Parse(txtLau.Text);
thuchien.HOVATEN = txtNguoiLienHe.Text;
thuchien.SONHA = txtSoNha.Text;
thuchien.PHONGBAN = txtPhongBan.Text;
thuchien.SDTBAN1 = txtTel1.Text;
thuchien.SDTBAN2 = txtTel2.Text;
thuchien.EMAIL = txtEmail.Text;
thuchien.WEBSITE = txtWebsite.Text;
thuchien.GHICHU = txtGhiChu.Text;
thuchien.KHUCAOOC = txtKhuCaoOc.Text;
thuchien.PHONG = txtPhong.Text;
thuchien.DUONG = txtDuong.Text;
thuchien.XA = cbXa.Text;
thuchien.HUYEN = cbHuyen.Text;
thuchien.TINH = cbTinh.Text;
if (checkedButton.Text == "Fax")
{
thuchien.MAPTGUIHANG = "001";
}
else if (checkedButton.Text == "Email")
{
thuchien.MAPTGUIHANG = "002";
}
else if (checkedButton.Text == "Mail")
{
thuchien.MAPTGUIHANG = "003";
}
else if (checkedButton.Text == "Trực tiếp")
{
thuchien.MAPTGUIHANG = "004";
}
thuchien.MANHANVIENGHINHAN = this.cbNVGhiNhan.GetItemText(this.cbNVGhiNhan.SelectedItem);
if (thuchien.MANHANVIENGHINHAN == "Anh")
{
thuchien.MANHANVIENGHINHAN = "001";
}
if (thuchien.MANHANVIENGHINHAN == "Long")
{
thuchien.MANHANVIENGHINHAN = "002";
}
if (thuchien.MANHANVIENGHINHAN == "Tuấn")
{
thuchien.MANHANVIENGHINHAN = "003";
}
if (thuchien.MANHANVIENGHINHAN == "Văn")
{
thuchien.MANHANVIENGHINHAN = "004";
}
thuchien.YEUCAU = txtYeuCau.Text;
thuchien.THOIGIANKHDAPUNG = dateTimePicker1.Value;
thuchien.MANHANVIENTHUCHIEN = this.cbNVThucHien.GetItemText(this.cbNVThucHien.SelectedItem);
if (thuchien.MANHANVIENTHUCHIEN == "Anh")
{
thuchien.MANHANVIENTHUCHIEN = "001";
}
if (thuchien.MANHANVIENTHUCHIEN == "Long")
{
thuchien.MANHANVIENTHUCHIEN = "002";
}
if (thuchien.MANHANVIENTHUCHIEN == "Tuấn")
{
thuchien.MANHANVIENTHUCHIEN = "003";
}
if (thuchien.MANHANVIENTHUCHIEN == "Văn")
{
thuchien.MANHANVIENTHUCHIEN = "004";
}
thuchien.KETQUA = this.cbKetQua.GetItemText(this.cbKetQua.SelectedItem);
thuchien.QUATRINHXULY = txtGhiNhan.Text;
thuchien.NHANDINHTHUCTRANG = txtNhanDinh.Text;
thuchien.GIATRIPO = int.Parse(txtGiaTriPO.Text);
THYCBUS thbus = new THYCBUS();
thbus.luu_sua(thuchien);
this.Close();
}
