📄 dlgcancelin.cpp

📁 连接SQL数据库的系统源码,对于初学者十分有参考价值哦
💻 CPP
字号:
// DlgCancelin.cpp : implementation file
//

#include "stdafx.h"
#include "merchandisestore.h"
#include "DlgCancelin.h"

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

#include "Database.h"
//-------------global 
extern CDatabase m_hDatabase ;
//------------end
/////////////////////////////////////////////////////////////////////////////
// CDlgCancelin dialog


CDlgCancelin::CDlgCancelin(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgCancelin::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgCancelin)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDlgCancelin::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgCancelin)
	DDX_Control(pDX, IDC_TAB_Cancelin, m_hTabCancelin);
	DDX_Control(pDX, IDC_LIST_Cancelin, m_hListCancelin);
	DDX_Control(pDX, IDC_EDIT_unitprice, m_hEditunitprice);
	DDX_Control(pDX, IDC_EDIT_SumTotal, m_hEditSumTotal);
	DDX_Control(pDX, IDC_EDIT_Rebate, m_hEditRebate);
	DDX_Control(pDX, IDC_EDIT_providerid, m_hEditProviderid);
	DDX_Control(pDX, IDC_EDIT_principal, m_hEditprincipal);
	DDX_Control(pDX, IDC_EDIT_Paymoney, m_hEditPaymoney);
	DDX_Control(pDX, IDC_EDIT_Operator, m_hEditOperator);
	DDX_Control(pDX, IDC_EDIT_merchandiseID, m_hEditmerchandiseID);
	DDX_Control(pDX, IDC_EDIT_Factmoney, m_hEditFactmoney);
	DDX_Control(pDX, IDC_EDIT_Cancelnum, m_hEditCancelnum);
	DDX_Control(pDX, IDC_EDIT_CancelID, m_hEditCancelID);
	DDX_Control(pDX, IDC_DTP_CancelTime, m_hDtpCancelTime);
	DDX_Control(pDX, IDOK, m_hBtnOk);
	DDX_Control(pDX, IDC_BTN_SAVE, m_hBtnSave);
	DDX_Control(pDX, IDC_BTN_MOD, m_hBtnMod);
	DDX_Control(pDX, IDC_BTN_DEL, m_hBtnDel);
	DDX_Control(pDX, IDC_BTN_ADD, m_hBtnAdd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgCancelin, CDialog)
	//{{AFX_MSG_MAP(CDlgCancelin)
	ON_NOTIFY(NM_CLICK, IDC_LIST_Cancelin, OnClickLISTCancelin)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST_Cancelin, OnDblclkLISTCancelin)
	ON_NOTIFY(TCN_SELCHANGE, IDC_TAB_Cancelin, OnSelchangeTABCancelin)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDC_BTN_MOD, OnBtnMod)
	ON_BN_CLICKED(IDC_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDC_BTN_SAVE, OnBtnSave)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgCancelin message handlers

BOOL CDlgCancelin::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here

	InitCtrlData() ;
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgCancelin::OnClickLISTCancelin(NMHDR* pNMHDR, LRESULT* pResult) 
{
	char m_szCancelID[30+1] ;
	m_hListCancelin.GetItemText(m_hListCancelin.GetSelectionMark(), 0, m_szCancelID, sizeof(m_szCancelID)) ;
	

	m_hDatabase.EditCancelinToCtrl(m_szCancelID, &m_hEditunitprice,&m_hEditSumTotal,&m_hEditRebate,&m_hEditProviderid,&m_hEditprincipal,&m_hEditPaymoney,&m_hEditOperator,&m_hEditmerchandiseID,&m_hEditFactmoney,&m_hEditCancelnum,&m_hEditCancelID) ;
	*pResult = 0;
}

void CDlgCancelin::OnDblclkLISTCancelin(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	TabCtrlOfSelect(0) ;
	
	*pResult = 0;
}

void CDlgCancelin::OnSelchangeTABCancelin(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	
	switch(m_hTabCancelin.GetCurSel())
	{
	case 0:
		{
			TabCtrlOfSelect(0) ;
			break ;
		}
	case 1:
		{			
			TabCtrlOfSelect(1) ;
			break ;
		}
	}
	*pResult = 0;
}

void CDlgCancelin::InitCtrlData()
{
///INIT BUTTON CTRL
	m_hBtnOk.SetIcon(IDI_ICON_CLOSE);
	m_hBtnOk.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnOk.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

	m_hBtnSave.SetIcon(IDI_ICON_OK);
	m_hBtnSave.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnSave.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));
	m_hBtnSave.EnableWindow(FALSE) ;

	m_hBtnDel.SetIcon(IDI_ICON_DEL);
	m_hBtnDel.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnDel.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

	m_hBtnAdd.SetIcon(IDI_ICON_ADD);
	m_hBtnAdd.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnAdd.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

	m_hBtnMod.SetIcon(IDI_ICON_MOD);
	m_hBtnMod.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnMod.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

//Init tab ctrl 
	m_hTabCancelin.InsertItem(0, "入库退货基本信息") ;
	m_hTabCancelin.InsertItem(1, "入库退货信息列表") ;
	m_hTabCancelin.ShowWindow(TRUE) ;

	m_hListCancelin.InsertColumn(0, "退货单号", LVCFMT_CENTER, 80) ;
	m_hListCancelin.InsertColumn(1, "供应当编号", LVCFMT_CENTER, 50) ;
	m_hListCancelin.InsertColumn(2, "操作员", LVCFMT_CENTER, 50) ;
	m_hListCancelin.InsertColumn(3, "负责人", LVCFMT_CENTER, 60) ;
	m_hListCancelin.InsertColumn(4, "折扣", LVCFMT_CENTER, 100) ;
	m_hListCancelin.InsertColumn(5, "总计", LVCFMT_CENTER, 120) ;
	m_hListCancelin.InsertColumn(6, "应退金额", LVCFMT_CENTER, 100) ;
	m_hListCancelin.InsertColumn(7, "实退金额", LVCFMT_CENTER, 100) ;
	m_hListCancelin.InsertColumn(8, "退货时间", LVCFMT_CENTER, 100) ;
	m_hListCancelin.InsertColumn(9, "商品编号", LVCFMT_CENTER, 100) ;
	m_hListCancelin.InsertColumn(10, "价格", LVCFMT_CENTER, 100) ;
	m_hListCancelin.InsertColumn(11, "数量", LVCFMT_CENTER, 100) ;
	m_hListCancelin.SetExtendedStyle(m_hListCancelin.GetStyle() | LVS_EX_FULLROWSELECT);
//
	TabCtrlOfSelect(1) ;
}

void CDlgCancelin::TabCtrlOfSelect(int m_nSelected)
{
	switch(m_nSelected)
	{
	case 0:
		{
			m_hTabCancelin.SetCurSel(0) ;
		//---
			m_hEditunitprice.ShowWindow(TRUE) ;
			m_hEditSumTotal.ShowWindow(TRUE) ;
			m_hEditRebate.ShowWindow(TRUE) ;
			m_hEditProviderid.ShowWindow(TRUE) ;
			m_hEditprincipal.ShowWindow(TRUE) ;
			m_hEditPaymoney.ShowWindow(TRUE) ;
			m_hEditOperator.ShowWindow(TRUE) ;
			m_hEditmerchandiseID.ShowWindow(TRUE) ;
			m_hEditFactmoney.ShowWindow(TRUE) ;
			m_hEditCancelnum.ShowWindow(TRUE) ;
			m_hEditCancelID.ShowWindow(TRUE) ;
			m_hDtpCancelTime.ShowWindow(TRUE) ;
			
			m_hListCancelin.ShowWindow(FALSE) ;
			m_hEditCancelID.SetFocus() ;
			break ;
		}
	case 1:
		{
			m_hTabCancelin.SetCurSel(1) ;
			//-----
			m_hEditunitprice.ShowWindow(FALSE) ;
			m_hEditSumTotal.ShowWindow(FALSE) ;
			m_hEditRebate.ShowWindow(FALSE) ;
			m_hEditProviderid.ShowWindow(FALSE) ;
			m_hEditprincipal.ShowWindow(FALSE) ;
			m_hEditPaymoney.ShowWindow(FALSE) ;
			m_hEditOperator.ShowWindow(FALSE) ;
			m_hEditmerchandiseID.ShowWindow(FALSE) ;
			m_hEditFactmoney.ShowWindow(FALSE) ;
			m_hEditCancelnum.ShowWindow(FALSE) ;
			m_hEditCancelID.ShowWindow(FALSE) ;
			m_hDtpCancelTime.ShowWindow(FALSE) ;
			
			m_hListCancelin.ShowWindow(TRUE) ;

			break ;
		}
	}
	m_hDatabase.ListCancelinToCtrl(&m_hListCancelin) ;
}

void CDlgCancelin::OnBtnAdd() 
{
	// TODO: Add your control notification handler code here
	switch(m_hTabCancelin.GetCurSel())
	{
	case 0:
		{
			break ;
		}
	case 1:
		{
			TabCtrlOfSelect(0) ;
			break ;
		}
	}
	m_hEditunitprice.SetWindowText("") ;
	m_hEditSumTotal.SetWindowText("") ;
	m_hEditRebate.SetWindowText("") ;
	m_hEditProviderid.SetWindowText("") ;
	m_hEditprincipal.SetWindowText("") ;
	m_hEditPaymoney.SetWindowText("") ;
	m_hEditOperator.SetWindowText("") ;
	m_hEditmerchandiseID.SetWindowText("") ;
	m_hEditFactmoney.SetWindowText("") ;
	m_hEditCancelnum.SetWindowText("") ;
	m_hEditCancelID.SetWindowText("") ;

	m_hBtnSave.EnableWindow() ;
	m_hEditCancelID.SetFocus() ;
}

void CDlgCancelin::OnBtnMod() 
{
	// TODO: Add your control notification handler code here
	switch(m_hTabCancelin.GetCurSel())
	{
	case 0:
		{
			break ;
		}
	case 1:
		{
			if(m_hListCancelin.GetSelectionMark() == -1)
			{//未被选中
				MessageBox("请选择欲修改条目!") ;
				return ;
			}
			break ;
		}
	}
	TabCtrlOfSelect(0) ;
	m_hBtnSave.EnableWindow() ;
	m_hEditCancelID.SetFocus() ;
}

void CDlgCancelin::OnBtnDel() 
{
	// TODO: Add your control notification handler code here
	if(m_hListCancelin.GetSelectionMark() == -1)
	{//未被选中
		MessageBox("请选择欲删除条目!") ;
		return ;
	}
	char m_szCancelID[30+1] ;
	m_hListCancelin.GetItemText(m_hListCancelin.GetSelectionMark(), 0, m_szCancelID, sizeof(m_szCancelID)) ;
	m_hDatabase.DeleteDataWhere(RKTH, m_szCancelID) ;
	m_hDatabase.ListCancelinToCtrl(&m_hListCancelin) ;
}

void CDlgCancelin::OnBtnSave() 
{
	// TODO: Add your control notification handler code here
	char unitprice[30+1], SumTotal[30+1], Rebate[10+1], Providerid[30+1], 
		principal[30+1], Paymoney[10+1], Operator[30+1],
		merchandiseID[30+1],Factmoney[50+1],Cancelnum[30+1],
		CancelID[30+1];

	m_hEditunitprice.GetWindowText(unitprice, sizeof(unitprice)) ;
	m_hEditSumTotal.GetWindowText(SumTotal, sizeof(SumTotal)) ;
	m_hEditRebate.GetWindowText(Rebate, sizeof(Rebate)) ;
	m_hEditProviderid.GetWindowText(Providerid, sizeof(Providerid)) ;
	m_hEditprincipal.GetWindowText(principal, sizeof(principal)) ;
	m_hEditPaymoney.GetWindowText(Paymoney, sizeof(Paymoney)) ;
	m_hEditOperator.GetWindowText(Operator, sizeof(Operator)) ;
	m_hEditmerchandiseID.GetWindowText(merchandiseID, sizeof(merchandiseID)) ;
	m_hEditFactmoney.GetWindowText(Factmoney, sizeof(Factmoney)) ;
	m_hEditCancelnum.GetWindowText(Cancelnum, sizeof(Cancelnum)) ;
	m_hEditCancelID.GetWindowText(CancelID, sizeof(CancelID)) ;
	//保存修改,更新数据库
	m_hDatabase.UpdateCalcelinData(unitprice, SumTotal, Rebate, Providerid, 
		principal, Paymoney, Operator,merchandiseID,Factmoney,Cancelnum,CancelID) ;

	m_hBtnSave.EnableWindow(FALSE) ;
}
⌨️ 快捷键说明

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