indentdoc.cpp

用VC做的订单管理系统,可以实现网络订单的各种功能

// IndentDoc.cpp : implementation of the CIndentDoc class
//

#include "stdafx.h"
#include "Indent.h"

#include "IndentDoc.h"
#include "IndentView.h"


#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CIndentDoc

IMPLEMENT_DYNCREATE(CIndentDoc, CDocument)

BEGIN_MESSAGE_MAP(CIndentDoc, CDocument)
	//{{AFX_MSG_MAP(CIndentDoc)
	ON_UPDATE_COMMAND_UI(ID_FILE_SAVE_RECORD, OnUpdateFileSaveRecord)
	ON_COMMAND(ID_FILE_SAVE_RECORD, OnFileSaveRecord)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CIndentDoc construction/destruction

CIndentDoc::CIndentDoc()
{

}

CIndentDoc::~CIndentDoc()
{
}

/////////////////////////////////////////////////////////////////////////////
// CIndentDoc diagnostics

#ifdef _DEBUG
 void CIndentDoc::AssertValid() const
{
 	CDocument::AssertValid();
}

void CIndentDoc::Dump(CDumpContext& dc) const
{
	CDocument::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CIndentDoc commands

void CIndentDoc::SetTitle(LPCTSTR lpszTitle) 
{
	// TODO: Add your specialized code here and/or call the base class
	lpszTitle = _T("定货单管理");

	CDocument::SetTitle(lpszTitle);
}

BOOL CIndentDoc::SaveModified() 
{
	if(IsModified())
	{
		int result = AfxMessageBox("是否保存所做的修改?",MB_YESNOCANCEL);
		if(IDYES == result)
		{
			OnFileSaveRecord();
		}
		else if(IDCANCEL == result)
		{
			return FALSE;
		}
	}

//	return CDocument::SaveModified();
	return TRUE;
}


void CIndentDoc::OnUpdateFileSaveRecord(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	pCmdUI->Enable(IsModified());
}

void CIndentDoc::OnFileSaveRecord() 
{
	POSITION pos = GetFirstViewPosition();
	while(pos != NULL)
	{
		CIndentView *pView = (CIndentView*)GetNextView(pos);
		ASSERT(pView->IsKindOf(RUNTIME_CLASS(CFormView)));
		
		CString strItem[17];
		pView->GetDlgItemText(IDC_ITEM01,strItem[0]);
		pView->GetDlgItemText(IDC_ITEM02,strItem[1]);
		pView->GetDlgItemText(IDC_ITEM03,strItem[2]);
		pView->GetDlgItemText(IDC_ITEM04,strItem[3]);
		pView->GetDlgItemText(IDC_ITEM05,strItem[4]);
		pView->GetDlgItemText(IDC_ITEM06,strItem[5]);
		pView->GetDlgItemText(IDC_ITEM07,strItem[6]);
		pView->GetDlgItemText(IDC_ITEM08,strItem[7]);
		pView->GetDlgItemText(IDC_ITEM09,strItem[8]);
		pView->GetDlgItemText(IDC_ITEM10,strItem[9]);
		pView->GetDlgItemText(IDC_ITEM11,strItem[10]);
		pView->GetDlgItemText(IDC_ITEM12,strItem[11]);
		pView->GetDlgItemText(IDC_ITEM13,strItem[12]);
		pView->GetDlgItemText(IDC_ITEM14,strItem[13]);
		pView->GetDlgItemText(IDC_ITEM15,strItem[14]);
		pView->GetDlgItemText(IDC_ITEM16,strItem[15]);
		pView->GetDlgItemText(IDC_ITEM17,strItem[16]);
		
		CString strCmd;
		CIndentApp* pAapp = (CIndentApp*)AfxGetApp();
		
		// Format sql command char string
		strCmd.Format("INSERT INTO indent(db_item01,db_item02,db_item03,db_item04,\
						   db_item05,db_item06,db_item07,db_item08,\
						   db_item09,db_item10,db_item11,db_item12,\
						   db_item13,db_item14,db_item15,db_item16,\
						   db_item17)\
						   VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
						   strItem[0],strItem[1],strItem[2],strItem[3],strItem[4],strItem[5],\
						   strItem[6],strItem[7],strItem[8],strItem[9],strItem[10],strItem[11],\
						   strItem[12],strItem[13],strItem[14],strItem[15],strItem[16]);
		
		// Execute sql command to insert new record
		if(pAapp->m_ado.Execute(strCmd))
		{
			pView->SetDlgItemText(IDC_ITEM01,_T(""));
			pView->SetDlgItemText(IDC_ITEM02,_T(""));
			pView->SetDlgItemText(IDC_ITEM03,_T(""));
			pView->SetDlgItemText(IDC_ITEM04,_T(""));
			CTime tm = CTime::GetCurrentTime();
			((CDateTimeCtrl*)pView->GetDlgItem(IDC_ITEM05))->SetTime(&tm);
			pView->SetDlgItemText(IDC_ITEM06,_T(""));
			pView->SetDlgItemText(IDC_ITEM07,_T(""));
			pView->SetDlgItemText(IDC_ITEM08,_T(""));
			pView->SetDlgItemText(IDC_ITEM09,_T(""));
			pView->SetDlgItemText(IDC_ITEM10,_T(""));
			pView->SetDlgItemText(IDC_ITEM11,_T(""));
			pView->SetDlgItemText(IDC_ITEM12,_T(""));
			((CDateTimeCtrl*)pView->GetDlgItem(IDC_ITEM13))->SetTime(&tm);
			pView->SetDlgItemText(IDC_ITEM14,_T(""));
			pView->SetDlgItemText(IDC_ITEM15,_T(""));
			pView->SetDlgItemText(IDC_ITEM16,_T("ノ