public void AddCTHDB(EC_ChiTietHDB _cthdb)
{
try
{
Connect.SqlConnect.Open();
string sqlquery = @"INSERT INTO tb_CTHDB
(sohdb, mahang, soluong, thanhtien)
VALUES (N'{0}',N'{1}','{2}', '{3}')" ;
sqlquery = string.Format(sqlquery, _cthdb.SoHDB, _cthdb.MaHang, _cthdb.SoLuong, _cthdb.ThanhTien);
SqlCommand cmd = new SqlCommand(sqlquery, Connect.SqlConnect);
cmd.ExecuteNonQuery();
Connect.SqlConnect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
string thanhtien = Convert.ToString(Convert.ToInt32(txtDGB.Text) * Convert.ToInt32(nudSoLuong.Text));
TongTien += Convert.ToInt32(thanhtien);
txtTongTien.Text = TongTien.ToString();
//HoaDonBan.TongTien = txtTongTien.Text;
//Act.UpdateHDB(HoaDonBan);
EC_ChiTietHDB CTHDB = new EC_ChiTietHDB();
CTHDB.SoHDB = txtMaHD.Text;
CTHDB.MaHang = cbxMaHH.Text;
CTHDB.SoLuong = nudSoLuong.Value.ToString();
CTHDB.ThanhTien = thanhtien;
CTHDBs.Add(CTHDB);
this.dgvChiTiet.Rows.Add(cbxMaHH.Text, txtTenHH.Text, txtTenDVT.Text, txtDGB.Text, nudSoLuong.Value.ToString(), thanhtien);
//ActCTHDB.AddCTHDB(CTHDB);
//dgvChiTiet.DataSource = ActCTHDB.CreateTbCTHDB(txtMaHD.Text);
}
public void AddCTHDB(EC_ChiTietHDB _cthdb)
{
SqlCTHDB.AddCTHDB(_cthdb);
}
