editstuff.cpp

主要用在管理系统,一个工程维护管理用vc++ 8.0 accesss数据库

// EditStuff.cpp : 实现文件
//

#include "stdafx.h"
#include "ProjectManage.h"
#include "EditStuff.h"
#include "User.h"
#include "ADODB.h"

// CEditStuff 对话框

IMPLEMENT_DYNAMIC(CEditStuff, CDialog)

CEditStuff::CEditStuff(CWnd* pParent /*=NULL*/)
	: CDialog(CEditStuff::IDD, pParent)
{

}

CEditStuff::~CEditStuff()
{
}

void CEditStuff::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}


BEGIN_MESSAGE_MAP(CEditStuff, CDialog)
	ON_BN_CLICKED(IDC_BUTTON1, &CEditStuff::OnBnClickedButton1)
	ON_BN_CLICKED(IDC_BUTTON3, &CEditStuff::OnBnClickedButton3)
	ON_BN_CLICKED(IDC_BUTTON2, &CEditStuff::OnBnClickedButton2)
END_MESSAGE_MAP()


// CEditStuff 消息处理程序

void CEditStuff::OnBnClickedButton1()
{
	// TODO: 在此添加控件通知处理程序代码
    CString Sql;
	CString StuffName,uint,number,price,totalcost,storsCode,type,desc,omtname;

	CEdit* stuffBox=(CEdit*)this->GetDlgItem(IDC_EDIT2);
	stuffBox->GetWindowTextA(StuffName);

	CEdit* omtBox=(CEdit*)this->GetDlgItem(IDC_EDIT9);
	omtBox->GetWindowTextA(omtname);
    
	CComboBox* uintfBox=(CComboBox*)this->GetDlgItem(IDC_COMBO1);
	uintfBox->GetWindowTextA(uint);

	CEdit* numberBox=(CEdit*)this->GetDlgItem(IDC_EDIT4);
	numberBox->GetWindowTextA(number);

	CEdit* priceBox=(CEdit*)this->GetDlgItem(IDC_EDIT5);
	priceBox->GetWindowTextA(price);

	CEdit* totalcostBox=(CEdit*)this->GetDlgItem(IDC_EDIT6);
	totalcostBox->GetWindowTextA(totalcost);

	CEdit* codeBox=(CEdit*)this->GetDlgItem(IDC_EDIT3);
	codeBox->GetWindowTextA(storsCode);

	CEdit* typeBox=(CEdit*)this->GetDlgItem(IDC_EDIT8);
	typeBox->GetWindowTextA(type);

	CEdit* descBox=(CEdit*)this->GetDlgItem(IDC_EDIT7);
	descBox->GetWindowTextA(desc);
    try
	{
		Sql="insert into StuffBill(StuffName,StoresCode,SpecModel,Uint,Stuffnum,StuffCost,TotalCost,StuffDesc,ProjID,omtname)" 
		"values('"+StuffName+"','"+storsCode+"','"+type+"','"+uint+"',"+number+","+price+","+totalcost+",'"+desc+"',"+theApp.ProjID+",'"+omtname+"')";
		if(this->m_Storage.ExecSql(Sql))
		{
			 AfxMessageBox("添加成功！");
		}
	}
	catch(_com_error e)
	{
	     MessageBox("添加失败，请检查数据格式");
	}

}

BOOL CEditStuff::OnInitDialog()
{
	CDialog::OnInitDialog();

	// TODO:  在此添加额外的初始化
    CEdit* cPname=(CEdit*)this->GetDlgItem(IDC_EDIT1);
    cPname->SetWindowTextA(theApp.ProjName);
	if(SList!=NULL)
	{
		CString StuffName,uint,number,price,totalcost,storsCode,type,desc,omtname;

		CEdit* stuffBox=(CEdit*)this->GetDlgItem(IDC_EDIT2);
		stuffBox->SetWindowTextA(SList[1]);
	    
		CComboBox* uintfBox=(CComboBox*)this->GetDlgItem(IDC_COMBO1);
		uintfBox->SetWindowTextA(SList[4]);

		CEdit* numberBox=(CEdit*)this->GetDlgItem(IDC_EDIT4);
		numberBox->SetWindowTextA(SList[5]);

		CEdit* priceBox=(CEdit*)this->GetDlgItem(IDC_EDIT5);
		priceBox->SetWindowTextA(SList[6]);

		CEdit* totalcostBox=(CEdit*)this->GetDlgItem(IDC_EDIT6);
		totalcostBox->SetWindowTextA(SList[7]);

		CEdit* codeBox=(CEdit*)this->GetDlgItem(IDC_EDIT3);
		codeBox->SetWindowTextA(SList[2]);

		CEdit* typeBox=(CEdit*)this->GetDlgItem(IDC_EDIT8);
		typeBox->SetWindowTextA(SList[3]);

		CEdit* descBox=(CEdit*)this->GetDlgItem(IDC_EDIT7);
		descBox->SetWindowTextA(SList[8]);

		CEdit* omtBox=(CEdit*)this->GetDlgItem(IDC_EDIT9);
		omtBox->SetWindowTextA(SList[10]);
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}


void CEditStuff::OnBnClickedButton3()
{
	// TODO: 在此添加控件通知处理程序代码
	CString sql;
	sql="delete from StuffBill where id="+SList[0];
	if(MessageBox(_T("真的要删除吗?"),_T("删除询问"),MB_OKCANCEL|MB_ICONQUESTION)==IDOK)
	{
		if(this->m_Storage.ExecSql(sql))
		{
			AfxMessageBox("删除成功！");
			this->OnCancel();
		}
	}
}

void CEditStuff::OnBnClickedButton2()
{
	// TODO: 在此添加控件通知处理程序代码
	CString Sql;
	CString StuffName,uint,number,price,totalcost,storsCode,type,desc,omtname;

	CEdit* stuffBox=(CEdit*)this->GetDlgItem(IDC_EDIT2);
	stuffBox->GetWindowTextA(StuffName);

	CEdit* omtBox=(CEdit*)this->GetDlgItem(IDC_EDIT9);
	omtBox->GetWindowTextA(omtname);
    
	CComboBox* uintfBox=(CComboBox*)this->GetDlgItem(IDC_COMBO1);
	uintfBox->GetWindowTextA(uint);

	CEdit* numberBox=(CEdit*)this->GetDlgItem(IDC_EDIT4);
	numberBox->GetWindowTextA(number);

	CEdit* priceBox=(CEdit*)this->GetDlgItem(IDC_EDIT5);
	priceBox->GetWindowTextA(price);

	CEdit* totalcostBox=(CEdit*)this->GetDlgItem(IDC_EDIT6);
	totalcostBox->GetWindowTextA(totalcost);

	CEdit* codeBox=(CEdit*)this->GetDlgItem(IDC_EDIT3);
	codeBox->GetWindowTextA(storsCode);

	CEdit* typeBox=(CEdit*)this->GetDlgItem(IDC_EDIT8);
	typeBox->GetWindowTextA(type);

	CEdit* descBox=(CEdit*)this->GetDlgItem(IDC_EDIT7);
	descBox->GetWindowTextA(desc);
    try
	{
		Sql="update StuffBill  set StuffName='"+StuffName+"',StoresCode='"+storsCode+"',SpecModel='"+type+"',Uint='"+uint+"',Stuffnum="+number+",StuffCost="+price+",TotalCost="+totalcost+",StuffDesc='"+desc+"',ProjID="+theApp.ProjID+",omtname='"+omtname+"'where id="+ SList[0];
		
		if(this->m_Storage.ExecSql(Sql))
		{
			 AfxMessageBox("修改成功！");
		}
	}
	catch(_com_error e)
	{
	     MessageBox("修改失败，请检查数据格式");
	}
}