dialogout.cpp

以前给一个印刷厂开发的业务管理软件

// DialogPutIn.cpp : implementation file
//

#include "stdafx.h"
#include "PressManagerDoc.h"
#include "DialogOut.h"
#include "MainFrm.h"
#include "printfile\\ListCtrlPrint.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialogOut dialog


CDialogOut::CDialogOut(CWnd* pParent /*=NULL*/)
	: CDialog(CDialogOut::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDialogOut)
	m_strWarePurpose = _T("");
	m_strWareNum = _T("");
	m_strWareMode = _T("");
	m_strWareType = _T("");
	m_strRemarks = _T("");
	m_strPrice = _T("");
	m_strUnit = _T("");
	m_strDepartment = _T("");
	m_strOutMan = _T("");
	m_strProductSerial = _T("");
	m_strStoreNumber = _T("");
	//}}AFX_DATA_INIT
}


void CDialogOut::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialogOut)
	DDX_Control(pDX, IDC_COMBO_PRODUCT_SERIAL, m_ComboProductSerial);
	DDX_Control(pDX, IDC_COMBO_OUT_MAN, m_ComboOutMan);
	DDX_Control(pDX, IDC_COMBO_DEPARTMENT, m_ComboDepartment);
	DDX_Control(pDX, IDC_LIST, m_List);
	DDX_Control(pDX, IDC_COMBO_WARE_PURPOSE, m_ComboWarePurpose);
	DDX_CBString(pDX, IDC_COMBO_WARE_PURPOSE, m_strWarePurpose);
	DDX_Control(pDX, IDC_COMBO_WARE_MODE, m_ComboWareMode);
	DDX_Control(pDX, IDC_COMBO_WareType, m_ComboWareType);
	DDX_Text(pDX, IDC_EDIT_WareNum, m_strWareNum);
	DDX_CBString(pDX, IDC_COMBO_WARE_MODE, m_strWareMode);
	DDX_CBString(pDX, IDC_COMBO_WareType, m_strWareType);
	DDX_Text(pDX, IDC_EDIT_REMARKS, m_strRemarks);
	DDX_Text(pDX, IDC_EDIT_Price, m_strPrice);
	DDX_Text(pDX, IDC_EDIT_UNIT, m_strUnit);
	DDX_CBString(pDX, IDC_COMBO_DEPARTMENT, m_strDepartment);
	DDX_CBString(pDX, IDC_COMBO_OUT_MAN, m_strOutMan);
	DDX_CBString(pDX, IDC_COMBO_PRODUCT_SERIAL, m_strProductSerial);
	DDX_Text(pDX, IDC_EDIT_STORE_NUMBER, m_strStoreNumber);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialogOut, CDialog)
	//{{AFX_MSG_MAP(CDialogOut)
	ON_BN_CLICKED(IDC_PUTIN, OnPutin)
	ON_CBN_SELCHANGE(IDC_COMBO_WareType, OnSelchangeCOMBOWareType)
	ON_CBN_SELCHANGE(IDC_COMBO_WARE_PURPOSE, OnSelchangeComboWarePurpose)
	ON_BN_CLICKED(IDC_LIST_PRINT, OnListPrint)
	ON_CBN_SELCHANGE(IDC_COMBO_WARE_MODE, OnSelchangeComboWareMode)
	ON_CBN_SELCHANGE(IDC_COMBO_DEPARTMENT, OnSelchangeComboDepartment)
    ON_MESSAGE(WM_KICKIDLE, OnKickIdle)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialogOut message handlers

BOOL CDialogOut::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_List.SetExtendedStyle
	   (m_List.GetExtendedStyle()|LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
	m_List.InsertColumn(0,"原材料种类",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(1,"物品名",LVCFMT_LEFT,120,-1);
	m_List.InsertColumn(2,"物品型号",LVCFMT_LEFT,90,-1);
	m_List.InsertColumn(3,"计量单位",LVCFMT_LEFT,60,-1);
	m_List.InsertColumn(4,"出库单价",LVCFMT_LEFT,60,-1);
	m_List.InsertColumn(5,"出库数量",LVCFMT_LEFT,70,-1);
	m_List.InsertColumn(6,"领取人",LVCFMT_LEFT,60,-1);
	m_List.InsertColumn(7,"生产单号",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(8,"备注",LVCFMT_LEFT,80,-1);
	m_List.InsertColumn(9,"出库人",LVCFMT_LEFT,60,-1);

	m_pWarePurposeSet->MoveFirst();
	while(!m_pWarePurposeSet->IsEOF())
	{
		m_ComboWarePurpose.AddString(m_pWarePurposeSet->m_WarePurpose);
		m_pWarePurposeSet->MoveNext();
	}
	m_ComboWarePurpose.SetCurSel(0);
	OnSelchangeComboWarePurpose();

	if(m_pOperatorSet->IsOpen())
		m_pOperatorSet->Close();
	m_pOperatorSet->Open();
	if(m_pDepartmentSet->IsOpen())
		m_pDepartmentSet->Close();
	m_pDepartmentSet->Open();
	while(!m_pDepartmentSet->IsEOF())
 	{
		m_ComboDepartment.AddString(m_pDepartmentSet->m_Department);
		m_pDepartmentSet->MoveNext();
	}
	m_ComboDepartment.SetCurSel(0);
	OnSelchangeComboDepartment();

	CString str;
	str = "select * from [ProduceClient] where [State] = 0";
	if(m_pProduceClientSet->IsOpen())
		m_pProduceClientSet->Close();
	m_pProduceClientSet->Open(CRecordset::snapshot, str);
	while(!m_pProduceClientSet->IsEOF())
	{
		m_ComboProductSerial.AddString(m_pProduceClientSet->m_Serial);
		m_pProduceClientSet->MoveNext();
	}
	m_ComboProductSerial.SetCurSel(0);

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDialogOut::OnPutin() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if((atof(m_strStoreNumber) - atof(m_strWareNum)) < 0)
	{
		MessageBox("库存不足");
		return;
	}

	m_pWarePurposeSet->MoveFirst();
	while(!m_pWarePurposeSet->IsEOF())
	{
		if(m_strWarePurpose == m_pWarePurposeSet->m_WarePurpose)
			break;
		m_pWarePurposeSet->MoveNext();
	}	
	m_pWareTypeSet->MoveFirst();
	while(!m_pWareTypeSet->IsEOF())
	{
		if(m_strWareType == m_pWareTypeSet->m_WareType)
			break;
		m_pWareTypeSet->MoveNext();
	}
	m_pWareModeSet->MoveFirst();
	while(!m_pWareModeSet->IsEOF())
	{
		if(m_strWareMode == m_pWareModeSet->m_WareMode)
			break;
		m_pWareModeSet->MoveNext();
	}

	if(!m_pOutWareSet->IsOpen())
		m_pOutWareSet->Open();
	m_pOutWareSet->AddNew();
	m_pOutWareSet->m_OutManId = m_strOutMan;
	m_pOutWareSet->m_WarePurposeId = m_pWarePurposeSet->m_Id;
	m_pOutWareSet->m_WareTypeId = m_pWareTypeSet->m_Id;
	m_pOutWareSet->m_WareModeId = m_pWareModeSet->m_Id;
	m_pOutWareSet->m_ProduceClientSerial = m_strProductSerial;
	m_pOutWareSet->m_Price = m_strPrice;
	m_pOutWareSet->m_Number = atof(m_strWareNum);
	m_pOutWareSet->m_Remarks = m_strRemarks;
	m_pOutWareSet->m_OperatorId = m_strOperatorId;
	TRY
	{
		m_pOutWareSet->Update();
	}
	CATCH_ALL(e)
	{
		MessageBox("OutWare数据加入错误，请检查");
		return;
	}	
    END_CATCH_ALL;

	CString strSql;
	strSql.Format("select * from [StoreWare] where [WareModeId] = %d",m_pWareModeSet->m_Id);
	if(m_pStoreWareSet->IsOpen())
		m_pStoreWareSet->Close();
	m_pStoreWareSet->Open(CRecordset::snapshot, strSql);
	m_pStoreWareSet->Edit();
	m_pStoreWareSet->m_Number = atof(m_strStoreNumber) - atof(m_strWareNum);
	TRY
	{
		m_pStoreWareSet->Update();
	}
	CATCH_ALL(e)
	{
		MessageBox("StoreWare数据更新错误，请检查");
		return;
	}	
    END_CATCH_ALL;

	m_List.InsertItem(0, m_strWarePurpose);
	m_List.SetItemText(0, 1, m_strWareType);
	m_List.SetItemText(0, 2, m_strWareMode);
	m_List.SetItemText(0, 3, m_strUnit);
	m_List.SetItemText(0, 4, m_strPrice);
	m_List.SetItemText(0, 5, m_strWareNum);
	m_List.SetItemText(0, 6, m_strOutMan);
	m_List.SetItemText(0, 7, m_strProductSerial);
	m_List.SetItemText(0, 8, m_strRemarks);
	m_List.SetItemText(0, 9, m_strOperatorId);

}

void CDialogOut::OnSelchangeCOMBOWareType() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_pWareTypeSet->MoveFirst();
	while(!m_pWareTypeSet->IsEOF())
	{
		if(m_strWareType == m_pWareTypeSet->m_WareType)
		{
			m_pWareModeSet->MoveFirst();
			m_ComboWareMode.ResetContent();
			while(!m_pWareModeSet->IsEOF())
			{
				if(m_pWareModeSet->m_WareTypeId == m_pWareTypeSet->m_Id)
					m_ComboWareMode.AddString(m_pWareModeSet->m_WareMode);
				m_pWareModeSet->MoveNext();
			}
			m_ComboWareMode.SetCurSel(0);
			m_strUnit = m_pWareTypeSet->m_Unit;
			UpdateData(FALSE);
			break;
		}

		m_pWareTypeSet->MoveNext();
	}
	
	if(!(m_pWareModeSet->IsBOF() && m_pWareModeSet->IsEOF()))
		OnSelchangeComboWareMode();
}


void CDialogOut::OnSelchangeComboWarePurpose() 
{
	// TODO: Add your control notification handler code here
	UpdateData();

	m_pWarePurposeSet->MoveFirst();
	while(!m_pWarePurposeSet->IsEOF())
	{
		if(m_strWarePurpose == m_pWarePurposeSet->m_WarePurpose)
		{
			m_pWareTypeSet->MoveFirst();
			m_ComboWareType.ResetContent();
			while(!m_pWareTypeSet->IsEOF())
			{
				if(m_pWareTypeSet->m_WarePurposeId == m_pWarePurposeSet->m_Id)
					m_ComboWareType.AddString(m_pWareTypeSet->m_WareType);
				m_pWareTypeSet->MoveNext();
			}
			m_ComboWareType.SetCurSel(0);
			OnSelchangeCOMBOWareType();
			break;
		}

		m_pWarePurposeSet->MoveNext();
	}	
	
}

void CDialogOut::OnListPrint() 
{
	// TODO: Add your control notification handler code here
	if(m_List.GetItemCount() == 0)
		return;

	CListCtrlPrint cJob;
	CTime t = CTime::GetCurrentTime();
	cJob.csPageHead = "物资出库\r\n";
	cJob.csPageFooter.Format("打印日期 %d年%d月%d日 负责人 %s\r\n", t.GetYear(), t.GetMonth(), t.GetDay(), m_strOperatorId);
	cJob.csPage = " %d页 / %d";
	cJob.pList = &m_List;
	cJob.OnFilePrint();
	
}

void CDialogOut::OnSelchangeComboWareMode() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_pWareModeSet->MoveFirst();
	while(!m_pWareModeSet->IsEOF())
	{
		if(m_strWareMode == m_pWareModeSet->m_WareMode)
		{
			m_strPrice = m_pWareModeSet->m_Price;
			break;
		}

		m_pWareModeSet->MoveNext();
	}	

	CString strSql;
	strSql.Format("select * from [StoreWare] where [WareModeId] = %d",m_pWareModeSet->m_Id);
	if(m_pStoreWareSet->IsOpen())
		m_pStoreWareSet->Close();
	m_pStoreWareSet->Open(CRecordset::snapshot, strSql);
	if(!m_pStoreWareSet->IsEOF())
	{
		m_strStoreNumber.Format("%.2f", m_pStoreWareSet->m_Number);
	}
	else
	{
		m_strStoreNumber = "0";
	}
	
	UpdateData(FALSE);

	m_pStoreWareSet->Close();
}

void CDialogOut::OnSelchangeComboDepartment() 
{
	// TODO: Add your control notification handler code here
	UpdateData();

	m_pDepartmentSet->MoveFirst();
	while(!m_pDepartmentSet->IsEOF())
	{
		if(m_strDepartment == m_pDepartmentSet->m_Department)
			break;

		m_pDepartmentSet->MoveNext();
	}

	m_ComboOutMan.ResetContent();
	m_pOperatorSet->MoveFirst();
	while(!m_pOperatorSet->IsEOF())
	{
		if(m_pOperatorSet->m_DepartmentId == m_pDepartmentSet->m_Id)
			m_ComboOutMan.AddString(m_pOperatorSet->m_Operator);
		m_pOperatorSet->MoveNext();
	}
	m_ComboOutMan.SetCurSel(0);
		
}

LRESULT CDialogOut::OnKickIdle(WPARAM, LPARAM lCount)
{
       // Do idle processing here, just like CWinApp::OnIdle
       //
	Sleep(100); //1ms

	if(lCount >= 6000) //5分钟5*60*1000=3000*100
	{
		CDialogEnter dlg;
		dlg.m_strUser = m_strOperatorId;
		dlg.m_pOperatorSet = m_pOperatorSet;
		dlg.DoModal();
		return FALSE;
	}
   return TRUE;
}