public static void InsertCTPN(CTPNDTO ctpn)
{
SqlConnection con = dbConnection.HamKetNoi();
con.Open();
string sql = string.Format(@"INSERT INTO CTPN ([MaPhieuNhap], [MaSP], [SoLuong], [GiaNhap], [ThanhTien]) VALUES({0}, {1}, {2}, {3}, {4})", ctpn.MaPhieu, ctpn.MaSP, ctpn.SoLuong, ctpn.GiaNhap, ctpn.ThanhTien);
SqlCommand command = new SqlCommand(sql, con);
command.ExecuteNonQuery();
con.Close();
}
private void btnLuu_Click(object sender, EventArgs e)
{
int sl = int.Parse(txtSL.Text);
long gia = long.Parse(txtGiaNhap.Text);
long thanhtien = (long)sl * gia;
long masp = long.Parse(cbbMaSP.SelectedValue.ToString());
CTPNDTO ctpn = new CTPNDTO(maphieu, masp, sl, gia, thanhtien);
PhieuNhapBUS.InsertCTPN(ctpn);
dgvNhapHang.DataSource = PhieuNhapBUS.GetCTPN(maphieu);
}
public static void InsertCTPN(CTPNDTO ctpn)
{
PhieuNhapDAO.InsertCTPN(ctpn);
}
