📄 gzcrdlg.cpp
字号:
CString m_edit8;
CString m_edit9;
CString m_edit10;
CString m_edit11;
CString m_edit12;
CString m_edit13;
CString m_edit14;
CString m_edit15;
CString m_edit16;
CString m_edit17;
CString m_edit18;
CString m_edit19;
CString m_edit20;
CString m_edit29;
CString m_edit32;
CString m_edit36;
GetDlgItemText(IDC_EDIT1,m_edit1);
GetDlgItemText(IDC_EDIT2,m_edit2);
GetDlgItemText(IDC_EDIT3,m_edit3);
GetDlgItemText(IDC_EDIT4,m_edit4);
GetDlgItemText(IDC_EDIT5,m_edit5);
GetDlgItemText(IDC_EDIT6,m_edit6);
GetDlgItemText(IDC_EDIT7,m_edit7);
GetDlgItemText(IDC_EDIT8,m_edit8);
GetDlgItemText(IDC_EDIT9,m_edit9);
GetDlgItemText(IDC_EDIT10,m_edit10);
GetDlgItemText(IDC_EDIT11,m_edit11);
GetDlgItemText(IDC_EDIT12,m_edit12);
GetDlgItemText(IDC_EDIT13,m_edit13);
GetDlgItemText(IDC_EDIT14,m_edit14);
GetDlgItemText(IDC_EDIT15,m_edit15);
GetDlgItemText(IDC_EDIT16,m_edit16);
GetDlgItemText(IDC_EDIT17,m_edit17);
GetDlgItemText(IDC_EDIT18,m_edit18);
GetDlgItemText(IDC_EDIT19,m_edit19);
GetDlgItemText(IDC_EDIT20,m_edit20);
GetDlgItemText(IDC_EDIT29,m_edit29);
GetDlgItemText(IDC_EDIT32,m_edit32);
GetDlgItemText(IDC_EDIT36,m_edit36);
double fData1;
double fData2;
fData1=atof(m_edit1)+atof(m_edit2)+atof(m_edit3)+atof(m_edit4)+atof(m_edit5)+atof(m_edit6)
+atof(m_edit7)+atof(m_edit8)+atof(m_edit9)+atof(m_edit10)+atof(m_edit11)+atof(m_edit12)
+atof(m_edit29)+atof(m_edit32)+atof(m_edit36);
m_edit13.Format("%.2f",fData1);
SetDlgItemText(IDC_EDIT13,m_edit13);
fData2=fData1-atof(m_edit14)-atof(m_edit15)-atof(m_edit16)-atof(m_edit17)-atof(m_edit18);
m_edit19.Format("%.2f",fData2);
SetDlgItemText(IDC_EDIT19,m_edit19);
}
void Cgzcrdlg::OnButton5()
{
CFileDialog dlg(TRUE);
dlg.m_ofn.lpstrTitle="我的文件打开对话框";
dlg.m_ofn.lpstrFilter="Text Files(*.txt)\0*.txt\0All Files(*.*)\0*.*\0\0";
if(dlg.DoModal()==IDOK)
{
CString m_edit33;
CString m_FilePath = dlg.GetPathName();//取得文件路径及文件名
CStdioFile File;
File.Open(m_FilePath,CFile::modeRead); //以读模式打开文本文件
File.Seek(-8,CFile::end);///从文件末尾往上移动7字节
CString FileData;//定义一个CString变量作为缓冲区
File.ReadString(FileData);
m_edit33=FileData;
SetDlgItemText(IDC_EDIT33,m_edit33);
File.Close ;
UpdateData(FALSE);
}
}
void Cgzcrdlg::OnButton6()
{
UpdateData(TRUE);
//保存记录文件
// if(m_name!=_T(""))
// {
CString str;
CString m_edit36;
GetDlgItemText(IDC_EDIT36,m_edit36);
CStdioFile mFile;
CFileException mExcept;
if(!mFile.Open("基金累积表.txt",CFile::modeWrite,&mExcept))
mFile.Open("基金累积表.txt",CFile::modeCreate|CFile::modeWrite,&mExcept);
mFile.SeekToEnd();
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
str.Format("%s\n",m_edit36);
mFile.WriteString(str);
mFile.Close;
// }
// else AfxMessageBox("请输入姓名!");
}
void Cgzcrdlg::OnChangeEdit35()
{
CString m_edit33;
CString m_edit34;
CString m_edit35;
CString m_edit36;
GetDlgItemText(IDC_EDIT33,m_edit33);
GetDlgItemText(IDC_EDIT34,m_edit34);
GetDlgItemText(IDC_EDIT35,m_edit35);
GetDlgItemText(IDC_EDIT36,m_edit36);
double fData33 = atof(m_edit33);
double fData34 = atof(m_edit34);
double fData35 = atof(m_edit35);
double fData36;
fData36 = fData33+(120*fData34+0.2*fData35)*1/12;
m_edit36.Format("%.2f",fData36);
SetDlgItemText(IDC_EDIT36,m_edit36);
}
void Cgzcrdlg::OnButton8()
{
Cgzlldlg dlg;
dlg.DoModal();
}
void Cgzcrdlg::OnButton7()
{
Cjjljdlg dlg;
dlg.DoModal();
}
void Cgzcrdlg::OnButton1()
{
WinExec("Calc1.exe", SW_SHOW);
}
void Cgzcrdlg::OnButton10()
{
UpdateData(TRUE);
CString m_list1;
CString m_edit1;
CString m_edit2;
CString m_edit3;
CString m_edit4;
CString m_edit5;
CString m_edit6;
CString m_edit7;
CString m_edit8;
CString m_edit9;
CString m_edit10;
CString m_edit11;
CString m_edit29;
CString m_edit12;
CString m_edit32;
CString m_edit36;
CString m_edit13;
CString m_edit14;
CString m_edit15;
CString m_edit16;
CString m_edit17;
CString m_edit18;
CString m_edit19;
CString str;
CTime t=CTime::GetCurrentTime();
str.Format("%d-%d-%d",t.GetYear(),t.GetMonth(),t.GetDay());
SetDlgItemText(IDC_EDIT24,str);
UpdateData(FALSE);
SetDlgItemText(IDC_EDIT8,"35");
SetDlgItemText(IDC_EDIT9,"120");
GetDlgItemText(IDC_COMBO1,m_list1);
GetDlgItemText(IDC_EDIT1,m_edit1);
GetDlgItemText(IDC_EDIT2,m_edit2);
GetDlgItemText(IDC_EDIT3,m_edit3);
GetDlgItemText(IDC_EDIT4,m_edit4);
GetDlgItemText(IDC_EDIT5,m_edit5);
GetDlgItemText(IDC_EDIT6,m_edit6);
GetDlgItemText(IDC_EDIT7,m_edit7);
GetDlgItemText(IDC_EDIT8,m_edit8);
GetDlgItemText(IDC_EDIT9,m_edit9);
GetDlgItemText(IDC_EDIT10,m_edit10);
GetDlgItemText(IDC_EDIT11,m_edit11);
GetDlgItemText(IDC_EDIT29,m_edit29);
GetDlgItemText(IDC_EDIT12,m_edit12);
GetDlgItemText(IDC_EDIT32,m_edit32);
GetDlgItemText(IDC_EDIT36,m_edit36);
GetDlgItemText(IDC_EDIT13,m_edit13);
GetDlgItemText(IDC_EDIT14,m_edit14);
GetDlgItemText(IDC_EDIT15,m_edit15);
GetDlgItemText(IDC_EDIT16,m_edit16);
GetDlgItemText(IDC_EDIT17,m_edit17);
GetDlgItemText(IDC_EDIT18,m_edit18);
GetDlgItemText(IDC_EDIT19,m_edit19);
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql;
sql.Format("select* from employees order by id desc");
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
//m_pRecordset->MoveFirst();
m_pRecordset->Move(2);
//m_pRecordset->MoveLast();
// m_pRecordset->Move((long)pos,vtMissing);
// m_pRecordset->AddNew();
m_pRecordset->PutCollect("name",(_bstr_t)m_list1);
m_pRecordset->PutCollect("a1",(_bstr_t)m_edit1);
m_pRecordset->PutCollect("a2",(_bstr_t)m_edit2);
m_pRecordset->PutCollect("a3",(_bstr_t)m_edit3);
m_pRecordset->PutCollect("a4",(_bstr_t)m_edit4);
m_pRecordset->PutCollect("a5",(_bstr_t)m_edit5);
m_pRecordset->PutCollect("a6",(_bstr_t)m_edit6);
m_pRecordset->PutCollect("a7",(_bstr_t)m_edit7);
m_pRecordset->PutCollect("a8",(_bstr_t)m_edit8);
m_pRecordset->PutCollect("a9",(_bstr_t)m_edit9);
m_pRecordset->PutCollect("a10",(_bstr_t)m_edit10);
m_pRecordset->PutCollect("a11",(_bstr_t)m_edit11);
m_pRecordset->PutCollect("a12",(_bstr_t)m_edit29);
m_pRecordset->PutCollect("a13",(_bstr_t)m_edit12);
m_pRecordset->PutCollect("a14",(_bstr_t)m_edit32);
m_pRecordset->PutCollect("a15",(_bstr_t)m_edit36);
m_pRecordset->PutCollect("s1",(_bstr_t)m_edit13);
m_pRecordset->PutCollect("b1",(_bstr_t)m_edit14);
m_pRecordset->PutCollect("b2",(_bstr_t)m_edit15);
m_pRecordset->PutCollect("b3",(_bstr_t)m_edit16);
m_pRecordset->PutCollect("b4",(_bstr_t)m_edit17);
m_pRecordset->PutCollect("b5",(_bstr_t)m_edit18);
m_pRecordset->PutCollect("s2",(_bstr_t)m_edit19);
m_pRecordset->Update();
m_AdoConn.ExitConnect();
}
void Cgzcrdlg::OnButton11()
{
UpdateData(TRUE);
CString m_list1;
CString m_edit1;
CString m_edit2;
CString m_edit3;
CString m_edit4;
CString m_edit5;
CString m_edit6;
CString m_edit7;
CString m_edit8;
CString m_edit9;
CString m_edit10;
CString m_edit11;
CString m_edit29;
CString m_edit12;
CString m_edit32;
CString m_edit36;
CString m_edit13;
CString m_edit14;
CString m_edit15;
CString m_edit16;
CString m_edit17;
CString m_edit18;
CString m_edit19;
CString str;
CTime t=CTime::GetCurrentTime();
str.Format("%d-%d-%d",t.GetYear(),t.GetMonth(),t.GetDay());
SetDlgItemText(IDC_EDIT24,str);
UpdateData(FALSE);
SetDlgItemText(IDC_EDIT8,"35");
SetDlgItemText(IDC_EDIT9,"120");
GetDlgItemText(IDC_COMBO1,m_list1);
GetDlgItemText(IDC_EDIT1,m_edit1);
GetDlgItemText(IDC_EDIT2,m_edit2);
GetDlgItemText(IDC_EDIT3,m_edit3);
GetDlgItemText(IDC_EDIT4,m_edit4);
GetDlgItemText(IDC_EDIT5,m_edit5);
GetDlgItemText(IDC_EDIT6,m_edit6);
GetDlgItemText(IDC_EDIT7,m_edit7);
GetDlgItemText(IDC_EDIT8,m_edit8);
GetDlgItemText(IDC_EDIT9,m_edit9);
GetDlgItemText(IDC_EDIT10,m_edit10);
GetDlgItemText(IDC_EDIT11,m_edit11);
GetDlgItemText(IDC_EDIT29,m_edit29);
GetDlgItemText(IDC_EDIT12,m_edit12);
GetDlgItemText(IDC_EDIT32,m_edit32);
GetDlgItemText(IDC_EDIT36,m_edit36);
GetDlgItemText(IDC_EDIT13,m_edit13);
GetDlgItemText(IDC_EDIT14,m_edit14);
GetDlgItemText(IDC_EDIT15,m_edit15);
GetDlgItemText(IDC_EDIT16,m_edit16);
GetDlgItemText(IDC_EDIT17,m_edit17);
GetDlgItemText(IDC_EDIT18,m_edit18);
GetDlgItemText(IDC_EDIT19,m_edit19);
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql;
sql.Format("select* from employees order by id desc");
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
//m_pRecordset->AddNew();
// m_pRecordset->Move((long)pos,vtMissing);
m_pRecordset->PutCollect("name",(_bstr_t)m_list1);
m_pRecordset->PutCollect("a1",(_bstr_t)m_edit1);
m_pRecordset->PutCollect("a2",(_bstr_t)m_edit2);
m_pRecordset->PutCollect("a3",(_bstr_t)m_edit3);
m_pRecordset->PutCollect("a4",(_bstr_t)m_edit4);
m_pRecordset->PutCollect("a5",(_bstr_t)m_edit5);
m_pRecordset->PutCollect("a6",(_bstr_t)m_edit6);
m_pRecordset->PutCollect("a7",(_bstr_t)m_edit7);
m_pRecordset->PutCollect("a8",(_bstr_t)m_edit8);
m_pRecordset->PutCollect("a9",(_bstr_t)m_edit9);
m_pRecordset->PutCollect("a10",(_bstr_t)m_edit10);
m_pRecordset->PutCollect("a11",(_bstr_t)m_edit11);
m_pRecordset->PutCollect("a12",(_bstr_t)m_edit29);
m_pRecordset->PutCollect("a13",(_bstr_t)m_edit12);
m_pRecordset->PutCollect("a14",(_bstr_t)m_edit32);
m_pRecordset->PutCollect("a15",(_bstr_t)m_edit36);
m_pRecordset->PutCollect("s1",(_bstr_t)m_edit13);
m_pRecordset->PutCollect("b1",(_bstr_t)m_edit14);
m_pRecordset->PutCollect("b2",(_bstr_t)m_edit15);
m_pRecordset->PutCollect("b3",(_bstr_t)m_edit16);
m_pRecordset->PutCollect("b4",(_bstr_t)m_edit17);
m_pRecordset->PutCollect("b5",(_bstr_t)m_edit18);
m_pRecordset->PutCollect("s2",(_bstr_t)m_edit19);
m_pRecordset->Update();
m_AdoConn.ExitConnect();
}
void Cgzcrdlg::OnButton12()
{
// CDialog::OnInitDialog();
// TODO: Add extra initialization here
UpdateData(TRUE);
CString m_list1;
CString m_edit1;
CString m_edit2;
CString m_edit3;
CString m_edit4;
CString m_edit5;
CString m_edit6;
CString m_edit7;
CString m_edit10;
CString m_edit11;
CString m_edit29;
CString m_edit12;
CString m_edit32;
CString m_edit36;
CString m_edit13;
CString m_edit14;
CString m_edit15;
CString m_edit16;
CString m_edit17;
CString m_edit18;
CString m_edit19;
CString str;
CTime t=CTime::GetCurrentTime();
str.Format("%d-%d-%d",t.GetYear(),t.GetMonth(),t.GetDay());
SetDlgItemText(IDC_EDIT24,str);
UpdateData(FALSE);
SetDlgItemText(IDC_EDIT8,"35");
SetDlgItemText(IDC_EDIT9,"120");
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql;
sql.Format("select* from employees order by id desc");
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
//m_pRecordset->MoveFirst();
// m_pRecordset->MoveLast();
m_pRecordset->MoveNext();
// m_pRecordset->MoveNext();
// m_pRecordset->MoveNext();
// m_pRecordset->Move((long)pos,vtMissing);
// m_pRecordset->AddNew();
m_list1=((char*)(_bstr_t)m_pRecordset->GetCollect("name"));
m_edit1=((char*)(_bstr_t)m_pRecordset->GetCollect("a1"));
m_edit2=((char*)(_bstr_t)m_pRecordset->GetCollect("a2"));
m_edit3=((char*)(_bstr_t)m_pRecordset->GetCollect("a3"));
m_edit4=((char*)(_bstr_t)m_pRecordset->GetCollect("a4"));
m_edit5=((char*)(_bstr_t)m_pRecordset->GetCollect("a5"));
m_edit6=((char*)(_bstr_t)m_pRecordset->GetCollect("a6"));
m_edit7=((char*)(_bstr_t)m_pRecordset->GetCollect("a7"));
m_edit10=((char*)(_bstr_t)m_pRecordset->GetCollect("a10"));
m_edit11=((char*)(_bstr_t)m_pRecordset->GetCollect("a11"));
m_edit29=((char*)(_bstr_t)m_pRecordset->GetCollect("a12"));
m_edit12=((char*)(_bstr_t)m_pRecordset->GetCollect("a13"));
m_edit32=((char*)(_bstr_t)m_pRecordset->GetCollect("a14"));
m_edit36=((char*)(_bstr_t)m_pRecordset->GetCollect("a15"));
m_edit13=((char*)(_bstr_t)m_pRecordset->GetCollect("s1"));
m_edit14=((char*)(_bstr_t)m_pRecordset->GetCollect("b1"));
m_edit15=((char*)(_bstr_t)m_pRecordset->GetCollect("b2"));
m_edit16=((char*)(_bstr_t)m_pRecordset->GetCollect("b3"));
m_edit17=((char*)(_bstr_t)m_pRecordset->GetCollect("b4"));
m_edit18=((char*)(_bstr_t)m_pRecordset->GetCollect("b5"));
m_edit19=((char*)(_bstr_t)m_pRecordset->GetCollect("s2"));
SetDlgItemText(IDC_COMBO1,m_list1);
SetDlgItemText(IDC_EDIT1,m_edit1);
SetDlgItemText(IDC_EDIT2,m_edit2);
SetDlgItemText(IDC_EDIT3,m_edit3);
SetDlgItemText(IDC_EDIT4,m_edit4);
SetDlgItemText(IDC_EDIT5,m_edit5);
SetDlgItemText(IDC_EDIT6,m_edit6);
SetDlgItemText(IDC_EDIT7,m_edit7);
SetDlgItemText(IDC_EDIT10,m_edit10);
SetDlgItemText(IDC_EDIT11,m_edit11);
SetDlgItemText(IDC_EDIT29,m_edit29);
SetDlgItemText(IDC_EDIT12,m_edit12);
SetDlgItemText(IDC_EDIT32,m_edit32);
SetDlgItemText(IDC_EDIT36,m_edit36);
SetDlgItemText(IDC_EDIT13,m_edit13);
SetDlgItemText(IDC_EDIT14,m_edit14);
SetDlgItemText(IDC_EDIT15,m_edit15);
SetDlgItemText(IDC_EDIT16,m_edit16);
SetDlgItemText(IDC_EDIT17,m_edit17);
SetDlgItemText(IDC_EDIT18,m_edit18);
SetDlgItemText(IDC_EDIT19,m_edit19);
m_AdoConn.ExitConnect();
//return TRUE;
}
void Cgzcrdlg::OnButton13()
{
CString m_list1="123345";
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql;
sql.Format("select* from employees order by id desc");
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
m_pRecordset->MoveNext();
// m_pRecordset->AddNew();
// m_pRecordset->PutCollect("name",(_bstr_t)m_list1);
m_AdoConn.ExitConnect();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -