⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 jeah_datadlg.cpp

📁 图书管理系统
💻 CPP
📖 第 1 页 / 共 3 页
字号:
🔍
123 
	{
		char sourcename[30],username[10],password[10];
		strcpy(sourcename,"jeah_data_1");
		strcpy(username,"sa");
		strcpy(password,"jeah");
		SQLDisconnect(hdbc);
		SQLFreeConnect(hdbc);
		SQLFreeEnv(hdbc);
		SQLAllocEnv(&henv);
		SQLAllocConnect(henv,&hdbc);
		SQLConnect(hdbc,(UCHAR*)sourcename,SQL_NTS,(UCHAR*)username,
				                 SQL_NTS,(UCHAR*)password,SQL_NTS);
	}
	}
	else
	{
	//	AfxMessageBox("请选择借或还!");
			MsgeBox mb;
				mb.m_msge=_T("\n请选择借或还!");
								UpdateData(false);
								mb.DoModal();	
	}
	}	

}

void CJeah_dataDlg::OnConnect() 
{
	// TODO: Add your control notification handler code here
	phstmt=(HSTMT FAR*)malloc(sizeof(HSTMT FAR));
	char sourcename[30],username[10],password[10];
	strcpy(sourcename,"jeah_data_1");
	strcpy(username,"sa");
	strcpy(password,"jeah");
	rc=SQLAllocEnv(&henv);
	if(rc==SQL_SUCCESS)
	{
	//	AfxMessageBox("yes!");
		rc=SQLAllocConnect(henv,&hdbc);
		if(rc==SQL_SUCCESS)
		{
		//	AfxMessageBox("wow yeah!");
			rc=SQLConnect(hdbc,(UCHAR*)sourcename,SQL_NTS,(UCHAR*)username,
				                 SQL_NTS,(UCHAR*)password,SQL_NTS);
				if(rc==SQL_SUCCESS||rc==SQL_SUCCESS_WITH_INFO) 
				{
				//	AfxMessageBox("HAHA!!");
					m_conmsge=_T("与数据库连接中!");
					m_kanum=_T("");
					m_name=_T("");
					m_booknum=_T("");
					m_bookname=_T("");
					UpdateData(false);
					GetDlgItem(ID_CONNECT)->EnableWindow(FALSE);
					GetDlgItem(ID_TCXT)->EnableWindow(FALSE);
					GetDlgItem(ID_BREAK)->EnableWindow(true);
					GetDlgItem(ID_QUEDING)->EnableWindow(true);
					GetDlgItem(IDC_BUTTONKA)->EnableWindow(true);
					GetDlgItem(IDC_BUTTONBK)->EnableWindow(true);
					GetDlgItem(ID_CTIAN)->EnableWindow(true);
					GetDlgItem(IDC_BUTTONLEN)->EnableWindow(true);
					GetDlgItem(IDC_BUTTONBCK)->EnableWindow(true);
					GetDlgItem(ID_JCTJ)->EnableWindow(TRUE);
					GetDlgItem(ID_GSHI)->EnableWindow(TRUE);
					GetDlgItem(ID_SHHAO)->EnableWindow(TRUE);
					GetDlgItem(ID_JCTJ)->EnableWindow(TRUE);
					GetDlgItem(ID_YQTJ)->EnableWindow(TRUE);
					GetDlgItem(ID_HYDJ)->EnableWindow(TRUE);
					GetDlgItem(ID_HYTJ)->EnableWindow(TRUE);					
					GetDlgItem(ID_XSDJ)->EnableWindow(true);
				}

		}
	}	
}

void HEkDrawBitmap(CDC* pDC,CBitmap* pBitmap,CRect rect,BOOL bCenter=TRUE)
{
	ASSERT_VALID(pDC);
	ASSERT_VALID(pBitmap);
	CDC dcMem;
	dcMem.CreateCompatibleDC(pDC);
	CBitmap* pOldBitmap=dcMem.SelectObject(pBitmap);
/*	if(bCenter)
	{
		BITMAP bitmap;
		pBitmap->GetObject(sizeof(BITMAP),&bitmap);
		CSize sizeBitmap(bitmap.bmWidth,bitmap.bmHeight);
		CSize diff=rect.Size()-sizeBitmap;
		rect.DeflateRect(diff.cx/2,diff.cy/2);
	}
	*/
//	pDC->BitBlt(rect.left,rect.top,rect.Width(),rect.Height(),&dcMem,0,0,SRCCOPY);
	pDC->BitBlt(30,90,55,55,&dcMem,0,0,SRCCOPY); 
	dcMem.SelectObject(pOldBitmap);
}

void CJeah_dataDlg::OnBreak() 
{
	// TODO: Add your control notification handler code here
			SQLDisconnect(hdbc);
	SQLFreeConnect(hdbc);
	SQLFreeEnv(henv);
//	AfxMessageBox("连接断开!");
	m_conmsge=_T("连接已断开!");
//	m_lbmsge=_T("");
	len_bck=0;
	m_kanum=_T("");
	m_name=_T("");
	m_booknum=_T("");
	m_bookname=_T("");
	UpdateData(false);
	GetDlgItem(ID_CONNECT)->EnableWindow(true);
	GetDlgItem(ID_TCXT)->EnableWindow(true);
	GetDlgItem(ID_BREAK)->EnableWindow(false);
	GetDlgItem(ID_QUEDING)->EnableWindow(false);
	GetDlgItem(IDC_BUTTONKA)->EnableWindow(false);
	GetDlgItem(IDC_BUTTONBK)->EnableWindow(false);
	GetDlgItem(ID_CTIAN)->EnableWindow(false);
	GetDlgItem(IDC_BUTTONLEN)->EnableWindow(false);
	GetDlgItem(IDC_BUTTONBCK)->EnableWindow(false);
	GetDlgItem(ID_HYTJ)->EnableWindow(false);
	GetDlgItem(ID_GSHI)->EnableWindow(false);
	GetDlgItem(ID_SHHAO)->EnableWindow(false);
	GetDlgItem(ID_JCTJ)->EnableWindow(false);
	GetDlgItem(ID_YQTJ)->EnableWindow(false);
	GetDlgItem(ID_XSDJ)->EnableWindow(FALSE);
	GetDlgItem(ID_HYDJ)->EnableWindow(FALSE);

		CRect rect;
	CDC *pDC = GetDC();
	//CDC *pDC;
//	m_DrawArea.GetWindowRect(&rect);
	CBitmap bmp;
	bmp.LoadBitmap(IDB_BITMAP3);
	HEkDrawBitmap(pDC,&bmp,rect);
	ReleaseDC(pDC);
	
}

void CJeah_dataDlg::OnTcxt() 
{
	// TODO: Add your control notification handler code here
		CDialog::OnOK();	
}

void EkDrawBitmap(CDC* pDC,CBitmap* pBitmap,CRect rect,BOOL bCenter=TRUE)
{
	ASSERT_VALID(pDC);
	ASSERT_VALID(pBitmap);
	CDC dcMem;
	dcMem.CreateCompatibleDC(pDC);
	CBitmap* pOldBitmap=dcMem.SelectObject(pBitmap);
/*	if(bCenter)
	{
		BITMAP bitmap;
		pBitmap->GetObject(sizeof(BITMAP),&bitmap);
		CSize sizeBitmap(bitmap.bmWidth,bitmap.bmHeight);
		CSize diff=rect.Size()-sizeBitmap;
		rect.DeflateRect(diff.cx/2,diff.cy/2);
	}
	*/
//	pDC->BitBlt(rect.left,rect.top,rect.Width(),rect.Height(),&dcMem,0,0,SRCCOPY);
	pDC->BitBlt(30,90,55,55,&dcMem,0,0,SRCCOPY); 
	dcMem.SelectObject(pOldBitmap);
}

void CJeah_dataDlg::OnButtonlen() 
{
	// TODO: Add your control notification handler code here
	len_bck=1;
	CRect rect;
	CDC *pDC = GetDC();
	//CDC *pDC;
//	m_DrawArea.GetWindowRect(&rect);
	CBitmap bmp;
	bmp.LoadBitmap(IDB_BITMAP1);
	EkDrawBitmap(pDC,&bmp,rect);
	ReleaseDC(pDC);

//	m_lbmsge=_T("借");
//	UpdateData(false);
	
}

void CJeah_dataDlg::OnButtonbck() 
{
	// TODO: Add your control notification handler code here
	len_bck=2;

	CRect rect;
	CDC *pDC = GetDC();
	//CDC *pDC;
//	m_DrawArea.GetWindowRect(&rect);
	CBitmap bmp;
	bmp.LoadBitmap(IDB_BITMAP2);
	EkDrawBitmap(pDC,&bmp,rect);
	ReleaseDC(pDC);
//	m_lbmsge=_T("还");
//	UpdateData(false);
	
}

void CJeah_dataDlg::OnButtonka() 
{
	// TODO: Add your control notification handler code here
			phstmt=(HSTMT FAR *)malloc(sizeof(HSTMT FAR));
	UpdateData(true);
	char * b;
	char *rgbValue;
	SDWORD FAR *pcbValue;
	rgbValue=(char*)malloc(200);
	pcbValue=(SDWORD FAR*)malloc(sizeof(SDWORD FAR));
	b=(char*)malloc(200);
	CString sql;
	sql="select 姓名 from 读者表 where 卡号="+m_kanum;
//	AfxMessageBox(sql);
//	b=sql.GetBuffer(strlen(sql)+1);
	strcpy(b,sql.GetBuffer(sql.GetLength()));
 //   AfxMessageBox(b);
//	memcpy(b,sql,strlen(sql));
//	SQLAllocEnv(&henv);
//	SQLAllocConnect(henv,&hdbc);
	SQLAllocStmt(hdbc,phstmt);
	rc=SQLExecDirect(*phstmt,(UCHAR FAR *)b,SQL_NTS);
	if(rc==SQL_SUCCESS)
	{
	    SQLFetch(*phstmt);
		rc=SQLGetData(*phstmt,1,SQL_C_CHAR,rgbValue,200,pcbValue);
		if(rc==SQL_SUCCESS) 
		{
		//	AfxMessageBox("haha");
			m_name=rgbValue;
		//	m_name.Format("%s",rgbValue);
			UpdateData(false);
			GetDlgItem(IDC_BKNUM)->SetFocus();
		}	
		else 
		{
			//AfxMessageBox("找不到与此卡号对应的姓名!");
				MsgeBox mb;
				mb.m_msge=_T("\n找不到与此书号对应的姓名!");
								UpdateData(false);
								mb.DoModal(); 
		}
	}
		else 
		{
		//	AfxMessageBox("找不到与此卡号对应的姓名!");
		MsgeBox mb;
				mb.m_msge=_T("\n找不到与此书号对应的姓名!");
								UpdateData(false);
								mb.DoModal(); 
		}
	sql.ReleaseBuffer(sql.GetLength());
//	sqlstr.ReleaseBuffer(sqlstr.GetLength());
	free(b);
	free(rgbValue);
	free(pcbValue);
	
	
}

void CJeah_dataDlg::OnButtonbk() 
{
	// TODO: Add your control notification handler code here
				phstmt=(HSTMT FAR *)malloc(sizeof(HSTMT FAR));
	UpdateData(true);
	char * b;
	char *rgbValue;
	SDWORD FAR *pcbValue;
	rgbValue=(char*)malloc(200);
	pcbValue=(SDWORD FAR*)malloc(sizeof(SDWORD FAR));
	b=(char*)malloc(200);
	CString sql;
	sql="select 书名 from 书库表 where 书号="+m_booknum;
//	AfxMessageBox(sql);
	strcpy(b,sql.GetBuffer(sql.GetLength()));
 //   AfxMessageBox(b);
	SQLAllocStmt(hdbc,phstmt);
	rc=SQLExecDirect(*phstmt,(UCHAR FAR *)b,SQL_NTS);
	if(rc==SQL_SUCCESS)
	{
	    SQLFetch(*phstmt);
		rc=SQLGetData(*phstmt,1,SQL_C_CHAR,rgbValue,100,pcbValue);
		if(rc==SQL_SUCCESS) 
		{
		//	AfxMessageBox("haha");
			m_bookname=rgbValue;
			UpdateData(false);
			GetDlgItem(ID_QUEDING)->SetFocus();
		}	
		else{ 
				//AfxMessageBox("找不到与此书号对应的书名!");
				MsgeBox mb;
				mb.m_msge=_T("\n找不到与此书号对应的书名!");
								UpdateData(false);
								mb.DoModal();
			}	
	}
	else
	{
		// AfxMessageBox("找不到与此书号对应的书名!");
			MsgeBox mb;
				mb.m_msge=_T("\n找不到与此书号对应的书名!");
								UpdateData(false);
								mb.DoModal();
	}
	sql.ReleaseBuffer(sql.GetLength());
	free(b);
	free(rgbValue);
	free(pcbValue);
	
}

void CJeah_dataDlg::OnGshi() 
{
	// TODO: Add your control notification handler code here
	Gshi gs;
	gs.DoModal();
	
}

void CJeah_dataDlg::OnCtian() 
{
	// TODO: Add your control notification handler code here
	m_kanum=_T("");
    m_name=_T("");
	m_booknum=_T("");
	m_bookname=_T("");
	UpdateData(false);
	GetDlgItem(IDC_KANUM)->SetFocus();
	
}

void CJeah_dataDlg::OnShhao() 
{
	// TODO: Add your control notification handler code here
	Shhao sh;
	sh.DoModal();
	
}

void CJeah_dataDlg::OnXsdj() 
{
	// TODO: Add your control notification handler code here
	Hydj hy;
	hy.DoModal();	
}

void CJeah_dataDlg::OnHydj2() 
{
	// TODO: Add your control notification handler code here
	Hydj2 hy;
	hy.DoModal();

	
}

void CJeah_dataDlg::OnJctj() 
{
	// TODO: Add your control notification handler code here
	Jclist jc;
	jc.DoModal();
	
}

void CJeah_dataDlg::OnYqtj() 
{
	// TODO: Add your control notification handler code here
	Yqlist yq;
	yq.DoModal();	
}

void CJeah_dataDlg::OnHytj() 
{
	// TODO: Add your control notification handler code here
	Hytj dz;
	dz.DoModal();

	
}
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -