?? bmdialog.cpp
字號:
// BMDialog.cpp : 實現文件
//
#include "stdafx.h"
#include "StudentScore.h"
#include "BMDialog.h"
// CBMDialog 對話框
IMPLEMENT_DYNAMIC(CBMDialog, CDialog)
CBMDialog::CBMDialog(CWnd* pParent /*=NULL*/)
: CDialog(CBMDialog::IDD, pParent)
{
}
CBMDialog::~CBMDialog()
{
}
void CBMDialog::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
}
BEGIN_MESSAGE_MAP(CBMDialog, CDialog)
ON_BN_CLICKED(IDOK, OnBnClickedOk)
ON_WM_DESTROY()
ON_BN_CLICKED(IDC_BUTTON1, OnAddRec)
END_MESSAGE_MAP()
// CBMDialog 消息處理程序
BOOL CBMDialog::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: 在此添加額外的初始化
//動態創建組件
CFieldRecord* pRecord;
int top=0;
for(int i=1;i<=this->RecordArray.GetSize();i++)
{
top=(i-1)*22;
pRecord=(CFieldRecord*)RecordArray.GetAt(i-1);
this->CreateStatic(pRecord,top,70+i);
if((pRecord->IsBool)||(pRecord->pFK!=NULL))//布爾或有關聯外鍵
{
this->CreateCombo(pRecord,top,10+i);
}
else
{
this->CreateEdit(pRecord,top,10+i);
}
}
CWnd* pWnd;
CRect rect;
pWnd=this->GetDlgItem(IDC_BUTTON1);
pWnd->GetWindowRect(&rect);
rect.top=top+30;
rect.bottom=rect.top+25;
pWnd->MoveWindow(&rect);
pWnd=this->GetDlgItem(IDOK);
pWnd->GetWindowRect(&rect);
rect.top=top+30;
rect.bottom=rect.top+25;
pWnd->MoveWindow(&rect);
pWnd=this->GetDlgItem(IDCANCEL);
pWnd->GetWindowRect(&rect);
rect.top=top+30;
rect.bottom=rect.top+25;
pWnd->MoveWindow(&rect);
this->GetWindowRect(&rect);
int width=rect.right-rect.left;
this->MoveWindow(rect.left,rect.top,width,top+100);
if(!this->ISADD)
{
this->GetDlgItem(IDC_BUTTON1)->EnableWindow(false);
this->SetWindowText("修改記錄");
}
else
{
this->GetDlgItem(IDOK)->EnableWindow(false);
this->GetDlgItem(IDCANCEL)->SetWindowText("關閉");
this->SetWindowText("添加記錄");
}
return TRUE; // return TRUE unless you set the focus to a control
// 異常：OCX 屬性頁應返回 FALSE
}
void CBMDialog::PostNcDestroy()
{
CDialog::PostNcDestroy();
}
void CBMDialog::OnBnClickedOk()
{
// TODO: 在此添加控件通知處理程序代碼
//判斷添加內容(編輯框)是否為空
this->SendChangeMsg();
OnOK();
}
//釋放創建的組件
void CBMDialog::FreeControls(void)
{
CWnd *pWnd;
for(int i=1;i<=this->RecordArray.GetSize();i++)
{
//釋放靜態框
pWnd=this->GetDlgItem(70+i);
if (pWnd)
{
pWnd->DestroyWindow();
delete pWnd;
pWnd=NULL;
}
//釋放文本框或其它
pWnd=this->GetDlgItem(10+i);
if(pWnd)
{
if (pWnd->IsKindOf(RUNTIME_CLASS(CComboBox)))
{
CComboBox* pComboBox=(CComboBox*) pWnd;
void* p;
for(int j=0;j<pComboBox->GetCount();j++)
{
p=pComboBox->GetItemDataPtr(j);
if(p)
delete p;
}
for(j=0;j<pComboBox->GetCount();j++)
{
pComboBox->DeleteString(0);
}
}
pWnd->DestroyWindow();
delete pWnd;
pWnd=NULL;
}
}
//釋放數組
i=0;
CFieldRecord* pRecord=NULL;
while(i<this->RecordArray.GetSize())
{
pRecord=(CFieldRecord*)RecordArray.GetAt(i);
if(pRecord->pFK)//如果有外鍵,釋放外鍵
{
delete pRecord->pFK;
}
delete pRecord;
i++;
}
this->RecordArray.RemoveAll();
}
void CBMDialog::OnFinalRelease()
{
// TODO: 在此添加專用代碼和/或調用基類
CDialog::OnFinalRelease();
}
void CBMDialog::OnDestroy()
{
this->FreeControls();//釋放組件
CDialog::OnDestroy();
// TODO: 在此添加消息處理程序代碼
}
CString CBMDialog::GenerateInsertSql(void)
{
CString sqlstr,fldlist,valuelist;
CFieldRecord* pRecord;
ASSERT(this->m_OprTblName!="");
for(int i=0;i<this->RecordArray.GetSize();i++)
{
pRecord= (CFieldRecord*)this->RecordArray.GetAt(i);
//獲得值
if (pRecord->IsBool)
{
if(_stricmp(pRecord->Value,"是")==0)
valuelist=valuelist+"TRUE";
else if(_stricmp(pRecord->Value,"否")==0)
valuelist=valuelist+"FALSE";
}
else if(pRecord->IsStrType)
{
valuelist=valuelist+"'"+pRecord->Value+"'";
}
else
{
valuelist=valuelist+pRecord->Value;
}
//字段
fldlist=fldlist+pRecord->FieldName;
//判斷,
if(i!=this->RecordArray.GetSize()-1)
{
fldlist=fldlist+",";
valuelist=valuelist+",";
}
}
sqlstr="insert into "+this->m_OprTblName+"("+fldlist+") values("+valuelist+")";
return sqlstr;
}
CString CBMDialog::GenerateUpdateSql(void)
{
CString sqlstr,updatestr,valuelist,constr;
CFieldRecord* pRecord;
ASSERT(this->m_OprTblName!="");
pRecord=(CFieldRecord*)this->RecordArray.GetAt(0);
if(pRecord->IsStrType)
{
valuelist="'";
valuelist=valuelist+pRecord->Value;
valuelist=valuelist+"'";
}
else
{
valuelist=pRecord->Value;
}
constr="where ";
constr=constr+pRecord->FieldName+"="+valuelist;
for(int i=1;i<this->RecordArray.GetSize();i++)
{
pRecord= (CFieldRecord*)this->RecordArray.GetAt(i);
//獲得值
if (pRecord->IsBool)
{
if(_stricmp(pRecord->Value,"是")==0)
valuelist="TRUE";
else if(_stricmp(pRecord->Value,"否")==0)
valuelist="FALSE";
}
else if(pRecord->IsStrType)
{
valuelist="'";
valuelist=valuelist+pRecord->Value;
valuelist=valuelist+"'";
}
else
{
valuelist=pRecord->Value;
}
//字段
updatestr=updatestr+pRecord->FieldName+"="+valuelist;
//判斷,
if(i!=this->RecordArray.GetSize()-1)
{
updatestr=updatestr+",";
}
}
sqlstr="update "+this->m_OprTblName+" set "+updatestr+" "+constr;
return sqlstr;
}
void CBMDialog::OnAddRec()
{
// TODO: 在此添加控件通知處理程序代碼
this->SendChangeMsg();
}
void CBMDialog::CreateStatic(CFieldRecord* pRecord,int top,UINT CtlID)
{
CStatic *pText;
pText=new CStatic();
pText->Create(pRecord->FieldName, WS_CHILD|WS_VISIBLE|SS_CENTER,
CRect(10,2+top, 110, 23+top), this,CtlID);
pText->ShowWindow(SW_SHOW);
pText->SetFont(this->GetFont());
}
void CBMDialog::CreateCombo(CFieldRecord* pRecord,int top,UINT CtlID)
{
CComboBox* pCombo;
pCombo=new CComboBox();
pCombo->Create(WS_CHILD|WS_VISIBLE|WS_VSCROLL|CBS_DROPDOWNLIST,
CRect(110,2+top, 250, 230+top), this, CtlID);
pCombo->ShowWindow(SW_SHOW);
pCombo->SetFont(this->GetFont());
if(pRecord->IsBool)
{
pCombo->AddString("是");
pCombo->AddString("否");
if(this->ISADD)
{
pCombo->SetCurSel(0);
}
else//不是新增加
{
if(_stricmp(pRecord->Value,"TRUE")==0)
{
pCombo->SetCurSel(0);
}
else
{
pCombo->SetCurSel(1);
}
}
}
else//有外鍵
{
this->FillComboByDS(pRecord,pCombo);
}
}
void CBMDialog::CreateEdit(CFieldRecord* pRecord,int top,UINT CtlID)
{
CEdit *pEdit;
pEdit=new CEdit();
pEdit->Create(ES_MULTILINE | WS_CHILD | WS_VISIBLE | WS_TABSTOP | WS_BORDER,
CRect(110,2+top, 250, 23+top), this, CtlID);
pEdit->ShowWindow(SW_SHOW);
pEdit->SetWindowText(pRecord->Value);
pEdit->SetFont(this->GetFont());
}
void CBMDialog::FillComboByDS(CFieldRecord* pRecord,CComboBox* pCombo)
{
if(pRecord->pFK==NULL)
return;
storage1.OpenSql(pRecord->pFK->FKtbl);
int count=storage1.GetRecordCount();
if(count==0)
return;
CFldValue* pValue ; //用于添加記錄指針
CString value;
int index; //
int selindex=-1; //選擇的記錄(用于修改時)
storage1.MoveFirst();
for(int i=0;i<count;i++)
{
pValue=new CFldValue();
storage1.GetFieldValue(pRecord->pFK->FieldName,value);
strcpy(pValue->FieldValue,value);
storage1.GetFieldValue(pRecord->pFK->DisplayName,value);
strcpy(pValue->DispalyFieldValue,value);
index=pCombo->AddString(pValue->DispalyFieldValue);
pCombo->SetItemDataPtr(index,pValue);
//判斷當前選項
if(_stricmp(pValue->FieldValue,pRecord->Value)==0)
selindex=index;
storage1.MoveNext();
}
//判斷
if(this->ISADD)
{
pCombo->SetCurSel(0);
}
else//不是新增加,為修改時
{
pCombo->SetCurSel(selindex);
}
}
//發送修改或添加消息
void CBMDialog::SendChangeMsg(void)
{
CWnd* pWnd;
CString value,Msg;
CFieldRecord* pRecord;
for(int i=1;i<=this->RecordArray.GetSize();i++)
{
pWnd=this->GetDlgItem(10+i);
if(pWnd)
{
pRecord=(CFieldRecord*)RecordArray.GetAt(i-1);
if ((!pRecord->IsBool)&&pWnd->IsKindOf(RUNTIME_CLASS(CComboBox)))
{ //非布爾類型,且有關聯字段時
CComboBox* pCombo=(CComboBox*) pWnd;
CFldValue* p;
int index=pCombo->GetCurSel();
p=(CFldValue*)pCombo->GetItemDataPtr(index);
value=p->FieldValue;
}
else
pWnd->GetWindowText(value);
value.TrimRight();
if(value=="")
{
Msg=(CString)pRecord->FieldName+"不能為空!";
AfxMessageBox(Msg);
pWnd->SetFocus();
return;
}
else
{
if((i==1)&&(!this->ISADD))//如果是修改的話,則不對第一字段操作
{}
else
strcpy(pRecord->Value,value);
}
}
}
//發送字符串
CString cSend;
if(this->ISADD)
{
cSend=this->GenerateInsertSql();
}
else
{
cSend=this->GenerateUpdateSql();
}
LPARAM lparam=(LPARAM)&cSend;
::SendMessage((HWND)this->m_hParent,WM_USER+51,0,lparam);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -