resultview.cpp

一个用C++写的电力系统故障录波数据管理系统

					if(flag){
						CMySet.m_strFilter +="or"+ccc+"and"+kk2+")";
						title[4]="2";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter =ccc+"and"+kk2+")";
						title[4]="2";
                        flag=TRUE;
					}
				}
			}
			if(dlg.m_check8){
				sprintf(Wyy3, "(faulttype=%d)",dlg.type[3]);
				CString kk3=_T(Wyy3);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk3;
                    title[4]="3";
					flag=TRUE;
				}
				else{
					if(flag){
						CMySet.m_strFilter +="or"+ccc+"and"+kk3+")";
						title[4]="3";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter =ccc+"and"+kk3+")";
						title[4]="3";
                        flag=TRUE;
					}
				}
			}
			if(dlg.m_check9){
				sprintf(Wyy4, "(faulttype=%d)",dlg.type[4]);
				CString kk4=_T(Wyy4);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk4;
                    title[4]="4";
					flag=TRUE;
				}
				else{
					if(flag){
						CMySet.m_strFilter +="or"+ccc+"and"+kk4+")";
						title[4]="4";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter =ccc+"and"+kk4+")";
						title[4]="4";
                        flag=TRUE;
					}
				}
			}
			if(dlg.m_check10){
				sprintf(Wyy5, "(faulttype=%d)",dlg.type[5]);
				CString kk5=_T(Wyy5);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk5;
                    title[4]="5";
					flag=TRUE;
				}
				else{
					if(flag){
						CMySet.m_strFilter +="or"+ccc+"and"+kk5+")";
						title[4]="5";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter =ccc+"and"+kk5+")";
						title[4]="5";
                        flag=TRUE;
					}
				}
			}
			}
			
//////////////////////////////////////			
			else{
				if(dlg.m_check6){
				sprintf(Wyy1, "(faulttype=%d)",dlg.type[1]);
				CString kk1=_T(Wyy1);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk1;
                    title[4]="1";
					flag=TRUE;
				}
				else{					
					if(flag){
						CMySet.m_strFilter +="or"+kk1;
						title[4]="1";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter +="and"+kk1;
						title[4]="1";
                        flag=TRUE;
					}
				}
			}
			if(dlg.m_check7){
				sprintf(Wyy2, "(faulttype=%d)",dlg.type[2]);
				CString kk2=_T(Wyy2);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk2;
                    title[4]="2";
					flag=TRUE;
				}
				else{
					if(flag){
						CMySet.m_strFilter +="or"+kk2;
						title[4]="2";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter +="and"+kk2;
						title[4]="2";
                        flag=TRUE;
					}
				}
			}
			if(dlg.m_check8){
				sprintf(Wyy3, "(faulttype=%d)",dlg.type[3]);
				CString kk3=_T(Wyy3);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk3;
                    title[4]="3";
					flag=TRUE;
				}
				else{
					if(flag){
						CMySet.m_strFilter +="or"+kk3;
						title[4]="3";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter +="and"+kk3;
						title[4]="3";
                        flag=TRUE;
					}
				}
			}
			if(dlg.m_check9){
				sprintf(Wyy4, "(faulttype=%d)",dlg.type[4]);
				CString kk4=_T(Wyy4);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk4;
                    title[4]="4";
					flag=TRUE;
				}
				else{
					if(flag){
						CMySet.m_strFilter +="or"+kk4;
						title[4]="4";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter +="and"+kk4;
						title[4]="4";
                        flag=TRUE;
					}
				}
			}
			if(dlg.m_check10){
				sprintf(Wyy5, "(faulttype=%d)",dlg.type[5]);
				CString kk5=_T(Wyy5);
				if(CMySet.m_strFilter=="\0"){
					CMySet.m_strFilter =kk5;
                    title[4]="5";
					flag=TRUE;
				}
				else{
					if(flag){
						CMySet.m_strFilter +="or"+kk5;
						title[4]="5";
						flag=TRUE;
					}
					else{
						CMySet.m_strFilter +="and"+kk5;
						title[4]="5";
                        flag=TRUE;
					}
				}
			}
			}			
		}
		
      ////////////////////////////////////////////////////////////////////////		
		
	  //CMySet.m_strFilter
		//CMySet.Close();
	    //CMySet.m_strFilter="reserve1<=2000";
	//	AfxMessageBox(CMySet.m_strFilter, MB_OK);
		CMySet.Open();		
		if(CMySet.GetRecordCount()==0){
			AfxMessageBox("无记录！",MB_OK);
			CMySet.m_strFilter.Empty();
		}
		else
			CMySet.MoveFirst();
		/*while(!CMySet.IsEOF())
		{
			n++;
			CMySet.MoveNext();
		}*/
		if(CMySet.m_strFilter!="\0"){
	CSize sizeTotal;
	// TODO: calculate the total size of this view UpdateAllViews
	sizeTotal.cx = 2800;
	sizeTotal.cy = 700+(n+2)*80;
	SetScrollSizes(MM_LOMETRIC, sizeTotal);
	m_rmode=TRUE;
	m_AddMode=TRUE;
	Invalidate();}
	}
}

void CResultView::AddValue()
{
	
	value[0]=(char *)LPCTSTR(CMySet.m_recordno);
	int no = atoi(value[0]) + 1;
	sprintf(value[0], "%d", no); 
    value[1]=(char *)LPCTSTR(CMySet.m_startdatet); 
	value[2]=(char *)LPCTSTR(CMySet.m_phasename);
	value[3]=(char *)LPCTSTR(CMySet.m_delaytime);
	value[4]=(char *)LPCTSTR(CMySet.m_recordid);
	value[5]=(char *)LPCTSTR(CMySet.m_linename);
	value[6]=(char *)LPCTSTR(CMySet.m_filename);
}



void CResultView::OnBeginPrinting(CDC* pDC, CPrintInfo* pInfo) 
{
	// TODO: Add your specialized code here and/or call the base class
	//if(pDC->IsPrinting())
	//	pDC->SetMapMode(MM_LOMETRIC);framework CCmdTarget
	CScrollView::OnBeginPrinting(pDC, pInfo);
}

void CResultView::OnEndPrinting(CDC* pDC, CPrintInfo* pInfo) 
{
	// TODO: Add your specialized code here and/or call the base class
	
	CScrollView::OnEndPrinting(pDC, pInfo);
}

BOOL CResultView::OnPreparePrinting(CPrintInfo* pInfo) 
{
	// TODO: call DoPreparePrinting to invoke the Print dialog box
	return DoPreparePrinting(pInfo);
	
}




BOOL CResultView::AddFaultRecord(struct FAULT_RECORD FaultRecord)
{
		
	int i=0;
	if(CMySet.IsOpen())
		CMySet.Close();
	CMySet.Open();
	CMySet.MoveFirst();
    while(!CMySet.IsEOF())
	{
		i++;
		CMySet.MoveNext();
	}
	CMySet.Close();
	if(CMySet.IsOpen())
		CMySet.Close();	
	CMySet.Open();
	CMySet.MoveFirst();
	CMySet.AddNew();
    char zhx[200];
	i++;
	sprintf(zhx,"%d",i);
	CString s=_T(zhx);
	CMySet.m_recordno=s;
    CMySet.m_startdatet=FaultRecord.StartDateTime;
	CMySet.m_startmtime=FaultRecord.StartMTime;
	CMySet.m_delaytime=FaultRecord.DelayTime;
	CMySet.m_cityname= FaultRecord.CityName;
	CMySet.m_stationnam=FaultRecord.StationName;
	CMySet.m_linename =FaultRecord.LineName;
	CMySet.m_recordid =FaultRecord.RecordID;
	CMySet.m_phasename=FaultRecord.PhaseName;
	CMySet.m_jumpphase=FaultRecord.JumpPhase;
	CMySet.m_filename=FaultRecord.FileName;
	CMySet.m_analyfile=FaultRecord.AnalyFile;
	CMySet.m_faulttype=FaultRecord.FaultType;
	CMySet.m_reserve1=FaultRecord.Reserve1;
	CMySet.m_reserve2=FaultRecord.Reserve2;
	CMySet.m_reserve3=FaultRecord.Reserve3;
	CMySet.Update();
	CMySet.MoveFirst();	
	CMySet.Close();
	//CMySet.Update();
	return TRUE;
}

WORD CResultView::DelFaultRecord(struct FAULT_RECORD FaultRecord)
{
	if(CMySet.IsOpen())
		CMySet.Close();
	char ff[500];
	sprintf(ff,"(recordno=%s)",FaultRecord.RecordNo);
	CString dd=_T(ff);
	CMySet.m_strFilter=dd;

	AfxMessageBox(CMySet.m_strFilter,IDOK);
	CMySet.Open();
    CMySet.MoveFirst();
	CMySet.Delete();
	//CMySet.Update();
	//	CMySet.Open();
	//if(CMySet.CanScroll())
	//if(CMySet.GetRecordCount()!=0)
	//	CMySet.MoveFirst();	
	//CMySet.MoveLast();
    CMySet.m_strFilter.Empty(); 
	CMySet.Close();
	return TRUE;
}


void CResultView::OnEditDelete() 
{
	// TODO: Add your command handler code here
	/*struct FAULT_RECORD zhx={"18","1998-09-28 12:20:20","77",
		"77","武汉市邮电局","武汉市邮电局","广宁线","wyy100","A","A2",
		"awgu34.dat","zhx","3","1998.092812","1","1"};
	DelFaultRecord(zhx);*/
	CDelDialog dlg1;
	dlg1.DoModal();
}