// Duty.cpp : implementation file
//

#include "stdafx.h"
#include "源程序.h"
#include "Duty.h"
#include "RainFunction.h"
#include "DBSlider.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern _ConnectionPtr cnn;
/////////////////////////////////////////////////////////////////////////////
// CDuty dialog


CDuty::CDuty(CWnd* pParent /*=NULL*/)
	: CDialog(CDuty::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDuty)
	//}}AFX_DATA_INIT
}


void CDuty::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDuty)
	DDX_Control(pDX, IDC_BUTUnDo, m_ButUndo);
	DDX_Control(pDX, IDC_BUTSave, m_ButSave);
	DDX_Control(pDX, IDC_BUTEXIT, m_ButExit);
	DDX_Control(pDX, IDC_BUTDELETE, m_ButDelete);
	DDX_Control(pDX, IDC_BUTChange, m_ButChange);
	DDX_Control(pDX, IDC_BUTADD, m_ButAdd);
	DDX_Control(pDX, IDC_ComDuty, m_ComDuty);
	DDX_Control(pDX, IDC_EDTLetterName, m_EdtLetterName);
	DDX_Control(pDX, IDC_EDTName, m_EdtName);
	DDX_Control(pDX, IDC_STAID, m_StaID);
	DDX_Control(pDX, IDC_LIST2, m_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDuty, CDialog)
	//{{AFX_MSG_MAP(CDuty)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	ON_BN_CLICKED(IDC_BUTADD, OnButadd)
	ON_BN_CLICKED(IDC_BUTChange, OnBUTChange)
	ON_BN_CLICKED(IDC_BUTDELETE, OnButdelete)
	ON_BN_CLICKED(IDC_BUTSave, OnBUTSave)
	ON_BN_CLICKED(IDC_BUTUnDo, OnBUTUnDo)
	ON_EN_CHANGE(IDC_EDTName, OnChangeEDTName)
	ON_LBN_SELCHANGE(IDC_LIST2, OnSelchangeList2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDuty message handlers

BOOL CDuty::OnInitDialog() 
{
	CDialog::OnInitDialog();
	_RecordsetPtr DutyRst;
	DutyRst.CreateInstance(__uuidof(Recordset));
	DutyRst=cnn->Execute((_bstr_t)"客戶類別表",NULL,adCmdTable);
	if(function.RecordCount(DutyRst)>0)
	{
		m_ComDuty.record=DutyRst;
		m_ComDuty.DateBaseName="客戶類別表";
		m_ComDuty.IDStyle=1;
		m_ComDuty.Init("名稱");
	}
	DutyRst->Close();
	rst.CreateInstance(__uuidof(Recordset));
	rst=cnn->Execute((_bstr_t)"客戶職務查詢",NULL,adCmdTable);
	if(function.RecordCount(rst)>0)
	{
		m_List.record=rst;
		m_List.DateBaseName="客戶職務查詢";
		m_List.Init("名稱");
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDuty::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDuty::Display()
{
	_RecordsetPtr DisplayRst;
	DisplayRst.CreateInstance(__uuidof(Recordset));
	CString ID,Name,LetterName,Duty,sSQL;
	sSQL.Format("SELECT * FROM 客戶職務查詢 WHERE 編號=%d",this->m_List.Recno);
	DisplayRst=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
	if(function.RecordCount(DisplayRst)>0)
	{
		DisplayRst->MoveFirst();
		ID=(char*)(_bstr_t)DisplayRst->GetCollect("編號");
		Name=(char*)(_bstr_t)DisplayRst->GetCollect("名稱");
		LetterName=(char*)(_bstr_t)DisplayRst->GetCollect("簡稱");
		Duty=(char*)(_bstr_t)DisplayRst->GetCollect("客戶類別");
		m_StaID.SetWindowText(ID);
		m_EdtName.SetWindowText(Name);
		m_EdtLetterName.SetWindowText(LetterName);
		m_ComDuty.SetWindowText(Duty);
	}
	DisplayRst->Close();
}



void CDuty::OnButexit() 
{
	this->OnCancel();
}

void CDuty::OnButadd() 
{
	int NewID;
	CString ID;
	this->Enabled(false);
	this->ClearFrom();
	NewID=function.AutoNumber(0,"客戶職務表");
	ID.Format("%d",NewID);
	this->m_StaID.SetWindowText(ID);
	this->AddorChange=true;
	this->m_EdtName.SetFocus();
}

void CDuty::Enabled(bool enabled)
{
	this->m_ButAdd.EnableWindow(enabled);
	this->m_ButChange.EnableWindow(enabled);
	this->m_ButDelete.EnableWindow(enabled);
	this->m_ButExit.EnableWindow(enabled);
	this->m_ButSave.EnableWindow(!enabled);
	this->m_ButUndo.EnableWindow(!enabled);
	this->m_ComDuty.EnableWindow(!enabled);
	this->m_EdtLetterName.EnableWindow(!enabled);
	this->m_EdtName.EnableWindow(!enabled);
	this->m_List.EnableWindow(enabled);
}

void CDuty::OnBUTChange() 
{
	this->Enabled(false);
	this->m_ComDuty.SetWindowText("");
	this->m_EdtName.SetFocus();
	AddorChange=false;
}

void CDuty::OnButdelete() 
{
	CString ID,sSQL;
	this->m_StaID.GetWindowText(ID);
	if(ID.IsEmpty()==false)
	{
		int a=MessageBox("確定要刪除此條記錄嗎？","系統提示",MB_OKCANCEL|MB_ICONQUESTION);
		if (a==1)
		{
			CString sSQL;
			sSQL.Format("DELETE FROM 客戶職務表 WHERE 編號=%s",ID);
			cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
			this->Enabled(true);
			m_List.ResetContent();
			m_List.Init("名稱");
			this->Enabled(true);
			m_List.SetFocus();
			this->m_List.SetCurSel(0);
			this->ClearFrom();
		}
	}
	else
	{
		MessageBox("請選擇一條記錄！","系統提示",MB_OK|MB_ICONSTOP);
	}
}

void CDuty::OnBUTSave() 
{
	int a=MessageBox("確定保存記錄嗎?","系統提示",MB_ICONQUESTION|MB_OKCANCEL);
	if(a==1)
	{
		CString sSQL,ID,Name,LetterName,Duty;
		_RecordsetPtr myrst;
		myrst.CreateInstance(__uuidof(Recordset));
		m_StaID.GetWindowText(ID);
		m_EdtName.GetWindowText(Name);
		m_EdtLetterName.GetWindowText(LetterName);
		m_ComDuty.GetWindowText(Duty);
		if( Name.IsEmpty()==false && LetterName.IsEmpty()==false && Duty.IsEmpty()==false)
		{
			if(this->AddorChange==true)// 如果執行添加操作	
				sSQL.Format("Insert Into 客戶職務表 values (%s,'%s','%s',%d)",ID,Name,LetterName,m_ComDuty.Recno);
			else
				sSQL.Format("UPDATE 客戶職務表 SET 名稱='%s',簡稱='%s',客戶類別=%d WHERE 編號=%s",Name,LetterName,m_ComDuty.Recno,ID);
			try{
			myrst=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
			}
			catch(...)
			{
				function.ADOError(myrst);
				return;
			}
			m_List.ResetContent();
			m_List.Init("名稱");
			this->Enabled(true);
			m_List.SetFocus();
		}
		else	
		{
			MessageBox("請將字段填寫完整！","系統提示",MB_OK|MB_ICONSTOP);
			this->m_EdtName.SetFocus();
			return;
		}
	}
	
}

void CDuty::OnBUTUnDo() 
{
	this->Enabled(true);	
}

void CDuty::ClearFrom()
{
	this->m_EdtLetterName.SetWindowText("");
	this->m_EdtName.SetWindowText("");
	this->m_ComDuty.SetWindowText("");
}

BOOL CDuty::PreTranslateMessage(MSG* pMsg) 
{
	function.CMessage(this,pMsg,&m_EdtName,&m_EdtLetterName);
	function.CMessage(this,pMsg,&m_EdtLetterName,&m_ComDuty);
	function.CMessage(this,pMsg,&m_ComDuty,&m_ButSave);	
	return CDialog::PreTranslateMessage(pMsg);
}

void CDuty::OnChangeEDTName() 
{
	CString LetterName,Name;
	m_EdtName.GetWindowText(Name);
	LetterName=function.CharToLetterCode(Name);
	m_EdtLetterName.SetWindowText(LetterName);	
}


void CDuty::OnSelchangeList2() 
{
	this->Display();
}