public static void insert_CTPN(ChiTietPNDTO ctpn)
{
try
{
cnn = DataProvider.ConnectData();
string insert = string.Format("insert into db_chi_tiet_pn(ma_sp,ma_phieu_nhap,so_luong,gianhap,tong) values('{0}','{1}','{2}','{3}','{4}');",
ctpn.ma_sp, ctpn.ma_phieu_nhap, ctpn.soluong, ctpn.gianhap, ctpn.tong);
DataProvider.Execute(cnn, insert);
cnn.Close();
}catch (Exception ex)
{
throw ex;
}
}
public static void Update_CTPNSP(ChiTietPNDTO ctpn)
{
try
{
cnn = DataProvider.ConnectData();
string update = string.Format("UPDATE db_chi_tiet_pn SET ma_sp='{1}',so_luong='{2}',gianhap='{3}',tong='{4}' WHERE id='{0}'",
ctpn.id, ctpn.ma_sp, ctpn.soluong, ctpn.gianhap, ctpn.tong);
DataProvider.Execute(cnn, update);
cnn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void btnThemsp_Click(object sender, EventArgs e)
{
try
{
if (txtMaPN.Text == "")
{
MessageBox.Show("Bạn chưa nhập mã phiếu !", "Thông báo");
txtMaPN.Focus();
}
else
{
pnh.ma_phieu_nhap = txtMaPN.Text;
ChiTietPNDTO ctpn = new ChiTietPNDTO();
ctpn.ma_phieu_nhap = txtMaPN.Text;
ctpn.ma_sp = txtMSP.Text;
ctpn.soluong = int.Parse(txtSL.Text);
ctpn.gianhap = double.Parse(txtGSP.Text);
ctpn.tong = ctpn.soluong * ctpn.gianhap;
PhieuNhapBUS.Insert_CTPN(ctpn);
SanPhamDTO sp = new SanPhamDTO();
sp = SanPhamBUS.Search_SP(ctpn.ma_sp);
sp.soluong = sp.soluong + ctpn.soluong;
txtDVT.Text = sp.ma_loai;
SanPhamBUS.Update_SP(sp);
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK);
TongTien = TongTien + ctpn.tong;
txtTongthanhtoan.Text = "" + TongTien + "";
load_data();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void Insert_CTPN(ChiTietPNDTO ctpn)
{
ChiTietPNDAO.insert_CTPN(ctpn);
}
public static void Update_CTPN(ChiTietPNDTO ctpn)
{
ChiTietPNDAO.Update_CTPNSP(ctpn);
}
