public DataTable ChiTietPhieuNhap_Load(ChiTiet_PhieuNhap ctPhieuNhap) { string query = "sp_CTPhieuNhap_Select '" + ctPhieuNhap.MaPN + "'"; DataTable result = DataProvider.Instance.ExecuteQuery(query); return(result); }
public bool ChiTietPhieuNhap_Delete(ChiTiet_PhieuNhap ctPhieuNhap) { try { string query = "sp_CTPhieuNhap_Delete '" + ctPhieuNhap.MaPN + "','" + ctPhieuNhap.MaLo + "'"; DataTable result = DataProvider.Instance.ExecuteQuery(query); return(true); } catch (Exception e) { } return(false); }
private void btnXoaCTPN_Click(object sender, EventArgs e) { int MaPN = Convert.ToInt32(txtMaPN.Text); int MaLo = Convert.ToInt32(txtMaLo.Text); ChiTiet_PhieuNhap ctphieunhap = new ChiTiet_PhieuNhap(MaPN, MaLo, -1, -1, "", -1); if (MessageBox.Show("Bạn có thực sự muốn xóa??", "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { if (ctphieunhapBLL.ChittietPhieuNhap_Delete(ctphieunhap)) { LoadChiTietPhieuNhap(); } else { MessageBox.Show("Xóa thất bại"); } } }
private void btnSuaCTPN_Click(object sender, EventArgs e) { int MaPN = Convert.ToInt32(txtMaPN.Text); int MaLo = Convert.ToInt32(txtMaLo.Text); int SLNhap = Convert.ToInt32(txtSLNhap.Text); int SLGiao = Convert.ToInt32(txtSLGiao.Text); string DVT = txtDVT.Text;; int DonGiaNhap = Convert.ToInt32(txtDonGiaNhap.Text); ChiTiet_PhieuNhap ctphieunhap = new ChiTiet_PhieuNhap(MaPN, MaLo, SLNhap, SLGiao, DVT, DonGiaNhap); if (ctphieunhapBLL.ChittietPhieuNhap_Update(ctphieunhap)) { LoadChiTietPhieuNhap(); } else { MessageBox.Show("Chỉnh sửa thất bại"); } }
public bool ChittietPhieuNhap_Delete(ChiTiet_PhieuNhap ctPhieuNhap) { return(CT_PhieuNhap.ChiTietPhieuNhap_Delete(ctPhieuNhap)); }
public DataTable ChittietPhieuNhap_Load(ChiTiet_PhieuNhap ctPhieuNhap) { return(CT_PhieuNhap.ChiTietPhieuNhap_Load(ctPhieuNhap)); }
public bool ChiTietPhieuNhap_Insert(ChiTiet_PhieuNhap ctPhieuNhap) { return(CT_PhieuNhap.ChiTietPhieuNhap_Insert(ctPhieuNhap)); }