sr_fksq_dlg.cpp

用C++写的数据库软件

		str2 += "','";
		//经办人名称
		str1 += " JBRMC , ";
		str2 += m_JBRMC ;
		str2 += "','";
		//制单人
		str1 += " ZDRMC , ";
		m_ComboZDRMC.GetWindowText(temp);
		str2 += temp;
		str2 += "','";
		//NR1
		str1 += " NR1 , ";
		str2 += m_NR1 ;
		str2 += "','";
		//NR2
		str1 += " NR2 , ";
		str2 += m_NR2 ;
		str2 += "','";
		//NR3
		str1 += " NR3  ";
		str2 += m_NR3 ;
		str2 += "'";
		//NR4
		//NR5
		//NR6
		//NR7
		
		//end
		str1 += " ) " ;
		str2 += " ) ";
		str = str1 + str2;

		CShowStringDlg SSDlg2;
		SSDlg2.SetString(str);
	//	SSDlg2.DoModal();

		if(encaAdo.ExecuteSQL(LPCSTR(str)))
		{
			MessageBox("提交成功！");
		}
		else
		{
			MessageBox("提交失败！");
		}
	}
	this->EndDialog(0);
}




void CSR_FKSQ_Dlg::OnBtnSave() 
{
	OnBtnSubmit();	
}

void CSR_FKSQ_Dlg::setDJBJ(CString djbh)
{
	m_DJBH = "No." + djbh;
}

bool CSR_FKSQ_Dlg::readDJBH(CString djbh)
{
	m_strDJBH = djbh;
	return true;
}

BOOL CSR_FKSQ_Dlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	_RecordsetPtr rs;
	_variant_t var;
	// 连接数据库
	encaAdo.InitADOConn("","", "", "dbo.FKSQXT"); 
	InitCombo();
	
	if(m_strDJBH == "")
	{
		return TRUE;
	}
	CString str("select * from FKSQD where DJBH = '");
	str += m_strDJBH + "'";
	rs = encaAdo.GetRecordSet(LPCSTR(str));
	//单据编号
	m_DJBH = "No." + m_strDJBH;
	//收款单位
	var = rs->GetCollect("SKDW"); 
	if(var.vt != VT_NULL)
	{
		//		m_ComboSKDW.AddString(LPCSTR(_bstr_t(var)));
		m_ComboSKDW.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//收款单位名
	var = rs->GetCollect("SKDWMC"); 
	if(var.vt != VT_NULL)
	{
		m_SKDWMC = LPCSTR(_bstr_t(var));
	}
	//收款人
	var = rs->GetCollect("SKR");
	if(var.vt != VT_NULL)
	{
		//		m_ComboSKR.AddString(LPCSTR(_bstr_t(var)));
		m_ComboSKR.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//收款人名称
	var = rs->GetCollect("SKRMC"); 
	if(var.vt != VT_NULL)
	{
		m_SKRMC = LPCSTR(_bstr_t(var));
	}
	//收款银行
	var = rs->GetCollect("SKYH"); 
	if(var.vt != VT_NULL)
	{
		//		m_ComboSKYH.AddString(LPCSTR(_bstr_t(var)));
		m_ComboSKYH.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//银行账号
	var = rs->GetCollect("SKZH");
	if(var.vt != VT_NULL)
	{
		m_YHZH = LPCSTR(_bstr_t(var));
	}
	//事由
	var = rs->GetCollect("SY");
	if(var.vt != VT_NULL)
	{
		m_SY = LPCSTR(_bstr_t(var));
	}
	//合同编号
	var = rs->GetCollect("HTBH");
	if(var.vt != VT_NULL)
	{
		m_HTBH = LPCSTR(_bstr_t(var));
	}
	//合同金额
	var = rs->GetCollect("HTJE");
	if(var.vt != VT_NULL)
	{
		m_HTJE = LPCSTR(_bstr_t(var));
	}
	//预算科目
	var = rs->GetCollect("YSKM");
	if(var.vt != VT_NULL)
	{
		//		m_ComboYSKM.AddString(LPCSTR(_bstr_t(var)));
		m_ComboYSKM.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//预算科目名称
	var = rs->GetCollect("YSKMMC");
	if(var.vt != VT_NULL)
	{
		m_YSKMMC = LPCSTR(_bstr_t(var));
	}
	//发票价款
	var = rs->GetCollect("FPJK");
	if(var.vt != VT_NULL)
	{
		m_FPJK = LPCSTR(_bstr_t(var));
	}
	//增值税额
	var = rs->GetCollect("ZZSE");
	if(var.vt != VT_NULL)
	{
		m_ZZSE = LPCSTR(_bstr_t(var));
	}
	//价税合计金额
	var = rs->GetCollect("JSHJ");
	if(var.vt != VT_NULL)
	{
		m_JSHJ = LPCSTR(_bstr_t(var));
	}
	//前期借款余额
	var = rs->GetCollect("QQJK");
	if(var.vt != VT_NULL)
	{
		m_QQJK = LPCSTR(_bstr_t(var));
	}
	//前期应付余额
	var = rs->GetCollect("QQYF");
	if(var.vt != VT_NULL)
	{
		m_QQYF = LPCSTR(_bstr_t(var));
	}
	//本次冲帐金额
	var = rs->GetCollect("BCCZ");
	if(var.vt != VT_NULL)
	{
		m_BCCZ = LPCSTR(_bstr_t(var));
	}
	//当前借款余额
	var = rs->GetCollect("DQJK");
	if(var.vt != VT_NULL)
	{
		m_DQJK = LPCSTR(_bstr_t(var));
	}
	//本次付款金额
	var = rs->GetCollect("BCFK");
	if(var.vt != VT_NULL)
	{
		m_BCFK = LPCSTR(_bstr_t(var));
	}
	//当前应付余额
	var = rs->GetCollect("DQYF");
	if(var.vt != VT_NULL)
	{
		m_DQYF = LPCSTR(_bstr_t(var));
	}
	//预算总额
	var = rs->GetCollect("YSZE");
	if(var.vt != VT_NULL)
	{
		m_YSZE = LPCSTR(_bstr_t(var));
	}
	//本年累计执行金额
	var = rs->GetCollect("BNLJ");
	if(var.vt != VT_NULL)
	{
		m_BNLJ = LPCSTR(_bstr_t(var));
	}
	//部门名称
	var = rs->GetCollect("BMMC");
	if(var.vt != VT_NULL)
	{
		//		m_ComboBMMC.AddString(LPCSTR(_bstr_t(var)));
		m_ComboBMMC.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//专业名称
	var = rs->GetCollect("ZYMC");
	if(var.vt != VT_NULL)
	{
		m_ComboZYMC.AddString(LPCSTR(_bstr_t(var)));
		m_ComboZYMC.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//经办人
	var = rs->GetCollect("JBR");
	if(var.vt != VT_NULL)
	{
		//		m_ComboJBR.AddString(LPCSTR(_bstr_t(var)));
		m_ComboJBR.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//经办人名称
	var = rs->GetCollect("JBRMC");
	if(var.vt != VT_NULL)
	{
		m_JBRMC = LPCSTR(_bstr_t(var));
	}
	//制单人
	var = rs->GetCollect("ZDRMC");
	if(var.vt != VT_NULL)
	{
		//		m_ComboZDRMC.AddString(LPCSTR(_bstr_t(var)));
		m_ComboZDRMC.SelectString(0,LPCSTR(_bstr_t(var)));
	}
	//NR1
	var = rs->GetCollect("NR1");
	if(var.vt != VT_NULL)
	{
		m_NR1 = LPCSTR(_bstr_t(var));
	}
	//NR2
	var = rs->GetCollect("NR2");
	if(var.vt != VT_NULL)
	{
		m_NR2 = LPCSTR(_bstr_t(var));
	}
	//NR3
	var = rs->GetCollect("NR3");
	if(var.vt != VT_NULL)
	{
		m_NR3 = LPCSTR(_bstr_t(var));
	}
	
	UpdateData(FALSE);
	return TRUE;  
}

void CSR_FKSQ_Dlg::InitCombo()
{
	_RecordsetPtr rs;
	_variant_t var;
	// 连接数据库
	//SKDW
	rs = encaAdo.GetRecordSet("select * from BH_DW");
	rs->MoveFirst();
	while( !rs->adoEOF )
	{
		var = rs->GetCollect("DW");
		if(var.vt != VT_NULL)
		{
			m_ComboSKDW.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
	//SKR
	rs = encaAdo.GetRecordSet("select * from BH_RM");
	rs->MoveFirst();
	while(!rs->adoEOF)
	{
		var = rs->GetCollect("RM");
		if(var.vt != VT_NULL)
		{
			m_ComboSKR.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
	//SKYH
	rs = encaAdo.GetRecordSet("select * from BH_YH");
	rs->MoveFirst();
	while(!rs->adoEOF)
	{
		var = rs->GetCollect("YH");
		if(var.vt != VT_NULL)
		{
			m_ComboSKYH.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
	//YSKM
	rs = encaAdo.GetRecordSet("select * from BH_KM");
	rs->MoveFirst();
	while(!rs->adoEOF)
	{
		var = rs->GetCollect("KM");
		if(var.vt != VT_NULL)
		{
			m_ComboYSKM.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
	//BMMC
	rs = encaAdo.GetRecordSet("select * from BH_BM");
	rs->MoveFirst();
	while(!rs->adoEOF)
	{
		var = rs->GetCollect("BMMC");
		if(var.vt != VT_NULL)
		{
			m_ComboBMMC.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
	//ZYMC
	rs = encaAdo.GetRecordSet("select * from BH_ZY");
	rs->MoveFirst();
	while(!rs->adoEOF)
	{
		var = rs->GetCollect("ZYMC");
		if(var.vt != VT_NULL)
		{
			m_ComboZYMC.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
	//JBR
	rs = encaAdo.GetRecordSet("select * from BH_RM");
	rs->MoveFirst();
	while(!rs->adoEOF)
	{
		var = rs->GetCollect("RM");
		if(var.vt != VT_NULL)
		{
			m_ComboJBR.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
	//ZDRMC
	rs = encaAdo.GetRecordSet("select * from BH_RM");
	rs->MoveFirst();
	while(!rs->adoEOF)
	{
		var = rs->GetCollect("RMMC");
		if(var.vt != VT_NULL)
		{
			m_ComboZDRMC.AddString(LPCSTR(_bstr_t(var)));
		}
		rs->MoveNext();
	}
}

void CSR_FKSQ_Dlg::OnSelchangeComboSkdw() 
{
	// TODO: Add your control notification handler code here
	//	MessageBox("OnSelchangeComboSkdw");
	
	_RecordsetPtr rs;
	_variant_t var;
	// 连接数据库
	//SKDWMC
	CString str = "select * from BH_DW where DW ='";
	CString temp ;
	m_ComboSKDW.GetWindowText(temp);
	str += temp;
	str += "'";
	
	rs = encaAdo.GetRecordSet(LPCSTR(str));
	var = rs->GetCollect("DWMC");
	if(var.vt != VT_NULL)
	{
		m_SKDWMC = LPCSTR(_bstr_t(var));
	}

	this->GetDlgItem(IDC_STATIC_SKDWMC)->SetWindowText(m_SKDWMC);	
}

void CSR_FKSQ_Dlg::OnSelchangeComboSkr() 
{
	// TODO: Add your control notification handler code here
	//	MessageBox("OnSelchangeComboSkr");
	
	_RecordsetPtr rs;
	_variant_t var;
	// 连接数据库
	//SKRMC
	CString str = "select * from BH_RM where RM ='";
	CString temp ;
	m_ComboSKR.GetWindowText(temp);
	str += temp;
	str += "'";
	
	rs = encaAdo.GetRecordSet(LPCSTR(str));
	var = rs->GetCollect("RMMC");
	if(var.vt != VT_NULL)
	{
		m_SKRMC = LPCSTR(_bstr_t(var));
	}
	this->GetDlgItem(IDC_STATIC_SKRMC)->SetWindowText(m_SKRMC);	
	
}

void CSR_FKSQ_Dlg::OnSelchangeComboYskm() 
{
	// TODO: Add your control notification handler code here
	//	MessageBox("OnSelchangeComboSkdw");
	
	_RecordsetPtr rs;
	_variant_t var;
	// 连接数据库
	//KMMC
	CString str = "select * from BH_KM where KM ='";
	CString temp ;
	m_ComboYSKM.GetWindowText(temp);
	str += temp;
	str += "'";
	
	rs = encaAdo.GetRecordSet(LPCSTR(str));
	var = rs->GetCollect("KMMC");
	if(var.vt != VT_NULL)
	{
		m_YSKMMC = LPCSTR(_bstr_t(var));
	}
	this->GetDlgItem(IDC_STATIC_YSKMMC)->SetWindowText(m_YSKMMC);	
	
}

void CSR_FKSQ_Dlg::OnSelchangeComboJbr() 
{
	// TODO: Add your control notification handler code here
	//	MessageBox("OnSelchangeComboSkdw");
	
	_RecordsetPtr rs;
	_variant_t var;
	// 连接数据库
	//JBRMC
	CString str = "select * from BH_RM where RM ='";
	CString temp ;
	m_ComboJBR.GetWindowText(temp);
	str += temp;
	str += "'";
	
	rs = encaAdo.GetRecordSet(LPCSTR(str));
	var = rs->GetCollect("RMMC");
	if(var.vt != VT_NULL)
	{
		m_JBRMC = LPCSTR(_bstr_t(var));
	}
	this->GetDlgItem(IDC_STATIC_JBRMC)->SetWindowText(m_JBRMC);	
}

void CSR_FKSQ_Dlg::OnBtnQuit() 
{
	// TODO: Add your control notification handler code here
	this->EndDialog(0);
}

void CSR_FKSQ_Dlg::OnKillfocusEditFpjk() 
{
	// TODO: Add your control notification handler code here
/*	UpdateData(TRUE);
	int fpjk = atoi(m_FPJK);
	int zzse = atoi(m_ZZSE);
	int sum = fpjk + zzse;
	CString s;
	s.Format("%d",sum);
	this->GetDlgItem(IDC_EDIT_JE_JSHJ)->SetWindowText(s);	
*/
	UpdateData(TRUE);
	int fpjk = atoi(m_FPJK);
	int jshj = atoi(m_JSHJ);
	int sum = jshj - fpjk;
	CString s;
	s.Format("%d",sum);
	this->GetDlgItem(IDC_EDIT_ZZSE)->SetWindowText(s);	

}

void CSR_FKSQ_Dlg::OnKillfocusEditZzse() 
{
/*	UpdateData(TRUE);
	int fpjk = atoi(m_FPJK);
	int zzse = atoi(m_ZZSE);
	int sum = fpjk + zzse;
	CString s;
	s.Format("%d",sum);
	this->GetDlgItem(IDC_EDIT_JE_JSHJ)->SetWindowText(s);	
*/
}



void CSR_FKSQ_Dlg::OnKillfocusEditJeJshj() 
{
	UpdateData(TRUE);
	int fpjk = atoi(m_FPJK);
	int jshj = atoi(m_JSHJ);
	int sum = jshj - fpjk;
	CString s;
	s.Format("%d",sum);
	this->GetDlgItem(IDC_EDIT_ZZSE)->SetWindowText(s);	

}