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));
}
