📄 tuipiaodjdlg.cpp
字号:
// tuipiaodjdlg.cpp : implementation file
//
#include "stdafx.h"
#include "HKGL.h"
#include "tuipiaodjdlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// Ctuipiaodjdlg dialog
Ctuipiaodjdlg::Ctuipiaodjdlg(CWnd* pParent /*=NULL*/)
: CDialog(Ctuipiaodjdlg::IDD, pParent)
{
//{{AFX_DATA_INIT(Ctuipiaodjdlg)
m_hbnum = _T("");
m_ckid = _T("");
m_find = _T("");
m_tpje = 0;
m_tpdjrtn = 2;
m_zuowei = _T("");
m_mpzuohao = _T("");
//}}AFX_DATA_INIT
}
void Ctuipiaodjdlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(Ctuipiaodjdlg)
DDX_Control(pDX, IDC_COMBO4, m_tpshijiancom);
DDX_Control(pDX, IDC_LIST2, m_tphbList);
DDX_Control(pDX, IDC_LIST1, m_tpdjList);
DDX_Control(pDX, IDC_COMBO2, m_com2);
DDX_Control(pDX, IDC_COMBO1, m_com1);
DDX_Text(pDX, IDC_EDIT1, m_hbnum);
DDX_Text(pDX, IDC_EDIT2, m_ckid);
DDX_Text(pDX, IDC_EDIT6, m_find);
DDX_Text(pDX, IDC_EDIT7, m_tpje);
DDX_Radio(pDX, IDC_RADIO1, m_tpdjrtn);
DDX_Text(pDX, IDC_EDIT4, m_zuowei);
DDX_Text(pDX, IDC_EDIT5, m_mpzuohao);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(Ctuipiaodjdlg, CDialog)
//{{AFX_MSG_MAP(Ctuipiaodjdlg)
ON_BN_CLICKED(IDC_tpdjbtn, Ontpdjbtn)
ON_BN_CLICKED(IDC_Findbtn, OnFindbtn)
ON_WM_TIMER()
ON_BN_CLICKED(IDC_jisuanbtn, Onjisuanbtn)
ON_BN_CLICKED(IDC_Clear, OnClear)
ON_BN_CLICKED(IDC_czck, Onczck)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// Ctuipiaodjdlg message handlers
BOOL Ctuipiaodjdlg::OnInitDialog()
{
CDialog::OnInitDialog();
Changban_Recordset m_hb(&theApp.m_DB );
CCK_Recordset m_ck(&theApp.m_DB );
CTP_Recordset m_tp(&theApp.m_DB );
m_com1.SetCurSel(0);
m_com2.SetCurSel(1);
m_tpshijiancom.SetCurSel(1);
m_tphbList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
m_tphbList.InsertColumn(0,"航班编号",LVCFMT_LEFT,80);
m_tphbList.InsertColumn(1,"起始地",LVCFMT_LEFT,70);
m_tphbList.InsertColumn(2,"起飞时间",LVCFMT_LEFT,80);
m_tphbList.InsertColumn(3,"目的地",LVCFMT_LEFT,70);
m_tphbList.InsertColumn(4,"到达时间",LVCFMT_LEFT,80);
m_tphbList.InsertColumn(5,"一仓余票",LVCFMT_LEFT,80);
m_tphbList.InsertColumn(6,"二仓余票",LVCFMT_LEFT,80);
m_tphbList.InsertColumn(7,"三仓余票",LVCFMT_LEFT,80);
m_tphbList.InsertColumn(8,"日期",LVCFMT_LEFT,60);
///////////////////
int i=0;
CODBCFieldInfo Info;
m_tpdjList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
m_tp.Open();
for(i=0;i<m_tp.m_nFields;i++)
{
m_tp.GetODBCFieldInfo(i,Info);
m_tpdjList.InsertColumn(i,Info.m_strName,LVCFMT_LEFT,110);
}
m_tp.Close();
if(m_tp.IsOpen())m_tp.Close();
m_Ftp=TRUE;
this->Show();
this->Show2();
m_Ftp=FALSE;
SetTimer(1,2,NULL);
return TRUE;
}
void Ctuipiaodjdlg::OnFindbtn()
{
UpdateData(TRUE);
m_com1.GetLBText(m_com1.GetCurSel(),m_comstr1);
m_com2.GetLBText(m_com2.GetCurSel(),m_comstr2);
if(m_hb.IsOpen())m_hb.Close();
m_hb.Open();
if(m_tp.IsOpen())m_tp.Close();
m_tp.Open();
if(m_comstr1=="编号查询")
{
m_hb.m_strFilter.Format("[航班编号] Like '%%"+ m_find+"%%'");
m_tphbList.DeleteAllItems();
m_tp.m_strFilter.Format("[航班编号] Like '%%"+ m_find+"%%'");
m_tpdjList.DeleteAllItems();
}
else if(m_comstr1=="时间查询")
{
m_hb.m_strFilter.Format("[时间] ='"+m_comstr2+"'");
m_tphbList.DeleteAllItems();
m_tp.m_strFilter.Format("[退票时间] ='"+m_comstr2+"'");
m_tpdjList.DeleteAllItems();
}
m_hb.Requery();
m_tp.Requery();
if(m_hb.IsEOF() && m_tp.IsEOF())
{
AfxMessageBox("没有没有你要得信息!");
return ;
}
if(m_hb.IsEOF())
{
m_hb.Close();
AfxMessageBox("没有该时间航班!");
return ;
}
else
this->Show2();
if(m_tp.IsEOF())
{
m_tp.Close();
AfxMessageBox("该时间航班没退票!");
}
else
this->Show();
}
int Ctuipiaodjdlg::Show()
{
int i=0;
if(m_Ftp==TRUE)m_tp.Open();
m_tp.MoveFirst();
do
{
m_tpdjList.InsertItem(i,m_tp.m_column1 );
m_tpdjList.SetItemText(i,1,m_tp.m_column2 );
CString s;
s.Format("%d",m_tp.m_column3);
m_tpdjList.SetItemText(i,2,s );
m_tpdjList.SetItemText(i,3,m_tp.m_column4 );
i++;
m_tp.MoveNext();
}while(!m_tp.IsEOF());
m_tp.Close();
return i;
}
void Ctuipiaodjdlg::OnTimer(UINT nIDEvent)
{
CString s;
m_com1.GetLBText(m_com1.GetCurSel(),s);
if(s=="时间查询")
{
GetDlgItem(IDC_EDIT6)->EnableWindow(FALSE);
m_com2.EnableWindow(TRUE);
}
else
{
GetDlgItem(IDC_EDIT6)->EnableWindow(TRUE);
m_com2.EnableWindow(FALSE);
}
CDialog::OnTimer(nIDEvent);
}
int Ctuipiaodjdlg::Show2()
{
int j=0;
if(m_Ftp==TRUE)m_hb.Open();
m_hb.MoveFirst();
do
{
CString s;
m_tphbList.InsertItem(j,m_hb.m_column1 );
m_tphbList.SetItemText(j,1,m_hb.m_column3 );
m_tphbList.SetItemText(j,2,m_hb.m_column4 );
m_tphbList.SetItemText(j,3,m_hb.m_column5);
m_tphbList.SetItemText(j,4,m_hb.m_column6);
s.Format("%d",m_hb.m_column9);
m_tphbList.SetItemText(j,5,s);
s.Format("%d",m_hb.m_column13);
m_tphbList.SetItemText(j,6,s);
s.Format("%d",m_hb.m_column17);
m_tphbList.SetItemText(j,7,s);
m_tphbList.SetItemText(j,8,m_hb.m_column22);
j++;
m_hb.MoveNext();
}while(!m_hb.IsEOF());
m_hb.Close();
return j;
}
void Ctuipiaodjdlg::Onjisuanbtn() //////////////////////////////////////////
{
UpdateData(TRUE);
if(m_hbnum==""||m_ckid==""||m_zuowei=="")
{
MessageBox("请检查你的输入项!");
return ;
}
if(m_ck.IsOpen())m_ck.Close();
m_ck.Open();
m_ck.m_strFilter.Format ("[身份证号]='"+ m_ckid+"' and [航班编号]='"+ m_hbnum+"'");
m_ck.Requery();
if(m_ck.IsEOF())
{
m_hb.Close();
m_ck.Close();
MessageBox("没有你要的信息!");
OnClear();
return ;
}
else
{
if(m_tpdjrtn==0)//一等仓
{
if(m_hb.IsOpen())m_hb.Close();
m_hb.Open();
m_hb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
m_hb.Requery();
m_tpje=m_hb.m_column7 ;
m_hb.Close();
}
else if(m_tpdjrtn==1)
{
if(m_hb.IsOpen())m_hb.Close();
m_hb.Open();
m_hb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
m_hb.Requery();
m_tpje=m_hb.m_column11 ;
m_hb.Close();
}
else
{
if(m_hb.IsOpen())m_hb.Close();
m_hb.Open();
m_hb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
m_hb.Requery();
m_tpje=m_hb.m_column15 ;
m_hb.Close();
}
}
UpdateData(FALSE);
}
void Ctuipiaodjdlg::Ontpdjbtn() //////////////////////////////////////////////
{
UpdateData(TRUE);
if(m_hbnum==""||m_ckid==""||m_zuowei=="")
{
MessageBox("请检查你的输入项!");
return ;
}
if(m_ck.IsOpen())m_ck.Close();
m_ck.Open();
m_ck.m_strFilter.Format ("[身份证号]='"+ m_ckid+"' and [航班编号]='"+ m_hbnum+"'");
m_ck.Requery();
if(m_ck.IsEOF())
{
m_hb.Close();
m_ck.Close();
MessageBox("没有你要的信息!");
OnClear();
return ;
}
else
{
if(m_tpdjrtn==0)//一等仓
{
int dj=0;
CString shijian;
if(m_hb.IsOpen())m_hb.Close();
m_hb.Open();
m_hb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
m_hb.Requery();
m_hb.Edit();
m_hb.m_column8-=1;
m_hb.m_column9+=1;
m_hb.m_column10-=m_hb.m_column7 ;
dj=m_hb.m_column7 ;
shijian=m_hb.m_column22;
m_hb.Update();
m_hb.Close();
//////////////////////////////////////////////////////////////
if(m_ck.IsOpen())m_ck.Close();
m_ck.Open();
m_ck.m_strFilter.Format ("[身份证号]='"+ m_ckid+"' and [航班编号]='"+ m_hbnum+"'");
m_ck.Delete();
m_ck.Requery();
m_ck.Close();
/////////////////////////////////////////
if(m_tp.IsOpen())m_tp.Close();
m_tp.Open();
m_tp.Requery();
m_tp.AddNew();
m_tp.m_column1=m_hbnum;
m_tp.m_column2="A"+m_zuowei;
m_tp.m_column3=dj;
m_tp.m_column4=shijian;
m_tp.Update();
m_tp.Close();
MessageBox("确定");
OnClear();
///////////////////////////////////////////////////////
}
else if(m_tpdjrtn==1)
{
int dj=0;
CString shijian;
if(m_hb.IsOpen())m_hb.Close();
m_hb.Open();
m_hb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
m_hb.Requery();
m_hb.Edit();
m_hb.m_column12-=1;
m_hb.m_column13+=1;
m_hb.m_column14-=m_hb.m_column11 ;
dj=m_hb.m_column11 ;
shijian=m_hb.m_column22;
m_hb.Update();
m_hb.Close();
//////////////////////////////////////////////////////////////
if(m_ck.IsOpen())m_ck.Close();
m_ck.Open();
m_ck.m_strFilter.Format ("[身份证号]='"+ m_ckid+"' and [航班编号]='"+ m_hbnum+"'");
m_ck.Delete();
m_ck.Requery();
m_ck.Close();
/////////////////////////////////////////
if(m_tp.IsOpen())m_tp.Close();
m_tp.Open();
m_tp.Requery();
m_tp.AddNew();
m_tp.m_column1=m_hbnum;
m_tp.m_column2="B"+m_zuowei;
m_tp.m_column3=dj;
m_tp.m_column4=shijian;
m_tp.Update();
m_tp.Close();
MessageBox("确定");
OnClear();
}
else
{
int dj=0;
CString shijian;
if(m_hb.IsOpen())m_hb.Close();
m_hb.Open();
m_hb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
m_hb.Requery();
m_hb.Edit();
m_hb.m_column16-=1;
m_hb.m_column17+=1;
m_hb.m_column18-=m_hb.m_column15 ;
dj=m_hb.m_column15 ;
shijian=m_hb.m_column22;
m_hb.Update();
m_hb.Close();
//////////////////////////////////////////////////////////////
if(m_ck.IsOpen())m_ck.Close();
m_ck.Open();
m_ck.m_strFilter.Format ("[身份证号]='"+ m_ckid+"' and [航班编号]='"+ m_hbnum+"'");
m_ck.Delete();
m_ck.Requery();
m_ck.Close();
/////////////////////////////////////////
if(m_tp.IsOpen())m_tp.Close();
m_tp.Open();
m_tp.Requery();
m_tp.AddNew();
m_tp.m_column1=m_hbnum;
m_tp.m_column2="C"+m_zuowei;
m_tp.m_column3=dj;
m_tp.m_column4=shijian;
m_tp.Update();
m_tp.Close();
MessageBox("确定");
OnClear();
}
}
UpdateData(FALSE);
}
void Ctuipiaodjdlg::OnClear()
{
UpdateData(TRUE);
m_hbnum="";
m_ckid="";
m_zuowei="";
m_mpzuohao="";
UpdateData(FALSE);
}
void Ctuipiaodjdlg::Onczck()
{
UpdateData(TRUE);
if(m_hbnum==""||m_ckid=="")
{
MessageBox("请检查你的输入项!");
return ;
}
if(m_ck.IsOpen())m_ck.Close();
m_ck.Open();
m_ck.m_strFilter.Format ("[身份证号]='"+ m_ckid+"' and [航班编号]='"+ m_hbnum+"'");
m_ck.Requery();
if(m_ck.IsEOF())
{
m_ck.Close();
MessageBox("没有你要的信息!");
// OnClear();
return ;
}
m_mpzuohao=m_ck.m_column4;
m_ck.Close();
UpdateData(FALSE);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -