public bool AddData(ChitietHoaDonObj cthdObj) { cmd.CommandText = "insert into ChiTietPhieuBan(MaHD,MaSach,SoLuong) values('" + cthdObj.Mahd + "','" + cthdObj.Masach + "','" + cthdObj.Soluong + "')"; cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(false); }
private void btnLuu_Click(object sender, EventArgs e) { bool a = false; ChitietHoaDonObj cthdObj = new ChitietHoaDonObj(); for (int k = 0; k < dtGRchitietHD.Rows.Count; k++) { cthdObj.Mahd = txtMaHD.Text; cthdObj.Masach = dtGRchitietHD.Rows[k].Cells[0].Value.ToString(); cthdObj.Soluong = int.Parse(dtGRchitietHD.Rows[k].Cells[2].Value.ToString()); a = cthdCtr.AddData(cthdObj); } if (a == true) { MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Thêm không thành công!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool AddData(ChitietHoaDonObj cthdObj) { return(cthdMod.AddData(cthdObj)); }