toolturn.cpp

基于SQLSERVER2000的机械工艺数据库系统

            iItem = m_Turnlist.GetNextSelectedItem(pos);
           sToolid = m_Turnlist.GetItemText(iItem, 0);
		    strQuery = "delete from toolturn where turnid='"+sToolid+"'";
	        theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	    	m_Turnlist.DeleteItem(iItem);
		}
 	}
 	m_sTurnbrand="";
	m_sTooltype="";
	m_sTurnmaterial="";
   	m_sTurnname="";
	m_sFormaterial="";
	m_sPath="";
	m_sProducer="";
	m_sToolID="";
	bt_delete->EnableWindow(false);
	bt_modify->EnableWindow(false);
 	UpdateData(false);	
	
}

void CTOOLTURN::OnTurnModify() 
{
	// TODO: Add your control notification handler code here
	tx_Turnbrand->EnableWindow(true);
	tx_Tooltype->EnableWindow(true);
	tx_Turnmaterial->EnableWindow(true);
    tx_Turnname->EnableWindow(true);
    tx_Formaterial->EnableWindow(true);
	tx_Path->EnableWindow(true);
	tx_Producer->EnableWindow(true);
	tx_ToolID->EnableWindow(true);
	flag=2;
	bt_save->EnableWindow(true);
	bt_delete->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_browse->EnableWindow(true);
}

void CTOOLTURN::OnTurnSave() 
{   // TODO: Add your control notification handler code here
		UpdateData(true);
	// Make sure all needed info is available
	CString sWarning="";
	if ( ""==m_sToolID ) sWarning=_T("刀具编号");
    else if ( ""==m_sTurnname) sWarning=_T("车刀名称");
	else if ( ""==m_sTooltype) sWarning=_T("车刀类型");
	else if ( ""==m_sTurnbrand) sWarning=_T("车刀型号");
	else if ( ""==m_sTurnmaterial) sWarning=_T("刀具材料");
	else if ( ""==m_sFormaterial) sWarning=_T("适合加工材料");
	else if ( ""==m_sProducer) sWarning=_T("生产商");

    if ( ""!=sWarning ) 
	{
	   sWarning += _T("不能为空");
	   AfxMessageBox(sWarning, MB_ICONEXCLAMATION);
	   return;
	}
	_variant_t strQuery;
	if(flag==1)  //添加记录
	{
		// Judge Turn is unique
	    strQuery = "select * from toolturn where turnid='"+m_sToolID+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	    int iCount = theApp.m_pADOSet->GetRecordCount();
	    if ( 0!=iCount )
		{
	       AfxMessageBox(_T("已经存在此刀具记录！"), MB_ICONEXCLAMATION);
	       return;
		}
	}
else if(flag==2)//修改
	{  //删除旧记录
		strQuery = "delete from toolturn where turnid='"+m_sToolID+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	}
	// Insert Record
	strQuery = "insert toolturn (turnid, turnname, turntype,turnmodel,turnmaterial,formaterial,producer,turnpicdir) \
		        values ('"+m_sToolID+"', '"+m_sTurnname+"', '"+m_sTooltype+"','"+m_sTurnbrand+"','"+m_sTurnmaterial+"','"+m_sFormaterial+"','"+m_sProducer+"','"+m_sPath+"')";
   int iItem;
  POSITION pos = m_Turnlist.GetFirstSelectedItemPosition();
  iItem = m_Turnlist.GetNextSelectedItem(pos);
	m_Turnlist.DeleteItem(iItem);
	//更新列表框数据
	int j;
	j=m_Turnlist.GetItemCount();
	m_Turnlist.InsertItem(j, m_sToolID);
    m_Turnlist.SetItemText(j, 1 , m_sTurnname);
    m_Turnlist.SetItemText(j, 2 , m_sTooltype);
	m_Turnlist.SetItemText(j, 3 , m_sTurnbrand);
    m_Turnlist.SetItemText(j, 4 , m_sTurnmaterial);
    m_Turnlist.SetItemText(j, 5 , m_sFormaterial);
	m_Turnlist.SetItemText(j, 6 , m_sProducer);
    m_Turnlist.SetItemText(j, 7 , m_sPath);


	if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
	{
	    if (flag==1) 
		{
			AfxMessageBox(_T("添加刀具信息成功！"), MB_ICONINFORMATION);
	        // Clear all input
       m_sToolID=m_sTurnname=m_sTooltype=m_sTurnbrand=m_sTurnmaterial=m_sFormaterial=m_sProducer=m_sPath="";
            UpdateData(false);
		}
		else AfxMessageBox(_T("修改刀具信息成功！"), MB_ICONINFORMATION);
	}
	else 
	{
		if (flag==1) AfxMessageBox(_T("添加刀具信息失败！"), MB_ICONEXCLAMATION);
		else AfxMessageBox(_T("修改刀具信息失败！"), MB_ICONEXCLAMATION);
	}
    tx_Turnbrand->EnableWindow(false);
	tx_Tooltype->EnableWindow(false);
	tx_Turnmaterial->EnableWindow(false);
    tx_Turnname->EnableWindow(false);	
	tx_Formaterial->EnableWindow(false);
	tx_Path->EnableWindow(false);
	tx_Producer->EnableWindow(false);
	tx_ToolID->EnableWindow(false);
	
	bt_add->EnableWindow(true);
	bt_save->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);
	bt_browse->EnableWindow(false);
}

BOOL CTOOLTURN::OnInitDialog() 
{
	 CDialog::OnInitDialog();
	_variant_t strQuery, Holder;
	CString str;
	DWORD style;
	style=m_Turnlist.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_Turnlist.SetExtendedStyle(style);
	m_sOldTurnid = m_sToolID;
	
	// Set Color
	//m_Codelist.SetBkColor(RGB(177, 151, 240));
//	m_Codelist.SetTextColor(RGB(0,0,0));
//	m_Codelist.SetTextBkColor(RGB(177, 151, 240));
    // 设置表字段
	m_Turnlist.InsertColumn(0,"刀具编号",LVCFMT_LEFT,100);
	m_Turnlist.InsertColumn(1,"车刀名称",LVCFMT_LEFT,100);
 	m_Turnlist.InsertColumn(2,"车刀类型",LVCFMT_LEFT,100);
    m_Turnlist.InsertColumn(3,"车刀型号",LVCFMT_LEFT,100);
	m_Turnlist.InsertColumn(4,"刀具材料",LVCFMT_LEFT,100);
	m_Turnlist.InsertColumn(5,"适合加工材料",LVCFMT_LEFT,100);
    m_Turnlist.InsertColumn(6,"生产商",LVCFMT_LEFT,100);
	m_Turnlist.InsertColumn(7,"刀具图片地址",LVCFMT_LEFT,100);

	flag=0;
	
	tx_Turnbrand=GetDlgItem(IDC_EDIT12);
	tx_Turnmaterial=GetDlgItem(IDC_EDIT3);
    tx_Turnname=GetDlgItem(IDC_EDIT2);
	tx_Tooltype=GetDlgItem(IDC_COMBO1);
	tx_Formaterial=GetDlgItem(IDC_EDIT5);
	tx_Path=GetDlgItem(IDC_EDIT17);
	tx_Producer=GetDlgItem(IDC_EDIT6);
	tx_ToolID=GetDlgItem(IDC_EDIT1);

	bt_add=GetDlgItem(IDC_TurnAdd);
	bt_save=GetDlgItem(IDC_TurnSave);
	bt_modify=GetDlgItem(IDC_TurnModify);
	bt_delete=GetDlgItem(IDC_TurnDelete);
    bt_browse=GetDlgItem(IDC_TurnBrowse);

    tx_Turnbrand->EnableWindow(false);
	tx_Turnmaterial->EnableWindow(false);
    tx_Turnname->EnableWindow(false);
	tx_Tooltype->EnableWindow(false);
	tx_Formaterial->EnableWindow(false);
	tx_Path->EnableWindow(false);
	tx_Producer->EnableWindow(false);
	tx_ToolID->EnableWindow(false);
  	
	bt_add->EnableWindow(true);
	bt_save->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);
	bt_browse->EnableWindow(false);
//组合框初始化
    CString stri[2]={"可转位刀片","整体车刀"};
	for(int m=0;m<2;m++)
	{ ((CComboBox*)GetDlgItem(IDC_COMBO1))->InsertString(m, stri[m]);
	}
    ((CComboBox*)GetDlgItem(IDC_COMBO1))->SetCurSel(0);
	UpdateData(FALSE);

//列表框数据初始化
	strQuery = "select * from toolturn";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    int iCount = theApp.m_pADOSet->GetRecordCount();
	if (0==iCount) return 0;
	theApp.m_pADOSet->MoveFirst();
	for (int i=0; i<iCount; i++)
    {
		// Get toolid
		Holder = theApp.m_pADOSet->GetCollect("turnid");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.InsertItem(i, str);
	    // Get turnname
        Holder = theApp.m_pADOSet->GetCollect("turnname");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.SetItemText(i, 1, str);
		// Get turndia
        Holder = theApp.m_pADOSet->GetCollect("turntype");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.SetItemText(i, 2, str);
		// Get turnbrand
        Holder = theApp.m_pADOSet->GetCollect("turnmodel");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.SetItemText(i, 3, str);
		// Get turnmateria
        Holder = theApp.m_pADOSet->GetCollect("turnmaterial");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.SetItemText(i, 4, str);
		// Get formaterial
        Holder = theApp.m_pADOSet->GetCollect("formaterial");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.SetItemText(i, 5, str);
		// Get producer
        Holder = theApp.m_pADOSet->GetCollect("producer");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.SetItemText(i, 6, str);
		// Get path
        Holder = theApp.m_pADOSet->GetCollect("turnpicdir");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Turnlist.SetItemText(i, 7, str);

		theApp.m_pADOSet->MoveNext();
	}
	
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTOOLTURN::OnPaint() 
{
    CPaintDC dc(this); // device context for painting
	int x=520, y=160;
	int iWidth=400, iHeight=400;
	// TODO: Add your message handler code here
	if(!m_hBitmap)  //如果内存中没有BMP数据，则返回
		return;
	HBITMAP tmpBitmap;  //用于保存输出到屏幕的BMP数据
	CDC MemDC;  //CDC对象，用于输出到屏幕
	MemDC.CreateCompatibleDC(&dc);
	tmpBitmap = (HBITMAP)MemDC.SelectObject(m_hBitmap);
	dc.BitBlt(x,y,iWidth,iHeight,&MemDC,0,0,SRCCOPY);
	MemDC.SelectObject(tmpBitmap);
	
	
	// Do not call CDialog::OnPaint() for painting messages
}