private void btnLuu_Click(object sender, EventArgs e) { try { ePhieuQLiKho newpNk = new ePhieuQLiKho(); newpNk._maNV = comboboxMaNV.Text; newpNk._maKho = comboBoxMaKho.Text; newpNk._maPhieuQli = txtmphieu.Text; newpNk._tinhTrang = comboTinhTrang.Text; newpNk._ngayLapQLi = dtpNgayLap.Value; int kq = bllpqlk.AddAllPhieuQLK(newpNk); if (kq == 1) { MessageBox.Show("Thêm thành công!!!"); } else { MessageBox.Show("Trùng mã phiếu!!"); } listpqlk = bllpqlk.getAllPQLKho(); //listtp = blltp.getthuephongbymaphong(txtmaphong.Text); duadulieulendgvCTPQL(dgvPQLK, listpqlk); chedobutton(true); chedotextbox(false); btnthem.Text = "Thêm"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public bool DeletePhieuQLK(ePhieuQLiKho delid) { try { Tbl_PhieuQLKho deletema = DB.Tbl_PhieuQLKhos.Single(x => x.maPhieuQL == delid._maPhieuQli); DB.Tbl_PhieuQLKhos.DeleteOnSubmit(deletema); DB.SubmitChanges(); return(true); } catch { return(false); } }
public List <ePhieuQLiKho> getAllPQLKho() { var dspqlk = DB.Tbl_PhieuQLKhos.ToList(); List <ePhieuQLiKho> ls = new List <ePhieuQLiKho>(); foreach (Tbl_PhieuQLKho temppqlk in dspqlk) { ePhieuQLiKho pqlk = new ePhieuQLiKho(); pqlk._maPhieuQli = temppqlk.maPhieuQL; pqlk._ngayLapQLi = Convert.ToString(temppqlk.ngayLapQL); pqlk._maNV = temppqlk.maNV; pqlk._maKho = temppqlk.msKho; pqlk._tinhTrang = temppqlk.tinhTrang; ls.Add(pqlk); } return(ls); }
public int AddAllPhieuQLK(ePhieuQLiKho newpqlk) { if (Kiemtrasutontai(newpqlk._maPhieuQli)) { return(0); } Tbl_PhieuQLKho pqlk = new Tbl_PhieuQLKho(); pqlk.maPhieuQL = newpqlk._maPhieuQli; pqlk.ngayLapQL = newpqlk._ngayLapQLi; pqlk.maNV = newpqlk._maNV; pqlk.tinhTrang = newpqlk._tinhTrang; pqlk.msKho = newpqlk._maKho; DB.Tbl_PhieuQLKhos.InsertOnSubmit(pqlk); DB.SubmitChanges(); return(1); }
public bool UpDatePhieuQLK(ePhieuQLiKho updatepqlk) { try { Tbl_PhieuQLKho pqlk = DB.Tbl_PhieuQLKhos.Single(x => x.maPhieuQL == updatepqlk._maPhieuQli); pqlk.maPhieuQL = updatepqlk._maPhieuQli; pqlk.maNV = updatepqlk._maNV; pqlk.ngayLapQL = Convert.ToDateTime(updatepqlk._ngayLapQLi); pqlk.tinhTrang = updatepqlk._tinhTrang; pqlk.msKho = updatepqlk._maKho; DB.SubmitChanges(); return(true); } catch { return(false); } }
public bool AddAllPhieuQLK(ePhieuQLiKho newpqlk) { try { Tbl_PhieuQLKho pqlk = DB.Tbl_PhieuQLKhos.Single(x => x.maPhieuQL == newpqlk._maPhieuQli); pqlk.maPhieuQL = newpqlk._maPhieuQli; pqlk.ngayLapQL = Convert.ToDateTime(newpqlk._ngayLapQLi); pqlk.maNV = newpqlk._maNV; pqlk.tinhTrang = newpqlk._tinhTrang; DB.Tbl_PhieuQLKhos.InsertOnSubmit(pqlk); DB.SubmitChanges(); return(true); } catch { return(false); } }
private void btnxoa_Click(object sender, EventArgs e) { ePhieuQLiKho qlk = new ePhieuQLiKho(); qlk._maPhieuQli = txtmphieu.Text; qlk._ngayLapQLi = txtngaylap.Text; qlk._maNV = txtmanv.Text; qlk._maKho = txtmakho.Text; qlk._tinhTrang = txttinhtrang.Text; bool kq = pqlkBLL.DeletePhieuQLK(qlk); if (kq == false) { MessageBox.Show("Không có mã để xóa!", "Thông báo!"); } else { MessageBox.Show("Xóa thành công!", "Thông báo!"); dataPQLK.DataSource = pqlkBLL.getAllPQLKho(); } }