📄 developview.cpp
字号:
m_sex=m_pSet->m_column3;
m_num=m_pSet->m_column4;
m_dormitory=m_pSet->m_column5;
m_class=m_pSet->m_column6;
m_tel=m_pSet->m_column7;
m_mobile=m_pSet->m_E_mail;
m_Email=m_pSet->m_Mobile;
break;
}
else
{
m_pSet->MoveNext();
}
}
m_name3="";
m_num3="";
m_repair3="";
strSQL="select * from Repair";
if(m_repairSet->IsOpen()) m_repairSet->Close();
m_repairSet->Open(CRecordset::dynaset, strSQL);
while(!m_repairSet->IsEOF())
{
if(m_repairSet->m_column3==Donum)
{
m_name3=m_repairSet->m_column2;
m_num3=m_repairSet->m_column3;
m_repair3=m_repairSet->m_column5;
break;
}
else
{
m_repairSet->MoveNext();
}
}
}
*pResult = 0;
}
void CDevelopView::OnSelectName()
{
int searcher;
WorkModel=1;
searcher=0;
CSelectDlg selectOK;
if(selectOK.DoModal()==IDOK)
{
strSQL="select * from Informatiom";//~~~~
if(m_pSet->IsOpen()) m_pSet->Close();
m_pSet->Open(CRecordset::dynaset, strSQL);
strSQL="select * from Repair";//~~~~
if(m_repairSet->IsOpen()) m_repairSet->Close();
m_repairSet->Open(CRecordset::dynaset, strSQL);
strSQL="select * from Encourage";//~~~~
if(m_encourageSet->IsOpen()) m_encourageSet->Close();
m_encourageSet->Open(CRecordset::dynaset, strSQL);
m_pSet->MoveFirst(); //~~~
while(!m_pSet->IsEOF())
{
if(m_pSet->m_column2==Selecter)
{
searcher=1;
m_name=m_pSet->m_column2;
m_sex=m_pSet->m_column3;
m_num=m_pSet->m_column4;
m_dormitory=m_pSet->m_column5;
m_class=m_pSet->m_column6;
m_tel=m_pSet->m_column7;
m_mobile=m_pSet->m_E_mail;
m_Email=m_pSet->m_Mobile;
break;
}
else
{
m_pSet->MoveNext();
}
}
m_encourageSet->MoveFirst(); //~~~
m_name2="";
m_num2="";
m_encourage2="";
while(!m_encourageSet->IsEOF())
{
if(m_encourageSet->m_column3==m_num)
{
m_name2=m_encourageSet->m_column2;
m_num2=m_encourageSet->m_column3;
m_encourage2=m_encourageSet->m_column5;
break;
}
else
{
m_encourageSet->MoveNext();
}
}
m_repairSet->MoveFirst(); //~~~
m_name3="";
m_num3="";
m_repair3="";
while(!m_repairSet->IsEOF())
{
if(m_repairSet->m_column3==m_num)
{
m_name3=m_repairSet->m_column2;
m_num3=m_repairSet->m_column3;
m_repair3=m_repairSet->m_column5;
break;
}
else
{
m_repairSet->MoveNext();
}
}
if(searcher==1)
{
WorkModelinfo=2;
CShowinfo info;
info.DoModal();
}
else
{
MessageBox("没有这个记录！");
}
}
}
void CDevelopView::OnSelectNum()
{
int searcher;
searcher=0;
WorkModel=2;
CSelectDlg selectOK;
if(selectOK.DoModal()==IDOK)
{
strSQL="select * from Informatiom";//~~~~
if(m_pSet->IsOpen()) m_pSet->Close();
m_pSet->Open(CRecordset::dynaset, strSQL);
strSQL="select * from Repair";//~~~~
if(m_repairSet->IsOpen()) m_repairSet->Close();
m_repairSet->Open(CRecordset::dynaset, strSQL);
strSQL="select * from Encourage";//~~~~
if(m_encourageSet->IsOpen()) m_encourageSet->Close();
m_encourageSet->Open(CRecordset::dynaset, strSQL);
m_pSet->MoveFirst(); //~~~
while(!m_pSet->IsEOF())
{
if(m_pSet->m_column4==Selecter)
{
searcher=1;
m_name=m_pSet->m_column2;
m_sex=m_pSet->m_column3;
m_num=m_pSet->m_column4;
m_dormitory=m_pSet->m_column5;
m_class=m_pSet->m_column6;
m_tel=m_pSet->m_column7;
m_mobile=m_pSet->m_E_mail;
m_Email=m_pSet->m_Mobile;
break;
}
else
{
m_pSet->MoveNext();
}
}
m_encourageSet->MoveFirst(); //~~~
m_name2="";
m_num2="";
m_encourage2="";
while(!m_encourageSet->IsEOF())
{
if(m_encourageSet->m_column3==m_num)
{
m_name2=m_encourageSet->m_column2;
m_num2=m_encourageSet->m_column3;
m_encourage2=m_encourageSet->m_column5;
break;
}
else
{
m_encourageSet->MoveNext();
}
}
m_repairSet->MoveFirst(); //~~~
m_name3="";
m_num3="";
m_repair3="";
while(!m_repairSet->IsEOF())
{
if(m_repairSet->m_column3==m_num)
{
m_name3=m_repairSet->m_column2;
m_num3=m_repairSet->m_column3;
m_repair3=m_repairSet->m_column5;
break;
}
else
{
m_repairSet->MoveNext();
}
}
if(searcher==1)
{
WorkModelinfo=2;
CShowinfo info;
info.DoModal();
}
else
{
MessageBox("没有这个记录！");
}
}
}
void CDevelopView::OnFileLook()
{
WorkModelinfo=2;
CShowinfo info;
}
void CDevelopView::OnFileDel()
{
CDelDlg deldlg;
if(deldlg.DoModal()==IDOK)
{
if(table=="Informatiom") //若所选表格为Informatiom
{
strSQL="select * from Informatiom";//~~~~
if(m_pSet->IsOpen()) m_pSet->Close();
m_pSet->Open(CRecordset::dynaset, strSQL);
while(!m_pSet->IsEOF())
{
if(m_pSet->m_column4==m_num)
{
m_pSet->Delete();
m_pSet->MoveNext();
if(m_pSet->IsEOF())
m_pSet->MoveLast();
if(m_pSet->IsEOF())
m_pSet->SetFieldNull(NULL);
UpdateData(FALSE);
break;
}
else
{
m_pSet->MoveNext();
}
}
strSQL="select * from Repair";//~~~~
if(m_repairSet->IsOpen()) m_repairSet->Close();
m_repairSet->Open(CRecordset::dynaset, strSQL);
while(!m_repairSet->IsEOF())
{
if(m_repairSet->m_column3==m_num)
{
m_repairSet->Delete();
m_repairSet->MoveNext();
if(m_repairSet->IsEOF())
m_repairSet->MoveLast();
if(m_repairSet->IsEOF())
m_repairSet->SetFieldNull(NULL);
UpdateData(FALSE);
break;
}
else
{
m_repairSet->MoveNext();
}
}
strSQL="select * from Encourage";//~~~~
if(m_encourageSet->IsOpen()) m_encourageSet->Close();
m_encourageSet->Open(CRecordset::dynaset, strSQL);
while(!m_encourageSet->IsEOF())
{
if(m_encourageSet->m_column3==m_num)
{
m_encourageSet->Delete();
m_encourageSet->MoveNext();
if(m_encourageSet->IsEOF())
m_encourageSet->MoveLast();
if(m_encourageSet->IsEOF())
m_encourageSet->SetFieldNull(NULL);
UpdateData(FALSE);
break;
}
else
{
m_encourageSet->MoveNext();
}
}
m_name="";
m_num="";
m_sex="";
m_class="";
m_dormitory="";
m_tel="";
m_mobile="";
m_Email="";
m_name2="";
m_num2="";
m_encourage2="";
m_name3="";
m_num3="";
m_repair3="";
HTREEITEM root=m_tree1.GetSelectedItem();//删除后重画list
if(!m_tree1.ItemHasChildren(root))
{
m_list1.DeleteAllItems();
while(m_list1.DeleteColumn(0));
UpdateWindow();
}
CRect rect;
m_list1.GetWindowRect(rect);
BeginWaitCursor();
if(!m_pSet->IsEOF())
{
m_pSet->MoveLast();
m_pSet->MoveFirst();
}
int nFieldCount = m_pSet->GetODBCFieldCount();
CODBCFieldInfo fieldinfo;
for(int n=0;n<nFieldCount;n++)
{
m_pSet->GetODBCFieldInfo(n, fieldinfo);
int nWidth = m_list1.GetStringWidth(fieldinfo.m_strName) + 15;
m_list1.InsertColumn(n, fieldinfo.m_strName, LVCFMT_LEFT, nWidth);
}
CString strValue;
m_pSet->MoveFirst();
int nCount = 0;
while(!m_pSet->IsEOF())
{
m_list1.InsertItem(nCount, strValue);
for(int j=0;j<nFieldCount;j++)
{
m_pSet->GetFieldValue(j, strValue);
m_list1.SetItemText(nCount, j, strValue);
}
m_pSet->MoveNext();
nCount ++;
}
}
else if(table=="Repair")//若所选表格为Repair
{
m_repairSet->Delete();
m_repairSet->MoveNext();
if(m_repairSet->IsEOF())
m_repairSet->MoveLast();
if(m_repairSet->IsEOF())
m_repairSet->SetFieldNull(NULL);
UpdateData(FALSE);
HTREEITEM root=m_tree1.GetSelectedItem();//删除后重画list
if(!m_tree1.ItemHasChildren(root))
{
m_list1.DeleteAllItems();
while(m_list1.DeleteColumn(0));
UpdateWindow();
}
CRect rect;
m_list1.GetWindowRect(rect);
BeginWaitCursor();
if(!m_repairSet->IsEOF())
{
m_repairSet->MoveLast();
m_repairSet->MoveFirst();
}
int nFieldCount = m_repairSet->GetODBCFieldCount();
CODBCFieldInfo fieldinfo;
for(int n=0;n<nFieldCount;n++)
{
m_repairSet->GetODBCFieldInfo(n, fieldinfo);
int nWidth = m_list1.GetStringWidth(fieldinfo.m_strName) + 15;
m_list1.InsertColumn(n, fieldinfo.m_strName, LVCFMT_LEFT, nWidth);
}
CString strValue;
m_repairSet->MoveFirst();
int nCount = 0;
while(!m_repairSet->IsEOF())
{
m_list1.InsertItem(nCount, strValue);
for(int j=0;j<nFieldCount;j++)
{
m_repairSet->GetFieldValue(j, strValue);
m_list1.SetItemText(nCount, j, strValue);
}
m_repairSet->MoveNext();
nCount ++;
}
}
else if(table=="Encourage")//若所选表格为Encourage
{
m_encourageSet->Delete();
m_encourageSet->MoveNext();
if(m_encourageSet->IsEOF())
m_encourageSet->MoveLast();
if(m_encourageSet->IsEOF())
m_encourageSet->SetFieldNull(NULL);
UpdateData(FALSE);
HTREEITEM root=m_tree1.GetSelectedItem();//删除后重画list
if(!m_tree1.ItemHasChildren(root))
{
m_list1.DeleteAllItems();
while(m_list1.DeleteColumn(0));
UpdateWindow();
}
CRect rect;
m_list1.GetWindowRect(rect);
BeginWaitCursor();
if(!m_repairSet->IsEOF())
{
m_repairSet->MoveLast();
m_repairSet->MoveFirst();
}
int nFieldCount = m_repairSet->GetODBCFieldCount();
CODBCFieldInfo fieldinfo;
for(int n=0;n<nFieldCount;n++)
{
m_encourageSet->GetODBCFieldInfo(n, fieldinfo);
int nWidth = m_list1.GetStringWidth(fieldinfo.m_strName) + 15;
m_list1.InsertColumn(n, fieldinfo.m_strName, LVCFMT_LEFT, nWidth);
}
CString strValue;
m_encourageSet->MoveFirst();
int nCount = 0;
while(!m_repairSet->IsEOF())
{
m_list1.InsertItem(nCount, strValue);
for(int j=0;j<nFieldCount;j++)
{
m_encourageSet->GetFieldValue(j, strValue);
m_list1.SetItemText(nCount, j, strValue);
}
m_encourageSet->MoveNext();
nCount ++;
}
}
}
}
void CDevelopView::OnFileCreat()
{
WorkModelinfo=1;
CShowinfo info;
if(info.DoModal()==IDOK)
{
strSQL="select * from Informatiom";//添加记录Informatiom
if(m_pSet->IsOpen()) m_pSet->Close();
m_pSet->Open(CRecordset::dynaset, strSQL);
m_pSet->AddNew();
m_pSet->m_column2=m_name;
m_pSet->m_column3=m_num;
m_pSet->m_column4=m_sex;
m_pSet->m_column5=m_class;
m_pSet->m_column6=m_dormitory;
m_pSet->m_column7=m_tel;
m_pSet->m_E_mail=m_Email;
m_pSet->m_Mobile=m_mobile;
m_pSet->Update();
m_pSet->MoveLast();
m_name="";
m_sex="";
m_num="";
m_dormitory="";
m_class="";
m_tel="";
m_mobile="";
m_Email="";
if (have_encourage==1)//添加记录encourage
{
strSQL="select * from Encourage";
if(m_encourageSet->IsOpen()) m_encourageSet->Close();
m_encourageSet->Open(CRecordset::dynaset, strSQL);
m_encourageSet->AddNew();
m_encourageSet->m_column2=m_name2;
m_encourageSet->m_column3=m_num2;
m_encourageSet->m_column5=m_encourage2;
m_encourageSet->Update();
m_encourageSet->MoveLast();
m_name2="";
m_num2="";
m_encourage2="";
}
if (have_repair==1)//添加记录repair
{
strSQL="select * from Repair";
if(m_repairSet->IsOpen()) m_repairSet->Close();
m_repairSet->Open(CRecordset::dynaset, strSQL);
m_encourageSet->AddNew();
m_repairSet->m_column2=m_name3;
m_repairSet->m_column3=m_num3;
m_repairSet->m_column5=m_repair3;
m_repairSet->Update();
m_repairSet->MoveLast();
m_name3="";
m_num3="";
m_repair3="";
}
}
UpdateWindow();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -