public bool DeleteCTPhieuQLK(eCTQLKho delid) { try { Tbl_CTPhieuQLKho deletema = DB.Tbl_CTPhieuQLKhos.Single(x => x.maPhieuql == delid._maPhieuQL && x.maSP == delid._masp); DB.Tbl_CTPhieuQLKhos.DeleteOnSubmit(deletema); DB.SubmitChanges(); return(true); } catch { return(false); } }
public List <eCTQLKho> getAllCTPhieuQLKho() { var dsctpqlk = DB.Tbl_CTPhieuQLKhos.ToList(); List <eCTQLKho> ls = new List <eCTQLKho>(); foreach (Tbl_CTPhieuQLKho ctpqlktemp in dsctpqlk) { eCTQLKho ctpqlk = new eCTQLKho(); ctpqlk._maPhieuQL = ctpqlktemp.maPhieuql; ctpqlk._masp = ctpqlktemp.maSP; ctpqlk._tensp = ctpqlktemp.tenSP; ctpqlk._sott = ctpqlktemp.sTT; ctpqlk._soluongql = ctpqlktemp.sLuongql; ctpqlk._donvi = ctpqlktemp.donVi; ls.Add(ctpqlk); } return(ls); }
public bool UpdateCTPQLKho(eCTQLKho updatectpqlk) { try { Tbl_CTPhieuQLKho ctpqlk = DB.Tbl_CTPhieuQLKhos.Single(x => x.maPhieuql == updatectpqlk._maPhieuQL && x.maSP == updatectpqlk._masp); ctpqlk.maSP = updatectpqlk._masp; ctpqlk.maPhieuql = updatectpqlk._maPhieuQL; ctpqlk.tenSP = updatectpqlk._tensp; ctpqlk.sTT = updatectpqlk._sott; ctpqlk.sLuongql = updatectpqlk._soluongql; ctpqlk.donVi = updatectpqlk._donvi; DB.SubmitChanges(); return(true); } catch { return(false); } }
public bool AddAllCTPQLKho(eCTQLKho newctpqlk) { try { Tbl_CTPhieuQLKho ctpqlk = DB.Tbl_CTPhieuQLKhos.Single(x => x.maPhieuql == newctpqlk._maPhieuQL && x.maSP == newctpqlk._masp); ctpqlk.maPhieuql = newctpqlk._maPhieuQL; ctpqlk.maSP = newctpqlk._masp; ctpqlk.sTT = newctpqlk._sott; ctpqlk.tenSP = newctpqlk._tensp; ctpqlk.sLuongql = newctpqlk._soluongql; ctpqlk.donVi = newctpqlk._donvi; DB.Tbl_CTPhieuQLKhos.InsertOnSubmit(ctpqlk); DB.SubmitChanges(); return(true); } catch { return(false); } }
private void btnxoa_Click(object sender, EventArgs e) { eCTQLKho ect = new eCTQLKho(); ect._maPhieuQL = txtmaphieu.Text; ect._sott = txtstt.Text; ect._masp = txtmasp.Text; ect._tensp = txttensp.Text; ect._soluongql = txtsoluong.Text; ect._donvi = txtdonvi.Text; bool kq = ctqlkBLL.DeleteCTPhieuQLK(ect); 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!"); dataCTPQLK.DataSource = ctqlkBLL.getAllCTPhieuQLKho(); } }