//thêm // int index = e.RowIndex; // tbxmssv1.Text = dGVdsphieudangky["Column5", index].Value.ToString(); // tbxmapdk.Text = dGVdsphieudangky["Column1", index].Value.ToString(); // tbxmaquyenda.Text = dGVdsphieudangky["Column2", index].Value.ToString(); // dtpngaydkdt.Text = dGVdsphieudangky["Column4", index].Value.ToString(); // tbxmadt.Text = dGVdsphieudangky["Column3", index].Value.ToString(); private void btnthem_Click(object sender, EventArgs e) { try { PhieuPhanCong PPC = new PhieuPhanCong(); PPC.MaPhieuPC = tbxmaphieuphancong.Text.Trim(); PPC.NgayPC = dtpngayphancong.Value; PPC.MaGV = tbxmaGV.Text.Trim(); PPC.MaQuyenDA = tbxmaquyendoan.Text.Trim(); PPC.MaChucVu = tbxmachucvu.Text.Trim(); PhieuPhanCongBLL PPCBLL = new PhieuPhanCongBLL(); string _MaPhieuPC = tbxmaphieuphancong.Text.Trim(); if (!(PPCBLL.CheckID(_MaPhieuPC))) { PPCBLL.Insert(PPC); LoadData(); } else { MessageBox.Show("Mã phieu phan cong " + _MaPhieuPC.ToString() + "đã tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBox.Show("Thêm bị lỗi: " + ex.Message.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public int Update(PhieuPhanCong obj) { int result = 0; string strQuery = "update PHIEUPHANCONG set NgayPC='" + obj.NgayPC + "',FK_MaQuyenDA='" + obj.MaQuyenDA + "',FK_MaGV='" + obj.MaGV + "',FK_MaChucVu='" + obj.MaChucVu + "' where MaPhieuPC='" + obj.MaPhieuPC + "'"; DataConfig config = new DataConfig(); result = config.excuteNoneQuery(strQuery); return(result); //tra ve so ghi nhan thuc hien }
////ham tim kiem //public DataTable TimKiem(string chuoi) //{ // DataTable result = new DataTable(); // DataConfig config = new DataConfig();//tao ket noi // string strQuery = "select * from PHIEUPHANCONG Where MaPhieuPC like'%" + chuoi + "%'"; // tim kiem theo ma // result = config.GetData(strQuery);// form load len thi thuc hien load data // return result; //} //them csdl public int Insert(PhieuPhanCong obj) { int result = 0; string strQuery = "insert into PHIEUPHANCONG (MaPhieuPC,NgayPC,FK_MaQuyenDA,FK_MaGV,FK_MaChucVu) values ('" + obj.MaPhieuPC + "','" + obj.NgayPC + "','" + obj.MaQuyenDA + "','" + obj.MaGV + "','" + obj.MaChucVu + "')"; DataConfig config = new DataConfig(); result = config.excuteNoneQuery(strQuery); return(result); //tra ve so ghi nhan thuc hien }
private void btncapnhat_Click(object sender, EventArgs e) { try { PhieuPhanCong PPC = new PhieuPhanCong(); PPC.MaPhieuPC = tbxmaphieuphancong.Text.Trim(); PPC.NgayPC = dtpngayphancong.Value; PPC.MaGV = tbxmaGV.Text.Trim(); PPC.MaQuyenDA = tbxmaquyendoan.Text.Trim(); PPC.MaChucVu = tbxmachucvu.Text.Trim(); PhieuPhanCongBLL PPCBLL = new PhieuPhanCongBLL(); string _MaPhieuPC = tbxmaphieuphancong.Text.Trim(); PPCBLL.Update(PPC); LoadData(); } catch (Exception ex) { MessageBox.Show("Sửa bị lỗi: " + ex.Message.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }