dialogproductwarelist.cpp

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

// MeterRecordView.cpp : implementation file
//

#include "stdafx.h"
#include "DialogProductWareList.h"
#include "printfile//ListCtrlPrint.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialogProductWareList

IMPLEMENT_DYNCREATE(CDialogProductWareList, CDialog)

CDialogProductWareList::CDialogProductWareList()
	: CDialog(CDialogProductWareList::IDD)
{
	//{{AFX_DATA_INIT(CDialogProductWareList)
	m_timeFrom = CTime::GetCurrentTime();
	m_timeTo = CTime::GetCurrentTime();
	m_nState = 0;
	m_strSerial = _T("");
	m_strProduct = _T("");
	//}}AFX_DATA_INIT
}

void CDialogProductWareList::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialogProductWareList)
	DDX_Control(pDX, IDC_LIST, m_List);
	DDX_DateTimeCtrl(pDX, IDC_FROM_DATE, m_timeFrom);
	DDX_DateTimeCtrl(pDX, IDC_TO_DATE, m_timeTo);
	DDX_CBIndex(pDX, IDC_COMBO_STATE, m_nState);
	DDX_Text(pDX, IDC_EDIT_SERIAL, m_strSerial);
	DDX_Text(pDX, IDC_EDIT_PRODUCT, m_strProduct);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialogProductWareList, CDialog)
	//{{AFX_MSG_MAP(CDialogProductWareList)
    ON_MESSAGE(WM_KICKIDLE, OnKickIdle)
	ON_BN_CLICKED(IDC_BUTTON_OUT_EXCEL, OnButtonOutExcel)
	ON_BN_CLICKED(IDC_BUTTON_SEARCH, OnButtonSearch)
	ON_BN_CLICKED(IDC_LIST_PRINT, OnListPrint)
	ON_WM_CLOSE()
	ON_NOTIFY(NM_RCLICK, IDC_LIST, OnRclickList)
	ON_WM_CHAR()
	ON_COMMAND(ID_MENU_EDIT_PRODUCT_CLIENT, OnMenuEditProductClient)
	ON_COMMAND(ID_MENU_EDIT_PRODUCT_WARE, OnMenuEditProductWare)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialogProductWareList diagnostics

#ifdef _DEBUG
void CDialogProductWareList::AssertValid() const
{
	CDialog::AssertValid();
}

#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CDialogProductWareList message handlers

void CDialogProductWareList::OnButtonOutExcel() 
{
	// TODO: Add your control notification handler code here
	int answer = MessageBox("确定导出？","确定", MB_OKCANCEL);
	if(answer != IDOK)
		return;

	CWaitCursor cursor; // this will automatically display a wait cursor
	CTime t = CTime::GetCurrentTime();
	CDatabase database;
	CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)"; // exactly the same name as in the ODBC-Manager
	CString sExcelFile;// = "c:\\demo.xls";                // Filename and path for the file to be created
	CString sSql;
	sExcelFile.Format("c:\\生产任务查询%d%d%d%d%d.xls", t.GetYear(),t.GetMonth(),t.GetDay(),t.GetHour(),t.GetMinute());
    
	TRY
	{
    // Build the creation string for access without DSN
    sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s", sDriver,sExcelFile,sExcelFile);
    // Create the database (i.e. Excel sheet)
    if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
    {
      // Create table structure
  	  CString str,header1,header2;
	  int i,k;
      HDITEM hdi;

	  header1 =  "list ( ";
	  header2 =  "list ( ";
	  char cc[50];
	  for(k = 0; k < m_List.GetHeaderCtrl()->GetItemCount(); k++)
	  {
			hdi.mask = HDI_TEXT;
			hdi.pszText = cc;
			hdi.cchTextMax = 50;
		   m_List.GetHeaderCtrl()->GetItem(k, &hdi);
		  header1 += cc;
		  header1 += ",";
		  header2 += cc;
		  header2 += " TEXT,";
	  }
	  header1.Delete(header1.GetLength() - 1);
	  header1 += ")";
	  header2.Delete(header2.GetLength() - 1);
	  header2 += ")";

      sSql = "CREATE TABLE ";
	  sSql += header2;
      database.ExecuteSQL(sSql);

      // Insert data
     for(i = 0; i < m_List.GetItemCount(); i++)
	  {
		  str = " VALUES (";
		  for(k = 0; k <  m_List.GetHeaderCtrl()->GetItemCount(); k++)
		  {
			  str += "'";
			  str += m_List.GetItemText(i,k);
			  str += "',";
		  }
		  str.Delete(str.GetLength() - 1);
		  sSql = "INSERT INTO ";
		  sSql += header1;
		  sSql += str;
		  sSql += ")";
		  database.ExecuteSQL(sSql);
	  }    
	}
    // Close database
    database.Close();
  }
  CATCH_ALL(e)
  {
	TRACE1("Driver not installed: %s",sDriver);
	  sSql.Format("Driver not installed: %s",sDriver);
	  MessageBox(sSql);
	  return;
  }
  END_CATCH_ALL;
	
  sSql.Format("文件：%s，导出成功", sExcelFile);
  MessageBox(sSql);
	
}

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

	CString strFtime, strTtime;
#if !defined(_ACCESS_DB)
	strFtime.Format("'%d/%d/%d'",m_timeFrom.GetMonth(),m_timeFrom.GetDay(),m_timeFrom.GetYear());
	strTtime.Format("'%d/%d/%d 23:59:59'",m_timeTo.GetMonth(),m_timeTo.GetDay(),m_timeTo.GetYear());
#endif
#if defined(_ACCESS_DB)
	strFtime.Format("#%d/%d/%d#",m_timeFrom.GetMonth(),m_timeFrom.GetDay(),m_timeFrom.GetYear());
	strTtime.Format("#%d/%d/%d 23:59:59#",m_timeTo.GetMonth(),m_timeTo.GetDay(),m_timeTo.GetYear());
#endif

	CString	strSql;
	if(m_nState != 0)
		strSql.Format("select *	from [ProductWare] where [UpdateDate] between %s and %s and State = %d", strFtime, strTtime, m_nState - 1);
	else
		strSql.Format("select *	from [ProductWare] where [UpdateDate] between %s and %s", strFtime, strTtime);

	CString substrSql[2];
	if(!m_strSerial.IsEmpty())
		substrSql[0].Format("[ProduceClientSerial] = '%s'", m_strSerial);
	if(!m_strProduct.IsEmpty())
		substrSql[1].Format("[Draft] like '%%%s%%'", m_strProduct);

	CWaitCursor cursor; // this will automatically display a wait cursor
	for(int i = 0; i < 2; i++)
	{
		if(!substrSql[i].IsEmpty())
		{
			strSql += _T(" AND ");
			strSql += substrSql[i];
		}
	}

	i = 0;
	m_List.DeleteAllItems();
	if(m_pProductWareSet->IsOpen())
		m_pProductWareSet->Close();
	m_pProductWareSet->Open(CRecordset::snapshot, strSql);
	while(!m_pProductWareSet->IsEOF())
	{
		m_pWarePurposeSet->MoveFirst();
		while(!m_pWarePurposeSet->IsEOF())
		{
			if(m_pWarePurposeSet->m_Id == m_pProductWareSet->m_WarePurposeId)
				break;

			m_pWarePurposeSet->MoveNext();
		}
		m_pWareTypeSet->MoveFirst();
		while(!m_pWareTypeSet->IsEOF())
		{
			if(m_pWareTypeSet->m_Id == m_pProductWareSet->m_WareTypeId)
				break;

			m_pWareTypeSet->MoveNext();
		}
		m_pWareModeSet->MoveFirst();
		while(!m_pWareModeSet->IsEOF())
		{
			if(m_pWareModeSet->m_Id == m_pProductWareSet->m_WareModeId)
				break;

			m_pWareModeSet->MoveNext();
		}

		m_List.InsertItem(i, m_pProductWareSet->m_ProduceClientSerial);
		m_List.SetItemText(i, 1, 	m_pProductWareSet->m_Draft );
		m_List.SetItemText(i, 2, 	m_pProductWareSet->m_Size );
		m_List.SetItemText(i, 3, 	m_pProductWareSet->m_Unit );
		strSql.Format("%.2f",	m_pProductWareSet->m_Number);
		m_List.SetItemText(i, 4, 	strSql );
		strSql.Format("%.2f",	atof(m_pProductWareSet->m_Price));
		m_List.SetItemText(i, 5, 	strSql );
		m_List.SetItemText(i, 6, 	m_pProductWareSet->m_ProduceType );
		m_List.SetItemText(i, 7, m_pWarePurposeSet->m_WarePurpose);
		m_List.SetItemText(i, 8, m_pWareTypeSet->m_WareType );
		m_List.SetItemText(i, 9, m_pWareModeSet->m_WareMode );
		m_List.SetItemText(i, 10, m_pWareTypeSet->m_Unit );
		strSql.Format("%.2f",	m_pProductWareSet->m_WareNumber);
		m_List.SetItemText(i, 11, 	strSql );
		m_List.SetItemText(i, 12, 	m_pProductWareSet->m_PinHouSize );
		strSql.Format("%d",	m_pProductWareSet->m_PinBanNumber);
		m_List.SetItemText(i, 13, 	strSql );
		m_List.SetItemText(i, 14, 	m_pProductWareSet->m_BanLei );
		m_List.SetItemText(i, 15, 	m_pProductWareSet->m_PrintColorNumber );
		m_List.SetItemText(i, 16, 	m_pProductWareSet->m_PrintJiTai );
		m_List.SetItemText(i, 17, 	m_pProductWareSet->m_DanSeCheSu );
		m_List.SetItemText(i, 18, 	m_pProductWareSet->m_XiaoHaoCheSu );
		m_List.SetItemText(i, 19, 	m_pProductWareSet->m_DingSi );
		m_List.SetItemText(i, 20, 	m_pProductWareSet->m_ShangJiao );
		m_List.SetItemText(i, 21, 	m_pProductWareSet->m_BaoKe );
		m_List.SetItemText(i, 22, 	m_pProductWareSet->m_ChengPingShu );

		if(m_pProductWareSet->m_State == 0)
			m_List.SetItemText(i, 23, "生产中" );
		else
			m_List.SetItemText(i, 23, "完成" );

		if(m_pProductWareSet->m_UpdateDate != 0)
		{
			strSql.Format("%d.%d.%d", m_pProductWareSet->m_UpdateDate.GetYear(),m_pProductWareSet->m_UpdateDate.GetMonth(),m_pProductWareSet->m_UpdateDate.GetDay());
			m_List.SetItemText(i, 24, 	strSql );
		}

		strSql.Format("%d",	m_pProductWareSet->m_Id);
		m_List.SetItemText(i, 25, 	strSql );

		m_pProductWareSet->MoveNext();
		i++;
	}

}

BOOL CDialogProductWareList::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,80,-1);
	m_List.InsertColumn(1,"稿件",LVCFMT_LEFT,80,-1);
	m_List.InsertColumn(2,"稿件尺寸",LVCFMT_LEFT,90,-1);
	m_List.InsertColumn(3,"计量单位",LVCFMT_LEFT,70,-1);
	m_List.InsertColumn(4,"印刷数量",LVCFMT_LEFT,80,-1);
	m_List.InsertColumn(5,"印刷单价",LVCFMT_LEFT,90,-1);
	m_List.InsertColumn(6,"生产类别",LVCFMT_LEFT,80,-1);
	m_List.InsertColumn(7,"原材料种类",LVCFMT_LEFT,80,-1);
	m_List.InsertColumn(8,"物品名",LVCFMT_LEFT,90,-1);
	m_List.InsertColumn(9,"物品型号",LVCFMT_LEFT,70,-1);
	m_List.InsertColumn(10,"计量单位",LVCFMT_LEFT,70,-1);
	m_List.InsertColumn(11,"物品数量",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(12,"拼后尺寸",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(13,"拼板数量",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(14,"板类",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(15,"打印色数",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(16,"打印机台",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(17,"单色车数",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(18,"消耗车数",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(19,"钉丝",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(20,"上胶",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(21,"包壳",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(22,"成品数",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(23,"状态",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(24,"下发日期",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(25,"任务ID",LVCFMT_LEFT,0,-1);

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


void CDialogProductWareList::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日\r\n", t.GetYear(), t.GetMonth(), t.GetDay());
	cJob.csPage = " %d页 / %d";
	cJob.pList = &m_List;
	cJob.OnFilePrint();
	
}


void CDialogProductWareList::PostNcDestroy() 
{
	// TODO: Add your specialized code here and/or call the base class
	
	CMDIChild::DelClassChild(this);
	CDialog::PostNcDestroy();
}

void CDialogProductWareList::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	
	CDialog::OnClose();
	DestroyWindow();
}

LRESULT CDialogProductWareList::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;
}

void CDialogProductWareList::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
	DestroyWindow();
}

void CDialogProductWareList::OnRclickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	m_nSelectItem = 0;
	POSITION pos = m_List.GetFirstSelectedItemPosition();
	if (pos != NULL)
	{
	   while (pos)
	   {
			m_nSelectItem = m_List.GetNextSelectedItem(pos);
	   }
	}
	else
	{
		*pResult = 0;
		return;
	}

	CPoint pt;
	pt.x= GetCurrentMessage()->pt.x;
	pt.y= GetCurrentMessage()->pt.y;

//	CMenu* menu_bar = AfxGetMainWnd()->GetMenu();
//	CMenu* file_menu = menu_bar->GetSubMenu(7);    
//	ASSERT(file_menu);

//	file_menu->TrackPopupMenu(TPM_LEFTALIGN |TPM_RIGHTBUTTON, pt.x, 
//	  pt.y, this);

	CMenu menu;
	if (menu.LoadMenu(ID_POPUP_MENU))
	{
		CMenu* pPopup = menu.GetSubMenu(1);
		ASSERT(pPopup != NULL);

		pPopup->TrackPopupMenu(TPM_LEFTALIGN | TPM_RIGHTBUTTON,
		pt.x, pt.y,	this); // use main window for cmds
	}
	
	*pResult = 0;
}

#include "DialogProduceClient.h"
void CDialogProductWareList::OnMenuEditProductClient() 
{
	// TODO: Add your command handler code here
	CDialogProduceClient dlg;
	dlg.m_pProduceClientSet = m_pProduceClientSet;
	dlg.m_pProductWareSet = m_pProductWareSet;
	dlg.m_pWareModeSet = m_pWareModeSet;
	dlg.m_pWarePurposeSet = m_pWarePurposeSet;
	dlg.m_pWareTypeSet = m_pWareTypeSet;
	dlg.m_pOperatorSet = m_pOperatorSet;
	dlg.m_strOperatorId = m_strOperatorId;
	dlg.m_strSerial = m_List.GetItemText(m_nSelectItem, 0);
	dlg.DoModal();	
}

#include "DialogProductWare.h"
void CDialogProductWareList::OnMenuEditProductWare() 
{
	// TODO: Add your command handler code here
	CDialogProductWare dlg;
	dlg.m_pProductWareSet = m_pProductWareSet;
	dlg.m_pWareModeSet = m_pWareModeSet;
	dlg.m_pWarePurposeSet = m_pWarePurposeSet;
	dlg.m_pWareTypeSet = m_pWareTypeSet;
	dlg.m_pOperatorSet = m_pOperatorSet;
	dlg.m_strOperatorId = m_strOperatorId;
	dlg.m_strSerial = m_List.GetItemText(m_nSelectItem, 0);
//	dlg.m_strUserName = m_strClientName;
//	dlg.m_strAddress = m_strClientAddress;
	dlg.m_nId = atoi(m_List.GetItemText(m_nSelectItem, 25));
	dlg.DoModal();	
}