📄 news.cpp

📁 一个电视台专用的信息管理软件源代码
💻 CPP
📖 第 1 页 / 共 2 页
字号:
上一页 12

	try
	{
		m_pCommand.CreateInstance(__uuidof(Command));
		m_pCommand->ActiveConnection=m_pConnection;
		m_pCommand->CommandType=adCmdStoredProc;
		m_pCommand->CommandText=_bstr_t("UploadNews");
		
		_variant_t vvar1,vvar2,vvar3,vvar4,vvar5,vvar6,vvar7,vvar8,vvar9,vvar10,vvar11;
	
		vvar1=_variant_t(_bstr_t(cTitle));
		vvar2=_variant_t(iUserID);
		vvar3=_variant_t(IsAgent);
		vvar4=_variant_t(iColumnID);
		vvar5=_variant_t(_bstr_t(cDesc));
		vvar6=_variant_t(_bstr_t(cFileName));
		vvar7=_variant_t(iFileSize);
		vvar8=_variant_t(iAuditUserID);
		vvar9=_variant_t(_bstr_t(cFilePath));
		
		vvar10=_variant_t(iFlag);
		vvar11=_variant_t(_bstr_t(cMessage));

	

		_ParameterPtr mp_var1,mp_var2,mp_var3,mp_var4,mp_var5,mp_var6,mp_var7,mp_var8,mp_var9,mp_var10,mp_var11;
		mp_var1.CreateInstance(__uuidof(Parameter));
		mp_var2.CreateInstance(__uuidof(Parameter));
		mp_var3.CreateInstance(__uuidof(Parameter));
		mp_var4.CreateInstance(__uuidof(Parameter));
		mp_var5.CreateInstance(__uuidof(Parameter));
		mp_var6.CreateInstance(__uuidof(Parameter));
		mp_var7.CreateInstance(__uuidof(Parameter));
		mp_var8.CreateInstance(__uuidof(Parameter));
		mp_var9.CreateInstance(__uuidof(Parameter));
		mp_var10.CreateInstance(__uuidof(Parameter));
		mp_var11.CreateInstance(__uuidof(Parameter));
	
		mp_var1=m_pCommand->CreateParameter
		(
		_bstr_t("var1"),
		adVarChar,
		adParamInput,
		200,
		vvar1
		);
		m_pCommand->Parameters->Append(mp_var1); 

		mp_var2=m_pCommand->CreateParameter
		(
		_bstr_t("var2"),
		adBigInt,
		adParamInput,
		5,
		vvar2
		);
		m_pCommand->Parameters->Append(mp_var2); 

		mp_var3=m_pCommand->CreateParameter
		(
		_bstr_t("var3"),
		adBigInt,
		adParamInput,
		5,
		vvar3
		);
		m_pCommand->Parameters->Append(mp_var3); 

		mp_var4=m_pCommand->CreateParameter
		(
		_bstr_t("var4"),
		adBigInt,
		adParamInput,
		5,
		vvar4
		);
		m_pCommand->Parameters->Append(mp_var4); 

		mp_var5=m_pCommand->CreateParameter
		(
		_bstr_t("var5"),
		adVarChar,
		adParamInput,
		500,
		vvar5
		);
		m_pCommand->Parameters->Append(mp_var5); 

		mp_var6=m_pCommand->CreateParameter
		(
		_bstr_t("var6"),
		adVarChar,
		adParamInput,
		200,
		vvar6
		);
		m_pCommand->Parameters->Append(mp_var6); 
		
		mp_var7=m_pCommand->CreateParameter
		(
		_bstr_t("var7"),
		adBigInt,
		adParamInput,
		5,
		vvar7
		);
		m_pCommand->Parameters->Append(mp_var7); 
	
		mp_var8=m_pCommand->CreateParameter
		(
		_bstr_t("var8"),
		adBigInt,
		adParamInput,
		5,
		vvar8
		);
		m_pCommand->Parameters->Append(mp_var8); 

		mp_var9=m_pCommand->CreateParameter
		(
		_bstr_t("var9"),
		adVarChar,
		adParamInput,
		200,
		vvar9
		);
		m_pCommand->Parameters->Append(mp_var9); 


		mp_var10=m_pCommand->CreateParameter
		(
		_bstr_t("var10"),
		adBigInt,
		adParamOutput,
		5,
		vvar10
		);
		m_pCommand->Parameters->Append(mp_var10); 

		mp_var11=m_pCommand->CreateParameter
		(
		_bstr_t("var11"),
		adVarChar,
		adParamOutput,
		200,
		vvar11
		);
		m_pCommand->Parameters->Append(mp_var11); 


		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		m_pCommand->Execute(&vNull,&vNull,adCmdStoredProc);

		iFlag=mp_var10->Value;
		cMessage=mp_var11->Value.bstrVal;
		}
		catch(_com_error &error)
		{
			AfxMessageBox(error.ErrorMessage(),MB_OK,0);
			AfxMessageBox(error.Description(),MB_OK,0);
			AfxMessageBox("ADO错误!",MB_OK,0);
		}

}
void CNews::AuditNews(long iNewsID,long iAuditID,CString cAuditDesc,long iType,long bsUID,long& iFlg,CString& cMessage)
{

	try
	{
		m_pCommand.CreateInstance(__uuidof(Command));
		m_pCommand->ActiveConnection=m_pConnection;
		m_pCommand->CommandType=adCmdStoredProc;
		m_pCommand->CommandText=_bstr_t("AuditNews");
		
		_variant_t vvar1,vvar2,vvar3,vvar4,vvar5,vvar6,vvar7;
	
		vvar1=_variant_t(iNewsID);
		vvar2=_variant_t(iAuditID);	
		vvar3=_variant_t(_bstr_t(cAuditDesc));	
		vvar4=_variant_t(iType);
		vvar5=_variant_t(bsUID);
		
		vvar6=_variant_t(iFlg);
		vvar7=_variant_t(_bstr_t(cMessage));

		_ParameterPtr mp_var1,mp_var2,mp_var3,mp_var4,mp_var5,mp_var6,mp_var7;
		mp_var1.CreateInstance(__uuidof(Parameter));
		mp_var2.CreateInstance(__uuidof(Parameter));
		mp_var3.CreateInstance(__uuidof(Parameter));
		mp_var4.CreateInstance(__uuidof(Parameter));
		mp_var5.CreateInstance(__uuidof(Parameter));
		mp_var6.CreateInstance(__uuidof(Parameter));
		mp_var7.CreateInstance(__uuidof(Parameter));
	
		mp_var1=m_pCommand->CreateParameter
		(
		_bstr_t("var1"),
		adBigInt,
		adParamInput,
		5,
		vvar1
		);
		m_pCommand->Parameters->Append(mp_var1); 

		mp_var2=m_pCommand->CreateParameter
		(
		_bstr_t("var2"),
		adBigInt,
		adParamInput,
		5,
		vvar2
		);
		m_pCommand->Parameters->Append(mp_var2); 

	
		mp_var3=m_pCommand->CreateParameter
		(
		_bstr_t("var3"),
		adVarChar,
		adParamInput,
		500,
		vvar3
		);
		m_pCommand->Parameters->Append(mp_var3); 

	
		mp_var4=m_pCommand->CreateParameter
		(
		_bstr_t("var4"),
		adBigInt,
		adParamInput,
		5,
		vvar4
		);
		m_pCommand->Parameters->Append(mp_var4); 
	
		mp_var5=m_pCommand->CreateParameter
		(
		_bstr_t("var5"),
		adBigInt,
		adParamInput,
		5,
		vvar5
		);
		m_pCommand->Parameters->Append(mp_var5); 

		mp_var6=m_pCommand->CreateParameter
		(
		_bstr_t("var6"),
		adBigInt,
		adParamOutput,
		5,
		vvar6
		);
		m_pCommand->Parameters->Append(mp_var6); 

		mp_var7=m_pCommand->CreateParameter
		(
		_bstr_t("var7"),
		adVarChar,
		adParamOutput,
		200,
		vvar7
		);
		m_pCommand->Parameters->Append(mp_var7); 


		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		m_pCommand->Execute(&vNull,&vNull,adCmdStoredProc);

		iFlg=mp_var6->Value;
		cMessage=mp_var7->Value.bstrVal;
		}
		catch(_com_error &error)
		{
			AfxMessageBox(error.ErrorMessage(),MB_OK,0);
			AfxMessageBox(error.Description(),MB_OK,0);
			AfxMessageBox("ADO错误!",MB_OK,0);
		}
}
BOOL CNews::GetNewNews(CUIntArray& allNewsItem)
{
		//设置SELECT语句

	vSQL = "SELECT UID  FROM News WHERE  IsDelete =0 AND IsNew =1 ";

	//执行SELETE语句

	m_pRecordset = GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
	{
		CNews();
		return false;
	}
	else
	{
	
		while(!m_pRecordset->adoEOF)
		{
			allNewsItem.Add(atoi((_bstr_t)m_pRecordset->GetCollect("UID")));

			m_pRecordset->MoveNext();
		}
	}
	return true;

}
void CNews::GetAllNews(CUIntArray& allNewsItem,CString cCondition)
{
	//设置SELECT语句

	vSQL = "SELECT distinct News.UID as UID  FROM News,NewsAudit WHERE  NewsAudit.IsDelete =0 AND News.IsDelete =0 AND News.UID = NewsAudit.NewsID ";

	//执行SELETE语句

	vSQL = vSQL + cCondition;

	m_pRecordset = GetRecordSet(vSQL);
	
	while(!m_pRecordset->adoEOF)
	{
		allNewsItem.Add(atoi((_bstr_t)m_pRecordset->GetCollect("UID")));

		m_pRecordset->MoveNext();
	}
}
void CNews::GetAllNewsByUserID(CUIntArray& allNewsItem,int iUserID,int Type,CString cCondition)
{
	//设置SELECT语句
	CString strUserID,strAuditID;
	strUserID.Format("%d",iUserID);
	if(0==Type)
	{
		vSQL = "SELECT distinct News.UID as UID  FROM News,NewsAudit WHERE  NewsAudit.IsDelete =0 AND News.IsDelete =0 AND News.UID = NewsAudit.NewsID AND UserID="+strUserID;
	}
	else
	{
		vSQL = "SELECT distinct News.UID as UID FROM News,NewsAudit WHERE News.IsDelete =0 AND  NewsAudit.IsDelete =0  AND News.UID = NewsAudit.NewsID AND AuditUserID="+strUserID;
	}
	//执行SELETE语句

	vSQL = vSQL + cCondition;

	m_pRecordset = GetRecordSet(vSQL);
	
	while(!m_pRecordset->adoEOF)
	{
		allNewsItem.Add(atoi((_bstr_t)m_pRecordset->GetCollect("UID")));

		m_pRecordset->MoveNext();
	}
}



int CNews::QryFileExist(CString FileName,CString ServerPath)
{
	int iflg = 0;

	m_pCommand.CreateInstance(__uuidof(Command));
	m_pCommand->ActiveConnection=m_pConnection;
	m_pCommand->CommandText="QryFileExist";    
	m_pCommand->CommandType=adCmdStoredProc;
	m_pCommand->Parameters->Refresh(); 
//	CString strSQL = "AND FileName='"+ FileName +"' AND UserID = "+ strID;

	m_pCommand->Parameters->GetItem((short)1)->Value=(_bstr_t)ServerPath;
//	m_pCommand->Parameters->GetItem((short)2)->Value=(long)iUID;
	m_pCommand->Parameters->GetItem((short)2)->Value=(_bstr_t)FileName;


	m_pRecordset = m_pCommand->Execute(NULL,NULL,adCmdStoredProc);
	int iNum =atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("num"));
	if(iNum>0)
	{
		iflg = 1;
	}
	return iflg ;
	
}
void CNews::ShowNewNews(long NewsID,CString& cMessage)
{
	try
	{
		m_pCommand.CreateInstance(__uuidof(Command));
		m_pCommand->ActiveConnection=m_pConnection;
		m_pCommand->CommandType=adCmdStoredProc;
		m_pCommand->CommandText=_bstr_t("Show_NewNews");
		
		_variant_t vvar1,vvar2;
	
		vvar1=_variant_t(NewsID);
		vvar2=_variant_t(_bstr_t(cMessage));

		_ParameterPtr mp_var1,mp_var2;
		mp_var1.CreateInstance(__uuidof(Parameter));
		mp_var2.CreateInstance(__uuidof(Parameter));
	
		mp_var1=m_pCommand->CreateParameter
		(
		_bstr_t("var1"),
		adBigInt,
		adParamInput,
		5,
		vvar1
		);
		m_pCommand->Parameters->Append(mp_var1); 

		mp_var2=m_pCommand->CreateParameter
		(
		_bstr_t("var2"),
		adVarChar,
		adParamOutput,
		200,
		vvar2
		);
		m_pCommand->Parameters->Append(mp_var2); 


		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		m_pCommand->Execute(&vNull,&vNull,adCmdStoredProc);

		cMessage=mp_var2->Value.bstrVal;
		}
		catch(_com_error &error)
		{
			AfxMessageBox(error.ErrorMessage(),MB_OK,0);
			AfxMessageBox(error.Description(),MB_OK,0);
			AfxMessageBox("ADO错误!",MB_OK,0);
		}
}
void CNews::CancleNews(long NewsID,long UserID,long& iFlg,CString& cMessage)
{
	try
	{
		m_pCommand.CreateInstance(__uuidof(Command));
		m_pCommand->ActiveConnection=m_pConnection;
		m_pCommand->CommandType=adCmdStoredProc;
		m_pCommand->CommandText=_bstr_t("del_News");
		
		_variant_t vvar1,vvar2,vvar3,vvar4;
	
		vvar1=_variant_t(NewsID);
		vvar2=_variant_t(UserID);	
		
		vvar3=_variant_t(iFlg);
		vvar4=_variant_t(_bstr_t(cMessage));

		_ParameterPtr mp_var1,mp_var2,mp_var3,mp_var4,mp_var5,mp_var6;
		mp_var1.CreateInstance(__uuidof(Parameter));
		mp_var2.CreateInstance(__uuidof(Parameter));
		mp_var3.CreateInstance(__uuidof(Parameter));
		mp_var4.CreateInstance(__uuidof(Parameter));
		
	
		mp_var1=m_pCommand->CreateParameter
		(
		_bstr_t("var1"),
		adBigInt,
		adParamInput,
		5,
		vvar1
		);
		m_pCommand->Parameters->Append(mp_var1); 

		mp_var2=m_pCommand->CreateParameter
		(
		_bstr_t("var2"),
		adBigInt,
		adParamInput,
		5,
		vvar2
		);
		m_pCommand->Parameters->Append(mp_var2); 
	
		
		mp_var3=m_pCommand->CreateParameter
		(
		_bstr_t("var3"),
		adBigInt,
		adParamOutput,
		5,
		vvar3
		);
		m_pCommand->Parameters->Append(mp_var3); 

		mp_var4=m_pCommand->CreateParameter
		(
		_bstr_t("var4"),
		adVarChar,
		adParamOutput,
		200,
		vvar4
		);
		m_pCommand->Parameters->Append(mp_var4); 


		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		m_pCommand->Execute(&vNull,&vNull,adCmdStoredProc);

		iFlg=mp_var3->Value;
		cMessage=mp_var4->Value.bstrVal;
		}
		catch(_com_error &error)
		{
			AfxMessageBox(error.ErrorMessage(),MB_OK,0);
			AfxMessageBox(error.Description(),MB_OK,0);
			AfxMessageBox("ADO错误!",MB_OK,0);
		}
}
void CNews::GetRepInf(CStringArray& RepInf)
{
	m_pCommand.CreateInstance(__uuidof(Command));
	m_pCommand->ActiveConnection=m_pConnection;
	m_pCommand->CommandText="QryRepInfor";    
	m_pCommand->CommandType=adCmdStoredProc;
	m_pCommand->Parameters->Refresh(); 


	m_pRecordset = m_pCommand->Execute(NULL,NULL,adCmdStoredProc);
	
	 while(!m_pRecordset->adoEOF)
	{   
		RepInf.Add(_T((_bstr_t)m_pRecordset->GetCollect("dsec")));
		
		m_pRecordset->MoveNext();
	}
	 for(int i=RepInf.GetSize();i<3;i++)
	{
		RepInf.Add(_T(""));	
	}

}


BOOL CNews::QryTitleExist(CString FileName)
{
	vSQL = "Select * From News where IsDelete = 0 and Title = '" + FileName + "'";
	//执行SELETE语句
	m_pRecordset = GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return false;
	else
	{
		return true;
	}
}
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -