set.inc

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

function dml_setcooperation( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE COOPERATION SET TITLE = '".$parr['title']."'";
		$sql .= " , CONTENT = '".$parr['content']."'";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$einfo = "更新错误";
		$term = false;
		break;
	}
	return $term;
}

function dml_searchcooperation( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT TITLE,CONTENT FROM COOPERATION";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "没有任何协作区数据";
			$term = false;
			$nd = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_searchboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT B.ID,B.TITLE,B.MANAGER,B.MEMBER,B.CREATE_DATE,B.END_DATE";
		$sql .= " FROM CO_BOARD B ";
		$sql .= " WHERE B.ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "没有任何版面数据";
			$term = false;
			$nd = false;
		}
		else
		{
			if ( ( $term = $edb->getrecordset( ) ) )
			{
				break;
			}
			$nd = 0;
			break;
		}
	}
	return $term;
}

function dml_boarduser( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT MANAGER,MEMBER,USER_NAME FROM BOARD_USER,USER";
		$sql .= " WHERE BOARD = '".$parr['board']."' AND TYPE = '".$parr['type']."'";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_boardinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT ID,TITLE,MANAGER,MEMBER,CREATE_DATE,END_DATE";
		$sql .= " FROM CO_BOARD WHERE ID = ".$parr['id']." AND ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
		}
		else
		{
			if ( ( $term = $edb->getrecordset( ) ) )
			{
				break;
			}
			$einfo = "没有更新任何数据";
			$term = false;
			break;
		}
	}
	return $term;
}

function dml_setboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "INSERT INTO CO_BOARD(ID,TITLE,CREATOR,MANAGER,MEMBER,CREATE_DATE, ";
		$sql .= " END_DATE,ABLE,ABLED,ABLER) VALUES(0,";
		$sql .= "'".$parr['title']."','".$parr['creator']."',";
		$sql .= " '".$parr['manager']."','".$parr['member']."',NOW(),'".$parr['end_date']."'";
		$sql .= " ,'1',NOW(),'".$parr['creator']."')";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "更新协作区错误";
			$term = false;
		}
		else
		{
			if ( ( $rows = $edb->getaffectedrows( ) ) )
			{
				break;
			}
			$rows = 0;
			$term = false;
			$einfo = "没有作任何修改,请返回";
			break;
		}
	}
	return $term;
}

function dml_modifyboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE CO_BOARD SET TITLE='".$parr['title']."',MANAGER='".$parr['manager']."'";
		$sql .= " ,MEMBER = '".$parr['member']."' WHERE ID = ".$parr['id']." AND ABLE <> 0";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$einfo = "修改协作区错误";
		$term = false;
		break;
	}
	return $term;
}

function dml_boardtopic( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT COUNT(T.ID) ID FROM CO_TOPIC T,CO_BOARD B";
		$sql .= " WHERE T.BOARD = B.ID AND B.ID = ".$parr['id']." AND T.ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
			$nd = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_delboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE CO_BOARD SET ABLE = 0 WHERE";
		$sql .= " ID = ".$parr['id']."";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "删除错误";
			$term = false;
		}
		else
		{
			if ( ( $rows = $edb->getaffectedrows( ) ) )
			{
				break;
			}
			$rows = 0;
			$term = false;
			$einfo = "没有作任何修改,请返回";
			break;
		}
	}
	return $term;
}

?>