public void Load_Data() { clsChi_Tiet_Phieu_Nhap_Vat_Tu pn = new clsChi_Tiet_Phieu_Nhap_Vat_Tu(); txtMaPhieuNhap.Text = maphieu; dtPhieuNhap = pn.GetAll(txtMaPhieuNhap.Text); gridDanhSachPhieuNhap.DataSource = dtPhieuNhap; clsGiaoDienChung.initCombobox(cbbPhieuNo, new clsBu_Tru_No_Phieu(), "Ma_phieu_nhap", "ID_phieu_nhap", "Ma_phieu_nhap"); }
private bool initEdit() { try { clsPhieuNhapKho clsNhap = new clsPhieuNhapKho(); clsNhap.Ma_phieu_nhap = txtMaPhieuNhap.Text; if (clsNhap.CheckTonTaiSoDK(txtMaPhieuNhap.Text) == true) { DataTable tb = clsNhap.GetAllPhieuNo(txtMaPhieuNhap.Text.Trim()); // dtNgayNhap.Text = tb.Rows[0]["Ngay_nhap"].ToString(); dtNgayNhap.CustomFormat = "dd-MM-yyyy"; dtNgayNhap.Value = Convert.ToDateTime(tb.Rows[0]["Ngay_lap"].ToString()); // dtNgayNhap.Text = string.Format("{0:dd/MM/yyyy}", tb.Rows[0]["Ngay_lap"]); txtLyDo.Text = tb.Rows[0]["Ly_do"].ToString(); // txtXuatTaiKho.Text = tb.Rows[0]["ID_kho"].ToString(); txtCongTrinh.Text = tb.Rows[0]["cong_trinh"].ToString(); cbKhoNhan.Text = tb.Rows[0]["Ten_kho"].ToString(); txtDiaChi.Text = tb.Rows[0]["Dia_chi"].ToString(); // cbLoaiPhieuNhan.SelectedValue = tb.Rows[0]["ID_Loai_Phieu_Nhap"].ToString(); // chbNGD.Checked =bool.Parse( tb.Rows[0]["isGoiDau"].ToString()); cbKhoNgoai.Text = tb.Rows[0]["Ten_kho_muon"].ToString(); rdoKCMuonNo.Checked =bool.Parse( tb.Rows[0]["isKCMN"].ToString()); rdoKCTN.Checked = bool.Parse(tb.Rows[0]["isKCTN"].ToString()); rdoKNMN.Checked = bool.Parse(tb.Rows[0]["isKNMN"].ToString()); rdoKNTN.Checked = bool.Parse(tb.Rows[0]["isKNTN"].ToString()); clsChi_Tiet_Phieu_Nhap_Vat_Tu chitiet = new clsChi_Tiet_Phieu_Nhap_Vat_Tu(); DataTable vChiTiet = (DataTable)chitiet.GetAll(txtMaPhieuNhap.Text); for (int i = 0; i < vChiTiet.Rows.Count; i++) { // dataTable1.Rows[i]["Ma_phieu_nhap"] = vChiTiet.Rows[i]["ma_phieu_nhap"].ToString(); DataRow dr = dataTable1.NewRow(); //dr["Ma_vat_tu"] = vChiTiet.Rows[i]["ma_phieu_nhap"].ToString(); dr["ma_vat_tu"] = vChiTiet.Rows[i]["ma_vat_tu"].ToString(); dr["Ten_vat_tu"] = vChiTiet.Rows[i]["Ten_vat_tu"].ToString(); // dr["don_vi_tinh"] = vChiTiet.Rows[i]["don_vi_tinh"].ToString() ; dr["chat_luong"] = vChiTiet.Rows[i]["chat_luong"].ToString(); dr["ID_chat_luong"] = vChiTiet.Rows[i]["ID_chat_luong"].ToString(); dr["so_luong_thuc_lanh"] = vChiTiet.Rows[i]["so_luong_thuc_lanh"].ToString(); dr["don_gia"] = vChiTiet.Rows[i]["don_gia"].ToString(); dr["Thanh_tien"] = vChiTiet.Rows[i]["thanh_tien"].ToString();// int.Parse(vChiTiet.Rows[i]["don_gia"].ToString()) * int.Parse(vChiTiet.Rows[i]["so_luong_thuc_lanh"].ToString()); dr["Ten_Don_vi_tinh"] = vChiTiet.Rows[i]["ten_don_vi_tinh"].ToString(); dr["ID_Don_vi_tinh"] = vChiTiet.Rows[i]["ID_don_vi_tinh"].ToString(); dataTable1.Rows.Add(dr); } if (clsChi_Tiet_Phieu_Nhap_Vat_Tu.KTVTChuaDuyet(clsNhap.Ma_phieu_nhap) == true) { //khong cho sua thong tin tren luoi disableInputForm(); MessageBox.Show("Phiếu nhập này chứa vật tư đã phân vào kho, không thể chỉnh sữa thông tin."); return false; } //MessageBox.Show("Tồn tại mã phiếu nhập trong csdl"); return true; } else { //MessageBox.Show("Chưa Tồn tại mã phiếu nhập trong csdl"); } } catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); } return false; }
private void Load_DataNo() { clsChi_Tiet_Phieu_Nhap_Vat_Tu pn = new clsChi_Tiet_Phieu_Nhap_Vat_Tu(); dtPhieuNhapNo = pn.GetAll(cbbPhieuNo.GetItemText(this.cbbPhieuNo.SelectedItem)); gridNhapNo.DataSource = dtPhieuNhapNo; }