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

📄 fvchild.cpp

📁 我自己整理的一些VC源代码
💻 CPP
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
	case IDC_TG_DAILISHANG:
		QueryDL();
		break;
	case ID_WH_SP:
		QuerySP();
		break;
	case ID_WH_SJ:
		QuerySJ();
		break;
	case IDC_TG_YUANGONG:
		QueryXC();
		break;
	case IDC_YJ_DAILIYJ:
		QueryYJ();
		break;
	case IDC_FILE_GH:
		QueryGH();
		break;
	case ID_VIEW_SPDW:
		QueryCS();
		break;
	}
	m_bt_modify.EnableWindow( FALSE );
	m_bt_delete.EnableWindow( FALSE );
}

void CFVChild::OnBtClose() 
{
	GetParentFrame()->SendMessage( WM_CLOSE );
}

void CFVChild::InitXC()
{
	if( m_nListMode != IDC_TG_YUANGONG )
	{
		ClearList();
		m_nListMode = IDC_TG_YUANGONG;
		Title( "宣 传 员 信 息 维 护" );
		
		m_list_child.InsertColumn( 0, "员工编号", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 1, "员工名称", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 2, "员工电话", LVCFMT_LEFT, 100 );
		m_list_child.InsertColumn( 3, "开户银行", LVCFMT_LEFT, 110 );
		m_list_child.InsertColumn( 4, "银行帐号", LVCFMT_LEFT, 120 );
		m_list_child.InsertColumn( 5, "投资卡号", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 6, "加入日期", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 7, "代理处", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 8, "一部广告余额", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 9, "二部广告余额", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 10, "上次结算日期", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 11, "员工主管", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 12, "推荐人", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 13, "备注信息", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 14, "代理ID", LVCFMT_LEFT, 80 );

		QueryXC();
	}
}

void CFVChild::QueryXC()
{
	int     index = 0;
	CTabXC  tabxc,tabxc1;
	CTabCS  tabcs;
	CTabSJ  tabsj;
	CString strTmp;
	char    szSQL[250];

	m_list_child.DeleteAllItems();
	try
	{
		index = m_list_child.GetItemCount();
		tabxc.Open("WHERE XCJLZT <> 0 ORDER BY XCYGID ");
		while( tabxc.IsOpen() && !tabxc.IsEOF() )
		{
			m_list_child.InsertItem( index, tabxc.XCYGBH.GetValue(), 0 );
			m_list_child.SetItemData( index, atoi( tabxc.XCYGID.GetValue() ) );
			m_list_child.SetItemText( index, 1, tabxc.XCYGMC.GetValue() );
			m_list_child.SetItemText( index, 2, tabxc.XCYGDH.GetValue() );
			memset( szSQL, 0, 250 );
			sprintf( szSQL, "WHERE CSBMBM = 'XC' AND CSZDMC = 'XCKHYH' AND CSSZQZ = %s", tabxc.XCTZKH.GetValue() );
			tabcs.Open( szSQL );
			if ( tabcs.IsOpen() )
				m_list_child.SetItemText( index, 3, tabcs.CSQZMS.GetValue() );
			m_list_child.SetItemText( index, 4, tabxc.XCYHZH.GetValue() );
			memset( szSQL, 0, 250 );
			sprintf( szSQL, "WHERE CSBMBM = 'XC' AND CSZDMC = 'XCTZKH' AND CSSZQZ = %s", tabxc.XCTZKH.GetValue() );
			tabcs.Open( szSQL );
			if ( tabcs.IsOpen() )
				m_list_child.SetItemText( index, 5, tabcs.CSQZMS.GetValue() );
			m_list_child.SetItemText( index, 6, tabxc.XCJRRQ.GetValue() );
			memset( szSQL, 0, 250 );
			sprintf( szSQL, "WHERE SJDLCH = %s", tabxc.XCDLCH.GetValue() );
			tabsj.Open( szSQL );
			if ( tabsj.IsOpen() )
				m_list_child.SetItemText( index, 7, tabsj.SJDLCM.GetValue() );

			strTmp.Format( "%.2f", atof( tabxc.XCYBYE.GetValue().GetBuffer( 0 ) )/100 );
			m_list_child.SetItemText( index, 8, strTmp );
			strTmp.Format( "%.2f", atof( tabxc.XCEBYE.GetValue().GetBuffer( 0 ) )/100 );
			m_list_child.SetItemText( index, 9, strTmp );
			m_list_child.SetItemText( index, 10, tabxc.XCJSRQ.GetValue() );
			memset( szSQL, 0, 250 );
			sprintf( szSQL, "WHERE XCYGID = %s", tabxc.XCYGZG.GetValue() );
			tabxc1.Open( szSQL );
			if ( tabxc1.IsOpen() )
				m_list_child.SetItemText( index, 11, tabxc.XCYGZG.GetValue() + " " + tabxc1.XCYGMC.GetValue() );
			
			memset( szSQL, 0, 250 );
			sprintf( szSQL, "WHERE XCYGID = %s", tabxc.XCTJRH.GetValue() );
			tabxc1.Open( szSQL );
			if ( tabxc1.IsOpen() )
				m_list_child.SetItemText( index, 12, tabxc.XCTJRH.GetValue() + " " + tabxc1.XCYGMC.GetValue() );
			
			m_list_child.SetItemText( index, 13, tabxc.XCBZXX.GetValue() );
			m_list_child.SetItemText( index, 14, tabxc.XCDLMC.GetValue() );
			index ++;
			tabxc.MoveNext();
		}
	}
	catch( _com_error &e )
	{
		AfxMessageBox( e.ErrorMessage() );
	}
}

void CFVChild::InsertXC()
{
	CDlgXC dlg;
	CTabDL	tabdl;
	CTabCS  tabcs;
	CTabSJ	tabsj;
	CTabXC  tabxc1;
	char    szSQL[250];

	if( dlg.DoModal() == IDOK )
	{
		int index = m_list_child.GetItemCount();
		m_list_child.InsertItem( index, dlg.strxcygbh, 0 );
		m_list_child.SetItemData( index, atoi( dlg.strxcygid ) );
		m_list_child.SetItemText( index, 1, dlg.strxcygmc );
		m_list_child.SetItemText( index, 2, dlg.strxcygdh );
	//	m_list_child.SetItemText( index, 3, dlg.strxckhyh );
		m_list_child.SetItemText( index, 4, dlg.strxcyhzh );
	//	m_list_child.SetItemText( index, 5, dlg.strxctzkh );
		m_list_child.SetItemText( index, 6, dlg.strxcjrrq );
	//	m_list_child.SetItemText( index, 7, "" );
		m_list_child.SetItemText( index, 8, dlg.strxcybye );
		m_list_child.SetItemText( index, 9, dlg.strxcebye );
		m_list_child.SetItemText( index, 10, dlg.strxcjsrq );
		//m_list_child.SetItemText( index, 11, "" );
		//m_list_child.SetItemText( index, 12, "" );
		m_list_child.SetItemText( index, 13, dlg.strxcbzxx );
		memset( szSQL, 0, 250 );
		sprintf( szSQL, "WHERE CSBMBM = 'XC' AND CSZDMC = 'XCKHYH' AND CSSZQZ = %s", dlg.strxckhyh.GetBuffer(0) );
		tabcs.Open( szSQL );
		if ( tabcs.IsOpen() )
			m_list_child.SetItemText( index, 3, tabcs.CSQZMS.GetValue() );

		memset( szSQL, 0, 250 );
		sprintf( szSQL, "WHERE CSBMBM = 'XC' AND CSZDMC = 'XCTZKH' AND CSSZQZ = %s", dlg.strxctzkh.GetBuffer(0) );
		tabcs.Open( szSQL );
		if ( tabcs.IsOpen() )
			m_list_child.SetItemText( index, 5, tabcs.CSQZMS.GetValue() );

		memset( szSQL, 0, 250 );
		sprintf( szSQL, "WHERE SJDLCH = %s", dlg.strxcdlch );
		tabsj.Open( szSQL );
		if ( tabsj.IsOpen() )
			m_list_child.SetItemText( index, 7, tabsj.SJDLCM.GetValue() );

		memset( szSQL, 0, 250 );
		sprintf( szSQL, "WHERE XCYGID = %s", dlg.strxcygzg );
		tabxc1.Open( szSQL );
		if ( tabxc1.IsOpen() )
			m_list_child.SetItemText( index, 11, tabxc1.XCYGMC.GetValue() );

		memset( szSQL, 0, 250 );
		sprintf( szSQL, "WHERE XCYGID = %s", dlg.strxctjrh );
		tabxc1.Open( szSQL );
		if ( tabxc1.IsOpen() )
			m_list_child.SetItemText( index, 12, tabxc1.XCYGMC.GetValue() );
			
	}
}

void CFVChild::UpdateXC()
{
	CDlgXC	dlg;
	CTabDL	tabdl;
	CTabCS  tabcs;
	CTabSJ	tabsj;
	CTabXC  tabxc1;
	long	lxcid, ldlid;
	int		nCurrItem;
	char    szSQL[250];
	
	dlg.m_nOperType = MODE_MODIFY;
	memset( szSQL, 0, 250 );

	nCurrItem = m_list_child.GetSelectionMark();
	if ( nCurrItem >= 0 ) 
	{
		dlg.strdldlid = m_list_child.GetItemText( nCurrItem, 14 );
		lxcid = (long)m_list_child.GetItemData( nCurrItem );
		dlg.strxcygid.Format( "%d" , lxcid );

		ldlid = atol( dlg.strdldlid.GetBuffer(0) );
		sprintf( szSQL, "WHERE DLDLID = %d", ldlid );
		tabdl.Open( szSQL );
		if ( tabdl.IsOpen() )
		{
			dlg.strdljhje = tabdl.DLJHJE.GetValue();
			dlg.strdldlmc = tabdl.DLDLMC.GetValue();
			dlg.strxcdlbh = tabdl.DLDLBH.GetValue();
			dlg.strdljhje = tabdl.DLJHJE.GetValue();
			dlg.strdldljb = tabdl.DLDLJB.GetValue();
			dlg.strdlsjdl = tabdl.DLSJDL.GetValue();
			if ( dlg.strdldlmc.GetLength() ) 
				dlg.m_ck_supplier = true;
		}
		
		dlg.strxcygbh = m_list_child.GetItemText( nCurrItem, 0 );
		dlg.strxcygmc =	m_list_child.GetItemText( nCurrItem, 1 );
		dlg.strxcygdh = m_list_child.GetItemText( nCurrItem, 2 );
		dlg.strxckhyh = m_list_child.GetItemText( nCurrItem, 3 );
		dlg.strxcyhzh = m_list_child.GetItemText( nCurrItem, 4 );
		dlg.strxctzkh = m_list_child.GetItemText( nCurrItem, 5 );
		dlg.strxcjrrq = m_list_child.GetItemText( nCurrItem, 6 );
		dlg.strxcdlbh = m_list_child.GetItemText( nCurrItem, 14 );
		dlg.strxcybye = m_list_child.GetItemText( nCurrItem, 8 );
		dlg.strxcebye = m_list_child.GetItemText( nCurrItem, 9 );
		dlg.strxcjsrq = m_list_child.GetItemText( nCurrItem, 10 );
		dlg.strxcygzg = m_list_child.GetItemText( nCurrItem, 11 );
		dlg.strxctjrh = m_list_child.GetItemText( nCurrItem, 12 );
		dlg.strxcbzxx = m_list_child.GetItemText( nCurrItem, 13 );
		dlg.strxcdlch = m_list_child.GetItemText( nCurrItem, 7 );
		if ( dlg.DoModal() == IDOK )
		{
			m_list_child.DeleteItem( nCurrItem );
			m_list_child.InsertItem( nCurrItem, dlg.strxcygbh.GetBuffer(0), 0 );
			m_list_child.SetItemData( nCurrItem, lxcid );
			m_list_child.SetItemText( nCurrItem, 2, dlg.strxcygdh.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 1, dlg.strxcygmc.GetBuffer(0) );
			//m_list_child.SetItemText( nCurrItem, 3, dlg.strxckhyh.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 4, dlg.strxcyhzh.GetBuffer(0) );
			//m_list_child.SetItemText( nCurrItem, 5, dlg.strxctzkh.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 6, dlg.strxcjrrq.GetBuffer(0) );
		//	m_list_child.SetItemText( nCurrItem, 7, dlg.strxcdlbh.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 8, dlg.strxcybye.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 9, dlg.strxcebye.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 10, dlg.strxcjsrq.GetBuffer(0) );
			//m_list_child.SetItemText( nCurrItem, 11, dlg.strxcygzg.GetBuffer(0) );
		//	m_list_child.SetItemText( nCurrItem, 12, dlg.strxctjrh.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 13, dlg.strxcbzxx.GetBuffer(0) );
			m_list_child.SetItemText( nCurrItem, 14, dlg.strdldlid.GetBuffer(0) );
			try
			{
				memset( szSQL, 0, 250 );
				sprintf( szSQL, "WHERE CSBMBM = 'XC' AND CSZDMC = 'XCKHYH' AND CSSZQZ = %s", dlg.strxckhyh.GetBuffer(0) );
				tabcs.Open( szSQL );
				if ( tabcs.IsOpen() )
				m_list_child.SetItemText( nCurrItem, 3, tabcs.CSQZMS.GetValue() );

				memset( szSQL, 0, 250 );
				sprintf( szSQL, "WHERE CSBMBM = 'XC' AND CSZDMC = 'XCTZKH' AND CSSZQZ = %s", dlg.strxctzkh.GetBuffer(0) );
				tabcs.Open( szSQL );
				if ( tabcs.IsOpen() )
				m_list_child.SetItemText( nCurrItem, 5, tabcs.CSQZMS.GetValue() );

				memset( szSQL, 0, 250 );
				sprintf( szSQL, "WHERE SJDLCH = %s", dlg.strxcdlch );
				tabsj.Open( szSQL );
				if ( tabsj.IsOpen() )
					m_list_child.SetItemText( nCurrItem, 7, tabsj.SJDLCM.GetValue() );

				memset( szSQL, 0, 250 );
				sprintf( szSQL, "WHERE XCYGID = %s", dlg.strxcygzg );
				tabxc1.Open( szSQL );
				if ( tabxc1.IsOpen() )
					m_list_child.SetItemText( nCurrItem, 11, dlg.strxcygzg + " " + tabxc1.XCYGMC.GetValue() );

				memset( szSQL, 0, 250 );
				sprintf( szSQL, "WHERE XCYGID = %s", dlg.strxctjrh );
				tabxc1.Open( szSQL );
				if ( tabxc1.IsOpen() )
					m_list_child.SetItemText( nCurrItem, 12, dlg.strxctjrh + " " + tabxc1.XCYGMC.GetValue() );
			}
			catch(...)
			{

			}
			
		}
	}
}

void CFVChild::DeleteXC()
{
	char	szSQL[250], szTmp[100];
	int		nCurrItem;
	long	lxcid, ldlid;

	memset( szSQL, 0, 250 );
	memset( szTmp, 0, 100 );
	nCurrItem = m_list_child.GetSelectionMark();
	if ( nCurrItem >= 0 )
	{
		m_list_child.GetItemText( nCurrItem, 14, szTmp, 50 );
		ldlid = atol( szTmp );
		lxcid = (long)m_list_child.GetItemData( nCurrItem );
		try
		{
			connection->BeginTrans();
			sprintf( szSQL, "DELETE FROM DL WHERE DLDLID = %d", ldlid );
			connection->Execute( szSQL, NULL, adExecuteNoRecords );

			memset( szSQL, 0, 250 );
			sprintf( szSQL, "DELETE FROM XC WHERE XCYGID = %d", lxcid );
			connection->Execute( szSQL, NULL, adExecuteNoRecords );

			connection->CommitTrans();
			m_list_child.DeleteItem( nCurrItem );
		}
		catch( _com_error &e )
		{
			connection->RollbackTrans();
			AfxMessageBox( e.ErrorMessage() );
		}
		catch( ... )
		{
			connection->RollbackTrans();
		}

	}	
}

void CFVChild::InitDL()
{
	if( m_nListMode != IDC_TG_DAILISHANG )
	{
		ClearList();
		m_nListMode = IDC_TG_DAILISHANG;
		Title( "代 理 商 信 息 维 护" );
		
		m_list_child.InsertColumn( 0, "编号", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 1, "代理商名称", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 2, "代理商电话", LVCFMT_LEFT, 100 );
		m_list_child.InsertColumn( 3, "开户银行", LVCFMT_LEFT, 120 );
		m_list_child.InsertColumn( 4, "银行帐号", LVCFMT_LEFT, 100 );
		m_list_child.InsertColumn( 5, "加入日期", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 6, "负责人", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 7, "代理级别", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 8, "进货金额(首次)", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 9, "主管", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 10, "推荐人", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 11, "上级代理", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 12, "代理处", LVCFMT_LEFT, 80 );
		m_list_child.InsertColumn( 13, "备注信息", LVCFMT_LEFT, 130 );
		QueryDL();
	}
}

void CFVChild::QueryDL()
{
	int index = 0;
	CTabDL tabdl;
	CTabDL tabdl1;
	CTabXC tabxc;
	CTabSJ tabsj;
	CTabCS tabcs;
	char szSQL[ 255 ];
1234

⌨️ 快捷键说明

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