?? queryview.cpp
字號:
UINT m_sjdata[3] = {0,0,0};
UINT m_data[3] = {0,0,0};
UINT m_sjCount[2] = {0,0};
UINT m_Count[2] = {0,0};
CStringArray m_strsjarry;
CStringArray m_strarry;
CByteArray m_bsjarry,m_barry;
///////////////////////////////////////////////////////////////
fjstrParam(myotherstate.strsjhan,' ',m_strsjarry);
for(int i=0;i<m_strsjarry.GetSize();i++)
m_sjdata[i] = atoi(m_strsjarry.GetAt(i));
fjstrParam(myotherstate.strhan,' ',m_strarry);
for(i=0;i<m_strarry.GetSize();i++)
m_data[i] = atoi(m_strarry.GetAt(i));
//所含號碼個數nCount
int nsjCount = m_strsjarry.GetSize();
int nCount = m_strarry.GetSize();
/////////////////////////////////////////////////////////
//號碼和值
int ncountsjvalue = 0;
int ncountvalue = 0;
////////////////////////////////////////////////////////////
fjstrParam(myotherstate.strsjCount ,' ' ,m_strsjarry);
if(m_strsjarry.GetSize()<2)
m_sjCount[0] = m_sjCount[1] = atoi(m_strsjarry[0]);
else
{
m_sjCount[0] = atoi(m_strsjarry[0]);
m_sjCount[1] = atoi(m_strsjarry[1]);
}
fjstrParam(myotherstate.strCount ,' ' ,m_strarry);
if(m_strarry.GetSize()<2)
m_Count[0] = m_Count[1] = atoi(m_strarry[0]);
else
{
m_Count[0] = atoi(m_strarry[0]);
m_Count[1] = atoi(m_strarry[1]);
}
/////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////
L3DDATAOTHER myl3Ddataother;
bool bstate = 0;
CString strtmp = "";
//////////////////////////////////////////////////////////////////////////////////
//以下開始判定具體的條件
while(!m_visit.m_p3dotherSet->IsEOF())
{
bstate = (myotherstate.bstartno == 0) && (myotherstate.bJiNo == 0) && (myotherstate.bQiuNo == 0) && (myotherstate.bsjhan == 0) && \
(myotherstate.bhan == 0) && (myotherstate.bsjCount == 0) &&(myotherstate.bCount == 0) && \
(myotherstate.bsjsametail == 0) && (myotherstate.bsametail == 0) && (myotherstate.bsj[0] == 0) && (myotherstate.bsj[1] == 0)\
&& (myotherstate.bsj[2] == 0) && (myotherstate.bsjds == 0) && (myotherstate.b[0] == 0) && (myotherstate.b[1] == 0 ) && \
(myotherstate.b[2] == 0) && (myotherstate.bds == 0);
if(bstate) //所有條件全部不選擇
{
myl3Ddataother.uItemNo = m_visit.m_p3dotherSet->m_ItemNo;
myl3Ddataother.uJNo = m_visit.m_p3dotherSet->m_iJiNo;
myl3Ddataother.uQNo = m_visit.m_p3dotherSet->m_iQiuNo;
myl3Ddataother.strsjbsg = m_visit.m_p3dotherSet->m_iSJHAO;
myl3Ddataother.strbsg = m_visit.m_p3dotherSet->m_iSCHAO;
myl3Ddataother.uSJBNo = m_visit.m_p3dotherSet->m_iSJBNo;
myl3Ddataother.uSJSNo = m_visit.m_p3dotherSet->m_iSJSNo;
myl3Ddataother.uSJGNo = m_visit.m_p3dotherSet->m_iSJGNo;
myl3Ddataother.uBNo = m_visit.m_p3dotherSet->m_iBNo;
myl3Ddataother.uSNo = m_visit.m_p3dotherSet->m_iSNo;
myl3Ddataother.uGNo = m_visit.m_p3dotherSet->m_iGNo;
myl3Ddataother.uSJCount = m_visit.m_p3dotherSet->m_iSJCount;;
myl3Ddataother.uCountValue = m_visit.m_p3dotherSet->m_iCount;;
my3dotherarray.Add(myl3Ddataother);
}
bstate = (myotherstate.bstartno == 0) && (myotherstate.bJiNo == 1) && (myotherstate.bQiuNo == 1) && (myotherstate.bsjhan == 0) && \
(myotherstate.bhan == 0) && (myotherstate.bsjCount == 0) &&(myotherstate.bCount == 0) && \
(myotherstate.bsjsametail == 0) && (myotherstate.bsametail == 0) && (myotherstate.bsj[0] == 0) && (myotherstate.bsj[1] == 0)\
&& (myotherstate.bsj[2] == 0) && (myotherstate.bsjds == 0) && (myotherstate.b[0] == 0) && (myotherstate.b[1] == 0 ) && \
(myotherstate.b[2] == 0) && (myotherstate.bds == 0);
if(bstate) //僅選擇機號和球號
{
strtmp = "";
UINT uj=0,uq=0;
((CEdit*)GetDlgItem(IDC_EDIT11))->GetWindowText(strtmp);
uj = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDIT12))->GetWindowText(strtmp);
uq = atoi(strtmp);
if((m_visit.m_p3dotherSet->m_iJiNo == uj) && (m_visit.m_p3dotherSet->m_iQiuNo == uq)) //找到符合機號和球號的記錄
{
myl3Ddataother.uItemNo = m_visit.m_p3dotherSet->m_ItemNo;
myl3Ddataother.uJNo = m_visit.m_p3dotherSet->m_iJiNo;
myl3Ddataother.uQNo = m_visit.m_p3dotherSet->m_iQiuNo;
myl3Ddataother.strsjbsg = m_visit.m_p3dotherSet->m_iSJHAO;
myl3Ddataother.strbsg = m_visit.m_p3dotherSet->m_iSCHAO;
myl3Ddataother.uSJBNo = m_visit.m_p3dotherSet->m_iSJBNo;
myl3Ddataother.uSJSNo = m_visit.m_p3dotherSet->m_iSJSNo;
myl3Ddataother.uSJGNo = m_visit.m_p3dotherSet->m_iSJGNo;
myl3Ddataother.uBNo = m_visit.m_p3dotherSet->m_iBNo;
myl3Ddataother.uSNo = m_visit.m_p3dotherSet->m_iSNo;
myl3Ddataother.uGNo = m_visit.m_p3dotherSet->m_iGNo;
myl3Ddataother.uSJCount = m_visit.m_p3dotherSet->m_iSJCount;
myl3Ddataother.uCountValue = m_visit.m_p3dotherSet->m_iCount;
my3dotherarray.Add(myl3Ddataother);
}
}
bstate = (myotherstate.bstartno == 0) && (myotherstate.bJiNo == 1) && (myotherstate.bQiuNo == 1) && (myotherstate.bsjhan == 1) && \
(myotherstate.bhan == 0) && (myotherstate.bsjCount == 0) &&(myotherstate.bCount == 0) && \
(myotherstate.bsjsametail == 0) && (myotherstate.bsametail == 0) && (myotherstate.bsj[0] == 0) && (myotherstate.bsj[1] == 0)\
&& (myotherstate.bsj[2] == 0) && (myotherstate.bsjds == 0) && (myotherstate.b[0] == 0) && (myotherstate.b[1] == 0 ) && \
(myotherstate.b[2] == 0) && (myotherstate.bds == 0);
if(bstate) //選擇機號和球號,選擇試機號所含號碼,查詢方式:直選
{
strtmp = "";
UINT uj=0,uq=0;
((CEdit*)GetDlgItem(IDC_EDIT11))->GetWindowText(strtmp);
uj = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDIT12))->GetWindowText(strtmp);
uq = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDIT13))->GetWindowText(myotherstate.strsjhan);
int nlen = fjstrtoUint(myotherstate.strsjhan,' ',m_bsjarry);
m_sjdata[0] = m_visit.m_p3dotherSet->m_iSJBNo;
m_sjdata[1] = m_visit.m_p3dotherSet->m_iSJSNo;
m_sjdata[2] = m_visit.m_p3dotherSet->m_iSJGNo;
if((FindSame(m_sjdata,m_bsjarry) == nlen) && (m_visit.m_p3dotherSet->m_iJiNo == uj) && (m_visit.m_p3dotherSet->m_iQiuNo == uq)) //找到符合機號和球號的記錄
{
myl3Ddataother.uItemNo = m_visit.m_p3dotherSet->m_ItemNo;
myl3Ddataother.uJNo = m_visit.m_p3dotherSet->m_iJiNo;
myl3Ddataother.uQNo = m_visit.m_p3dotherSet->m_iQiuNo;
myl3Ddataother.strsjbsg = m_visit.m_p3dotherSet->m_iSJHAO;
myl3Ddataother.strbsg = m_visit.m_p3dotherSet->m_iSCHAO;
myl3Ddataother.uSJBNo = m_visit.m_p3dotherSet->m_iSJBNo;
myl3Ddataother.uSJSNo = m_visit.m_p3dotherSet->m_iSJSNo;
myl3Ddataother.uSJGNo = m_visit.m_p3dotherSet->m_iSJGNo;
myl3Ddataother.uBNo = m_visit.m_p3dotherSet->m_iBNo;
myl3Ddataother.uSNo = m_visit.m_p3dotherSet->m_iSNo;
myl3Ddataother.uGNo = m_visit.m_p3dotherSet->m_iGNo;
myl3Ddataother.uSJCount = m_visit.m_p3dotherSet->m_iSJCount;;
myl3Ddataother.uCountValue = m_visit.m_p3dotherSet->m_iCount;;
my3dotherarray.Add(myl3Ddataother);
}
}
bstate = (myotherstate.bstartno == 0) && (myotherstate.bJiNo == 1) && (myotherstate.bQiuNo == 1) && (myotherstate.bsjhan == 0) && \
(myotherstate.bhan == 0) && (myotherstate.bsjCount == 1) &&(myotherstate.bCount == 0) && \
(myotherstate.bsjsametail == 0) && (myotherstate.bsametail == 0) && (myotherstate.bsj[0] == 0) && (myotherstate.bsj[1] == 0)\
&& (myotherstate.bsj[2] == 0) && (myotherstate.bsjds == 0) && (myotherstate.b[0] == 0) && (myotherstate.b[1] == 0 ) && \
(myotherstate.b[2] == 0) && (myotherstate.bds == 0);
if(bstate) //選擇機號和球號,選擇試機號號碼和值區域
{
strtmp = "";
UINT uj=0,uq=0;
((CEdit*)GetDlgItem(IDC_EDIT11))->GetWindowText(strtmp);
uj = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDIT12))->GetWindowText(strtmp);
uq = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDIT15))->GetWindowText(myotherstate.strsjCount);
fjstrParam(myotherstate.strsjCount ,' ' ,m_strsjarry);
if(m_strsjarry.GetSize()<2)
m_sjCount[0] = m_sjCount[1] = atoi(m_strsjarry[0]);
else
{
m_sjCount[0] = atoi(m_strsjarry[0]);
m_sjCount[1] = atoi(m_strsjarry[1]);
}
if((m_visit.m_p3dotherSet->m_iSJCount >= m_sjCount[0]) && (m_visit.m_p3dotherSet->m_iSJCount <= m_sjCount[1]) \
&& (m_visit.m_p3dotherSet->m_iJiNo == uj) && (m_visit.m_p3dotherSet->m_iQiuNo == uq)) //找到符合機號和球號,符合試機和值區域的記錄
{
myl3Ddataother.uItemNo = m_visit.m_p3dotherSet->m_ItemNo;
myl3Ddataother.uJNo = m_visit.m_p3dotherSet->m_iJiNo;
myl3Ddataother.uQNo = m_visit.m_p3dotherSet->m_iQiuNo;
myl3Ddataother.strsjbsg = m_visit.m_p3dotherSet->m_iSJHAO;
myl3Ddataother.strbsg = m_visit.m_p3dotherSet->m_iSCHAO;
myl3Ddataother.uSJBNo = m_visit.m_p3dotherSet->m_iSJBNo;
myl3Ddataother.uSJSNo = m_visit.m_p3dotherSet->m_iSJSNo;
myl3Ddataother.uSJGNo = m_visit.m_p3dotherSet->m_iSJGNo;
myl3Ddataother.uBNo = m_visit.m_p3dotherSet->m_iBNo;
myl3Ddataother.uSNo = m_visit.m_p3dotherSet->m_iSNo;
myl3Ddataother.uGNo = m_visit.m_p3dotherSet->m_iGNo;
myl3Ddataother.uSJCount = m_visit.m_p3dotherSet->m_iSJCount;;
myl3Ddataother.uCountValue = m_visit.m_p3dotherSet->m_iCount;;
my3dotherarray.Add(myl3Ddataother);
}
}
bstate = (myotherstate.bstartno == 0) && (myotherstate.bJiNo == 1) && (myotherstate.bQiuNo == 1) && (myotherstate.bsjhan == 0) && \
(myotherstate.bhan == 1) && (myotherstate.bsjCount == 0) &&(myotherstate.bCount == 0) && \
(myotherstate.bsjsametail == 0) && (myotherstate.bsametail == 0) && (myotherstate.bsj[0] == 0) && (myotherstate.bsj[1] == 0)\
&& (myotherstate.bsj[2] == 0) && (myotherstate.bsjds == 0) && (myotherstate.b[0] == 0) && (myotherstate.b[1] == 0 ) && \
(myotherstate.b[2] == 0) && (myotherstate.bds == 0);
if(bstate) //選擇機號和球號,選擇實際號所含號碼
{
strtmp = "";
UINT uj=0,uq=0;
((CEdit*)GetDlgItem(IDC_EDIT11))->GetWindowText(strtmp);
uj = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDIT12))->GetWindowText(strtmp);
uq = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDIT14))->GetWindowText(myotherstate.strhan);
int nlen = fjstrtoUint(myotherstate.strhan,' ',m_barry);
m_data[0] = m_visit.m_p3dotherSet->m_iBNo;
m_data[1] = m_visit.m_p3dotherSet->m_iSNo;
m_data[2] = m_visit.m_p3dotherSet->m_iGNo;
if((FindSame(m_data,m_barry) == nlen) && (m_visit.m_p3dotherSet->m_iJiNo == uj) && (m_visit.m_p3dotherSet->m_iQiuNo == uq)) //找到符合機號和球號的記錄
{
myl3Ddataother.uItemNo = m_visit.m_p3dotherSet->m_ItemNo;
myl3Ddataother.uJNo = m_visit.m_p3dotherSet->m_iJiNo;
myl3Ddataother.uQNo = m_visit.m_p3dotherSet->m_iQiuNo;
myl3Ddataother.strsjbsg = m_visit.m_p3dotherSet->m_iSJHAO;
myl3Ddataother.strbsg = m_visit.m_p3dotherSet->m_iSCHAO;
myl3Ddataother.uSJBNo = m_visit.m_p3dotherSet->m_iSJBNo;
myl3Ddataother.uSJSNo = m_visit.m_p3dotherSet->m_iSJSNo;
myl3Ddataother.uSJGNo = m_visit.m_p3dotherSet->m_iSJGNo;
myl3Ddataother.uBNo = m_visit.m_p3dotherSet->m_iBNo;
myl3Ddataother.uSNo = m_visit.m_p3dotherSet->m_iSNo;
myl3Ddataother.uGNo = m_visit.m_p3dotherSet->m_iGNo;
myl3Ddataother.uSJCount = m_visit.m_p3dotherSet->m_iSJCount;;
myl3Ddataother.uCountValue = m_visit.m_p3dotherSet->m_iCount;;
my3dotherarray.Add(myl3Ddataother);
}
}
//////////////////////////////////////////////////////
//其他還有一些條件暫時先不考慮
m_visit.m_p3dotherSet->MoveNext();
}
if(((CButton*)GetDlgItem(IDC_RADIO3))->GetCheck() == 1)
((CButton*)GetDlgItem(IDC_RADIO3))->SetCheck(1);
if(((CButton*)GetDlgItem(IDC_RADIO2))->GetCheck() == 1)
((CButton*)GetDlgItem(IDC_RADIO2))->SetCheck(1);
if(((CButton*)GetDlgItem(IDC_RADIO1))->GetCheck() == 1)
((CButton*)GetDlgItem(IDC_RADIO1))->SetCheck(1);
m_visit.OnClose3DOther();
}
//根據所給定的所有條件進行查詢，最終結果存放在m_bqarray中
void CQueryView::QueryAllBq(BQSTATE mybqstate,L3DBQARRAY& m_bqarray)
{
m_bqarray.RemoveAll();
m_visit.OnInit3DBq();
UINT m_sjdata[3] = {0,0,0};
UINT m_data[3] = {0,0,0};
UINT m_sjCount[2] = {0,0};
UINT m_Count[2] = {0,0};
CStringArray m_strsjarry;
CStringArray m_strarry;
CByteArray m_bsjarry,m_barry;
///////////////////////////////////////////////////////////////
fjstrParam(myotherstate.strsjhan,' ',m_strsjarry);
for(int i=0;i<m_strsjarry.GetSize();i++)
m_sjdata[i] = atoi(m_strsjarry.GetAt(i));
fjstrParam(myotherstate.strhan,' ',m_strarry);
for(i=0;i<m_strarry.GetSize();i++)
m_data[i] = atoi(m_strarry.GetAt(i));
//所含號碼個數nCount
int nsjCount = m_strsjarry.GetSize();
int nCount = m_strarry.GetSize();
/////////////////////////////////////////////////////////
//號碼和值
int ncountsjvalue = 0;
int ncountvalue = 0;
L3DBQDATA my3dbqdata;
bool bstate = 0;
CString strtmp = "";
while(!m_visit.m_p3dbqSet->IsEOF())
{
bstate = (mybqstate.bstartno == 0) && (mybqstate.bJiNo == 0 ) && (mybqstate.bQiuNo == 0) && (mybqstate.bsjhan == 0) && \
(mybqstate.bhan == 0) && (mybqstate.bsjCount == 0) &&(mybqstate.bCount == 0) && \
(mybqstate.bsjsametail == 0) && (mybqstate.bsametail == 0) ;
if(bstate) //所有條件全部不選擇
{
my3dbqdata.uItemNo = m_visit.m_p3dbqSet->m_ItemNo;
my3dbqdata.uJNo = m_visit.m_p3dbqSet->m_iJiNo;
my3dbqdata.uQNo = m_visit.m_p3dbqSet->m_iQiuNo;
my3dbqdata.strsjbsg = m_visit.m_p3dbqSet->m_iSJHAO;
my3dbqdata.strbsg = m_visit.m_p3dbqSet->m_iSCHAO;
///////////////////////////////////////////////
strtmp = m_visit.m_p3dbqSet->m_iSJHAO.GetAt(0);
my3dbqdata.usjB = atoi(strtmp);
strtmp = m_visit.m_p3dbqSet->m_iSJHAO.GetAt(1);
my3dbqdata.usjS = atoi(strtmp);
strtmp = m_visit.m_p3dbqSet->m_iSJHAO.GetAt(2);
my3dbqdata.usjG = atoi(strtmp);
strtmp = m_visit.m_p3dbqSet->m_iSCHAO.GetAt(0);
my3dbqdata.uB = atoi(strtmp);
strtmp = m_visit.m_p3dbqSet->m_iSCHAO.GetAt(1);
my3dbqdata.uS = atoi(strtmp);
strtmp = m_visit.m_p3dbqSet->m_iSCHAO.GetAt(2);
my3dbqdata.uG = atoi(strtmp);
for(int i=0;i<10;i++)
{
strtmp = m_visit.m_p3dbqSet->m_strsjB.GetAt(i);
my3dbqdata.uSJBNo[i] = atoi(strtmp);
strtmp = m_visit.m_p3dbqSet->m_strsjS.GetAt(i);
my3dbqdata.uSJSNo[i] = atoi(strtmp);
strtmp = m_visit.m_p3dbqSet->m_strsjG.GetAt(i);
my3dbqdata.uSJGNo[i] = atoi(strtmp);
}
my3dbqdata.uSJCount = my3dbqdata.usjB +my3dbqdata.usjS +my3dbqdata.usjG;
my3dbqdata.uCountValue = my3dbqdata.uB + my3dbqdata.uS + my3dbqdata.uG;;
m_bqarray.Add(my3dbqdata);
}
m_visit.m_p3dbqSet->MoveNext();
}
m_visit.OnClose3DBq();
}
void CQueryView::OnQuery3dbq()
{
// TODO: Add your control notification handler code here
//檢查和獲取各個選擇項的狀態及取值
mybqstate.bstartno = ((CButton*)GetDlgItem(IDC_CHECKBQ1))->GetState();
mybqstate.bJiNo = ((CButton*)GetDlgItem(IDC_EDITBQ1))->GetState();
mybqstate.bQiuNo = ((CButton*)GetDlgItem(IDC_EDITBQ2))->GetState();
mybqstate.bsjhan = ((CButton*)GetDlgItem(IDC_EDITBQ3))->GetState();
mybqstate.bhan = ((CButton*)GetDlgItem(IDC_EDITBQ4))->GetState();
mybqstate.bsjCount = ((CButton*)GetDlgItem(IDC_EDITBQ5))->GetState();
mybqstate.bCount = ((CButton*)GetDlgItem(IDC_EDITBQ6))->GetState();
mybqstate.bsjsametail = ((CButton*)GetDlgItem(IDC_EDITBQ7))->GetState();
mybqstate.bsametail = ((CButton*)GetDlgItem(IDC_EDITBQ8))->GetState();
CString strtmp = "";
// int index = ((CComboBox*)GetDlgItem(IDC_START))->GetCurSel();
// ((CComboBox*)GetDlgItem(IDC_START))->GetLBText( index, strtmp);
// mystate.ustartNo = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDITBQ1))->GetWindowText(strtmp);
mybqstate.uJiNo = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDITBQ1))->GetWindowText(strtmp);
mybqstate.uQiuNo = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDITBQ2))->GetWindowText(mybqstate.strsjhan);
((CEdit*)GetDlgItem(IDC_EDITBQ3))->GetWindowText(mybqstate.strhan);
((CEdit*)GetDlgItem(IDC_EDITBQ4))->GetWindowText(mybqstate.strsjCount);
((CEdit*)GetDlgItem(IDC_EDITBQ5))->GetWindowText(mybqstate.strCount);
((CEdit*)GetDlgItem(IDC_EDITBQ6))->GetWindowText(strtmp);
mybqstate.usjsametail = atoi(strtmp);
((CEdit*)GetDlgItem(IDC_EDITBQ7))->GetWindowText(strtmp);
mybqstate.usametail = atoi(strtmp);
QueryAllBq(mybqstate,my3dbqarray);
//將查詢到的結果送到歷史數據視
CMainFrame* pmain = (CMainFrame*)AfxGetMainWnd();
HWND m_hwnd;
m_hwnd = (pmain->m_Framework.Get(6))->GetSafeWnd()->m_hWnd;
::PostMessage(m_hwnd,WM_DISPDATA,(WPARAM)&my3dbqarray,0);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -