private void btXoa_Click(object sender, EventArgs e) { int i = 0, z = 0; int y = gridView2.RowCount; for (i = 0; i < y; i++) { bool check = (bool)gridView2.GetRowCellValue(i, gridView2.Columns[4]); if (check) { string mvattu = gridView2.GetRowCellValue(i, gridView2.Columns[0]).ToString(); gridView2.DeleteRow(i); string[] param = { maNCC, mvattu }; MDNhaCungCap nhacungcap = new MDNhaCungCap(); int x = nhacungcap.xoaVTNCC(param); y--; i = -1; } } //grvCTNCC.DataBindings.Clear(); //foreach (DataRow ct in ChiTietNCC.Rows) //{ // ct.Delete(); // if (ct != null) continue; //} //ChiTietNCC.Clear(); //gan lai du lieu vao datatable //for (z = 0; z < gridView2.RowCount; z++) //{ // ChiTietNCC.Rows.Add(gridView2.Columns[0], gridView2.Columns[1], gridView2.Columns[2], gridView2.Columns[3]); //} }
private void DSNCC_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { DataRow row = gridView1.GetFocusedDataRow(); maNCC = row[0].ToString(); tbTenNCC.Text = row[1].ToString(); tbTenNCC.ReadOnly = true; tbSDT.Text = row[3].ToString(); tbSDT.ReadOnly = true; tbDiaChi.Text = row[2].ToString(); tbDiaChi.ReadOnly = true; //MessageBox.Show(maNCC); string[] param = { maNCC }; MDNhaCungCap ncc = new MDNhaCungCap(); ctNCC = ncc.getCTNCC(param); //grvCTNCC.DataSource = ctNCC; //grvCTNCC.DataMember = ctNCC.TableName; ChiTietNCC.Clear(); foreach (DataRow ct in ctNCC.Rows) { ChiTietNCC.Rows.Add(ct[0], ct[1], ct[2], ct[3]); grvCTNCC.DataSource = ChiTietNCC; grvCTNCC.DataBindings.Clear(); } btTaoNCC.Enabled = false; }
private void NhaCungCap_Load(object sender, EventArgs e) { tbTenVT.ReadOnly = true; MDNhaCungCap nhaCungCap = new MDNhaCungCap(); nhaCC = nhaCungCap.getDSNCC(); grvNCC.DataSource = nhaCC; grvNCC.DataMember = nhaCC.TableName; //danh sach vat tu VatTu vt = new VatTu(); vatTu = vt.getVatTu(); grvDSVT.DataSource = vatTu; grvDSVT.DataMember = vatTu.TableName; GrvChiTietNCC(); BangTam(); }
private void btTaoNCC_Click(object sender, EventArgs e) { if (index == 0) { SqlDataReader ma; MDNhaCungCap ncc = new MDNhaCungCap(); ma = ncc.GetMaNCC(); ma.Read(); maNCC = ma["MANCC"].ToString(); ma.Close(); string tenNCC = tbTenNCC.Text; string sdt = tbSDT.Text; string diachi = tbDiaChi.Text; if (!IsNumber(sdt)) { MessageBox.Show("Số Điện Thoại Phải Là Số!"); } else { try { for (int i = 0; i < gridView2.RowCount; i++) { string vt = gridView2.GetRowCellValue(i, gridView2.Columns[0]).ToString(); string[] param = { maNCC, tenNCC, diachi, sdt, vt }; MDNhaCungCap nhacc = new MDNhaCungCap(); int x = nhacc.CreateNCC(param); if (x == 0 && i == gridView2.RowCount - 1) { MessageBox.Show("Bạn Đã Thêm Nhà Cung Cấp Thành Công!"); ChiTietNCC.Clear(); LoadLaiNCC(); } } } catch (Exception ex) { MessageBox.Show("Lỗi: " + ex.ToString()); } } } }
private void btThem_Click(object sender, EventArgs e) { for (int i = 0; i < gridView2.RowCount; i++) { string mavattu = gridView2.GetRowCellValue(i, gridView2.Columns[0]).ToString(); if (mavattu == maVT) { MessageBox.Show("Nhà Cung Cấp Đã Có Vật Tư Này!"); return; } } //ChiTietNCC.NewRow(); ChiTietNCC.Rows.Add(maVT, tenVT, maLoai, donVi); grvCTNCC.DataSource = ChiTietNCC; grvCTNCC.DataBindings.Clear(); if (maNCC != "") { string[] param = { maNCC.Trim(), maVT.Trim() }; MDNhaCungCap nhacungcap = new MDNhaCungCap(); int x = nhacungcap.ThemVTNCC(param); return; } }
private void LoadLaiNCC() { tbTenNCC.Text = ""; tbSDT.Text = ""; tbDiaChi.Text = ""; tbTenNCC.ReadOnly = false; tbSDT.ReadOnly = false; tbDiaChi.ReadOnly = false; tbTenVT.Text = ""; tbTenVT.ReadOnly = true; MDNhaCungCap nhaCungCap = new MDNhaCungCap(); nhaCC = nhaCungCap.getDSNCC(); grvNCC.DataSource = nhaCC; grvNCC.DataMember = nhaCC.TableName; //danh sach vat tu VatTu vt = new VatTu(); vatTu = vt.getVatTu(); grvDSVT.DataSource = vatTu; grvDSVT.DataMember = vatTu.TableName; }