managesystemview.cpp

使用vc进行数据库编程的好例子

	{
		m_MemDetail_Dlg.m_btnMPreve.EnableWindow(true);
		m_MemDetail_Dlg.m_btnMNext.EnableWindow(true);
	}
	//=============================================

	CString sAge;
	sAge.Format("%d",g_mSet->m_mem_age);
	m_MemDetail_Dlg.m_Age=sAge;

	m_MemDetail_Dlg.m_City=g_mSet->m_city;
	m_MemDetail_Dlg.m_City.TrimRight();
	m_MemDetail_Dlg.m_Company=g_mSet->m_mem_company;
	m_MemDetail_Dlg.m_Company.TrimRight();
	m_MemDetail_Dlg.m_IDCard=g_mSet->m_mem_idcard;
	m_MemDetail_Dlg.m_IDCard.TrimRight();
	m_MemDetail_Dlg.m_Key=g_mSet->m_mem_key;
	m_MemDetail_Dlg.m_Key.TrimRight();
	
	CString sID;
	sID.Format("%d",g_mSet->m_mem_id);
	m_MemDetail_Dlg.m_MemID=sID;

	m_MemDetail_Dlg.m_MemName=g_mSet->m_mem_name;
	m_MemDetail_Dlg.m_MemName.TrimRight();
	m_MemDetail_Dlg.m_Province=g_mSet->m_province;
	m_MemDetail_Dlg.m_Province.TrimRight();

	m_MemDetail_Dlg.m_RegisterDate=g_mSet->m_register_time;
	m_MemDetail_Dlg.m_ctrRegisterDate.UpdateData(false);
	
	CString strSex;
	strSex=g_mSet->m_mem_sex;
	strSex.TrimRight();

	if(strSex=="男")
	{
		m_MemDetail_Dlg.m_nsex=0;
	}
	else
	{
		m_MemDetail_Dlg.m_nsex=1;
	}

	m_MemDetail_Dlg.m_Tel=g_mSet->m_mem_telephone;
	m_MemDetail_Dlg.m_Tel.TrimRight();
	m_MemDetail_Dlg.m_UserName=g_mSet->m_user_name;
	m_MemDetail_Dlg.m_UserName.TrimRight();

	m_MemDetail_Dlg.UpdateData(false);
	
	g_isMlocked=false;
}

void CManageSystemView::ChangeDialog(WPARAM wParam ,LPARAM lParam)
{
	switch(wParam)
	{
	case MEMSIMPLE:
		m_RstSimp_Dlg.ShowWindow(SW_SHOW);
		m_PdtDetail_Dlg.ShowWindow(SW_HIDE);
		m_MemDetail_Dlg.ShowWindow(SW_HIDE);
		break;
	case MEMDETAIL:
		m_RstSimp_Dlg.ShowWindow(SW_HIDE);
		m_PdtDetail_Dlg.ShowWindow(SW_HIDE);
		m_MemDetail_Dlg.ShowWindow(SW_SHOW);
		break;
	case PDTSIMPLE:
		m_RstSimp_Dlg.ShowWindow(SW_SHOW);
		m_PdtDetail_Dlg.ShowWindow(SW_HIDE);
		m_MemDetail_Dlg.ShowWindow(SW_HIDE);
		break;
	case PDTDETAIL: 
		m_RstSimp_Dlg.ShowWindow(SW_HIDE);
		m_PdtDetail_Dlg.ShowWindow(SW_SHOW);
		m_MemDetail_Dlg.ShowWindow(SW_HIDE);
		break;
	default:
		break;
	}
}

void CManageSystemView::DeleteSet(WPARAM wParam ,LPARAM lParam)
{
	int index=wParam;

	if(lParam==DELETEMEM)
	{
		g_mSet->MoveFirst();
		g_mSet->Move(index);

		if(!g_mSet->IsEOF()&&!g_mSet->IsDeleted())
		{
			g_mSet->Delete();
			g_mSet->MoveNext();
		}

		g_isMlocked=false;
	}
	else if(lParam==DELETEPDT)
	{
		g_pSet->MoveFirst();
		g_pSet->Move(index);
		
		if(!g_pSet->IsEOF()&&!g_pSet->IsDeleted())
		{
			g_pSet->Delete();
			g_pSet->MoveNext();
			g_isPLocked=false;
		}
	}
}

void CManageSystemView::ModifySet(WPARAM wParam ,LPARAM lParam)
{
	int index=wParam;
	
	if(lParam==MODIFYMEM)
	{
		ShowMResultDetail(wParam,0);
		m_MemDetail_Dlg.ModifyFromSimple(false);
	}
	else if(lParam==MODIFYPDT)
	{
		ShowPResultDetail(wParam,0);
		m_PdtDetail_Dlg.ModifyFromSimple(false);
	}	
}

void CManageSystemView::DeleteFromDetail(WPARAM wParam ,LPARAM lParam)
{
	CRecordsetStatus rStatus;

	if(lParam==DELETEMEM)
	{
		if(!g_mSet->IsDeleted())
		{
			g_mSet->GetStatus(rStatus);
			g_mSet->Delete();

			g_mSet->MoveNext();
			if(g_mSet->IsEOF())
				g_mSet->MoveFirst();

			while(g_mSet->IsDeleted())
				{
					if(g_mSet->IsEOF())
						break;
					else
						g_mSet->MoveNext();
				}
			
			if(g_mSet->IsEOF())
				ShowMResultDetail(-2,-2);
			else
				ShowMResultDetail(-1,-1);
		}

		g_isMlocked=false;
		::SendMessage(::AfxGetMainWnd()->m_hWnd,WM_UPDETASELDATA,0,UPDATEMEM);
	}
	else if(lParam==DELETEPDT)
	{
	
		if(!g_pSet->IsDeleted())
		{
			g_pSet->GetStatus(rStatus);
			g_pSet->Delete();

			g_pSet->MoveNext();
			if(g_pSet->IsEOF())
				g_pSet->MoveFirst();

			while(g_pSet->IsDeleted())
				{
					if(g_pSet->IsEOF())
						break;
					else
						g_pSet->MoveNext();
				}
			
			if(g_pSet->IsEOF())
				ShowPResultDetail(-2,-2);
			else
				ShowPResultDetail(-1,-1);
		}
		
		g_isPLocked=false;
		::SendMessage(::AfxGetMainWnd()->m_hWnd,WM_UPDETASELDATA,0,UPDATEPDT);
	}

}

void CManageSystemView::EmptyMResultDetail()
{
	m_MemDetail_Dlg.m_Age="";
	m_MemDetail_Dlg.m_City="";
	m_MemDetail_Dlg.m_Company="";
	m_MemDetail_Dlg.m_IDCard="";
	m_MemDetail_Dlg.m_Key="";
	m_MemDetail_Dlg.m_MemID="";
	m_MemDetail_Dlg.m_MemName="";
	m_MemDetail_Dlg.m_Province="";
	m_MemDetail_Dlg.m_Tel="";
	m_MemDetail_Dlg.m_UserName="";

	m_MemDetail_Dlg.UpdateData(false);
}

void CManageSystemView::EmptyPResultDetail()
{
	m_PdtDetail_Dlg.m_Addr="";
	m_PdtDetail_Dlg.m_Amount="";
	m_PdtDetail_Dlg.m_Company="";
	m_PdtDetail_Dlg.m_LinkMan="";
	m_PdtDetail_Dlg.m_Name="";
	m_PdtDetail_Dlg.m_Price="";
	m_PdtDetail_Dlg.m_Produce="";
	m_PdtDetail_Dlg.m_Provide="";
	m_PdtDetail_Dlg.m_Resume="";
	m_PdtDetail_Dlg.m_Specification="";
	m_PdtDetail_Dlg.m_Telephone="";

	m_PdtDetail_Dlg.UpdateData(false);
}

void CManageSystemView::ModifyRecord(WPARAM wParam ,LPARAM lParam)
{
	if(lParam==MODIFYMEM)
	{
		g_mSet->Edit();

		CString sAge;
		sAge=m_MemDetail_Dlg.m_Age;
		g_mSet->m_mem_age=atoi(sAge.operator LPCTSTR());

		g_mSet->m_city=m_MemDetail_Dlg.m_City;
		g_mSet->m_mem_company=m_MemDetail_Dlg.m_Company;
		g_mSet->m_mem_idcard=m_MemDetail_Dlg.m_IDCard;
		g_mSet->m_mem_key=m_MemDetail_Dlg.m_Key;
	
		CString sID;
		sID=m_MemDetail_Dlg.m_MemID;
		g_mSet->m_mem_id=atoi(sID.operator LPCTSTR());

		g_mSet->m_mem_name=m_MemDetail_Dlg.m_MemName;
		g_mSet->m_province=m_MemDetail_Dlg.m_Province;

		g_mSet->m_register_time=m_MemDetail_Dlg.m_RegisterDate;


		if(m_MemDetail_Dlg.m_nsex==0)
		{
			g_mSet->m_mem_sex="男";
		}
		else
		{
			g_mSet->m_mem_sex="女";
		}

		g_mSet->m_mem_telephone=m_MemDetail_Dlg.m_Tel;
		g_mSet->m_user_name=m_MemDetail_Dlg.m_UserName;

		g_mSet->Update();
	
		g_isMlocked=false;

		::SendMessage(::AfxGetMainWnd()->m_hWnd,WM_UPDETASELDATA,0,UPDATEMEM);
	}
	else if(lParam==MODIFYPDT)
	{
		g_pSet->Edit();

		g_pSet->m_company_addr=m_PdtDetail_Dlg.m_Addr;

		CString sAmount;
		sAmount=m_PdtDetail_Dlg.m_Amount;
		g_pSet->m_amount=atoi(sAmount.operator LPCTSTR());

		PRODUCTCLASS* temp=g_ProductClass->next;
		CString ClassName;
		int index=m_PdtDetail_Dlg.m_cmbClassName.GetCurSel();
		m_PdtDetail_Dlg.m_cmbClassName.GetLBText(index,ClassName);
		while(ClassName!=temp->classname)
			temp=temp->next;
		g_pSet->m_class_id=temp->classid;
	
		g_pSet->m_company_name=m_PdtDetail_Dlg.m_Company;
		g_pSet->m_linkman=m_PdtDetail_Dlg.m_LinkMan;
		g_pSet->m_prodt_name=m_PdtDetail_Dlg.m_Name;
		g_pSet->m_unit_price=m_PdtDetail_Dlg.m_Price;
		g_pSet->m_producing_area=m_PdtDetail_Dlg.m_Produce;
		g_pSet->m_provide_area=m_PdtDetail_Dlg.m_Provide;
		g_pSet->m_prodt_resume=m_PdtDetail_Dlg.m_Resume;
		g_pSet->m_specification=m_PdtDetail_Dlg.m_Specification;
		g_pSet->m_comp_telephone=m_PdtDetail_Dlg.m_Telephone;
		g_pSet->m_picture_addr=m_PdtDetail_Dlg.m_strPicAddr;
		g_pSet->Update();

		g_isPLocked=false;

		::SendMessage(::AfxGetMainWnd()->m_hWnd,WM_UPDETASELDATA,0,UPDATEPDT);
	}
}

void CManageSystemView::RecordeMove(WPARAM wParam ,LPARAM lParam)
{
	//============产品详表中移动记录=================//
	//
	if(lParam==SHOW_PDT)
	{
		switch(wParam)
		{
		case RECODE_FIRST:
			g_pSet->MoveFirst();
			while(g_pSet->IsDeleted())
				{
					if(g_pSet->IsEOF())
						break;
					else
						g_pSet->MoveNext();
				}
			
			if(g_pSet->IsEOF())
				ShowPResultDetail(-2,-2);
			else
				ShowPResultDetail(-1,-1);

			break;
		//=========================================
		case RECODE_PREVE:
			g_pSet->MovePrev();
			if(g_pSet->IsBOF())
//				g_pSet->MoveFirst();

			while(g_pSet->IsDeleted())
				{
					if(g_pSet->IsBOF())
						break;
					else
						g_pSet->MovePrev();
				}
			
			if(g_pSet->IsBOF())
				ShowPResultDetail(-2,-2);
			else
				ShowPResultDetail(-1,-1);

			break;
		//==============================================
		case RECODE_NEXT:
			g_pSet->MoveNext();
			if(g_pSet->IsEOF())
//				g_pSet->MoveFirst();

			while(g_pSet->IsDeleted())
				{
					if(g_pSet->IsEOF())
						break;
					else
						g_pSet->MoveNext();
				}
			
			if(g_pSet->IsEOF())
				ShowPResultDetail(-2,-2);
			else
				ShowPResultDetail(-1,-1);

			break;
		//=========================================
		case RECODE_LAST:
			g_pSet->MoveLast();
			while(g_pSet->IsDeleted())
				{
					if(g_pSet->IsBOF())
						break;
					else
						g_pSet->MovePrev();
				}
			
			if(g_pSet->IsBOF())
				ShowPResultDetail(-2,-2);
			else
				ShowPResultDetail(-1,-1);

			break;
		//===========================================
		default:
			break;
		}
	}
	///===============会员详表中移动记录====================///
	//
	else if(lParam=SHOW_MEM)
	{
		switch(wParam)
		{
		case RECODE_FIRST:
			g_mSet->MoveFirst();
			while(g_mSet->IsDeleted())
				{
					if(g_mSet->IsEOF())
						break;
					else
						g_mSet->MoveNext();
				}
			
			if(g_mSet->IsEOF())
				ShowMResultDetail(-2,-2);
			else
				ShowMResultDetail(-1,-1);

			break;
		//=========================================
		case RECODE_PREVE:
			g_mSet->MovePrev();
			if(g_mSet->IsBOF())
//				g_mSet->MoveFirst();

			while(g_mSet->IsDeleted())
				{
					if(g_mSet->IsBOF())
						break;
					else
						g_mSet->MovePrev();
				}
			
			if(g_mSet->IsBOF())
				ShowMResultDetail(-2,-2);
			else
				ShowMResultDetail(-1,-1);

			break;
		//==============================================
		case RECODE_NEXT:
			g_mSet->MoveNext();
			if(g_mSet->IsEOF())
//				g_mSet->MoveFirst();

			while(g_mSet->IsDeleted())
				{
					if(g_mSet->IsEOF())
						break;
					else
						g_mSet->MoveNext();
				}
			
			if(g_mSet->IsEOF())
				ShowMResultDetail(-2,-2);
			else
				ShowMResultDetail(-1,-1);

			break;
		//=========================================
		case RECODE_LAST:
			g_mSet->MoveLast();
			while(g_mSet->IsDeleted())
				{
					if(g_mSet->IsBOF())
						break;
					else
						g_mSet->MovePrev();
				}
			
			if(g_mSet->IsBOF())
				ShowMResultDetail(-2,-2);
			else
				ShowMResultDetail(-1,-1);

			break;
		//==============================================
		default:
			break;
		}
	}
}

void CManageSystemView::OnLogon(WPARAM wParam ,LPARAM lParam)
{
	if(lParam==LOGON_SHOW)
	{
		m_RstSimp_Dlg.ShowWindow(SW_SHOW);
	}
	else if(lParam==LOGON_HIDE)
	{
		m_RstSimp_Dlg.ShowWindow(SW_HIDE);
		m_MemDetail_Dlg.ShowWindow(SW_HIDE);
		m_PdtDetail_Dlg.ShowWindow(SW_HIDE);
	}
}

void CManageSystemView::AutoSizeDlg()
{
	if(m_RstSimp_Dlg.GetSafeHwnd()
		&&m_PdtDetail_Dlg.GetSafeHwnd()
		&&m_RstSimp_Dlg.GetSafeHwnd())
	{
		CRect rect;
		GetClientRect(&rect);
		m_RstSimp_Dlg.MoveWindow(&rect);
		m_PdtDetail_Dlg.MoveWindow(&rect);
		m_MemDetail_Dlg.MoveWindow(&rect);
	}
}

void CManageSystemView::RecordAdd(WPARAM wParam ,LPARAM lParam)
//lParam:	消息来源
//wParam:	
{
	CString sAmount,sID,sAge,ClassName;
	int index;
	PRODUCTCLASS* temp;
	
	switch (lParam)
	{
	//============================	
	case MEM_SIMPLE:
		ShowMResultDetail(wParam,0);
		m_MemDetail_Dlg.ModifyFromSimple(true);
		//m_MemDetail_Dlg
		break;

	//=============================
	case PDT_SIMPLE:
		ShowPResultDetail(wParam,0);
		m_PdtDetail_Dlg.ModifyFromSimple(true);
		break;

	//=============================
	case MEM_DETAIL:
		g_mSet->AddNew();

		sAge=m_MemDetail_Dlg.m_Age;
		g_mSet->m_mem_age=atoi(sAge.operator LPCTSTR());

		g_mSet->m_city=m_MemDetail_Dlg.m_City;
		g_mSet->m_mem_company=m_MemDetail_Dlg.m_Company;
		g_mSet->m_mem_idcard=m_MemDetail_Dlg.m_IDCard;
		g_mSet->m_mem_key=m_MemDetail_Dlg.m_Key;
	
		sID=m_MemDetail_Dlg.m_MemID;
		g_mSet->m_mem_id=atoi(sID.operator LPCTSTR());

		g_mSet->m_mem_name=m_MemDetail_Dlg.m_MemName;
		g_mSet->m_province=m_MemDetail_Dlg.m_Province;

		g_mSet->m_register_time=m_MemDetail_Dlg.m_RegisterDate;


		if(m_MemDetail_Dlg.m_nsex==0)
		{
			g_mSet->m_mem_sex="男";
		}
		else
		{
			g_mSet->m_mem_sex="女";
		}

		g_mSet->m_mem_telephone=m_MemDetail_Dlg.m_Tel;
		g_mSet->m_user_name=m_MemDetail_Dlg.m_UserName;

		g_mSet->Update();
	
		g_isMlocked=false;

		::SendMessage(::AfxGetMainWnd()->m_hWnd,WM_UPDETASELDATA,0,UPDATEMEM);
		break;

	//=============================
	case PDT_DETAIL:
		g_pSet->AddNew();

		g_pSet->m_company_addr=m_PdtDetail_Dlg.m_Addr;

		sAmount=m_PdtDetail_Dlg.m_Amount;
		g_pSet->m_amount=atoi(sAmount.operator LPCTSTR());

		temp=g_ProductClass->next;
		
		index=m_PdtDetail_Dlg.m_cmbClassName.GetCurSel();
		m_PdtDetail_Dlg.m_cmbClassName.GetLBText(index,ClassName);
		while(ClassName!=temp->classname)
			temp=temp->next;
		g_pSet->m_class_id=temp->classid;
		
		g_pSet->m_company_name=m_PdtDetail_Dlg.m_Company;
		g_pSet->m_linkman=m_PdtDetail_Dlg.m_LinkMan;
		g_pSet->m_prodt_name=m_PdtDetail_Dlg.m_Name;
		g_pSet->m_unit_price=m_PdtDetail_Dlg.m_Price;
		g_pSet->m_producing_area=m_PdtDetail_Dlg.m_Produce;
		g_pSet->m_provide_area=m_PdtDetail_Dlg.m_Provide;
		g_pSet->m_prodt_resume=m_PdtDetail_Dlg.m_Resume;
		g_pSet->m_specification=m_PdtDetail_Dlg.m_Specification;
		g_pSet->m_comp_telephone=m_PdtDetail_Dlg.m_Telephone;
		g_pSet->m_picture_addr=m_PdtDetail_Dlg.m_strPicAddr;

		g_pSet->Update();

		g_isPLocked=false;

		::SendMessage(::AfxGetMainWnd()->m_hWnd,WM_UPDETASELDATA,0,UPDATEPDT);
		break;
	//=============================
	default:
		break;
	}

}

void CManageSystemView::RecordModify(WPARAM wParam ,LPARAM lParam)
{

}

void CManageSystemView::RecordDelete(WPARAM wParam ,LPARAM lParam)
{

}