// DlgXiaoShouTuiDan.cpp : implementation file
//

#include "stdafx.h"
#include "ncshop.h"
#include "DlgXiaoShouTuiDan.h"
#include "ADOConn.h"
#include "MyTime.h"
#include "DlgAll.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDlgXiaoShouTuiDan dialog


CDlgXiaoShouTuiDan::CDlgXiaoShouTuiDan(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgXiaoShouTuiDan::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgXiaoShouTuiDan)
	m_str1 = _T("");
	m_str2 = _T("");
	m_str3 = _T("");
	m_str4 = _T("");
	m_str5 = _T("");
	//}}AFX_DATA_INIT
}


void CDlgXiaoShouTuiDan::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgXiaoShouTuiDan)
	DDX_Control(pDX, IDC_BUTTON7, m_Btn7);
	DDX_Control(pDX, IDC_LIST1, m_listMain);
	DDX_Control(pDX, IDC_BUTTON6, m_Btn2);
	DDX_Control(pDX, IDCANCEL, m_Btn4);
	DDX_Control(pDX, IDC_BUTTON1, m_Btn3);
	DDX_Control(pDX, IDC_BUTTON2, m_Btn1);
	DDX_Text(pDX, IDC_EDIT1, m_str1);
	DDX_Text(pDX, IDC_EDIT2, m_str2);
	DDX_Text(pDX, IDC_EDIT3, m_str3);
	DDX_Text(pDX, IDC_EDIT5, m_str4);
	DDX_Text(pDX, IDC_EDIT4, m_str5);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgXiaoShouTuiDan, CDialog)
	//{{AFX_MSG_MAP(CDlgXiaoShouTuiDan)
	ON_BN_CLICKED(IDC_BUTTON6, OnButton6)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON7, OnButton7)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgXiaoShouTuiDan message handlers

BOOL CDlgXiaoShouTuiDan::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CMyTime time1;
	CADOConn adoMain;
	CString strSql;
	GetDlgItem(IDC_STATIC1)->SetFont(&ftHeader,TRUE);
	m_Btn1.SetXIcon(IDI_ICONFIND);
	m_Btn2.SetXIcon(IDI_ICONFIND);
	m_Btn3.SetXIcon(IDI_ICONBUTTON);
	m_Btn4.SetXIcon(IDI_ICONBUTTON);
	m_Btn7.SetXIcon(IDI_ICONFIND);
	m_str2=time1.GetDateString(FALSE);
	UpdateData(FALSE);
	strSql="select * from 銷售商品管理表";
	adoMain.Open(strSql);
	adoMain.InitList(&m_listMain,4);
	adoMain.ExitConnect();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgXiaoShouTuiDan::OnButton6() 
{
	// TODO: Add your control notification handler code here
	CDlgAll dlg;
	UpdateData(TRUE);
	dlg.strTitle="管理員基本信息表";
	dlg.strSql="select 編號,姓名 from 管理員基本信息表";
	dlg.intOpen=2;
	if(dlg.DoModal()==IDOK)
	{
		m_str3=dlg.strKey;
		UpdateData(FALSE);
	}		
}

void CDlgXiaoShouTuiDan::OnButton2() 
{
	// TODO: Add your control notification handler code here
	CDlgAll dlg;
	CADOConn adoMain;
	CString strSql;
	UpdateData(TRUE);
	dlg.strTitle="銷售單統計表";
	dlg.strSql="select * from 銷售單統計表";
	dlg.intOpen=2;
	if(dlg.DoModal()==IDOK)
	{
		m_str1=dlg.strKey;
		UpdateData(FALSE);
	}
	strSql="select * from 銷售商品管理表 where 單編號='";
	strSql=strSql+m_str1+"'";
	adoMain.Open(strSql);
	adoMain.InitList(&m_listMain,4);
	adoMain.FillList(&m_listMain,4);
	adoMain.ExitConnect();
}

void CDlgXiaoShouTuiDan::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CDlgAll dlg;
	CADOConn adoMain;
	CString strSql,str;
	int i;
	UpdateData(TRUE);
	strSql="insert into 銷售退貨單統計表 values('";
	strSql=strSql+m_str1+"','";
	strSql=strSql+m_str2+"','";
	strSql=strSql+m_str3+"','";
	strSql=strSql+m_str4+"','";
	strSql=strSql+m_str5+"')";
	adoMain.ExecuteSQL(strSql);
	if(m_str1!="")
	{

		for(i=0;i<m_listMain.GetItemCount();i++)
		{
			strSql="update 商品庫存數量統計表 set 庫存=";
			str.Format("%0.2f",atof(m_listMain.GetItemText(i,5))+atof(m_listMain.GetItemText(i,6)));
			strSql=strSql+str+" where 條形碼='";
			strSql=strSql+m_listMain.GetItemText(i,1)+"'";
			adoMain.ExecuteSQL(strSql);
		}
	}
	adoMain.ExitConnect();
	m_str1="";
	m_str3="";
	m_str4="";
	m_listMain.DeleteAllItems();
	UpdateData(FALSE);
}

void CDlgXiaoShouTuiDan::OnButton7() 
{
	// TODO: Add your control notification handler code here
	CDlgAll dlg;
	UpdateData(TRUE);
	dlg.strTitle="分機基本信息表";
	dlg.strSql="select * from 分機基本信息表";;
	dlg.intOpen=3;
	if(dlg.DoModal()==IDOK)
	{
		m_str5=dlg.strKey;
		UpdateData(FALSE);
	}			
}