dms2dlg.cpp

此系统中

	//重新更新列表中的所有列
	m_list.InsertColumn(0,"设备号");
	m_list.InsertColumn(1,"现存数量");
	m_list.InsertColumn(2,"最大数量");
	m_list.InsertColumn(3,"最小数量");
	m_list.InsertColumn(4,"总数");
	
	RECT rect;
	m_list.GetWindowRect(&rect);
	int wid = rect.right - rect.left;
	m_list.SetColumnWidth(0,wid/5);
	m_list.SetColumnWidth(1,wid/5);
	m_list.SetColumnWidth(2,wid/5);
	m_list.SetColumnWidth(3,wid/5);
	m_list.SetColumnWidth(4,wid/5);

	RefreshData();
	yin();
	yin2();
}



/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备信息增加函数
void CDMS2Dlg::OnBtnDevadd() 
{
	// TODO: Add your control notification handler code here
	if (!UpdateData())
		return;

	_RecordsetPtr pRst = NULL;
	CDevRs rs;

	m_devs.GetWindowText(rs.m_sz_code,10);

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

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

		pRst->Open("device",_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdTable);
      		
		m_devs.GetWindowText(rs.m_sz_code,10);
		rs.m_f_cur = m_cur;
		rs.m_f_max = m_dmax;
		rs.m_f_min = m_dmin;
		rs.m_f_total = m_total;
	
		COleSafeArray vaFieldlist, vaValuelist;
		rs.FillFieldsArray(vaFieldlist,vaValuelist);
		TESTHR(pRst->AddNew(vaFieldlist, vaValuelist));
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		return;
    } 

	MessageBox("完成操作！");
	m_logMngr.AddLog("添加库存信息");
	
	RefreshData();
}





/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备信息删除函数
void CDMS2Dlg::OnBtnDevdel() 
{
	// TODO: Add your control notification handler code here

	if (!UpdateData())
		return;

	CString code;
	m_devs.GetWindowText(code);

	CString sql_;
	sql_.Format("DELETE FROM DEVICE WHERE CODE='%s'",code);
	_bstr_t sql = sql_;
	try
	{
		m_DBCnt->Execute(sql,NULL,adCmdText);
	} 
	catch(_com_error& e)
    {
        AfxMessageBox(e.ErrorMessage());
		return;
    }  
	MessageBox("完成操作！");	
	m_logMngr.AddLog("删除库存记录。");
      
	RefreshData(); 
}




/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备信息修改函数
void CDMS2Dlg::OnBtnDevupd() 
{
	// TODO: Add your control notification handler code here
	if (!UpdateData())
	return;

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

	m_devs.GetWindowText(rs.m_sz_code,10);

	if (strlen(rs.m_sz_code)<=0)
	{
		MessageBox("请选择一个设备");
		return;
	}

	CString sql_;
	sql_.Format("SELECT * FROM DEVICE WHERE code='%s'", rs.m_sz_code);
	_bstr_t sql = sql_;

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

		pRst->Open(sql,_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdText);
      		
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));

		rs.m_f_cur = m_cur;
		rs.m_f_max = m_dmax;
		rs.m_f_min = m_dmin;
		rs.m_f_total = m_total;

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

	MessageBox("完成操作！");
	m_logMngr.AddLog("修改库存信息");
	
	RefreshData();
}


/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备信息对话框打开函数
void CDMS2Dlg::OnBtnDevcode() 
{
	// TODO: Add your control notification handler code here
	CDlgDevCode dlg;
	dlg.Setup(m_DBCnt,&m_logMngr);
	dlg.DoModal();
	if(ii==1){
		Initdlgout();
		Initdlgin();
	}

}



/////////////////////////////////////////////////////////////////////////
//打开查看日志文件对话框
/////////////////////////////////////////////////////////////////////////
void CDMS2Dlg::OnBtnViewlog() 
{
	// TODO: Add your control notification handler code here
	CDlgViewLog dlg;
	dlg.SetDBConnection(m_DBCnt);
	dlg.DoModal();
}







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


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

	if (!UpdateData())
		return;
	
	_RecordsetPtr pRst = NULL;
	CDevRetRs rs;

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

		pRst->Open("device_return",_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdTable);
      		
		m_devsr.GetWindowText(rs.m_sz_code,11);
		sprintf(rs.m_sz_date,"%d-%d-%d %d:%d:%d",
			m_date3.GetYear(), m_date3.GetMonth(), m_date3.GetDay(),
			m_time3.GetHour(), m_time3.GetMinute(), m_time3.GetSecond());
		strcpy(rs.m_sz_keeper, m_keeperR);
		rs.m_f_number = m_numberR;
		strcpy(rs.m_sz_reter, m_reter);

		COleSafeArray vaFieldlist, vaValuelist;
		rs.FillFieldsArray(vaFieldlist,vaValuelist);
		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()==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 = rs.m_f_number + rsDev.m_f_cur;

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

	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		return;
    } 

	MessageBox("完成操作！");

	m_date3 = CTime::GetCurrentTime();//获得当前时间(初始化当前m_date,m_time控件)
	m_time3 = m_date3;
	UpdateData(false);
	m_logMngr.AddLog("添加还库信息");
	RefreshData();
}



/*
/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备入库信息修改函数
void CDMS2Dlg::OnBtnViupdate() 
{
	// TODO: Add your control notification handler code here

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

	if (!UpdateData())
		return;

	CString sql_;
	sql_.Format(CString("SELECT *FROM DEVICE_IN WHERE in_date=")+DATEFMT, m_vidate);
//	sql_.Format("SELECT *FROM DEVICE_IN WHERE code='%s'",m_vicode);
	_bstr_t sql = sql_;

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

	try
	{
		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));
		
		pRst->Open(sql,_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdText);
      	 		
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));

		strcpy(rs.m_sz_code,m_vicode);
		strcpy(rs.m_sz_date,m_vidate);
		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);

		TESTHR(picRs->Update(&rs));

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

	MessageBox("完成操作！");
	m_logMngr.AddLog("修改入库信息");

	RefreshDatainfoin();
}
*/

/*
void CDMS2Dlg::OnBtnVidel() 
{
	// TODO: Add your control notification handler code here
	if (!UpdateData())
		return;

	CString sql_;
	sql_.Format(CString("DELETE *FROM DEVICE_IN WHERE in_date=")+DATEFMT, m_vidate);
//	sql_.Format("DELETE FROM DEVICE_IN WHERE code='%s'",m_vicode);
	_bstr_t sql = sql_;

	try
	{
		m_DBCnt->Execute(sql, NULL, adCmdText);
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		return;
    } 
	MessageBox("完成操作！");
	m_logMngr.AddLog("删除入库信息");

	RefreshDatainfoin();
}
*/

/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//库存报警按钮显示函数
void CDMS2Dlg::OnBtnDevalert() 
{
	// TODO: Add your control notification handler code here
	CDlgDevAlert dlg;
	dlg.Setup(m_DBCnt,&m_logMngr);
	dlg.DoModal();
}


/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//需求信息按钮显示函数
void CDMS2Dlg::OnBtnInfoneed() 
{
	// TODO: Add your control notification handler code here
	CDlgViewNeed dlg;
	dlg.Setup(m_DBCnt,&m_logMngr);
	dlg.DoModal();
}



/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
//设备采购信息按钮显示函数
void CDMS2Dlg::OnBtnViewprt() 
{
	// TODO: Add your control notification handler code here
	CDlgViewReport dlg;
	dlg.Setup(m_DBCnt,&m_logMngr);
	dlg.DoModal();
}

void CDMS2Dlg::OnBtnInfoout() 
{
	// TODO: Add your control notification handler code here
	CDlgViewOut dlg;
	dlg.Setup(m_DBCnt,&m_logMngr);
	dlg.DoModal();
}

void CDMS2Dlg::OnBtnInforet() 
{
	// TODO: Add your control notification handler code here
	CDlgViewRet dlg;
	dlg.Setup(m_DBCnt,&m_logMngr);
	dlg.DoModal();

}

void CDMS2Dlg::OnButtonModpsw() 
{
	// TODO: Add your control notification handler code here
	CModPsward m_modpswd;
	m_database.Close();
	m_modpswd.user.Format("%s",user);//将用户名传递给修改密码对话框变量
	m_modpswd.m_database.Open(_T("DMS"));//在对话框里打开数据库
	m_modpswd.DoModal();
}

void CDMS2Dlg::Onaboutbox() 
{
	// TODO: Add your control notification handler code here
	CAboutDlg yy;
	yy.DoModal();
}

void CAboutDlg::OnOK() 
{
	// TODO: Add extra validation here
	WinExec("WINHELP.EXE yx.chm",SW_SHOW);

	CDialog::OnOK();
}












void CDMS2Dlg::yin()
{
	//修改已有设备
	//(按钮）
	((CStatic *)GetDlgItem(IDC_STATICer))->EnableWindow(false);//查看设备信息
	((CStatic *)GetDlgItem(IDC_STATICer))->ShowWindow(false);

	((CStatic *)GetDlgItem(IDC_BTN_DEVDEL))->EnableWindow(false);//删除
	((CStatic *)GetDlgItem(IDC_BTN_DEVDEL))->ShowWindow(false);

	((CStatic *)GetDlgItem(IDC_BTN_DEVUPD))->EnableWindow(false);//修改
	((CStatic *)GetDlgItem(IDC_BTN_DEVUPD))->ShowWindow(false);

	((CStatic *)GetDlgItem(IDC_BTN_DEVADD))->EnableWindow(false);//新增
	((CStatic *)GetDlgItem(IDC_BTN_DEVADD))->ShowWindow(false);


    //(静态控件）
	((CStatic *)GetDlgItem(IDC_stDevCode))->EnableWindow(false);//使这个控件失效
	((CStatic *)GetDlgItem(IDC_stDevCode))->ShowWindow(false);

	((CStatic *)GetDlgItem(IDC_stNowNumber))->EnableWindow(false);//使这个控件失效
	((CStatic *)GetDlgItem(IDC_stNowNumber))->ShowWindow(false);

	((CStatic *)GetDlgItem(IDC_stMaxNumber))->EnableWindow(false);//使这个控件失效
	((CStatic *)GetDlgItem(IDC_stMaxNumber))->ShowWindow(false);

	((CStatic *)GetDlgItem(IDC_stSmNumber))->EnableWindow(false);//使这个控件失效
	((CStatic *)GetDlgItem(IDC_stSmNumber))->ShowWindow(false);

	((CStatic *)GetDlgItem(IDC_stTotal))->EnableWindow(false);//使这个控件失效