?? khfk.cpp
字號:
// KHFK.cpp : implementation file
//
#include "stdafx.h"
#include "khmanager.h"
#include "KHFK.h"
#include "ado.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
int khfkclnum=0;
int khfkxiugai=0;
/////////////////////////////////////////////////////////////////////////////
// KHFK dialog
KHFK::KHFK(CWnd* pParent /*=NULL*/)
: CDialog(KHFK::IDD, pParent)
{
//{{AFX_DATA_INIT(KHFK)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void KHFK::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(KHFK)
DDX_Control(pDX, IDC_LIST1, m_list);
DDX_Control(pDX, IDC_EDIT7, m_edit7);
DDX_Control(pDX, IDC_EDIT6, m_edit6);
DDX_Control(pDX, IDC_EDIT5, m_edit5);
DDX_Control(pDX, IDC_EDIT2, m_edit2);
DDX_Control(pDX, IDC_EDIT1, m_edit1);
DDX_Control(pDX, IDC_DATETIMEPICKER1, m_date);
DDX_Control(pDX, IDC_COMBO4, m_com4);
DDX_Control(pDX, IDC_COMBO1, m_com1);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(KHFK, CDialog)
//{{AFX_MSG_MAP(KHFK)
ON_COMMAND(ID_ADD, OnAdd)
ON_COMMAND(ID_DELETE, OnDelete)
ON_COMMAND(ID_EXIT, OnExit)
ON_COMMAND(ID_UPDATE, OnUpdate)
ON_COMMAND(ID_SAVE, OnSave)
ON_COMMAND(ID_CANCEL, OnCancel)
ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// KHFK message handlers
BOOL KHFK::OnInitDialog()
{
CDialog::OnInitDialog();
ado load;
load.Open("select * from tb_khxx",adCmdText);
int rstnum=load.GetRecordCount();
int l;
for(l=1;l<=rstnum;l++)
{
this->m_com4.AddString(load.GetFieldValue("khxx_mc"));
load.Move(l);
}
load.Open("select * from tb_Client_khmyd",adCmdText);
rstnum=load.GetRecordCount();
for(l=1;l<=rstnum;l++)
{
this->m_com1.AddString(load.GetFieldValue("khmyd_myd"));
load.Move(l);
}
load.close();
imagelist.Create(32,32,ILC_COLOR32|ILC_MASK,0,0);
imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON1)));
imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON2)));
imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON3)));
imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON4)));
imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON5)));
imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON10)));
CString s;
TCHAR *pString;
menu.LoadMenu(IDR_lxrxx);
toolbar.EnableAutomation();
toolbar.Create(WS_CHILD|WS_VISIBLE,CRect(0,0,0,0),this,ID_TOOLBAR);
toolbar.SetImageList(&imagelist);
int i;
for(i=0;i<8;i++)
{
button[i].dwData=0;
button[i].fsState=TBSTATE_ENABLED;
button[i].fsStyle=TBSTYLE_BUTTON;
}
button[5].fsStyle=TBSTYLE_SEP;
button[0].idCommand=ID_ADD;
button[0].iBitmap=0;
button[1].idCommand=ID_UPDATE;
button[1].iBitmap=1;
button[2].idCommand=ID_DELETE;
button[2].iBitmap=2;
button[3].idCommand=ID_SAVE;
button[3].iBitmap=3;
button[4].idCommand=ID_CANCEL;
button[4].iBitmap=4;
button[6].idCommand=ID_EXIT;
button[6].iBitmap=5;
for(i=0;i<8;i++)
{
s.LoadString(i+IDS_21);
int nStringLength= s.GetLength() + 1;
pString = s.GetBufferSetLength(nStringLength);
button[i].iString =toolbar.AddStrings(pString);
s.ReleaseBuffer();
}
toolbar.AddButtons(7,button);
toolbar.AutoSize();
toolbar.SetStyle(TBSTYLE_FLAT|CCS_TOP);
toolbar.EnableButton(ID_SAVE,false);
toolbar.EnableButton(ID_CANCEL,false);
m_list.ModifyStyle(0L,LVS_REPORT);
// m_list.ModifyStyle(0L,LVS_SINGLESEL);
m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS);
m_list.ModifyStyle(0L,LVS_NOSORTHEADER);
m_list.SetExtendedStyle(LVS_EX_GRIDLINES|
LVS_EX_FULLROWSELECT|
LVS_EX_HEADERDRAGDROP|
LVS_EX_ONECLICKACTIVATE);
m_list.InsertColumn(0,"意見反饋編號");
m_list.InsertColumn(1,"反饋標題");
m_list.InsertColumn(2,"客戶名稱");
m_list.InsertColumn(3,"反饋內容");
m_list.InsertColumn(4,"反饋日期");
m_list.InsertColumn(5,"受理人");
m_list.InsertColumn(6,"客戶滿意度");
m_list.InsertColumn(7,"備注信息");
m_list.SetColumnWidth(0,100);
m_list.SetColumnWidth(1,100);
m_list.SetColumnWidth(2,100);
m_list.SetColumnWidth(3,100);
m_list.SetColumnWidth(4,100);
m_list.SetColumnWidth(5,100);
m_list.SetColumnWidth(6,100);
m_list.SetColumnWidth(7,100);
this->loadlist();
this->enbalewin(false);
//this->datatotext();
this->texttowin();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void KHFK::OnAdd()
{
this->enbalewin(true);
this->enablebutton(false);
this->clearall();
this->autonum();
}
void KHFK::OnCancel()
{
this->enbalewin(false);
this->enablebutton(true);
khfkxiugai=0;
this->datatotext();
this->texttowin();
}
void KHFK::OnDelete()
{
ado rst;
CString ss,aa;
this->m_edit1.GetWindowText(aa);
if(aa.IsEmpty())
{MessageBox("不能為空","提示");
return;}
if(MessageBox("刪除后數據將丟失","提示",MB_YESNO)==IDYES)
{
ss.Format("delete from tb_Client_khfk where khfk_id = '%s'",aa);
rst.ExecuteSQL(ss);
m_list.DeleteAllItems();
this->loadlist();
this->datatotext();
this->texttowin();
}
}
void KHFK::OnExit()
{
this->EndDialog(true);
}
void KHFK::OnUpdate()
{
CString ss,aa;
this->m_edit1.GetWindowText(aa);
if(aa.IsEmpty())
{MessageBox("不能為空","提示");
return;}
this->enbalewin(true);
this->enablebutton(false);
khfkxiugai=1;
}
void KHFK::OnSave()
{
ado rst;
this->wintotext();
CString ss;
if(khfkxiugai==1)
{ss.Format("UPDATE tb_Client_khfk set khfk_fkbt='%s',khfk_khmc='%s',khfk_fknr='%s',khfk_fkrq='%s',khfk_fkslr='%s',khfk_khmyd='%s',khfk_bz='%s' where khfk_id='%s'",edit2,com4,edit5,date,edit6,com1,edit7,edit1);}
else
{ss.Format("INSERT INTO tb_Client_khfk values('%s','%s','%s','%s','%s','%s','%s','%s')",edit1,edit2,com4,edit5,date,edit6,com1,edit7);}
rst.ExecuteSQL(ss);
m_list.DeleteAllItems();
this->loadlist();
this->datatotext();
this->texttowin();
this->enbalewin(false);
this->enablebutton(true);
khfkxiugai=0;
}
void KHFK::clearall()
{
this->m_com1.SetWindowText("");
this->m_com4.SetWindowText("");
this->m_date.SetWindowText("");
this->m_edit1.SetWindowText("");
this->m_edit2.SetWindowText("");
this->m_edit5.SetWindowText("");
this->m_edit6.SetWindowText("");
this->m_edit7.SetWindowText("");
}
void KHFK::enablebutton(bool butn)
{
toolbar.EnableButton(ID_ADD,butn);
toolbar.EnableButton(ID_UPDATE,butn);
toolbar.EnableButton(ID_DELETE,butn);
toolbar.EnableButton(ID_SAVE,!butn);
toolbar.EnableButton(ID_CANCEL,!butn);
}
void KHFK::enbalewin(bool wi)
{
this->m_com1.EnableWindow(wi);
this->m_com4.EnableWindow(wi);
this->m_date.EnableWindow(wi);
this->m_edit1.EnableWindow(wi);
this->m_edit2.EnableWindow(wi);
this->m_edit5.EnableWindow(wi);
this->m_edit6.EnableWindow(wi);
this->m_edit7.EnableWindow(wi);
}
void KHFK::texttowin()
{
this->m_com1.SetWindowText(com1);
this->m_com4.SetWindowText(com4);
this->m_date.SetWindowText(date);
this->m_edit1.SetWindowText(edit1);
this->m_edit2.SetWindowText(edit2);
this->m_edit5.SetWindowText(edit5);
this->m_edit6.SetWindowText(edit6);
this->m_edit7.SetWindowText(edit7);
}
void KHFK::wintotext()
{
this->m_com1.GetWindowText(com1);
this->m_com4.GetWindowText(com4);
this->m_date.GetWindowText(date);
this->m_edit1.GetWindowText(edit1);
this->m_edit2.GetWindowText(edit2);
this->m_edit5.GetWindowText(edit5);
this->m_edit6.GetWindowText(edit6);
this->m_edit7.GetWindowText(edit7);
}
void KHFK::datatotext()
{
edit1=m_list.GetItemText(khfkclnum,0);
edit2=m_list.GetItemText(khfkclnum,1);
edit5=m_list.GetItemText(khfkclnum,3);
edit6=m_list.GetItemText(khfkclnum,5);
edit7=m_list.GetItemText(khfkclnum,7);
com1=m_list.GetItemText(khfkclnum,6);
com4=m_list.GetItemText(khfkclnum,2);
date=m_list.GetItemText(khfkclnum,4);
}
void KHFK::loadlist()
{
ado rst;
rst.rstOpen("select * from tb_Client_khfk");
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("khfk_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("khfk_fkbt"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("khfk_khmc"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("khfk_fknr"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("khfk_fkrq"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("khfk_fkslr"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("khfk_khmyd"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("khfk_bz"));
rst.Move(ii);
}
rst.close();
}
void KHFK::autonum()
{
ado rst3;
rst3.rstOpen("select * from tb_Client_khfk");
if(rst3.GetRecordCount()==0)
{
this->m_edit1.SetWindowText("FK001");
this->m_edit1.EnableWindow(false);
return;
}
rst3.MoveLast();
CString mm=rst3.GetFieldValue("khfk_id");
int xuhao=atoi(mm.Right(3));
xuhao+=1;
mm.Format("FK%03d",xuhao);
this->m_edit1.EnableWindow(false);
this->m_edit1.SetWindowText(mm);
rst3.close();
}
void KHFK::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult)
{
khfkclnum=m_list.GetHotItem();
if(khfkclnum<0)
{return;}
this->datatotext();
this->texttowin();
this->enbalewin(false);
this->enablebutton(true);
*pResult = 0;
}
BOOL KHFK::PreTranslateMessage(MSG* pMsg)
{
// TODO: Add your specialized code here and/or call the base class
if(pMsg->message==WM_KEYDOWN && pMsg->wParam==13)
pMsg->wParam=9;
return CDialog::PreTranslateMessage(pMsg);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -