private void FocusedRowChanged_for_DDH_CHUANHAP()// lấy sự kiện click trong gridViewDDH_CHUANHAP load Data lên gridViewDDH_CHUANHAP { DataRow red = gridViewDDH_CHUANHAP.GetFocusedDataRow(); if (red == null) { return; } else { EventHandleForBtnHuy(); NgaylapDateEdit.Text = red["NGAY"].ToString(); string MADDH = red["MasoDDH"].ToString(); string[] param = { MADDH }; MDPhieuNhap phieunhap = new MDPhieuNhap(); pnhap = phieunhap.getChiTietDonDatHangTheoMa(param); sP_DS_CHITIET_DONDATHANG_THEOMAGridControl.DataSource = pnhap; sP_DS_CHITIET_DONDATHANG_THEOMAGridControl.DataMember = pnhap.TableName; if (label1.Text != "") { loadMaPN_TuDong(); } } }
private void loadDonHang_ChuaNhap() { MDPhieuNhap phieunhap = new MDPhieuNhap(); pnhap = phieunhap.getDS_DonDatHang_ChuaNhap(); sP_DS_DONDATHANG_CHUANHAPGridControl.DataSource = pnhap; sP_DS_DONDATHANG_CHUANHAPGridControl.DataMember = pnhap.TableName; }
private void load_DS_PhieuNhap() { MDPhieuNhap phieunhap = new MDPhieuNhap(); pnhap = phieunhap.getDS_PHIEUNHAP(); sP_DS_PHIEUNHAPGridControl.DataSource = pnhap; sP_DS_PHIEUNHAPGridControl.DataMember = pnhap.TableName; }
private void load_CTPN(string ct_pn) { string[] param = { ct_pn }; MDPhieuNhap phieunhap = new MDPhieuNhap(); pnhap = phieunhap.getChiTietPhieuNhap(param); sP_DS_CHITIET_PHIEUNHAPGridControl.DataSource = pnhap; sP_DS_CHITIET_PHIEUNHAPGridControl.DataMember = pnhap.TableName; }
private void loadMaPN_TuDong() { MDPhieuNhap phieunhap = new MDPhieuNhap(); maphieu = phieunhap.getMaPhieuNhap_TuDong(); maphieu.Read(); label1.Text = maphieu["MAPN"].ToString(); maphieu.Close(); }
private void cboxMaPhieuNhap_SelectedValueChanged(object sender, EventArgs e) { DataTable ppnn = new DataTable(); string mapn = cboxMaPhieuNhap.Text.ToString(); string[] param = { mapn }; MDPhieuNhap phieunhap = new MDPhieuNhap(); ppnn = phieunhap.getChiTietPhieuNhap(param); DS_CT_PNHAP.DataSource = ppnn; }
private void btnLapPhieuNhap_Click(object sender, EventArgs e) { try { int numberRow = gridViewChiTietPhieuNhap.RowCount; if (numberRow == 0) { MessageBox.Show("Nhập chị tiết Phiếu Nhập của đơn hàng"); return; } string mapn = label1.Text.ToString(); string maNV = Access.MANV.ToString(); string maKho = mKhoTbox.Text.ToString(); string strXML = "<Root>"; for (int i = 0; i < numberRow; i++) { strXML += "<PhieuNhap MAPN = \"" + mapn; strXML += "\" MAKHO =\"" + maKho; strXML += "\" MADDH =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[0]).ToString(); strXML += "\" MAVT =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[1]).ToString(); strXML += "\" MANV =\"" + maNV; strXML += "\" SL_NHAP =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[3]).ToString(); strXML += "\" DONGIA_NHAP =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[4]).ToString(); strXML += "\" />"; } strXML += "</Root>"; string[] param = { strXML }; MDPhieuNhap pnhap = new MDPhieuNhap(); int x = pnhap.CreatePhieuNhap(param); if (x == 0) { MessageBox.Show("Thêm Phiếu nhập : " + label1.Text + " thành công"); loadDonHang_ChuaNhap(); load_DS_PhieuNhap(); load_Chitiet_PN(); gridViewDDH_CHUANHAP.FocusedRowHandle = 1; EventHandleForBtnHuy(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } EventHandleForBtnHuy(); }
private void btnLapPhieuNhap_Click(object sender, EventArgs e) { try { int numberRow = gridViewChiTietPhieuNhap.RowCount; if (numberRow == 0) { MessageBox.Show("Nhập chị tiết Phiếu Nhập của đơn hàng"); return; } for (int i = 0; i < numberRow; i++) { string mapn = label1.Text.ToString(); string maddh = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[0]).ToString(); string mavt = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[1]).ToString(); string soluongnhap = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[3]).ToString(); string maNV = Access.MANV.ToString(); string dongia_nhap = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[4]).ToString(); string[] param = { mapn, maddh, mavt, maNV, soluongnhap, dongia_nhap }; MDPhieuNhap pnhap = new MDPhieuNhap(); int x = pnhap.CreatePhieuNhap(param); if (x == 0 && i == (numberRow - 1)) { MessageBox.Show("Thêm Phiếu nhập : " + label1.Text + " thành công"); loadDonHang_ChuaNhap(); load_DS_PhieuNhap(); load_Chitiet_PN(); EventHandleForBtnHuy(); } } } catch { MessageBox.Show("Them DDH that bai"); } EventHandleForBtnHuy(); }