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

📄 dms2dlg.cpp

📁 此系统中
💻 CPP
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
		
		picRs->Release();
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		EndDialog(0);
    } 

	UpdateData(FALSE);

}



/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//在程序结束时关闭数据库连接
void CDMS2Dlg::OnDestroy() 
{
	CDialog::OnDestroy();
	
	// TODO: Add your message handler code here
	m_DBCnt->Close();//关闭数据库连接
}


/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备出库按钮响应函数
void CDMS2Dlg::OnBtnDoadd() 
{
	// TODO: Add your control notification handler code here
	if (m_devso.GetCurSel()==CB_ERR)
	{
		MessageBox("请选择一个设备");
		return;
	}

	m_date = CTime::GetCurrentTime();//获得当前时间(初始化当前m_date,m_time控件)
	m_time = m_date;


	if (!UpdateData())
		return;

	if ((m_max>0.0f) && (m_number>m_max))
	{
		MessageBox("超过最大限量！");
		return;
	}

	_RecordsetPtr pRst = NULL;
	CDevOutRs rs;

	try
	{
		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst->Open("device_out",_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdTable);
      		
		m_devso.GetWindowText(rs.m_sz_code,11);
		sprintf(rs.m_sz_date,"%d-%d-%d %d:%d:%d",
			m_date.GetYear(), m_date.GetMonth(), m_date.GetDay(),
			m_time.GetHour(), m_time.GetMinute(), m_time.GetSecond());
		strcpy(rs.m_sz_dept, m_dept);
		sprintf(rs.m_sz_state, "%d", m_state);
		strcpy(rs.m_sz_keeper, m_keeper);
		rs.m_f_number = m_number;
		strcpy(rs.m_sz_taker, m_taker);
		strcpy(rs.m_sz_usage, m_usage);

		COleSafeArray vaFieldlist, vaValuelist;
		rs.FillFieldsArray(vaFieldlist,vaValuelist);
		TESTHR(pRst->AddNew(vaFieldlist, vaValuelist));//AddNew全靠DataBinding.h文件技持
		pRst->Close();

		CString sql_;
		sql_.Format("SELECT * FROM device WHERE code='%s'", rs.m_sz_code);
		_bstr_t sql = sql_;
		
		pRst->Open(sql, _variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdText);
		if (pRst->GetRecordCount()==1)
		{
			CDevRs rsDev;
			IADORecordBinding   *picRs = NULL;  //Interface Pointer declared.(VC++ Extensions)   
			TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
			TESTHR(picRs->BindToRecordset(&rsDev));

			strcpy(rsDev.m_sz_code, rs.m_sz_code);
			rsDev.m_f_cur = rsDev.m_f_cur - rs.m_f_number;//现存设备数量减少

			TESTHR(picRs->Update(&rsDev));
			picRs->Release();
		}
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		return;
    } 

	MessageBox("完成操作！");



	m_date = CTime::GetCurrentTime();//获得当前时间(初始化当前m_date,m_time控件)
	m_time= m_date;
	UpdateData(FALSE);

	m_logMngr.AddLog("添加出库信息");//向日志数据库追加记录
	RefreshData();
}


/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备入库按钮响应函数
void CDMS2Dlg::OnBtnDiadd() 
{
	// TODO: Add your control notification handler code here

	if (m_devsi.GetCurSel()==CB_ERR)
	{
		MessageBox("请选择一个设备");
		return;
	}

	m_date2 = CTime::GetCurrentTime();//获得当前时间(初始化当前m_date,m_time控件)
	m_time2 = m_date2;
	if (!UpdateData())
	return;

	_RecordsetPtr pRst = NULL;
	CDevInRs rs;

	try
	{
		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst->Open("device_in",_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdTable);
      	
		m_devsi.GetWindowText(rs.m_sz_code,11);
		sprintf(rs.m_sz_date,"%d-%d-%d %d:%d:%d",
			m_date2.GetYear(), m_date2.GetMonth(), m_date2.GetDay(),
			m_time2.GetHour(), m_time2.GetMinute(), m_time2.GetSecond());
		strcpy(rs.m_sz_provider, m_provider);
		strcpy(rs.m_sz_tel, m_tel);
		rs.m_f_number = m_numberin;
		rs.m_f_price = m_price;
		strcpy(rs.m_sz_buyer, m_buyer);

		COleSafeArray vaFieldlist, vaValuelist;
		rs.FillFieldsArray(vaFieldlist,vaValuelist);

//		m_DBCnt->BeginTrans();

		TESTHR(pRst->AddNew(vaFieldlist, vaValuelist));
		pRst->Close();

		CString sql_;
		sql_.Format("SELECT * FROM device WHERE code='%s'", rs.m_sz_code);
		_bstr_t sql = sql_;
		
		pRst->Open(sql, _variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdText);
		if (pRst->GetRecordCount()==0)
		{
			CDevRs rsDev;
			strcpy(rsDev.m_sz_code, rs.m_sz_code);

			rsDev.m_f_cur = rs.m_f_number;
			rsDev.m_f_total = rs.m_f_number;
			rsDev.m_f_max = 1;
			rsDev.m_f_min = 1;

			COleSafeArray vaFields, vaValues;
			rsDev.FillFieldsArray(vaFields,vaValues);
			TESTHR(pRst->AddNew(vaFields, vaValues));
		} else
		{
			CDevRs rsDev;
			IADORecordBinding   *picRs = NULL;  //Interface Pointer declared.(VC++ Extensions)   
			TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
			TESTHR(picRs->BindToRecordset(&rsDev));

			strcpy(rsDev.m_sz_code, rs.m_sz_code);
			rsDev.m_f_cur = rs.m_f_number + rsDev.m_f_cur;
			rsDev.m_f_total = rs.m_f_number + rsDev.m_f_total;

			TESTHR(picRs->Update(&rsDev));
			picRs->Release();
		}
		pRst->Close();

//		m_DBCnt->CommitTrans();
	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.ErrorMessage());
		m_DBCnt->RollbackTrans();
		return;
    } 

	MessageBox("完成操作！");




	m_date2 = CTime::GetCurrentTime();//获得当前时间(初始化当前m_date,m_time控件)
	m_time2 = m_date2;
	UpdateData(FALSE);



	m_logMngr.AddLog("添加入库信息");

	RefreshData();
}



/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//Combo Box 控件（IDC_COMBO_DODEVS）关上时的响应函数
/*
void CDMS2Dlg::OnCloseupComboDodevs() 
{
	// TODO: Add your control notification handler code here
	char buf[64];

	m_devso.GetWindowText(buf,64);
	if (strlen(buf)<=0)
		return;	

	_RecordsetPtr pRst = NULL;
	IADORecordBinding   *picRs = NULL;  //Interface Pointer declared.(VC++ Extensions)   
	CDevRs rs;
	_bstr_t strSQL;

	try
	{
		CString sql;
		sql.Format("SELECT * FROM DEVICE WHERE code='%s'",buf);
		strSQL = sql;

		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));
		pRst->Open(strSQL, _variant_t((IDispatch *) m_DBCnt, true), adOpenKeyset, adLockOptimistic, adCmdText);

		if (pRst->GetRecordCount()!=1)
		{
			m_max = 0;
			UpdateData(FALSE);
			return;
		}

		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));
		
		m_max = rs.m_f_cur;

		picRs->Release();
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
    } 

	UpdateData(FALSE);
}


*/



/////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////
//设备库存管理显示函数
void CDMS2Dlg::RefreshData()
{
	m_list.DeleteAllItems();
	m_list.SetRedraw(FALSE);

	_RecordsetPtr pRst = NULL;
	
	IADORecordBinding   *picRs = NULL;  //Interface Pointer declared.(VC++ Extensions)   
	CDevRs rs;
	try
	{
		_bstr_t strSQL("SELECT * FROM DEVICE");

		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst = m_DBCnt->Execute(strSQL, NULL, adCmdText);
		
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));

		int i = 0;
		char buf[64];
		while (!pRst->adoEOF)
		{
			m_list.Update(1);
			m_list.InsertItem(0, rs.m_sz_code);

			sprintf(buf,"%1.0f",rs.m_f_cur); 	m_list.SetItemText(i, 1, buf);
			sprintf(buf,"%1.0f",rs.m_f_max);	m_list.SetItemText(i, 2, buf);
			sprintf(buf,"%1.0f",rs.m_f_min);	m_list.SetItemText(i, 3, buf);
			sprintf(buf,"%1.0f",rs.m_f_total);	m_list.SetItemText(i, 4, buf);

			pRst->MoveNext();
		}
		picRs->Release();
		pRst->Close();
	}
	catch(_com_error& e)
	{
       	AfxMessageBox(e.ErrorMessage());
		m_list.SetRedraw(TRUE);	
		return;
    } 

	m_list.SetRedraw(TRUE);	

}/**/


/////////////////////////////////////////////////////////////////////////
//list control控件单击响应函数
/////////////////////////////////////////////////////////////////////////
void CDMS2Dlg::OnClickListDev(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int yx = m_list.GetSelectionMark();	
	switch (ii){
	case 1:
		{
			m_devso.SetWindowText(m_list.GetItemText(yx,0));
			m_devsi.SetWindowText(m_list.GetItemText(yx,0));
			m_devs.SetWindowText(m_list.GetItemText(yx,0));
			m_devsr.SetWindowText(m_list.GetItemText(yx,0));
			m_cur = (float)atof(m_list.GetItemText(yx,1));
			m_dmax = (float)atof(m_list.GetItemText(yx,2));
			m_dmin = (float)atof(m_list.GetItemText(yx,3));
			m_total = (float)atof(m_list.GetItemText(yx,4));
			break;
		}
	case 2:
		{
//			m_vicode = m_list.GetItemText(yx,0);
//			m_vidate = m_list.GetItemText(yx,1);
			m_provider = m_list.GetItemText(yx,2);
			m_tel = m_list.GetItemText(yx,3);
			m_numberin = (float)atof(m_list.GetItemText(yx,4));
			m_price = (float)atof(m_list.GetItemText(yx,5));
			m_buyer = m_list.GetItemText(yx,6);
		}
	}
	

	UpdateData(FALSE);
	*pResult = 0;
}



/////////////////////////////////////////////////////////////////////////
//查看设备信息显示函数
void CDMS2Dlg::RefreshDatainfoin()
{
	m_list.DeleteAllItems();
	m_list.SetRedraw(FALSE);	

	_RecordsetPtr pRst = NULL;
	
	IADORecordBinding   *picRs = NULL;  //Interface Pointer declared.(VC++ Extensions)   
	CDevInRs rs;
	try
	{
		_bstr_t strSQL("SELECT * FROM DEVICE_IN");

		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst = m_DBCnt->Execute(strSQL, NULL, adCmdText);
		
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));

		int i = 0;
		char buf[64];
		while (!pRst->adoEOF)
		{
			m_list.InsertItem(0, rs.m_sz_code);
			m_list.SetItemText(i, 1, rs.m_sz_date);
			m_list.SetItemText(i, 2, rs.m_sz_provider);
			m_list.SetItemText(i, 3, rs.m_sz_tel);
			sprintf(buf, "%1.0f", rs.m_f_number); m_list.SetItemText(i, 4, buf);
			sprintf(buf, "%1.0f", rs.m_f_price); m_list.SetItemText(i, 5, buf);
			m_list.SetItemText(i, 6, rs.m_sz_buyer);

			pRst->MoveNext();
		}

		picRs->Release();
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		m_list.SetRedraw(TRUE);	
		return;
    } 

	m_list.SetRedraw(TRUE);	
}
/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//查看入库信息响应函数
void CDMS2Dlg::OnButtonInfoin() 
{
	ii=2;
	//从列表中删除所有列
	m_list.DeleteAllItems();//从列表控件中删除所有项
	m_list.DeleteColumn(4);//从列表控件中删除一列
	m_list.DeleteColumn(3);
	m_list.DeleteColumn(2);
	m_list.DeleteColumn(1);
	m_list.DeleteColumn(0);

	//重新更新列表中的所有列
	m_list.InsertColumn(0,"设备号");
	m_list.InsertColumn(1,"入库时间");
	m_list.InsertColumn(2,"供应商");
	m_list.InsertColumn(3,"供应商电话");
	m_list.InsertColumn(4,"数量");
	m_list.InsertColumn(5,"价格");
	m_list.InsertColumn(6,"采购员");
	
	RECT rect;
	m_list.GetWindowRect(&rect);
	int wid = rect.right - rect.left;
	m_list.SetColumnWidth(0,wid/8);
	m_list.SetColumnWidth(1,wid*3/16);
	m_list.SetColumnWidth(2,wid/8);
	m_list.SetColumnWidth(3,wid*3/16);
	m_list.SetColumnWidth(4,wid/9);
	m_list.SetColumnWidth(5,wid/8);
	m_list.SetColumnWidth(6,wid/8);

	m_list.SetBkColor(RGB(177,151,240));
	m_list.SetTextColor(RGB(0,0,0));
	m_list.SetTextBkColor(RGB(177,151,240));
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);

	RefreshDatainfoin();
	yin();
	yin2();
}

/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//显示设备信息按钮响应函数
void CDMS2Dlg::OnButtonDrve() 
{
	ii=1;
	m_list.SetBkColor(RGB(177,151,240));
	m_list.SetTextColor(RGB(0,0,0));
	m_list.SetTextBkColor(RGB(177,151,240));
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
	// TODO: Add your control notification handler code here
	//从列表中删除所有列
	m_list.DeleteAllItems();//从列表控件中删除所有项
	m_list.DeleteColumn(6);
	m_list.DeleteColumn(5);
	m_list.DeleteColumn(4);//从列表控件中删除一列
	m_list.DeleteColumn(3);
	m_list.DeleteColumn(2);
	m_list.DeleteColumn(1);
	m_list.DeleteColumn(0);
1234

⌨️ 快捷键说明

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