sr_fksq_dlg.cpp

用C++写的数据库软件

// SR_FKSQ_Dlg.cpp : implementation file
//

#include "stdafx.h"
#include "FKSQXT.h"
#include "SR_FKSQ_Dlg.h"

#include "string.h"
#include "ShowStringDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSR_FKSQ_Dlg dialog


CSR_FKSQ_Dlg::CSR_FKSQ_Dlg(CWnd* pParent /*=NULL*/)
: CDialog(CSR_FKSQ_Dlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSR_FKSQ_Dlg)
	m_FPJK = _T("");
	m_HTBH = _T("");
	m_HTJE = _T("");
	m_BCCZ = _T("");
	m_BCFK = _T("");
	m_BNLJ = _T("");
	m_DQJK = _T("");
	m_JSHJ = _T("");
	m_QQJK = _T("");
	m_QQYF = _T("");
	m_YSZE = _T("");
	m_SY = _T("");
	m_YHZH = _T("");
	m_ZZSE = _T("");
	m_NYR = _T("2008-12-13");
	m_JBRMC = _T("");
	m_NR1 = _T("");
	m_NR2 = _T("");
	m_NR3 = _T("");
	m_SKDWMC = _T("");
	m_SKRMC = _T("");
	m_YSKMMC = _T("");
	m_DJBH = _T("");
	m_DQYF = _T("");
	m_SPZT = _T("");
	m_comboSPZT = 3;
	//}}AFX_DATA_INIT
	m_strDJBH = "";
}


void CSR_FKSQ_Dlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSR_FKSQ_Dlg)
	DDX_Control(pDX, IDC_COMBO_BMMC, m_ComboBMMC);
	DDX_Control(pDX, IDC_COMBO_ZYMC, m_ComboZYMC);
	DDX_Control(pDX, IDC_COMBO_ZDRMC, m_ComboZDRMC);
	DDX_Control(pDX, IDC_COMBO_YSKM, m_ComboYSKM);
	DDX_Control(pDX, IDC_COMBO_SKYH, m_ComboSKYH);
	DDX_Control(pDX, IDC_COMBO_SKR, m_ComboSKR);
	DDX_Control(pDX, IDC_COMBO_SKDW, m_ComboSKDW);
	DDX_Control(pDX, IDC_COMBO_JBR, m_ComboJBR);
	DDX_Text(pDX, IDC_EDIT_FPJK, m_FPJK);
	DDX_Text(pDX, IDC_EDIT_HTBH, m_HTBH);
	DDX_Text(pDX, IDC_EDIT_HTJE, m_HTJE);
	DDX_Text(pDX, IDC_EDIT_JE_BCCZ, m_BCCZ);
	DDX_Text(pDX, IDC_EDIT_JE_BCFK, m_BCFK);
	DDX_Text(pDX, IDC_EDIT_JE_BNLJ, m_BNLJ);
	DDX_Text(pDX, IDC_EDIT_JE_DQJK, m_DQJK);
	DDX_Text(pDX, IDC_EDIT_JE_JSHJ, m_JSHJ);
	DDX_Text(pDX, IDC_EDIT_JE_QQJK, m_QQJK);
	DDX_Text(pDX, IDC_EDIT_JE_QQYF, m_QQYF);
	DDX_Text(pDX, IDC_EDIT_JE_YSZE, m_YSZE);
	DDX_Text(pDX, IDC_EDIT_SY, m_SY);
	DDX_Text(pDX, IDC_EDIT_YHZH, m_YHZH);
	DDX_Text(pDX, IDC_EDIT_ZZSE, m_ZZSE);
	DDX_Text(pDX, IDC_NYR, m_NYR);
	DDX_Text(pDX, IDC_STATIC_JBRMC, m_JBRMC);
	DDX_Text(pDX, IDC_STATIC_NR1, m_NR1);
	DDX_Text(pDX, IDC_STATIC_NR2, m_NR2);
	DDX_Text(pDX, IDC_STATIC_NR3, m_NR3);
	DDX_Text(pDX, IDC_STATIC_SKDWMC, m_SKDWMC);
	DDX_Text(pDX, IDC_STATIC_SKRMC, m_SKRMC);
	DDX_Text(pDX, IDC_STATIC_YSKMMC, m_YSKMMC);
	DDX_Text(pDX, IDC_DJBH, m_DJBH);
	DDX_Text(pDX, IDC_EDIT_JE_DQYF, m_DQYF);
	DDX_Text(pDX, IDC_SPZT, m_SPZT);
	DDX_CBIndex(pDX, IDC_COMBO_SPZT, m_comboSPZT);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSR_FKSQ_Dlg, CDialog)
//{{AFX_MSG_MAP(CSR_FKSQ_Dlg)
ON_BN_CLICKED(IDC_BTN_SUBMIT, OnBtnSubmit)
ON_BN_CLICKED(IDC_BTN_SAVE, OnBtnSave)
ON_CBN_SELCHANGE(IDC_COMBO_SKDW, OnSelchangeComboSkdw)
ON_CBN_SELCHANGE(IDC_COMBO_SKR, OnSelchangeComboSkr)
ON_CBN_SELCHANGE(IDC_COMBO_YSKM, OnSelchangeComboYskm)
ON_CBN_SELCHANGE(IDC_COMBO_JBR, OnSelchangeComboJbr)
	ON_BN_CLICKED(IDC_BTN_QUIT, OnBtnQuit)
	ON_EN_KILLFOCUS(IDC_EDIT_FPJK, OnKillfocusEditFpjk)
	ON_EN_KILLFOCUS(IDC_EDIT_ZZSE, OnKillfocusEditZzse)
	ON_EN_KILLFOCUS(IDC_EDIT_JE_JSHJ, OnKillfocusEditJeJshj)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSR_FKSQ_Dlg message handlers

void CSR_FKSQ_Dlg::OnBtnSubmit() 
{
	UpdateData(TRUE);
	CString temp;
	// 连接数据库
	CString str;
	if(m_strDJBH != "")
	{
		str = "update FKSQD set";
		//收款单位
/*		if(SKDW == "")
		{
			MessageBox("收款单位 不能为空");
			return;
		}
*/		str += " SKDW = '";
		m_ComboSKDW.GetWindowText(temp);
		str += temp;
		str += "'";
		//收款单位名
		str += ", SKDWMC = '";
		str += m_SKDWMC ;
		str += "'";
		//收款人
/*		if(SKR == "")
		{
			MessageBox("收款人 不能为空");
			return;
		}
*/		str += ", SKR = '";
		m_ComboSKR.GetWindowText(temp);
		str += temp;
		str += "'";
		//收款人名称
		str += ", SKRMC = '";
		str += m_SKRMC ;
		str += "'";
		//收款银行
/*		if(SKYH == "")
		{
			MessageBox("收款银行 不能为空");
			return;
		}
*/		str += ", SKYH = '";
		m_ComboSKYH.GetWindowText(temp);
		str += temp;
		str += "'";
		//收款账号
		if(m_YHZH == "")
		{
			MessageBox("收款账号 不能为空");
			return;
		}
		str += ", SKZH = '";
		str += m_YHZH ;
		str += "'";
		//事由
		if(m_SY == "")
		{
			MessageBox("事由 不能为空");
			return;
		}
		str += ", SY = '";
		str += m_SY ;
		str += "'";
		//合同编号
		if(m_HTBH == "")
		{
			MessageBox("合同编号 不能为空");
			return;
		}
		str += ", HTBH = '";
		str += m_HTBH ;
		str += "'";
		//合同金额
		if(m_HTJE == "")
		{
			MessageBox("合同金额 不能为空");
			return;
		}
		str += ", HTJE = '";
		str += m_HTJE ;
		str += "'";
		//预算科目
/*		if(YSKM == "")
		{
			MessageBox("预算科目 不能为空");
			return;
		}
*/		str += ", YSKM = '";
		m_ComboYSKM.GetWindowText(temp);
		str += temp;
		str += "'";
		//预算科目名称
		str += ", YSKMMC = '";
		str += m_YSKMMC ;
		str += "'";
		//发票价款
		str += ", FPJK = '";
		if(m_FPJK != "")
		{
			str += m_FPJK ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//增值税额
		str += ", ZZSE = '";	
		if(m_ZZSE != "")
		{
			str += m_ZZSE ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//价税合计金额
		str += ", JSHJ = '";
		if(m_JSHJ != "")
		{
			str += m_JSHJ ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//前期借款余额
		str += ", QQJK = '";
		if(m_QQJK != "")
		{
			str += m_QQJK ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//前期应付余额
		str += ", QQYF = '";
		if(m_QQYF != "")
		{
			str += m_QQYF ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//本次冲帐金额
		str += ", BCCZ = '";
		if(m_BCCZ != "")
		{
			str += m_BCCZ ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//当前借款余额
		str += ", DQJK = '";
		if(m_DQJK != "")
		{
			str += m_DQJK ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//本次付款金额
		str += ", BCFK = '";
		if(m_BCFK != "")
		{
			str += m_BCFK ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//当前应付余额
		str += ", DQYF = '";
		if(m_DQYF != "")
		{
			str += m_DQYF ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//预算总额
		str += ", YSZE = '";
		if(m_YSZE != "")
		{
			str += m_YSZE ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//本年累计执行金额
		str += ", BNLJ = '";
		if(m_BNLJ != "")
		{
			str += m_BNLJ ;
		}
		else
		{
			str += "0";
		}
		str += "'";
		//部门名称
		str += ", BMMC = '";
		m_ComboBMMC.GetWindowText(temp);
		str += temp;
		str += "'";
		//专业名称
		str += ", ZYMC = '";
		m_ComboZYMC.GetWindowText(temp);
		str += temp;
		str += "'";
		//经办人
		str += ", JBR = '";
		m_ComboJBR.GetWindowText(temp);
		str += temp;
		str += "'";
		//经办人名称
		str += ", JBRMC = '";
		str += m_JBRMC ;
		str += "'";
		//制单人
		str += ", ZDRMC = '";
		m_ComboZDRMC.GetWindowText(temp);
		str += temp;
		str += "'";
		//NR1
		str += ", NR1 = '";
		str += m_NR1 ;
		str += "'";
		//NR2
		str += ", NR2 = '";
		str += m_NR2 ;
		str += "'";
		//NR3
		str += ", NR3 = '";
		str += m_NR3 ;
		str += "'";
		//NR4
		//NR5
		//NR6
		//NR7
		//SPZT 
		str += ",SPZT = '";
//		待审/审批中/通过/驳回
		switch(m_comboSPZT)
		{
		case 0:
			str += "待审";
			break;
		case 1:
			str += "审批中";
			break;
		case 2:
			str += "通过";
			break;
		case 3:
			str += "驳回";
			break;
		default:
			break;
		}
		str+= "'";
		//end
		str += " where DJBH = '" ;
		CString djbh = m_DJBH;
		djbh = djbh.Mid(3);
		str += djbh; ;
		str += "'";
//		CShowStringDlg SSDlg;
//		SSDlg.SetString(str);
//		SSDlg.DoModal();

		if(encaAdo.ExecuteSQL(LPCSTR(str)))
		{
			MessageBox("提交成功！");
		}
		else
		{
			MessageBox("提交失败！");
		}
	}
	else
	{
		CString str1,str2;
		str1 = "insert into FKSQD (";
		str2 = "values(";
		//FKSQDBH
		str1 += " FKSQD ,";
		str2 += " '0101','";
		//FKSQDMC
		str1 += " FKSQDMC ,";
		str2 += " 付款申请单','";
		//单据编号
		CString djbh = m_DJBH;
		djbh = djbh.Mid(3);

		str1 += " DJBH , ";
		str2 += djbh;
		str2 += "','";
		//收款单位
		str1 += " SKDW , ";
		m_ComboSKDW.GetWindowText(temp);
		str2 += temp;
		str2 += "','";
		//收款单位名
		str1 += " SKDWMC , ";
		str2 += m_SKDWMC ;
		str2 += "','";
		//收款人
		str1 += " SKR , ";
		m_ComboSKR.GetWindowText(temp);
		str2 += temp;
		str2 += "','";
		//收款人名称
		str1 += " SKRMC , ";
		str2 += m_SKRMC ;
		str2 += "','";
		//收款银行
		str1 += " SKYH , ";
		m_ComboSKYH.GetWindowText(temp);
		str2 += temp;
		str2 += "','";
		//收款账号
		str1 += " SKZH , ";
		str2 += m_YHZH ;
		str2 += "','";
		//事由
		str1 += " SY , ";
		str2 += m_SY ;
		str2 += "','";
		//合同编号
		str1 += " HTBH , ";
		str2 += m_HTBH ;
		str2 += "','";
		//合同金额
		str1 += " HTJE , ";
		str2 += m_HTJE ;
		str2 += "','";
		//预算科目
		str1 += " YSKM , ";
		m_ComboYSKM.GetWindowText(temp);
		str2 += temp;
		str2 += "','";
		//预算科目名称
		str1 += " YSKMMC , ";
		str2 += m_YSKMMC ;
		str2 += "','";
		//发票价款
		str1 += " FPJK , ";
		str2 += m_FPJK ;
		str2 += "','";
		//增值税额
		str1 += " ZZSE , ";
		str2 += m_ZZSE ;
		str2 += "','";
		//价税合计金额
		str1 += " JSHJ , ";
		str2 += m_JSHJ ;
		str2 += "','";
		//前期借款余额
		str1 += " QQJK , ";
		str2 += m_QQJK ;
		str2 += "','";
		//前期应付余额
		str1 += " QQYF , ";
		str2 += m_QQYF ;
		str2 += "','";
		//本次冲帐金额
		str1 += " BCCZ , ";
		str2 += m_BCCZ ;
		str2 += "','";
		//当前借款余额
		str1 += " DQJK , ";
		str2 += m_DQJK ;
		str2 += "','";
		//本次付款金额
		str1 += " BCFK , ";
		str2 += m_BCFK ;
		str2 += "','";
		//当前应付余额
		str1 += " DQYF , ";
		str2 += m_DQYF ;
		str2 += "','";
		//预算总额
		str1 += " YSZE , ";
		str2 += m_YSZE ;
		str2 += "','";
		//本年累计执行金额
		str1 += " BNLJ , ";
		str2 += m_BNLJ ;
		str2 += "','";
		//部门名称
		str1 += " BMMC , ";
		m_ComboBMMC.GetWindowText(temp);
		str2 += temp;
		str2 += "','";
		//专业名称
		str1 += " ZYMC , ";
		m_ComboZYMC.GetWindowText(temp);
		str2 += temp;
		str2 += "','";
		//经办人
		str1 += " JBR , ";
		m_ComboJBR.GetWindowText(temp);
		str2 += temp;