private void cbMaVatTu_SelectedIndexChanged(object sender, EventArgs e) { DataTable table = new clsDMVatTu().getThongTinTuMaVT(cbMaVatTu.GetItemText(this.cbMaVatTu.SelectedItem));// cbMaVatTu.Text); if (table.Rows.Count == 0) return; cbTenVatTu.Text = table.Rows[0]["ten_vat_tu"].ToString(); }
public void Init() { cbMaVatTu.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbMaVatTu.AutoCompleteSource = AutoCompleteSource.CustomSource; clsDMVatTu vt = new clsDMVatTu(); clsGiaoDienChung.initCombobox(cbMaVatTu, new clsDMVatTu(), "Ma_vat_tu", "ID_Vat_tu", "Ma_vat_tu"); clsGiaoDienChung.initCombobox(cbTenVatTu, new clsDMVatTu(), "Ten_vat_tu", "ID_Vat_tu", "Ten_vat_tu"); clsGiaoDienChung.initCombobox(cbChatLuong, new clsDMChatLuong(), "Loai_chat_luong", "ID_chat_luong", "Loai_chat_luong"); cbMaVatTu.SelectedIndex = -1; }
private void cbTenVatTu_SelectedIndexChanged(object sender, EventArgs e) { clsDMVatTu vattu = new clsDMVatTu(); string Ma_Vat_Tu = vattu.getMaVatTu(cbTenVatTu.GetItemText(this.cbTenVatTu.SelectedItem)); cbMaVatTu.Text = Ma_Vat_Tu; DataTable table = vattu.getData_By_MaVatTu(Ma_Vat_Tu); if (table.Rows.Count == 0) return; cbMaVatTu.Text = table.Rows[0]["ma_vat_tu"].ToString(); }
private void btnGridSave_Click(object sender, EventArgs e) { try { Int32 selectedRowCount = gridMaster.CurrentCell.RowIndex; if (dataTable1.Rows.Count == 0 || selectedRowCount >= dataTable1.Rows.Count) return; if (PanelButton.getClickStatus() == enumButton2.SuaLuoi) { gridMaster.Rows[selectedRowCount].Cells["ma_vat_tu"].Value = cbMaVatTu.Text; gridMaster.Rows[selectedRowCount].Cells["ten_vat_tu"].Value = cbTenVatTu.Text; gridMaster.Rows[selectedRowCount].Cells["ten_don_vi_tinh"].Value = txtDVT.Text; gridMaster.Rows[selectedRowCount].Cells["chat_luong"].Value = cbChatLuong.Text; gridMaster.Rows[selectedRowCount].Cells["ID_chat_luong"].Value = cbChatLuong.SelectedValue; // gridMaster.Rows[selectedRowCount].Cells["so_luong_yeu_cau"].Value = txtSLYC.Text; gridMaster.Rows[selectedRowCount].Cells["so_luong_thuc_lanh"].Value = txtSLTX.Text; gridMaster.Rows[selectedRowCount].Cells["don_gia"].Value = txtDonGia.Text; clsDMVatTu vt = new clsDMVatTu(); DataTable temp = vt.GetAll(cbMaVatTu.Text); gridMaster.Rows[selectedRowCount].Cells["ID_don_vi_tinh"].Value = temp.Rows[0]["ID_Don_vi_tinh"]; if (txtDonGia.Text == "") txtDonGia.Text = "0"; gridMaster.Rows[selectedRowCount].Cells["thanh_tien"].Value =double.Parse( txtDonGia.Text)*int.Parse(txtSLTX.Text); PanelButton.setClickStatus( sttaf); } if (PanelButton.getClickStatus() == enumButton2.XoaLuoi) { dataTable1.Rows.RemoveAt(selectedRowCount); PanelButton.setClickStatus(sttaf); } setInputComponentStatus(true); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnGridAdd_Click(object sender, EventArgs e) { try { if(cbKhoNhan.Text =="") { MessageBox.Show("vui lòng chọn kho trước khi cho mượn vật tư"); return; } sttaf = PanelButton.getClickStatus(); if (cbMaVatTu.Text == "" || cbTenVatTu.Text == "" || cbChatLuong.Text == "") { MessageBox.Show("Mã vật tư và tên vật tư không được rỗng, Chất lượng bắt buộc nhập !"); return; } if (isLoaiPhieu == "KNMN" || isLoaiPhieu == "KCTN") { clsTonKho checkton = new clsTonKho(); decimal temp = checkton.checkSLTonChoMuon((int)cbKhoNhan.SelectedValue, cbMaVatTu.Text, (int)cbChatLuong.SelectedValue, int.Parse(txtSLTX.Text)); if (temp < int.Parse(txtSLTX.Text)) { MessageBox.Show("Số lượng vật tư mượn phải nhỏ hơn số lượng trong kho,Không thể cho mượn đối với vật tư này!Số lượng còn lại trong kho: "+ temp ); return; } } DataRow[] result = dataTable1.Select("Ma_vat_tu =" + cbMaVatTu.Text +" and ID_chat_luong =" +cbChatLuong.SelectedValue ); if (result.Length == 0) { try { DataRow dr = dataTable1.NewRow(); dr["Ma_vat_tu"] = cbMaVatTu.Text; dr["ten_vat_tu"] = cbTenVatTu.Text; dr["Ten_don_vi_tinh"] = txtDVT.Text; dr["chat_luong"] = cbChatLuong.Text; dr["ID_chat_luong"] = cbChatLuong.SelectedValue; // dr["so_luong_yeu_cau"] = txtSLYC.Text; dr["so_luong_thuc_lanh"] = txtSLTX.Text; dr["don_gia"] = txtDonGia.Text; clsDMVatTu vt = new clsDMVatTu(); DataTable temp = vt.GetAll(cbMaVatTu.Text); dr["ID_don_vi_tinh"] = temp.Rows[0]["ID_Don_vi_tinh"]; if (txtDonGia.Text == "") txtDonGia.Text = "0"; dr["thanh_tien"] = double.Parse(txtDonGia.Text) * double.Parse(txtSLTX.Text) == 0; dataTable1.Rows.Add(dr); ResetGridInputForm(); PanelButton.setClickStatus(sttaf); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else MessageBox.Show("Đã tồn tại mã vật tư này rồi !"); // gridMaster.SelectedRows. } catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); } }
private void initVatTuData() { Int32 selectedRowCount = gridMaster.CurrentCell.RowIndex; string Ma_Vat_Tu = cbMaVatTu.GetItemText(cbMaVatTu.SelectedItem); clsDMVatTu vattu = new clsDMVatTu(); string Ten_Vat_Tu = vattu.getTenVatTu(Ma_Vat_Tu); cbTenVatTu.Text = Ten_Vat_Tu; DataTable tb = vattu.getData_By_MaVatTu(Ma_Vat_Tu); txtDVT.Text = tb.Rows[0]["Ten_don_vi_tinh"].ToString(); txtDonGia.Text = gridMaster.Rows[selectedRowCount].Cells["Don_gia"].Value.ToString();// tb.Rows[0]["Don_gia"].ToString(); cbChatLuong.Text = gridMaster.Rows[selectedRowCount].Cells["chat_luong"].Value.ToString(); }
private void cbMaVatTu_SelectionChangeCommitted(object sender, EventArgs e) { try { ComboBox c = (ComboBox)sender; //DataRowView dtv = c.Items[c.SelectedIndex] as DataRowView ; string Ma_Vat_Tu = c.GetItemText(c.SelectedItem); clsDMVatTu vattu = new clsDMVatTu(); string Ten_Vat_Tu = vattu.getTenVatTu(Ma_Vat_Tu); cbTenVatTu.Text = Ten_Vat_Tu; DataTable tb = vattu.getData_By_MaVatTu(Ma_Vat_Tu); txtDVT.Text = tb.Rows[0]["Ten_don_vi_tinh"].ToString(); txtDonGia.Text = tb.Rows[0]["Don_gia"].ToString(); } catch (Exception ex) { } }
private void gridMaster_EditingControlShowing_1(object sender, DataGridViewEditingControlShowingEventArgs e) { try { int row = gridMaster.CurrentCell.RowIndex; int column = gridMaster.CurrentCell.ColumnIndex; string headerText = gridMaster.Columns[column].Name; if (headerText.Equals("Ma_vat_tu")) { TextBox tb = e.Control as TextBox; clsDMVatTu vattu = new clsDMVatTu(); if (tb != null) { tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tb.AutoCompleteCustomSource = vattu.getListToCombobox("ma_vat_tu");// AutoCompleteLoad; tb.AutoCompleteSource = AutoCompleteSource.CustomSource; } } if (headerText.Equals("Chat_luong")) { TextBox tb = e.Control as TextBox; clsDMChatLuong cl = new clsDMChatLuong(); if (tb != null) { tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tb.AutoCompleteCustomSource = cl.getListToCombobox("loai_chat_luong");// AutoCompleteLoad; tb.AutoCompleteSource = AutoCompleteSource.CustomSource; } } if (headerText.Equals("Ten_vat_tu")) { TextBox tb = e.Control as TextBox; clsDMVatTu cl = new clsDMVatTu(); if (tb != null) { tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tb.AutoCompleteCustomSource = cl.getListToCombobox("Ten_vat_tu");// AutoCompleteLoad; tb.AutoCompleteSource = AutoCompleteSource.CustomSource; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnGridAdd_Click(object sender, EventArgs e) { try { sttaf = PanelButton.getClickStatus(); if ((double.Parse(txtSLYC.Text)) < 0 || (double.Parse(txtSLTX.Text)) < 0) { MessageBox.Show("Số lượng vật tư không được phép giá trị âm !"); return; } if (cbMaVatTu.Text == "" || cbTenVatTu.Text == "" || cbChatLuong.Text == "") { MessageBox.Show("Mã vật tư và tên vật tư không được rỗng, Chất lượng bắt buộc nhập !"); return; } DataRow[] result = dataTable1.Select("Ma_vat_tu =" + cbMaVatTu.Text + " and ID_chat_luong =" + cbChatLuong.SelectedValue); if (result.Length == 0) { try { DataRow dr = dataTable1.NewRow(); dr["Ma_vat_tu"] = cbMaVatTu.Text; dr["ten_vat_tu"] = cbTenVatTu.Text; dr["Ten_don_vi_tinh"] = txtDVT.Text; dr["chat_luong"] = cbChatLuong.Text; dr["ID_chat_luong"] = cbChatLuong.SelectedValue; dr["so_luong_yeu_cau"] = txtSLYC.Text; dr["so_luong_thuc_lanh"] = txtSLTX.Text; dr["don_gia"] = txtDonGia.Text; clsDMVatTu vt = new clsDMVatTu(); DataTable temp = vt.GetAll(cbMaVatTu.Text); dr["ID_don_vi_tinh"] = temp.Rows[0]["ID_Don_vi_tinh"]; if (txtDonGia.Text == "") txtDonGia.Text = "0"; dr["thanh_tien"] = double.Parse(txtDonGia.Text) * double.Parse(txtSLTX.Text) == 0; dataTable1.Rows.Add(dr); ResetGridInputForm(); PanelButton.setClickStatus(sttaf); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else MessageBox.Show("Đã tồn tại mã vật tư này rồi !"); // gridMaster.SelectedRows. } catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); } }
private void init_cbTenVatTu_ALL() { cbTenVatTu.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbTenVatTu.AutoCompleteSource = AutoCompleteSource.CustomSource; clsDMVatTu vt = new clsDMVatTu(); AutoCompleteStringCollection combData1 = vt.getListTenVatTu(); cbTenVatTu.AutoCompleteCustomSource = combData1; cbTenVatTu.DataSource = vt.getAll_Ma_Ten_VatTu(); cbTenVatTu.ValueMember = "ID_Vat_tu"; cbTenVatTu.DisplayMember = "Ten_vat_tu"; cbTenVatTu.SelectedIndex = -1; }
/// <summary> /// txtSL: /// [ ] Nếu ko mượn vt từ kho khác, luôn lấy SL từ kho xuất /// </summary> private void setInfoVatTu(string ID_Vat_tu) { clsDMVatTu vt = new clsDMVatTu(); txtDVT.Text = vt.getDVT_from_IDVT(ID_Vat_tu); //txtSL.Text = "-"; ////txtSL //string ID_Kho = ""; //if (chkboxEnableMuonVT.Checked) //{ // ID_Kho = cbMuonVTTaiKho.SelectedValue.ToString(); //} //else //{ // ID_Kho = cbKhoXuat.SelectedValue.ToString(); //} //if (Int32.Parse(ID_Kho) >= 0) //{ // string Ma_vat_tu = vt.getMaVT_from_IDVT(ID_Vat_tu); // //clsTonKho TonKho = new clsTonKho(); // //txtSL.Text = TonKho.getSL_from_MaVatTu(Ma_vat_tu, ID_Kho); //} }
/// <summary> /// hàm này tiến hành cập nhật lại CSDL rất lớn liên quang 5000 dòng /// /// </summary> public void ChuyenDoi() { DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); // insert using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { try { for (int i = 0; i < tb.Rows.Count - 1; i++) { string Ma_phieu_nhap = tb.Rows[i]["column1"].ToString(); DateTime Ngay_lap = DateTime.Parse(tb.Rows[i]["column2"].ToString()); string Kho_nhan = tb.Rows[i]["column3"].ToString(); string Ly_do = tb.Rows[i]["column4"].ToString(); string Ma_vat_tu = tb.Rows[i]["column5"].ToString(); string Ten_vat_tu = tb.Rows[i]["column6"].ToString(); string Chat_luong = tb.Rows[i]["column7"].ToString(); string DVT = tb.Rows[i]["column8"].ToString(); string So_luong_thuc_lanh = tb.Rows[i]["column9"].ToString(); string Don_gia = tb.Rows[i]["column10"].ToString(); string Thanh_tien = tb.Rows[i]["column11"].ToString(); clsPhieuNhapKho pnk = new clsPhieuNhapKho(); if (pnk.CheckTonTaiSoDK(Ma_phieu_nhap, help) == false) { pnk.Ma_phieu_nhap = Ma_phieu_nhap; pnk.isGoiDau = rdoPhieuGoiDau.Checked; pnk.isCanTru = false; pnk.Ngay_lap = Ngay_lap; pnk.Kho_nhan = Kho_nhan; pnk.Ly_do = Ly_do; clsLoaiPhieuNhap LPN = new clsLoaiPhieuNhap(); LPN.Ma_LPN = Loai_PN; pnk.ID_Loai_Phieu_Nhap = LPN.GetFirst(help); pnk.ID_khoNhan = idkho; if ( pnk.Insert(help) == 0) { dbcxtransaction.Rollback(); MessageBox.Show("insert thất bại tại dòng !" + i); return; } } clsChi_Tiet_Phieu_Nhap_Vat_Tu ctpn = new clsChi_Tiet_Phieu_Nhap_Vat_Tu(); ctpn.Ma_vat_tu = Ma_vat_tu; ctpn.Ma_phieu_nhap = Ma_phieu_nhap; ctpn.ID_Chat_luong = Chat_luong.Contains("mới") ? 1 : 2; //kiểm tra xem vật tư đã có trong csdl chưa nếu chưa thêm vào clsDM_DonViTinh DMDVT = new clsDM_DonViTinh(); if (ctpn.CheckTonTaiSoDK(help) == false) { DMDVT.Ten_don_vi_tinh = DVT; if (DMDVT.hasDuplicateRow(help) == false) { //nếu chưa có thì insert dòng mới DMDVT.Insert(help); } //tiến hành insert 5000 dòng dữ liệu từ phiếu nhập } ctpn.ID_Don_vi_tinh = DMDVT.getMATuTen(DVT, help); //kiểm tra mã vật tư đã tồn tại chưa trong CSDL clsDMVatTu vt = new clsDMVatTu(); vt.Ma_vat_tu = Ma_vat_tu; vt.Ten_vat_tu = Ten_vat_tu; vt.ID_Don_vi_tinh = ctpn.ID_Don_vi_tinh; if (vt.KiemTraTrungMa(help) == false) { vt.Insert(help); } ctpn.So_luong_thuc_lanh = decimal.Parse(So_luong_thuc_lanh); ctpn.Insert(help); backgroundWorker1.ReportProgress(i); } dbcxtransaction.Commit(); backgroundWorker1.ReportProgress(0); MessageBox.Show("Thêm thành công!"); } catch (Exception ex) { dbcxtransaction.Rollback(); // Get stack trace for the exception with source file information MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); return; } } }
/// <summary> /// Initializes --> combobox kho nhap. /// </summary> private void initTenVatTu() { clsDMVatTu DMVatTu = new clsDMVatTu(); cbTenVatTu.DisplayMember = "Ten_vat_tu"; cbTenVatTu.ValueMember = "id"; cbTenVatTu.DataSource = DMVatTu.GetAll_for_cb(); cbTenVatTu.SelectedIndex = -1; }
private void cbMaVatTu_KeyDown(object sender, KeyEventArgs e) { try { DataTable table = new clsDMVatTu().getThongTinTuMaVT(cbMaVatTu.GetItemText(this.cbMaVatTu.SelectedItem));// cbMaVatTu.Text); if (table.Rows.Count == 0) return; cbTenVatTu.Text = table.Rows[0]["ten_vat_tu"].ToString(); int iddvt = int.Parse(table.Rows[0]["ID_don_vi_tinh"].ToString()); clsDM_DonViTinh dvt = new clsDM_DonViTinh(); string tenDVT = dvt.getTenDVTTuMa(iddvt); txtDVT.Text = tenDVT; } catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); } }
private void cbTenVatTu_SelectionChangeCommitted(object sender, EventArgs e) { try { ComboBox c = (ComboBox)sender; string Ten_Vat_Tu = c.GetItemText(c.SelectedItem); clsDMVatTu vattu = new clsDMVatTu(); string Ma_Vat_Tu = vattu.getMaVatTu(Ten_Vat_Tu); cbMaVatTu.Text = Ma_Vat_Tu; DataTable tb = vattu.getData_By_MaVatTu(Ma_Vat_Tu); txtDVT.Text = tb.Rows[0]["Ten_don_vi_tinh"].ToString(); txtDonGia.Text = tb.Rows[0]["Don_gia"].ToString(); txtSoLuongTon.Text = new clsTonKho().checkKho_VatTu((int)cbKhoNhan.SelectedValue, cbMaVatTu.Text, (int)cbChatLuong.SelectedValue).ToString(); } catch (Exception ex) { } }
private void gridMaster_CellEndEdit(object sender, DataGridViewCellEventArgs e) { try { int column = gridMaster.CurrentCell.ColumnIndex; string forcus = gridMaster.Columns[column].Name; int row = gridMaster.CurrentCell.RowIndex; if (forcus.ToLower().Equals("ma_vat_tu")) { clsDMVatTu vattu = new clsDMVatTu(); string mavattu = gridMaster.Rows[row].Cells["Ma_vat_tu"].Value.ToString(); DataTable temp = vattu.getData_By_MaVatTu(mavattu); if (temp == null) return; gridMaster.Rows[row].Cells["Ten_vat_tu"].Value = temp.Rows[0]["ten_vat_tu"]; gridMaster.Rows[row].Cells["Ten_don_vi_tinh"].Value = temp.Rows[0]["Ten_don_vi_tinh"]; gridMaster.Rows[row].Cells["Don_gia"].Value = temp.Rows[0]["Don_gia"]; gridMaster.Rows[row].Cells["id_don_vi_tinh"].Value = temp.Rows[0]["id_don_vi_tinh"]; } if (forcus.ToLower().Equals("ten_vat_tu")) { clsDMVatTu vattu = new clsDMVatTu(); string tenvattu = gridMaster.Rows[row].Cells["Ten_vat_tu"].Value.ToString(); DataTable temp = vattu.getTenVatTuData(tenvattu); if (temp == null) return; gridMaster.Rows[row].Cells["Ma_vat_tu"].Value = temp.Rows[0]["Ma_vat_tu"]; gridMaster.Rows[row].Cells["Ten_don_vi_tinh"].Value = temp.Rows[0]["Ten_don_vi_tinh"]; gridMaster.Rows[row].Cells["Don_gia"].Value = temp.Rows[0]["Don_gia"]; gridMaster.Rows[row].Cells["id_don_vi_tinh"].Value = temp.Rows[0]["id_don_vi_tinh"]; } // gridMaster.Rows[row].Cells["Chat_luong"].Selected = true; //gridMaster.CurrentCell = gridMaster.Rows[row].Cells["Chat_luong"]; //gridMaster.BeginEdit(true); //gridMaster.CurrentCell.Selected = true; clsDMChatLuong cl = new clsDMChatLuong(); string ten_chat_luong = gridMaster.Rows[row].Cells["chat_luong"].Value == null ? "" : gridMaster.Rows[row].Cells["chat_luong"].Value.ToString(); if (ten_chat_luong != "") { gridMaster.Rows[row].Cells["id_chat_luong"].Value = cl.getIDChatLuong(ten_chat_luong); } } catch (Exception ex) { } }
private void cbMaVatTu_SelectedIndexChanged(object sender, EventArgs e) { try { DataTable table = new clsDMVatTu().getThongTinTuMaVT(cbMaVatTu.GetItemText(this.cbMaVatTu.SelectedItem));// cbMaVatTu.Text); if (table.Rows.Count == 0) return; cbTenVatTu.Text = table.Rows[0]["ten_vat_tu"].ToString(); } catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); } }
private void cbTenVatTu_SelectionChangeCommitted(object sender, EventArgs e) { clsDMVatTu vattu = new clsDMVatTu(); string Ma_Vat_Tu = vattu.getMaVatTu(cbTenVatTu.GetItemText(this.cbTenVatTu.SelectedItem)); cbMaVatTu.Text = Ma_Vat_Tu; DataTable table = vattu.getData_By_MaVatTu(Ma_Vat_Tu); if (table.Rows.Count == 0) return; cbMaVatTu.Text = table.Rows[0]["ma_vat_tu"].ToString(); int iddvt = int.Parse(table.Rows[0]["ID_don_vi_tinh"].ToString()); clsDM_DonViTinh dvt = new clsDM_DonViTinh(); string tenDVT = dvt.getTenDVTTuMa(iddvt); txtDVT.Text = tenDVT; }