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);
}
