publicquery.cpp

偶作的毕业设计程序

		{softnumber=(char*)(_bstr_t)Holder;
		softnumber.TrimRight(" ");}
		Holder=Myset->GetCollect ("作者");
		if(Holder.vt!=VT_NULL)
		{softauthor=(char*)(_bstr_t)Holder;
		softauthor.TrimRight(" ");}
		Holder=Myset->GetCollect ("软件类型");
		if(Holder.vt!=VT_NULL)
		{softtype=(char*)(_bstr_t)Holder;
		softtype.TrimRight(" ");}
		Holder=Myset->GetCollect ("所属型号");
		if(Holder.vt!=VT_NULL)
		{softxinghao=(char*)(_bstr_t)Holder;
		softxinghao.TrimRight(" ");}
		Holder=Myset->GetCollect ("所属系统");
		if(Holder.vt!=VT_NULL)
		{softxitong=(char*)(_bstr_t)Holder;
		softxitong.TrimRight(" ");}
		Holder=Myset->GetCollect ("软件功能描述");
		if(Holder.vt!=VT_NULL)
		{softfunction=(char*)(_bstr_t)Holder;
		softfunction.TrimRight(" ");}
		Holder=Myset->GetCollect ("入库时间");
		if(Holder.vt!=VT_NULL)
		{softdate=(char*)(_bstr_t)Holder;
		softdate.TrimRight(" ");}
		//判断格式
		for(int i=1;i<6;i++)
		{	_variant_t strgeshi=geshi[i];
		Holder=Myset->GetCollect (strgeshi);
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		if(mystr=="在家"){
			m_List.InsertItem (j,softname);
			m_List.SetItemText (j,1,softauthor);
			m_List.SetItemText (j,2,geshi[i]);
			m_List.SetItemText (j,3,softtype);
			m_List.SetItemText (j,4,softfunction);
			m_List.SetItemText (j,5,softxinghao);
			m_List.SetItemText (j,6,softxitong);
			m_List.SetItemText (j,7,softnumber);
			m_List.SetItemText (j,8,softdate);
			
			j++;}
		}
		
		//if
	}Myset->MoveNext();}
}

void CPublicQuery::FindUserInfo()
{
	// TODO: Add your control notification handler code here
	InitList();
	m_List.SetRedraw (false);
	CString mysql;
	mysql.Format("SELECT * FROM UserInfo ORDER BY 用户名");
	_bstr_t sql=mysql;
	_bstr_t source=m_strSource;
	_RecordsetPtr Myset;
	Myset.CreateInstance (__uuidof(Recordset));
	try{
		Myset->Open (sql,source,adOpenDynamic,adLockOptimistic,adCmdText);}
	catch(_com_error &e){
		AfxMessageBox(e.ErrorMessage ());return;
	}
	CString str1,mystr;
	_variant_t Holder;
	int i=0;
	while(!Myset->adoEOF ){
		Holder=Myset->GetCollect ("用户名");//
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		m_List.InsertItem (i,mystr);}
		else
			m_List.InsertItem (i,"未知用户名");
		Holder=Myset->GetCollect ("姓名");//
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		m_List.SetItemText (i,1,mystr);}
		else
			m_List.SetItemText (i,1,"未知姓名");
		Holder=Myset->GetCollect ("部门");//
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		m_List.SetItemText (i,2,mystr);}
		else
			m_List.SetItemText (i,2,"未知部门");
		Holder=Myset->GetCollect ("联系电话");//
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		m_List.SetItemText (i,3,mystr);}
		else
			m_List.SetItemText (i,3,"未知电话");
		Holder=Myset->GetCollect ("登记时间");//
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		m_List.SetItemText (i,4,mystr);}
		else
			m_List.SetItemText (i,4,"未知日期");
		Holder=Myset->GetCollect ("详细信息");//
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		m_List.SetItemText (i,5,mystr);}
		else
			m_List.SetItemText (i,5,"未知信息");
		i++;
		Myset->MoveNext();
	}
	Myset->Close();
	m_List.SetRedraw (true);
}

void CPublicQuery::FindSoftBorrow()
{
	// TODO: Add your control notification handler code here
	m_List.DeleteAllItems ();
	CString geshi[6];
	geshi[1]="软盘";
	geshi[2]="光盘";
	geshi[4]="文本";
	geshi[3]="硬盘";
	geshi[5]="其他";
	m_List.SetRedraw (false);
	CString mysql,mystr;
	mysql.Format("SELECT * FROM SoftDocInfo WHERE (软盘 <> '在家' and 软盘 <>'无') or (光盘 <> '在家' and 光盘 <>'无') or (硬盘 <> '在家' and 硬盘<>'无') or (文本 <> '在家' and 文本 <>'无') or (其他 <> '在家' and 其他 <>'无')");
	_bstr_t sql=mysql;
	_bstr_t source=m_strSource;
	_RecordsetPtr Myset;
	Myset.CreateInstance (__uuidof(Recordset));
	try{
		Myset->Open (sql,source,adOpenDynamic,adLockOptimistic,adCmdText);}
	catch(_com_error &e){
		AfxMessageBox(e.ErrorMessage ());return;
	}
	_variant_t Holder;
	int i=0,j=0;
	
	int Shumu=0;
	while(!Myset->adoEOF)//看是否存在纪录
	{Shumu+=1;
	Myset->MoveNext ();}
	if(Shumu<1)return;
	Myset->MoveFirst ();
	CString softnumber,softname,softtype,softgeshi,softdate,softauthor;
	while(!Myset->adoEOF ){	
		Holder=Myset->GetCollect ("软件名称");
		if(Holder.vt!=VT_NULL)
		{softname=(char*)(_bstr_t)Holder;
		softname.TrimRight(" ");}
		else softname="未知软件";
		Holder=Myset->GetCollect ("软件编号");
		if(Holder.vt!=VT_NULL)
		{softnumber=(char*)(_bstr_t)Holder;
		softnumber.TrimRight(" ");}
		else softnumber="未知编号";
		Holder=Myset->GetCollect ("作者");
		if(Holder.vt!=VT_NULL)
		{softauthor=(char*)(_bstr_t)Holder;
		softauthor.TrimRight(" ");}
		else softauthor="未知作者";
		Holder=Myset->GetCollect ("软件类型");
		if(Holder.vt!=VT_NULL)
		{softnumber=(char*)(_bstr_t)Holder;
		softnumber.TrimRight(" ");}
		else softnumber="未知类型";
		
		for(i=1;i<6;i++)
		{_variant_t strgeshi=geshi[i];
		Holder=Myset->GetCollect (strgeshi);
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight(" ");
		if(mystr!="在家" && mystr!="无"){
			m_List.InsertItem (j,softname);
			m_List.SetItemText (j,1,softauthor);
			m_List.SetItemText (j,2,geshi[i]);
			m_List.SetItemText (j,3,softtype);
			m_List.SetItemText (j,4,mystr);
			m_List.SetItemText (j,5,softnumber);
			j++;}
		}}
		Myset->MoveNext ();}
	m_List.SetRedraw (true);
}

void CPublicQuery::FindAbandonSoft()
{
	//((CPublicQuery*)(GetDlgItem(IDC_TAB1)->GetParent()))->ShowWindow(IDC_LIST1,SW_SHOW);//先获得父窗口指针，在使用它的函数
	UpdateData();
	m_List.SetRedraw (false);
	_RecordsetPtr Myset;
	CString sql_,mystr,strSTime,strETime;
	if(!((CButton*)GetDlgItem(IDC_CHECK7))->GetCheck())//设置查询语句
		sql_="select * from DiscardSoft";
	else
	{
		strSTime=m_Stime.Format("%Y-%m-%d");
		strETime=m_Etime.Format("%Y-%m-%d");
		sql_.Format(CString("select * from Discardsoft where 作废时间 > ") +DATEFMT + CString(" and 作废时间 < ") +DATEFMT,strSTime,strETime);
	}
	Myset.CreateInstance (__uuidof(Recordset));
	_bstr_t Mysql=sql_;
	_bstr_t source=m_strSource;
	_variant_t Holder;
	try{
		Myset->Open (Mysql,source,adOpenDynamic,adLockOptimistic,adCmdText);
	}
	catch(_com_error &e){
		AfxMessageBox(e.ErrorMessage());return;}
	int Shumu=0;
	while(!Myset->adoEOF)//记录数
	{Shumu+=1;
	Myset->MoveNext ();}
	if(Shumu<1)return;
	Myset->MoveFirst ();
	int i=0;
	while(!Myset->adoEOF ){		
		
		Holder=Myset->GetCollect ("软件名称");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.InsertItem (i,mystr);}
		else
			m_List.InsertItem(i,"未知名称");
		Holder=Myset->GetCollect ("作者");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,1,mystr);}
		else
			m_List.SetItemText(i,1,"未知作者");
		Holder=Myset->GetCollect ("格式");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,2,mystr);}
		else
			m_List.SetItemText(i,2,"未知格式");
		Holder=Myset->GetCollect ("软件类型");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,3,mystr);}
		else
			m_List.SetItemText(i,3,"未知类型");
		Holder=Myset->GetCollect ("软件功能描述");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,4,mystr);}
		else
			m_List.SetItemText(i,4,"未知功能");
		Holder=Myset->GetCollect ("所属型号");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,5,mystr);}
		else
			m_List.SetItemText(i,5,"未知型号");
		Holder=Myset->GetCollect ("所属系统");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,6,mystr);}
		else
			m_List.SetItemText(i,6,"未知系统");
		Holder=Myset->GetCollect ("软件编号");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,7,mystr);}
		else
			m_List.SetItemText(i,7,"未知编号");
		Holder=Myset->GetCollect ("入库日期");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,8,mystr);}
		else
			m_List.SetItemText(i,8,"未知日期");
		Holder=Myset->GetCollect ("作废日期");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,9,mystr);}
		else
			m_List.SetItemText(i,9,"未知时间");
		i++;
		Myset->MoveNext ();
	}
	m_List.SetRedraw (true);
	Invalidate();//重绘窗口
}

void CPublicQuery::FindChatRecord()
{
	//((CPublicQuery*)(GetDlgItem(IDC_TAB1)->GetParent()))->ShowWindow(IDC_LIST1,SW_SHOW);//先获得父窗口指针，在使用它的函数
	UpdateData();
	m_List.SetRedraw (false);
	CString sql_,mystr,strSTime,strETime;
	if(!((CButton*)GetDlgItem(IDC_CHECK7))->GetCheck())//设置查询语句
		sql_="select * from ChatInfo";
	else
	{
		strSTime=m_Stime.Format("%Y-%m-%d");
		strETime=m_Etime.Format("%Y-%m-%d");
		sql_.Format(CString("select * from ChatInfo where 交易时间 > ") +DATEFMT + CString(" and 交易时间 < ") +DATEFMT,strSTime,strETime);
	}
	_RecordsetPtr Myset;
	Myset.CreateInstance (__uuidof(Recordset));
	_bstr_t Mysql=sql_;
	_bstr_t source=m_strSource;
	_variant_t Holder;
	try{
		Myset->Open (Mysql,source,adOpenDynamic,adLockOptimistic,adCmdText);
	}
	catch(_com_error &e){
		AfxMessageBox(e.ErrorMessage());return;}
	int Shumu=0;
	while(!Myset->adoEOF)//记录数
	{Shumu+=1;
	Myset->MoveNext ();}
	if(Shumu<1)return;
	Myset->MoveFirst ();
	int i=0;
	while(!Myset->adoEOF ){		
		Holder=Myset->GetCollect ("交易编号");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.InsertItem (i,mystr);}
		else
			m_List.InsertItem(i,"未知编号");
		
		Holder=Myset->GetCollect ("用户名");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,1,mystr);}
		else
			m_List.SetItemText(i,1,"未知用户");
		Holder=Myset->GetCollect ("交易类别");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,2,mystr);}
		else
			m_List.SetItemText(i,2,"未知类别");
		Holder=Myset->GetCollect ("软件名称");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,3,mystr);}
		else
			m_List.SetItemText(i,3,"未知名称");
		Holder=Myset->GetCollect ("格式");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");
		m_List.SetItemText(i,4,mystr);}
		else
			m_List.SetItemText(i,4,"未知格式");
		Holder=Myset->GetCollect ("软件编号");
		if(Holder.vt!=VT_NULL)
		{mystr=(char*)(_bstr_t)Holder;
		mystr.TrimRight (" ");