private void btnThem_Click(object sender, EventArgs e) { EC_CTDonDHNCC CTDonDHNCC = new EC_CTDonDHNCC(); CTDonDHNCC.MaDonDHNCC = txtMaDonDHNCC.Text; CTDonDHNCC.MaHangHoa = cbxMaHH.Text; CTDonDHNCC.SoLuong = nudSoLuong.Value.ToString(); CTDonDHNCCs.Add(CTDonDHNCC); this.dgvChiTiet.Rows.Add(cbxMaHH.Text, txtTenHH.Text, txtTenDVT.Text, nudSoLuong.Value.ToString()); //ActChiTiet.AddCTDonDHNCC(CTDonDHNCC); //dgvChiTiet.DataSource = ActChiTiet.CreateTbCTDonDHNCC(txtMaDonDHNCC.Text); }
public void AddCTDonDHNCC(EC_CTDonDHNCC _ctdondhncc) { try { Connect.SqlConnect.Open(); string sqlquery = @"INSERT INTO tb_CTDonDHNCC (madhncc, mahang, soluong) VALUES (N'{0}',N'{1}','{2}')" ; sqlquery = string.Format(sqlquery, _ctdondhncc.MaDonDHNCC, _ctdondhncc.MaHangHoa, _ctdondhncc.SoLuong); SqlCommand cmd = new SqlCommand(sqlquery, Connect.SqlConnect); cmd.ExecuteNonQuery(); Connect.SqlConnect.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void AddCTDonDHNCC(EC_CTDonDHNCC _ctdondhncc) { SqlCTDonDHNCC.AddCTDonDHNCC(_ctdondhncc); }