private void btnThem_Click(object sender, EventArgs e) { try { idKho = (int)cbKhoNhanVatTu.SelectedValue; } catch (Exception ex) { MessageBox.Show("Bạn chưa chọn kho "); } //progressAll.Maximum = gridDanhSachPhieuNhap.Rows.Count; //backgroundWorker1.RunWorkerAsync(); try { Int32 selectedRowCount = gridDanhSachPhieuNhap.CurrentCell.RowIndex; DataGridViewRow SelectedRow = gridDanhSachPhieuNhap.Rows[selectedRowCount]; string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString(); string maphieu = SelectedRow.Cells["Ma_phieu_nhap"].Value.ToString(); if (cbKhoNhanVatTu.Text == "") { MessageBox.Show("Bạn chưa chọn kho để phân vật tư"); return; } // string soluong = SelectedRow.Cells["So_luong"].Value.ToString(); string tenvt = SelectedRow.Cells["Ten_vat_tu"].Value.ToString(); string tenkho = cbKhoNhanVatTu.Text; decimal soluong = decimal.Parse(SelectedRow.Cells["So_luong_thuc_lanh"].Value.ToString()); // string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString(); int idcl = int.Parse(SelectedRow.Cells["ID_chat_luong"].Value.ToString()); frmChiTietNhanVatTu ob = new frmChiTietNhanVatTu(this, maphieu, mavt, idKho, soluong, tenvt, tenkho, idcl); ob.Show(); //show child } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void InProgress() { if (chbChonTatCa.Checked == false) { try { Int32 selectedRowCount = gridDanhSachPhieuNhap.CurrentCell.RowIndex; DataGridViewRow SelectedRow = gridDanhSachPhieuNhap.Rows[selectedRowCount]; string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString(); string maphieu = SelectedRow.Cells["Ma_phieu_nhap"].Value.ToString(); if (cbKhoNhanVatTu.Text == "") { MessageBox.Show("Bạn chưa chọn kho để phân vật tư"); return; } // string soluong = SelectedRow.Cells["So_luong"].Value.ToString(); string tenvt = SelectedRow.Cells["Ten_vat_tu"].Value.ToString(); string tenkho = cbKhoNhanVatTu.Text; decimal soluong = decimal.Parse(SelectedRow.Cells["So_luong_thuc_lanh"].Value.ToString()); // string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString(); int idcl = int.Parse(SelectedRow.Cells["ID_chat_luong"].Value.ToString()); frmChiTietNhanVatTu ob = new frmChiTietNhanVatTu(this, maphieu, mavt, idKho, soluong, tenvt, tenkho, idcl); ob.Show(); //show child } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { //txtRunning.Visible = true; //progressAll.Visible = true; DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { for (int i = 0; i < gridDanhSachPhieuNhap.Rows.Count; i++) { string mavt = gridDanhSachPhieuNhap.Rows[i].Cells["Ma_vat_tu"].Value.ToString(); string maphieu = gridDanhSachPhieuNhap.Rows[i].Cells["Ma_phieu_nhap"].Value.ToString(); string tenvt = gridDanhSachPhieuNhap.Rows[i].Cells["Ten_vat_tu"].Value.ToString(); // string tenkho = cbKhoNhanVatTu.Text; decimal soluong = decimal.Parse(gridDanhSachPhieuNhap.Rows[i].Cells["So_luong_thuc_lanh"].Value.ToString()); int idcl = int.Parse(gridDanhSachPhieuNhap.Rows[i].Cells["ID_chat_luong"].Value.ToString()); clsXuLyDuLieuChung dc = new clsXuLyDuLieuChung(); DateTime ngayNhap = DateTime.Now; try { if (dc.InsertTonKho(help, mavt, idKho, soluong, maphieu, ngayNhap, idcl,true) == 0) { dbcxtransaction.Rollback(); MessageBox.Show("Thêm thất bại tại dòng " + i); return; } } catch (Exception ex) { dbcxtransaction.Rollback(); MessageBox.Show("Thêm thất bại tại dòng " + i); return; } //dbcxtransaction.Commit(); backgroundWorker1.ReportProgress(i); } dbcxtransaction.Commit(); } } }