📄 queryformview.cpp
字号:
(mystate.bmaxred == 0) && (mystate.bblue == 1) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件3
{
if(m_visit.m_pSet->m_Blue == mystate.ublue)
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
myssqdata.iRed[0] = m_visit.m_pSet->m_Red1;
myssqdata.iRed[1] = m_visit.m_pSet->m_Red2;
myssqdata.iRed[2] = m_visit.m_pSet->m_Red3;
myssqdata.iRed[3] = m_visit.m_pSet->m_Red4;
myssqdata.iRed[4] = m_visit.m_pSet->m_Red5;
myssqdata.iRed[5] = m_visit.m_pSet->m_Red6;
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 0) && (mystate.bRCount == 0) && (mystate.bminred == 1) && \
(mystate.bmaxred == 0) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件4
{
if(m_visit.m_pSet->m_Red1 >= mystate.uminRed)
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
myssqdata.iRed[0] = m_visit.m_pSet->m_Red1;
myssqdata.iRed[1] = m_visit.m_pSet->m_Red2;
myssqdata.iRed[2] = m_visit.m_pSet->m_Red3;
myssqdata.iRed[3] = m_visit.m_pSet->m_Red4;
myssqdata.iRed[4] = m_visit.m_pSet->m_Red5;
myssqdata.iRed[5] = m_visit.m_pSet->m_Red6;
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 0) && (mystate.bRCount == 0) && (mystate.bminred == 0) && \
(mystate.bmaxred == 1) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件5
{
if(m_visit.m_pSet->m_Red6 <= mystate.umaxRed)
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
myssqdata.iRed[0] = m_visit.m_pSet->m_Red1;
myssqdata.iRed[1] = m_visit.m_pSet->m_Red2;
myssqdata.iRed[2] = m_visit.m_pSet->m_Red3;
myssqdata.iRed[3] = m_visit.m_pSet->m_Red4;
myssqdata.iRed[4] = m_visit.m_pSet->m_Red5;
myssqdata.iRed[5] = m_visit.m_pSet->m_Red6;
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 0) && (mystate.bRCount == 0) && (mystate.bminred == 1) && \
(mystate.bmaxred == 1) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件4,5
{
if(m_visit.m_pSet->m_Red6 <= mystate.umaxRed && m_visit.m_pSet->m_Red1 >= mystate.uminRed)
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
myssqdata.iRed[0] = m_visit.m_pSet->m_Red1;
myssqdata.iRed[1] = m_visit.m_pSet->m_Red2;
myssqdata.iRed[2] = m_visit.m_pSet->m_Red3;
myssqdata.iRed[3] = m_visit.m_pSet->m_Red4;
myssqdata.iRed[4] = m_visit.m_pSet->m_Red5;
myssqdata.iRed[5] = m_visit.m_pSet->m_Red6;
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 1) && (mystate.bRCount == 1) && (mystate.bminred == 0) && \
(mystate.bmaxred == 0) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件1,2
{
UINT utmp[6] = {m_visit.m_pSet->m_Red1,m_visit.m_pSet->m_Red2,m_visit.m_pSet->m_Red3,m_visit.m_pSet->m_Red4,m_visit.m_pSet->m_Red5,m_visit.m_pSet->m_Red6};
if(nCountValue == 1) //只给出一个和值，表示仅查询该单独值的记录
m_RCount[1] = m_RCount[0];
if(subFind(m_Red,utmp) == nRCount && (m_visit.m_pSet->m_RCountValue >= m_RCount[0] && m_visit.m_pSet->m_RCountValue <= m_RCount[1])) //该记录符合查询条件要求
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
for(i = 0;i<6;i++)
myssqdata.iRed[i] = utmp[i];
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 0) && (mystate.bRCount == 1) && (mystate.bminred == 1) && \
(mystate.bmaxred == 1) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件2,4,5
{
if(nCountValue == 1) //只给出一个和值，表示仅查询该单独值的记录
m_RCount[1] = m_RCount[0];
if(m_visit.m_pSet->m_RCountValue >= m_RCount[0] && m_visit.m_pSet->m_RCountValue <= m_RCount[1] && m_visit.m_pSet->m_Red6 <= mystate.umaxRed && m_visit.m_pSet->m_Red1 >= mystate.uminRed )
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
myssqdata.iRed[0] = m_visit.m_pSet->m_Red1;
myssqdata.iRed[1] = m_visit.m_pSet->m_Red2;
myssqdata.iRed[2] = m_visit.m_pSet->m_Red3;
myssqdata.iRed[3] = m_visit.m_pSet->m_Red4;
myssqdata.iRed[4] = m_visit.m_pSet->m_Red5;
myssqdata.iRed[5] = m_visit.m_pSet->m_Red6;
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 1) && (mystate.bRCount == 1) && (mystate.bminred == 1) && \
(mystate.bmaxred == 1) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件1,2,4,5
{
UINT utmp[6] = {m_visit.m_pSet->m_Red1,m_visit.m_pSet->m_Red2,m_visit.m_pSet->m_Red3,m_visit.m_pSet->m_Red4,m_visit.m_pSet->m_Red5,m_visit.m_pSet->m_Red6};
if(nCountValue == 1) //只给出一个和值，表示仅查询该单独值的记录
m_RCount[1] = m_RCount[0];
if(subFind(m_Red,utmp) == nRCount && (m_visit.m_pSet->m_RCountValue >= m_RCount[0] && m_visit.m_pSet->m_RCountValue <= m_RCount[1]) \
&& (m_visit.m_pSet->m_Red1 >= mystate.uminRed) && (m_visit.m_pSet->m_Red6 <= mystate.umaxRed)) //该记录符合查询条件要求
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
for(i = 0;i<6;i++)
myssqdata.iRed[i] = utmp[i];
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 1) && (mystate.bRCount == 1) && (mystate.bminred == 1) && \
(mystate.bmaxred == 0) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件1,2,4
{
UINT utmp[6] = {m_visit.m_pSet->m_Red1,m_visit.m_pSet->m_Red2,m_visit.m_pSet->m_Red3,m_visit.m_pSet->m_Red4,m_visit.m_pSet->m_Red5,m_visit.m_pSet->m_Red6};
if(nCountValue == 1) //只给出一个和值，表示仅查询该单独值的记录
m_RCount[1] = m_RCount[0];
if(subFind(m_Red,utmp) == nRCount && (m_visit.m_pSet->m_RCountValue >= m_RCount[0] && m_visit.m_pSet->m_RCountValue <= m_RCount[1]) \
&& (m_visit.m_pSet->m_Red1 >= mystate.uminRed)) //该记录符合查询条件要求
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
for(i = 0;i<6;i++)
myssqdata.iRed[i] = utmp[i];
m_array.Add(myssqdata);
}
}
bstate = (mystate.bhanRed == 1) && (mystate.bRCount == 1) && (mystate.bminred == 0) && \
(mystate.bmaxred == 1) && (mystate.bblue == 0) &&(mystate.b0 == 0) && (mystate.b1 == 0) && (mystate.b2 == 0);
if(bstate) //只选择条件1,2,5
{
UINT utmp[6] = {m_visit.m_pSet->m_Red1,m_visit.m_pSet->m_Red2,m_visit.m_pSet->m_Red3,m_visit.m_pSet->m_Red4,m_visit.m_pSet->m_Red5,m_visit.m_pSet->m_Red6};
if(nCountValue == 1) //只给出一个和值，表示仅查询该单独值的记录
m_RCount[1] = m_RCount[0];
if(subFind(m_Red,utmp) == nRCount && (m_visit.m_pSet->m_RCountValue >= m_RCount[0] && m_visit.m_pSet->m_RCountValue <= m_RCount[1]) \
&& (m_visit.m_pSet->m_Red6 <= mystate.umaxRed)) //该记录符合查询条件要求
{
myssqdata.strNo = m_visit.m_pSet->m_qishu;
myssqdata.iBlue = m_visit.m_pSet->m_Blue;
myssqdata.iCountValue = m_visit.m_pSet->m_RCountValue;
for(i = 0;i<6;i++)
myssqdata.iRed[i] = utmp[i];
m_array.Add(myssqdata);
}
}
//////////////////////////////////////////////////////
//其他还有一些条件暂时先不考虑
m_visit.m_pSet->MoveNext();
}
m_visit.OnClose();
}
void CQueryFormView::OnDrawline()
{
// TODO: Add your control notification handler code here
}
void CQueryFormView::OnInitialUpdate()
{
CFormView::OnInitialUpdate();
//初始化查询状态
mystate.bhanRed = 0;
mystate.bRCount = 0;
mystate.strRCount = "";
mystate.bminred = 0;
mystate.bmaxred = 0;
mystate.b0 =0;
mystate.b1 = 0;
mystate.b2 = 0;
mystate.bblue = 0;
mystate.strendNo = "";
mystate.strstartNo = "";
mystate.strred = "";
mystate.uminRed = 0;
mystate.umaxRed = 0 ;
mystate.ub0 = 0;
mystate.ub1 = 0;
mystate.ub2 = 0;
mystate.ublue = 0;
//CVisitData m_visit;
m_visit.OnInit();
while(!m_visit.m_pSet->IsEOF())
{
((CComboBox*)GetDlgItem(IDC_START))->AddString(m_visit.m_pSet->m_qishu);
((CComboBox*)GetDlgItem(IDC_END))->AddString(m_visit.m_pSet->m_qishu);
m_visit.m_pSet->MoveNext();
}
m_visit.OnClose();
((CComboBox*)GetDlgItem(IDC_START))->SetCurSel(1);
((CComboBox*)GetDlgItem(IDC_END))->SetCurSel(10);
}
void CQueryFormView::OnDropdownStart()
{
// TODO: Add your control notification handler code here
}
void CQueryFormView::OnDropdownEnd()
{
// TODO: Add your control notification handler code here
}
void CQueryFormView::OnSelchangeEnd()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
}
void CQueryFormView::OnSelchangeStart()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -