private void btnThem_Click(object sender, EventArgs e) { EC_CTDonDH CTDonDH = new EC_CTDonDH(); CTDonDH.MaDonDH = txtMaDonDH.Text; CTDonDH.MaHangHoa = cbxMaHH.Text; CTDonDH.SoLuong = nudSoLuong.Value.ToString(); CTDonDHs.Add(CTDonDH); this.dgvChiTiet.Rows.Add(cbxMaHH.Text, txtTenHH.Text, txtTenDVT.Text, nudSoLuong.Value.ToString()); //ActChiTiet.AddCTDonDHNCC(CTDonDHNCC); }
public void AddCTDonDH(EC_CTDonDH _ctdondh) { try { Connect.SqlConnect.Open(); string sqlquery = @"INSERT INTO tb_CTDonDH (madondh, mahang, soluong) VALUES (N'{0}',N'{1}','{2}')" ; sqlquery = string.Format(sqlquery, _ctdondh.MaDonDH, _ctdondh.MaHangHoa, _ctdondh.SoLuong); SqlCommand cmd = new SqlCommand(sqlquery, Connect.SqlConnect); cmd.ExecuteNonQuery(); Connect.SqlConnect.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void AddCTDonDH(EC_CTDonDH _ctdondh) { SqlCTDonDH.AddCTDonDH(_ctdondh); }