private void btnLapPhieuChi_Click(object sender, EventArgs e) { GridView gridView = grcDanhSachCongNoPhaiChi.FocusedView as GridView; var maPhieu = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaPhieu");// lấy được mã phiếu var ngayLap = gridView.GetRowCellValue(gridView.FocusedRowHandle, "NgayLap"); var tenNCC = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TenNCC"); var maNCC = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaNCC"); var soTien = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TongTienTra"); if (maPhieu == null) { XtraMessageBox.Show("Mời bạn chọn mã phiếu nhập hàng cần xóa"); } else { PhieuChiTien phieuChi = new PhieuChiTien(); phieuChi.MaChungTu = (string)maPhieu; phieuChi.NgayLap = (DateTime)ngayLap; phieuChi.SoTien = (float)Convert.ToDouble(soTien); phieuChi.TenNCC = (string)tenNCC; phieuChi.MaNCC = (string)maNCC; frmPay_LapPhieuChi fCM_LapPhieuChi = new frmPay_LapPhieuChi(phieuChi); fCM_LapPhieuChi.ShowDialog(); grcDanhSachCongNoPhaiChi.DataSource = inforBuy.getListInforDetailBuyConNo(); } }
private void btnLapPhieuChi_Click(object sender, EventArgs e) { GridView gridView = grcBangKePhieuThanhToanNgay.FocusedView as GridView; var maPhieu = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaPhieu");// lấy được mã phiếu var ngayLap = gridView.GetRowCellValue(gridView.FocusedRowHandle, "NgayLap"); var tenNCC = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TenNCC"); var maNCC = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaNCC"); var soTien = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TongTienTra"); int checkInPhieuChi = inforBuy.checkMaChungTuInPhieuChi((string)maPhieu); if (checkInPhieuChi == 1) { DialogResult dr; dr = XtraMessageBox.Show("Đơn hàng đã được chi tiền.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (maPhieu == null) { XtraMessageBox.Show("Mời bạn chọn mã phiếu nhập hàng cần xóa"); } else { PhieuChiTien phieuChi = new PhieuChiTien(); phieuChi.MaChungTu = (string)maPhieu; phieuChi.NgayLap = (DateTime)ngayLap; phieuChi.SoTien = (float)Convert.ToDouble(soTien); phieuChi.TenNCC = (string)tenNCC; phieuChi.MaNCC = (string)maNCC; frmPay_LapPhieuChi fCM_LapPhieuChi = new frmPay_LapPhieuChi(phieuChi); fCM_LapPhieuChi.ShowDialog(); grcBangKePhieuThanhToanNgay.DataSource = inforBuy.getListMuaTraNgay(a, a, 0); } }
public int ThemPhieuChi(PhieuChiTien pc) { string sql = "insert into PHIEUCHITIEN(MaNCC, MaPhieuXuat,NgayLap,SoTien,ConNo,SoTienTra,MaNV,LyDo) " + string.Format("values ('{0}','{1}','{2}',{3},{4},{5},'{6}',N'{7}')", pc.MaNCC, pc.MaPhieuXuat, pc.NgayLap, pc.SoTien, pc.ConNo, pc.SoTienTra, pc.MaNV, pc.LyDo); return(Execute.InsertUpdateDelete(sql)); }
public frmPay_LapPhieuChi(PhieuChiTien pcTienNhan) : this() { phieuChiTien.TenNCC = pcTien.TenNCC = pcTienNhan.TenNCC; phieuChiTien.MaNCC = pcTien.MaNCC = pcTienNhan.MaNCC; phieuChiTien.SoTien = pcTien.SoTien = pcTienNhan.SoTien; phieuChiTien.MaChungTu = pcTien.MaChungTu = pcTienNhan.MaChungTu; phieuChiTien.NgayLap = pcTien.NgayLap = pcTienNhan.NgayLap; }
private void FillDuLieu(PhieuChiTien pct) { lkueNCC.EditValue = pct.MaNCC; deNgayLap.EditValue = pct.NgayLap; txtChungTu.Text = pct.MaPhieuXuat; ceSoTien.EditValue = pct.SoTien; ceConNo.EditValue = pct.ConNo; ceSoTienTra.EditValue = ceConNo.EditValue; rtbLyDo.Text = pct.LyDo; }
public frmLapPhieuChi(PhieuChiTien pct) { InitializeComponent(); Load += FrmLapPhieuChi_Load; //button btnBoQua.Click += BtnBoQua_Click; btnLuu.Click += BtnLuu_Click; FillDuLieu(pct); }
private void BtnLapPhieuChi_Click(object sender, EventArgs e) { if (CurRowIndex >= 0) { PhieuChiTien pc = LayPhieuChi(); frmLapPhieuChi lpc = new frmLapPhieuChi(pc); lpc.ThemThanhCong += Lpt_ThemThanhCong;; lpc.ThemThanhCong += FillGridView; lpc.ShowDialog(); } }
public void PrintReportChi(PhieuChiTien pcTien) { ReportPhieuThuChi reportPhieuThuChi = new ReportPhieuThuChi(); foreach (DevExpress.XtraReports.Parameters.Parameter p in reportPhieuThuChi.Parameters) { p.Visible = false; } reportPhieuThuChi.initDataChi(pcTien); docPrint.DocumentSource = reportPhieuThuChi; reportPhieuThuChi.CreateDocument(); }
private PhieuChiTien LayPhieuChi() { PhieuChiTien pc = new PhieuChiTien(); pc.MaPhieuXuat = gvChiTien.GetRowCellValue(CurRowIndex, "MaPhieu").ToString(); pc.MaNCC = gvChiTien.GetRowCellValue(CurRowIndex, "MaNCC").ToString(); pc.SoTien = int.Parse(gvChiTien.GetRowCellValue(CurRowIndex, "TongTien").ToString()); pc.ConNo = int.Parse(gvChiTien.GetRowCellValue(CurRowIndex, "ConLai").ToString()); pc.NgayLap = DateTime.Now; pc.LyDo = "Chi tiền mua hàng"; return(pc); }
public void initDataChi(PhieuChiTien pcTien) { pChungTuGoc.Value = pcTien.MaChungTu; pThuQuy.Value = pcTien.TenNV; pSoTien.Value = pcTien.SoTien; pNgay.Value = pcTien.NgayLap; pLyDo.Value = pcTien.GhiChu; pNguoiNopTien.Value = pcTien.TenNCC; pNguoiLapPhieu.Value = pcTien.TenNV; pSoTienBangChu.Value = ChuyenSoThanhChu(ChuanHoaSoTien(pcTien.SoTien.ToString())); pMaPhieu.Value = pcTien.MaPhieu; }
private void BtnLuu_Click(object sender, EventArgs e) { PhieuChiTien pc = new PhieuChiTien(); pc.MaNCC = lkueNCC.EditValue.ToString(); pc.MaPhieuXuat = txtChungTu.Text; pc.NgayLap = DateTime.Parse(deNgayLap.EditValue.ToString()); pc.SoTien = int.Parse(ceSoTien.EditValue.ToString()); pc.ConNo = int.Parse(ceConNo.EditValue.ToString()); pc.SoTienTra = int.Parse(ceSoTienTra.EditValue.ToString()); pc.LyDo = rtbLyDo.Text; pc.MaNV = lkueNhanVien.EditValue.ToString(); if (pc.SoTienTra > pc.ConNo) { MessageBox.Show("Số tiền trả lớn hơn số tiền còn nợ", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } nv_pct.ThemPhieuChi(pc); nv_pn.CapNhatTienDaTra(pc.MaPhieuXuat, pc.SoTienTra); ThemThanhCong(); MessageBox.Show("Lưu thành công!"); }
public int ThemPhieuChi(PhieuChiTien pc) { return(XL_PC.ThemPhieuChi(pc)); }
public int InsertPhieuChiTien(PhieuChiTien ptTien) { return(pcTienDAO.InsertPhieuChiTien(ptTien)); }
public int InsertPhieuChiTien(PhieuChiTien pcTien) { string sql = string.Format("INSERT INTO [BANGKE_PHIEUCHITIEN] VALUES('{0}', '{1}', '{2}', '{3}', N'{4}', {5}, N'{6}' ,N'{7}')", pcTien.MaPhieu, pcTien.MaChungTu, pcTien.NgayLap, pcTien.MaNCC, pcTien.TenNCC, pcTien.SoTien, pcTien.TenNV, pcTien.GhiChu); return(ConnectionDB.ExcuteNonQuery(sql)); }