?? xjxfxdlg.cpp
字號:
m_Bj_Con.EnableWindow(true);
}
else
{
m_Bj_Con.EnableWindow(false);
}
this->UpdateData(false);
}
void CXjXfxDlg::OnCheckJb()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
if(m_IsJb)
{
m_Jb_Con.EnableWindow(true);
}
else
{
m_Jb_Con.EnableWindow(false);
}
this->UpdateData(false);
}
void CXjXfxDlg::OnCheckQt()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
if(m_IsQt)
{
m_Qt_Con.EnableWindow(true);
m_Qt_G_Con.EnableWindow(true);
}
else
{
m_Qt_Con.EnableWindow(false);
m_Qt_G_Con.EnableWindow(false);
}
this->UpdateData(false);
}
void CXjXfxDlg::OnCheckXh()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
if(m_IsXh)
{
m_Xh_Con.EnableWindow(true);
}
else
{
m_Xh_Con.EnableWindow(false);
}
this->UpdateData(false);
}
void CXjXfxDlg::OnCheckXm()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
if(m_IsXm)
{
m_Xm_Con.EnableWindow(true);
}
else
{
m_Xm_Con.EnableWindow(false);
}
this->UpdateData(false);
}
void CXjXfxDlg::OnCheckZy()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
if(m_IsZy)
{
m_Zy_Con.EnableWindow(true);
}
else
{
m_Zy_Con.EnableWindow(false);
}
this->UpdateData(false);
}
void CXjXfxDlg::RefreshXfx(CString SID)
{
m_XfxList.DeleteAllItems();
CString sqlt;
sqlt.Format("SELECT * FROM XfxTable WHERE S_ID='%s'",SID);
m_parent->m_recSet->Open(sqlt.GetBuffer(100));
if(!m_parent->m_recSet->IsEOF())
{
CString temp;
COleDateTime dateTemp;
int i=0;
LV_ITEM lvitem;
lvitem.mask = LVIF_TEXT | LVIF_IMAGE | LVIF_STATE;
lvitem.state = 0;
lvitem.stateMask = 0;
char temp1[50];
while(!m_parent->m_recSet->IsEOF())
{
lvitem.iItem = i;
lvitem.iSubItem = 0;
lvitem.pszText =itoa(i, temp1, 10);
m_XfxList.InsertItem(&lvitem);
m_parent->m_recSet->GetFieldValue("XFX_ID",temp);
m_XfxList.SetItemText(i,0,temp);
m_parent->m_recSet->GetFieldValue("XFX_Lx",temp);
m_XfxList.SetItemText(i,1,temp);
m_parent->m_recSet->GetFieldValue("XFX_Date",dateTemp);
m_XfxList.SetItemText(i,2,dateTemp.Format("%Y/%m/%d"));
m_parent->m_recSet->GetFieldValue("XFX_Jsr",temp);
m_XfxList.SetItemText(i,3,temp);
i++;
m_parent->m_recSet->MoveNext();
}
}
m_parent->m_recSet->Close();
}
void CXjXfxDlg::OnClickListStu(NMHDR* pNMHDR, LRESULT* pResult)
{
// TODO: Add your control notification handler code here
int index = m_StuList.GetSelectionMark();
if(index <0)
{
return;
}
RefreshXfx(m_StuList.GetItemText(index,0));
this->UpdateData(true);
m_Xfx_Jb = m_StuList.GetItemText(index,3);
m_Xfx_Bj = m_StuList.GetItemText(index,4);
m_Xfx_ID = m_StuList.GetItemText(index,0);
m_Xfx_Xm = m_StuList.GetItemText(index,1);
m_Xfx_Xjzt = m_StuList.GetItemText(index,6);
this->UpdateData(false);
*pResult = 0;
}
void CXjXfxDlg::OnClickListXfx(NMHDR* pNMHDR, LRESULT* pResult)
{
// TODO: Add your control notification handler code here
int index = m_XfxList.GetSelectionMark();
if(index <0)
{
return;
}
CString sqlt;
sqlt.Format("SELECT * FROM XfxTable WHERE XFX_ID=%s",m_XfxList.GetItemText(index,0));
m_parent->m_recSet->Open(sqlt.GetBuffer(100));
COleDateTime dateTemp;
this->UpdateData(true);
m_parent->m_recSet->GetFieldValue("XFX_Lx",m_Xfx_Lx);
m_parent->m_recSet->GetFieldValue("XFX_Date",dateTemp);
CTime t(dateTemp.GetYear(),dateTemp.GetMonth(),dateTemp.GetDay(),0,0,0);
m_Xfx_Rq = t;
m_parent->m_recSet->GetFieldValue("XFX_Yy",m_Xfx_Yy);
m_parent->m_recSet->GetFieldValue("XFX_Jsr",m_Xfx_Jsr);
m_parent->m_recSet->GetFieldValue("XFX_Bz",m_Xfx_Bz);
this->UpdateData(false);
m_parent->m_recSet->Close();
*pResult = 0;
}
void CXjXfxDlg::OnBuXfxAdd()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
m_Xfx_ID.TrimLeft();
m_Xfx_ID.TrimRight();
if(m_Xfx_ID == "")
{
MessageBox("請選擇學生");
this->UpdateData(false);
return;
}
m_Xfx_Lx.TrimLeft();
m_Xfx_Lx.TrimRight();
if(m_Xfx_Lx =="")
{
MessageBox("請選擇類型");
this->UpdateData(false);
return;
}
m_Xfx_Yy.TrimLeft();
m_Xfx_Yy.TrimRight();
if(m_Xfx_Yy =="")
{
MessageBox("請輸入原因");
this->UpdateData(false);
return;
}
m_Xfx_Jsr.TrimLeft();
m_Xfx_Jsr.TrimRight();
if(m_Xfx_Jsr =="")
{
MessageBox("請輸入經手人");
this->UpdateData(false);
return;
}
m_Xfx_Xjzt.TrimLeft();
m_Xfx_Xjzt.TrimRight();
if(m_Xfx_Xjzt =="")
{
MessageBox("請選擇學籍狀態");
this->UpdateData(false);
return;
}
CString sqlt;
sqlt.Format("UPDATE Student SET S_Zt='%s' WHERE S_ID='%s'",m_Xfx_Xjzt,m_Xfx_ID);
m_parent->m_conn->Execute(sqlt);
sqlt.Format("INSERT INTO XfxTable(S_ID,XFX_Lx,XFX_Date,XFX_Yy,XFX_Bz,XFX_Jsr) VALUES('%s','%s',DATE(),'%s','%s','%s')"\
,m_Xfx_ID,m_Xfx_Lx,m_Xfx_Yy,m_Xfx_Bz,m_Xfx_Jsr);
m_parent->m_conn->Execute(sqlt);
RefreshXfx(m_Xfx_ID);
this->UpdateData(false);
}
void CXjXfxDlg::OnBuXfxDel()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
m_Xfx_ID.TrimLeft();
m_Xfx_ID.TrimRight();
if(m_Xfx_ID == "")
{
MessageBox("請選擇學生");
this->UpdateData(false);
return;
}
int index =m_XfxList.GetSelectionMark();
if(index<0)
{
MessageBox("請選擇異動行");
this->UpdateData(false);
return;
}
CString sqlt;
sqlt.Format("DELETE FROM XfxTable WHERE XFX_ID=%s",m_XfxList.GetItemText(index,0));
m_parent->m_conn->Execute(sqlt);
RefreshXfx(m_Xfx_ID);
}
void CXjXfxDlg::OnBuXfxSave()
{
// TODO: Add your control notification handler code here
this->UpdateData(true);
m_Xfx_ID.TrimLeft();
m_Xfx_ID.TrimRight();
if(m_Xfx_ID == "")
{
MessageBox("請選擇學生");
this->UpdateData(false);
return;
}
int index = m_XfxList.GetSelectionMark();
if(index<0)
{
MessageBox("請選擇異動行");
this->UpdateData(false);
return;
}
m_Xfx_Lx.TrimLeft();
m_Xfx_Lx.TrimRight();
if(m_Xfx_Lx =="")
{
MessageBox("請選擇類型");
this->UpdateData(false);
return;
}
m_Xfx_Yy.TrimLeft();
m_Xfx_Yy.TrimRight();
if(m_Xfx_Yy =="")
{
MessageBox("請輸入原因");
this->UpdateData(false);
return;
}
m_Xfx_Jsr.TrimLeft();
m_Xfx_Jsr.TrimRight();
if(m_Xfx_Jsr =="")
{
MessageBox("請輸入經手人");
this->UpdateData(false);
return;
}
m_Xfx_Xjzt.TrimLeft();
m_Xfx_Xjzt.TrimRight();
if(m_Xfx_Xjzt =="")
{
MessageBox("請選擇學籍狀態");
this->UpdateData(false);
return;
}
CString sqlt;
sqlt.Format("UPDATE XfxTable SET XFX_Lx='%s',XFX_Yy='%s',XFX_Bz='%s',XFX_Jsr='%s' WHERE XFX_ID=%s"\
,m_Xfx_Lx,m_Xfx_Yy,m_Xfx_Bz,m_Xfx_Jsr,m_XfxList.GetItemText(index,0));
m_parent->m_conn->Execute(sqlt);
sqlt.Format("UPDATE Student SET S_Zt='%s' WHERE S_ID='%s'"\
,m_Xfx_Xjzt,m_Xfx_ID);
m_parent->m_conn->Execute(sqlt);
RefreshXfx(m_Xfx_ID);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -