good.cpp

这是一个不错的商店管理系统

		   
	   }
	    

	


	 
     tiaozhuan: 
	   //m_vdeptno = "";
	  // m_vdeptname = "";
	   UpdateData(false);
	// TODO: Add your control notification handler code here
	
}

void Cgood::OnButton2() 
{
	UpdateData(true);

   //_variant_t vclassnumber;
   //int panduan = 1;
   //CString sql,sql2,classnumber;
    //m_insertstudentnum = "'"+m_insertstudentnum + "'"; 
    //sql = "select * from student where  studentnum = "+m_insertstudentnum ;
	if(MessageBox("确定要删除吗?",0,
			MB_OKCANCEL|MB_DEFBUTTON2|MB_ICONWARNING)==IDOK)
	{
	m_goodno = "'"+m_goodno + "'"; 
	sql = "select * from good where  goodno = "+m_goodno ;
	

	//////////////////////////////////////////////////////////////////////////////
	try
	 {
       m_pRecordset->Close();
       m_pRecordset = NULL;
         m_pRecordset.CreateInstance(_uuidof(Recordset));//

         
         m_pRecordset->Open( (_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
         m_pRecordset->Delete(adAffectCurrent);
		 
		 //AfxMessageBox("删除记录成功!!");

		 displayintheuserlist();

		 AfxMessageBox("删除记录成功!!");


      

		 //m_pRecordset->Close();
         //m_pRecordset = NULL;
     //  m_pRecordset.CreateInstance(_uuidof(Recordset));//
     //  m_pRecordset->Open("select * from student",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
               
	 }
	 catch(_com_error e)///捕捉异常
	   {
		  AfxMessageBox("删除记录失败!");///显示错误信息
		 // panduan = 0;
	   }
	}
	// TODO: Add your control notification handler code here
	
}

void Cgood::OnButton3() 
{
	UpdateData(true);

	CString sql1,sql2,sql3,sql4,sql5;
m_goodno = "'"+m_goodno + "'"; 
m_goodname = "'"+m_goodname+"'";
m_unit = "'"+m_unit+"'";
m_deptno = "'"+m_deptno + "'"; 
m_provideprice = "'"+m_provideprice+"'";
m_sellprice = "'"+m_sellprice+"'";
sql1 = " update good set goodname = "+m_goodname+" where  goodno = "+m_goodno ; 
sql2 = " update good set unit = "+m_unit+" where goodno = "+m_goodno ; 
sql3 = " update good set deptno = "+m_deptno+" where  goodno = "+m_goodno ; 
sql4 = " update good set provideprice = "+m_provideprice+" where goodno = "+m_goodno ; 	
sql5 = " update good set sellprice = "+m_sellprice+" where  goodno = "+m_goodno ; 
 	
 
    try
	 {
       m_pRecordset->Close();
       m_pRecordset = NULL;
         m_pRecordset.CreateInstance(_uuidof(Recordset));//
         m_pRecordset->Open( (_variant_t)sql1,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
         m_pRecordset->Open( (_variant_t)sql2,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
		 m_pRecordset->Open( (_variant_t)sql3,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
		 m_pRecordset->Open( (_variant_t)sql4,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
         m_pRecordset->Open( (_variant_t)sql5,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	
		displayintheuserlist();
         AfxMessageBox("修改记录成功!"); 
		 // m_pRecordset->Open( (_variant_t)sql1,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
		 
	//	 //m_pRecordset->Close();
        // m_pRecordset = NULL;
	  // m_pRecordset.CreateInstance(_uuidof(Recordset));//
     //  m_pRecordset->Open("select * from student",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
               
	 }
	 catch(_com_error e)///捕捉异常
	   {
		  //AfxMessageBox("删除记录失败!");///显示错误信息
		  
	   }
//	 try
//	 {
	  //   m_pRecordset.CreateInstance(_uuidof(Recordset));//
     //    m_pRecordset->Open( (_variant_t)sql2,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
          //AfxMessageBox("修改记录成功!");
		// m_pRecordset->Close();
        // m_pRecordset = NULL;

		 

//	 }
//	 catch(_com_error e)///捕捉异常
	//   {
		  //AfxMessageBox("删除记录失败!");///显示错误信息
		  
//	   }
	// TODO: Add your control notification handler code here
	
}

void Cgood::OnButton4() 
{
	UpdateData(true);
    ///////////////////////////////////
	if (m_mode=="商品编号")
		mode="goodno";
	if (m_mode=="商品名称")
		mode="goodname";
    if (m_mode=="所在部门编号")
		mode="deptno";
	 
	//////////////////////////////////
	 

	condition = m_condition;
	 
	//if (mode1 == "" && mode2 == "")
		//AfxMessageBox("请选择查询方式!");
	//else
	if(mode == "")
		AfxMessageBox("请选择查询方式!");
	
	if(option11 == true)
	{
	 sql = "select * from good where " + mode +" "+ option1 +" " + "'"+ condition + "'" ;
	  
	}
	  
	 else
		goto label;
	

	//sql = (mode1 + option1 + condition1) + (andor + mode2 + option2 + condition2);
	try
	{
		//AfxMessageBox("请选择查询方式!");
		m_pRecordset->Close();
		m_pRecordset = NULL;
		
	    m_userlist.DeleteAllItems();

		m_pRecordset.CreateInstance("ADODB.Recordset");

		//m_pRecordset->MoveFirst();
		//m_pRecordset.CreateInstance(_uuidof(Recordset));//
		//m_pRecordset->Open("select  *  from employeeview",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
        m_pRecordset->Open( (_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	    //AfxMessageBox("请选择查询方式!");
		//m_pRecordset->Close();
		
	    
		//m_pRecordset->Open("select  *  from employeeview where sql",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	    if(m_pRecordset->adoEOF)
			AfxMessageBox("没有满足您查询的结果!");
	    
		//m_bSuccess = TRUE;
		
		while(!m_pRecordset->adoEOF)
		{
			
			//AfxMessageBox("请选择查询方式!");
			 
			vgoodno= m_pRecordset->GetCollect("goodno");
			vgoodname= m_pRecordset->GetCollect("goodname");
			vunit = m_pRecordset->GetCollect("unit");
			vdeptno= m_pRecordset->GetCollect("deptno");
			vprovideprice= m_pRecordset->GetCollect("provideprice");
			vsellprice = m_pRecordset->GetCollect("sellprice");
			 
			
			//this->AbleFalse();
	     	//this->LoadData();
			//this->GetDlgItem(IDC_BUTTON4)->EnableWindow(FALSE);
			//this->GetDlgItem(IDC_BUTTON2)->EnableWindow(FALSE);
			nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vgoodno);//先插第一个项
			m_userlist.SetItem(nItem,1,1,(_bstr_t)vgoodname,NULL,0,0,0);
			m_userlist.SetItem(nItem,2,1,(_bstr_t)vunit ,NULL,0,0,0);
			m_userlist.SetItem(nItem,3,1,(_bstr_t)vdeptno ,NULL,0,0,0);
			m_userlist.SetItem(nItem,4,1,(_bstr_t)vprovideprice,NULL,0,0,0);
			m_userlist.SetItem(nItem,5,1,(_bstr_t)vsellprice ,NULL,0,0,0);
			 
			

			m_pRecordset->MoveNext();
		}
	}
	catch(_com_error e)///捕捉异常
	{
		//AfxMessageBox("读取数据库失败!");///显示错误信息
	}
    
	//对逻辑运算的符号的恢复，以供下一次的查询 。
 label:	 //AfxMessageBox("请选择查询方式!");
	//option11 = false;
	    //option22 = false;
	    //andor00 = false;
	////////////////////////////////////////////////////////////////////
                
	
	//mode1 = "";
	//mode2 = "";
	//option1 = "";
	//option2 = "";
	//andor = "";
    
   UpdateData(false);
   //UpdateData(true);
   //AfxMessageBox("请选择查询方式!");
	// TODO: Add your control notification handler code here
	
}

void Cgood::OnRadio1() 
{
	option1 = "<";
	option11 = true;
	// TODO: Add your control notification handler code here
	
}

void Cgood::OnRadio2() 
{
	option1 = "=";
	option11 = true;
	// TODO: Add your control notification handler code here
	
}

void Cgood::OnRadio3() 
{
	option1 = ">";
	option11 = true;
	// TODO: Add your control notification handler code here
	
}