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));
}